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!=27129203 having distance <= 11 order by distance limit 3

Lot 31 ASHCROFT ROAD For Sale

kamloops, British Columbia
$ 265,000
  • ©MLS 179664

Description

Opportunity to own a magnificent 10.98-acre parcel of land, offering an idyllic setting with southern exposure and unparalleled mountain vistas. Situated within a desirable zone (RL-1), this property grants you the freedom to construct the residence of your dreams or opt for a custom double-wide home tailored to your preferences. short drive to Kamloops Lake, enjoy leisurely days boating under the sun, or take a brief 35-minute drive to indulge in the conveniences of Costco and more in Kamloops. A thoughtful building scheme has been established to ensure the preservation of the natural aesthetics of the Thompson River Valley. The scheme mandates: - No single-wide mobile homes, whether new or used. - A preference for subdued, nature-blending colors for home exteriors, avoiding bright hues that detract from the area's inherent beauty. This is in keeping with the harmonious palette seen in nearby Tobiano, providing a visually pleasing environment. The lot comes equipped with essential utilities: water and power are readily available. A newly drilled 240 ft well delivers a reliable water supply at 1.5 gallons per minute, amounting to 2,160 gallons daily. (id:48970) Show More

Details

  • Property Type: Vacant Land
  • Road: Gravel road
  • Community: Cherry Creek/Savona

Features

  • Sloping

Location



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

©️ Hybrid Real Estate Plugin For CREA DDF

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®)