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` = '7' and `BedroomsTotal` = '5' and ListingID!=27512923 having distance <= 11 order by distance limit 3
Elk Ridge Estate! This striking spacious home w/ its parklike surroundings offers a rural lifestyle within 5 mins from Dawson Creek. Featuring a sprawling 3200sqft MAIN EXECUTIVE residence PLUS a 1300sqft SECONDARY SUITE above the TRIPLE car garage. The main home contains a grand feature stone gas fireplace, gorgeous bright windows & seamless open concept kitchen/dining with vaulted ceilings. The kitchen showcases an oversized island w/ stone counters & prep sink, custom wood cabinets & walk-in pantry PLUS sunken window over the sink perfect for capturing the city views. The primary bedroom incl. a private balcony, ensuite w/ jacuzzi tub & walk-in closet. The spacious Basement offers 3 bedrooms, a laundry room and a great room w/ space for a tv area and/or games room including walk-out access to the backyard. The SUITE includes two large bedrooms plus the primary bedroom w/ ensuite, STUNNING views out every window & a private back deck. The attention to detail OUTSIDE cannot be matched showcasing the extensive rock work, retaining walls, variety of trees and shrubs & maintained trails throughout the property - room to house all your toys & pets (even room for horses!). (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®)
