Checkout more related properties for rent and for sale.
SELECT p.*, MIN(pi.id) as image_id, pi.local_url
FROM
wp_data_reaxml_properties p
JOIN
wp_data_property_images pi ON pi.property_id = p.id
WHERE
p.status != 'sold' AND p.status != 'leased' and p.status != 'withdrawn'
AND
CAST(p.price AS DECIMAL) >= 0
AND
CAST(p.price AS DECIMAL) <= 0
AND
p.id!=
GROUP
BY p.id
ORDER
BY p.id
LIMIT 3
