Albany, NY Real Estate Search

Kellie Kieley Realty Featured Properties

Welcome to our exclusive collection of featured property listings. Explore these handpicked gems that exemplify the finest in architecture, design, and location. If you are curious about any of the featured properties below or would like a personal tour, please contact us today. We’d love to share the features that make these properties noteworthy. If you would like to see YOUR property listed below, please give us a call to receive a personal in-home consultation or click here to get your FREE home analysis.

$485,000
202622112 MLS
342-346 Hamilton Street offers a unique mixed-use opportunity in a prime downtown Albany location. The property includes office space, two apartments, and a private parking lot with six spaces. Owned and meticulously maintained by a nonprofit for the past 30 years, the property provides strong income and investment potential. Note: 342 Hamilton Street refers to the building, and 346 Hamilton Street is the parking lot. The first floor is currently configured as professional office space and showcases beautiful original woodwork crafted by a skilled carpenter. The layout includes three private offices, a conference room, and a kitchenette, offering flexibility for an owner-user or potential to subdivide for additional rental income. Newer central air serves the office space. The upper floors consist of two residential units, each offering two bedrooms and one full bath. The second floor unit is vacant and the third floor unit is currently rented on a month-to-month basis, generating $600/month. Separate utilities and panels are in place, and the water service line to the property has been replaced in recent years.

342 Hamilton Street
$485,000
4 Beds ⋅ 3 Baths ⋅ 202622063 MLS
342-346 Hamilton Street offers a unique mixed-use opportunity in a prime downtown Albany location. The property includes office space, two apartments, and a private parking lot with six spaces. Owned and meticulously maintained by a nonprofit for the past 30 years, the property provides strong income and investment potential. Note: 342 Hamilton Street refers to the building, and 346 Hamilton Street is the parking lot. The first floor is currently configured as professional office space and showcases beautiful original woodwork crafted by a skilled carpenter. The layout includes three private offices, a conference room, and a kitchenette, offering flexibility for an owner-user or potential to subdivide for additional rental income. Newer central air serves the office space. The upper floors consist of two residential units, each offering two bedrooms and one full bath. The second floor unit is vacant and the third floor unit is currently rented on a month-to-month basis, generating $600/month. Separate utilities and panels are in place, and the water service line to the property has been replaced in recent years.

342 Hamilton Street
$399,900
3 Beds ⋅ 3 Baths ⋅ 202622520 MLS
A hard-to-find layout in Guilderland's Covington Woods: this townhome has 3 full baths, including a first-floor bedroom with its own full bath, plus a full basement. That first-floor suite is ideal for guests, multigenerational living, or a home office. Vaulted ceilings give the main living and dining areas an open, airy feel, and the custom kitchen delivers with stainless steel appliances, a gas range, and a new refrigerator. Upstairs, two generously sized bedrooms each have their own private full bath, plus a flexible loft space perfect for a home office, workout area, or reading nook. Hardwood floors run throughout, tying it all together. There is one-car garage plus driveway space for four more vehicles, five spots in all. Outside, a nice yard adds room to relax or entertain. Recent updates include a new roof (front 2019, rear 2026), an updated electrical panel (2026), and fresh paint in several rooms. Set in the Guilderland School District, you're just a mile from Crossgates Mall and minutes from Albany Medical, SUNY, and the University at Albany, with easy access to I-87, I-90, shopping, dining, and local parks. A low annual HOA keeps the community's grounds and entrance looking sharp.

214 Walnut Lane
$359,900
3 Beds ⋅ 2 Baths ⋅ 202622411 MLS
***ALL OFFERS DUE MONDAY, JULY 27 AT 10AM.**** Welcome to this inviting 3-bedroom, 1.5-bath Colonial in the highly sought-after North Colonie School District. Conveniently located, this home features a bright and welcoming layout filled with natural light. The spacious living and dining areas flow seamlessly, creating the perfect setting for everyday living and entertaining. The convenience of first-floor laundry adds to the home's functionality and ease of living. Step outside to a generous, fully fenced backyard offering plenty of space to relax, play, garden, or host family and friends.

29 Meadowbrook Road
$349,000
4 Beds ⋅ 3 Baths ⋅ 202620399 MLS
Bright and full of light, this colonial has endless possibilities. The first floor features gleaming hard wood floors in the formal living room, eat in kitchen, dining area, family room w/propane fireplace, 1/2 bath and laundry area. The second floor includes 4 large bedrooms and 2 full baths. The primary bedroom has an ensuite bathroom. Bring your vision to the unfinished bonus room over the garage for even more living space. Partially finished basement with workshop with woodstove and bar area. Have a bunch of toys/cars? There are 2 attached 2 car garages with an additional attached garage in the back of the house for storage. Large composite deck overlooking the sprawling backyard. Includes generator that powers the entire house. Close to I-88, for easy access to the Capital District and beyond.

754 NY-30A
$325,000
3 Beds ⋅ 2 Baths ⋅ 202617165 MLS
Make this summer one to remember on the Great Sacandaga Lake! This inviting 3-bedroom, 2 full bath home offers year round living, a bright, open concept layout designed for effortless lake living and relaxing summer days. The kitchen was updated about 5 years ago. Stay warm on the cool nights or winter escapes in the living room by the gas fireplace. A spacious loft provides the perfect bonus area for additional sleeping space, a playroom, or a cozy retreat for guests. Step through the sliding doors onto the wraparound deck -ideal for morning coffee, outdoor dining, or relaxing after a day on the water. The private backyard features a paver patio and fire pit, creating the perfect setting for summer evenings with family and friends. Tucked away in a quiet neighborhood off the main road, this property offers both peace and convenience. Younger metal roof, whole house generator. Extra storage in the detached garage and shed. Furnace and central air only around 7 years old. Enjoy a short walk to your 10-foot lake access with a dock is included so you can make the most of lake season from day one.

11 Lakeview Terrace
$274,900
2 Baths ⋅ 202613937 MLS
PRICE IMPROVEMENT! Exceptional mixed-use investment or owner-user opportunity located directly across from Tricentennial Park in one of downtown Albany's most walkable corridors. Beginning August 15, both the street-level commercial space and second-floor one-bedroom apartment will be delivered vacant, allowing the next owner to establish market rents, occupy the commercial space, or create a live/work arrangement. The street-level commercial space offers excellent visibility, steady pedestrian traffic, and existing restaurant infrastructure, including a built-in commercial kitchen hood, grease trap, and private restroom, while remaining adaptable for restaurant, café, bakery, retail, office, professional services, salon, or other permitted commercial uses. The second-floor one-bedroom apartment provides an excellent opportunity for rental income or owner occupancy. Additional highlights include a roof replaced in August 2020 and convenient access to downtown businesses, restaurants, government offices, public transportation, and major highways. Both the commercial space and apartment are also being offered for lease, providing additional flexibility for investors, owner-occupants, and prospective tenants. Both the commercial space and residential apartment are also available for lease, providing additional flexibility for investors, owner-occupants, and prospective tenants. Property is being sold AS-IS. Buyers should perform their own due diligence. Showings by appointment only.

54 James Street
$150,000
202526151 MLS
Can't find a home? Build your dream home here. Escape the hustle and bustle and surround yourself in peace and tranquility with this 12.26 acre of mostly cleared, flat, raw land in Stephentown. At the end of a dead end residential street, this parcel is ready for your vision. Build your mountain retreat, full time home or enjoy hobbies on this property. Only 10 minutes to Jimmy Peak Mountain Resort and 45 minutes to Albany.

L113 Upper Hemlock Ridge Way
Start Your Search

©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