Refine Search
Sort by
$999,900
6 Beds 6 Baths 202619915 MLS
5 Normandy Square, Altamont, is tucked away on a manicured Cul de sac, this home has all the ''I wants'' and more. Much more! Truly needs to be seen to be appreciated and realized. From the moment you enter the soaring 2 story foyer-great room you will recognize details like the double-trayed 18' LED ceiling, the floor to ceiling windows and fireplace you will realize you are not in your average home. The best is yet to come. The Great room opens into a huge gourmet kitchen with a massive island with beverage cooler putting the perfect chill on your favorite beverage. Can't you just picture it, and don't forget the pot filler! The breakfast nook adjacent to the transitional sunroom opens to an expansive covered patio with stunning woodburning lodge fireplace, raftered ceilings with paddle fans, an all-weather TV, and a natural gas fed built in weber grill kitchen area, perfect for relaxing your cares away in any season. This retreat was built for effortless entertainment and the surprises keep coming. Less than 100 feet away is the most flexible space of all, a 40 X 60 (over 2600 mixed sq ft) accessory dwelling unit with recreational center/ small business headquarters. (Seasonal toy storage, or classic cars, a golf simulator, seriously it's a blank slate.) The ADU has a 2 BR apartment (approx. 1000 SqFt) and 1.5 Baths, great for multigenerational living, guests or office for your homebased business. The entire property has a whole house and ADU generator, so you'll always have access to power. In addition to the over 3780 sq ft natural light filled 4 BR , 3.5 BA main house with a first-floor primary suite, and 3 car garage, there is over 5500 sq ft, and a total of 6 BR, and 4 full, and 2 half baths, with unparalleled flex spaces and newer mechanicals. This is the unicorn, that unique property you have been looking for. You have found that dream, say ''AHHH'', you have arrived home.

5 Normandy Square

$5,900,000
202618009 MLS
An extraordinary offering in the heart of the Helderberg foothills, Altamont Orchards represents over 57 years of family farming legacy and one of the most diverse, income-producing agricultural estates in Upstate New York. Situated on historic land deeded as far back as 1792, this multi-faceted property delivers rare depth across hospitality, recreation, retail, and agricultural operations. This remarkable offering encompasses a spectacular working orchard, a beloved farm market and farm stand complete with a bakery, specialty foods, greenhouse, and gift shop, all drawing loyal customers season after season. A craft brewery tenant operating on-site adds yet another layer of energy and income to an already exceptional portfolio and a private residential home provides a live-where-you-work lifestyle on this compound. And then there's the crown jewel, the adjacent Orchard Creek Golf Course, an acclaimed 18-hole championship par-71 public course and proud recipient of NYS Course of the Year. Host unforgettable gatherings here in the three-season banquet space, welcome diners to the full-service Cider House Restaurant, and entertain guests in the signature clubhouse. From dining to pick-your-own apple experiences to championship golf and grand event hosting, this is the rare property where history, community, and opportunity converge. The next steward of this property inherits not just land, but a legacy generations in the making.

6700 Dunnsville Road

$669,900
5 Beds 5 Baths 202617214 MLS
Expansive, multi-generational living, over 4,000 square feet on a double lot on a quiet cul-de-sac within the award-winning Guilderland School Dist. Recent changes to town zoning law now allows for income rental of existing in law suite. Thoughtfully designed residence offers space, privacy, and professional craftsmanship across three finished levels. Kitchen w/tiled back splash, SS Appliances, island and pantry. Spacious dining room with hw flrs and chair rail provides the perfect setting for gatherings. Multiple living rooms offer endless possibilities. LR 1 is full of natural light. The brick FP with wood stove insert which will heat the house. Light a fire and host game night, movie, or a quiet place to read. LR 2 has a brick FP w\ gas insert providing warmth and comfort. This area leads to the upstairs In-Law suite. The main residence offers 4 bedrooms, 2 full baths,1/2 bath,2 living rooms, a formal dining room and home office. The 2 flr primary suite offers walk in closet, an en-suite bath with tiled shower, double sink and sky lights which brings natural light into this spacious bath. The 2nd flr full bath is exquisitely tiled, jet tub, and dual granite sinks. In-law apartment has its own entrance. The extra wide staircase leads to the in-law living room with custom made built-ins. The in-law sun room is a tranquil retreat with views of the private, tree lined backyard. In-Law full bath with a tiled walk-in shower and dual sink. Full eat in kitchen. Finished basement offers another whole level of living space w/ 1/2 bath. Enjoy the game around the custom made bar. Oversized 2 car garage leads to large mud room with custom made cubbies. Yard backs to forever wild, providing privacy amongst suburban conveniences. Enjoy hiking trails that meander through the woods beside a stream. Stroll streets lined w/old-fashioned Colonial-style lampposts and custom street signs. Walk to shops/restaurants. A true a multi-generational home in a location that cannot be beat.

573 Jefferson Court

$635,000
4 Beds 3 Baths 202610778 MLS
Welcome to this to-be-built Colonial home with late Summer 2026 completion, showcasing refined craftsmanship and modern design in the award-winning Guilderland School District. This 4-bedroom, 2.5-bath home features 9-foot first-floor ceilings, an open-concept layout, and abundant natural light. Enjoy luxury vinyl flooring, quartz countertops throughout, a gas fireplace, first-floor den, walk-in pantry, mudroom, and convenient second-floor laundry. The spacious primary suite includes dual walk-in closets. Additional highlights include tiled baths, a covered front porch, landscaping package, public utilities, an open basement ready for future finishing, and a two-car garage. Situated on a private lot with ambiance on a .74-acre lot that offers over 400' of depth and a picturesque babbling brook. Broker/owner. Photos shown are from prior builds.

5987 State Farm Road

$698,540
4 Beds 3 Baths 202610710 MLS
Set on an expansive 1.60-acre lot, the home offers a sense of privacy and outdoor enjoyment that is increasingly hard to find in established suburban neighborhoods. An attached two-car garage and a fully finished basement add functionality, storage, and additional living space, enhancing overall usability and long-term value. The neighborhood is characterized by primarily one-unit residential homes and is considered stable, with balanced supply and demand. The area benefits from convenient access to major roadways, including Western Avenue, Washington Avenue, and Interstate 87, typically within a short drive, making regional commuting and travel efficient. Nearby schools, parks, shopping, and employment centers further support everyday convenience and livability.

14 Rizzo Lane

©2019 Global Multiple Listing Service, Inc. The data relating to real estate on this website comes in part from the Internet Data Exchange program of the GMLS. All information is deemed reliable but not guaranteed and should be independently verified. All properties subject to prior sale, change, or withdrawal. Neither listing broker(s), GMLS shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless from any damages arising from reliance upon these data. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties they may be interested in purchasing. Data last updated