Mycapitalregionhomes.com Search Results

$1,499,900

A Rare 163-Acre Estate Offering Exceptional Privacy & Endless Possibilities The original part of the home has 2,584 Sq feet and about 1,875 new addition was completed in September 2022 total of 4459 on 2 levels Set approximately 0.7 mile from the road, the property offers a remarkable sense of seclusion and tranquility. Rolling hills, open areas, wooded acreage, and beautiful natural surroundings create a true sanctuary for nature lovers, equestrian enthusiasts, or anyone seeking a private country estate. The residence combines historic character with a comfortable and functional floor plan. A substantial newer addition provides over 1,800 square feet of additional above-grade space, complemented by a large finished lower level of over 1000 square feet with egress windows, creating tremendous flexibility for recreation, entertaining, home offices, guest accommodations, or other uses. The property is exceptionally well equipped for horses and agricultural pursuits, featuring five detached buildings, including two garages, a stallion barn, a 12-stall horse barn with tack room, and a maintenance barn. The expansive acreage and rolling terrain offer wonderful opportunities for private riding trails, pastures, recreation, farming, or simply enjoying the peace and beauty of the land. Whether envisioned as a private equestrian estate, horse boarding operation, trail-riding property, agricultural retreat, recreational sanctuary, or multigenerational country compound, the possibilities here are truly remarkable. With 163.35 acres offered as one parcel, substantial existing infrastructure, incredible privacy, and a setting that is increasingly difficult to find, 3405 Rynex Corners Road presents a rare opportunity to create something truly special. Partial baseboard Heating & partial central heating 7 AC Chimney for wood / pellet stove in the basement. Propane powered Generac, generator included. Wired Internet Do not miss & schedule Now!!

4 Beds ⋅ 4 Baths ⋅ 202626070 MLS

A Rare 163-Acre Estate Offering Exceptional Privacy & Endless Possibilities The original part of the home has 2,584 Sq feet and about 1,875 new addition was completed in September 2022 total of 4459 on 2 levels Set approximately 0.7 mile from the road, the property offers a remarkable sense of seclusion and tranquility. Rolling hills, open areas, wooded acreage, and beautiful natural surroundings create a true sanctuary for nature lovers, equestrian enthusiasts, or anyone seeking a private country estate. The residence combines historic character with a comfortable and functional floor plan. A substantial newer addition provides over 1,800 square feet of additional above-grade space, complemented by a large finished lower level of over 1000 square feet with egress windows, creating tremendous flexibility for recreation, entertaining, home offices, guest accommodations, or other uses. The property is exceptionally well equipped for horses and agricultural pursuits, featuring five detached buildings, including two garages, a stallion barn, a 12-stall horse barn with tack room, and a maintenance barn. The expansive acreage and rolling terrain offer wonderful opportunities for private riding trails, pastures, recreation, farming, or simply enjoying the peace and beauty of the land. Whether envisioned as a private equestrian estate, horse boarding operation, trail-riding property, agricultural retreat, recreational sanctuary, or multigenerational country compound, the possibilities here are truly remarkable. With 163.35 acres offered as one parcel, substantial existing infrastructure, incredible privacy, and a setting that is increasingly difficult to find, 3405 Rynex Corners Road presents a rare opportunity to create something truly special. Partial baseboard Heating & partial central heating 7 AC Chimney for wood / pellet stove in the basement. Propane powered Generac, generator included. Wired Internet Do not miss & schedule Now!!

3405 Rynex Corners Road, Princetown

$1,250,000

Prime redevelopment opportunity in the heart of Downtown Schenectady, offered at $1,250,000. Located along the Erie Boulevard corridor, this approximately 23,000 SF, three-story commercial building presents a unique opportunity for redevelopment, adaptive reuse, or repositioning, with potential for a variety of commercial and mixed-use applications, including residential conversion. The property features approximately 7,500 SF floorplates, three levels of space, and convenient first-floor loading dock access. The building has been exceptionally well maintained and offers strong potential for investors, developers, and owner-users looking to capitalize on the continued revitalization of Downtown Schenectady. Situated in an area benefiting from recent and proposed development initiatives, including support through the City of Schenectady's Strategic Investment Plan and Downtown Revitalization Initiative.

202625867 MLS

Prime redevelopment opportunity in the heart of Downtown Schenectady, offered at $1,250,000. Located along the Erie Boulevard corridor, this approximately 23,000 SF, three-story commercial building presents a unique opportunity for redevelopment, adaptive reuse, or repositioning, with potential for a variety of commercial and mixed-use applications, including residential conversion. The property features approximately 7,500 SF floorplates, three levels of space, and convenient first-floor loading dock access. The building has been exceptionally well maintained and offers strong potential for investors, developers, and owner-users looking to capitalize on the continued revitalization of Downtown Schenectady. Situated in an area benefiting from recent and proposed development initiatives, including support through the City of Schenectady's Strategic Investment Plan and Downtown Revitalization Initiative.

180 Erie Boulevard, Schenectady

$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, Schenectady

$750,000

Well-Maintained 6-Unit Multifamily Investment Opportunity -- $750,000 Fully rented and turnkey, this 6-unit multifamily property offers a stable, income-producing asset with room to grow. Each unit is separately metered with individual electric heat and its own hot water tank, keeping utility costs cleanly divided between tenants. The property also features ample on-site parking for residents, and is located +/- 250 feet from the ALCO Heritage Trail bike path. Currently generating an approximate 6% cap rate, the property presents a clear path to an estimated 8% cap rate through market-rate rent adjustments -- offering investors meaningful upside in both cash flow and long-term value. A well-maintained, fully occupied property with strong fundamentals and clear growth potential. Pro forma available upon request.

12 Beds ⋅ 7 Baths ⋅ 202625284 MLS

Well-Maintained 6-Unit Multifamily Investment Opportunity -- $750,000 Fully rented and turnkey, this 6-unit multifamily property offers a stable, income-producing asset with room to grow. Each unit is separately metered with individual electric heat and its own hot water tank, keeping utility costs cleanly divided between tenants. The property also features ample on-site parking for residents, and is located +/- 250 feet from the ALCO Heritage Trail bike path. Currently generating an approximate 6% cap rate, the property presents a clear path to an estimated 8% cap rate through market-rate rent adjustments -- offering investors meaningful upside in both cash flow and long-term value. A well-maintained, fully occupied property with strong fundamentals and clear growth potential. Pro forma available upon request.

4 River Street, Schenectady

$3,600,000

100% occupied 11 Unit Mixed-Use asset in the heart of Downtown Schenectady. +/- 26,718 sf, 4 story building featuring one (1) studio, five (5) one-bedroom units, five (5) three-bedroom units & one commercial space. Ground floor retail space is occupied by long term tenant with 5 years of term remaining. Property was completely renovated in 2021 featuring industrial, loft-style finishes. Priced at a 7.40% cap rate on in place income and includes a PILOT program in place through 2031. Located in Downtown Schenectady right off State Street; steps from numerous dining and entertainment options. Priced significantly below replacement cost.

202624413 MLS

100% occupied 11 Unit Mixed-Use asset in the heart of Downtown Schenectady. +/- 26,718 sf, 4 story building featuring one (1) studio, five (5) one-bedroom units, five (5) three-bedroom units & one commercial space. Ground floor retail space is occupied by long term tenant with 5 years of term remaining. Property was completely renovated in 2021 featuring industrial, loft-style finishes. Priced at a 7.40% cap rate on in place income and includes a PILOT program in place through 2031. Located in Downtown Schenectady right off State Street; steps from numerous dining and entertainment options. Priced significantly below replacement cost.

132 N Broadway, Schenectady

$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, Rotterdam

$529,999

Beautiful property ready for viewing! Assignment Listing.

5 Beds ⋅ 3 Baths ⋅ 202623797 MLS

Beautiful property ready for viewing! Assignment Listing.

1022 Country Brook Court, Rotterdam

$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 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 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, Niskayuna

$1,600,000

Exceptional opportunity to acquire two fully occupied five-unit apartment buildings offered together as a 10-unit investment portfolio. This turnkey package features a diverse unit mix, strong rental history, and over $220,000 in capital improvements since 2022, including renovated apartments, updated kitchens and baths, refinished hardwood and luxury vinyl flooring, plumbing and mechanical upgrades, exterior painting, and more. Tenants pay their own utilities. Both properties offer off-street parking, with garages at 1114 Union St. Ideally located near Union College, Ellis Hospital, downtown Schenectady, shopping, dining, and major highways. Financials available upon request.

9 Beds ⋅ 6 Baths ⋅ 202621204 MLS

Exceptional opportunity to acquire two fully occupied five-unit apartment buildings offered together as a 10-unit investment portfolio. This turnkey package features a diverse unit mix, strong rental history, and over $220,000 in capital improvements since 2022, including renovated apartments, updated kitchens and baths, refinished hardwood and luxury vinyl flooring, plumbing and mechanical upgrades, exterior painting, and more. Tenants pay their own utilities. Both properties offer off-street parking, with garages at 1114 Union St. Ideally located near Union College, Ellis Hospital, downtown Schenectady, shopping, dining, and major highways. Financials available upon request.

1114 Union Street, Schenectady

$770,000

Welcome to a rare 2.6-acre retreat where lifestyle, privacy, and possibility all come together. Custom-built in 1991 and freshly repainted inside and out, this 4,300 sq ft home blends timeless craftsmanship with modern comfort -- including a heated/insulated attached garage, a second full kitchen, and a heated sunroom with its own indoor garden. One of the home's most charming surprises is found in the finished lower level: a BellSouth payphone that instantly sparks nostalgia and a full bar originally from the legendary Ground Round restaurant -- the perfect conversation pieces for hosting, game nights, or creating your own entertainment space with personality and history. Outdoors, the property unfolds as a place to stretch out, breathe deeper, and settle in. Enjoy a 14-foot-deep, fully stocked pond and powered fountain, surrounded by open lawn and mature trees. The detached 1,300 sq ft heated and insulated garage offers incredible flexibility with a vehicle lift, making it ideal for car collectors, hobbyists, or home-based businesses. A mix of heating sources (oil, propane, electric), forced hot air with central air, well, and septic provide year-round efficiency and peace of mind. With 4 bedrooms, 3 full baths, a half bath, two full kitchens, expansive gathering spaces, and room to stretch out both indoors and out, this is a property designed for comfort, creativity, and lifestyle. 1306 Putnam Road, Schenectady, NY -- a one-of-a-kind setting where memories are made, hobbies thrive, and every day feels a little bit like a retreat. Sq Ft according to the seller / builder plans.

4 Beds ⋅ 3 Baths ⋅ 202618807 MLS

Welcome to a rare 2.6-acre retreat where lifestyle, privacy, and possibility all come together. Custom-built in 1991 and freshly repainted inside and out, this 4,300 sq ft home blends timeless craftsmanship with modern comfort -- including a heated/insulated attached garage, a second full kitchen, and a heated sunroom with its own indoor garden. One of the home's most charming surprises is found in the finished lower level: a BellSouth payphone that instantly sparks nostalgia and a full bar originally from the legendary Ground Round restaurant -- the perfect conversation pieces for hosting, game nights, or creating your own entertainment space with personality and history. Outdoors, the property unfolds as a place to stretch out, breathe deeper, and settle in. Enjoy a 14-foot-deep, fully stocked pond and powered fountain, surrounded by open lawn and mature trees. The detached 1,300 sq ft heated and insulated garage offers incredible flexibility with a vehicle lift, making it ideal for car collectors, hobbyists, or home-based businesses. A mix of heating sources (oil, propane, electric), forced hot air with central air, well, and septic provide year-round efficiency and peace of mind. With 4 bedrooms, 3 full baths, a half bath, two full kitchens, expansive gathering spaces, and room to stretch out both indoors and out, this is a property designed for comfort, creativity, and lifestyle. 1306 Putnam Road, Schenectady, NY -- a one-of-a-kind setting where memories are made, hobbies thrive, and every day feels a little bit like a retreat. Sq Ft according to the seller / builder plans.

1306 Putnam Road, Rotterdam

$349,000

Exceptional opportunity to own a versatile mixed-use retail / warehouse building in a high-visibility, high-traffic location! This +/- 4,400 SF property offers a flexible layout ideal for retail, warehouse, or service-based businesses. Positioned along a major thoroughfare with strong daily traffic counts and excellent exposure, the site provides easy access to Schenectady, Scotia, and Amsterdam. On site parking, room to expand, and much more make this ideal for owner-users or investors. Business can be added in for sale as well and is listed separately. Business is additional $150k. Inventory TBD.

2 Baths ⋅ 202615138 MLS

Exceptional opportunity to own a versatile mixed-use retail / warehouse building in a high-visibility, high-traffic location! This +/- 4,400 SF property offers a flexible layout ideal for retail, warehouse, or service-based businesses. Positioned along a major thoroughfare with strong daily traffic counts and excellent exposure, the site provides easy access to Schenectady, Scotia, and Amsterdam. On site parking, room to expand, and much more make this ideal for owner-users or investors. Business can be added in for sale as well and is listed separately. Business is additional $150k. Inventory TBD.

3304 Amsterdam Road, Schenectady

$199,000

Professional office condominium, over 4400 sq ft located in the Nott Street Medical Arts building attached to Ellis Hospital. Opportunity for medical, dental, psychiatry, nutrition, health & wellness and much more! Consists of large waiting/reception, 2 offices and 8 exam rooms, 3 offices and 4 bathrooms. Also included is 2 private garage spaces. Leasing options available too!

202611780 MLS

Professional office condominium, over 4400 sq ft located in the Nott Street Medical Arts building attached to Ellis Hospital. Opportunity for medical, dental, psychiatry, nutrition, health & wellness and much more! Consists of large waiting/reception, 2 offices and 8 exam rooms, 3 offices and 4 bathrooms. Also included is 2 private garage spaces. Leasing options available too!

1201 Nott Street Suite 102, Schenectady

$575,000

Incredibly versatile beautifully maintained turnkey restaurant. Over 4300 of space on the main level could be divided into multiple spaces and or other businesses, with separate entrances. Currently a fully functioning restaurant, with full bar, cafe seating, a private dining room, and approx. 1200 sq ft that could be additional dining currently or a completely different business. There is also a residential apartment upstairs originally set up to be a 2 BR owners unit or additional offices about 600 Sq ft. The full basement offers offices, a full bath, walk in coolers/freezers, and tons of dry good storage. You couldn't rent this space for what you could own it for, excellent investment opportunity. Just 1/2 mile from Ellis Hospital, 1.5 miles to Rivers and Union College, and 2 miles to Proctors. Sale includes all FFE excepting some personal effects.

4 Baths ⋅ 202610875 MLS

Incredibly versatile beautifully maintained turnkey restaurant. Over 4300 of space on the main level could be divided into multiple spaces and or other businesses, with separate entrances. Currently a fully functioning restaurant, with full bar, cafe seating, a private dining room, and approx. 1200 sq ft that could be additional dining currently or a completely different business. There is also a residential apartment upstairs originally set up to be a 2 BR owners unit or additional offices about 600 Sq ft. The full basement offers offices, a full bath, walk in coolers/freezers, and tons of dry good storage. You couldn't rent this space for what you could own it for, excellent investment opportunity. Just 1/2 mile from Ellis Hospital, 1.5 miles to Rivers and Union College, and 2 miles to Proctors. Sale includes all FFE excepting some personal effects.

2015 Rosa Road, Schenectady

$1,895,000

Welcome to The Mansion at Rebecca's Fountain, where you'll be welcomed by a working fountain with a statue of Rebecca which sets the tone for this beautiful estate. Perched atop more than three secluded acres in Niskayuna, overlooking the Mohawk River, the Estate offers mountain views, refined architecture, and a rare sense of privacy minutes from the finest destinations. Reminiscent of ''Gone with the Wind,'' a grand foyer welcomes you with sweeping dual staircase & a striking 6-foot motorized crystal chandelier that showcases the elegance found throughout the home. Fully furnished by a designer, the approx. 5,000 sqft residence features 7 bedrooms, 3 full baths, sun-filled spaces, soaring ceilings, hardwood floors & oversized windows framing the surrounding landscape. The 1st floor primary suite serves as a serene retreat, featuring a spa-inspired bath w dual sinks, walk-in shower, jetted tub, and an expansive walk-in closet. The gourmet kitchen is ideal for daily living & entertaining, offering a large island, custom cabinetry & seamless flow to a formal dining room with classic millwork. Additional highlights include a sunken Great Room with vaulted ceiling and a floor-to-ceiling LP gas fireplace, first-floor laundry/ Butler's pantry, central air, a two-car side-load garage, and a partially finished lower level that is suitable as 7th bedroom or theater room. An additional 1,720 sqft of unfinished lower-level space (formerly wine storage) offers potential for a gym, game room or other uses. The estate unfolds into a serene oasis with a tranquil pond, custom concrete patio & deck, firepit, and a 7-person spa overlooking apple trees and wildlife. Completing the property is a detached aux building with an existing, legally permitted use for wine tasting & wine sales, offering a rare and distinctive feature that further sets the estate apart. A rare opportunity to own a landmark estate offering timeless elegance, exceptional flexibility, unmatched tranquility.

7 Beds ⋅ 3 Baths ⋅ 202610469 MLS

Welcome to The Mansion at Rebecca's Fountain, where you'll be welcomed by a working fountain with a statue of Rebecca which sets the tone for this beautiful estate. Perched atop more than three secluded acres in Niskayuna, overlooking the Mohawk River, the Estate offers mountain views, refined architecture, and a rare sense of privacy minutes from the finest destinations. Reminiscent of ''Gone with the Wind,'' a grand foyer welcomes you with sweeping dual staircase & a striking 6-foot motorized crystal chandelier that showcases the elegance found throughout the home. Fully furnished by a designer, the approx. 5,000 sqft residence features 7 bedrooms, 3 full baths, sun-filled spaces, soaring ceilings, hardwood floors & oversized windows framing the surrounding landscape. The 1st floor primary suite serves as a serene retreat, featuring a spa-inspired bath w dual sinks, walk-in shower, jetted tub, and an expansive walk-in closet. The gourmet kitchen is ideal for daily living & entertaining, offering a large island, custom cabinetry & seamless flow to a formal dining room with classic millwork. Additional highlights include a sunken Great Room with vaulted ceiling and a floor-to-ceiling LP gas fireplace, first-floor laundry/ Butler's pantry, central air, a two-car side-load garage, and a partially finished lower level that is suitable as 7th bedroom or theater room. An additional 1,720 sqft of unfinished lower-level space (formerly wine storage) offers potential for a gym, game room or other uses. The estate unfolds into a serene oasis with a tranquil pond, custom concrete patio & deck, firepit, and a 7-person spa overlooking apple trees and wildlife. Completing the property is a detached aux building with an existing, legally permitted use for wine tasting & wine sales, offering a rare and distinctive feature that further sets the estate apart. A rare opportunity to own a landmark estate offering timeless elegance, exceptional flexibility, unmatched tranquility.

2820 Balltown Road, Niskayuna

$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, Rotterdam

$575,000

This is income producing property for investors or licensed professionals. Excellent for any professional office space or store with plenty of space to expand. Located on the high traffic road, next to I-88 and I-90. This Veterinary/Medical/ Mixed Use building is well established and emphasizes a strong focus on personalized care. This is a phenomenal potential for continuing Veterinary practice/Medical facility/Dental or Chiropractic clinic. Spacious +/- 2400SF include waiting area, 2 exam rooms, receptionist /waiting area, kennels, lab, cages, surgery, treatment and X-ray rooms with potential for 2nd floor addition and 1.17 acres there are many possibilities for growth. Property includes a +/- 3700SF single-family residence, offering live/work flexibility or supplemental income.

3 Baths ⋅ 202529244 MLS

This is income producing property for investors or licensed professionals. Excellent for any professional office space or store with plenty of space to expand. Located on the high traffic road, next to I-88 and I-90. This Veterinary/Medical/ Mixed Use building is well established and emphasizes a strong focus on personalized care. This is a phenomenal potential for continuing Veterinary practice/Medical facility/Dental or Chiropractic clinic. Spacious +/- 2400SF include waiting area, 2 exam rooms, receptionist /waiting area, kennels, lab, cages, surgery, treatment and X-ray rooms with potential for 2nd floor addition and 1.17 acres there are many possibilities for growth. Property includes a +/- 3700SF single-family residence, offering live/work flexibility or supplemental income.

2241-2275 Duanesburg Road, Princetown

$685,000

Price Reduced!!! Welcome to this modern contemporary 4 bedroom 2.5 bath home on a secluded 56 acre lot. Serene and private although only 5 minutes to 890 and the thruway. 10 minutes to downtown Schenectady. 4000+ sq feet, a 3 car garage, finished space in the basement 2 ponds. Custom kitchen with stainless steel appliances and pot filler. To die for master suite with sitting room walk in closet, jetted tub, glass showier. Cozy house with 7 zone radiant heat and 3 fire places with blowers. Rooftop deck fireplace, with spectacular views of the mohawk valley and downtown Albany on clear days. Wrap around deck with hot tub, Large shed, chicken coop, 2 ponds complete this breath taking property!!

4 Beds ⋅ 3 Baths ⋅ 202528980 MLS

Price Reduced!!! Welcome to this modern contemporary 4 bedroom 2.5 bath home on a secluded 56 acre lot. Serene and private although only 5 minutes to 890 and the thruway. 10 minutes to downtown Schenectady. 4000+ sq feet, a 3 car garage, finished space in the basement 2 ponds. Custom kitchen with stainless steel appliances and pot filler. To die for master suite with sitting room walk in closet, jetted tub, glass showier. Cozy house with 7 zone radiant heat and 3 fire places with blowers. Rooftop deck fireplace, with spectacular views of the mohawk valley and downtown Albany on clear days. Wrap around deck with hot tub, Large shed, chicken coop, 2 ponds complete this breath taking property!!

1243 Waters Road, Glenville

$269,000

518 Hegeman Street - Versatile Commercial / Mixed-Use Building. Discover the potential of this two-story, 4,450± SF commercial building offering exceptional flexibility for a variety of uses. Situated in a convenient and accessible location, the property features multiple offices, classrooms, open meeting areas, a full kitchen, and restrooms on each level. Perfectly suited for daycare, educational, community, or faith-based programs, the layout provides ample room for group activities, administration, and storage. The building's adaptable floor plan also lends itself to office, studio, or small business use, with onsite parking and easy access for staff and visitors. Clean, well-maintained, and ready for its next chapter, 520 Hegeman Street presents a rare opportunity to own a move-in-ready property in a well-established neighborhood. Whether you're expanding your organization or starting something new, this versatile space is ready to accommodate your vision.

202528863 MLS

518 Hegeman Street - Versatile Commercial / Mixed-Use Building. Discover the potential of this two-story, 4,450± SF commercial building offering exceptional flexibility for a variety of uses. Situated in a convenient and accessible location, the property features multiple offices, classrooms, open meeting areas, a full kitchen, and restrooms on each level. Perfectly suited for daycare, educational, community, or faith-based programs, the layout provides ample room for group activities, administration, and storage. The building's adaptable floor plan also lends itself to office, studio, or small business use, with onsite parking and easy access for staff and visitors. Clean, well-maintained, and ready for its next chapter, 520 Hegeman Street presents a rare opportunity to own a move-in-ready property in a well-established neighborhood. Whether you're expanding your organization or starting something new, this versatile space is ready to accommodate your vision.

518 Hegeman Street, Schenectady

$549,900

TURN KEY BUSINESS RESTAURANT & BAR WITH APARTMENT.

3 Baths ⋅ 202527622 MLS

TURN KEY BUSINESS RESTAURANT & BAR WITH APARTMENT.

783 STATE Street 783, Schenectady