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
Single House in Yomitan will be available soon!
Single House in Awase, Okinawa city is Coming Soon!
Newer single house with garage in Ginoza is available now!
A Newer House with Garage will be available soon!
Brand new houses are coming available soon!!!
4bed2bath, US appliances hook ups.
3mins drive from Camp Courtney.
Will be ready Late Dec. to Jan. 2020!
Brand New single house is coming soon.