#25028543, Listing office: Barry Upchurch Realty
Property details
About 20054 Shady Tree Ln
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.
Highlights
Home typeSingle Family Residence
HeatingGeothermal, Other
StatusActive
CoolingCeiling Fan(s), Geothermal
Size3,057 sqft
BasementYes
Lot size42.5 Acres
Year built2005
ParkingAttached, Circular Driveway, Detached, Garage, Garage Door Opener, Oversized, Storage, Workshop in Garage
MLS #25026947
Attached garage6 spaces
FireplaceWood Burning, Dining Room, Great Room, Kitchen
ViewOther, Water, Trees/Woods
Summary
- Full Bathrooms: 3
- Appliances: Water Softener
- Basement: Yes
- Flooring Type: Hardwood
- Interior: 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
- Fireplace: Wood Burning, Dining Room, Great Room, Kitchen
- Total Bedroom Count: 4
- Garage Space: 6 spaces
- Attached Garage: Yes
- Parking: Attached, Circular Driveway, Detached, Garage, Garage Door Opener, Oversized, Storage, Workshop in Garage
- View: Other, Water, Trees/Woods
- Exterior: Balcony
- Architectural Style: Traditional, Other
- Heating: Geothermal, Other
- Cooling: Ceiling Fan(s), Geothermal
- List Price: $1,575,000
- Price/SqFt: $515
- Lot: Views, Waterfront, Wooded
- Directions: From Warrenton I-70 & Hwy 47 go north 5.1 miles to Power Line Rd, go left/west 0.5 miles to Prairie Edge Lane go left/south at 20054 Shady Tree mailbox 0.3 miles continue on 0.6 miles to right at road going across the lake bridge to homesite.
- Year Built: 2005
- Living Area: 3,057 SqFt
- Lot Size: 42.5 Acres
- MLS Number: 25026947
- MLS Name: MARIS2
- Office Name: Barry Upchurch Realty
- Office Phone: (314) 749-6177
Listings courtesy of Mid America Regional Information System as distributed by MLS GRID.
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. Properties displayed may be listed or sold by various participants in the MLS.
DMCA Notice
Based on information submitted to the MLS GRID. 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.
Listings courtesy of MARIS MLS as distributed by MLS GRID. Copyright © 2025 Mid America Regional Information System (MARIS). All Rights Reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 7/16/2025, 3:38:28 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Price information
Property sales
We're sorry, we currently don't have property sales data for this listing.
Tax history
We're sorry, we currently don't have tax history data for this listing.
Nearby schools
4
Rebecca Boone Elementary School
Public District KG-5
5.6 mi
•836 South St
4
Daniel Boone Elementary School
Public District KG-5
5.6 mi
•813 Vosholl Ave
9
Hawk Point Elementary School
Public District KG-5
5.8 mi
•327 Maple St
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $79,332. The majority of undefined, MO residents have income between $35k-100k annually. Typical family type is married, no kids. The most common level of education of people living in this area is post secondary degree.
How much money do the neighbors make?
22%
<35k
43%
35k-100k
35%
100k-200k
0%
200k+
What level of education do the neighbors have?
No High School
High School Diploma
Post Secondary Degree
Masters Degree
What types of families live nearby?
28%
Single, No Kids
9%
Single, with Kids
37%
Married, No Kids
26%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
18%
<11 yrs old
9%
12-17 yrs old
16%
18-34 yrs old
42%
35-64 yrs old
15%
65+ yrs old
What do the neighbors do for fun?
Hunting
NASCAR
Figure Skating
Where do the neighbors shop?
Academy Sports & Outdoors
Wal-Mart
Bass Pro Shops
Where do the neighbors go to eat?
Jimmy Johns
Hardee's
Applebees
What do the neighbors drive?
Chevrolet
Ram
GMC
What do the neighbors listen to?
New Country
Classic Country
Oldies
All data provided by Home Junction and Claritas
Similar homes for sale
Frequently asked questions
About 20054 Shady Tree Ln
The listing price of 20054 Shady Tree Ln property is $1,575,000.
Active Listing: 20054 Shady Tree Ln is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 20054 Shady Tree Ln are: Rebecca Boone Elementary School (GreatSchools Rating 4/10), Daniel Boone Elementary School (GreatSchools Rating 4/10), Hawk Point Elementary School (GreatSchools Rating 9/10), Black Hawk Middle School (GreatSchools Rating 3/10), Wright City Middle School (GreatSchools Rating 4/10), Troy Middle School (GreatSchools Rating 6/10), Warrenton High School (GreatSchools Rating 3/10), Wright City High School (GreatSchools Rating 6/10), Troy Buchanan High School (GreatSchools Rating 5/10).
The property at 20054 Shady Tree Ln has 4 bedrooms and 3 bathrooms.
The property 20054 Shady Tree Ln is 3,057 SqFt (source: MLS/tax record).
The year of construction for 20054 Shady Tree Ln is 2005.
This 3,057 square foot home, which was built in 2005, sits on a 42.50 acre lot. Features: 4 bedrooms, 3 bathrooms. It has been listed on Rocket Homes since April 25, 2025 and is currently priced at $1,575,000.
Over 8 listings were sold over their listed price in June 2025 in undefined, MO. In the same period over 2 listings were sold below the listed price and 2 listings were sold for the listed price. Between May and June 2025, undefined, MO real estate market has seen increase in the number of listings by 1.9%. The median list price of listings available in June 2025 was $239,950, while the average time on the real estate market was 27 days.
From Rocket Homes Real Estate and based on county public records data.