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
160000.00
Per Shitje
45000.00
Per Shitje
50000.00
Per Shitje
160000.00
Per Shitje
300000.00
Per Shitje
120000.00
Per Shitje
170000.00
Per Shitje
682000.00
Per Shitje
70000.00
Per Shitje
715000.00
Per Shitje
