Skip main navigation
Off market
  • $1,011,400

    150 Waterville Rd, Farmington, CT 06032

    4beds
    4,254sqft
    SingleFamily
    Built in 2002
    3.28 Acres Lot
    $1,011,400 Zestimate®
    $238/sqft
    $6,181 Estimated rent

    Owner options

    List your home for rent

    $6,181/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $6,181/mo

    Rent Zestimate®

    Refinance and save

    $7,313/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $7,313/mo

    Est. payment

    What's special

    Modern, new and delightfully organic, huge wall-sized windows artfully beckon the manicured lawn, flowers and plantings inside, in perfect symmetry with each room's architecture. (3,771sf 12 rms, 4BR/4.1 baths) Designed by a Stonington architect, visitors delight in the massive stone frogs, symbolizing joy and prosperity, which flank the front entrance. The soaring open floor plan with cathedral ceilings gracefully flows from one interesting space to the next. The floor-to-ceiling windows in the living/dining room and the kitchen dwarf the occupants and command attention. The use of natural materials: solid oak floors and cabinets, custom granite in the kitchen and all baths, and red sandstone and Mexican tiled floors add to the quiet natural beauty of this unique and impeccably maintained home. All three bedrooms enjoy full custom granite baths and walk-in closets. The fireplaces (upstairs with granite) and downstairs (with sandstone) are beautifully designed as well. Downstairs there is a finished lower level with two areas: the fireplace family room and a light, airy sunroom. In addition there is a second finished large basement room for laundry and storage and a wine cellar with more storage. However, the true surprise downstairs is the completely light and private apartment complete with a separate entrance. Amazingly complete with a full kitchen and bath, separate bedroom, living/dining room, and large outdoor terrace and garden. The outdoor lawn and gardens are a sight to behold and treasure with Cherry, Dogwood and Crabtrees along with old growth Maple and Oak trees on 3.32 acres. The small wetlands preserve is a part of the property and ensures privacy. The 3 car garage and large (screened) backup generator complete the package. A tour of this property is de rigueur!

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 5
    • Full bathrooms: 4
    • 1/2 bathrooms: 1
    Heating
    • Forced air, Oil
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Microwave, Refrigerator, Trash compactor
    Features
    • Flooring: Tile, Hardwood
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 4,254 sqft

    Property

    Parking
    • Parking features: Garage - Attached
    Features
    • Exterior features: Wood
    Lot
    • Size: 3.28 Acres
    Details
    • Parcel number: FARMM0052B1A

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Contemporary
    Materials
    • Frame
    • Roof: Asphalt
    Condition
    • Year built: 2002

    Community & neighborhood

    Location
    • Region: Farmington
    Sell for more on Zillow
    Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
    $1,011,400
    2% more+$20,228
    With Zillow Showcase(estimated)$1,031,628