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
1865
Rent
260,000 yen
Floor Plan
3Bed2Bath
Sqft
1419
LOCATION
Kin cho

Fairy new single house located 15min. drive access to Camp Hansen.
With yard, all American appliances hook ups.
Will be available soon!!

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
2072
Rent
380,000 yen
Floor Plan
4bed 2.5 bath rooms
Sqft
1975
LOCATION
Uruma City

Big House in Uruma City is available now.

Click here

Type
House
ID
821
Rent
370,000 yen
Floor Plan
3 bed 2 bath
Sqft
1944
LOCATION
Onna Village

Click here

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

New Arrival in Uruma City!

Click here

Type
House
ID
2336
Rent
280,000 yen
Floor Plan
3bed/1.5ath/garage
Sqft
1330
LOCATION
Yomitan-son

Big yard

Click here

Need help? Please contact us.