Albany County

MLS Number 202223303

• MultiFamily
• Mlsstatus Active
• Acreage 0.65
• Year Built 1880
• Bedrooms 7

This is a truly one of a kind property situated in the heart of Downtown Albany! Have the chance to own this high end building outfitted with 41 luxury residential units, and 21 commercial spaces. 96 Walk Score; close to every need for prospective residents and those wanting to work directly Downtown Albany. Apartments are furnished with beautiful custom kitchens, washer/dryer, stainless appliances, dishwashers, granite countertops, and hardwood floors. State of the art VRF mini split systems and heat pumps in all residential units. Bathrooms are spa like with Roman walk-in mosaic tiled showers, mahogany vanities and custom light fixtures. Rooftop patio, theatre room, and fitness center all included! Reach out today for a private showing and review our Offering Flyer with financial details

Listed by Christopher Maddalone and Sage Baltrusaitis of Hunt ERA

MLS Number 202220588

• CommercialSale
• Mlsstatus Active
• Square Feet 17,470
• Acreage 3.2
• Year Built 1983

Motel with 109 rooms for sale 7 minutes from Albany International airport. Located only a half mile off Interstate 87, Colonie Center and Wolf Road. Motel has well above average occupancy rate. Roadside building constructed in 1983. The back building housing suites built recently in 2001. Numerous events booked into the future. Restaurant on site currently leased out and managed by tenant. Owner has done many updates and capital improvements. NDA must be filled out before discussing financials. Listing agent to accompany tours. Do not approach employees.

Listed by William Curry of NAI Platform LLC

MLS Number 202225534

• Residential
• Mlsstatus Active
• Square Feet 8,800
• Acreage 303.03
• Year Built 2009

Idyllic setting includes an 8800+ sf Estate with caretakers quarters tucked away from the main home. Settled on 300 awe-inspiring forested and groomed acres, including a stocked pond and various springs. Endless recreational and wildlife opportunities. Perfect for horseback riding. The main property boasts a gourmet kitchen with Viking Appliances and walk-in pantry featuring in-floor radiant heat. Wet Bar, Blue stone tasting room and wine cellar. Executive Office. Two walk up attic spaces. Indoor riding Arena, heated tac room, 8 heated self watering stalls, hay loft holds 1700 bales. Heated machine shop. Abundant storage for bikes, ski, snowboard, hockey, and hunting equipment. Close proximity to Albany, Saratoga, Lake George, Adirondacks, Catskills, and of course NYC

Listed by April D Seney of Four Seasons Sothebys Int RE

MLS Number 202211634

• CommercialSale
• Mlsstatus Active
• Square Feet 33,760
• Acreage 0.32
• Year Built 1913

30 residential units, 3 commercial spaces-fully rented. Mix of studios,1,2,3,4 bedroom units. some rents could be higher .Roof new w/in 2years, updated electric, Gas Hot water and hot air. Off street parking. All apartments have hw floors, ceramic tile kitchen & baths some have central air. Sprinkler system, elevator.

Listed by Laurie Baranski of DeThomasis & Baranski RE,Inc

MLS Number 202230471

• Residential
• Mlsstatus Active
• Square Feet 7,245
• Acreage 4.21
• Year Built 1989

Custom Designed and crafted to meticulous standards, this contemporary 4.21 acre waterfront home is surrounded by tended gardens and inviting pathways. The artful floor plan affords a seamless balance of open and intimate spaces for ultimate functionality and luxury. Countless and vast windows offer ever-changing panoramic views of the Hudson River and gracious grounds. Soak up the warm rays of the sun as you relax in the solarium or enjoy gardening in the greenhouse all while feeling connected with nature no matter the season. Located minutes from the New State Capitol and all conveniences however once through the iron gates the sense of stillness and calm is soothing and inspiring. This is the retreat you have been seeking.

Listed by Katie A O'Keefe of Four Seasons Sothebys Int RE

MLS Number 202228653

• CommercialSale
• Mlsstatus Active
• Square Feet 19,560
• Acreage 3.5
• Year Built 1979

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 7 tax parcels totaling 3.5 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 Melissa C Cartier and Nicole Mazzotti of Cartier Real Estate Group LLC

MLS Number 202226229

• Residential
• Mlsstatus Active
• Square Feet 4,000
• Acreage 2.5
• 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. Superior Condition, Custom Kitchen Feature

Listed by Brian S McQueen of INMO Realty Company,LLC

MLS Number 202224617

• CommercialSale
• Mlsstatus Active
• Square Feet 7,176
• Acreage 0.08
• Year Built 2017

New building with 2400 sqf retail place with 6 luxury one bedroom apartments.Stainless steel appliances, central air condition, security system, stainless steel countertop, cork floors, Highly insulated energy efficient windows. Tenant pays all the utilities. First floor 2400 sqf retail store ready to be used for restaurant, bank etc. This is very unique opportunity for investors and business owners. Call listing agent for showings

Listed by Ramiz Turan of Keller Williams Capital Dist

MLS Number 202215636

• CommercialSale
• Mlsstatus Active
• Acreage 103.86
• Year Built 1900

103 Acres of beautiful farm land located in Bethlehem, NY in the hamlet of Selkirk. Large Historic wood frame barn is still in great shape and can be functional. The land zoning is due to be changed to Mixed Industry via the Town of Bethlehem Comprehensive plan due to be passed in May or June of 2022. Mixed Industry (MI)This area includes research and development, testing and light manufacturing, technology basedbusinesses, and offices. Multi-family residential development and businesses that support employeesand residents are also found.

Listed by Irvin S Ackerman of Venture Realty Solutions

MLS Number 202226955

• MultiFamily
• Mlsstatus Active
• Square Feet 14,875
• Acreage 0.63
• Year Built 1905

ATTN Investors & Developers, opportunity to develop in the 'OPPORTUNITY ZONE'. A few blocks from Pearl St and all of the re-development going on in downtown. 240 Sheridan is the anchor to a multi property portfolio that consists of 9 apts, 3 art studios/flex space + 5 vacant lots and a community garden lot. Check assoc docs for a complete list of all props included. TOTAL Package price is 1.4mill. This offering is best suitable for a developer looking to take advantage of the vacant lots and potential to build from the ground up. Most Units have been completely restored - modern loft style living. Courtyard, off street parking, central air (in some units) and updated kitchens & baths. (PROOF OF FUNDS REQUIRED PRIOR TO SHOWING) Very Good Condition

Listed by Michael J Field of Field Realty

MLS Number 202228961

• Residential
• Mlsstatus Active
• Square Feet 2,129
• Acreage 60.2
• Year Built 2022

We call her ''The Periwinkle House''. Full of truly custom surprises created by the artist, you won't find these thoughtful & upscale finishes in most new construction. Surrounded by 60 acres of views, pastures, trees & privacy. Two garages, one at the beginning of a long private drive, all custom heights for your RV or farm equipment, room for expansion above the home garage. The inside is a blank canvas in ways that only invite you to be the creator, yet the custom lighting and hardware fixtures are far above the norm. The centerpiece of the house is the rare solid tempered glass island that has the wow factor of no other we have seen. The European feel of the mounted sinks and accessories, off grid solar, radiant heat, & SOTA systems, make the Periwinkle house one of a kind.

Listed by Dona Federico and Laura Murphy of Berkshire Hathaway Blake

MLS Number 202227767

• CommercialSale
• Mlsstatus Active
• Square Feet 4,380
• Acreage 0.85
• Year Built 1990

+/- 4380 sf building for sale or lease on Central Avenue. Currently outfitted as a well established family restaurant. Recently renovated. Massive basement with office space and additional coolers and freezers. Prime location on Central Ave. A turn key opportunity or easy change of use. Owners open to lease options and owner financing.

Listed by Sophia M Mantzouris of 518 Realty.Com Inc