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` = '3' and ListingID!=26775350 having distance <= 11 order by distance limit 3
Discover lakeside luxury in Koocanusa Village with this stunning 4-bed, 3-bath home designed with contemporary elegance and breathtaking views of Lake Koocanusa. The heart of this home is an open plan living area: state-of-the-art kitchen with custom cabinets and quartz countertops, dining area, and cozy lounge with fireplace, connected through patio doors to a huge upper deck with BBQ and dining area--perfect for entertaining or enjoying the panoramic views. The master suite is a luxurious escape, with en suite bathroom, walk-in closet, and access to the sunny deck. The lower level has two spacious bedrooms, a full bathroom, and large den with wet bar that leads out to the lower deck. The deck features a hot tub, seating area with fire table and hideaway TV, making it an ideal spot for gatherings. A fully equipped gym, laundry and mechanical room add to the functional layout, and the attached heated double garage with 10' high door is perfect for storing your surf boat. There's a high-efficiency furnace, on-demand hot water, zoned heating, and built-in speaker system that fills the house and patio with sound. Smart home features like WiFi-enabled thermostat, remote-controlled window blinds, and Starlink internet ensure comfort and connectivity. The property also boasts underground irrigation, Pixel Light outdoor lighting, and central vac. Experience the best of modern design and natural beauty at Lakeview Terrace - schedule a viewing today and start making memories in this gorgeous lakeside retreat. (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®)
