HOMESFARMSANDLAND
BuySell
    • Featured Properties
    • Property Showcases
    • Latest Blogs
      • Overview
      • Explore Open Houses
      • Discover Rental Living
      • Escape to Cabin Life
      • Unlock Multi-Family Living
      • Your Perfect Land Awaits
      • Embrace Farm Life
      • Overview
      • Find Rentals
      • Find Cabins
      • Browse Homes
      • Browse Farms
      • Browse Lands
    • Saved Properties
    • Overview
    • Buying Form
    • Buying Process
    • Mortgage Calculator
    • Overview
    • Selling Form
    • Selling Process
    • Free Home Evaluation
      • All of Otsego
      • Cooperstown
      • Oneonta
      • West Oneonta
      • Milford
      • Hartwick
      • Worcester
      • Unadilla
      • Laurens
      • Richfield Springs
      • All of Schoharie
      • Cobleskill
      • Middleburgh
      • Schoharie
      • Sharon Springs
      • Summit
      • Richmondville
      • Esperance
      • All of Chenango
      • Norwich
      • Oxford
      • Greene
      • Bainbridge
      • Sherburne
      • All of Delaware
      • Delhi
      • Stamford
      • Andes
      • Walton
      • Margaretville
      • Roxbury
      • Sidney
      • All of Greene
      • Catskill
      • Windham
      • Hunter
      • Cairo
      • Coxsackie
      • Athens
      • All of Broome
      • Binghamton
      • Vestal
      • Endicott
      • All of Oneida
      • New Hartford
      • Utica
      • Marcy
      • Clinton
      • All of Montgomery
      • Amsterdam
      • Fort Plain
      • Canajoharie
      • Fonda
      • All of Ulster
      • Kingston
      • New Paltz
      • Saugerties
      • Woodstock
      • Marlborough
    • Overview
    • Free Vendor List
    • Need Funding?
    • Property Inspector
    • Down Payment Eligibility
    • Location Sharing?
      • Overview
      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution
    • Who We Are
    • Meet the Team
Featured
Featured Properties
Property Showcases
Latest Blogs
Search
Advanced Search
Explore Open Houses
Discover Rental Living
Escape to Cabin Life
Unlock Multi-Family Living
Your Perfect Land Awaits
Embrace Farm Life
Search by Map
Find Rentals
Find Cabins
Browse Homes
Browse Farms
Browse Lands
Saved Properties
Buy
Buying Form
Buying Process
Mortgage Calculator
Sell
Selling Form
Selling Process
Free Home Evaluation
HOMESFARMSANDLAND
  • Otsego
  • Schoharie
  • Chenango
  • Delaware
  • Greene
  • Broome
  • Oneida
  • Montgomery
  • Ulster

Select a county to see cities

Resources
Free Vendor List
Need Funding?
Property Inspector
Down Payment Eligibility
Location Sharing?
Disclosures
Standard Operating Procedure
NYS Buyer-Seller
NYS Landlord-Tenant
Tenant Rights Notice
Fair Housing Notice
Privacy Policy
Location Services
Properties Preferences
Map Data Attribution
About
Who We Are
Meet the Team

HOMESFARMSANDLAND.COM

Kevin Lucero

Lic Real Estate Salesperson

a Charlotteville Realty Team

Independently Owned & Operated

607-282-6242kevin@homesfarmsandland.com

Buying

  • Buying Form
  • Buying Process
  • Mortgage Calculator

Selling

  • Selling Form
  • Selling Process
  • Free Home Evaluation

Layout spacer

    Layout spacer

      About Us

      • Who We are
      • Meet the Team

      Resources

      • Latest Blogs
      • Free Vendor List
      • Need Funding?
      • Property Inspector
      • Down Payment Eligibility

      Communities

      • Otsego County
      • Schoharie County
      • Chenango County
      • Delaware County
      • Greene County
      • Broome County
      • Oneida County
      • Montgomery County
      • Ulster County

      Disclosures

      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution

      © 2026 Homes, Farms & Land. All rights reserved.

      Property at 671 Mariaville Road, Rotterdam, NY 12306
      ACTIVE
      0
      $899,900

      671 Mariaville RoadRotterdam, NY, 12306

      5,837 SqFt0.81 Acres
      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, the Gun Store, and the pool supply store are both negotiable.
      1 / 59

      Est. Monthly

      $4,266/mo

      $899,900

      671 Mariaville Road, Rotterdam, NY

      5,837 SqFt0.81 Acres

      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, the Gun Store, and the pool supply store are both negotiable.

      StatusActive
      Property TypeCommercial Sale
      Property SubtypeMixed Use
      Year Built1950
      Days on Market201 days

      Est. Monthly Payment

      $4,265.50

      %
      %
      yr

      Private Mortgage Insurance

      Not required

      Affordability Checkoptional
      $

      Enter your annual income to check affordability

      Property Details

      Property Information

      671 Mariaville Road

      Rotterdam, NY 12306 • Schenectady
      —
      Beds
      —
      Baths
      5,837
      SqFt
      0.81
      Acres
      Status
      Active
      Property Type
      Commercial Sale
      Property Subtype
      Mixed Use
      Year Built
      195076 years ago
      Days on Market
      201 days
      Tax History
      Estimated values, may not reflect current amounts.
      • Annual Tax Amount
        $16,033
      • School Taxes
        $9,815
      • Town/County Taxes
        $6,170
      Property History
      • Listed for sale
        Oct 21, 2025 • GLOBAL MLS • 202528144
        $899,900
      Mortgage Calculator
      Estimated monthly payment for this property
      $4,265.50
      Down Payment
      Interest Rate
      Loan Term
      %
      %
      yearsyrs.
      Affordability Checkoptional
      $

      Enter your annual income to see if this home fits your budget

      Private Mortgage Insurance

      Not required — down payment above 20%
      MLS Information
      • Source
        Global MLS
      • MLS#
        202528144
      • Listing Office
        Carr Real Estate Group, LLC
      • Last Updated
        61 days ago

      Climate & Systems

      • Heating
        • Fireplace Insert
        • Electric
        • Baseboard
        • Forced Air
        • Heat Pump

      Interior Features

      • Flooring
        • Laminate
        • Ceramic Tile
        • Wood
        • Hardwood
        • Tile
      • Basement
        • Unfinished
        • Full
        • Interior Entry
      • Interior Features
        • Walk-In Closet(s)
        • Ceramic Tile Bath
        • High Speed Internet
        • Solid Surface Counters
        • Built-in Features
        • Dry Bar
        • Wet Bar
        • Crown Molding

      Parking

      • Parking Features
        • Detached
        • Off Street
        • Paved
        • Open
        • Stone Parking Area
        • Private
      • Parking Spaces
        75

      Lot & Grounds

      • Lot Size
        0.81 acres
      • Lot Features
        • Corner Lot
        • Landscaped
        • Level
        • Road Frontage
      • Patio & Porch
        Patio
      • Exterior Features
        Lighting

      Type

      • Property Type
        Commercial Sale
      • Property Subtype
        Mixed Use

      Structure

      • Construction
        • Brick Veneer
        • Stucco
        • Brick
        • Masonite
      • Roof
        • Rubber
        • Shingle

      Condition

      • Year Built
        1950
      • Days on Market
        201 days
      • Water
        Public
      • Sewer
        Septic Tank
      • Electric
        • 200+ Amp Service
        • Circuit Breakers
        • Underground
        • Single Phase

      607-282-6242, (607) 282-6242, or +1 607 282 6242

      Kevin Lucero

      Kevin Lucero

      Lic. Real Estate Salesperson

      CallEmail
      Picked for you

      Similar Properties

      Handpicked listings that match what you're looking at

      View all →
      • 48 Lincoln Avenue, Saratoga Springs, NY 12866ACTIVE$820,000

        48 Lincoln Avenue, Saratoga Springs, NY 12866

        Commercial SaleMixed Use0.17 Acres

        LISTING BY MIRANDA REAL ESTATE GROUP INC

      • 104 Lord Avenue, Brunswick, NY 12180ACTIVE$850,000

        104 Lord Avenue, Brunswick, NY 12180

        4,996 SqFt14.81 Acres

        LISTING BY KW PLATFORM

      • 2469 NY-30, Mayfield, NY 12117ACTIVE$850,000

        2469 NY-30, Mayfield, NY 12117

        Commercial SaleMixed Use1.4 Acres

        LISTING BY COLDWELL BANKER PRIME PROPERTIES

      • 162 Glen Street, Glens Falls, NY 12801ACTIVE$898,000

        162 Glen Street, Glens Falls, NY 12801

        7,654 SqFt0.07 Acres

        LISTING BY LEVACK REAL ESTATE INC

      • 461 Linwood Avenue, Buffalo, NY 14209ACTIVE$899,777

        461 Linwood Avenue, Buffalo, NY 14209

        4 Beds4.5 Baths5,272 SqFt0.2055 Acres

        LISTING BY HOWARD HANNA WNY INC.

      • 334 Main Street, Middleburgh, NY 12122ACTIVE$899,900

        334 Main Street, Middleburgh, NY 12122

        8,280 SqFt0.25 Acres

        LISTING BY COUNTRY BOY REALTY

      • 379 & 391 route 145, Durham, NY 12423ACTIVE$900,000

        379 & 391 route 145, Durham, NY 12423

        Commercial SaleMixed Use0.95 Acres

        LISTING BY COLDWELL BANKER VILLAGE GREEN

      • 237 Washington Street, Saratoga Springs, NY 12866ACTIVE$900,000

        237 Washington Street, Saratoga Springs, NY 12866

        LandMixed Use0.67 Acres

        LISTING BY KW PLATFORM

      • 200 Glen Street, Glens Falls, NY 12801ACTIVE$949,000

        200 Glen Street, Glens Falls, NY 12801

        13,727 SqFt0.09 Acres

        LISTING BY REALIZE BROKERS