REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.

In-PersonVirtual Tour

Thu

Oct

Fri

Oct

Sat

Oct

Listed by Richard Carr • Carr Real Estate Group, LLC

$ 899,900

Est. payment -/mo

Save Virtual Tour

New

671 Mariaville Road Rotterdam, NY 12306

3 Baths

5,837 SqFt

UPDATED:

Key Details

Property Type Single Family Home

Sub Type Mixed Use

Listing Status Active

Purchase Type For Sale

Square Footage 5,837 sqft

Price per Sqft $154

MLS Listing ID 202528144

HOA Y/N No

Year Built 1950

Annual Tax Amount $16,032

Lot Size 0.810 Acres

Acres 0.81

Lot Dimensions 282 X 224

Property Sub-Type Mixed Use

Source Global MLS

Property 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. 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!

Location

State NY

County Schenectady

Zoning Commercial

Direction I-890 West to Exit 2A for NY-337 (Campbell Rd) Turn right onto NY 337 S Burdeck St, left on Mariaville Rd property on left.

Interior

Interior Features High Speed Internet, Solid Surface Counters, Walk-In Closet(s), Wet Bar, Built-in Features, Ceramic Tile Bath, Crown Molding, Dry Bar

Heating Baseboard, Electric, Fireplace Insert, Forced Air, Heat Pump, Natural Gas

Flooring Tile, Wood, Ceramic Tile, Hardwood, Laminate

Inclusions Business & Building, Building & Land

Exterior

Exterior Feature Lighting

Parking Features Public Parking, Off Street, Paved, Private, Stone Parking Area, Detached

Pool In Ground, Salt Water

Roof Type Rubber,Shingle

Porch Patio

Building

Lot Description Road Frontage, Level, Corner Lot, Landscaped

Sewer Septic Tank

Water Public

Architectural Style Commercial

New Construction No

Schools

School District Schalmont

Others

Tax ID 422800 47.-8-4.1

Acceptable Financing Lease Option

Listing Terms Lease Option

Special Listing Condition Standard

Virtual Tour https://youriguide.com/671-Mariaville-Rd-10-15-25/

Inglenook Realty, Inc.

Broker | License ID: 109931319

+1(518) 882-6236

GET MORE INFORMATION

Name

Email*

Phone*

Message

By creating an account, you acknowledge & agree that your activity on our site will be saved to your profile & accessible to Inglenook Realty, Inc. You consent to receive property alerts & marketing communications, including emails, phone calls, video updates, & text messages. You may opt-out at any time.

Homes For Sale Quick Search