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!=27516711 having distance <= 11 order by distance limit 3
Location is everything and this has an amazing one. This lot has an outhouse generator shed and a motorhome with all the comforts you will need to either use as a camping lot or home while you build. Motorhome sleeps 6 full kitchen and furnace all work well. Lot is scheduled to hav ethe well drilled in the fall. There is a large area approved for septic so it can support a large home if needed. Only a 3 minute walk to one of the nicest southside meadows beaches with no stairs or switch backs making it very easy to access. Sunset Trail is a 3 minute walk for you to enjoy the beautiful sunsets or walk the famous trail to Indian Point. This lot is 1/3 of an acre with crown land beside you, so you have the enjoyment of a double lot without having to pay for it. This lot also has a large area approved for septic so it can accommodate a large home if needed. The well is scheduled to be drilled in Nov/Dec 2024. (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: Powell River Sunshine Coast Real Estate Board
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®)
