select a.* from article a where a.type = 'Duplex' and a.view = '0' and a.type != '' and a.type is not null and a.ddate is null group by a.article_id
Beautiful multiplex coming up soon!
Located in 5 min. drive from Kadena Gate3,
Close to base and with one car garage and 2 cars parking space outside.
Spacious and good view duplex is opening soon!
15min. drive location from Kadena Gate 2, 5min. drive from Rycom Shopping Mall.
Brand new side by side duplex with HUGE car port and balcony.
20mins drive from Kadena Gate2, all US appliances hook ups.
View the property on Youtube!!
Renovated duplex in Sunabe location is coming soon!
Spacious 3bed 2bath with 2 car parking space.
5mins. drive from Kadena Gate1.
Will be ready to move in June.