SQL: SELECT * FROM Listings WHERE (Active='Y') AND (AddDate > '2026-10-13 00:00:00') AND (PropertyType = 'Single Family')



![]() |
$1,588,000
3612 KELLY AVENUE, BELCARRA
3 Bedrooms, 3 Bathrooms, 3178 sqft
Exceptional value in Belcarra! Located beautifully landscaped gardens with sweeping ocean views, this stunning executive family home overlooks a sparkling swimming pool with picturesque mountain vistas and ocean beyond. Expansive outdoor living spaces include generous decks ideal for summer entertaining, a resort-style pool area with stamped concrete, pool shed, hot tub pad area, and a tranquil waterfall feature. Inside features open-concept design is filled with natural light from expansive win ... Click for more details
Call Captain Vancouver at (604) YOUR KEY |
R3142681
Listing by Axford Real Estate
|
| # | MLS® | Address | City | Price | Beds | Baths | Year | SqFt | Land |
|---|---|---|---|---|---|---|---|---|---|
| 1 | R3142681 | 3612 KELLY AVENUE | Belcarra | $1,588,000 | 3 | 3 | 1967 | 3178 | 7850 |