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
A NEWER SINGLE HOUSE IS AVAILABLE NOW!!!
3 BEDROOM 2 BATHROOM NICE FRONT PORCH FOR BBQ, PARK AND DOG RUN NEAR BY!
Beautiful contemporary style house with nice view coming available soon!
NO INSPECTION Place!!
House with yard.
Japanese style single house is available!
15mins from Kadena
Park near by