SELECT * FROM ResDatMaster Where MLSID = '#Configuration.MLSID#' AND AgentID = '#Configuration.ID#' AND ListStatus <> 'Sold' AND ListStatus <> 'LTR' order by ListPrice desc SELECT distinct Top 50 * FROM ResDatMaster Where MLSID = '#Configuration.MLSID#' AND city = '#Configuration.City#' AND ListStatus <> 'Sold' order by ListPrice desc SELECT Distinct City FROM THCommunities Where Type = 'Building' AND MLSID = '#Configuration.MLSID#' AND City <> '' or Type = 'Building-New' AND MLSID = '#Configuration.MLSID#' AND City <> '' Order by City 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 25 Photo1,CommunityName,CommunityID,City,Latitude,Longitude FROM THCommunities Where Type = 'Building' AND MLSID = '#Configuration.MLSID#' And Photo1 <> '' AND CommunityDescription <> '' AND City <> '' Order by CommunityName #Configuration.MetaTitle#
Slider Image  

#Configuration.CompanyName#

#Configuration.City# 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

Everything In Its Place...

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

image TEAM

#Configuration.Acro##Configuration.Tagline4e#

NETWORK

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

#Configuration.phone#

SOCIAL