Albany County

MLS Number 202023044

• Residential
• MlsStatus 202023044
• Square Feet 11,218
• Year Built 2009
• Bathroom 10

Enjoy privacy and convenience on 350 acres in the heart of the Helderbergs with spectacular views and groomed trails for hiking, horseback riding and snowmobiling. Multiple high end properties, including a 8,800 sf mansion style home, a 2,500sf second home, an 8 stall horse barn, an indoor arena and a 4 car garage. Close to downtown Albany, the Albany International Airport, The Amtrak Station, 2 1/4 hours to NYC and 1 hour from the Adirondacks. Please see attached disclosure for features and detailed property descriptions. Agent to accompany showings and qualifying information for buyer required.

Listed by Anne Stuto of Coldwell Banker Prime Prop.

MLS Number 202121392

• Commercial
• MlsStatus Active
• Year Built 1983

The Days Inn Albany is a phenomenal investment opportunity for any investor or owner-operator.? The property consists of three separate buildings.? The first building to the left is outdoor rooms and has a lobby inside, as well as laundry & vending machines.? The building to the right is a restaurant and is a triple net lease.? The building in the back is 3 stories of a hotel room.? These rooms are suites, and the building has a breakfast area, banquet hall, pool, laundry, and vending machines.? Each building was renovated in 2018.? Due to the pandemic, the hotel was forced to close its pool, banquet hall, and breakfast bar.? Prior to the pandemic, the hotel found lots of success hosting events and accommodating guests with reasonably priced, yet very nice, suites.? While many investors/

Listed by Bryce Cherko of Cherko Fusco Realty

MLS Number 202124092

• Residential
• MlsStatus 202124092
• Square Feet 8,800
• Year Built 2009
• Bathroom 7

Enjoy privacy and convenience in the heart of the Helderberg Mtns with spectacular views and groomed trails for hiking, horseback riding and snowmobiling. Multiple high end properties, including a 8,800 sf mansion style home with 5 bedrooms, 4.3 baths gourmet kitchen, 3 car attached garage, 3 fireplaces, wine cellar, 60 kw generator, an 8 stall horse barn with heated tack room, lounge, laundry, bath and kitchen, a 100 x 200 indoor arena with heated machine shop and ample storage and a separate 4 car garage. Close to downtown Albany, the Albany International Airport, The Amtrak Station, 2 1/4 hours to NYC and 1 hour from the Adirondacks. Please see attached disclosure for features and detailed property descriptions. Agent to accompany showings and qualifying information for buyer required.

Listed by Anne Stuto of Coldwell Banker Prime Prop.

MLS Number 202116068

• Commercial
• MlsStatus Active
• Year Built 1979
• Bathroom 8

Unique commercial opportunity with unmatched visibility/traffic and expansive move-in ready professional office space for sale or lease. The proud home to Martin, Harding & Mazzotti for the past 20 years, this unique site comprises 6 tax parcels totaling 3.32 acres split between the Towns of Colonie and Niskayuna, on a prominent corner of Route 7 w/traffic counts of 40,000 cars per day. Currently, a 17,872 sq ft (3-level) professional office building (formerly retail/medical) and 1,688 sq ft additional office/home, 87 parking spots + 2 car garage. 371 ft frontage on Rte 7, 151 ft on side rd. Ideal location for healthcare/medical, retail, financial, etc. Contact listing agents to discuss potential leasing details: $9/sq ft + approx. $5/ft CAM charges.

Listed by Nicole Mazzotti and Melissa Cartier of Cartier Real Estate Group LLC

MLS Number 202033935

• Land
• MlsStatus Active
• Acreage 40.5

Excellent development opportunity! 40.5 acre wooded parcel. Currently zoned residential. Incredible location on Old Loudon Road off busy Route 9 corridor. Town water at road.

Listed by Franca DiCrescenzo and Anthony Durante of Armida Rose Realty Group

MLS Number 202125760

• Commercial
• MlsStatus Active
• Year Built 1915

Investment Opportunity and 100% rented! This does not come around often! Have a chance at owning 15 luxury residential units, 1st floor restaurant space, office space, rooftop patio with Downtown views, exclusive parking, and the amenities continue. Private second floor patio as well included for 2 apartments, then 2 elevators, and coined laundry for additional income! Newly renovated 5 years ago with luxury units having stainless steel appliances, granite countertops, hardwood floors, and tile showers. Reach out to Sage today for a showing!

Listed by Christopher Maddalone and Sage Baltrusaitis of Hunt ERA

MLS Number 202118914

• Commercial
• MlsStatus Active
• Year Built 1991

Car dealership, most any business, 6 Prime Acres on very busy Rt 7 close to Mill Rd Golf course and rt 9.

Listed by Thomas Marks of Coldwell Banker Prime Prop.

MLS Number 202124871

• Commercial
• MlsStatus Active
• Year Built 1972
• Bathroom 8

Former bank branch and executive office space. Move-in condition. First floor retail. Amazing amount of light-windows all around. 2nd Floor State St access. Hotel garage close. Bus stop close. Fountain park outside. Heart of financial/government district. Walk to government buildings and SUNY HQ. Opportunity Zone with many incentives.

Listed by Ann MacAffer of CBRE Albany

MLS Number 202132951

• Residential
• MlsStatus 202132951
• Square Feet 6,615
• Year Built 1994
• Bathroom 6

H627606...Welcome To 19 Pheasant Lane! A Mediterranean Villa Masterpiece! An Architectural Marvel! A National Award Winning Mansion! Unmatched in Superior Style And Craftmanship And Appointed With The Finest Design Finishes! This Stunning Estate Home Features: Over 6,800SF With 5+BR, 4 Full & 2 Half BA, 3 Fireplaces, Exquisite Limestone, Cherry & Marble Floors, Striking Plaster Moldings, Grand Reception Hall, Formal & Informal Entertaining Rooms, Open French Country Kitchen & Family Room, Private Guest Suite, Spectacular Primary Suite, Magnificent Stone Terraces, Lovely Landscaped 3.8 Acres With Expansive Yard And Breathtaking Views, Private & Secluded Setting And So Much More! A Very Rare Opportunity To Own One Of The Most Sought-After And Distinctive Homes In The Capital Region! H627606

Listed by Steven Girvin and Martha Chamberlin of Howard Hanna

MLS Number 202130860

• Residential
• MlsStatus 202130860
• Square Feet 4,000
• Year Built 2020
• Bathroom 5

Come see what The Times Union classified as the next generation of premium luxury! You simply won't find a product that compares in the Capital Region. This home is in a prime location deep in the heart of Loudonville. A perfect blend of state of the art engineering, with truly no limits, on one of the last remaining lots in prestigious Taprobane. Start designing your dream home today. Call for a private consultation, and a tour of MIG Builder's product. Meet proud owners who have experienced MIG luxury for themselves. We'll let them define the differences that set MIG builders apart. Don't let this once in a lifetime opportunity pass you by. Property is to be built.

Listed by Brian McQueen of INMO Realty Company,LLC

MLS Number 202133127

• Residential
• MlsStatus 202133127
• Square Feet 5,938
• Year Built 1995
• Bathroom 5

From The moment you arrive & pass through the gates of this rare usable 5.75acre, 5900SF above ground estate, “stunning & exceptional” are the words to describe what your about to see! This home is a very special place w/picturesque ground, a backyard paradise w/an oversized saltwater pool, surrounded w/custom patio stonework & waterfall. The backyard retreat includes an upper & lower patio, large wood burning fireplace & step down to hot tub area. This 5BR, 4.1BA home has gleaming HW floors, 2 staircases, tiled bathrooms, 2 gas fireplaces, beautifully remodeled open concept 1st floor. Custom moldings & ceilings, a new roof, newer furnaces & central air units are just a few of the upgrades. In addition to the large 3-car attached garage, there's a free standing detached 40X28 3-car garage.

Listed by John Longo of Miranda Real Estate Group Inc

MLS Number 202114987

• Commercial
• MlsStatus Active
• Year Built 1980

Professional Office building perfect for any owner-user or investor. Located within close proximity to Albany's colleges, hospitals and downtown. 65 separate office spaces with large conference rooms and kitchens on each floor. Freshly painted and new carpet tiles. Security system. Elevator.

Listed by Luke Khachadourian of Keller Williams Capital Dist