Spring Island Real Estate

Refine Search

Premier Island Properties

Wayne McDonald
Wayne M. McDonald
Your Lowcountry Real Estate Expert

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