SOLD THE ALINA LOFT BUILDING IN NORTH VAN
Listed By: TRG Downtown Realty
Alina living offers a modern lifestyle at an affordable price. This boutique style residence offers a Central Lonsdale location, tastefully appointed features, and expansive ocean and city views! Unique and bright 1 bedroom penthouse loft, is carefully deliberated to create a truly livable space. In addition this exceptional home features three balconies, 16ft living room ceilings, hardwood floors, fireplace, stainless appliances with gas stove cooktop, granite counters, and more. Parking stall #25. Storage locker #41. Pets and rentals ok.
# PH2 1288 CHESTERFIELD AV, NORTH VANCOUVER
| PRICE: $399,900 | BEDROOMS: 1 | TAXES(2010): $1,700 | MNT. FEE: $223 |
| SIZE: 634 Sq.Ft. | BATHROOMS: 2 | YEAR BUILT: 2009 | PARKING: 1 |
| MLS: V882185 | TYPE: Apartment Unit | SUBAREA: Central Lonsdale | $/SqFt $631 |
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 1select * 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'