SELECT distinct Top 25 * FROM ResDatMaster Where MLSID = '#Configuration.MLSID#' AND AgentID = '#Configuration.ID#' AND ListStatus <> 'LTR' AND ListStatus <> 'Sold' order by ListPrice desc SELECT distinct Top 25 * FROM ResDatMaster Where MLSID = '#Configuration.MLSID#' AND city = '#Configuration.City#' AND ListStatus <> 'LTR' AND Protype <> 'Com' AND Protype <> 'lnd' order by ListPrice desc SELECT Distinct City FROM THCommunities Where Type = 'Community' AND MLSID = '#Configuration.MLSID#' AND City <> '' or Type = 'Community-New' AND MLSID = '#Configuration.MLSID#' AND City <> '' Order by City SELECT Distinct CommunityName,Type,City,CommunityID FROM THCommunities Where MLSID = '#Configuration.MLSID#' AND City <> '' Order By City,CommunityName SELECT distinct Top 50 * FROM THCommunities Where Type = 'City' AND MLSID = '#Configuration.MLSID#' And Photo1 <> '' AND CommunityDescription <> '' AND City <> '' or CommunityName = 'Southbridge' Order by City desc #Configuration.MetaTitle#
Slider Image  

#Configuration.CompanyName#

Greater Savannah Real Estate

image OUR FEATURED LISTINGS

#Configuration.Acro##Configuration.Tagline4c#

VIEW ALL

LATEST

image MLS FEATURED LISTINGS

#Configuration.Acro##Configuration.Tagline4d#

VIEW ALL

#Configuration.City# Real Estate For Sale

image DIRECTORIES

#Configuration.CompanyName#

 AREA PROPERTY SEARCHES

#Property.Area# | 

SELECT* FROM THAgents Where BorranID <> '1' AND BorranID <> '' And ClientID = '#Configuration.ID#' Order by Priority Desc, AgentLName, AgentFName

image TEAM

#Configuration.Acro##Configuration.Tagline4e#

#Configuration.Address# | #Configuration.city#, #Configuration.state# #Configuration.Zip#

#Configuration.phone#

SOCIAL