Refine Search
Sort by
$2,150,000
202613733 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

$499,900
202611021 MLS
Iconic Schenectady Restaurant/Bar! Don't miss this rare opportunity to own a well-known restaurant/bar with over 50 years of history in Schenectady's thriving North End! Recently acquired and now available again, this property is just steps from Mohawk Harbor, Rivers Casino, and the future Mohawk Harbor Arena. Indoor and outdoor seating for 75+ guests. Fully remodeled in 2011 with a large commercial kitchen: ovens, fryers, walk-in cooler, and ample prep space. Outdoor stone patio with roof (2011), updated plumbing and electrical. Sale includes the business, building, furniture, and equipment. Private parking lot + plenty of public parking. Garage door access to basement for easy deliveries. Perfect for owner-operators or investors—turnkey and ready to go! Owner financing is available

1857 Van Vranken Avenue

$575,000
4 Baths 202610875 MLS
Incredibly versatile beautifully maintained turnkey restaurant. Over 4300 of space on the main level could be divided into multiple spaces and or other businesses, with separate entrances. Currently a fully functioning restaurant, with full bar, cafe seating, a private dining room, and approx. 1200 sq ft that could be additional dining currently or a completely different business. There is also a residential apartment upstairs originally set up to be a 2 BR owners unit or additional offices about 600 Sq ft. The full basement offers offices, a full bath, walk in coolers/freezers, and tons of dry good storage. You couldn't rent this space for what you could own it for, excellent investment opportunity. Just 1/2 mile from Ellis Hospital, 1.5 miles to Rivers and Union College, and 2 miles to Proctors. Sale includes all FFE excepting some personal effects.

2015 Rosa Road

$1,990,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

$495,000
6 Beds 5 Baths 202530407 MLS
This property is a five-unit multifamily, located in the highly convenient and historic Union Street corridor. With approximately 2,932 square feet of living space and three stories, this building offers strong investment potential in one of Schenectady's most active rental areas. Built in 1984, the property sits on a 28-by-150-foot lot with municipal water and sewer, public utilities, and off-street parking via the shared driveway. The location provides exceptional accessibility. Union College, Ellis Hospital, Schenectady High School, Downtown Schenectady, and Mohawk Harbor are all within easy reach, along with nearby shops, restaurants, and entertainment venues on Union Street itself. School proximities include Yates Elementary, Oneida Middle School, and Schenectady High School, all within 2 miles or less. This property is zoned for multi-family use and offers a reliable opportunity for investors seeking stable occupancy and long-term value in a well-connected neighborhood.

714 Union Street

$845,000
5 Beds 5 Baths 202529377 MLS
Experience the Perfect blend of luxury, comfort, & privacy in this stunning contemporary estate set on 28.17 acres. This spacious 4,333 sq. ft home features 5 BR, 4 1/2 baths, including a main-level primary suite w/generous closets, & beautifully appointed bathroom. The open Kitchen is ideal for entertaining. The great room with an entertainment center, wet bar, & pool table- perfect for gatherings and relaxation. Step outside through French doors to enjoy the inviting inground saltwater pool. Car Enthusiasts and hobbyist will appreciate both the attached 3 car garage, & 3 car detached garage that holds 6 cars, while the greenhouse offers exciting potential for gardening. Energy efficiency is a highlight, with OWNED Solar panels and a propane tank providing independence and savings. (Attached garage solar is, rented) Recent updates include a blue stone front retaining wall, newer sidewalks, foundational work, fresh exterior paint (2023), a newer awning, 2 new garage doors (attached) and an accessible ramp to the front entrance. This Property is a rare opportunity for those seeking unique amenities, expansive grounds, private retreat. A New Furnace installed in February 2026, and all new LBT flooring was installed in the basement in April 2026.

3041 Mariaville Road

$575,000
3 Baths 202529244 MLS
This is income producing property for investors or licensed professionals. Excellent for any professional office space or store with plenty of space to expand. Located on the high traffic road, next to I-88 and I-90. This Veterinary/Medical/ Mixed Use building is well established and emphasizes a strong focus on personalized care. This is a phenomenal potential for continuing Veterinary practice/Medical facility/Dental or Chiropractic clinic. Spacious +/- 2400SF include waiting area, 2 exam rooms, receptionist /waiting area, kennels, lab, cages, surgery, treatment and X-ray rooms with potential for 2nd floor addition and 1.17 acres there are many possibilities for growth. Property includes a +/- 3700SF single-family residence, offering live/work flexibility or supplemental income.

2241-2275 Duanesburg Road

$284,000
202528863 MLS
518 Hegeman Street - Versatile Commercial / Mixed-Use Building. Discover the potential of this two-story, 4,450± SF commercial building offering exceptional flexibility for a variety of uses. Situated in a convenient and accessible location, the property features multiple offices, classrooms, open meeting areas, a full kitchen, and restrooms on each level. Perfectly suited for daycare, educational, community, or faith-based programs, the layout provides ample room for group activities, administration, and storage. The building's adaptable floor plan also lends itself to office, studio, or small business use, with onsite parking and easy access for staff and visitors. Clean, well-maintained, and ready for its next chapter, 520 Hegeman Street presents a rare opportunity to own a move-in-ready property in a well-established neighborhood. Whether you're expanding your organization or starting something new, this versatile space is ready to accommodate your vision.

518 Hegeman Street

$759,900
4 Beds 3 Baths 202528591 MLS
Introducing a stunning new construction, to be built home in Niskayuna, situated on a generous private lot exceeding an acre. Boasting a carefully designed floor plan with four bedrooms and 2.5 bathrooms, this property offers the perfect balance of luxury, privacy and convenience. The tiled kitchen with a cozy dinette seamlessly connects to both, a formal living room and an elegant dining room. A spacious family room and a dedicated study can be found on the first floor. The upper level hosts a convenient laundry room and good sized bedrooms. In addition to a comfortable interior, the house features a spacious 2-car garage. Its desirable location next to shopping centers, restaurants, a casino as well as major highways, offers easy access to activities and transportation.

2573 Rosendale Road

$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

©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