Refine Search
Sort by
36 The Concourse, Bethlehem
$649,000
5 Beds ⋅ 4 Baths ⋅ 202626656 MLS
**Rare Opportunity **Maximum Privacy ** Exclusive Triplex together with 5.80 +- Acres in the Town of North Bethlehem with Guilderland Schools ! Tremendous room to roam ! Fantastic Views ! Many Old-Growth Hardwood species throughout the property including Oak, Maple, Poplar, and Hickory to name a few! Property is located at the end of a quiet Dead End street in the Indian Hills Neighborhood . The entrance of the property begins with a 450 foot long Private Road which leads to the 3 Family home and 5 +- additional acres of Super-Private land bordering the Castlewoods Subdivision , high above the Krumkill Creek . Truly, One-of-a-kind ! You be the Judge ! Must see to Believe ! Too much to list . All Buyers must have Buyer Agency Agreements in place prior to All showings . Please do not visit this property without a verified prior appointment . Thankyou .

36 The Concourse, Bethlehem

6161 Depot Road, Guilderland
$749,000
8 Beds ⋅ 4 Baths ⋅ 202626153 MLS
On this Over 110 acre parcel, sits this 4,000 sq. ft. Duplex Perfect for extended families, nature lovers, gentlemen farmers or those seeking privacy. Unit 1 is two floors with a total of 4 bedrooms, 2 full baths. Living Room, Family Room, Large Eat-in Kitchen. Unit 2 is on the second floor with a total of 4 bedrooms, two living rooms, two kitchens and two full baths. Four garage stalls, separate laundry room on first floor. Two separate parcels sold as ''one offering'': 17.75 acres. (013089 49.00-3-2.1) in which the house is located. Another 96.46 acres (013089 49.00-3-10.122) an undeveloped parcel with conservation easement. Units are vacant and all appliances sold ''As is''. Taxes are total for both parcels.

6161 Depot Road, Guilderland

447 Krumkill Road, Guilderland
$1,200,000
10 Beds ⋅ 9 Baths ⋅ 202625639 MLS
Get ready to be amazed...set back in a tranquil & private 1.2 acre setting in the highly coveted Guilderland School District this breathtaking custom estate delivers a staggering 7,847 square feet of finished luxury living space and is designed to effortlessly accommodate multi-generational households, large blended families and elite hosting. The main level immediately captivates w/a stunning open-concept flow anchored by gorgeous hardwood floors & a gourmet kitchen featuring pristine granite countertops, dual islands, double wall ovens, a farmhouse sink, top-notch custom cabintry and sliding glass doors - all seamlessly open to the dining & living spaces and a multi-functional beverage wet bar w/butcher-block counter--ideal for all your large family & entertaining needs--anywhere from an office to a homework, snack & craft station. The main floor features a magnificent primary sanctuary boasting dual walk-in closets & a spa-inspired ensuite w/custom tile, walk-in shower & jetted soaking tub w/motorized pop-up TV. To finish off this level nicely, a handy laundry/mudroom is conveniently situated to the rear of the home. Unmatched flexibility defines the upper levels featuring distinct left & right wings. The left features add'l 2nd flr private primary bdrm & ensuite bath w/dual-sink vanity, 2 more bdrms, a full bathrm & a 3rd-floor bdrm. The spacious right wing is anchored by a central family room--a 3rd primary bdrm suite w/bathrm & walk-in closet, 2 more bdrms, full bath & 3rd flr bdrm w/living area. The finished lower level is a showstopper offering a self contained In-Law APT/proven Airbnb AND a bonus full gym area w/waiting RM, storage closet & its own full bathrm w/shower. Sound wiring, composite decks & porches, gas grill line, outdoor patio/fire pit area & an oversized detached 2-bay garage w/office, bdrm space & 1/2 bath that can fit a 35+ ft boat all round out this luxury listing perfectly. Schedule soon & be in your new home hosting by the holidays!

447 Krumkill Road, Guilderland

6700 Dunnsville Road, Altamont
$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, Altamont

©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