Hang on a second...
USDAProperties.com is preparing the eligibility details...

 

 

 

$4,500,000   Price Analysis
USDAProperties Agent Contact Page  Agent Details  share icon     map icon  QR
594 N Plum Tree Rd
Barrington Hills, IL 60010
7 bed 11 bath 15,000 SqFt ($300/SqFt)
5.0 acre lot. Built 2007
Listed 2023-04-08, Taxes $38,580
Ⓧ USDA Ineligible
due to price & location

near Barrington Hills

This breathtaking estate boasts over 15

000 square feet of unparalleled quality construction and exquisite finishings. The craftsmanship is evident throughout and the state- of-the-art design is truly remarkable. Set on a sprawling 5-acre lot with horse trails, this home is the epitome of luxury living. With 21 thoughtfully designed rooms spread over 4 levels all serviced by an elevator. They include 7 vast bedrooms, 12 luxurious bathrooms and 6 cozy fireplaces. This home offers the ultimate in spaciousness and comfort. Each room features high-end materials and finishes, showcasing the attention to detail that went into its design. The audio and security systems are top-of-the-line, with expandable capabilities, ensuring that your family feels privacy and security.

The home is also fully wired with internet and plasma throughout, so you can stay connected and entertained no matter where you are in the house. In addition to its impressive features, the property includes a spa room, personal gym with a private bath, office area, dog wash and two laundry rooms. With multiple PIN numbers, this property also offers a unique investment opportunity and flexibility for future use. This once-in-a-lifetime opportunity also provides plenty of space to build a stable, arena, large pool or tennis and pickleball court. Overall, this is a truly exceptional property that seamlessly blends the best in craftsmanship, design and technology. Don't miss your chance t own this stunning estate and live the ultimate luxurious lifestyle. ]


Presented by Kim Alden at
Compass.
Listing Agent Photo

Property MLS #11754782 from MRED

Bedrooms: 7
Bedrooms Possible: 7
Primary Bedroom Dimensions: 22 x 16
Bedroom 2 Dimensions: 14 x 13
Bedroom 3 Dimensions: 14 x 13
Bedroom 4 Dimensions: 14 x 13
Bedroom 5 Dimensions: 16 x 13
Bedroom 6 Dimensions: 16 x 14
Bedroom 7 Dimensions: 14 x 13
Primary Bedroom Level: Second
Bedroom 2 Level: Second
Bedroom 3 Level: Second
Bedroom 4 Level: Second
Bedroom 5 Level: Second
Bedroom 6 Level: Main
Bedroom 7 Level: Lower

Total Rooms: 13
Bedroom 5, Bedroom 6, Bedroom 7, Den, Eating Area, Enclosed Porch, Office
Eating Area: 13 x 13
Eating Area Level: Main
Enclosed Porch: 14 x 16
Enclosed Porch Level: Main
Basement Features: Full, English
Den Dimensions: 16 x 14
Family Room Dimensions: 22 x 21
Office/Study Room Dimensions: 18 x 14
Den Level: Main
Family Room Level: Main
Office/Study Room Level: Second
Basement Description: Finished, Cellar

Total Bathrooms: 11
Full Bathrooms: 8
1/2 Bathrooms: 3

Vaulted/Cathedral Ceilings
Skylight(s)
Sauna/Steam Room
Hot Tub
Bar-Wet
Elevator
Flooring: Hardwood, Carpet

Yes
Laundry Features: Gas Dryer Hookup, Multiple Locations, Sink

Cooling Features: Central Air
Fireplace Features: Wood Burning, Gas Starter
Heating Features: Natural Gas, Sep Heating Systems - 2+, Zoned
Number of Fireplaces: 6

Dining Area Dimensions: 18 x 15
Dining Area Level: Main
Kitchen Dimensions: 21 x 17
Kitchen Level: Main

Patio
Hot Tub
Porch Screened

Additional Parcels Description: 13213000310000
Additional Parcels: Yes
Lot Description: Horses Allowed, Landscaped
Lot Size Acres: 5.0
Lot Size Dimensions: 530X575X397X803
Lot Size Square Feet: 217800

Driveway: Asphalt
Garage Spaces: 4
Garage Description: Attached
Garage Features: Garage Door Opener(s), Transmitter(s), Heated
Parking Total: 4

Model: TUDOR

Association: No
Calculated Total Monthly Association Fees: 0

Elementary School: Countryside Elementary School
Elementary School District: 220
High School: Barrington High School
High School District: 220

Countryside Elementary School is a public elementary school located approximately 2.3 miles away.
directions icon Map directions

Barrington High School is a public high school located approximately 3.1 miles away.
directions icon Map directions

Barrington Middle School Station is a public middle school located approximately 4.5 miles away.
directions icon Map directions

Trinity Oaks Christian Academy is a private elementary, middle and high school located approximately 2.9 miles away.
directions icon Map directions

Community Features: Horse-Riding Trails, Street Paved

Annual Tax Amount: 39003.66
Source Listing Status: Active
County: Lake
Directions: RT 14 W TO PLUM TREE RD TURN LEFT FOLLOWED BY A RIGHT
Tax Year: 2022
Ownership: Fee Simple
Source Property Type: Residential
Parcel Number: 13213000320000
Township: Cuba
Property Subtype: Detached Single
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2021$429,574 + $57,539
$487,113
$38,580
2020$538,336 + $57,361
$595,697
$38,075
2019$524,132 + $55,848
$579,980
$44,767
2018$685,233 + $80,543
$765,776
$49,117
2017$671,468 + $78,925
$750,393
$56,638
2016$646,139 + $75,948
$722,087
$55,827
2015$606,020 + $71,232
$677,252
$54,616
2014$606,020 + $71,232
$677,252
$55,564
2013$589,035 + $71,451
$660,486
$55,682
2012$608,162 + $73,771
$681,933
$53,992
2011$604,057 + $73,273
$677,330
$47,345
2010$698,873 + $100,593
$799,466
$51,556

Price Changed 2024-05-26
$4,500,000
MRED
Listed 2023-04-08
$5,500,000
MRED
Listing removed 2018-12-17
$12,000
MRED
Listing removed 2018-12-17
$5,150,000
MRED
Listing removed 2018-07-17
$12,000
MRED
Listing removed 2018-07-17
$5,150,000
MRED
Price Changed for rent 2017-12-19
$12,000
MRED
Relisted 2017-09-19
$5,150,000
MRED
Listed for rent 2017-08-29
$10,000
MRED
Listing removed 2017-08-27
$10,000
MRED
Listing removed 2017-08-27
$5,150,000
MRED
Listed for rent 2017-06-01
$10,000
MRED
Listed 2017-05-24
$5,150,000
MRED
Listing removed 2017-05-17
$2,700,000
MRED
Listing removed 2017-03-21
$12,000
MRED
Listing removed 2017-03-21
$5,050,000
MRED
Relisted 2016-09-22
$5,050,000
MRED
Relisted 2016-09-22
$2,700,000
MRED
Listed for rent 2016-09-21
$12,000
MRED
Listing removed 2016-09-18
$12,000
MRED
Listing removed 2016-09-18
$5,050,000
MRED
Listing removed 2016-09-18
$2,700,000
MRED
Listed for rent 2015-09-15
$12,000
MRED
Listed 2014-09-25
$5,050,000
MRED
Listed 2014-09-25
$2,700,000
MRED
Listing removed 2012-09-21
$2,800,000
MRED
Listed 2012-07-10
$2,800,000
MRED
Sold 2009-03-26
$1,660,000
Public Record
Listing removed 2009-03-03
$3,950,000
MRED
Listed 2008-08-19
$3,950,000
MRED
Listing removed 2008-08-18
$4,649,000
MRED
Listing removed 2008-08-18
$2,399,000
MRED
Listed 2007-08-07
$4,649,000
MRED
Listed 2007-03-28
$2,399,000
MRED

Total Square Feet Living: 15000
Year Built: 2007
Attic: Full
Foundation Details: Concrete Perimeter
Property Age: 17
Roof: Shake
Levels or Stories: 3
Architectural Style: Tudor

Electric: Circuit Breakers, 200+ Amp Service
Sewer: Septic-Private
Water Source: Private Well

Other Equipment: Humidifier, Water-Softener Owned, Central Vacuum, TV-Cable, Security System, Intercom, CO Detectors, Ceiling Fan(s), Sump Pump, Sprinkler-Lawn
Click Thumbnail Images To View Full Size
garageliving_roomliving_roomliving_roomdining_room
kitchenkitchenkitchendining_roomdining_room
unknownbedroomkitchenbathroomunknown
bedroombedroombedroomliving_roomunknown
unknownunknownbedroombathroomlaundry_room
unknownfarm_land

The property loan eligibility may be subject to additional requirements beyond geographical location including but not limited to the condition of the property. Speak with a real estate professional to find out more about the eligibility of a specific property.