Error in loadingSELECT sysID, listingID, address, listingStatus, folder, frontstill, listingAgent, unitNumber, city, buildingName, addressDisplay, price, pricetext, bedrooms, remarks, firmname1, realtor, listingAgent2, firmname2, listingagent3, firmname3 FROM mls_properties where (listingStatus is null or listingStatus = 'Sold' or listingStatus = 'Pending' or listingStatus = 'Active') and internetDisplay in ('Yes') and brokerRecipFlag in ('Yes') and (firmName1 = 'Royal LePage ArTeam Realty') AND (realtor <> 'Designer Junkies' OR realtor IS NULL) order by listingStatus, sortorder desc, price asc
Royal LePage - ArTeam Realty
