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 area is available!
Nice and quiet location, nice neighbors around.
Park and Kadena school bus stop are within walking distance.
Beautiful contemporary style house with nice view coming available soon!
NO INSPECTION Place.
Let's view the house on Youtube!!!
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!!
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.
Beautiful wood work single house will be available soon!
3 bed rooms with big bonus area in up stair and 2.5 bath rooms.
All US appliances come with except for refrigerator.
Close to Alivila beach in Yomitan. Very quiet and peaceful neighborhood.
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.
There is beautiful single house by Camp Courtney avaialble!
The house just got renovated and all appliances are installed:)
!!!NO GOV. INSPECTION PROPERTY!!!
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.