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!=27178965 having distance <= 11 order by distance limit 3
Welcome to the Ymir Bakery, a charming establishment offering a delightful array of baked goods and breads. This turnkey sale includes all equipment, with the option to purchase the building separately. Financials are accessible for qualified buyers, and the seller is open to aiding in a seamless transition. Ideal for an ambitious entrepreneur, this 1000 sq ft space boasts 13 ft ceilings highlighting original timbers. Recent updates such as new windows, a timber frame front awning, radiant in-floor heating, and modern electrical and plumbing enhance the ambiance. Don't miss this opportunity to own a thriving business in the heart of Ymir, where community connection and delicious treats await. Lease available at $1500 plus utilities, with no triple net. (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®)
