Spring Island Real Estate

Refine Search
   Reset


Premier Island Properties

Wayne McDonald
Wayne M. McDonald
Your Lowcountry Real Estate Expert


Homes on Spring Island

select p.Matrix_Unique_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.Matrix_Unique_ID>0 AND (PropertyType='Residential-Single Fam' OR PropertyType='Villas/Condos' OR PropertyType='Land/Lots') AND Area='Spring Island' AND Status='Active' AND Area='Spring Island' GROUP BY p.MLSNumber ORDER BY po.sort_order ASC LIMIT 0, 24