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!=27462661 having distance <= 11 order by distance limit 3
One of two available 0.13-acre lots, this R2A-zoned property is ideally located just across the Big Eddy Bridge in Revelstoke. It offers a rare chance to own land in a highly desirable area, blending natural beauty with convenience. Just steps away, the paved Big Eddy walking path hugs the Columbia River, providing scenic strolls with stunning views of Revelstoke Mountain Resort and the Monashee Mountains. The nearby Holm Café serves local coffee, and the Big Eddy Pub offers a friendly spot to relax, both within easy walking distance. This flat, sunny lot is perfect for residential development, with utilities and municipal water ready at the lot line. Minimal site prep is required, and Development Cost Charges (DCCs) for a single-family home have already been covered. However, GST and a septic permit will still be applicable. Revelstoke is a dream destination for outdoor enthusiasts, offering world-class access to Revelstoke Mountain Resort, Mt. Macpherson’s cross-country biking trails, and Boulder Mountain’s sledding trails. The much-anticipated Cabot Golf Course is also under construction, adding even more appeal to the area. This is your opportunity to be part of a vibrant community where nature and lifestyle meet. Need more space? Combine this lot with the adjacent property and home for sale at 1765 Nixon Road! Contact the listing realtor for more details or to arrange a viewing. (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®)
