Albany County

MLS Number 202023044

• Single Family
• MLS Status Active
• Address 256 Elm Dr
• Half Baths 4
• Year Built 2009

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 Coldwell Banker Prime Prop.

MLS Number 202033011

• Multi-Family
• Address 228 WESTERN AV
• Bedrooms 3
• Square Feet 35,000

Twenty-four (24) unit portfolio consisting of twelve (12) buildings all within one block of each other. 96% occupied. 8.03% cap. Located in albany’s highly desirable pine hills neighborhood in a super strong rental market just steps to numerous colleges, hospitals, and historic washington park. Thirty (30) on-site parking spaces. Very well maintained with no deferred maintenance. Great investment opportunity!

Listed by Carrow Real Est Services LLC

MLS Number 202029510

• Multi-Family
• Address 1-27 OLMSTEAD ST
• Village Cohoes City (191)
• Bedrooms 60
• Square Feet 32,207

Rare 28 unit building with 12 3BR units. Brick exterior, Priced $215K below recent appraisal. $100k in recent capital improvements. (Rear roof replacement and other improvements) 13 units have W/D hookups.

Listed by Expert Realty Advisors, LLC

MLS Number 202027776

• Single Family
• MLS Status Active
• Address 8 SHALIMAR CT
• Half Baths 3
• Year Built 2003

Elegance personified! Welcome to this one-of-a-kind custom mansion tucked away on a private Loudonville setting. Offering 10,000 +/- square feet with 5 bedrooms, 7 full bathrooms and 3 half bathrooms, this home has space for everyone. Meticulously maintained and cared for by the original owner. Enter into a stunning foyer with dazzling chandelier, grand entry staircase, and marble tile throughout. Boasting 3 gas fireplaces, 2 laundry rooms, large eat-in kitchen with island, butler's pantry, library, sunroom, formal living and dining rooms, and multiple play/recreational rooms. Home accents include recessed lighting, volume ceilings, detailed trim and 4-car attached garage. In-law potential. Expansive grounds. Minutes to major highways, airport, shopping, and dining. Luxury at its finest!

Listed by Coldwell Banker Prime Prop.

MLS Number 202023503

• Commercial
• MLS Status Active
• Address 12 METRO PARK DR
• Zoning Cor
• Year Built 1973

Updated common areas, bathrooms with showers, walking trails to the Crossings & Cicotti Center a short distance. This corner location at Aviation Rd. leads to back entrance to Colonie Center or North to I-87 at exit 4.

Listed by Berkshire Hathaway Blake

MLS Number 202013717

• Multi-Family
• Address 125 JEFFERSON ST
• Village Albany City-SE (114)
• Bedrooms 3
• Square Feet 11,340

The infamous "Tillerman" property which once acted as an old fire station and has undergone substantial commercial rehab is ready for the next owner to extend and maximize the opportunity for the building. Zoned as "Mixed-use, neighborhood edge," the bottom front half of the building houses two commercial spaces ready to rent, market rents generating a projected $3,500/month. Upstairs are two modern luxury apartments that yield $3,750/mo. Finishing the renovations in the remaining two 1st floor spaces would allow for a projected 13k in gross revenue a month. All new electrical, HVAC, and roof. Approx. 6.7% cap. Please only serious inquiries.

Listed by New Scotland Realty

MLS Number 202022150

• Commercial
• MLS Status Active
• Address 420 MADISON AV
• Village Albany City-SE (114)
• Year Built 1899

This is a very unique opportunity. It is walking distance to Albany med, and colleges. Mixed use building located hearth of downtown Albany, has 6 apartments each large 3 bedrooms and 2 retails. Owner also runs a pizzeria on the first floor. It is one of the busiest pizza businesses in Capital District. Price is only for the building. The building can be sold with business or w\\o business, Price with business and building is $2.5M.

Listed by Keller Williams Capital Dist

MLS Number 202032027

• Single Family
• MLS Status Active
• Address 2 TAPROBANE
• Half Baths 1
• Year Built 2020

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 Foundation First Realty Group

MLS Number 202031194

• Single Family
• MLS Status Active
• Address 9 SAGE ESTATE
• Half Baths 2
• Year Built 1992

Stunning Custom Brick Colonial in Sage Estates. Completely Renovated in 2017. Surround sound speakers throughout house. New inground pool 2019, basement finished in 2019, new HVAC radiant heat. Dramatic 2 Story Foyer, Spacious Custom Kitchen perfect for entertaining, New Miele Appliances, Paneled Refrigerator and freezer. Master Suite with Fireplace and Balcony. 4 Seasons Room and much more.

Listed by MLS 4 Less Realty

MLS Number 202028343

• Single Family
• MLS Status Active
• Address 114 WOODS LA
• Half Baths 3
• Year Built 1892

At the end of Exclusive Woods Lane sits this alluring residence which is majestically poised on 4.3 glorious acres (more acreage available) & yet, just minutes from town. This home is imbued with incredible charm but w/all the modern amenities one desires. It is refined w/exquisite architectural detailing, lavish millwork & is truly elegantly appointed. The spacious rooms begin at the foyer & carry through to the living & dining rms, kitchen/great rm, bedrooms, the offices & gym. The Grand Ballroom can be repurposed for home offices or sports courts. 2 of the 4 furnaces replaced 2020. The owner’s suite is complete w/a lg. walk in closet & luxurious bath. Impressive property features include a circular driveway, huge patio & absolutely magnificent manicured grounds! *some lighting excluded

Listed by Howard Hanna

MLS Number 202014560

• Multi-Family
• Address 644 MADISON AV
• Bedrooms 10
• Square Feet 7,428

17 Units in Unique Multi-Family in Center of Albany Across from Washington Park. 16 apartments all Leased, 1 Vacant, some long-term tenants. Potential to Expand Off-Street Parking with Rear lot to Morris Street Where 3 Car Gar. is Located (Engineered Plans done for additional parking).Well maintained, some updated apartments, Laundry on-site, Minutes from downtown Albany. Close to Albany Med, Lark Street, restaurants, schools. 24 Hours notice to show, agent to accompany

Listed by Howard Hanna

MLS Number 202025957

• Single Family
• MLS Status Active
• Address 49 THOREAU DR
• Half Baths 2
• Year Built 2011

Stunning custom estate on a 2.26 acre lot surrounded by woods. Stone exterior w/ transom windows. Hardwood & inlaid custom tile flooring. Soaring 2 story family room with coffered ceiling, carved limestone fireplace & 2nd floor balcony overlook. Open floor plan w/spacious dining room, gourmet custom kitchen & wet bar-perfect for entertaining! 1st floor bedroom w/private bath for overnight guests or potential in-law space. Cherry wood library w/coffered ceiling, gas fireplace & private office. Four season sun room overlooks paver patio & private yard. Second floor master bedroom oasis with dressing room, fireplace & luxurious master bath. 4 car garage for all of the toys. Multi zone heating and cooling systems, including 7 zone radiant heat. No custom detail was overlooked!

Listed by RE/MAX Capital