Map
Link Copied
Listed price in listed location currency (USD).
$899,900

0375

MLS® 202528144

  • Key Facts
  • Description
  • Map

Key Facts

Type Mixed Use
Levels Commercial Sale
Size 5837 sqft
Garage No
Maintenance Fees 
Taxes $16,033
Days Active 84
Approx. Age 1950
Avg. Price Per Sqft $154
MLS® Number 202528144

Property Address: 671 Mariaville Rd, Rotterdam, NY, 12306-6806

Average square foot calculated using Size range provided by listing agent.

Description

Impressive mixed-use commercial property on a desirable corner lot at 671 Mariaville Road, Schenectady! This high-traffic location features four established retail tenants — including a pool supply store, gun and ammo reseller, and fishing supply shop — anchored by the renowned Wagon Train BBQ Restaurant, a regional favorite that draws steady customer traffic. Real estate only for sale. The property was extensively remodeled in 2004, with numerous updates throughout, including a complete roof replacement using 50-year rubber slate-style shingles for long-term durability and low maintenance. Zoned B-1, the property allows for a wide range of business and redevelopment opportunities. A stand-alone 16' x 20' office building offers flexible build-to-suit options for future tenants seeking a smaller, more manageable retail or professional space. Additional income is generated from a retail propane fill station, further enhancing cash flow. The second floor includes a well-kept one-bedroom apartment, adding residential rental income. With projected gross annual rents exceeding $130, 000, this property provides strong, diversified income potential, long-term stability, and exceptional visibility in a growing commercial corridor! Businesses are excluded from the sale.
MLS® Number202528144
Locker
Ensuite LaundryNo
Balcony
Furnished
Laundry Level
Exposure
Exterior
GarageNo
Approx. Age1950
Stories
Pets

Included in Maintenance Fee

Heat
Hydro
Water
Building Insurance
Condo Taxes
Cable TV
Central Air
Parking Maintenance

Utilities

Heat
A/C
Heating Fuel

Extras

Business & Building, Building & Land

Similar Listings

Price History

-End Date
Not Sold YetSold Price

For Sale

Oct 21, 2025List Date
$899,900List Price
  • Commute

Commute

Starting Address
Destination Address
671 Mariaville Rd, Rotterdam, NY

Like what you see?

Complete the form and we'll be in touch. No login necessary.

Add a Comment
Loading...

Comparable Properties