Mycapitalregionhomes.com Search Results

$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!

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!

37 Covington Court

$1,650,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

$3,000,000

A rare downtown Schenectady investment and redevelopment opportunity comprising approximately 45,322 square feet situated on 1.20 acres across four tax parcels. Prominently located at the intersection of State Street, South Ferry Street, and Erie Boulevard, the property offers extensive on-site parking, flexible office and community facility space, elevator access, and highly desirable C-4 Downtown Commercial Mixed-Use zoning that permits a broad range of office, medical, educational, multifamily, hospitality, retail, and mixed-use uses.

202620541 MLS

A rare downtown Schenectady investment and redevelopment opportunity comprising approximately 45,322 square feet situated on 1.20 acres across four tax parcels. Prominently located at the intersection of State Street, South Ferry Street, and Erie Boulevard, the property offers extensive on-site parking, flexible office and community facility space, elevator access, and highly desirable C-4 Downtown Commercial Mixed-Use zoning that permits a broad range of office, medical, educational, multifamily, hospitality, retail, and mixed-use uses.

214 State Street

$2,150,000

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.

202613733 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

$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

$1,990,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

$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

$549,900

TURN KEY BUSINESS RESTAURANT & BAR WITH APARTMENT.

3 Baths ⋅ 202527622 MLS

TURN KEY BUSINESS RESTAURANT & BAR WITH APARTMENT.

783 STATE Street 783