Reddoorrealtyny.com Search Results

$495,000

Welcome to 2517 Antonia Dr in the sought-after Niskayuna School District. This exceptional 4-bedroom, 2.5-bath Colonial offers over 2,400 sq. ft. of beautifully appointed living space, set on a picturesque 0.46-acre lot. From the moment you arrive, you'll feel the quality and charm of a home designed for comfort, style, and easy entertaining. Inside, the bright, inviting layout flows effortlessly through multiple living areas, creating ideal spaces for both everyday living and special gatherings. Gather around the warm glow of the cozy fireplace, enjoy generous room sizes, and discover a functional layout that elevates daily routines. A full basement adds even more possibilities--perfect for future finishing, storage, or a tailored recreation space--while the attached 2-car garage provides added convenience. Outside, enjoy a serene, quiet residential setting with ample outdoor space to relax, garden, or host summer get-togethers. Plus, you're just minutes from local schools, shopping, dining, and parks--making it the perfect blend of privacy and convenience. Comfortable living, conveniently located: Albany International Airport: Less than 20 minutes Local hospitals (area): 15-25 minutes Area universities: 15-35 minutes

4 Beds ⋅ 3 Baths ⋅ 202622503 MLS

2517 Antonia Drive

$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

2820 Balltown Road