SELECT DISTINCT p.property_id, p.source_id
FROM properties p
LEFT JOIN cities_sites_xref csx ON p.city_id = csx.city_id
LEFT JOIN sources_sites_xref ssx ON csx.site_id = ssx.site_id
LEFT JOIN sources s ON ssx.source_id = s.source_id AND p.source_id = s.source_id
WHERE s.is_active = '1'
AND csx.site_id = 23 AND p.city_id = 3 AND p.is_active = '1' AND p.bedrooms >= 4 AND p.source_id = 7
ORDER BY RAND(UNIX_TIMESTAMP(CURDATE()))
Kitty Hawk Duck, NC 4+ Bedroom Vacation Rentals by Sun Realty Search - Kitty-Hawk.com
Duck, NC 4+ Bedroom Vacation Rentals by Sun Realty
