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!!
Newer Single home 10 min. to Kadena Air Base. It's available now!
Big 5 Bed room is available now!
House with yard.
Japanese style single house is available!
15mins from Kadena
Park near by
Single House with garage is coming available !
20mins drive from Courtney
Single house with Ocean view is available.
Quiet area, Good for family