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
2103
Rent
220,000 yen
Floor Plan
3 BEDROOM 2 BATHROOM
Sqft
1180
LOCATION
YOMITAN Zakimi

A NEWER SINGLE HOUSE IS AVAILABLE NOW!!!
3 BEDROOM 2 BATHROOM NICE FRONT PORCH FOR BBQ, PARK AND DOG RUN NEAR BY!

Click here

Type
House
ID
2209
Rent
460,000 yen
Floor Plan
3bedrooms 2bathrooms
Sqft
2000
LOCATION
Yomitan

Beautiful contemporary style house with nice view coming available soon!
NO INSPECTION Place!!

Click here

Type
House
ID
2278
Rent
250,000 yen
Floor Plan
2BR/1Bath Tatami mats
Sqft
LOCATION
Uruma-city

House with yard.

Click here

Type
House
ID
1321
Rent
397,000 yen
Floor Plan
4bed 2bath
Sqft
2284
LOCATION
Kin-town

Click here

Type
House
ID
2170
Rent
240,000 yen
Floor Plan
4bed2bath rooms
Sqft
1461
LOCATION
Okinawa City

Japanese style single house is available!
15mins from Kadena
Park near by

Click here

Type
House
ID
565
Rent
210,000 yen
Floor Plan
2bed 2bath rooms
Sqft
1303
LOCATION
Urum City Ishikawa

Click here

Type
House
ID
917
Rent
162,000 yen
Floor Plan
2bed 2bath rooms
Sqft
1010
LOCATION
Uruma city Enobi

Click here

Need help? Please contact us.