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

$ 1,649,000
  • ©MLS 2471147

Description

Incredible business and homestead opportunity! Discover the perfect blend of work and relaxation at this remarkable property, boasting the renowned Boards by George Sawmill, a thriving business with a 43-year legacy. Situated on 33 expansive and flat usable acres, this real estate gem offers endless potential. Nestled alongside the Lardeau River, this property presents a 4-bedroom, 1-bath home, and sawmill overlooking the river. The mill processes primarily fir, as well as larch, cedar, spruce, and hemlock and can process side cuts, boards, T&G, shiplap, trim, siding, and flooring. It is one of the last mills that can cut 40' long and logs up to 7' in diameter, with The Duncan Ironworks sawmill. The sale includes all the equipment necessary to break down logs from start to finish. From unloading, and handling to milling, drying, planing and packaging. It has a complete repair and maintenance shop with parts, tools, welder, milling machines, and a large supply of miscellaneous milling equipment. The property has numerous outbuildings and an office. The business is ready to step into and is still being used on a part-time basis. BBG comes with a valuable client list and an excellent reputation. The owner is willing to mentor and share contacts. Please see MLS 2471146 to view the full residential information of this property. (id:48970) Show More

Details

  • Constructed Date: 1950
  • Property Type: Other
  • Community: Kaslo North to Gerrard

Features

  • Treed Lot
  • Rural Setting

Location



This REALTOR.ca listing content is owned and licensed by REALTOR® members of The Canadian Real Estate Association
Data provided by: Kootenay Real Estate Board

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