Carrrealestategroupllc.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! The dining room light fixture is excluded.

4 Beds ⋅ 5 Baths ⋅ 202622935 MLS

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

37 Covington Court

$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

$1,400,000

Discover timeless elegance and modern comforts in this extraordinary one-owner, custom-built 4-bedroom, 3 full and 3 half bath residence set on 1.37 acres of lushly landscaped grounds. A sweeping staircase makes a dramatic first impression, leading to a home designed for both entertaining and comfortable living. The main level offers a gracious formal living room with a gas fireplace, an expansive dining room with its own fireplace, and two offices with custom built-in bookcases—one with a private outside entry, perfect for working from home. The chef's kitchen is the heart of the home, featuring granite counters, an oversized center island, abundant cabinetry, and tile floors, flowing seamlessly into the 4-season sunroom and the soaring family room with a wall of windows. Upstairs, the luxurious primary suite boasts a cozy gas fireplace, a fully renovated modern bath, and large his-and-hers walk-in closets. The Jack and Jill bath and guest bathroom have also been beautifully renovated with tasteful finishes. A versatile bonus room provides the perfect space for an art studio, yoga retreat, or potential in-law suite. A second staircase and a private elevator add to the home's thoughtful design. Radiant heat in the sunroom, primary bath, and front and rear deck walkways. The lower level is an entertainer's dream, complete with a wine cellar, bar, dance floor, billiard room, half bath, and another family room with a cozy fireplace. Step outside to your own resort-style oasis, featuring a sparkling inground pool, expansive patio, and deck surrounded by beautifully manicured landscaping. This rare offering blends privacy, luxury, and lifestyle, creating a place to build lasting memories.

4 Beds ⋅ 6 Baths ⋅ 202526075 MLS

Discover timeless elegance and modern comforts in this extraordinary one-owner, custom-built 4-bedroom, 3 full and 3 half bath residence set on 1.37 acres of lushly landscaped grounds. A sweeping staircase makes a dramatic first impression, leading to a home designed for both entertaining and comfortable living. The main level offers a gracious formal living room with a gas fireplace, an expansive dining room with its own fireplace, and two offices with custom built-in bookcases—one with a private outside entry, perfect for working from home. The chef's kitchen is the heart of the home, featuring granite counters, an oversized center island, abundant cabinetry, and tile floors, flowing seamlessly into the 4-season sunroom and the soaring family room with a wall of windows. Upstairs, the luxurious primary suite boasts a cozy gas fireplace, a fully renovated modern bath, and large his-and-hers walk-in closets. The Jack and Jill bath and guest bathroom have also been beautifully renovated with tasteful finishes. A versatile bonus room provides the perfect space for an art studio, yoga retreat, or potential in-law suite. A second staircase and a private elevator add to the home's thoughtful design. Radiant heat in the sunroom, primary bath, and front and rear deck walkways. The lower level is an entertainer's dream, complete with a wine cellar, bar, dance floor, billiard room, half bath, and another family room with a cozy fireplace. Step outside to your own resort-style oasis, featuring a sparkling inground pool, expansive patio, and deck surrounded by beautifully manicured landscaping. This rare offering blends privacy, luxury, and lifestyle, creating a place to build lasting memories.

70 Dublin Drive

$800,000

Step back in time and experience the grandeur of this exquisite estate in the heart of Niskayuna. Spanning 6,784 sq. ft. on 4.5 acres, this remarkable home will seamlessly blend historical charm w/your idea of modern conveniences. Boasting 6 BRs, 5.5 BA & a 6-car garage, it features a stunning grand foyer, an elegant library, & an elevator for ultimate convenience. Throughout, you'll find breathtaking architectural details, rich HW floors, an inviting conservatory room located just off the formal DR, featuring a custom fireplace & elegant arched doorways. Ideally situated in a prime location, this estate is just moments from the prestigious Mohawk Golf Club, offering access to numerous local amenities. A rare opportunity to own a piece of history & add your own personal touch!

6 Beds ⋅ 6 Baths ⋅ 202518457 MLS

Step back in time and experience the grandeur of this exquisite estate in the heart of Niskayuna. Spanning 6,784 sq. ft. on 4.5 acres, this remarkable home will seamlessly blend historical charm w/your idea of modern conveniences. Boasting 6 BRs, 5.5 BA & a 6-car garage, it features a stunning grand foyer, an elegant library, & an elevator for ultimate convenience. Throughout, you'll find breathtaking architectural details, rich HW floors, an inviting conservatory room located just off the formal DR, featuring a custom fireplace & elegant arched doorways. Ideally situated in a prime location, this estate is just moments from the prestigious Mohawk Golf Club, offering access to numerous local amenities. A rare opportunity to own a piece of history & add your own personal touch!

2125 Rosendale Road

$1,100,000

Meticulously maintained custom built Sotile Tudor on a 3.88 acre Estate lot in a desirable Baldwin Farms Niskayuna neighborhood. The stunning tiled foyer leads to the spacious living area, with a convenient first floor primary suite with full bath and walk through closet, library with f/p and custom coffered ceiling, living room with f/p, formal dining room and family room with f/p. The gourmet kitchen with eating area, island and wet bar leads to the enjoyable conservatory. Two 1/2 baths and laundry complete the 1st floor. The 2nd floor has 3 generous size bedrooms each with a full bath, a sewing room, exercise room and sitting area. There is an oversized 3 car attached garage with radiant heated floors in addition to the 48X32 heated detached showroom style garage for your toys

4 Beds ⋅ 6 Baths ⋅ 202421578 MLS

Meticulously maintained custom built Sotile Tudor on a 3.88 acre Estate lot in a desirable Baldwin Farms Niskayuna neighborhood. The stunning tiled foyer leads to the spacious living area, with a convenient first floor primary suite with full bath and walk through closet, library with f/p and custom coffered ceiling, living room with f/p, formal dining room and family room with f/p. The gourmet kitchen with eating area, island and wet bar leads to the enjoyable conservatory. Two 1/2 baths and laundry complete the 1st floor. The 2nd floor has 3 generous size bedrooms each with a full bath, a sewing room, exercise room and sitting area. There is an oversized 3 car attached garage with radiant heated floors in addition to the 48X32 heated detached showroom style garage for your toys

10 Covington Ct.

$890,000

Welcome to 1230 Milton Keynes! A distinctive, desirable and stunningly unique Niskayuna Custom Contemporary with the most dramatic design style and multiple levels of incredible living space! This impressive & modern home features a functional and fabulous floor plan with 4+bedrooms, 5.5 baths, 3 fireplaces and so much more! Striking foyer with sweeping staircases! Large great room. Formal dining room. Spacious gourmet kitchen. Family room. Sunroom. Office. Full & half bath. Upper level: Primary suite with spa like bath & dressing room. 3 additional bedrooms & 2 full baths. Laundry room. Bonus space. Lower level: Flexible space with kitchen & full bath. Sited on a lovely landscaped 1.88 +/- acre with expansive deck & sparkling inground pool! Niskayuna Schools. Convenient location!

5 Beds ⋅ 6 Baths ⋅ 202320715 MLS

Welcome to 1230 Milton Keynes! A distinctive, desirable and stunningly unique Niskayuna Custom Contemporary with the most dramatic design style and multiple levels of incredible living space! This impressive & modern home features a functional and fabulous floor plan with 4+bedrooms, 5.5 baths, 3 fireplaces and so much more! Striking foyer with sweeping staircases! Large great room. Formal dining room. Spacious gourmet kitchen. Family room. Sunroom. Office. Full & half bath. Upper level: Primary suite with spa like bath & dressing room. 3 additional bedrooms & 2 full baths. Laundry room. Bonus space. Lower level: Flexible space with kitchen & full bath. Sited on a lovely landscaped 1.88 +/- acre with expansive deck & sparkling inground pool! Niskayuna Schools. Convenient location!

1230 Milton Keynes Drive

$600,000

Relocate your business to this prime commercial building in the highly desirable Upper Union area of Schenectady/Niskayuna. Rock-solid & handsome brick building stands two stories with ample & easy parking for 35 vehicles. Building totals 5,457 sq ft w/ top-notch remodeled office space for medical, retail, mixed use. Beautiful entry lobby w/ slate floors & brick walls. New flooring, acoustic-tile ceilings, skylights, remodeled kitchen area, conference rooms, central air, outdoor waiting area. Cannot beat this location or property condition. Definitely a head-turning opportunity.

202320433 MLS

Relocate your business to this prime commercial building in the highly desirable Upper Union area of Schenectady/Niskayuna. Rock-solid & handsome brick building stands two stories with ample & easy parking for 35 vehicles. Building totals 5,457 sq ft w/ top-notch remodeled office space for medical, retail, mixed use. Beautiful entry lobby w/ slate floors & brick walls. New flooring, acoustic-tile ceilings, skylights, remodeled kitchen area, conference rooms, central air, outdoor waiting area. Cannot beat this location or property condition. Definitely a head-turning opportunity.

2141 Eastern Parkway