select a.* from article a where a.type = 'Apartment' and a.view = '0' and a.type != '' and a.type is not null and a.ddate is null group by a.article_id
Beautiful ocean view apt. will come up soon!
Big American style kitchen, hot stone room in master shower room.
Located on 329, 15min. drive access to Hansen.
Apartment in Chatan, great location!
Only 5 minutes from Kadena and 8 minutes from Camp Foster
Beautiful apt with view close to Futenma and Foster location is available now!
All American appliances installed and very good quality!
This apartment located in Kitanakagusuku area, Rycom Aeon Mall near by!!
Nice view and all appliances are installed.
2 cars parking.
Apartment in Chatan s coming available.
Araha Beach front apt is opening soon!
Walking distance to everything you need!!!
5mins drive from Foster & 10mins drive from KAB.
Try viewing property on Youtube!!!
Great ocean View apartment is available now!
All utilities are included in rent 500,000 JPY and it's negotiable!
Brand new apartment is coming available soon.
Brand new Beach view apt is coming soon!!!
Quiet peaceful location but close to convenience store and restaurants.
10mins drive to Camp Hansen.
Will be ready to move in end of Feb.
Beautiful and modernn 2bed rooms condo is available!
Move-in ready now.
Let's do home viewing on Youtube!!
Big sqft with ocean view apt is available now!
Each unit has very spacious storage, 2 cars parking spots comes with.
The rent includes all utilities by owner.
Let's view property on Youtube!!