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
4 YEAR OLD NEWER HOUSE WITH NICE VIEW FROM BALCONY.
SHOPPING AREA AND EXPRESS WAY NEAR BY.
New Arrival in Uruma City!
Brand new shingle House in Uruma-city
Shingle house Kin town Comming soon!
Single house with big yard is available now!
Newer Single House will be available end of September!
Single House with yard in Urasoe City is available now!
All American Hook ups, American Dishwasher is installed.