Refine Search
Sort by
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

1836 Oakland Avenue, Schenectady
$400,000
5 Beds ⋅ 3 Baths ⋅ 202627914 MLS
City living with suburban space and serenity! Tucked into a picturesque neighborhood of tree-lined streets and sidewalks, this charming 5-bedroom, 2.5-bath home offers privacy and room to breathe, just minutes from everything Schenectady has to offer. Inside, approximately 2,500 square feet of sun-filled living space features hardwood floors, vintage charm and thoughtful updates. A spacious formal living room with a stunning 12-foot bay window flows into the dining room, perfect for gatherings. Cozy up by the wood-burning fireplace in the additional family room, or enjoy the flexibility of a first-floor bedroom with built-in shelving, ideal for a home office, library or guest space. Upstairs, the spacious primary suite offers a private full bath, plus 3 additional bedrooms and shared full bathroom. Approximately 650 square feet of finished basement space provides even more room to live, work or play. Outside, the generous corner lot feels like a private oasis! The fenced backyard offers room for four-legged friends to roam, while the above-ground pool, patio and gazebo set the scene for summer entertaining. Newly installed, OWNED solar panels add value and potential energy savings without lease payments or tricky fine-print. Just minutes from Union College, Ellis Hospital, Upper Union Street and downtown, enjoy local restaurants, coffee shops, the Schenectady Greenmarket, Proctors Theatre, Rivers Casino and a vibrant arts scene. Explore the city, then come home to your peaceful retreat. All the charm of an established neighborhood, the excitement of city living and space to truly make yourself at home! Open House Saturday, 10/10 from 10am-12pm.

1836 Oakland Avenue, Schenectady

1092 Merlin Drive, Niskayuna
$624,900
4 Beds ⋅ 3 Baths ⋅ 202627741 MLS
Stunning kitchen. Scenic backyard. Exceptional Niskayuna location. Welcome to 1092 Merlin Drive, a beautifully upgraded 4-bedroom, 2.5-bath Colonial offering 2,330 sq. ft. plus a finished basement. The welcoming foyer features marble flooring, crown molding, chair rail and a hardwood staircase. The showpiece kitchen boasts an oversized chef's island with built-in microwave and bread warmer, Taj Mahal Quartzite countertops, Thermador gas range, marble backsplash, under-cabinet lighting, custom cabinetry, walk-in pantry and breakfast nook. The living room features custom built-ins and a gas fireplace. The spacious primary bedroom offers a Juliet balcony with a picturesque river view. Recessed LED lighting and ceiling fans add to the home's thoughtful upgrades. The finished basement offers LVP flooring, fireplace, bar room and oversized laundry area. Outside, enjoy an oversized patio, beautiful landscaping and a deck with natural gas hookup for a grill or firepit. Large driveway, 2-car garage, central air and smart locks complete the home. Niskayuna Schools/Birchwood Elementary.

1092 Merlin Drive, Niskayuna

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

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

1005 Fairlane Road, Rotterdam
$989,900
6 Beds ⋅ 5 Baths ⋅ 202623835 MLS
A once in a generation opportunity to own one of Rotterdam's most distinguished custom built estates. The first home built in this prestigious neighborhood, this landmark residence has long been admired for its exceptional quality, timeless architecture, and enduring craftsmanship. Situated on beautifully landscaped, park-like grounds, this extraordinary home offers approximately 6,300 square feet above grade plus an additional 3,000 square feet of finished lower level living space. A dramatic two story foyer welcomes you with marble floors, a sweeping staircase, and powder room. Formal living and dining rooms feature original hardwood floors preserved beneath carpeting since 1959, pocket doors, and an adjoining garden room complete with a wet bar, indoor grill, and dual sliding doors to the backyard. The spacious eat in kitchen offers abundant cabinetry and Corian countertops. The inviting family room features a Roman brick fireplace with slate hearth, oversized windows, and a built in bar closet. A stunning executive office showcases rich walnut paneling, custom built-ins, and a cherry coffered ceiling. The main level also includes a spacious primary suite with dual closets and private bath, plus a second bedroom and full bath. Upstairs are four generously sized bedrooms with hardwood floors, ample closet space, a cedar closet, linen closet, two large storage rooms, and a full bath with triple vanity, soaking tub, and separate shower. The finished lower level includes a family room with fireplace, recreation room, kitchenette, office, wine cellar, half bath, and an expansive two room woodworking shop. The striking brick and Kentucky bluestone exterior is complemented by an inground pool, pool house with bath and shower, lighted bocce court, gazebo, tree house, three-car attached garage, and beautifully landscaped grounds. Additional features include three Lennox furnaces, two central air systems, and generator hookup Adj .71acre building lot available separately

1005 Fairlane Road, Rotterdam

37 Covington Court, Niskayuna
$1,299,000
4 Beds ⋅ 5 Baths ⋅ 202622935 MLS
Designed and built by renowned builder Peter Sotile, this one-of-a-kind custom contemporary offers nearly 6,000 square feet of thoughtfully designed living space, which includes an exceptional finished lower level. Expansive windows and skylights fill the home with natural light while bringing the beauty and serenity of the surrounding landscape indoors. The private primary suite is tucked away on its own wing and features two unique balconies--one overlooking the dramatic sunken living room and another accessed through sliding glass doors, where you can enjoy peaceful treetop views of the surrounding forest. A separate bedroom wing offers outstanding flexibility, featuring a shared living area, three spacious bedrooms, and two full bathrooms--ideal for family, guests, or multigenerational living. The oversized second-floor loft overlooks the grand foyer, family room, and kitchen, creating an open and airy atmosphere. The inviting library is introduced through beautifully etched double doors, while the formal dining room showcases elegant inlaid hardwood flooring and sliding glass doors leading to a screened porch. Recent updates provide peace of mind and modern comfort, including two approximately five-year-old heating and air conditioning systems, a newer roof, and an on-demand hot water system. The expansive finished lower level features an oversized recreation room perfect for entertaining, game nights, celebrations, or hosting large gatherings. This exceptional Baldwin Farms residence combines distinctive architecture, generous living spaces, and a tranquil natural setting to create a truly remarkable place to call home. All in the award winning Niskayuna School District! The dining room light fixture is excluded.

37 Covington Court, Niskayuna

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

How much is your home worth?

Get instant property value now!