Mycapitalregionhomes.com Search Results

Prime Corner Development Opportunity - Rotterdam, NY Positioned at a signalized intersection in the heart of Rotterdam, this ±44,000 SF corner lot offers exceptional visibility and strong daily traffic counts with immediate access to Route 9. The site presents a highly flexible development opportunity ideal for retail, office, or service-oriented users, with ample space for parking, signage, and efficient site layout. Surrounded by established national retailers and dense residential neighborhoods, the location supports a wide range of uses including medical, wellness, fitness, childcare, personal care, and fast-casual concepts. A rare opportunity to secure a highly visible corner site in a proven commercial corridor--perfect for users and developers seeking long-term growth and consistent traffic exposure.

202628277 MLS

Prime Corner Development Opportunity - Rotterdam, NY Positioned at a signalized intersection in the heart of Rotterdam, this ±44,000 SF corner lot offers exceptional visibility and strong daily traffic counts with immediate access to Route 9. The site presents a highly flexible development opportunity ideal for retail, office, or service-oriented users, with ample space for parking, signage, and efficient site layout. Surrounded by established national retailers and dense residential neighborhoods, the location supports a wide range of uses including medical, wellness, fitness, childcare, personal care, and fast-casual concepts. A rare opportunity to secure a highly visible corner site in a proven commercial corridor--perfect for users and developers seeking long-term growth and consistent traffic exposure.

1874 Altamont Avenue, Rotterdam

$499,000

Rare redevelopment opportunity in the Town of Rotterdam! Former Dutch Manor nursing home offering approximately 35,000 SF of existing building space situated on 2.77 acres along Hamburg Street. This expansive single-story property presents tremendous potential for rehabilitation, adaptive reuse, or redevelopment. Previously operated as a nursing home, the property may appeal to investors, developers, and institutional operators seeking a large-scale project. Features extensive paved parking areas, multiple building wings, and municipal water and sewer. Property requires significant renovation and is being sold as-is. All proposed uses subject to municipal approvals.

202628129 MLS

Rare redevelopment opportunity in the Town of Rotterdam! Former Dutch Manor nursing home offering approximately 35,000 SF of existing building space situated on 2.77 acres along Hamburg Street. This expansive single-story property presents tremendous potential for rehabilitation, adaptive reuse, or redevelopment. Previously operated as a nursing home, the property may appeal to investors, developers, and institutional operators seeking a large-scale project. Features extensive paved parking areas, multiple building wings, and municipal water and sewer. Property requires significant renovation and is being sold as-is. All proposed uses subject to municipal approvals.

1940 Hamburg Street, Schenectady

$799,999

144-146 Vley Road presents a unique multifamily investment opportunity in the Village of Scotia, consisting of seven residential apartments across two buildings, separate third-floor space currently configured as an open office, and an approximately 3,000-square-foot warehouse/storage building. Multifamily properties of this size are infrequently available within the Scotia market, offering investors a rare opportunity to acquire a larger income-producing asset in an established residential community. The property features five (5) two-bedroom and two (2) one-bedroom apartments and has maintained strong, long-term occupancy, with leasing handled through a licensed real estate professional and current residents in place under written lease agreements. The owner has continued to reinvest in the apartments over time, including kitchen and bathroom updates, two new apartments within 146 Vley Road, and a new front porch at 144 Vley Road. A particularly unique feature is the approximately 3,000-square-foot warehouse/storage building, offering substantial utility and potential for additional income. With seven residential units, a history of strong occupancy, continued reinvestment, separate office space, and substantial warehouse/storage space, the property combines an established multifamily investment with opportunities for continued income and value growth. Its Scotia location and limited availability of comparable multifamily properties within the Village further distinguish this offering. Please note: 144 Vley Road and 146 Vley Road are separate tax parcels being offered and sold together as one transaction.

12 Beds ⋅ 7 Baths ⋅ 202627559 MLS

144-146 Vley Road presents a unique multifamily investment opportunity in the Village of Scotia, consisting of seven residential apartments across two buildings, separate third-floor space currently configured as an open office, and an approximately 3,000-square-foot warehouse/storage building. Multifamily properties of this size are infrequently available within the Scotia market, offering investors a rare opportunity to acquire a larger income-producing asset in an established residential community. The property features five (5) two-bedroom and two (2) one-bedroom apartments and has maintained strong, long-term occupancy, with leasing handled through a licensed real estate professional and current residents in place under written lease agreements. The owner has continued to reinvest in the apartments over time, including kitchen and bathroom updates, two new apartments within 146 Vley Road, and a new front porch at 144 Vley Road. A particularly unique feature is the approximately 3,000-square-foot warehouse/storage building, offering substantial utility and potential for additional income. With seven residential units, a history of strong occupancy, continued reinvestment, separate office space, and substantial warehouse/storage space, the property combines an established multifamily investment with opportunities for continued income and value growth. Its Scotia location and limited availability of comparable multifamily properties within the Village further distinguish this offering. Please note: 144 Vley Road and 146 Vley Road are separate tax parcels being offered and sold together as one transaction.

144-146 Vley Road, Scotia

$675,000

Excellent opportunity in the heart of downtown Schenectady! Offering nearly 6,000 SF of versatile commercial space, this well-established property features solid brick, block and steel construction, 15' ceilings, three overhead doors, multiple office areas, showroom space and a finished second level. The property has a long history of successful commercial use, including an alternative heating company that operated from the showroom for over 25 years, as well as an auto body shop with current NYS Dealer & Repair Shop licenses. The flexible layout and existing features lend themselves to a variety of automotive, retail, service or other commercial uses. Recent improvements include new insulation and fresh exterior paint. Conveniently located near Union College, downtown businesses, restaurants, Proctors, Rivers Casino and major highways. Bring your vision to this unique property in an area that continues to see redevelopment and growth.

3 Baths ⋅ 202627500 MLS

Excellent opportunity in the heart of downtown Schenectady! Offering nearly 6,000 SF of versatile commercial space, this well-established property features solid brick, block and steel construction, 15' ceilings, three overhead doors, multiple office areas, showroom space and a finished second level. The property has a long history of successful commercial use, including an alternative heating company that operated from the showroom for over 25 years, as well as an auto body shop with current NYS Dealer & Repair Shop licenses. The flexible layout and existing features lend themselves to a variety of automotive, retail, service or other commercial uses. Recent improvements include new insulation and fresh exterior paint. Conveniently located near Union College, downtown businesses, restaurants, Proctors, Rivers Casino and major highways. Bring your vision to this unique property in an area that continues to see redevelopment and growth.

111 Nott Terrace, Schenectady

$670,000

CASH FLOW & VALUE-ADD OPPORTUNITY! Investors, take notice! This mixed-use Schenectady property offers multiple income streams and substantial upside potential. The first floor features two retail storefronts, with one currently leased and producing income. The upper levels include five apartments, all currently rented, Whether you're expanding your portfolio or looking for your next investment project, 881 Albany St. presents an opportunity to build equity and increase cash flow through strategic leasing and management. Bring your investment strategy and capitalize on the existing income and available upside!

202627363 MLS

CASH FLOW & VALUE-ADD OPPORTUNITY! Investors, take notice! This mixed-use Schenectady property offers multiple income streams and substantial upside potential. The first floor features two retail storefronts, with one currently leased and producing income. The upper levels include five apartments, all currently rented, Whether you're expanding your portfolio or looking for your next investment project, 881 Albany St. presents an opportunity to build equity and increase cash flow through strategic leasing and management. Bring your investment strategy and capitalize on the existing income and available upside!

881 Albany Street, Schenectady

$1,575,000

Pleased to present 8-16 Swan Street, a 15-unit multifamily portfolio spanning three buildings in Schenectady. The property offers established in-place income with meaningful upside through multiple channels, including below-market rents, a largely flexible rent roll, an underutilized coin-operated laundry facility, substantial off-street parking, and a separate storage building. Separate tenant-paid utilities provide a strong operating foundation, while the scale of the portfolio and concentration of additional income opportunities give new ownership several clear paths to grow NOI. Conveniently located near Downtown Schenectady, I-890, Union College, and significant ongoing investment throughout the surrounding area.

44 Beds ⋅ 15 Baths ⋅ 202626865 MLS

Pleased to present 8-16 Swan Street, a 15-unit multifamily portfolio spanning three buildings in Schenectady. The property offers established in-place income with meaningful upside through multiple channels, including below-market rents, a largely flexible rent roll, an underutilized coin-operated laundry facility, substantial off-street parking, and a separate storage building. Separate tenant-paid utilities provide a strong operating foundation, while the scale of the portfolio and concentration of additional income opportunities give new ownership several clear paths to grow NOI. Conveniently located near Downtown Schenectady, I-890, Union College, and significant ongoing investment throughout the surrounding area.

8-16 Swan Street, Schenectady

$349,000

NYC Investors! OPPORTUNITY MIX USE BUILDING! Look at this Former All Brick Fire House! First Floor has tons of Commercial Potential. 2nd Floor has potential for LOFT style Apartments. Tons of space for Parking. This is a must see Asset! Call to view today!

6 Beds ⋅ 2 Baths ⋅ 202626495 MLS

NYC Investors! OPPORTUNITY MIX USE BUILDING! Look at this Former All Brick Fire House! First Floor has tons of Commercial Potential. 2nd Floor has potential for LOFT style Apartments. Tons of space for Parking. This is a must see Asset! Call to view today!

907 Albany Street, Schenectady

$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 gas furnace 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 gas furnace 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

$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

$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

$555,000

A one of a kind gentleman property build in 1950(continuously renovated ), uniquely situated on 1.17 acres along high-visibility Rt 7, next to Rotterdam & I-88/I-90 Exit. This inviting +/- 3700 sq. ft. 3 Bedroom, 2 bath home sits beside a mixed use commercial building- perfect for those seeking live - work convenience, additional rental income and provides compelling alternative to traditional commuting & leasing arrangement. Next door, the +/-2400 sq. ft. commercial structure has been thoughtfully designed for professional use and features multiple rooms that can adapt to a variety of business or studio needs. Whether you're looking for a home with workspace, an investment property or room to expand, this unique setup delivers endless options.

6 Beds ⋅ 3 Baths ⋅ 202529611 MLS

A one of a kind gentleman property build in 1950(continuously renovated ), uniquely situated on 1.17 acres along high-visibility Rt 7, next to Rotterdam & I-88/I-90 Exit. This inviting +/- 3700 sq. ft. 3 Bedroom, 2 bath home sits beside a mixed use commercial building- perfect for those seeking live - work convenience, additional rental income and provides compelling alternative to traditional commuting & leasing arrangement. Next door, the +/-2400 sq. ft. commercial structure has been thoughtfully designed for professional use and features multiple rooms that can adapt to a variety of business or studio needs. Whether you're looking for a home with workspace, an investment property or room to expand, this unique setup delivers endless options.

2241-2275 Duanesburg Road, Princetown

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

How much is your home worth?

How much is your home worth?