671 Mariaville Rd

Rotterdam, NY 12306

$899,900
Price
—
Beds
3
Baths
5,837 Sq. Ft.
$154 / Sq. Ft.
5,837
Sq. Ft.
$154
per Sq. Ft.
Virtual Tour
Virtual Tour
10000 Air Front 2
0 Air Front 1
0 Air Front 2
1 Outside 1
1 Outside 2
1 Outside 3
1 Outside 11
1 Outside 4
1 Outside 5
1 Outside 10
2 Pool 1
2 Pool 2
2 Pool 3
2 Pool 4
2 Pool 5
2 Pool 6
2 Pool 7
3 rest 1
3 rest 2
3 rest 3
3 rest 4
3 rest 5
3 rest 6
3 rest 7
3 rest 8
3 rest 9
3 rest 10
3 rest 11
3 rest 12
3 rest 13
3 rest 14
3 rest 15
4 Office up 1
4 Office up 2
4 Office up 3
4 Office up 4
5 Office Down 1
5 Office Down 2
5 Office Down 3
5 Office Down 4
6 Apt entryway
Air Yard 1
Air Yard 2
Air Yard 3
Air Yard 4
Air Yard 5
Air Yard 6
Air Yard 7
Air Yard 8
Air Yard 10
Areial View Lot Line
20251018_132327
20251018_132352 - Copy - Copy
20251018_132420 - Copy - Copy
20251018_132434 - Copy - Copy
20251018_132454 - Copy (2)
20251018_132507 - Copy - Copy
20251018_132522
20251018_132530 - Copy

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...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.
  1. Listed by Richard Carr • Carr Real Estate Group, LLC
    P: (518)-488-2434 C: (518)-488-2434 richc1976@gmail.com

Property Details for 671 Mariaville Road

Architectural Style
Commercial
Zoning
Commercial
Waterfront
No
Parking Total
75.00
LISTING UPDATED: 10/29/2025 04:54 PM

Property Details for 671 Mariaville Road

StatusActive
MLS #202528144
Days on Market66
Taxes$16,033 / year
HOA Fees-
Condo/Co-op Fees-
Compass TypeMixed Use
MLS TypeCommercial Sale / Mixed Use
Year Built1950
Lot Size0.81 AC / 35,283 SF
CountySchenectady County

Location

Listing Courtesy of Carr Real Estate Group, LLC
Add your commute

Virtual Tour

Building Information for 671 Mariaville Road

Stories2Residences-Year Built1950Lot Size0.81 AC / 35,283 SF

Payment Calculator

$5,783 per month

30 year fixed, 6.28% Interest

Principal and Interest

$4,447

Property Taxes

$1,336

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Property Information for 671 Mariaville Road

Summary
Location and General Information
  • Postal City: Schenectady
  • Directions: 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.
  • City: Rotterdam
  • State Or Province: NY
  • Postal Code: 12306
  • County Or Parish: Schenectady
  • Latitude: 42.79
  • Longitude: -74.01
Taxes and HOA
  • Association Fee: $.00
  • Association: No
  • Tax Lot: 4.001
  • Tax Block: 8
  • Parcel Number: 422800 47.-8-4.1
  • Tax Tract: 47.00
  • Tax Annual Amount: $16,032.84
Parking
  • Attached Garage: No
  • Parking Features: Public Parking, Off Street, Paved, Private, Stone Parking Area, Detached
School Information
  • School District: Schalmont
  • Elementary School: Jefferson ES
Virtual Tour
Property
Property and Assessments
  • Possession: At Closing
  • Property Type: Commercial Sale
  • Property Type Label: Commercial Sale
  • Current Use: Business, Mixed Use, Restaurant, Retail
Lot Information
  • Lot Features: Road Frontage, Level, Corner Lot, Landscaped
  • Year Built: 1950
  • Lot Size Dimensions: 282 X 224
  • New Construction: No
  • Year Established: 2004
  • Lot Size Acres: 0.81
  • Lot Size Area: 0.81
  • Lot Size Units: Acres
  • Lot Size Square Feet: 35284.0
Building Information
  • Business Type: Commercial
  • Business Name: Delgallo Country pools
  • Building Area Total: 5837.0
  • Living Area: 5837.0
  • Possible Use : Mixed Use: Yes
  • Possible Use : OfficeRetail: Yes
  • Possible Use : Restaurant: Yes
  • Possible Use : Retail: Yes
Utilities
  • Water Source: Public
Interior and Exterior Features
Exterior Features
  • Security Features: Security System Owned, Security Lights, Smoke Detector(s), 24 Hour Security, Building Security, Closed Circuit Camera(s), Fire Alarm
  • Pool: In Ground, Salt Water
  • Patio And Porch Features: Patio
  • Other Structures: Outbuilding, Shed(s), Equipment Buillding
  • Exterior Features: Lighting
  • Association Amenities: None
Interior Features
  • 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
  • Roof: Rubber, Shingle
  • Flooring: Tile, Wood, Ceramic Tile, Hardwood, Laminate
  • Electric: True
  • Basement: Full, Interior Entry, Unfinished
  • Construction Materials: Brick, Brick Veneer, Masonite, Stucco
  • Cooling: Central Air
  • Cooling: Yes
  • Heating: Yes
  • Stories: 2
  • Building Detail : Fire Sprinkler System YN: No
  • Building Detail : Railroad Siding YN: No
  • Building Detail : Building Ceiling Height: 10
  • Building Detail : Office Total SQFT: 400.00
  • Building Detail : Office Available SQFT: 1,200.00
  • Building Detail : Office Ceiling Height: 8.00
  • Building Detail : Retail Total SQFT: 5,837.00
  • Building Detail : Retail Available SQFT: 5,837.00
  • Building Detail : Retail Ceiling Height: 8.00
  • Building Detail : Restrictions: Zoning B-1
Room Information
Bathrooms
  • Bathrooms Total Integer: 3
  • Bathrooms Total Decimal: 3.00
  • Bathrooms Total Notational: 3.00
Unit Information
Unit 1
  • Unit Dining Room Type : None: Yes
Rental
Rental Information
  • Land Lease: No
  • Tenant Pays: Heat, Hot Water, Internet, Cable TV, Electricity

Property History for 671 Mariaville Road

DateEvent & SourcePriceAppreciation
Oct 20, 2025

Listed (Active)

GLOBAL MLS #202528144

$899,900—
Sep 22, 2004

Sold (Public Record)

Public Record #240756303

$265,000—
DateEvent & SourcePrice
10/20/2025

Listed (Active)

GLOBAL MLS #202528144

$899,900
09/22/2004

Sold (Public Record)

Public Record #240756303

$265,000

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 671 Mariaville Road

Taxable ValueLand$102,200Additions$292,800Total$395,000
Home Facts
Total Finished SqFt5,837 SqFtAbove Grade Finished SqFt5,837 SqFtUnfinished Basement SqFt854 SqFtStories2Lot Size35,284 SqFtStyleService StationYear Built1950Year Renovated2004ZoningB-1CountySCHENECTADYAPN422800 47.-8-4.1

Schools near 671 Mariaville Road

This home is within Schalmont Central School District.
Rating
School
Type
Grades
Distance
Jefferson Elementary School
Public - K to 12
Schalmont Middle School
Public - 5 to 8
Schalmont High School
Public - 9 to 12
Rating
School
Distance
Jefferson Elementary School
PublicK to 12

Schalmont Middle School
Public5 to 8

Schalmont High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

Explore Nearby Homes

More information about 671 Mariaville Road, Rotterdam, NY 12306

671 Mariaville Road is a mixed use property for sale in Rotterdam, NY 12306. This property was listed for sale on October 20, 2025 by Carr Real Estate Group, LLC, it's currently listed at $899,900. It has been on the market for a total of 66 days and was last sold on September 22, 2004. This listing's school district is Schalmont Central School District. Nearby schools include Jefferson Elementary School, Schalmont Middle School and Schalmont High School. 671 Mariaville Road is a 0-bed, 3-bath, 5,837 sqft mixed use property built in 1950.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Carr Real Estate Group, LLC

©2025 Global Multiple Listing Service, Inc. The data relating to real estate on this website comes in part from the Internet Data Exchange program of the GMLS. All information is deemed reliable but not guaranteed and should be independently verified. All properties subject to prior sale, change, or withdrawal. Neither listing broker(s), GMLS shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless from any damages arising from reliance upon these data. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties they may be interested in purchasing.