SELECT 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 = 7 AND p.city_id = 26 AND p.is_active = '1' AND p.bedrooms >= 8 GROUP BY p.property_id, p.source_id ORDER BY RAND(UNIX_TIMESTAMP(CURDATE())) Beaufort, SC Beaufort, SC 8+ Bedroom Vacation Rentals Search - Beaufort-SC.com
1 rentals found

Magnolia Court features a 3 bedroom Craftsman Cottage, along with a three suite townhouse comprising a total of 5 additional bedrooms, giving space...

more
  • Beaufort
  • 8 Bedrooms
  • 5 Bathrooms
  • Sleeps 14