select a.* from article a where a.type = 'House' and a.view = '0' and a.type != '' and a.type is not null and a.ddate is null group by a.article_id NEW ARRIVALS|Central Housing

CATEGORY

  • TYPE
  • SALE
  • BEDROOMS
  • RENT
    JPY
  • KEYWORD
Type
House
ID
2083
Rent
225,000 yen
Floor Plan
3Bed 2Bath
Sqft
1279
LOCATION
ISHIKAWA-URUMA

4 YEAR OLD NEWER HOUSE WITH NICE VIEW FROM BALCONY.
SHOPPING AREA AND EXPRESS WAY NEAR BY.

Click here

Type
House
ID
Big house okinawa city
Rent
550,000 yen
Floor Plan
5bed 2.5bath
Sqft
2300
LOCATION
Koja Okinawa city

Click here

Type
House
ID
2342
Rent
400,000 yen
Floor Plan
3 bed 2 bath
Sqft
1914
LOCATION
Uruma City

New Arrival in Uruma City!

Click here

Type
House
ID
1622
Rent
210,000 yen
Floor Plan
3 bed 2 bath
Sqft
1432
LOCATION
Uruma City

Click here

Type
House
ID
2346
Rent
380,000 yen
Floor Plan
Sqft
1800
LOCATION
Uruma

Brand new shingle House in Uruma-city

Click here

Type
House
ID
2350
Rent
0 yen
Floor Plan
Sqft
LOCATION
Kin town

Shingle house Kin town Comming soon!

Click here

Type
House
ID
1774
Rent
320,000 yen
Floor Plan
4BR 2BATH
Sqft
1770
LOCATION
uruma-city

Click here

Type
House
ID
890
Rent
320,000 yen
Floor Plan
3 bed 2 bath
Sqft
1521
LOCATION
Uruma City

Single house with big yard is available now!

Click here

Type
House
ID
1972
Rent
290,000 yen
Floor Plan
3 bed 2 bath
Sqft
1613
LOCATION
Yomitan

Newer Single House will be available end of September!

Click here

Type
House
ID
1750
Rent
324,000 yen
Floor Plan
3 bed 2 bath
Sqft
1448
LOCATION
Urasoe City

Single House with yard in Urasoe City is available now!
All American Hook ups, American Dishwasher is installed.

Click here

Need help? Please contact us.