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 Delgallo Pools and 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.
| Listing Id: | 202625381 |
|---|---|
| List Price: | $899,900 |
| Property Type: | Commercial Sale |
| Property Sub Type: | Mixed Use |
| Status: | Active |
| Bathrooms Full: | 3 |
| Living Area: | 5,837 |
| Tax Annual Amount: | $16,033 |
| Lot Size Square Feet: | 35,284.0 |
| Lot Size Acres: | 0.81 |
| Waterfront?: | No |
| City: | Schenectady |
| County Or Parish: | Schenectady |
| Postal Code: | 12306 |
| Year Built: | 1950 |
| List Agent Full Name: | Richard Carr |
| Cooling: | Central Air |
| Elementary School: | Jefferson ES |
| Lot Size Units: | Acres |
| Patio And Porch Features: | Patio |
| Heating?: | Yes |
| Bathrooms Total Integer: | 3 |
| Cooling?: | Yes |
| Basement: | true |
| Basement: | Unfinished, Full, Interior Entry |
| State Or Province: | NY |
| Lot Features: | Corner Lot, Landscaped, Level, Road Frontage |
| Special Listing Conditions: | Standard |
| Building Area Total: | 5,837.0 |
| Stories: | 2 |
| Pool Features: | In Ground, Salt Water |
| Sewer: | Septic Tank |
| Lot Size Dimensions: | 282 X 224 |
| Electric: | 200+ Amp Service, Circuit Breakers, Underground, Single Phase |
| Association Amenities: | None |
| Roof: | Rubber, Shingle |
| Lot Size Area: | 0.81 |
| Possible Use: | Mixed Use, Office/Retail, Restaurant, Retail, Automotive, Convenience Store, Gas Station, Investment |
| Parking Features: | Detached, Off Street, Paved, Open, Stone Parking Area, Private |
| Current Use: | Business, Mixed Use, Restaurant, Retail |
| Zoning: | Commercial |
| Documents Change Timestamp: | 2026-09-03T15:47:53Z |
| Heating: | Fireplace Insert, Electric, Baseboard, Forced Air, Heat Pump |
| Directions: | Google maps |
| Flooring: | Laminate, Ceramic Tile, Wood, Hardwood, Tile |
| Business Type: | Commercial |
| Listing Contract Date: | 2026-09-03 |
| Parcel Number: | 422800 47.-8-4.1 |
| List Agent Key: | 20211012215944220661000000 |
| Construction Materials: | Brick Veneer, Stucco, Brick, Masonite |
| Parking Total: | 75 |
| Water Source: | Public |
| High School District: | Schalmont |
| Security Features: | 24 Hour Security, Building Security, Fire Alarm, Closed Circuit Camera(s), Security Lights, Security System Owned, Smoke Detector(s) |
| Year Established: | 2004 |
| Tenant Pays: | Internet, Cable TV, Electricity, Heat, Hot Water |
| Postal City: | Schenectady |
| Other Structures: | Equipment Buillding, Outbuilding, Shed(s) |
| Listing Terms: | Lease Option |
| Business Name: | Delgallo Country pools |
| Original List Price: | $899,900 |
| Possession: | At Closing |
| Cross Street: | Burdeck Street |
| Bathrooms Total Decimal: | $3.00 |
| Contract Information Lease Per Sq Ft Or Month: | SqFt |
| Contract Information Lease Considered: | Yes |
| Contract Information Offered Lease Sqft: | $12.00 |
| Contract Information List Price Sq Ft: | $154.17 |
| Contract Information List Price Acres: | $1,110,987.65 |
| Property Detail Parking Yn: | Yes |
| Property Detail Building Available Sqft: | $6,982.00 |
| Property Detail Main Road Frontage: | $282.00 |
| Property Detail Enhanced Accessible Yn2: | No |
| Parcel Tax Hoa Total Taxes Description: | Estimated |
| Financial Details General Taxes: | $6,170.00 |
| Financial Details General Taxes Description: | Actual |
| Financial Details School Taxes: | $9,815.00 |
| Financial Details School Taxes Description: | Actual |
| 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 |
| Number Of Buildings: | 1 |
| Inclusions: | Business & Building, Building & Land |
| Approval Status: | Yes |
| Photos - the contractual owner of the photos Photo Owner 3: | Broker |
| Architectural Style: | Commercial, Mixed Use, Retail |
| Exterior Features: | Lighting |
Listing Courtesy of: Carr Real Estate Group LLC
Listing Agent: Richard Carr
518-488-2434
Mortgage Calculator
© 2026 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.
Data last updated October 08, 2026 05:02 PM - ET.
Property Last Updated: October 08, 2026 05:02 PM - ET
