WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '* pi()/180) * COS(Latitude * pi()/180) * POWER(SIN(( - Longitude) * pi()/18...' at line 1]SELECT * , (3956 * 2 * ASIN(SQRT( POWER(SIN(( - Latitude) * pi()/180 / 2), 2) +COS( * pi()/180) * COS(Latitude * pi()/180) * POWER(SIN(( - Longitude) * pi()/180 / 2), 2) ))) as distance from wp_phl_property where `property_id`>0 and `Sold` != '1' and `TransactionType` = 'For sale' and `BedroomsTotal` = '3' and `BedroomsTotal` = '2' and ListingID!=27477571 having distance <= 11 order by distance limit 3
- ©MLS R2930424
- Area 1198 sq ft
- Bedrooms 3
- Bathrooms 2
- Parkings 4
Description
You'll never have to leave the beach again! 2946 O'Hara Lane, a remarkable beach front property offering 180-degree unobstructed ocean, island and mountain views. Enjoy endless sunsets from this updated 1200 sqft Pan-abode, featuring western red cedar, vaulted ceilings, and recent upgrades including the roof, windows & siding. This timeless rancher is nestled on a prime, flat and gated 6,500 sqft lot with 50ft of frontage, and no covenants or easements. A turnkey investment just awaiting your DREAM HOME ideas. Come experience all the perks that this close-nit coastal community provides! Just a short walk to Blackie spit park, the yacht club, swim club and restaurants. Minutes to Crescent Beach Marina & Nico-Wynd Golf Course. This is a rare opportunity you don't want to miss! (id:48970) Show More
Details
- Age: 58 Years
- Property Type: Single Family
- Type: House
- Architectural Style: Ranch
Ammenities + Nearby
- Air Conditioning
Features
- Mountain view
- Ocean view
- Washer
- Dryer
- Refrigerator
- Stove
- Dishwasher
- Storage Shed
- Air Conditioned
- Heat Pump
- Waterfront
Location
This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Fraser Valley Real Estate Board
