x
Showing 1 of 0
X
Save

20054 Shady Tree Lane
Unincorporated MO 63383 US

$1,475,000

Active Listing ID 25026947
bed icon
4 bed
bath icon
3.00 Bath (3 Full)
lot icon
Lot: 42.50 Acres
home icon
Single Family Residence

$1,475,000

Active Listing ID 25026947
Save

20054 Shady Tree Lane 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 $488, 750 (@$11, 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 to $1, 954, 000.

Collapse all

Property Features

  • Facts
  • Lot Size: 42.50 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 3
  • Cooling System: Ceiling Fan(s), Geothermal
  • Exterior Finish: Views, Waterfront, Balcony, Security Lights
  • Floor Covering: Hardwood
  • Heating Fuels: Fireplace(s), Geothermal (Heating)
  • Additional Features
  • Fireplace
  • Waterfront

School Information

  • School
  • Rebecca Boone Elem.(Elementary)
  • Black Hawk Middle(MiddleSchool)
  • Warrenton High(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 1475000
  • unparsedaddress: 20054 Shady Tree Lane
  • postalcity: Unincorporated
  • stateorprovince: MO
  • country: US
  • postalcode: 63383
  • bathroomsfull: 3
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 42.5
  • lotsizeunits: Acres
  • lotsizearea: 42.5
  • livingarea: 3057
  • livingareaunits: Square Feet
  • latitude: 38.886762
  • longitude: -91.150931
  • listagentfullname: Barry Upchurch
  • listagentemail: barry@upchurchrealty.net
  • listagentkey: 3yd-MARISMO-EBAUPCHU
  • listagentmlsid: EBAUPCHU
  • listagentpreferredphone: 3147496178
  • listagentofficephone: 3147496177
  • listofficekey: 3yd-MARISMO-BAUP02
  • listagentstatelicense: 1999023853
  • listofficemlsid: BAUP02
  • disclaimer: Copyright © 2025 MARIS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: MARISMO
  • yearbuilt: 2005
  • listagenturl: http://barryupchurchrealty.com
  • countyorparish: Warren
  • parcelnumber: 03-32.0-0-00-001.001.000
  • elementaryschool: Rebecca Boone Elem.
  • highschool: Warrenton High
  • elementaryschooldistrict: Warren Co. R-III
  • middleorjuniorschooldistrict: Warren Co. R-III
  • highschooldistrict: Warren Co. R-III
  • appliances: Water - Softener
  • cooling: Ceiling Fan(s), Geothermal
  • flooring: Hardwood
  • heating: Fireplace(s), Geothermal (Heating)
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 1.5
  • parkingtotal: 6
  • parkingfeatures: Driveway, Garage, Garage - Attached, Oversized, Workshop
  • waterfrontyn: True
  • interiorfeatures: 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
  • exteriorfeatures: Views, Waterfront, Balcony, Security Lights
  • waterfrontfeatures: Waterfront
  • architecturalstyle: New Traditional
  • rooms: Basement, Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Dining Room, Great Room, Kitchen, Loft
  • securityfeatures: Security Lighting
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -91.15093, 38.88676
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Barry Upchurch Realty", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"barry@upchurchrealty.net", "ListBrokerageCity":"Chesterfield", "ListBrokerageCountry":"US", "ListBrokerageEmail":"barry@upchurchrealty.net", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/90/298728/20150316180303092.png", "ListBrokerageName":"Barry Upchurch Realty", "ListBrokeragePhone":"(636) 530-7727", "ListBrokeragePostalCode":"63005", "ListBrokerageStateOrProvince":"MO", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"173 Long Road, Suite 108", "ListBrokerageWebsiteUrl":"http://barryupchurchrealty.com", "ListOfficeAddress1":"173 Long Rd Ste 108", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"EBAUPCHU", "ListOfficeCity":"Chesterfield", "ListOfficeCountry":"US", "ListOfficeEmail":"barry@upchurchrealty.net", "ListOfficePostalCode":"63005", "ListOfficeStateOrProvince":"MO", "ListPriceCurrencyType":"USD", "ListingTitle":"Single Family Residence, Traditional - Unincorporated, MO", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/20054-Shady-Tree-Ln_Warrenton_MO_63383_M99597-55682?f=listhub&s=MARISMO&m=25026947&c=rexren", "MLSModificationTimestamp":"2025-10-15T09:46:38Z", "Neighborhoods":[{"Description":null, "Name":"469 - Warrenton R-3"}], "PostalCode":null, "RawPropertySubType":"Single Family Residence", "RawPropertyType":"Residential", "RoomCount":9, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":2553, "TaxDescription":null, "TaxYear":"2024"}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 10/15/2025 5:09:31 PM GMT
Source Updated Date: 12/7/2025 12:56:07 PM GMT

Courtesy of: Barry Upchurch, Barry Upchurch Realty, barry@upchurchrealty.net

Copyright © 2025 MARIS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.