Refine Search
Map
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
3041 Mariaville Road, Rotterdam
$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, 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