SELECT r.GrossArea,r.LandArea, r.Bathrooms, r.Rooms, r.InteriorRooms, r.Name ,r.Views, r.Exclusive, r.Reference, r.RealestateStatusIDName,r.GPSLat, r.GPSLon, r.ID, r.NettArea, r.Description,r.BrokerID,r.LocationIDName, rb.BusinessTypeIDName, rb.Price ,r.HasPriceUnderAppreciation,r.ExportAddress, r.ExportGeoreference, m.Format, m.UID,ed.PersonalContactEmailSearch,rb.CurrencyIDName, ed.PersonalContactPhoneSearch
FROM realestate r
INNER JOIN realestate_portal rp
ON r.ID = rp.RealestateID AND rp.PortalIDName = 'Web Page'
INNER JOIN realestate_business_type rb
ON rb.RealEstateID = r.ID
LEFT JOIN media m
ON m.ID = r.FirstMediaID
LEFT JOIN entity_data ed
ON ed.EntityID = r.BrokerID
where 1=1 AND ((rb.BusinessTypeIDName IN ('For sale') )) AND r.RealestateStatusIDName != 'Withdrawn' ORDER BY r.CreateDate DESC LIMIT 0 , 16
1500000.00
Per Shitje
370000.00
Per Shitje
320000.00
Per Shitje
140000.00
Per Shitje
53000.00
Per Shitje
44000.00
Per Shitje
160000.00
Per Shitje
68000.00
Per Shitje
217800.00
Per Shitje
132000.00
Per Shitje
100000.00
Per Shitje
580000.00
Per Shitje
