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!=27159991 having distance <= 11 order by distance limit 3
Imagine tossing another log on the fire in your cozy new home, tucked away in the gorgeous colorful hills of West Creston. Here a serene and private acreage with expansive views is all yours to escape to. The breathtaking views from this 2.5 acre Simmons Road Property offers a natural mountain experience for year round enjoyment. This rural retreat displays a stunning vista of the Selkirk and Purcell mountains, from sunny wide open spaces to the big starry night sky. It's a vantage point worth discovering. West Creston has year-round access to trails for hiking, biking, cross country skiing, snowmobiling, and more. Only minutes away, downtown Creston is a vibrant and growing hub brimming with shopping, wineries and restaurants, and the famous Kokanee Brewery. All this to explore at your own pace, from your own piece of paradise. Whether you are looking to build a peaceful retreat or a "grow and sell your own food" business, this special land offers endless possibilities to create and nurture your family homestead. High quality wells are already in place to enjoy crystal clear and abundant water. And of course, septic fields have been proven. This property could also allow for B&B potential, or an accessory dwelling unit. What great income boosters or mortgage helpers! The quality of the people that call Creston home - including farmers, entrepreneurs, retirees and young families- live in a region brimming with activities and opportunities. What better place to call home? So get your hands dirty! We invite you to explor (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®)
