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` = '3' and `BedroomsTotal` = '3' and ListingID!=26481465 having distance <= 11 order by distance limit 3
- ©MLS 2474803
- Area 2073 sq ft
- Bedrooms 3
- Bathrooms 3
Description
New build modern home located in the Redstone Neighbourhood! 3 generous bedrooms + flex room, 2.5 bathrooms, 2 car garage with EV charger, office, front deck and Nordic inspired open living plan with high ceilings. Modern and bright design throughout with large windows, engineered wood floors, natural gas linear fireplace, and a big kitchen island. Close to epic mountain bike trails, golfing, x-c ski trails and snowshoeing. Estimated completion is December 2024. Comes with a new home warranty. This property should be on the short list for the family coming to Rossland. (id:48970) Show More
Details
- Constructed Date: 2024
- Property Type: Single Family
- Type: House
- Construction Material: Wood frame
- Community: Rossland
Features
- Forced air
Location
This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Kootenay Real Estate Board