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` = '4' and `BedroomsTotal` = '4' and ListingID!=26966035 having distance <= 11 order by distance limit 3
For more information, please click on Brochure button below. Nestled in the prestigious Upper Arrow Heights neighborhood of Revelstoke, BC, a distinctive array of eco-forward community homes embracing safe, luxurious & healthy family living. And best of all, the home will be super energy efficient. This home will provide affordable luxury while respecting the environment & limiting our carbon footprint. Responsible, luxurious & state of the art. That is Stoked living. This Caribou Townhome features 4 bedrooms, 3.5 bathrooms with a total square footage of 1900 sqft. Main floor is 660 Sqft, second floor is 620 Sqft, third floor is 620 Sqft. High quality & professional specifications & finishes included for the Kitchen: stainless steel appliance package (LG), quartz kitchen countertop, shaker panel cabinetry with matching toe kicks, 30"" high upper cabinets, matching quartz backsplash, water line to fridge. For the Bathroom: pressure balance valve on all shower and tub taps, quartz countertops, porcelain under-mount sinks, wall hung luxury toilets. Comes with a separate guest area with private entrance & a garage. This Caribou Townhome is only 1600m from the famous Revelstoke Mountain Resort, 500m from the Cabot Golf Course and only 300m from many shops and restaurant & within a short walking distance to the Arrow Heights Elementary School and many hiking, walking & biking trails. Photos are drawings & example of unit. Estimated completion date: December 2024. (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®)
