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 ListingID!=27766386 having distance <= 11 order by distance limit 3
- ©MLS 10330986
Description
INTRODUCING The Sevens a prime multifamily development opportunity in Golden, B.C. The development offers a fully envisioned 34 townhouse project with all permits approved and substantial earthworks and in-ground services already started. Located in the heart of the Rockies, this site provides stunning mountain views of Mount Seven as you look across the Columbia Valley at the Dogtooth mountain range. Easy access to outdoor hiking trails, skiing, and other forms of outdoor recreation is a must, and you can't get closer than this! With Golden's growing market demand, this project is perfectly positioned for developers to capitalize on the area's increasing popularity. Don't miss the chance to bring this master-planned community to life and secure a valuable investment in one of British Columbia's most sought-after destinations. (id:48970) Show More
Details
- Constructed Date: 2023
- Property Type: Multi-family
- Type: Multi-Family
- Neighbourhood: Golden
Features
- Mountain view
- Valley view
- No heat
Location
This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Okanagan-Mainline Real Estate Board