Reddoorrealtyny.com Search Results

4 listings

Refine Search

Sort by

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.

3 Baths ⋅ 202625381 MLS

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.

671 Mariaville Road

A once in a generation opportunity to own one of Rotterdam's most distinguished custom built estates. The first home built in this prestigious neighborhood, this landmark residence has long been admired for its exceptional quality, timeless architecture, and enduring craftsmanship. Situated on beautifully landscaped, park-like grounds, this extraordinary home offers approximately 6,300 square feet above grade plus an additional 3,000 square feet of finished lower level living space. A dramatic two story foyer welcomes you with marble floors, a sweeping staircase, and powder room. Formal living and dining rooms feature original hardwood floors preserved beneath carpeting since 1959, pocket doors, and an adjoining garden room complete with a wet bar, indoor grill, and dual sliding doors to the backyard. The spacious eat in kitchen offers abundant cabinetry and Corian countertops. The inviting family room features a Roman brick fireplace with slate hearth, oversized windows, and a built in bar closet. A stunning executive office showcases rich walnut paneling, custom built-ins, and a cherry coffered ceiling. The main level also includes a spacious primary suite with dual closets and private bath, plus a second bedroom and full bath. Upstairs are four generously sized bedrooms with hardwood floors, ample closet space, a cedar closet, linen closet, two large storage rooms, and a full bath with triple vanity, soaking tub, and separate shower. The finished lower level includes a family room with fireplace, recreation room, kitchenette, office, wine cellar, half bath, and an expansive two room woodworking shop. The striking brick and Kentucky bluestone exterior is complemented by an inground pool, pool house with bath and shower, lighted bocce court, gazebo, tree house, three-car attached garage, and beautifully landscaped grounds. Additional features include three Lennox furnaces, two central air systems, and generator hookup Adj .71acre building lot available separately

6 Beds ⋅ 5 Baths ⋅ 202623835 MLS

A once in a generation opportunity to own one of Rotterdam's most distinguished custom built estates. The first home built in this prestigious neighborhood, this landmark residence has long been admired for its exceptional quality, timeless architecture, and enduring craftsmanship. Situated on beautifully landscaped, park-like grounds, this extraordinary home offers approximately 6,300 square feet above grade plus an additional 3,000 square feet of finished lower level living space. A dramatic two story foyer welcomes you with marble floors, a sweeping staircase, and powder room. Formal living and dining rooms feature original hardwood floors preserved beneath carpeting since 1959, pocket doors, and an adjoining garden room complete with a wet bar, indoor grill, and dual sliding doors to the backyard. The spacious eat in kitchen offers abundant cabinetry and Corian countertops. The inviting family room features a Roman brick fireplace with slate hearth, oversized windows, and a built in bar closet. A stunning executive office showcases rich walnut paneling, custom built-ins, and a cherry coffered ceiling. The main level also includes a spacious primary suite with dual closets and private bath, plus a second bedroom and full bath. Upstairs are four generously sized bedrooms with hardwood floors, ample closet space, a cedar closet, linen closet, two large storage rooms, and a full bath with triple vanity, soaking tub, and separate shower. The finished lower level includes a family room with fireplace, recreation room, kitchenette, office, wine cellar, half bath, and an expansive two room woodworking shop. The striking brick and Kentucky bluestone exterior is complemented by an inground pool, pool house with bath and shower, lighted bocce court, gazebo, tree house, three-car attached garage, and beautifully landscaped grounds. Additional features include three Lennox furnaces, two central air systems, and generator hookup Adj .71acre building lot available separately

1005 Fairlane Road

Beautifully maintained 4BR, 2.5BA Colonial on a quiet cul-desac with exceptional privacy in Glenville. This spacious home offers 2,494 sq ft above grade plus ~800 sq ft of finished lower-level space on a large, level 0.45-acre corner lot with mature landscaping and exceptional privacy. Gleaming hardwood floors, granite kitchen with center island, stainless-steel appliances, family room, formal dining room, living room with a fireplace, & a full front porch. Finished lower level includes a recreation room, a cedar closet, and cold storage--with an attached 2-car garage. Seller offers a cosmetic credit at closing. A separate credit is available toward a portion of the chain-link fence and gate affected by a recent storm--a wonderful opportunity for space, privacy, and flexibility under $500K.

4 Beds ⋅ 3 Baths ⋅ 202622741 MLS

Beautifully maintained 4BR, 2.5BA Colonial on a quiet cul-desac with exceptional privacy in Glenville. This spacious home offers 2,494 sq ft above grade plus ~800 sq ft of finished lower-level space on a large, level 0.45-acre corner lot with mature landscaping and exceptional privacy. Gleaming hardwood floors, granite kitchen with center island, stainless-steel appliances, family room, formal dining room, living room with a fireplace, & a full front porch. Finished lower level includes a recreation room, a cedar closet, and cold storage--with an attached 2-car garage. Seller offers a cosmetic credit at closing. A separate credit is available toward a portion of the chain-link fence and gate affected by a recent storm--a wonderful opportunity for space, privacy, and flexibility under $500K.

1015 Cheyenne Road

Imagine waking each morning to sweeping panoramic views, colorful perennial gardens, and the peaceful beauty of your own 3.1-acre country retreat. This distinctive 1850s Greek Revival-style home offers 3,100+ sq. ft. of living space, blending historic character with thoughtful renovations and modern-day functionality. Lovingly cared for by the same owner for more than 30 years, the expansive floor plan features multiple living areas with exceptional flexibility for multigenerational living, remote work, creative pursuits, recreation, or guest accommodations. Outside is where this property truly sets itself apart. Several impressive outbuildings offer incredible possibilities, including a 2,899 sq. ft. garage with abundant space for RVs, boats, recreational vehicles, equipment, or the auto enthusiast and vehicle collector. The garage also features a workshop in the loft with a door providing direct exterior access to the rear of the building, adding even more versatility for projects, hobbies, or workspace. A separate 1,188 sq. ft. horse barn features an existing stall with room for additional stalls. A 16' x 9' run-in shed and 10' x 13' chicken coop complete the property, creating wonderful potential for equestrian use, a hobby farm, or country lifestyle. Established perennial gardens provide colorful seasonal blooms, while the patio, hot tub, and outdoor shower offer inviting spaces to relax and enjoy the peaceful surroundings. Enjoy privacy and natural beauty while remaining convenient to hiking, nature preserves, shopping, dining, with easy access to Schenectady, Albany, and Saratoga Springs. Whether you're searching for a historic country home, private retreat, hobby farm, or a property with exceptional garage, workshop, and storage space, this one offers possibilities rarely found together. Virtually staged.

4 Beds ⋅ 3 Baths ⋅ 202621917 MLS

Imagine waking each morning to sweeping panoramic views, colorful perennial gardens, and the peaceful beauty of your own 3.1-acre country retreat. This distinctive 1850s Greek Revival-style home offers 3,100+ sq. ft. of living space, blending historic character with thoughtful renovations and modern-day functionality. Lovingly cared for by the same owner for more than 30 years, the expansive floor plan features multiple living areas with exceptional flexibility for multigenerational living, remote work, creative pursuits, recreation, or guest accommodations. Outside is where this property truly sets itself apart. Several impressive outbuildings offer incredible possibilities, including a 2,899 sq. ft. garage with abundant space for RVs, boats, recreational vehicles, equipment, or the auto enthusiast and vehicle collector. The garage also features a workshop in the loft with a door providing direct exterior access to the rear of the building, adding even more versatility for projects, hobbies, or workspace. A separate 1,188 sq. ft. horse barn features an existing stall with room for additional stalls. A 16' x 9' run-in shed and 10' x 13' chicken coop complete the property, creating wonderful potential for equestrian use, a hobby farm, or country lifestyle. Established perennial gardens provide colorful seasonal blooms, while the patio, hot tub, and outdoor shower offer inviting spaces to relax and enjoy the peaceful surroundings. Enjoy privacy and natural beauty while remaining convenient to hiking, nature preserves, shopping, dining, with easy access to Schenectady, Albany, and Saratoga Springs. Whether you're searching for a historic country home, private retreat, hobby farm, or a property with exceptional garage, workshop, and storage space, this one offers possibilities rarely found together. Virtually staged.

1236 McGuire School Road

©2019 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