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 ') AND
`pixilink_mlsr`.`mlsr_listings`.`status` = 'Active' AND
`pixilink_mlsr' at line 6
SELECT
COUNT(*) as count
FROM
mlsr_listings
WHERE
`pixilink_mlsr`.`mlsr_listings`.`building_id` IN () AND
`pixilink_mlsr`.`mlsr_listings`.`status` = 'Active' AND
`pixilink_mlsr`.`mlsr_listings`.`reciprocity` = 'Yes'
- HOME
- ABOUT US
- BUYERS
- Our Listings
- What we will do for you
- Cost of Buying a Home
- Once you have bought
- Buying an Assignment
- Mortgage Brokers
- Tips for Buyers & First Time Home Buyers Important Information
- Useful Real Estate Links
- Schedule an Appointment
- Assignments for Sale (Downtown) - PDF Spreadsheet
- Assignment Websites, Information Sheets & Contracts
- Non Residents Buying in Canada
- Non Residents Info For Buyers And Sellers
- School Information
- PTT - Property Transfer Tax - First Time Home Buyers Program General Info
- MyStrataCorp Document Services
- Sample Marketing ads
- Vancouver Online Floor Plan Service
- Free Property Evaluation Sign Up
- Signup For Bldg Sale Info, Posting of Rentals & Bldg Strata Minutes
- MLS® Condo Search Downtown
- MLS® House Search Map Base
- SELLERS
- Our Listings
- Les & Sonja's Guarantee
- Preparing your Home
- Tips for Sellers
- Commission Rates
- Mortgage Brokers
- Business Sale Info Needed
- Assignments for Sale (Downtown) - PDF Spreadsheet
- Assignment Websites, Information Sheets & Contracts
- RE/MAX Office Market Share
- Useful Real Estate Links
- Schedule an Appointment
- Info for Non Residents Buying or Selling
- School Information
- Sample Marketing Ads
- Vancouver Online Floor Plan Service
- Free Property Evaluation Sign Up
- Signup For Bldg Sale Info, Posting of Rentals & Bldg Strata Minutes
- RESOURCES
- Professionals / Lawyers / Notaries / Accountants etc.
- Home Services Directory (recommended contractors)
- Mortgage Brokers incl. Applications & Calculator
- Useful Real Estate Links
- Contracts & Forms
- Special Reports
- Web Hits & Users Main Page
- Communities & Neighbourhoods
- Cabo Rental at El Zalate, Mx.
- Vancouver Online Floor Plan Service
- Vancouver Strata Plans
- Free Property Evaluation Sign Up
- Sale Info & Posting of Rentals Sign Up
- LISTINGS
- MAPS & FLOOR PLANS
- Main Map Page - Links of All Maps incl Other Areas and Directories
- MAP 1 - Concord Pacific, Downtown & Yaletown Area
- MAP 2 - Coal Harbour, Bayshore Area & Part of Westend
- MAP 3 - E Coal Harbour, Gastown, Citygate, Olympic Village, & North False Creek
- MAP 4 - South False Creek, Fairview & Pennyfarthing Area
- MAP 5 - Mount Pleasant Area, Main Street Corridor & Olympic Village
- MAP 6 - Vancouver West End
- MAP 7 - Kitsilano
- MAP 15 - Cabo San Lucas - Mexico
- MAP 10 - Out OF Area Buildings
- Vancouver Online Floor Plan Service
- Free Property Evaluation Sign Up
- Sale Info & Posting of Rentals Sign Up
- CONTACT US