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
Brand new houses are NOW opening!!!
4bed2bath, US appliances hook ups.
3mins drive from Camp Courtney.
Pet Friendly and Once a month cleaning service is included!
Brand New single house is coming soon.
Beautiful brandnew houses in Takahara Okinawa City are coming available in April!
15mins drive from Kadena AirBase.
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.