Refine Search
Sort by
103 Ulrich Drive, Rotterdam
$674,900
4 Beds ⋅ 3 Baths ⋅ 202629213 MLS
Welcome to 103 Ulrich Drive, an exceptional new construction home situated on a beautiful half-acre lot along the Mohawk River in the Schalmont School District! Offering approximately 2,400 sq. ft. of thoughtfully designed living space, this stunning 4-bedroom, 2.5-bath home combines modern luxury with quality craftsmanship. The gorgeous kitchen features quartz countertops, a spacious island, tile backsplash, under-cabinet lighting, and high-end GE stainless steel appliances. Enjoy an inviting living area with a custom tile fireplace, a first-floor home office, and a convenient mudroom with built-in bench. The impressive primary suite boasts cathedral ceilings, an oversized walk-in closet, and a beautifully appointed bath with custom tile shower and makeup counter. Additional highlights include second-floor laundry, recessed lighting, dual-zoned HVAC, and durable waterproof LVP flooring. The oversized 3-car passthrough garage features its own heating zone. Beautiful board-and-batten exterior details, custom porch beams, and scenic Mohawk River views complete this remarkable property. Experience the perfect blend of style, comfort, and riverside living!

103 Ulrich Drive, 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

1276 Upper Gregg Road, Schenectady
$599,600
3 Beds ⋅ 3 Baths ⋅ 202627622 MLS
This amazing 2592 Sq. foot custom Contemporary Colonial is on 10.36 acres of very private land that offers amazing views of the local area and mountains. This well cared for home features 3 very nice size bedrooms and 3 full bathrooms, a vaulted ceiling foyer and living room with an open floor plan design. A few of the many custom features of this home include random width oak flooring and solid six panel pine doors plus Andersen windows throughout the home. This unique home also features a large private rear deck for entertaining with those amazing views. Large full basement with a workshop area and a wood stove. 2.5 car attached garage with high ceilings and a separate basement entrance. This country home also features a separate two story carriage house with 2 garage bays plus a large second floor loft area and separate electric power plus a chimney to hook up a furnace or a wood stove. The carriage house could potentially be finished into a quest house. All just a short drive from stores, shops and other Local amenities.

1276 Upper Gregg Road, Schenectady

303 Terrace Road, Rotterdam
$399,000
5 Beds ⋅ 4 Baths ⋅ 202626542 MLS
MCM LOVERS, RENOVATORS & VISIONARIES...THIS IS THE OPPORTUNITY YOU'VE BEEN WAITING FOR! Tucked into Rotterdam's distinctive WEST HILL community, this authentic 1950 Mid-Century Modern home, designed by architect VICTOR CIVKIN, is ready for its next chapter! Offering 3,041 SQ FT, 5 bedrooms, 3.5 baths & incredible original architectural details, 303 Terrace is a rare opportunity to restore, reimagine & make something truly extraordinary your own. BUT THE REAL SHOWSTOPPER? THE SETTING! Situated on a .44-acre homesite PLUS an adjoining .20-acre parcel, you'll enjoy approximately .64 ACRES of wooded privacy, with West Hill's natural land & trails directly behind the property, neighborhood open space alongside it & remarkable separation from neighboring homes! Inside, WALLS OF WINDOWS frame the surrounding woods & flood the home with natural light. Original SPANISH MAHOGANY paneling, extensive built-ins, hardwood floors, a stunning BLUESTONE GAS FIREPLACE & radiant heat throughout celebrate everything MCM enthusiasts love! Even the ORIGINAL ARCHITECTURAL PLANS convey! The flexible multi-level layout offers 4 second-floor bedrooms, including an en-suite, while the ENTIRE THIRD-FLOOR RETREAT features an expansive 5th bedroom, full en-suite bath & FULL ROOFTOP DECK! Downstairs, a bonus/recreation space with wet bar, private exterior entrance & workshop creates exciting possibilities for guests, extended family, hobbies or multigenerational living. Enjoy a three-season room, expansive patio, two-car garage & the unique WEST HILL LIFESTYLE, with wooded trails, pond, gazebo, playing field & tennis/pickleball opportunities. YES, THIS HOME NEEDS UPDATING. BUT THE ARCHITECTURE, ORIGINAL CHARACTER, SPACE & LOCATION? THOSE ARE THE THINGS YOU CAN'T RECREATE! Bring your vision & discover the extraordinary potential of 303 Terrace!

303 Terrace Road, Rotterdam

8812 Mariaville Road, Duanesburg
$495,000
4 Beds ⋅ 2 Baths ⋅ 202621198 MLS
Nestled along the tranquil shores of Mariaville Lake, this 4-bedroom, 2-full-bath waterfront home offers a rare opportunity to enjoy year-round lake living in one of the area's most peaceful settings. Set within a quiet, well-established lake community, the property captures serene water views and a sense of privacy that defines life on the lake. The spacious interior provides comfortable living with four bedrooms and two full baths, while large windows welcome natural light and frame the picturesque waterfront. The layout offers flexibility for everyday living, entertaining, or accommodating family and guests. Outside, the lake becomes an extension of the property, with opportunities for boating, kayaking, fishing, swimming, or simply relaxing while taking in the calm waters and surrounding natural beauty. From vibrant summer days to colorful autumn foliage and snow-covered winter landscapes, the setting offers exceptional beauty throughout every season. Conveniently located with easy access to I-88 while maintaining the charm and tranquility of lakeside living, this property presents an ideal opportunity for a year-round residence, seasonal getaway, or waterfront retreat. Experience the beauty, recreation, and peaceful lifestyle that make Mariaville Lake a truly special place to call home.

8812 Mariaville Road, Duanesburg

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

©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!