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` = '5' and `BedroomsTotal` = '4' and ListingID!=27473368 having distance <= 11 order by distance limit 3
- ©MLS 10325147
- Area 3346 sq ft
- Bedrooms 5
- Bathrooms 4
- Parkings 6
Description
For more information, please click on Brochure button below. Nestled in the prestigious Upper Arrow Heights neighbourhood of Revelstoke, BC, a distinctive array of eco-forward community homes embracing safe, luxurious and healthy family living. And best of all, our home will be super energy efficient. This home will provide affordable luxury while respecting the environment and limiting our carbon footprint. Responsible, luxurious and state of the art. That is stoked living. We know that living your best life involves spending quality time outdoors. That's why we created great outdoor spaces, added not one but two parks to the neighbourhood and are providing a street that is friendly and usable by anyone with two, or four feet! With back lanes and additional visitor parking we give space for visitors but get cars out of the way. We want to see kids riding bikes, playing road hockey, people walking dogs and the kind of neighbourhood that fits Revelstoke best. Home is environmentally friendly and energy-efficient. The Bison Plus is the perfect example of this! We're using the latest sustainable technologies and following Step Code 5 standards to ensure this home is as green as possible. This means, your home is Net-Zero ready. This home is only 1600 meters from the famous Revelstoke Mountain Resort, 500 meters from the Cabot Golf Course and only 300 meters from many shops and restaurants. Estimated completion date spring 2025. Some photos are examples of rendering drawings. (id:48970) Show More
Details
- Constructed Date: 2024
- Property Type: Single Family
- Type: House
- Access Type: Easy access
- Architectural Style: Split level entry
- Neighbourhood: Revelstoke
Ammenities + Nearby
- Golf Nearby
- Public Transit
- Airport
- Park
- Recreation
- Schools
- Shopping
- Ski area
- Golf Nearby
- Public Transit
- Airport
- Park
- Recreation
- Schools
- Shopping
- Ski area
Features
- Level lot
- Private setting
- Family Oriented
- Rentals Allowed
- Mountain view
- Valley view
- View (panoramic)
- Heat Pump
- Controlled entry
- Smoke Detector Only
- Baseboard heaters
- Forced air
- Heat Pump
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