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 lease' and ListingID!=27457603 having distance <= 11 order by distance limit 3
A rare chance to lease the prominent Coldstream Drygoods space, located in the heart of Silver Star Mountain Resort. This prime retail location offers 1,079 square feet of space and 38 feet of frontage on Main Street, providing excellent visibility and foot traffic. May also be combined with the Spice House location adjacent to provide over 50 feet of frontage on Main Street at Silver Star Mountain Resort. The unit boasts 10-foot ceilings, large windows for natural light, and a spacious partially covered deck area—ideal for showcasing your business. Quick possession is available, allowing you to set up in no time. Included with the lease is one designated staff parking space, and the commercial zoning allows for a variety of business possibilities. Monthly fees cover taxes, insurance, utilities, sewer, water, snow clearing, and a contingency fund, with the exception of garbage services. Seize this opportunity to establish your business in a high-traffic, year-round resort destination! (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®)
