Refine Search
Premier Island Properties
Wayne M. McDonald
Your Lowcountry
Real Estate Expert
Homes in Palmetto Dunes
select p.ID, p.View, p.Status, p.LegalNumber, p.LegalAddress, p.MLSNumber, p.StreetNumber, p.StreetName, p.StreetSuffix, p.BedsTotal, p.BathsFull, p.BathsHalf, p.ListOfficeName, p.ListPrice, po.sort_order
FROM properties p
LEFT OUTER JOIN properties_order po ON p.MLSNumber = po.MLSNumber
WHERE p.ID>0 AND (PropertyType!='' AND PropertyType!='Fractional' AND PropertyType!='Timeshare')
AND Area='Palmetto Dunes/Shelter Cove' AND Status='Active' AND Area='Palmetto Dunes/Shelter Cove' AND ListPrice < '0' GROUP BY p.MLSNumber ORDER BY po.sort_order ASC LIMIT 168, 24