Hilton Head Lakes Real Estate

Homes in Hilton Head Lakes

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.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='Hilton Head Lakes' AND Status='Active' AND Area='Hilton Head Lakes' AND ListPrice < '0' GROUP BY p.MLSNumber ORDER BY po.sort_order ASC LIMIT 0, 24