Refine Search
Map
Sort by
$2,100
16 Beds ⋅ 8 Baths ⋅ 202625868 MLS
Newly constructed three-story mixed-use investment property in the Town of Guilderland featuring approximately 7,000 SF of leased commercial space on the first floor and 12 luxury residential apartments across the second and third floors. The residential component offers a desirable mix of 8 one-bedroom apartments, each approximately 950 SF with 1 full bath, and 4 two-bedroom apartments, each approximately 1,400 SF with 2 full baths. The modern apartments feature spacious floor plans, quality finishes, and contemporary amenities designed to appeal to today's renters. The fully leased commercial component provides an established income stream while the residential units offer additional rental income potential. Ideally located with convenient access to major roadways, shopping, dining, employment centers, and other everyday amenities, this newly constructed mixed-use property presents an excellent opportunity to acquire a modern, income-producing asset in one of the Capital Region's desirable growth markets.

20 Twenty West Drive
$1,200,000
10 Beds ⋅ 9 Baths ⋅ 202625639 MLS
Get ready to be amazed...set back in a tranquil & private 1.2 acre setting in the highly coveted Guilderland School District this breathtaking custom estate delivers a staggering 7,847 square feet of finished luxury living space and is designed to effortlessly accommodate multi-generational households, large blended families and elite hosting. The main level immediately captivates w/a stunning open-concept flow anchored by gorgeous hardwood floors & a gourmet kitchen featuring pristine granite countertops, dual islands, double wall ovens, a farmhouse sink, top-notch custom cabintry and sliding glass doors - all seamlessly open to the dining & living spaces and a multi-functional beverage wet bar w/butcher-block counter--ideal for all your large family & entertaining needs--anywhere from an office to a homework, snack & craft station. The main floor features a magnificent primary sanctuary boasting dual walk-in closets & a spa-inspired ensuite w/custom tile, walk-in shower & jetted soaking tub w/motorized pop-up TV. To finish off this level nicely, a handy laundry/mudroom is conveniently situated to the rear of the home. Unmatched flexibility defines the upper levels featuring distinct left & right wings. The left features add'l 2nd flr private primary bdrm & ensuite bath w/dual-sink vanity, 2 more bdrms, a full bathrm & a 3rd-floor bdrm. The spacious right wing is anchored by a central family room--a 3rd primary bdrm suite w/bathrm & walk-in closet, 2 more bdrms, full bath & 3rd flr bdrm w/living area. The finished lower level is a showstopper offering a self contained In-Law APT/proven Airbnb AND a bonus full gym area w/waiting RM, storage closet & its own full bathrm w/shower. Sound wiring, composite decks & porches, gas grill line, outdoor patio/fire pit area & an oversized detached 2-bay garage w/office, bdrm space & 1/2 bath that can fit a 35+ ft boat all round out this luxury listing perfectly. Schedule soon & be in your new home hosting by the holidays!

447 Krumkill Road
$869,000
4 Beds ⋅ 6 Baths ⋅ 202621767 MLS
Rarely does a home offer this level of space, privacy, and resort-style living in such a convenient Guilderland location. Set in the desirable Vale of Normanskill neighborhood, 257 Longhouse Lane is an impressive brick Colonial offering 4 bedrooms, 3 full baths, and 2 half baths, with a thoughtfully designed layout for comfortable everyday living and memorable entertaining. The main level features formal living and dining rooms, a custom eat-in kitchen with an island and new appliances, a generous family room with a wood-burning fireplace, and dedicated office or library space. The finished, heated basement provides exceptional flexibility with space for a theater area, game room, bar setup, and additional recreation or entertaining areas. A true highlight is the private indoor swimming pool complex, complete with a Jacuzzi and sauna for year-round enjoyment through every Northeast season. The exceptional outdoor spaces create a private resort-style setting for relaxation and entertaining, featuring a fenced and landscaped 0.45-acre lot, grand patio, built-in fire pits, outdoor kitchen, deck, and multiple gathering areas. Select high-quality indoor and outdoor furnishings are also included at no additional cost. Additional features include a paved driveway, 2-car garage, and generous off-street parking. Conveniently located near Western Avenue/Route 20, NY-155, Crossgates Mall, shopping, dining, schools, parks, and major commuter routes, this remarkable home offers a rare combination of space, amenities, privacy, and accessibility. Schedule your private showing today.

257 Longhouse Lane
$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

©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