This marquee property is for the discerning car collector,avid hunter/nature lover;the possibilities are endless. 42.5 acres of natural hunting bliss w/Yeater Branch Creek meandering though this estate,you are only 10 min.away from downtown Warrenton w/easy access to I-70.Best of all is the 3,100 approx. sq ft homestead.The home itself boast 2-master bedrms,-main flr & 2nd flr. 2 addit'l main flr bedrms,3 baths,2-story,massive great rm adorned w/a 2-story,historic grist-mill fireplace & gourmet kitchen suite w/see-through fireplace connected to enlarged dining hall.Incredible views of the private park-like lake w/gazebo,scenic walking bridge & monument approach bridge which transports you to your own private oasis suitable for a story-book wedding. Huge equipment barn can be used for a variety of uses not to mention the 6 garages attached to the house.Bring your friends & family & get ready to enjoy the best life has to offer country living w/easy access to amenities.Shangri la paradise.The addt’l western 42.5 acres avail.for $531,250 (@$12,500/acre).Also,addt’l 5 acre vineyard avail.for $125,000-another tax record north of pretty-part of 15 acres.Entire 90 and all improvements available for a price concession of $2,079,000.
Active
Price increase: $449K (5/27)
$1,699,000
20054 Shady Tree Ln, Warrenton, MO 63383
4beds
3,057sqft
Est.:
Single Family Residence
Built in 2005
42.5 Acres Lot
$1,617,600 Zestimate®
$556/sqft
$-- HOA
What's special
Private park-like lakeYeater branch creekHistoric grist-mill fireplaceMonument approach bridgeNatural hunting blissGourmet kitchen suiteScenic walking bridge
- 50 days
- on Zillow |
- 786 |
- 44 |
Zillow last checked: 7 hours ago
Listing updated: May 27, 2025 at 02:28pm
Listing Provided by:
Barry P Upchurch 314-749-6178,
Barry Upchurch Realty,
Diane M Upchurch 314-749-6177,
Barry Upchurch Realty
Source: MARIS,MLS#: 25026947
Originating MLS: St. Louis Association of REALTORS

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 3
- Main level bathrooms: 2
- Main level bedrooms: 3
Primary bedroom
- Features: Floor Covering: Carpeting, Wall Covering: Some
- Level: Upper
- Area: 460
- Dimensions: 23 x 20
Primary bedroom
- Features: Floor Covering: Carpeting, Wall Covering: Some
- Level: Main
- Area: 196
- Dimensions: 14 x 14
Bedroom
- Features: Floor Covering: Carpeting, Wall Covering: Some
- Level: Main
- Area: 224
- Dimensions: 16 x 14
Bedroom
- Features: Floor Covering: Carpeting, Wall Covering: Some
- Level: Main
- Area: 156
- Dimensions: 13 x 12
Primary bathroom
- Features: Floor Covering: Ceramic Tile, Wall Covering: None
- Level: Main
- Area: 54
- Dimensions: 9 x 6
Bathroom
- Features: Floor Covering: Ceramic Tile, Wall Covering: Some
- Level: Upper
- Area: 130
- Dimensions: 13 x 10
Dining room
- Features: Floor Covering: Wood, Wall Covering: Some
- Level: Main
- Area: 375
- Dimensions: 25 x 15
Great room
- Features: Floor Covering: Wood, Wall Covering: Some
- Level: Main
- Area: 680
- Dimensions: 34 x 20
Kitchen
- Features: Floor Covering: Wood, Wall Covering: Some
- Level: Main
- Area: 375
- Dimensions: 25 x 15
Loft
- Features: Floor Covering: Wood, Wall Covering: Some
- Level: Upper
- Area: 240
- Dimensions: 20 x 12
Heating
- Geothermal, Other
Cooling
- Ceiling Fan(s), Geothermal
Appliances
- Included: Water Softener Rented
- Laundry: Main Level
Features
- Workshop/Hobby Area, Dining/Living Room Combo, Separate Dining, Historic Millwork, Vaulted Ceiling(s), Walk-In Closet(s), Breakfast Bar, Kitchen Island, Custom Cabinetry, Eat-in Kitchen, Granite Counters, Pantry, Separate Shower, Entrance Foyer
- Flooring: Hardwood
- Basement: Concrete,Storage Space,Walk-Up Access
- Number of fireplaces: 2
- Fireplace features: Wood Burning, Dining Room, Great Room, Kitchen
Interior area
- Total structure area: 3,057
- Total interior livable area: 3,057 sqft
- Finished area above ground: 3,057
Property
Parking
- Total spaces: 6
- Parking features: Attached, Circular Driveway, Detached, Garage, Garage Door Opener, Oversized, Storage, Workshop in Garage
- Attached garage spaces: 6
- Has uncovered spaces: Yes
Features
- Levels: One and One Half
- Exterior features: Balcony
- Has view: Yes
- Waterfront features: Waterfront
Lot
- Size: 42.5 Acres
- Features: Adjoins Wooded Area, Suitable for Horses, Views, Waterfront, Wooded
Details
- Additional structures: Equipment Shed, Gazebo, Kennel/Dog Run, Metal Building, Outbuilding, Poultry Coop
- Parcel number: 0332.0000001.001.000
- Special conditions: Standard
- Horses can be raised: Yes
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional,Other
- Property subtype: Single Family Residence
Condition
- Year built: 2005
Utilities & green energy
- Sewer: Lagoon, Septic Tank
- Water: Well
Community & HOA
Community
- Security: Security Lights
- Subdivision: None
Location
- Region: Warrenton
Financial & listing details
- Price per square foot: $556/sqft
- Tax assessed value: $2,210
- Annual tax amount: $2,553
- Date on market: 4/25/2025
- Listing terms: Cash,Conventional,Other
- Ownership: Private
- Loading
- Loading