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!=26876870 having distance <= 11 order by distance limit 3
Private 11.87 acres of irrigated farm land, excellent soil for vegetables, berries, orchard, old growth forest valley micro-climate ideal for organics, wildlife. Water licences from Pouce Coupe River for irrigation, in ALR, was a great market garden with high production for the area, owners willing to advise the new owners on best use for growing crops. Secluded, with good road all year. 15 min to Dawson Creek. Eager, receptive client base. Full line of equipment included in price. Gravel bar income opportunity. Solid high ground building site for your dream home overlooks fields and river. 20 by 30 ft. Greenhouse, 30 by 70ft. quonset w/12ft. insulated overhead doors, large cistern, all facilities and hookups. Recent metal clad powershack to underground feeds 200 amp service in Quonset. Secondary outdoor garden toilet with water hookup. Quonset is cool and shady in summer, warm & cozy in winter. (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®)
