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
Sinle house in SeaLake Zakimi coming available soon!
Nice and quiet location, nice neighbors around.
Park and Kadena school bus stop are within walking distance.
AVAILABLE NOW!!
Nice large house coming available soon!
4 bedroom 2 bathroom, 2 car garage, the located right by Maxalue/StarBucksCoffee in Furugen area, and beach near by.
5mins drive to Tori Station and 15mins. drive to Kadena Air Base.
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!!!
House near by KAB Gate 3 coming available soon!
Single house in Uruma area is coming soon!
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 refrigerator and U.S kitchen stove/oven.
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!!
4 bedrooms ingle story house will be ready in Feb.
Single house with big roof top balcony is available now!
Located on the hill side with good view:)
Brand new houses are NOW opening!!!
4bed2bath, US appliances hook ups.
3mins drive from Camp Courtney.
Rent is negotiable, free to ask!!
Beautiful American style single house with yard is available in Uruma City. 3 car parking spaces.US appliances are installed.
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.
!!!NO GOV. INSPECTION PROPERTY!!!
Kadena Hsg inspection won't be done til Jan. 2021!!!
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.
Brandnew house in Uruma area, 15mins drive from Courtney.
Nice modern style!
A beautiful house with garage in a quiet location away from busy streets AVAILABLE NOW!!
Single house just renovated is available!
Walking distance to Seven-Eleven,Supermarkets and restaurants.
15mins drive from Kadena Air Base.
A very nice cozy family home with 4Bedrooms/2.5Bath is available now!
The located in Senaha, Yomitan area, close to the ocean!
House with ocean view coming available soon!