Team McSharry Listings

431 Onesquethaw Creek Road, Feura Bush

$625,000

Tucked away on 12 breathtaking acres, this one-of-a-kind country retreat offers the perfect blend of privacy, natural beauty, and endless potential. Meticulously updated and maintained and ideally laid out, the home is perfectly positioned to capture incredible views overlooking the pond and surrounding landscape, with a wraparound deck that allows you to fully enjoy the peaceful setting from every angle. A separate studio space is ideal for guests, a home office, artist retreat, or hobby space. The oversized 2-car garage and massive barn provide exceptional storage, workshop opportunities, or room for equipment, animals, and recreational vehicles.

The property itself is truly special - featuring immaculately kept grounds, a peaceful pond complete with deck and fire pit, two flowing streams, and a stunning natural waterfall that creates a setting unlike any other. Adding even more value and opportunity, the property includes an approved building lot equipped with its own well and septic system, offering potential for expansion - whether for a guest house, family compound, or future development. 

The red barn is a piece of local history, raised in 1864, it was moved (plank by plank) in 2008 and rebuilt on this property. Nearby the 1922 Fordson tractor is positioned in the open field, adding charm and character to the property.

Whether you're looking for a private getaway, hobby farm, weekend retreat, or a nature lover’s paradise, this extraordinary property offers a rare opportunity to own a slice of countryside heaven. Enjoy peaceful walks, outdoor adventures, and picturesque views in every direction while still being within easy reach of local conveniences.

285 Elsmere Avenue, Delmar

$469,900

Completely renovated and thoughtfully reimagined, this home offers the best of both worlds- timeless character paired with today's modern updates. From the moment you arrive, the deep front porch sets the tone, a perfect spot to relax and watch the world go by.

Inside, wood floors run throughout the home. The recently renovated kitchen is a true standout, featuring new high-end appliances along with generous counter and cabinet space designed for everyday living and entertaining alike. Just off the main living areas, a large mudroom and laundry space keeps busy households organized with ease.

The flexible floor plan includes a cozy family room complete with a full bathroom, making it an ideal option for a first-floor bedroom or private guest suite. A beautifully updated primary suite features a gorgeous walk-in closet that will delight any clotheshorse and a completely updated en suite bath.

Efficiency meets peace of mind with a new boiler, updated electrical panel, replacement windows and an energy-conscious setup that includes a brand new solar water heater along with owned solar panels- both thermal for hot water and photovoltaic for electricity.
Storage is well thought out with a convenient pull-down attic.

Outside, the deep private backyard creates a true extension of the home. Whether you're dining al fresco on the 700 square foot deck, relaxing, or enjoying a soak in the hot tub, this outdoor oasis is where you'll spend your summer days. And for those who've ever dreamed of a little backyard hobby- Cluckingham Palace is ready and waiting for your baby chicks.

All of this in a location that's hard to beat- walkable to the heart of Delmar and just minutes to shopping and conveniences in Glenmont.

52 Hawthorne Avenue, Albany

$329,900

Set on a quiet street just minutes from local restaurants and walkable to Buckingham Lake, this brick ranch offers a comfortable blend of updates and mid-century modern style. The open living space is bright and inviting, with large windows that fill the home with natural light and wood flooring throughout the first floor. A decorative gas fireplace in the living room enhances the home’s character.

The renovated kitchen is designed for both function and flow, featuring generous counter space and abundant storage. The primary suite is spacious and well-appointed, with an updated en suite bath and large closet, while the hall bath has also been thoughtfully updated.

The finished basement adds valuable flexibility—ideal for a home office, gym, or additional living space. With a new furnace, air conditioning unit and water heater, there's nothing left to worry about. Outside, the backyard is bright and sunny, offering a welcoming space to relax or entertain.

Looking for a spacious, low maintenance home in a great Albany location? Your search is over!

18 Bridge Street, Slingerlands

$485,000

Architecturally distinctive and full of character, this Spanish Mission–style Colonial offers a rare opportunity in a highly desirable Slingerlands setting. From the tile roof to the quarter sawn oak trim, every detail reflects a clear sense of style and craftsmanship. Thoughtful updates—including Pella Craftsman wood replacement windows, custom radiator covers, soapstone countertops, a Motawi tile backsplash, and Quoizel stained glass light fixtures—honor the home’s original character while enhancing everyday living.

Entering the front foyer, it’s immediately clear this is a one-of-a-kind home. Nine-foot ceilings and abundant windows create a bright, open feel, while French glass-paned doors provide separation when needed and easy flow throughout the first floor. The renovated kitchen connects seamlessly to the dining room, making meal prep both enjoyable and social. Whether gathered around the living room fireplace or settling in for movie night in the family room, there are plenty of options for relaxing.

Even the stairway stands out, with tile accents and a cleverly designed storage closet on the landing. The second floor offers a nicely renovated hall bath, two bedrooms, and a primary suite to be envied. The third floor adds flexibility with two additional rooms plus a storage room or play nook.

Set on a quiet dead-end street, the neighborhood has a friendly, welcoming feel. A park sits across the street, with easy access to the Helderberg Hudson Rail Trail and Pine Hollow Arboretum. The fenced backyard is nicely landscaped and features a secluded sitting area for morning coffee. The heated two-car garage, with new doors, provides excellent storage and protection from the elements.

Homes like this, where updates reflect care and respect for the original design, are hard to find. Don’t miss the chance to make this Slingerlands gem your own.

2232 Rosendale Road, Niskayuna

$325,000

Set on an unusually spacious corner lot in a desirable Niskayuna location, this low maintenance brick ranch offers a thoughtful blend of classic character and everyday functionality. Refinished hardwood floors run through the main living space.  A wood-burning fireplace and large picture window that overlooks the fenced backyard make the living room a relaxing place to hang out.

The efficiently designed kitchen offers practical flow and ease for daily living. A finished basement adds versatile space—ideal for a family room, guest room or recreation area—while the first floor office provides a comfortable work-from-home setup.

With its subtle mid-century vibe, solid construction, and flexible layout, this home presents a wonderful opportunity to enjoy both comfort and convenience in a sought-after setting.

11 Rhode Island Avenue, Rensselaer

$205,000

Set in a quiet, walkable neighborhood close to the desirable Red Mill Elementary and convenient to shops and everyday amenities, this thoughtfully updated home offers comfort and efficiency in all the right ways.

Bright and welcoming, the interior is designed to make the most of its footprint. The open living space feels airy and connected. The recently renovated kitchen and baths bring a fresh, modern feel, with attractive finishes including updated lighting and stylish bathroom tile work.

Every space has been carefully considered, resulting in a home that lives larger than its size. It’s right-sized for downsizers seeking simplicity without compromise, or for young professionals looking for a move-in ready home in a sought-after location.

The sunny and spacious backyard will be the site of summer barbecues and is the ideal spot for gardening or playing ball.

An affordable opportunity in an area where values hold strong, this home offers smart design, quality updates, and a setting that’s hard to beat.

47 Wheeler Road, Glenmont

$99,900

Discover a quiet and serene slice of Glenmont with this fully approved building lot nestled on nearly 2 acres in the Bethlehem School District. Surrounded by old growth trees and set in a quiet, close-knit community a short distance to the Hudson River, this unique setting offers the best of both worlds—close to Albany and countless amenities, yet it feels like you’re away from it all. Enjoy fresh well water, with electric conveniently available at the road. A rare opportunity to build your dream home in a peaceful environment where nature and neighborhood charm meet.