NOT LISTED FOR SALE

5174 Barrington Dr Unit 23 Rochester, MI 48306

Estimated Value: $2,922,191 - $3,884,000

6 Beds
8 Baths
13,298 Sq Ft
$263/Sq Ft Est. Value

Last Sold February 09, 2016

Last sale price $2,200,000 $165 Per Sq Ft

Est. 59% increase in value since last sale

Current estimated payment $20,413/month

73 Days on Market

Highlights

  • In Ground Pool
  • 1.7 Acre Lot
  • Fireplace in Primary Bedroom
  • Delta Kelly Elementary School Rated A
  • Colonial Architecture
  • Jetted Tub in Primary Bathroom

About This Home

As of February 2016

Gorgeous luxury estate In Orchard Ridge's private gated community . This 18,400 square foot home boasts entertainment. The home has 5 generous sized bedrooms master suite includes spacious bath with duo w/c & large jetted tub. Also upstairs the bonus room with wet bar 6.2 baths. Enjoy the lower levels amenities: gym quality workout facility, regulation basketball court,stainless steel soaking tubs and home theatre, The gourmet kitchen with all high end appliances wrapped with beautiful French doors overlooking the sprawling pool & heated cabana. Don't overlook the 6 Limestone fireplaces,fully wired smart house,security cameras inside & out, & 4 car garage. Must see to believe...

Last Agent to Sell the Property

Stacey Weinberg

Real Broker Birmingham License #6501317759 Listed on: 10/31/2015

Real Broker Birmingham

Last Buyer's Agent

Chris Gabriel

Nest Real Estate License #RCO-6501320955

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2000 | Remodeled in 2010

Lot Details

  • 1.7 Acre Lot
  • Lot Dimensions are 257x265x257x265
  • Gated Home
  • Level Lot

HOA Fees

  • $500 Monthly HOA Fees

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Block Foundation
  • Poured Concrete
  • Asphalt Roof
  • Stone Siding

Interior Spaces

  • 13,298 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Central Vacuum
  • Sound System
  • Bar Fridge
  • Ceiling Fan
  • Gas Fireplace
  • Family Room with Fireplace
  • Great Room with Fireplace
  • Living Room with Fireplace
  • Security System Owned

Kitchen

  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Fireplace in Primary Bedroom
  • Jetted Tub in Primary Bathroom

Laundry

  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Sump Pump
  • Fireplace in Basement

Parking

  • 4 Car Attached Garage
  • Garage Door Opener

Eco-Friendly Details

  • Air Purifier

Pool

  • In Ground Pool
  • Spa

Outdoor Features

  • Balcony
  • Terrace
  • Exterior Lighting
  • Porch

Utilities

  • Humidifier
  • Forced Air Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater
  • Water Softener is Owned
  • High Speed Internet
  • Cable TV Available

Community Details

  • Orchard Ridge Occpn 1031 Subdivision

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 1032226023

Home Details

Home Type

Single Family

Est. Annual Taxes

$52,226

Year Built

Built in 2000 | Remodeled in 2010

Lot Details

0

HOA Fees

$500 per month

Listing Details

  • Property Type: Residential
  • Architecture Style: Colonial
  • Architecture Level: 2 Story
  • Warranty: Yes
  • Year Built: 2000
  • Year Renovated: 2010
  • Foundation Features: Sump Pump
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: Air Purifier, Cable Available, Central Vacuum, High Spd Internet Avail, Humidifier, Intercom, Jetted Tub, Security Alarm (owned), Sound System, Spa/Hot-tub, Water Softener (owned), Wet Bar
  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Fireplace Locations: Basement, Family Room, Great Room, Living Room, Primary Bedroom
  • Total Bedrooms: 6
  • Total Bathrooms: 6.20
  • Full Bathrooms: 6
  • Half Bathrooms: 2
  • Basement: Yes
  • Basement Type: Finished
  • Kitchen Appliances: Bar Fridge, Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Range/Stove, Washer
  • Total Sq Ft: 13298

Exterior Features

  • Roof Material: Asphalt
  • Pool: Yes
  • Foundation Details: Basement
  • Construction Materials: Brick, Stone
  • Exterior Features: Fenced, Gate House, Lighting, Pool - Inground
  • Foundation Materials: Block, Poured
  • Porch Type: Balcony, Porch, Terrace
  • Road Frontage Type: Paved

Garage/Parking

  • Garage Size: 4 Car
  • Garage Features: Attached, Basement Access, Door Opener, Electricity, Side Entrance
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Ceiling Fan(s), Central Air
  • Heating: Forced Air, Zoned
  • Sewer: Public Sewer (Sewer-Sanitary)
  • Water Heater Fuel: Natural Gas
  • Water Source: Public (Municipal)
  • Laundry Facilities: No

Condo/Co-op/Association

  • Association Fee Frequency: Monthly
  • Association Fee: 500
  • Association Fee: No

Lot Info

  • List Price per Acre: 1764117.6471
  • Lot Features: Level
  • Lot Size Area: 1.70
  • Lot Dimensions: 257X265X257X265
  • Parcel Number: 1032226023

Tax Info

  • Tax Amount Summer: 30757.2100
  • Tax Amount Winter: 21468.3700
  • Total Tax: 52225.5800

MLS Schools

  • School District: Rochester

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 31, 2015
Closed on
Feb 9, 2016
Sold by
Gordon Benjamin
Bought by
Jerebko Jonas
Seller's Agent
Stacey Weinberg
Real Broker Birmingham
Buyer's Agent
Chris Gabriel
Nest Real Estate
List Price
$2,999,000
Sold Price
$2,200,000
Premium/Discount to List
-$799,000
-26.64%
Current Estimated Value
$3,490,730

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$1,290,730
Avg. Annual Appreciation
4.86%

Purchase Details

Closed on
Sep 11, 2009
Sold by
Smith David J and Gamble Smith Mary V
Bought by
Gordon Benjamin

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$921,250
Interest Rate
4.37%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 28, 2000
Sold by
Kay Building Land Dev
Bought by
Smith David J
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
Jerebko Jonas $2,200,000 Liberty Title
Gordon Benjamin $1,910,000 Philip R Seaver Title Co Inc
Smith David J -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Gordon Benjamin $921,250
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
02/09/2016 02/09/16 Sold $2,200,000 -26.6% $165 / Sq Ft
01/12/2016 01/12/16 Pending -- -- --
10/31/2015 10/31/15 For Sale $2,999,000 -- $226 / Sq Ft
Source: Realcomp

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
2024 $19,706 $1,225,520 $0 $0
2023 $19,067 $1,174,410 $0 $0
2022 $30,709 $1,213,510 $0 $0
2021 $36,580 $1,500,520 $0 $0
2020 $26,096 $1,512,820 $0 $0
2019 $39,659 $1,495,610 $0 $0
2018 $42,119 $1,550,850 $0 $0
2017 $41,411 $1,511,370 $0 $0
2016 $41,841 $1,446,350 $0 $0
2015 -- $1,397,900 $0 $0
2014 -- $1,220,710 $0 $0
2011 -- $862,900 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 216002350

Realcomp

APN: 10-32-226-023