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
Fairy new single house located 15min. drive access to Camp Hansen.
With yard, all American appliances hook ups.
Will be available soon!!
Big House in Uruma City is available now.
New Arrival in Uruma City!