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` = '1' and ListingID!=27261376 having distance <= 11 order by distance limit 3
Welcome to your dream retreat! Nestled on 3.58 stunning acres of serene privacy, this beautiful property truly has it all. Imagine waking up every morning in a sun-drenched home featuring 3 spacious bedrooms and 1 bath. This sanctuary exudes charm with delightful crown moldings and the cozy warmth of a wood stove, perfect for those cool evenings. Step outside into your own private paradise where lush, landscaped gardens beckon you to unwind and savor the natural beauty. The green-thumbed will d elight in the abundant vegetable garden and several flourishing fruit trees. For the horse enthusiasts, a well-maintained corral and lean-to await, providing ample space and comfort for your equine friends. Embrace the joy of sustainable living with your very own hothouse, perfect for cultivating a variety of plants year-round. Two generous sheds offer plenty of storage, keeping y our outdoor space pristine and organized. Whether you're gazing out over your partially fenced property or relaxing under the c anopy of mature trees, you'll cherish the unparalleled tranquility this home offers. This rare gem is bathed in natural light, c reating a warm and inviting atmosphere throughout. Don't miss your opportunity to own a piece of paradise--schedule a v iewing today and discover the perfect blend of comfort, elegance, and natural beauty. Your dream home awaits! (id:48970) Show More
This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Kamloops & District Real Estate Association
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®)
