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
A SINGLE HOUSE WITH GARAGE COMING AVAILABLE!
Beautiful contemporary style house with nice view coming available soon!
NO INSPECTION Place.
Let's view the house on Youtube!!!
Single house in Uruma area is available!
Huge living room and beautiful view!
Located 20min. drive from KAB, 15min. drive from Courtney/White Beach.
Quiet location but only 5min. drive to stores and restaurants area.
4-5 cars big covered parking and storage shed comes with.
Japanese gas dryer/washer are installed
Hook up for US kitchen stove and friige
Feel free to ask:)
Big single house close by Camp Courtney is available.
Walking distance to Konbu beach, quiet residential location.
3 stories single house in Sealake Zakimi area is available.
Very nice and quiet residential community. Kadena school bus stop and park are in the community. Great environment for families!!
Single house with Ocean view is available.
Quiet area, 10-15mins. drive from Kadena Gate2.
Brand new houses are NOW opening!!!
4bed2bath, US appliances hook ups.
3mins drive from Camp Courtney.
Rent is negotiable, free to ask!!
The house is located in walking distance to super markets, park, etc.
Spacious living and dining room plus 2 car garage. There is a big roof top balcony. All US appliances are installed.
Very nice community and convenient for living.
View the property on Youtube!!!
The house in Okinawa-city coming available soon!!
The property is located in a very convenient area in Kin-town 5 minutes drive from Camp Hansen available now!
3Bed rooms plus Office room with 2.5 bath/yard available. And location is by Okinawa Comprehensive Park.
Walking distance to ocean and convenience store and restaurants!
Beautiful house with yard and view is available now!
Car port and spaciouse parking space can store 4 cars easily and very privacy location.
Kitchen stove is replaced to US stove. Wifi is included.
Still preparing for GOV. inspection.
There is a huge single house with big yard and garage by EM hotel.
5Mins. drive to Rycom Shopping Mall/ 10mins. drive to Camp Foster.
Single house with yard where is located close to Camp Hansen.
Newly Japanese style house! All Japanese appliances are installed.
2 cars parking space.
There is good size sinle house available in Awase Okinawa City.
15mins drive to Kadena Air Base. Close to grocer and restaurants, convenient locaion!
Newly built single house is going to be available soon!
All Japanese appliances are installed. 20mins drive from Kadena Air Base, there is a convenience store in walking distance from the property.
Brand new single house is available in 10mins drive from Camp Courtney!
A beautiful single house with yard in sealake Zakimi area is available now! Very quiet location and Kadena school bus stop is within walking distance. US hook up for kitchen stove/washer/fridge.
Comtenporary single house is coming available in late Dec.
3bed2bath with car port. Very quiet area.
Brand new siingle house located close to Hansen.
In a very quiet area. One story modern style single house.
Brandnew house in Uruma area, 15mins drive from Courtney.
Nice modern style!
Single house just renovated is available!
Walking distance to Seven-Eleven,Supermarkets and restaurants.
15mins drive from Kadena Air Base.
House with ocean view/garage is available now!!!
All one floor 5bed rooms single house with garage and huge yard is coming up soon!!! However NO GOV INSPECTION!!!
US appliances are provided.
You can make appointment for viewing, please feel free to contact us:)
Beautiful sapcious single house in Urasoe City available!
US gas stove and diswasher installed. No Gov. inspection.
Good access to Camp Kinser, Naha Air Port.
Location in 15-20mins drive from Kadena Air Base.
Big single house with 2cars garage!