Agent profile image in chat bubble
Agent profile image in chat header

IDX Support

sales rep | Brivity IDX

Agent profile image in message

202 N Queen Anne Rd , Woodstock, IL 60098
$950,000
Est. Payment: $5,097.20/mo
4 Bed
5 Bath
5064 Sqft
5.01 Acres
Status: active | Days on site: 18
Get Pre-Qualified
5154 - 56229
By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from IDX Support, its affiliates, and agents or vendors acting on their behalf. These communications may be delivered using an automatic telephone dialing system or by using an artificial or prerecorded voice. Message and data rates may apply. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms of Use and Privacy Policy.

House Description

Discover an extraordinary private estate where luxury, architectural distinction, and wide-open space come together on 5 picturesque acres with horses allowed, a tranquil pond, mature woods, and exceptional privacy; even a brand new roof - 2026 for the house and 2020 for the barn and a fresh paint job on the entire exterior of the home. Offering more than 4,500 square feet of beautifully designed living space, this impressive 5-bedroom, 4.5-bath residence showcases thoughtful craftsmanship and timeless finishes throughout. Designed by renowned architect Terence Riley, the home makes an immediate statement with its distinctive architectural details and sophisticated yet inviting interior. Rich cherry hardwood flooring flows throughout the main level. At the heart of the home is a spectacular Mick De Giulio-designed kitchen featuring granite countertops and premium appliances, including a Wolf range, Sub-Zero refrigerator, and Bosch dishwasher. Designed for both everyday living and entertaining, this exceptional kitchen blends luxury, functionality, and timeless style. The flexible floor plan includes the option for a main-level primary suite complete with its own fireplace. Generously sized bedrooms and beautifully appointed living areas provide plenty of space for family, guests, working from home, and entertaining. A heated 3-car garage is complemented by an incredible approximately 1,200-square-foot loft above, creating endless possibilities for a home office, recreation room, fitness space, studio, or additional flex space. The property continues to impress outdoors with 5 acres of scenic grounds featuring a private pond, wooded areas, and room for horses. A substantial approximately 6,000-square-foot barn with its own studio provides remarkable versatility for equestrian use, hobbies, storage, a workshop, or creative pursuits. A rear circular drive and expansive parking areas easily accommodate numerous vehicles and guests. With more than 4,500 square feet of living space, an additional 1,200-square-foot loft/office above the 3 car garage, 6,000-square-foot barn, heated 3-car garage, premium finishes, and five breathtaking acres, this one-of-a-kind estate offers a rare combination of luxury, privacy, flexibility, and space-inside and out.

Highlights

Listed by Branden Linnane , 815-355-2331 HomeSmart Connect LLC , 847-495-5000. Midwest Real Estate Data mls logo

Property Type

Residential

Lot/Acreage
5.01

Year Built

1920

County

McHenry

Area

Bull Valley / Greenwood / Woodstock

School District

200

Listing ID

12771927

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:4
  • ▪ Bathrooms:5
  • ▪ Full Bathrooms:4
  • ▪ 1/2 Bathrooms:1
Appliances:Double Oven, Range, Microwave, High End Refrigerator, Freezer, Washer, Dryer, Cooktop, Oven, Water Purifier Owned, Water Softener Owned
Air Cond:Central Air,Zoned
Fireplaces:Gas Starter
Floor:Hardwood
Below Ground Sq Ft:1347
Basement:Partially Finished,Crawl Space,Cellar,Partial
Other:
  • ▪ Additional:1st Floor Bedroom
Water:Well

Exterior Features

Lot:Wooded
Lot Dimensions:303X720
Garage Capacity:3
Roof:Asphalt,Metal
Others:
  • ▪ Additional:Fire Pit
Sewer:Septic Tank
Parking Features:Brick Driveway,Gravel,Garage Door Opener,Heated Garage,Yes,Garage Owned,Attached,Garage
Principal Interest
$5,097
Taxes
$1,801

Home Price

$950,000

Loan Details

30 yrs
7.08%

Down Payment

20%
$190,000
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$5,097.20

Principal

Taxes

Principal Taxes HOA Total
Monthly $5,097.20 $1,800.93 $0.00 $6,898.13
Yearly $61,166.37 $21,611.14 $0.00 $82,777.51
Total $1,834,991.19 $648,334.20 $0.00 $2,483,325.39
Lender profile image
Master Chief
Lender
GET PRE-QUALIFIED

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Oct 2026

Average Price

All Price Ranges
N/A
Oct 2026

Average Days on Market

All Price Ranges
N/A
Oct 2026
Market insight data is pulled from the same city as the listing being viewed (Woodstock, IL).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

Based on information submitted to the MRED as of the date listed below. All data is obtained from various sources and has not been, and will not be, verified by broker or MRED. MRED supplied Open House information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. IDX information is provided exclusively for consumers' personal non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed by MTP or MRED. The use of the MRED Data may be subject to an end user license agreement prescribed by the Member Participant's applicable MLS if any and as amended from time to time.

Based on information submitted to the MLS GRID as of the date listed below. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. IDX information is provided exclusively for consumers' personal non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant's applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability. Some listings have been excluded from this website.

IDX service by Blueroof 360

Data last updated: 2026-10-27T02:55:04.000Z

© 2026 Midwest Real Estate Data

MLS Logo - Midwest Real Estate Data