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

$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

©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