Immobiliare Procida
Search for Real Estate Ads
Real Estate category
(0) Villas L (0) Villas on hills
L (0) Villas to the sea
(2) Apartments L (2) Apartments to the sea
L (0) Apartments in center
L (0) Apartments on hills
(0) Bed and Breakfast L (0) B&B in center
L (0) B&B to the sea
L (0) B&B on hills
(0) Lands L (0) Forests
L (0) Cultivated lands
L (0) Lands with ruin
(0) Palace (0) Mansard (0) Hotel (0) Open space (0) Stores (0) RestaurantsFree Ads board
- vendesi immobile ( / Immobili in vendita a procida) Tuesday, 15 November 2011
SELECT DISTINCT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid, u.username as user FROM #__adsmanager_ads as a LEFT JOIN #__adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN #__users as u ON a.userid = u.id LEFT JOIN #__adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN #__adsmanager_categories as p ON c.parent = p.id WHERE a.id=54 and c.published LIMIT 1
$row->ad_headline
$row->ad_headline
$row->ad_text
Price: $ $row->ad_price
