Reddoorrealtyny.com Search Results

$459,900

OPEN HOUSE Sat 9/12 2-4pm Comfort, character, and an exceptional outdoor setting make this inviting split-level home a place you'll be proud to call your own. Offering 4 bedrooms and 2.5 baths, the home features beautiful hardwood floors, a cozy gas fireplace in the living room, built-ins, walk-in closets, and the convenience of upper-level laundry. The heart of the home is the remodeled eat-in gourmet kitchen, thoughtfully designed with custom cherry cabinetry, granite countertops, stainless steel appliances, abundant cabinet space, a wet bar, and wine cooler--creating a wonderful space for both everyday living and entertaining. A ceramic tile bath and numerous updates throughout add to the home's comfort and functionality. The full basement is partially finished, offering valuable additional space for relaxing, recreation, hobbies, or a home office. An attached two-car garage and whole-house generator provide added convenience and peace of mind. Step outside and discover a private backyard designed for enjoying time with family and friends. The fenced yard features an in-ground pool with spa, koi pond, outdoor shower, patio, Trex composite decking, and pergola--creating a peaceful setting for summer gatherings, quiet afternoons, and memorable evenings outdoors. Front and rear lawn sprinkler systems make maintaining the grounds easy. With central air, generous storage, thoughtful improvements, and a wonderful combination of indoor comfort and outdoor enjoyment, this home offers a special opportunity to settle in, relax, and make it your own. Please see the attached document for a complete list of additional upgrades and improvements made to the property.

3 Beds ⋅ 3 Baths ⋅ 202625791 MLS

OPEN HOUSE Sat 9/12 2-4pm Comfort, character, and an exceptional outdoor setting make this inviting split-level home a place you'll be proud to call your own. Offering 4 bedrooms and 2.5 baths, the home features beautiful hardwood floors, a cozy gas fireplace in the living room, built-ins, walk-in closets, and the convenience of upper-level laundry. The heart of the home is the remodeled eat-in gourmet kitchen, thoughtfully designed with custom cherry cabinetry, granite countertops, stainless steel appliances, abundant cabinet space, a wet bar, and wine cooler--creating a wonderful space for both everyday living and entertaining. A ceramic tile bath and numerous updates throughout add to the home's comfort and functionality. The full basement is partially finished, offering valuable additional space for relaxing, recreation, hobbies, or a home office. An attached two-car garage and whole-house generator provide added convenience and peace of mind. Step outside and discover a private backyard designed for enjoying time with family and friends. The fenced yard features an in-ground pool with spa, koi pond, outdoor shower, patio, Trex composite decking, and pergola--creating a peaceful setting for summer gatherings, quiet afternoons, and memorable evenings outdoors. Front and rear lawn sprinkler systems make maintaining the grounds easy. With central air, generous storage, thoughtful improvements, and a wonderful combination of indoor comfort and outdoor enjoyment, this home offers a special opportunity to settle in, relax, and make it your own. Please see the attached document for a complete list of additional upgrades and improvements made to the property.

945 Mohegan Road

$899,900

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

$989,900

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

$1,299,000

Designed and built by renowned builder Peter Sotile, this one-of-a-kind custom contemporary offers nearly 6,000 square feet of thoughtfully designed living space, which includes an exceptional finished lower level. Expansive windows (126 of them!) and skylights fill the home with natural light while bringing the beauty and serenity of the surrounding landscape indoors. The private primary suite is tucked away on its own wing and features two unique balconies--one overlooking the dramatic sunken living room and another accessed through sliding glass doors, where you can enjoy peaceful treetop views of the surrounding forest. A separate bedroom wing offers outstanding flexibility, featuring a shared living area, three spacious bedrooms, and two full bathrooms--ideal for family, guests, or multigenerational living. The oversized second-floor loft overlooks the grand foyer, family room, and kitchen, creating an open and airy atmosphere. The inviting library is introduced through beautifully etched double doors, while the formal dining room showcases elegant inlaid hardwood flooring and sliding glass doors leading to a screened porch. Recent updates provide peace of mind and modern comfort, including two approximately five-year-old heating and air conditioning systems, a newer roof, and an on-demand hot water system. The expansive finished lower level features an oversized recreation room perfect for entertaining, game nights, celebrations, or hosting large gatherings. This exceptional Baldwin Farms residence combines distinctive architecture, generous living spaces, and a tranquil natural setting to create a truly remarkable place to call home. All in the award winning Niskayuna School District! The dining room light fixture is excluded.

4 Beds ⋅ 5 Baths ⋅ 202622935 MLS

Designed and built by renowned builder Peter Sotile, this one-of-a-kind custom contemporary offers nearly 6,000 square feet of thoughtfully designed living space, which includes an exceptional finished lower level. Expansive windows (126 of them!) and skylights fill the home with natural light while bringing the beauty and serenity of the surrounding landscape indoors. The private primary suite is tucked away on its own wing and features two unique balconies--one overlooking the dramatic sunken living room and another accessed through sliding glass doors, where you can enjoy peaceful treetop views of the surrounding forest. A separate bedroom wing offers outstanding flexibility, featuring a shared living area, three spacious bedrooms, and two full bathrooms--ideal for family, guests, or multigenerational living. The oversized second-floor loft overlooks the grand foyer, family room, and kitchen, creating an open and airy atmosphere. The inviting library is introduced through beautifully etched double doors, while the formal dining room showcases elegant inlaid hardwood flooring and sliding glass doors leading to a screened porch. Recent updates provide peace of mind and modern comfort, including two approximately five-year-old heating and air conditioning systems, a newer roof, and an on-demand hot water system. The expansive finished lower level features an oversized recreation room perfect for entertaining, game nights, celebrations, or hosting large gatherings. This exceptional Baldwin Farms residence combines distinctive architecture, generous living spaces, and a tranquil natural setting to create a truly remarkable place to call home. All in the award winning Niskayuna School District! The dining room light fixture is excluded.

37 Covington Court

$649,900

Tucked at the quiet end of Via Maria Drive in sought-after Burnt Hills-Ballston Lake schools, this move-in ready 5-bed, 2.5-bath home offers 2,816 sq ft (per county records) on 0.44 private acres backing to forever wild land--no rear neighbors, ever. Kitchen fully updated 2024 with stainless steel appliances. Gas fireplace, spacious dining room, first floor laundry, covered screened porch, large shed, and a freshly restained exterior (June 2026). Partially finished basement adds a bonus room plus large storage with shelving. Quiet street, minimal traffic. Sq ft approximate; buyers should independently verify all information

5 Beds ⋅ 3 Baths ⋅ 202621120 MLS

Tucked at the quiet end of Via Maria Drive in sought-after Burnt Hills-Ballston Lake schools, this move-in ready 5-bed, 2.5-bath home offers 2,816 sq ft (per county records) on 0.44 private acres backing to forever wild land--no rear neighbors, ever. Kitchen fully updated 2024 with stainless steel appliances. Gas fireplace, spacious dining room, first floor laundry, covered screened porch, large shed, and a freshly restained exterior (June 2026). Partially finished basement adds a bonus room plus large storage with shelving. Quiet street, minimal traffic. Sq ft approximate; buyers should independently verify all information

35 Via Maria Drive

$845,000

Experience the Perfect blend of luxury, comfort, & privacy in this stunning contemporary estate set on 28.17 acres. This spacious 4,333 sq. ft home features 5 BR, 4 1/2 baths, including a main-level primary suite w/generous closets, & beautifully appointed bathroom. The open Kitchen is ideal for entertaining. The great room with an entertainment center, wet bar, & pool table- perfect for gatherings and relaxation. Step outside through French doors to enjoy the inviting inground saltwater pool. Car Enthusiasts and hobbyist will appreciate both the attached 3 car garage, & 3 car detached garage that holds 6 cars, while the greenhouse offers exciting potential for gardening. Energy efficiency is a highlight, with OWNED Solar panels and a propane tank providing independence and savings. (Attached garage solar is, rented) Recent updates include a blue stone front retaining wall, newer sidewalks, foundational work, fresh exterior paint (2023), a newer awning, 2 new garage doors (attached) and an accessible ramp to the front entrance. This Property is a rare opportunity for those seeking unique amenities, expansive grounds, private retreat. A New Furnace installed in February 2026, and all new LBT flooring was installed in the basement in April 2026.

5 Beds ⋅ 5 Baths ⋅ 202529377 MLS

Experience the Perfect blend of luxury, comfort, & privacy in this stunning contemporary estate set on 28.17 acres. This spacious 4,333 sq. ft home features 5 BR, 4 1/2 baths, including a main-level primary suite w/generous closets, & beautifully appointed bathroom. The open Kitchen is ideal for entertaining. The great room with an entertainment center, wet bar, & pool table- perfect for gatherings and relaxation. Step outside through French doors to enjoy the inviting inground saltwater pool. Car Enthusiasts and hobbyist will appreciate both the attached 3 car garage, & 3 car detached garage that holds 6 cars, while the greenhouse offers exciting potential for gardening. Energy efficiency is a highlight, with OWNED Solar panels and a propane tank providing independence and savings. (Attached garage solar is, rented) Recent updates include a blue stone front retaining wall, newer sidewalks, foundational work, fresh exterior paint (2023), a newer awning, 2 new garage doors (attached) and an accessible ramp to the front entrance. This Property is a rare opportunity for those seeking unique amenities, expansive grounds, private retreat. A New Furnace installed in February 2026, and all new LBT flooring was installed in the basement in April 2026.

3041 Mariaville Road

$549,900

TURN KEY BUSINESS RESTAURANT & BAR WITH APARTMENT.

3 Baths ⋅ 202527622 MLS

TURN KEY BUSINESS RESTAURANT & BAR WITH APARTMENT.

783 STATE Street 783