$1,866,507 - $3,682,000
RENTED APR 4, 2025
5 Beds
4.5 Baths
8,750 Sq Ft
$281 Price per Sq Ft

Highlights

  • Lake Front
  • Colonial Architecture
  • 2 Fireplaces
  • Burr Elementary School Rated A
  • Attic
  • Cul-De-Sac

About This Home

As of April 2025

Tucked away on a quiet cul-de-sac, this 8,000 sq. ft. lakeside estate has luxury and privacy just minutes from NYC. Enjoy soaring ceilings, a chef's kitchen, and stunning panoramic views. The home features a 2,000+ sq. ft. in-law suite with a private entrance, a 1,300 sq. ft. office, and a 3-car garage with extra parking for 10. With 284 feet of direct lake frontage, a private beach, dock, and access to five beaches, this is a water lover's dream. Inside, floor-to-ceiling windows, walk-in closets, a steam room, and smart home features create the perfect blend of comfort and sophistication. Outdoor spaces include balconies, patios, fire pits, and a 55-foot landscaped courtyard, ideal for year-round enjoyment. Located in a top-rated suburb with A+ schools, this home is close to highways, airports, and premier shopping. A rare opportunity to own a private resort-style retreat!

Last Agent to Rent the Property

Carol Horsford

Farnam Realty Group License #REB.0790307 Listed on: 02/04/2025

Last Renter's Agent

Michael Vartuli

Keller Williams Realty License #RES.0828254

Keller Williams Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $32,009

Year Built

  • Built in 1974

Lot Details

  • 0.73 Acre Lot
  • Lake Front
  • Cul-De-Sac
  • Property is zoned AA

Home Design

  • Colonial Architecture

Interior Spaces

  • 2 Fireplaces
  • Basement Fills Entire Space Under The House
  • Attic

Kitchen

  • Gas Range
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 5 Bedrooms

Laundry

  • Dryer
  • Washer

Parking

  • 3 Car Garage
  • Private Driveway

Location

  • Property is near shops

Schools

  • Burr Elementary School
  • Fairfield Warde High School

Utilities

  • Central Air
  • Hot Water Heating System
  • Heating System Uses Natural Gas
  • Hot Water Circulator

Listing and Financial Details

  • Assessor Parcel Number 125041

Home Details

Home Type

Single Family

Est. Annual Taxes

$32,009

Year Built

Built in 1974

Lot Details

0

Rental Info

  • Pets Allowed Info: Text listing broker
  • Lease Price Description: Per Month
  • Pets Allowed: Restrictions
  • Rental Duration: Yearly Unfurnished
  • Smoking Allowed: No

Listing Details

  • Neighborhood: Lake Hills
  • Property Type: Residential Rental
  • Style: Colonial
  • Sq Ft Est Heated Above Grade: 6605
  • Sq Ft Est Heated Below Grade: 2145
  • Total Sq Ft: 8750
  • Year Built: 1974
  • New Construction: No/Resale
  • Nearby Amenities: Lake, Medical Facilities, Park, Private School(s), Shopping/Mall
  • Property Sub Type: Single Family Rental
  • Direct Waterfront: Yes
  • Directions: Use GPS
  • Living Area Sq Ft Per Public Record: 4927
  • Street Type: Road
  • Tenant Responsibility: All Utilities
  • Special Features: None

Interior Features

  • Total Bedrooms: 5
  • Total Bathrooms: 5
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Fireplaces: 2
  • Attic Description: Walk-In
  • Basement Description: Full
  • Appliances: Gas Range, Microwave, Dishwasher, Washer, Dryer, Refrigerator
  • Attic: Yes
  • Street Number Modifier: 475
  • Other SqFt Description: Attic is finished

Exterior Features

  • Waterfront Description: Lake
  • Swimming Pool: No

Garage/Parking

  • Garages Number: 3
  • Driveway Type: Private
  • Total Parking Spaces: 10
  • Garage And Parking: Attached Garage, Driveway

Utilities

  • Cooling System: Central Air
  • Heat Type: Hot Water
  • Heat Fuel Type: Natural Gas
  • Hot Water Description: Natural Gas, Tank Size Unknown
  • Water Source: Public Water Connected
  • Sewer: Septic

Schools

  • Elementary School: Burr
  • High School: Fairfield Warde

Lot Info

  • Acres: 0.73
  • Lot Description: On Cul-De-Sac
  • Zoning: AA
  • Parcel #: 125041

MLS Schools

  • Elementary School: Burr
  • High School: Fairfield Warde

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Aug 12, 2008
Sold by
Goeller Michael
Bought by
Brisman Juliette
Current Estimated Value
$2,455,377

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,000,000
Interest Rate
6.49%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Apr 25, 2002
Sold by
Grella Janice L
Bought by
Goeller Michael
Source: Public Records

Range of Values:

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

Purchase History

Date Buyer Sale Price Title Company
Zuckerman Mark J $1,200,000 None Available
Zuckerman Mark J $1,200,000 None Available
Brisman Juliette $2,180,000 --
Brisman Juliette $2,180,000 --
Goeller Michael $820,000 --
Goeller Michael $820,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Goeller Michael $708,000
Previous Owner Goeller Michael $950,000
Previous Owner Goeller Michael $1,000,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/04/2025 04/04/25 Rented $10,500 -16.0% --
04/02/2025 04/02/25 Under Contract -- -- --
02/04/2025 02/04/25 For Rent $12,500 +13.6% --
10/31/2023 10/31/23 Rented $11,000 -12.0% --
10/28/2023 10/28/23 Under Contract -- -- --
10/24/2023 10/24/23 For Rent $12,500 -- --
Source: SmartMLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $32,009 $1,127,490 $406,070 $721,420
2024 $31,457 $1,127,490 $406,070 $721,420
2023 $31,017 $1,127,490 $406,070 $721,420
2022 $30,713 $1,127,490 $406,070 $721,420
2021 $30,420 $1,127,490 $406,070 $721,420
2020 $29,956 $1,118,180 $302,120 $816,060
2019 $29,956 $1,118,180 $302,120 $816,060
2018 $29,475 $1,118,180 $302,120 $816,060
2017 $28,871 $1,118,180 $302,120 $816,060
2016 $28,458 $1,118,180 $302,120 $816,060
2015 $31,138 $1,256,080 $403,130 $852,950
2014 $30,648 $1,256,080 $403,130 $852,950
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: SmartMLS

MLS Number: 24072610

SmartMLS

APN: FAIR-000121-000000-000027-R000000