Klrealestateservices.com Search Results

Exceptional luxury residence offering exquisite craftsmanship, generous living spaces and resort-style amenities. Grand marble foyer, elegant formal dining room, refined parlor and spectacular two-story family room with soaring ceilings and expansive windows overlooking the pool. Gourmet kitchen features quartzite countertops, premium appliances, coffered ceiling and butler's pantry. First-floor guest suite with private bath, two powder rooms and laundry/mudroom. Five garage spaces, including heated attached and detached garages. Luxurious primary suite features a three-sided fireplace, private sitting room with wet bar, spa-inspired bath with radiant floors and custom his-and-her California Closets. Finished lower level offers a home theater, recreation room, full bar and wine cellar. Magnificent heated gunite pool with hot tub, waterfall, slide and grotto, surrounded by bluestone patios, outdoor kitchen and two-level pool house. Fire pit and children's play area complete this extraordinary property.

5 Beds ⋅ 8 Baths ⋅ 202627949 MLS

Exceptional luxury residence offering exquisite craftsmanship, generous living spaces and resort-style amenities. Grand marble foyer, elegant formal dining room, refined parlor and spectacular two-story family room with soaring ceilings and expansive windows overlooking the pool. Gourmet kitchen features quartzite countertops, premium appliances, coffered ceiling and butler's pantry. First-floor guest suite with private bath, two powder rooms and laundry/mudroom. Five garage spaces, including heated attached and detached garages. Luxurious primary suite features a three-sided fireplace, private sitting room with wet bar, spa-inspired bath with radiant floors and custom his-and-her California Closets. Finished lower level offers a home theater, recreation room, full bar and wine cellar. Magnificent heated gunite pool with hot tub, waterfall, slide and grotto, surrounded by bluestone patios, outdoor kitchen and two-level pool house. Fire pit and children's play area complete this extraordinary property.

611 Bedford Square, Albany

$499,000

INVESTMENT OPPORTUNITY IN THE GUILDERLAND SCHOOL DISTRICT! This expansive Altamont duplex offers two spacious 1,600+ sq. ft. units, each with the potential for three bedrooms, a full bath, in-unit laundry, kitchen, living room, and private back deck. Beyond the two residential units, the property features an attached three-bay garage with loft space above, plus additional bonus space behind the garage with a half bath—providing intriguing potential for additional usable or income-producing space, subject to municipal approvals, while potentially retaining the garage bays. Situated on a .49-acre lot backing to forever-wild land, the property offers a private backyard with seasonal fruit trees. Even better, the solar panels are OWNED outright and transfer with the sale, providing long-term value without a solar lease. Significant capital improvements have already been completed, including a new driveway (2026), two new garage doors (2026), new oil tank (2025), new electrical panel (2024), hot water tanks (2023 & 2024), updated flooring, sheetrock, and more. With two substantial units, extensive garage and bonus space, owned solar, major recent improvements, and potential for further value creation, this is a compelling opportunity for an investor or owner-occupant looking to build equity in the Guilderland School District.

5 Beds ⋅ 2 Baths ⋅ 202627740 MLS

INVESTMENT OPPORTUNITY IN THE GUILDERLAND SCHOOL DISTRICT! This expansive Altamont duplex offers two spacious 1,600+ sq. ft. units, each with the potential for three bedrooms, a full bath, in-unit laundry, kitchen, living room, and private back deck. Beyond the two residential units, the property features an attached three-bay garage with loft space above, plus additional bonus space behind the garage with a half bath—providing intriguing potential for additional usable or income-producing space, subject to municipal approvals, while potentially retaining the garage bays. Situated on a .49-acre lot backing to forever-wild land, the property offers a private backyard with seasonal fruit trees. Even better, the solar panels are OWNED outright and transfer with the sale, providing long-term value without a solar lease. Significant capital improvements have already been completed, including a new driveway (2026), two new garage doors (2026), new oil tank (2025), new electrical panel (2024), hot water tanks (2023 & 2024), updated flooring, sheetrock, and more. With two substantial units, extensive garage and bonus space, owned solar, major recent improvements, and potential for further value creation, this is a compelling opportunity for an investor or owner-occupant looking to build equity in the Guilderland School District.

6778 State Route 158, Altamont

3062 New Williamsburg Drive, Guilderland

$750,000

From the moment you arrive, this home makes an impression. Set in a beautiful, walkable neighborhood within the award-winning Guilderland School District, this remarkable **5-bedroom, 3-bathroom home** offers an incredible combination of space, character, thoughtful updates, and location. Step inside and you'll immediately see how well this home has been loved and maintained. Hardwood floors, abundant living space, and thoughtful improvements throughout make this a home that is truly move-in ready. Outside, the property feels like its own retreat, with beautifully maintained grounds, a patio made for gathering, and a pool ready for summer days at home. The location gives you the best of both worlds: a neighborhood where you can get out and walk, great restaurants and everyday conveniences nearby, and easy access to major highways. Head in the other direction and you're quickly surrounded by the beautiful countryside and charm of Altamont. With **five bedrooms, three full bathrooms**, plenty of room to spread out, and a property that has been thoughtfully cared for and continuously improved, this is a home that truly needs to be experienced in person. **Please see attachments for a complete list of the many upgrades and improvements made to the home.**

5 Beds ⋅ 3 Baths ⋅ 202627339 MLS

From the moment you arrive, this home makes an impression. Set in a beautiful, walkable neighborhood within the award-winning Guilderland School District, this remarkable **5-bedroom, 3-bathroom home** offers an incredible combination of space, character, thoughtful updates, and location. Step inside and you'll immediately see how well this home has been loved and maintained. Hardwood floors, abundant living space, and thoughtful improvements throughout make this a home that is truly move-in ready. Outside, the property feels like its own retreat, with beautifully maintained grounds, a patio made for gathering, and a pool ready for summer days at home. The location gives you the best of both worlds: a neighborhood where you can get out and walk, great restaurants and everyday conveniences nearby, and easy access to major highways. Head in the other direction and you're quickly surrounded by the beautiful countryside and charm of Altamont. With **five bedrooms, three full bathrooms**, plenty of room to spread out, and a property that has been thoughtfully cared for and continuously improved, this is a home that truly needs to be experienced in person. **Please see attachments for a complete list of the many upgrades and improvements made to the home.**

3062 New Williamsburg Drive, Guilderland

$649,000

**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 .

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

$450,000

Expanded Raised Ranch with 4 BR's and 3 full baths. Open floor plan with newer kitchen. 2 full baths on main level with 1 on lower level. Fireplace on each level. Sliding glass door from kitchen to screened porch. Sliding glass doors from one bedroom to trex deck and sliding glass door from family room to trex deck and staircase to inground pool. Located minutes from Northway, Rt. 90, shopping, medical facilities, colleges.

4 Beds ⋅ 3 Baths ⋅ 202625810 MLS

Expanded Raised Ranch with 4 BR's and 3 full baths. Open floor plan with newer kitchen. 2 full baths on main level with 1 on lower level. Fireplace on each level. Sliding glass door from kitchen to screened porch. Sliding glass doors from one bedroom to trex deck and sliding glass door from family room to trex deck and staircase to inground pool. Located minutes from Northway, Rt. 90, shopping, medical facilities, colleges.

10 Kaine Drive, Guilderland

$799,000

Welcome to exceptional living in sought-after Kennewyck! This meticulously maintained Marini-built home is nestled on a quiet cul-de-sac in the Guilderland School District and set on nearly an acre of beautifully appointed grounds. From the moment you arrive, the attention to detail is evident. Inside, gleaming hardwood floors, soaring cathedral ceilings, and a striking double-sided fireplace create an inviting yet sophisticated atmosphere. The updated kitchen features granite countertops and coordinating granite flooring, while the spacious sunroom offers a peaceful retreat and opens seamlessly to the newer Trex deck. Step outside and discover your own private summer oasis, complete with an in-ground saltwater pool and charming gazebo entertaining area--perfect for poolside afternoons, sunset gatherings, and making the most of warm summer evenings. The first-floor primary suite offers a luxurious retreat with a spacious bath and walk-in closet. A versatile lower-level bonus room provides additional space for a home office, guest accommodations, nursery, or recreation. With a brand-new HVAC system, newer hot water heater, and meticulous care throughout, this exceptional property is ready to be enjoyed. A rare opportunity to experience comfort, elegance, and effortless indoor-outdoor living in one of Guilderland's most desirable communities.

4 Beds ⋅ 4 Baths ⋅ 202625195 MLS

Welcome to exceptional living in sought-after Kennewyck! This meticulously maintained Marini-built home is nestled on a quiet cul-de-sac in the Guilderland School District and set on nearly an acre of beautifully appointed grounds. From the moment you arrive, the attention to detail is evident. Inside, gleaming hardwood floors, soaring cathedral ceilings, and a striking double-sided fireplace create an inviting yet sophisticated atmosphere. The updated kitchen features granite countertops and coordinating granite flooring, while the spacious sunroom offers a peaceful retreat and opens seamlessly to the newer Trex deck. Step outside and discover your own private summer oasis, complete with an in-ground saltwater pool and charming gazebo entertaining area--perfect for poolside afternoons, sunset gatherings, and making the most of warm summer evenings. The first-floor primary suite offers a luxurious retreat with a spacious bath and walk-in closet. A versatile lower-level bonus room provides additional space for a home office, guest accommodations, nursery, or recreation. With a brand-new HVAC system, newer hot water heater, and meticulous care throughout, this exceptional property is ready to be enjoyed. A rare opportunity to experience comfort, elegance, and effortless indoor-outdoor living in one of Guilderland's most desirable communities.

302 Quidor Court, Guilderland

$550,000

Investor opportunity, this historic property needs work. Combined with the adjacent 102 Severson this property offers over 32 acres extending from Severson to Helderberg Avenue. The home includes the pool house and historic Altamont poll barn. The home is over 2,000 sqft with 3 bedrooms and 2 full bathrooms. Please make sure to secure the front door and turn off all lights. The home is priced due to the all the work needed. Be prepared to make an investment to unlock the value in this unique home and property.

3 Beds ⋅ 2 Baths ⋅ 202619523 MLS

Investor opportunity, this historic property needs work. Combined with the adjacent 102 Severson this property offers over 32 acres extending from Severson to Helderberg Avenue. The home includes the pool house and historic Altamont poll barn. The home is over 2,000 sqft with 3 bedrooms and 2 full bathrooms. Please make sure to secure the front door and turn off all lights. The home is priced due to the all the work needed. Be prepared to make an investment to unlock the value in this unique home and property.

114 & 102 Severson Avenue, Altamont

$5,900,000

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.

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

$698,540

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.

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, Guilderland