SELECT *, uf.id_prop AS star, STR_TO_DATE(date, '%M %d %Y') as latest, IF(COUNT( DISTINCT rent ) > 1,CONCAT('$', MIN(rent), ' - $', MAX(rent)),CONCAT('$', rent)) as rent, IF(COUNT( DISTINCT beds ) > 1,CONCAT(MIN(beds), ' - ', MAX(beds)),beds) as beds FROM properties AS p INNER JOIN prop_units AS u ON u.id_prop = p.id_pg LEFT JOIN prop_photos c ON p.id_pg = c.id_prop AND c.p_order = 1 INNER JOIN user_fav uf ON p.id_pg = uf.id_prop AND uf.id_session = '5fbbddbc3357b4.34915659' GROUP BY p.id_pg Faves

Saved Searches 0

You have no saved searches yet. Click the star icon by "Save this Search" on the listing page.

Saved Properties 0

You have no properties saved yet. Click the star icon located by the property title on the listing page.
Promote for FREE, use coupon code "BEST"