Refine Search
Sort by
$349,999
8 Beds 4 Baths 202616229 MLS
Tucked away on a quiet dead-end street in Rotterdam Junction, this stunning 8-bedroom, 3 and a 1/2 bath single-family home offers the perfect blend of privacy, space, and scenic beauty surrounded nature from overlooking the forest to Mountain views. This property features a spacious U-shaped driveway with ample parking, brand-new flooring throughout, and a beautifully updated kitchen with modern backsplash. The expansive layout includes a luxurious primary suite with a cathedral-style bath, plus seven additional bedrooms upstairs with 2 additional full and half baths--ideal for large households or investment potential. Whether you're looking to create lasting memories or explore income opportunities (ideal for Airbnb), this unique home delivers exceptional versatility in a serene setting. Property As-Is.

11 Parkis Street

$699,900
3 Beds 2 Baths 202615414 MLS
A rare opportunity in the highly sought-after Niskayuna School District! Welcome to 929 Pearse Rd. Set on 1.78 acres, this beautiful property offers the chance to build your dream home with a local builder. Bring your own plans or build approved plans for a 2,000 sq ft ranch starting at $699,900. The thoughtfully designed layout includes 3 bedrooms, 2 bathrooms, a 2-car attached garage, and an additional 2-car detached garage--perfect for extra storage, hobbies, or workspace. Planned finishes include engineered hardwood floors and quartz countertops, combining quality craftsmanship with modern style. Buyers also have the flexibility to customize, with options to add approximately 600 sq ft above the garage for a bedroom, bathroom, and loft or in-law suite. Prefer something different? Build to suit and bring your own vision to life. Ideally located near the Town of Town of Colonie Golf Course, local restaurants, and everyday conveniences, this property offers the perfect blend of privacy and accessibility in one of the Capital Region's most desirable areas. Don't miss this unique opportunity to create a home tailored to your lifestyle in a prime location. Make sure to check out the virtual tour and YouTube video. Pictures are of Builder's work at different site.

929 Pearse Road

$375,000
3 Beds 3 Baths 202614157 MLS
Welcome to 703 Union Street, a mixed use property offering both a successful restaurant on the first floor and a fully updated apartment above. The ground level is home to Termeh Persian Restaurant, a well known local favorite with over 60 five star reviews and a strong repeat customer base. The restaurant is fully equipped, with all kitchen appliances, hood system, and ventilation up to code, making this a true turn key opportunity for a new owner. The second floor apartment offers three bedrooms, one full bath, and a large family room with views of Union Street. It is perfect for an owner occupant or as an additional rental unit for extra income. Both the building and the business are included in the sale, making this a great fit whether you are an investor or someone looking to operate their own restaurant in a proven location. Additional features include off street parking, handicap accessible entry, and excellent street visibility. This section of Union Street continues to see steady development and growth, and the property is located just minutes from Union College, adding to its long term value and demand. A rare chance to own a true turn key mixed use property with both residential and commercial income.

703 Union Street

$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

$549,900
4 Beds 4 Baths 202612937 MLS
To Be Built - The Janet Ann- Build your dream home- with a duplex on this beautiful 3.58 acre site in the scenic country side in the town of Duanesburg! Located just 5 minutes from the village and the desirable Duanesburg School District, this property offers an ideal blend of privacy and convenience--close to recreation, dining, and shopping. The Janet Ann model features 1,957 SF of thoughtfully designed living space with 4 bedrooms and 4 full baths on one floor. Enjoy an open-concept layout perfect for modern living, including a bright kitchen with quartz countertops and Fabuwood cabinets with soft-close doors. The primary suites offer comfort and style with an en-suite bath featuring cultured marble countertops. LVT flooring flows through the main living areas, while bedrooms are comfortably carpeted. The full basement with 8-foot ceilings provides even more opportunity for future living or storage. To-be-built. Photos are digital renderings and virtually staged for illustration purposes.

453 Gage Road

$399,000
202611781 MLS
Turn-key automotive repair facility for sale, including building, equipment, and business assets. Property features three service bays with two installed vehicle lifts and adequate space to add a third lift for expanded capacity. Sales to include all shop tools, toolboxes, and commercial air compressor system. Additional improvements include a professional spray booth suitable for auto body and paint work. Equipment included: tire mounting machine and wheel balancer. Inspection machine on site (currently not operational; can be update by new owner). Sale also includes a Jeep 4x4 with snow plow attachment, providing added value for property maintenance or supplemental business use. Ideal opportunity for owner-operator or established automotive business seeking a fully equipped facility with room for growth.

885 Strong Street

$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

$499,895
2 Beds 2 Baths 202529637 MLS
Join Rotterdam's Newest 55+ Community Today & Enjoy The Carefree Lifestyle You've Been Yearning For. One Floor Living In One Of Our 1500 Sq Ft Cottages Featuring Covered Front Porch, Den, Primary Bedroom w/ Walk-In Closet & Pvt Bath, Guest Bedroom w/ Walk-In Closet, Main Bath, Eat-In Kitchen w/ Granite Counters & SS Appl Pkg, Combined Great Rm/ Dining Rm w/ Sliding Doors to Covered Patio, Finished Walk-Up 500 Sq Ft Bonus Room & Storage, 2 Car Att Garage w/ Opener, Off St Pkg, Nat Gas Hot Air Heat, Elec HW, Full Basement, Gas Fireplace. Interior Selections Available, HOA, Front/Side IG Sprinklers, 200 Amp CB Elec; Fire Suppression, Security & Emergency Call Systems, Ctrl A/C, Clubhouse, Golf Course, Public Water & Sewer, Mohonasen CSD. SPEC HOME READY IN < 30 DAYS.

125 Whispering Pines Way

©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