Team McSharry Listings

1712 Crescent Road, Rexford

$575,000

This circa-1840 Greek Revival farmhouse offers the rare opportunity to enjoy historic charm and craftsmanship with the comfort and functionality of a modern home. Thoughtfully renovated and expanded over time, this is not a project house - it is a turnkey property where the hard work has already been done.

Set back from the road on an expansive property, the home offers added privacy, space and curb appeal rarely found in historic farmhouses. A substantial 2010 addition seamlessly integrated a spacious kitchen, cathedral-ceiling great room and usable basement space designed for today’s lifestyle while preserving the home’s timeless architectural character. Natural light fills the home, highlighting exposed original wood beams, wide plank pine floors, eyebrow and transom windows, and the stately columned portico.

The kitchen blends classic style with modern functionality, featuring Shaker cabinetry, a center island with seating and storage, and a generous pantry with built-in shelving. The flexible floor plan includes a first-floor bedroom with dual closets and pocket doors alongside an updated full bath, offering ideal guest or single-level living options. The formal living room centers around a cozy gas fireplace. Upstairs are two additional bedrooms and a full bath, with peaceful treetop and landscape views throughout.

The finished lower level adds valuable living space with a large bedroom, laundry room and convenient Bilco door access, while the unfinished area provides abundant storage.

Outside, the grounds feature 25 species of trees and shrubs, perennial gardens and fenced garden beds, creating a peaceful, established setting. A detached two-car garage includes a heated and air-conditioned second-floor office with a custom desk, ideal for remote work, studio space or creative pursuits.

Located in a walkable neighborhood near the bike path and just one mile from the Vischer Ferry Nature Preserve and Vischer Ferry General Store, this beautifully preserved and extensively updated property offers a rare blend of historic authenticity and modern ease.

31 Crestwood Lane, Delmar

$495,000

Carefully maintained and ideally located, this bright and airy home offers the perfect floor plan for today’s living. Southern exposure fills the home with natural light with sunny rooms throughout the home. Large rooms and great flow make everyday living and entertaining feel effortless, while the cozy family room provides the perfect spot to relax and unwind.

The expansive primary suite features an en suite bath and walk-in closet, complemented by great closet space throughout the home. A basement rec space adds  flexibility for hobbies, exercise, or a place to send the kids.

Enjoy a convenient Slingerlands location with easy access to recreational areas including the rail trail, town parks, Five Rivers nature center, and the library. Walkable to Slingerlands Elementary, this is a home that truly combines comfort, space, and lifestyle.

86 Harris Avenue, Albany

$334,900

Set in one of Albany’s most walkable neighborhoods, this spacious split-level home offers room to spread out both inside and out. It’s an ideal spot for biking, walking, and easy access to the restaurants and shops along New Scotland.

The main living level features an open floor plan that creates an easy flow between the living, dining, and kitchen spaces—well suited for both everyday living and entertaining. Good-sized bedrooms, great closet space, and multiple flexible living areas provide plenty of options for how to use the home.

The lower level offers versatile bonus space along with a convenient half bath, while the basement provides excellent storage or potential rec room space. Outside, the spacious backyard is designed for enjoying the warmer months, complete with a deck, patio, shed, and swing set. A deep one-car garage offers tandem-style potential for additional storage, workspace, or parking flexibility.

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.

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.