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
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!!
Brand New single house is coming soon.
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!!!