SOLD THE KEYSTONE SOLD IN PITT MEADOWS
Listed By: RE/MAX Sabre Realty Group
"Keystone" -- Built by Bosa. Nearly new corner unit, bright & spacious with 9 ft ceiling. Open kitchen with granite countertop, s/s appliances, and breakfast bar. Massive patio and walking distance to shops, recreation, and West Coast Express.
# #306 - 12350 Harris Rd, Pitt Meadows
| PRICE: $289,900 | BEDROOMS: 2 | TAXES(2010): $2,350 | MNT. FEE: $268 |
| SIZE: 1,163 Sq.Ft. | BATHROOMS: 2 | YEAR BUILT: 2007 | PARKING: 2 |
| MLS: V879595 | TYPE: Apartment Unit | SUBAREA: Mid Meadows | $/SqFt $249 |
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 agents.active = 'y'' at line 4select * from agents
join agent_sites on (agents.id = agent_sites.agent_id)
where agent_sites.site_id = 2
and agents.id = and agents.active = 'y'