Team McSharry Listings

23 Dumbarton Drive, Delmar


Looking for a well built home in a lovely community? Hoping for brightly lit and open living spaces? Waiting for a large yard for playing ball and gardening? Situated in the desirable Kenholm neighborhood, with updated mechanicals and roof, here's your chance to add your cosmetic touches and make this house your home! 

89 Second Avenue, Troy


Whether you are looking to live in one apartment or rent out both, this two family home is a great investment! Conveniently located with gorgeous river views, this home has been thoughtfully updated and features newer boilers and roof, renovated first floor kitchen, new two-level back deck and lots of original architectural detailing. Second floor last rented at $700 + utilities.

708 Penney Lane, Guilderland


Built with upgrades making it better than new construction, this beautifully appointed home has such tasteful decor, reminiscent of a Tuscan villa. Enjoy sunshine streaming through the many windows and take in the serene views of the neighboring Pine Bush preserve. With a gorgeous chef’s kitchen, large entertaining spaces, an open floor plan and a sumptuous master suite, you will live the good life here!

30 Charles Boulevard, Delmar


Looking for a completely renovated home with large rooms and great flow? Set on a large treed lot, in a quiet, walkable neighborhood, you don’t want to miss this one! From top to bottom, virtually everything is brand new including - roof, kitchen, both bathrooms, flooring, boiler, water heater, Bilco door and more. Add to that finished space in the basement and an oversized two car garage with a very useable attic and you really have the perfect home.

450 Long Road, East Berne


Unique opportunity to have the farm of your dreams! With over 100 acres of pastures perfect for grazing livestock, the property features a comfortably appointed custom modular. Included are a 2007 Morton barn (36 x 60) with 4-6 stalls, 6 paddocks, storage & additional sheds; the original 1800s farmhouse with so much potential and more! Breathtaking views, outdoor recreation, many conveniences near by, only 30 minutes to Albany and various markets. Agricultural exemption keeps taxes low. Operating as a farm; appointment required, no drop-ins.

237 Park Avenue, Albany


Looking for a great investment opportunity? Featuring three updated units that are always rented, this building generates over $26k in income. Separate utilities in two of the apartments, replacement windows, wood floors, good storage space, easy on-street parking.

335 Central Avenue, Albany


Looking for a profitable bar/music venue in the heart of Albany? Hoping for a full kitchen, complete with new fire suppressor system, large ice cooler, professional grade stove and cooktop? A 27 ft long bar with a newer Glycol keg system? Seating at bar and built-in tables and an approved capacity of 75 people? With additional income (currently $1400 a month) from two apartments above bar?

1749 New Scotland Road, Slingerlands


Striking the perfect balance that many wish for - historic yet contemporary, grand yet comfortable, gracious yet homey, you will be proud to come home to 1749 New Scotland Road! With large living spaces, a chef’s kitchen, a master suite with bathroom, office and sleeping porch, a finished attic, multiple outdoor seating areas and a three car garage with loft - all updated and featuring high-end finishes and interesting architectural details, this home is unparalleled. Enjoy easy access down a quiet road to the recently paved Albany County Rail Trail, one of the community's best assets.

17 Chapel St #703, Albany


Enjoy a bit of luxury every day right in the heart of Downtown Albany! This pristine, sun-filled top-floor condo features wood floors throughout, large windows, LEED-certified construction, and a private covered balcony. Wash away cares in the master Kohler spa shower. Create gourmet meals in the well-appointed kitchen, with high-quality appliances and solid maple cabinetry. Enjoy an evening at home by the gas fireplace, or walk to dinner and a show. Entertain friends or just enjoy the views from the rooftop terrace. Work out anytime in the private fitness center. Come home to the good life.