Berkeley Hall Real Estate

Refine Search
   Reset


Premier Island Properties

Wayne McDonald
Wayne M. McDonald
Your Lowcountry Real Estate Expert


Homes in Berkeley Hall
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, p.City, p.StateOrProvince, p.PostalCode 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='Berkeley Hall' AND Status='Active' AND Area='Berkeley Hall' AND ListPrice < '0' GROUP BY p.MLSNumber ORDER BY po.sort_order ASC LIMIT 0, 24