NOT LISTED FOR SALE
4 Beds
4.5 Baths
5,140 Sq Ft
1989 Built

Last Sold June 10, 2020

Last sale price $1,015,000 $197 Per Sq Ft

Highlights

  • Lake Front
  • Sub-Zero Refrigerator
  • Deck
  • Wine Cellar
  • Colonial Architecture
  • Property is near public transit

About This Home

As of June 2020

Located in sought after Sterling Lake, a private gated community of 13 homes, this house offers easy living. It is situated on a lake and is set at the end of a cul de sac. There is room for everyone in this elegant, spacious home. The gracious Living Room w/fireplace and large Family Room w/gas log fireplace, built ins both feature views of the lake and wildlife. The formal Dining Room is well suited for holiday parties with it's crown moldings, chair rails and bay window. The Eat In Kitchen offers granite counters, Top of the line SS appliances, center island, custom built cabinetry plus a wine fridge as well as access to the mahogany deck. The 2nd floor has 3 Bedrooms 1 en suite and the other two with a Jack and Jill Bathroom plus a den/2nd FR. The lower level is finished with a home office/BR, full bath, playroom and a wine cellar. The unfinished basement has a cedar closet and tons of storage as well as French door to the stone patio and backyard. Close to cafes, shopping and transportation. A must see!

Last Agent to Rent the Property

Maddy Shapiro

Coldwell Banker Realty License #RES.0621271 Listed on: 06/18/2020

Coldwell Banker Realty

Last Renter's Agent

Maddy Shapiro

Coldwell Banker Realty License #RES.0621271 Listed on: 06/18/2020

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1989

Lot Details

  • Lake Front
  • Lot Has A Rolling Slope
  • Sprinkler System
  • Property is zoned RD

HOA Fees

  • $567 Monthly HOA Fees

Home Design

  • Colonial Architecture
  • Clap Board Siding

Interior Spaces

  • Entertainment System
  • Sound System
  • 2 Fireplaces
  • Thermal Windows
  • Wine Cellar
  • Water Views
  • Pull Down Stairs to Attic
  • Home Security System

Kitchen

  • Built-In Oven
  • Gas Cooktop
  • Range Hood
  • Microwave
  • Sub-Zero Refrigerator
  • Ice Maker
  • Dishwasher
  • Wine Cooler
  • Compactor

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Laundry Room
  • Laundry on main level
  • Washer
  • Gas Dryer

Partially Finished Basement

  • Heated Basement
  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Interior Basement Entry
  • Basement Storage

Parking

  • 2 Car Attached Garage
  • Parking Deck
  • Automatic Garage Door Opener
  • Driveway

Outdoor Features

  • Deck
  • Patio
  • Exterior Lighting

Location

  • Property is near public transit
  • Property is near a golf course

Schools

  • Davenport Ridge Elementary School
  • Rippowam Middle School
  • Stamford High School

Utilities

  • Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • Power Generator
  • Cable TV Available

Listing and Financial Details

  • Exclusions: All attached items & draperies remain in home.

Community Details

Overview

  • Association fees include grounds maintenance, property management, road maintenance
  • Sterling Lake Community

Amenities

  • Public Transportation

Home Details

Home Type

Single Family

Year Built

Built in 1989

Lot Details

0

HOA Fees

$567 per month

Rental Info

  • Landlord Requirements: Credit Check, References Required, Security Deposit, Lease Required
  • Landlord Responsibility: Exterior Maintenance, Insurance, Real Estate Taxes
  • Lease Price Description: Per Month
  • Pets Allowed: No
  • Rental Duration: Short Term Unfurnished
  • Security Deposit Details: Two months rent, one month’s security
  • Smoking Allowed: No
  • Tenant Responsibility: Air Conditioning, All Utilities, Cable TV, Credit Check, Electricity, Heat, Hot Water, Insurance, Security System, Sewer, Snow Removal, Trash Service, Water

Listing Details

  • Neighborhood: Newfield
  • Property Type: Residential Rental
  • Style: Colonial
  • Sq Ft Est Heated Above Grade: 3427
  • Public Record Living Room Sq Ft: 3427
  • Sq Ft Est Heated Below Grade: 1713
  • Total Sq Ft: 5140
  • Year Built: 1989
  • Nearby Amenities: Golf Course, Health Club, Lake, Library, Medical Facilities, Park, Public Transportation, Tennis Courts
  • Property Sub Type: Condominium Rental
  • Exclusions: All attached items & draperies remain in home.
  • Direct Waterfront: Yes
  • End Unit: Yes
  • Radon Mitigation Air Ynu: No
  • Radon Mitigation Water Ynu: No
  • Public Record Gross Sq Ft: 6481
  • Directions: High Ridge Rd., to Buxton Farms Rd. Left onto Turn of River Rd., gated community on left. Wait for gate to open all the way.
  • Special Features: None

Interior Features

  • Room Count: 12
  • Total Bedrooms: 4
  • Total Bathrooms: 5.00
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Fireplaces: 2
  • Attic Description: Pull-Down Stairs
  • Basement Description: Full With Walk-Out, Partially Finished, Heated, Interior Access, Walk-out, Storage
  • Interior Amenities: Audio System, Auto Garage Door Opener, Cable - Available, Security System
  • Appliances: Gas Cooktop, Wall Oven, Microwave, Range Hood, Subzero, Icemaker, Dishwasher, Compactor, Washer, Gas Dryer, Wine Chiller
  • Additional Rooms: Laundry Room, Wine Cellar
  • Laundry Room Location: Main floor
  • Laundry Room Info: Main Level
  • Attic: Yes
  • Home Automation: Entertainment System, Security System

Exterior Features

  • Exterior Features: Deck, Lighting, Patio, Underground Sprinkler
  • Exterior Siding: Clapboard
  • Waterfront Description: Lake, Access
  • Swimming Pool: No

Garage/Parking

  • Garage Parking Info: Attached Garage
  • Garages Number: 2
  • Driveway Type: Paved

Utilities

  • Cooling System: Central Air
  • Heat Type: Hot Air, Zoned
  • Heat Fuel Type: Natural Gas
  • Hot Water Description: Domestic
  • Water Source: Public Water Connected
  • Sewer: Public Sewer Connected

Condo/Co-op/Association

  • Association Fee Includes: Grounds Maintenance, Property Management, Road Maintenance
  • Complex Name: Sterling Lake
  • HOA Fees: 1700
  • HOA Fee Frequency: Quarterly
  • HOA: Yes

Green Features

  • Energy Features: Generator, Thermopane Windows

Lot Info

  • Lot Description: Water View, Rolling
  • Flood Zone: No
  • Zoning: RD

Tax Info

  • Mil Rate Tax District: 0.440
  • Assessor Parcel Number: 347774

Multi Family

  • Total Num Of Units: 13

MLS Schools

  • Elementary School: Davenport Ridge
  • Middle Jr High School: Rippowam
  • High School: Stamford

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
06/26/2020 06/26/20 Rented $6,200 +3.3% --
06/24/2020 06/24/20 Under Contract -- -- --
06/18/2020 06/18/20 For Rent $6,000 0.0% --
06/10/2020 06/10/20 Sold $1,015,000 -2.3% $197 / Sq Ft View Prior Sale
02/28/2020 02/28/20 Pending -- -- --
01/01/2020 01/01/20 For Sale $1,039,000 -16.5% $202 / Sq Ft
03/19/2015 03/19/15 Sold $1,245,000 -5.3% $295 / Sq Ft View Prior Sale
02/17/2015 02/17/15 Pending -- -- --
09/11/2014 09/11/14 For Sale $1,315,000 -- $311 / Sq Ft
Source: SmartMLS

Tax History Compared to Growth

Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 170305613

SmartMLS

APN: STAM 004-0699