Refine Search
Sort by
$949,800
6 Beds 6 Baths 202619915 MLS
Come Explore .... 5 Normandy Square, Guilderland, NY 12009 -- tucked away on a manicured cul-de-sac in the Guilderland School District, this custom home has all the ''I wants'' and more. Much more! Truly needs to be seen to be appreciated. From the moment you enter the soaring two-story foyer-great room, the double-trayed 18' LED ceiling and floor-to-ceiling windows and fireplace tell you this isn't your average Albany County home. The great room opens to a gourmet kitchen with a massive island, beverage cooler, and pot filler. The breakfast nook and transitional sunroom lead to an expansive covered patio with a woodburning lodge fireplace, raftered ceilings, paddle fans, an all-weather TV, and a natural-gas Weber grill kitchen -- built for effortless, entertaining in the shadows of Thatcher Park. Less than 100 feet away sits the most flexible space of all: a 40'x60' (2,600+ sq ft) accessory dwelling unit with potential for recreation center/small business headquarters, or even light manufacturing. Could be used for car storage, a golf simulator, a theatre, dance studio, it is a blank slate. The ADU includes a 2BR/1.5BA apartment, ideal for multigenerational living, guests, or more offices for a home-based business. The 3,781 sq ft, natural-light-filled 4BR/3.5BA main house has a first-floor primary suite and 3-car garage. Combined: over 5,500 sq ft, 6 bedrooms, 4 full and 2 half baths, newer mechanicals, and unparalleled flex space near Costco, Hannaford, and all Guilderland/Altamont has to offer. This is the unicorn -- that unique Altamont, NY property you've been searching for. Stop by fall in love and say ''AHHH'' -- you've arrived home.

5 Normandy Square, Altamont

$550,000
10 Beds 4 Baths 202619760 MLS
Excellent investment opportunity on one of Albany's most desired neighborhoods with monthly rents totaling $5,425. This fully renovated & well-maintained four-unit property features separate utilities, helping minimize owner expenses and maximize cash flow. Located in a strong rental market near Albany's hospitals, colleges, downtown employers, restaurants, and public transportation, the property offers consistent tenant demand and long-term investment potential. Whether you're looking to expand your portfolio or acquire your first multifamily asset, this quadplex provides a solid foundation with multiple income streams and efficient operations. Don't miss the chance to own a turnkey investment property in the heart of Albany. Can be packaged with 211 Quail Street.

360 Madison Avenue, Albany

$799,900
4 Baths 202619677 MLS
Rare mixed-use opportunity in the heart of Albany. This approximately 6,000 SF building spans three levels and occupies more than half a block on Robin Street, just steps from Central Ave, Washington Park, and UAlbany's Downtown Campus. The first floor features two entertainment venues, including an event space with bar area and a separate lounge/nightlife concept, with a proven history of private event rentals and recent approval for event venue use. The second floor includes a recording studio with soundproof booths, while the upper two levels offer flexible space filled with natural light from oversized windows. Four bathrooms, off-street parking, and vacant possession at closing create endless possibilities for hospitality, creative, office, residential, or investment use.

56 Robin Street, Albany

$180,000
1 Baths 202619409 MLS
A great opportunity to own this established auto body repair, D&S Body shop. The auto body repair shop has been in use for well over 50 years. The property features a functioning automotive repair shop along with one separate office space rental and eight garage/storage rental units, providing steady supplemental income. Ideal for owner-operators, investors, or automotive business expansion, the property offers versatile commercial space with strong utility and flexibility. Well-situated with convenient access to major roadways, surrounding neighborhoods, and local business districts. Features include ample garage/storage capacity, office rental income opportunity, and a layout suitable for automotive services, contractor use, storage, or mixed commercial operations. Excellent opportunity to own an auto body repair shop with supplemental rental revenue in the City of Albany.

467 Jay Street, Albany

$2,450,000
202619191 MLS
Rare find! Completely renovated 11 years ago, this incredible building is fully rented and features 14 luxury apartments all with their own unique architectural details, and one large retail space with frontage on Washington Avenue, plus a large unfinished basement with even more investment potential. All apartments have hardwood floors, granite, dishwashers, private laundry, their own gas furnace and central air, hot water heater and electric panel. Large storage rooms for tenants both up and down. Shared lounge or gym space. Accessible lift to second floor. Secure entrances and lobby with intercom & updated security system. Potential rentable basement space up to fire code. Extremely attractive assumable Freddie Mac mortgage available until Dec. 31, 2029. Inquire for more details.

260 Washington Avenue, Albany

$589,000
2 Baths 202619084 MLS
Exceptional opportunity to own a well-maintained ±5,400 SF office building on ±0.86 acres in Delmar. Zoned Commercial Hamlet (CH), the property offers flexibility for a variety of commercial uses. The functional layout includes a reception area, five private offices, six workstations, conference room, training room, breakroom, copy room, IT room, and two restrooms. Features include 21 on-site parking spaces, rooftop solar PV system, gas forced-air heating and cooling, municipal water and sewer, and 400-amp, 3-phase electrical service. Highly visible location on Delaware Avenue with over 14,000 vehicles per day and convenient access to Downtown Albany. Also available for lease at $18.00 PSF plus utilities and janitorial.

25 Delaware Avenue, Bethlehem

$600,000
3 Beds 4 Baths 202619080 MLS
Very rare opportunity to own a unique duplex in Albany's highly desirable Center Square neighborhood. Technically comprised of two separately deeded condominiums, 149 Lancaster Street is being offered as a duplex, providing flexibility for investors and owner-occupants alike. The property features spacious living areas, abundant natural light, and the historic character that makes Center Square so sought after. Unit 1 is a massive 1 bedroom/ 1.5 bathroom with an exceptional garden & outdoor space. Unit 2 is equally as grand but with 2 bedrooms/ 1.5 bathrooms and rooftop deck perfect for firework spectating. Both units to be delivered vacant. Located just steps from Washington Park, Lark Street, Albany Medical Center, restaurants, shops, and downtown Albany, this property offers exceptional walkability and strong rental demand. Continue operating as a duplex or explore the benefits of the existing condo structure. A rare chance to own a versatile income-producing property in one of Albany's premier neighborhoods

149 Lancaster Street, Albany

$599,000
202618730 MLS
3,952 SF professional office building located at a signalized intersection on New Scotland Road. Operate your office from this well appointed, easily accessible and highly recognizable location. Easy to find, easy to get to with ample parking (20 spaces) one you arrive. There is a private shower on the first floor. The building also has a natural gas generator that can power the whole building. Well maintained and well cared for, this building offers much for the office user. Located in Hamlet zoning/ Town of Bethlehem. First floor layout: Reception and work area, 8 private offices, conference room, kitchenette, handicap accessible restrooms (2), and private bath with shower. Second floor layout: three private offices, conference room, and bathroom. UPS drop box on site.

1280 New Scotland Road, Bethlehem

$799,900
4 Beds 4 Baths 202618305 MLS
NEW Price & Open Sunday 9/13 11-12:30PM. Executive Custom Home Adjacent to Wolfert's Roost Country Club. A rare opportunity to own this residence on 1.5 private acres bordering the prestigious Wolfert's Roost Country Club & Golf Course. Surrounded by mature trees, landscaped grounds, and a charming gazebo, this property offers a serene estate-like setting just minutes from Albany. ALL BRAND NEW SECOND FLOOR (was not finished), adding 1,200 square feet. Exceptional Garage & Workshop. A standout feature of this home is the 6-8 car garage -- ideal for collectors, hobbyists, or professionals. Includes a mechanic's car lift, making this a dream set up for automotive enthusiasts. (24.7 ' x 40.8') First-Floor Living at Its Best! The main level is designed for comfort, convenience, and flow: Primary Suite with full private bath, 2 large bedroom with attached bonus room (nursery, office, or flex space). Laundry conveniently located in the bedroom closet. Two full baths + one half bath on this level, high-end kitchen with granite countertops, open to the family room, family room with doors leading to the back deck, combined living room + formal dining room for elegant entertaining. Spacious Second Floor The upper level offers flexibility for guests, extended family, or creative use: Two generous bedrooms, charming dormer alcoves perfect for reading, play areas, or study nooks, oversized full bathroom & Endless potential for multi-generational living, home offices, or recreation space. Updates & Features: All new hardwood floors throughout, updated flooring, granite, vanities, and fresh paint. Full, dry, unfinished basement ready for storage or future finishing. Key Highlights/Feature Details: The ramp from garage directly into the house for handicap access.

186 Van Rensselaer Boulevard, Menands

$579,900
4 Beds 6 Baths 202618260 MLS
Sprawling, spacious, versatile & uniquely individual 4BR, 5.5BA custom ranch-style home in desirable Sage Hill. Boasting over 3,500 sf of living space. Situated on nearly an acre & framed by mature trees, this property offers privacy & a peaceful backyard with a deck & patio to relax on. The original wing features a welcoming slate floor foyer. Large living room with beautiful bay window, handsome fireplace & built-ins. Bright dining room with large picture window. Country kitchen with ample cabinetry & prep area. Cozy corner breakfast area. Pantry/mudroom & half bath adjacent to the entrance from the 2 car side load garage. Original primary with ensuite bath. Convenient hall bath. Music room. Walkout lower level with recreation room, flex space & full bath complete the traditional house. A wide, bright hallway with a cozy sitting area & an atrium door bridges the original home to the expansive newer wing. Two additional bedrooms share a full bathroom with double sinks. A separate laundry room is strategically placed nearby. The private owner's suite is located at the end of the addition with a walk-in closet & a calming bathroom equipped with a soaking tub and separate standalone shower. Second-floor loft lends itself perfectly to a home office, studio or playroom. An unfinished walkout basement complete the modern addition. An established neighborhood, great location and award winning schools complete the package. A very unique property!

6 Sage Hill Lane, Menands

$1,499,900
4 Beds 4 Baths 202618087 MLS
Welcome to an exceptional equestrian estate set on 7 picturesque acres, thoughtfully designed for both horse & rider. This unique property offers outstanding facilities, including a beautifully maintained 8-stall barn featuring fans in each stall & 2 heated stalls, a heated tack room, & oversized wash area. An impressive indoor riding arena w: a new roof in 2024, regulation dressage dimensions, 8-foot interior walls & premium GGT fiber footings for superior performance-- providing year-round comfort, functionality, & training capability. The property features generous pastures & turnout areas w a new all steel Buckley fence w concrete posts along w exceptional riding & training facilities. Additionally, the property is equipped w a commercial-grade generator & a comprehensive camera system throughout the estate, providing added peace of mind along with reliable safety & security for both horses & property year-round. The home itself has been extensively updated w countless improvements throughout the interior & exterior, including all new architectural grade windows w hidden screens, a completely gutted & beautifully redesigned kitchen featuring an iconic AGA stove & Sub-zero refrigerator, new lighting throughout, custom built fireplace and hearth, updated bathrooms & freshly painted interior & exterior spaces. A stunning rear heated porch w blue stone patio addition creates the perfect setting for entertaining or relaxing while overlooking the property, complete with a WiFi-controlled Lutron lighting system for modern convenience & ambiance. For anyone seeking a private horse property w premium features. Whether you are riding competitively or simply embracing the equestrian lifestyle, this estate combines practicality, comfort, & versatility in a truly special setting. A rare opportunity to own a turnkey horse property w exceptional infrastructure, scenic surroundings, & endless potential for both personal enjoyment & professional use

145 Bullock Road, New Scotland

$5,900,000
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

$500,000
5 Beds 5 Baths 202617831 MLS
FOR INVESTORS: Legal 2-family property offering dual rental income opportunities. Strong demand for short-term and long-term rentals with close proximity to skiing, golf, hiking, and farm-to-table dining. Features include ample storage, a full walk-up attic, brand-new stainless steel appliances, and laundry hookups. Just 2+ hours from NYC, this home is well positioned for a weekend rental audience and makes a solid addition to any investment portfolio. FOR ENTREPRENEURS: Outbuildings provide excellent potential for an artist studio, yoga space, workshop, or other creative use. The legal 2-family configuration offers flexibility for live/work needs. Conveniently located near Albany, Hudson, Windham, and Saugerties—ideal for attracting clients or visitors. Scenic mountain views and access to outdoor recreation further enhance short-term rental appeal. FOR HOMEBUYERS: Two fully equipped living units offer versatile options for those seeking separate living spaces or adaptable layouts. Spacious bedrooms, a primary suite, and enclosed sunrooms provide comfort and privacy. The expansive living room features a wood-burning fireplace that adds warmth and character, while central air and mini-splits ensure year-round comfort. Located in the Greenville School District, which offers the International Baccalaureate Program.

186 Cty Rte 411, Westerlo

$499,900
4 Beds 3 Baths 202617158 MLS
Welcome to this beautifully renovated home in the heart of Delmar! This move-in ready property features 4 spacious bedrooms and 3 fully updated bathrooms, offering modern comfort and style throughout. Enjoy a stunning brand-new kitchen with quartz countertops, stainless steel appliances and contemporary finishes, along with new flooring and fresh paint throughout the home. First floor features spacious living room, dining room, family room and a new bathroom with tiled shower; second floor features four bedrooms, a primary suite with full bathroom and walk-in closet. Major upgrades include a new roof and new driveway, providing peace of mind for years to come. Conveniently located near shopping, dining, parks, and top-rated Bethlehem schools. A rare turnkey opportunity you don't want to miss!

358 Kenwood Avenue, Bethlehem

$1,699,000
4 Beds 5 Baths 202616731 MLS
Set within the coveted Shaker Bay neighborhood, this distinguished residence reflects a high level of craftsmanship and thoughtful design, with an emphasis on scale, light and seamless flow. An impressive great room with soaring ceilings and a statement stone fireplace anchors the home, opening effortlessly to a well appointed kitchen and dining area crafted for both everyday living and elevated entertaining. The private first floor office offers a quiet workspace, while the main level primary suite provides a well appointed retreat with a spacious full bathroom and elevated finishes. A generously sized mudroom enhances everyday functionality without compromising style. The walk out lower level is designed for versatility, featuring a recreation room, bedroom and full bath, perfect for extended living or guests. Outdoors, the setting is equally compelling with an expansive deck overlooking the gorgeous grounds, a beautifully designed in ground pool, and a stone patio with a built in gas grill creating a true outdoor escape. Some major updates include: Furnace, HW Heater & Deck/Hardscaping all 2024, Pool liner 2025, Pool pump & filter 2023 and Roof 2019. Complete with a 3 car garage and access to neighborhood tennis courts, this home offers a rare balance of privacy, convenience and understated sophistication. Quick Close Available!

35 Shaker Bay Road, Colonie

$499,900
3 Beds 3 Baths 202616489 MLS
Magnificent and meticulously maintained, this original Buckingham Mews townhouse offers true move-in condition and an exceptional blend of comfort, style, and convenience. Fully renovated throughout, the home features gleaming hardwood floors, beautifully updated kitchen and baths, and a bright, expansive open floor plan designed for modern living. A dramatic two-story living room with a floor-to-ceiling fireplace flows seamlessly into the dining room (also with fireplace) and stunning kitchen, creating the perfect space for both everyday living and entertaining. The spacious first-floor primary suite boasts abundant closet space and a spa-like, designer-updated bath, while the second level offers two oversized bedrooms, a full bath, and a versatile loft area. The massive basement is nearly 2000sf and is ideal for hobbies or additional storage. Enjoy maintenance-free living with thoughtful upgrades including a whole-house generator, a two-car attached garage (epoxy floor), and two courtyard patios--one privately fenced for added tranquility. Ideally situated on a quiet cul-de-sac in Albany's desirable Buckingham Lake neighborhood, this home is just minutes from highway access and close to shopping, restaurants, hospitals, universities, and downtown. A truly impressive and turnkey property--simply move in and enjoy. This property has a 48 hour contingency.

214 Colonial Avenue, Albany

$950,000
5 Beds 3 Baths 202616096 MLS
Welcome to this beautifully maintained and thoughtfully updated home, ideally situated on a quiet cul-de-sac in the highly sought-after North Colonie School District. Offering five spacious bedrooms and a versatile floor plan, this home seamlessly blends comfort, elegance, style, and functionality. The heart of the home is the gourmet kitchen, perfect for both everyday living and entertaining, featuring a Wolf range, Sub-Zero refrigerator, wine fridge, high-end finishes, and abundant workspace. The spacious family room serves as a true gathering space, highlighted by a stunning stone gas fireplace that adds warmth and character. A first-floor office or den provides the ideal work-from-home setup or quiet retreat. Hardwood floors flow throughout, adding timeless elegance, while custom interior shutters enhance windows throughout the home. A large mudroom with convenient entry from both the garage and outside adds everyday practicality and organization. Upstairs, the updated bathrooms offer modern style and convenience, while the second-floor laundry room is elevated with radiant heated floors for added comfort. The finished basement provides excellent additional living space, with plumbing already in place for a future bathroom-offering outstanding potential for further expansion. Step outside to enjoy a beautifully designed bluestone front walkway and a patio overlooking a private backyard--perfect for relaxing or entertaining. Additional highlights include updated garage doors and a state-of-the-art security system with app-based control, along with exterior motion detectors that automatically activate lighting for added convenience and peace of mind. Conveniently located near shopping, dining, and major roadways, this home offers the perfect balance of tranquility and accessibility. This exceptional home you won't want to miss. Open Sunday 9.20.26 12 pm to 2 pm

11 Long Shadow Drive, Colonie

$249,900
11 Beds 5 Baths 202616027 MLS
Investor Alert! SELLER FINANCING OFFERED! Strong value add opportunity in a prime Watervliet location. This 4 unit property offers significant upside with a unit mix of two 1 bed 1 bath units, one 4 bed 2 bath unit, and one 5 bed 1 bath unit with a private laundry room. Excellent income potential with BRRR upside, potential to reconfigure into a 5 unit setup, and strong short term rental appeal. Property requires a full renovation and is being sold as is. Cash only, will not qualify for traditional financing. A substantial amount of renovation materials are already on site and ready for installation, helping streamline the project. With an estimated after repair value of $500K+, this is a compelling opportunity for investors looking to build equity. Situated on a corner lot with a 2 car garage and off street parking. Schedule your private tour today.

1301 Broadway, Watervliet

©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