Immobiliare Sorrento
Search for Real Estate Ads
Real Estate category
(0) Villas L (0) Villas on hills
L (0) Villas to the sea
(4) Apartments L (1) Apartments to the sea
L (0) Apartments in center
L (3) Apartments on hills
L (4) B&B in center
L (0) B&B to the sea
L (2) 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
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=204 and c.published LIMIT 1
$row->ad_headline
$row->ad_headline
$row->ad_text
Price: $ $row->ad_price
