Refine Search
Sort by
303 Terrace Road, Rotterdam
$399,000
5 Beds ⋅ 4 Baths ⋅ 202626542 MLS
A TRUE MID-CENTURY MODERN GEM in Rotterdam's distinctive West Hill community! Designed by architect Victor Civkin, this remarkable 5-bedroom, 3.5-bath home offers 3,041 sq ft of living space, authentic architectural character & an exceptionally private wooded setting. Situated on a .44-acre homesite PLUS an adjoining .20-acre parcel, the property offers approximately .64 acres combined, w/ West Hill's natural land behind the home, creating a rare sense of privacy w/ no close neighboring homes. Inside, walls of windows flood the home w/ natural light & frame the surrounding woods, while original Spanish Mahogany paneling, extensive built-ins & a striking bluestone gas fireplace showcase the craftsmanship of its Mid-Century Modern design. Radiant heat runs throughout the home & the original architectural plans convey with the property! The multi-level floor plan offers incredible flexibility. Four generously sized bedrooms & two full baths occupy the second floor, including an en-suite bedroom w/ a massive double closet & built-ins. Then head to the THIRD FLOOR, where an enormous fifth bedroom features its own FULL EN-SUITE BATH & access to a FULL ROOFTOP DECK, an incredible private retreat, guest suite or work-from-home escape. The lower level adds even more possibilities w/ a recreation/bonus space, wet bar, private exterior entrance & separate workshop area, ideal for guests, extended living, hobbies or entertaining. A three-season room, expansive patio, large front and rear yards, cedar siding and a two-car garage w/ newer doors complete the property. And then there's West Hill. Enjoy a truly unique neighborhood surrounded by extensive natural land & trails, w/opportunities for hiking, walking, snowshoeing & cross-country skiing, plus a community pond, gazebo, playing field and tennis/pickleball. This isn't a cookie-cutter home. It's architectural, light-filled, private & packed w/ original character...a one-of-a-kind Mid-Century Modern retreat!

303 Terrace Road, Rotterdam

671 Mariaville Road, Schenectady
$899,900
3 Baths ⋅ 202625381 MLS
Impressive mixed-use commercial property on a desirable corner lot at 671 Mariaville Road, Schenectady! This high-traffic location features four established retail tenants -- including a pool supply store, gun and ammo reseller, and fishing supply shop -- anchored by the Delgallo Pools and Wagon Train BBQ Restaurant, a regional favorite that draws steady customer traffic. Real estate only for sale. The property was extensively remodeled in 2004, with numerous updates throughout, including a complete roof replacement using 50-year rubber slate-style shingles for long-term durability and low maintenance. Zoned B-1, the property allows for a wide range of business and redevelopment opportunities. A stand-alone 16' x 20' office building offers flexible build-to-suit options for future tenants seeking a smaller, more manageable retail or professional space. Additional income is generated from a retail propane fill station, further enhancing cash flow. The second floor includes a well-kept one-bedroom apartment, adding residential rental income. With projected gross annual rents exceeding $130,000, this property provides strong, diversified income potential, long-term stability, and exceptional visibility in a growing commercial corridor! Businesses are excluded from the sale, the Gun Store, and the pool supply store are both negotiable.

671 Mariaville Road, Schenectady

1306 Putnam Road, Rotterdam
$749,900
4 Beds ⋅ 3 Baths ⋅ 202618807 MLS
Welcome to a rare 2.6-acre retreat where lifestyle, privacy, and possibility all come together. Custom-built in 1991 and freshly repainted inside and out, this 4,300 sq ft home blends timeless craftsmanship with modern comfort -- including a heated/insulated attached garage, a second full kitchen, and a heated sunroom with its own indoor garden. One of the home's most charming surprises is found in the finished lower level: a BellSouth payphone that instantly sparks nostalgia and a full bar originally from the legendary Ground Round restaurant -- the perfect conversation pieces for hosting, game nights, or creating your own entertainment space with personality and history. Outdoors, the property unfolds as a place to stretch out, breathe deeper, and settle in. Enjoy a 14-foot-deep, fully stocked pond and powered fountain, surrounded by open lawn and mature trees. The detached 1,300 sq ft heated and insulated garage offers incredible flexibility with a vehicle lift, making it ideal for car collectors, hobbyists, or home-based businesses. A mix of heating sources (oil, propane, electric), forced hot air with central air, well, and septic provide year-round efficiency and peace of mind. With 4 bedrooms, 3 full baths, a half bath, two full kitchens, expansive gathering spaces, and room to stretch out both indoors and out, this is a property designed for comfort, creativity, and lifestyle. 1306 Putnam Road, Schenectady, NY -- a one-of-a-kind setting where memories are made, hobbies thrive, and every day feels a little bit like a retreat. Sq Ft according to the seller / builder plans.

1306 Putnam Road, Rotterdam

8 Orchard Street, Rotterdam
$269,000
3 Beds ⋅ 1 Baths ⋅ 202616779 MLS
Discover timeless charm in this traditional home located in Rotterdam Junction within the desirable Schalmont School District, just steps from the historic Mabee Farm. This 3-bedroom home with a versatile den downstairs features beautiful hardwood floors throughout and a freshly painted front porch, perfect for relaxing. A bright bay window alcove creates a cozy nook and fills the home with natural light. Enjoy outdoor living on the back deck overlooking the shed and spacious yard. Situated on a rare double lot, there's ample space to add a garage and driveway, garden, pool, or outdoor living space. Character, history, and opportunity combine in this inviting property--don't miss your chance to make it yours!

8 Orchard Street, Rotterdam

©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