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!=27737178 having distance <= 11 order by distance limit 3
For more info, please click Brochure button. 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. We are also offering a matching Solar Package so that you can make utility bills a thing of the past! 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. (id:48970) Show More
The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. The trademark DDF® is owned by The Canadian Real Estate Association (CREA) and identifies CREA's Data Distribution Facility (DDF®)
