Refine Search
Sort by
1874 Altamont Avenue, Rotterdam
$1,990,000
202628277 MLS
Prime Corner Development Opportunity - Rotterdam, NY Positioned at a signalized intersection in the heart of Rotterdam, this ±44,000 SF corner lot offers exceptional visibility and strong daily traffic counts with immediate access to Route 9. The site presents a highly flexible development opportunity ideal for retail, office, or service-oriented users, with ample space for parking, signage, and efficient site layout. Surrounded by established national retailers and dense residential neighborhoods, the location supports a wide range of uses including medical, wellness, fitness, childcare, personal care, and fast-casual concepts. A rare opportunity to secure a highly visible corner site in a proven commercial corridor--perfect for users and developers seeking long-term growth and consistent traffic exposure.

1874 Altamont Avenue, Rotterdam

870-878 Ennis Road, Princetown
$1,899,000
5 Beds ⋅ 7 Baths ⋅ 202628622 MLS
This extraordinary private estate located in Princetown NY, presents a rare combination of scale, privacy, versatility, and infrastructure seldom found in the Capital Region. Set on +177 acres, this impressive residence is complemented by substantial ancillary buildings, beautifully designed grounds, and extensive systems created to support both luxurious everyday living and the demands of a private estate compound. The five-bedroom residence features five full and two half baths, two full kitchens, multiple entertaining areas, three wet bars and a dry bar, five fireplaces, a woodstove, two laundry rooms, and an oversized attached two-car garage. Its generous layout and multiple living areas offer potential for multigenerational living. Zoned HVAC, a walk-in cooler, and a walk-in freezer support everyday comfort and opportunity for large-scale entertaining. A separate heated five-stall brick garage includes a mezzanine, half bath, and five motorized overhead doors, providing space for an automobile collection, recreational vehicles, or equipment. The expansive utility building offers six motorized overhead doors, a full kitchen, full bath with shower, two private offices, open office space, and heating and HVAC systems—ideal for private workspace, hobbies, and storage. The grounds feature three ponds, a lighted fountain, engineered overflow and stormwater systems, raised garden beds with drip irrigation, and significant road frontage. Two gated entrances, commercial-grade exterior lighting, a 27-camera CCTV system, two diesel generators, three privately owned 1,000-gallon underground LP tanks, underground utilities, multiple irrigation systems, and wireless coverage throughout all three buildings enhance the property. An extraordinary combination of residential comfort, acreage, security, and adaptable space makes this estate a distinctive Capital Region offering.

870-878 Ennis Road, Princetown

2820 Balltown Road, Niskayuna
$1,895,000
7 Beds ⋅ 3 Baths ⋅ 202610469 MLS
Welcome to The Mansion at Rebecca's Fountain, where you'll be welcomed by a working fountain with a statue of Rebecca which sets the tone for this beautiful estate. Perched atop more than three secluded acres in Niskayuna, overlooking the Mohawk River, the Estate offers mountain views, refined architecture, and a rare sense of privacy minutes from the finest destinations. Reminiscent of ''Gone with the Wind,'' a grand foyer welcomes you with sweeping dual staircase & a striking 6-foot motorized crystal chandelier that showcases the elegance found throughout the home. Fully furnished by a designer, the approx. 5,000 sqft residence features 7 bedrooms, 3 full baths, sun-filled spaces, soaring ceilings, hardwood floors & oversized windows framing the surrounding landscape. The 1st floor primary suite serves as a serene retreat, featuring a spa-inspired bath w dual sinks, walk-in shower, jetted tub, and an expansive walk-in closet. The gourmet kitchen is ideal for daily living & entertaining, offering a large island, custom cabinetry & seamless flow to a formal dining room with classic millwork. Additional highlights include a sunken Great Room with vaulted ceiling and a floor-to-ceiling LP gas fireplace, first-floor laundry/ Butler's pantry, central air, a two-car side-load garage, and a partially finished lower level that is suitable as 7th bedroom or theater room. An additional 1,720 sqft of unfinished lower-level space (formerly wine storage) offers potential for a gym, game room or other uses. The estate unfolds into a serene oasis with a tranquil pond, custom concrete patio & deck, firepit, and a 7-person spa overlooking apple trees and wildlife. Completing the property is a detached aux building with an existing, legally permitted use for wine tasting & wine sales, offering a rare and distinctive feature that further sets the estate apart. A rare opportunity to own a landmark estate offering timeless elegance, exceptional flexibility, unmatched tranquility.

2820 Balltown Road, Niskayuna

13388 Duanesburg Road, Delanson
$1,699,000
4 Beds ⋅ 4 Baths ⋅ 202528482 MLS
The approach to The Grey Arrow feels almost cinematic. An 800-foot tree-lined drive leads to a Civil War-era farmhouse, its presence both commanding and welcoming. For five generations, this homestead has been a place of memory and stewardship. Under its current owners, it has been thoughtfully reborn--its history preserved, its comforts elevated, its spirit transformed into a modern sanctuary. Inside, the foyer introduces the home's character with Helderberg bluestone etched in arrowhead motifs. Beyond it, light-filled rooms open where wide-plank pine floors run beneath tall windows and two Rumford fireplaces anchor the living spaces with warmth and intention. The kitchen blends rustic authenticity with contemporary luxury: original 1850s beams, reclaimed-wood cabinetry, quartz countertops, and GE Café appliances that make daily rituals feel indulgent. A gas stove with indoor grill, hands-free faucet, and instant-hot sink at the coffee and tea bar elevate everyday living. Behind a hidden door, an expansive butler's pantry offers quiet order. The home unfolds in wings. The primary suite is a restorative retreat with a soaking tub, tiled shower, fog-free LED mirrors, and WiFi-enabled NuTone speakers. The guest wing, connected discreetly, offers comfort and privacy. Every bathroom has been fully renovated with intention. Beyond the main house, a 500-square-foot guest studio with cathedral ceilings, exposed beams, and a renovated bath offers endless possibility--an artist's loft, recording space, office, or serene guest quarters. Four hand-hewn barns from 1850-1910 stand ready for reinvention or preservation. The land itself is a defining character. 113 acres of meadows, gardens, forest, and trails invite exploration. A spring-fed pond mirrors the sky. Riverstone hardscaping and heirloom gardens frame moments of stillness. Mornings begin slowly on the bluestone patio; evenings stretch long with painted sunsets and firelight under the stars.

13388 Duanesburg Road, Delanson

8-16 Swan Street, Schenectady
$1,575,000
44 Beds ⋅ 15 Baths ⋅ 202626865 MLS
Pleased to present 8-16 Swan Street, a 15-unit multifamily portfolio spanning three buildings in Schenectady. The property offers established in-place income with meaningful upside through multiple channels, including below-market rents, a largely flexible rent roll, an underutilized coin-operated laundry facility, substantial off-street parking, and a separate storage building. Separate tenant-paid utilities provide a strong operating foundation, while the scale of the portfolio and concentration of additional income opportunities give new ownership several clear paths to grow NOI. Conveniently located near Downtown Schenectady, I-890, Union College, and significant ongoing investment throughout the surrounding area.

8-16 Swan Street, Schenectady

3405 Rynex Corners Road, Princetown
$1,499,900
4 Beds ⋅ 4 Baths ⋅ 202626070 MLS
A Rare 163-Acre Estate Offering Exceptional Privacy & Endless Possibilities The original part of the home has 2,584 Sq feet and about 1,875 new addition was completed in September 2022 total of 4459 on 2 levels Set approximately 0.7 mile from the road, the property offers a remarkable sense of seclusion and tranquility. Rolling hills, open areas, wooded acreage, and beautiful natural surroundings create a true sanctuary for nature lovers, equestrian enthusiasts, or anyone seeking a private country estate. The residence combines historic character with a comfortable and functional floor plan. A substantial newer addition provides over 1,800 square feet of additional above-grade space, complemented by a large finished lower level of over 1000 square feet with egress windows, creating tremendous flexibility for recreation, entertaining, home offices, guest accommodations, or other uses. The property is exceptionally well equipped for horses and agricultural pursuits, featuring five detached buildings, including two garages, a stallion barn, a 12-stall horse barn with tack room, and a maintenance barn. The expansive acreage and rolling terrain offer wonderful opportunities for private riding trails, pastures, recreation, farming, or simply enjoying the peace and beauty of the land. Whether envisioned as a private equestrian estate, horse boarding operation, trail-riding property, agricultural retreat, recreational sanctuary, or multigenerational country compound, the possibilities here are truly remarkable. With 163.35 acres offered as one parcel, substantial existing infrastructure, incredible privacy, and a setting that is increasingly difficult to find, 3405 Rynex Corners Road presents a rare opportunity to create something truly special. Partial baseboard Heating & partial central heating 7 AC Chimney for wood / pellet stove in the basement. Propane powered Generac, generator included. Wired Internet Do not miss & schedule Now!!

3405 Rynex Corners Road, Princetown

37 Covington Court, Niskayuna
$1,299,000
4 Beds ⋅ 5 Baths ⋅ 202622935 MLS
Designed and built by renowned builder Peter Sotile, this one-of-a-kind custom contemporary offers nearly 6,000 square feet of thoughtfully designed living space, which includes an exceptional finished lower level. Expansive windows and skylights fill the home with natural light while bringing the beauty and serenity of the surrounding landscape indoors. The private primary suite is tucked away on its own wing and features two unique balconies--one overlooking the dramatic sunken living room and another accessed through sliding glass doors, where you can enjoy peaceful treetop views of the surrounding forest. A separate bedroom wing offers outstanding flexibility, featuring a shared living area, three spacious bedrooms, and two full bathrooms--ideal for family, guests, or multigenerational living. The oversized second-floor loft overlooks the grand foyer, family room, and kitchen, creating an open and airy atmosphere. The inviting library is introduced through beautifully etched double doors, while the formal dining room showcases elegant inlaid hardwood flooring and sliding glass doors leading to a screened porch. Recent updates provide peace of mind and modern comfort, including two approximately five-year-old heating and air conditioning systems, a newer roof, and an on-demand hot water system. The expansive finished lower level features an oversized recreation room perfect for entertaining, game nights, celebrations, or hosting large gatherings. This exceptional Baldwin Farms residence combines distinctive architecture, generous living spaces, and a tranquil natural setting to create a truly remarkable place to call home. All in the award winning Niskayuna School District! The dining room light fixture is excluded.

37 Covington Court, Niskayuna

180 Erie Boulevard, Schenectady
$1,250,000
202625867 MLS
Prime redevelopment opportunity in the heart of Downtown Schenectady, offered at $1,250,000. Located along the Erie Boulevard corridor, this approximately 23,000 SF, three-story commercial building presents a unique opportunity for redevelopment, adaptive reuse, or repositioning, with potential for a variety of commercial and mixed-use applications, including residential conversion. The property features approximately 7,500 SF floorplates, three levels of space, and convenient first-floor loading dock access. The building has been exceptionally well maintained and offers strong potential for investors, developers, and owner-users looking to capitalize on the continued revitalization of Downtown Schenectady. Situated in an area benefiting from recent and proposed development initiatives, including support through the City of Schenectady's Strategic Investment Plan and Downtown Revitalization Initiative.

180 Erie Boulevard, Schenectady

13 Pinecrest Drive, Schenectady
$1,124,000
5 Beds ⋅ 5 Baths ⋅ 202620994 MLS
Luxury New Construction. Custom Home to be built. Welcome to 13 Pinecrest Dr, a stunning Griner Construction custom home in quiet Niskayuna established neighborhood. Located within the Niskayuna School District. Now is the perfect time to personalize your dream home! Now is the time for you to select all of your finishes + design details. This 3,232 sq ft home showcases timeless craftsmanship and today's most sought-after features. The open-concept floor plan includes a bright and airy great room w/ a cozy gas fireplace, elegant dining area, and a chef's kitchen with quartz countertops, Schrock custom soft-close cabinetry, and stainless-steel appliances, perfect for entertaining. Bring your plans or use our Custom Home Plans. Your Dream Home Awaits!! Photos are examples of homes built.

13 Pinecrest Drive, Schenectady

©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

How much is your home worth?

Get instant property value now!