| |
 |
Vancouver East > Champlain Heights |
|
|
|
mlsSearch.inc(217) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-25, 25' at line 1select listingid, listingtype, thumbnailurl, mainpicurl, streetaddress, postalcode, city, subarea, listprice, bedrooms, bathstotal, remarks, livingarea, reoffice, agent_id, agent2_id, agent3_id, virtualtoururl from mlsr_listings where reciprocity='Yes' and status = 'Active' and listingtype IN ('House with Acreage','House/Single Family') AND subarea NOT IN ('Grandview VE', 'Downtown VW', 'Downtown VE', 'Yaletown', 'Coal Harbour', 'West End VW') and city = 'Vancouver' and area = 'Vancouver East' and bedrooms >= 0 and bathstotal >= 0 and subarea like '%champlain heights%' order by listprice_2 desc limit -25, 25 | | | | |
