This site is currently down for maintenance. Please try again later.

 

SELECT WebStyles.CSSURL, WebStyles.SWFName, BrokerDynamixSites.BrokerID, BrokerDynamixSites.Offline AS OffLine, BrokerDynamixSites.BrokerShortName, BrokerDynamixSites.TrackingCode, BrokerDynamixSites.ForceRegOnPage, BrokerDynamixSites.AdvSearch, BrokerDynamixSites.AdvSearch_Forclosure, BrokerDynamixSites.AdvSearch_ShortSale, BrokerDynamixSites.AdvSearch_WaterFront, BrokerDynamixSites.AdvSearch_WaterView, BrokerDynamixSites.AdvSearch_NewConstruction , BrokerDynamixSites.AdvSearch_ForRent, BrokerDynamixSites.AdvSearch_GolfCourse, BrokerDynamixSites.AdvSearch_Pool, BrokerDynamixSites.AdvSearch_Schools, BrokerDynamixSites.GoogleMapAPIKey, BrokerDynamixSites.CallToAction, BrokerDynamixSites.CallToActionHTML , BrokerDynamixSites.Tab_Map, BrokerDynamixSites.Tab_Valuation, BrokerDynamixSites.Tab_Finance, BrokerDynamixSites.Tab_Comps, BrokerDynamixSites.Tab_Neighborhood, BrokerDynamixSites.Tab_Schools, BrokerDynamixSites.Tab_WalkScore, BrokerDynamixSites.Tab_Media , BrokerDynamixSites.Tab_TearSheet , BrokerDynamixSites.MobileSiteActive , BrokerDynamixSites.ShowPopularity , BrokerDynamixSites.ShowRSS , BrokerDynamixSites.RSSFeedSize , BrokerDynamixSites.ShowingTime , BrokerDynamixSites.ST_SiteID , BrokerDynamixSites.ST_ListingBrokerName , BrokerDynamixSites.ST_MLSID , BrokerDynamixSites.AdBox1Active , BrokerDynamixSites.AdBox1HTML , BrokerDynamixSites.AdBox2Active , BrokerDynamixSites.AdBox2HTML , BrokerDynamixSites.ListingArchiveActive , BrokerDynamixSites.SingleCitySite , BrokerDynamixSites.SingleCityName , BrokerDynamixSites.SingleCityState , Brokers.Active as BrokerActive, Brokers.BDA800Number, Brokers.AgentSystemActive, Brokers.EmailSystemActive, Brokers.PreferedLenderActive, Brokers.BrokerName, Brokers.BrokerLogoURL, Brokers.EmailLeadsToBroker, Brokers.EmailLeadToAddress, Brokers.ClientSupportEmail, Brokers.SupportPhone, MLSInfo.ListingsPerPage AS ListingsPerPage, MLSInfo.RecordsPerSearch AS RecordsPerSearch, MLSInfo.SEOBoostActive AS SEOBoostActive, MLSInfo.RecipLogoURL As RecipLogoURL, MLSInfo.CopyrightText as MLSCopyrightText, MLSInfo.AccuracyDisclaimer AS MLSAccuracyDisclaimer, MLSInfo.MLSName AS MSLName FROM BrokerDynamixSites INNER JOIN Brokers ON BrokerDynamixSites.BrokerID = Brokers.BrokerID INNER JOIN WebStyles ON BrokerDynamixSites.CSSID = WebStyles.CSSID INNER JOIN MLSInfo ON Brokers.BrokerID = MLSInfo.BrokerID WHERE (BrokerDynamixSites.SiteURL = 'www.virginiahomesinmls.com')