Spring Island Real Estate

Refine Search
   Reset


Premier Island Properties

Wayne McDonald
Wayne M. McDonald
Your Lowcountry Real Estate Expert


Homes on Spring Island
Wooded
Property photo
MLS
21 Little Neck Crossing
 Lot for Sale
 
$160,000
Wooded
Property
MLS
21 Straight Rd
5 Beds / Baths
 
$2,200,000

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