Nat Dhaliwal Realtor® 604-572-1211
home about us featured properties sold buyers and sellers testimonials contact us
Realtor ® Nat Dhaliwal superimposed over English Bay Vancouver Skyline
 

  North Vancouver Houses > Roche Point


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 '-20, 20' 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 city = 'North Vancouver' and class="1" and bedrooms >= 0 and bathstotal >= 0 and subarea like '%roche point%' order by listprice_2 asc limit -20, 20