Luxuriously warm with timeless elegance, this French Country estate on over 7 acres is a paradise within the city! The beautiful custom designed limestone and stucco home with multi-paned windows greets you with extensive gardens and a limestone walled, gated courtyard with brick walkway inviting you to the covered front porch with French antique wooden double entry doors opening to a stunning entryway. The interior of the gorgeous home exudes a welcoming, comfortable, rustic yet elegant design with curved, massive wooden arches soaring across the expansive post and beam ceiling and limestone fireplace with reclaimed oak flooring in the hearth room. A breath-taking open design with plenty of natural light includes a fully-appointed gourmet kitchen, an impressive island with plentiful seating and travertine marble countertops, professional grade appliances including a Wolf gas six-burner flat top with dual convection ovens and Subzero 700TR refrigerator/freezer, a butler's pantry with sonic ice, deep sink and microwave along with a large breakfast room. The magnificent dining room with fully opening French doors connects to the covered back porch with a wood burning fireplace. A large multi-windowed family room beckons you from the wide hallway with extensive barrel style ceilings extending from the side entry covered porch through the home to the luxurious, private master suite overlooking the grounds and in-ground swimming pool. The well designed master bath with heated floors flows to two master closets with dressing areas including washer & dryer. A sitting room off the master suite with a private entry may be used as an office. Additionally on the main floor is located a private office, caterer's large pantry/linen storage, two half baths, amazing drop zone with multiple storage lockers and under a stairway is the children's "hobbit" playroom! There are separate stairways leading to the wonderful upper level living areas. These include a stellar, private "in-law" suite with full bath, large sitting room and breakfast area; impressive and large den/library/family room with custom built-ins open to the hearth room below; Jack and Jill bedrooms with en suite bathroom with separate sinks, walk-in shower with glass doors and large walk-in closet with dressing area and window; another master suite with full bath and walk-in closet with a beautiful view of the back landscape and pool; an additional room overlooking the front side of the estate has endless possibilities; and, a full laundry room with storage access. The lower level custom "man cave"/ billiards room is absolutely stunning with full hardwood and leather walls, enormous bar with travertine marble top and built in cabinetry. It includes a kegerator fitting two 5-gallon kegs, refrigerator, ice maker and Bosch dishwasher. There are two separately controlled large screen televisions and four ceiling speakers with a subwoofer, and full bath with shower and dressing area. This living area opens to a tiled patio with access to the pool and gardens. Additionally, this level includes a shop area; craft room and salon with washer/dryer; humongous exercise room; storage area with shelving and cedar closet. And, a room for the well pressure tanks, geothermal, water filtration system, dual water heaters, hot water re-circulator with timer, etc. Rounding out this SMART home loaded with technology is an attached oversized two-car garage with full HVAC; it includes a large sink, cabinetry, garbage disposal and dishwasher. There is a covered side porch and an attached carport leading to a detached three-car garage with extensive storage and exceptionally high ceilings. Do you desire fresh air, spectacular views, a quiet, serene place, enjoying the outdoors, the sound of water features with birds singing while observing various wildlife peacefully enjoying the grounds in beautiful surroundings? If so, you will love this very special place. The grounds are extensively and beautifully landscaped into outdoor lifestyle spaces. A meandering, peaceful stream was carefully designed and built for nature to showcase its amazing beauty. A few steps from the back patio and pool you will find a serene reflection pool with koi situated with a large seating area. You are invited to follow the bluestone pavers and stone pathways as they diverge across and along the stream with bridges reconnecting. Along the way there are intimate, private seating areas along with gas and wood fireplaces. The stream eventually flows into the pond below, the source of its existence thanks to a pump located within the pond. Additionally, to maintain the gorgeous grounds there are several acres irrigated with well water.
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Permits
Beds
5
Baths
4
Stories
1
Lot width
—
Lot depth
—
Lot size
7.09 Acres
Year renovated
—
Sq. Ft.
7,927
Year built
2004
Style
Single Family Residential
County
Boone County
APN
1680300010140001
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 9, 2026.
R-1
One-Family Dwelling District
This district is intended to promote and preserve safe and attractive urban one-family residential neighborhoods. The principal land use is a one-family dwelling unit per lot. Some public recreational uses, religious facilities, educational facilities, and uses incidental or accessory to dwellings are included, as shown in Table 29-3.1 (Permitted Use Table).
Permitted uses
Include but are not limited to:
Community / recreation center
Religious facility
Garden center
Housing-Group
Housing-Single unit
Educational/school
Fire house
Police station
Golf related
Park & open space
Oct 16, 2023 • Final
Residential alteration
Addition
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking/Garage Information
Has Garage
# of Garage Spaces: 5
Parking Features: Garage Door Opener, Paved, Driveway, Attached
Interior
Bathroom Information
# of Full Bathrooms: 5
# of Half Bathrooms: 2
Heating & Cooling
Has Cooling
Cooling: Zoned
Has Heating
Heating: Forced Air, Propane, Geothermal, Exhaust Fan
Interior Features
Interior Features: Breakfast Bar, Eat-in Kitchen, Wet Bar, Bar, Cedar Closet(s), Wired for Data, Wired for Sound, Smart Thermostat, Kitchen Island, Pantry, Walk-In Closet(s), Master Downstairs
Window Features: Window Treatments
Appliances: Humidifier, Water Softener Owned, Gas Cooktop, Dishwasher, Disposal, Microwave, Gas Range, Refrigerator, Exhaust Fan, Down Draft, Convection Oven, Double Oven
Flooring: Carpet, Tile, Wood
Has Fireplace
Fireplace Features: Circulating, Gas, Living Room, Wood Burning
Directions: South on Providence Road to right on Nifong to left on Old Mill Creek Road to right on Old Field Road. Home is on the left at the corner of Old Field and Harvest Road. OR South on Scott Blvd to left on Vawter School road to right on Old Mill Creek Road to right on Old Field Road. Home is on the left at the corner of Old Field and Harvest Road.
Subdivision Name: COUNTRY FARMS
Public facts
Beds: 5
Baths: 4.0
Sq. Ft.: 7,927
Stories: 1.0
Lot Size: 7.09 acres
Style: Single Family Residential
Year Built: 2004
Year Renovated: —
County: Boone County
APN: 1680300010140001
Home facts updated by county records on Sep 9, 2026
Other
Listing Information
List AOR: Columbia Board of REALTORS®
Around this home
Schools
Mill Creek Elementary School
Public PreK-5 • Assigned • 0.7mi
10/10
JOHN WARNER MIDDLE SCHOOL
Public 6-8 • Assigned • 1.4mi
10/10
Rock Bridge Senior High School
Public 9-12 • Assigned • 2.7mi
9/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
4/10 Heat Factor
7 days above 107° expected this year, 19 days in 30 years
2/10 Wind Factor
Minor risk of severe winds over next 30 years
2/10 Air Factor
1 unhealthy days expected this year, 1 days in 30 years
Provided by First Street
Historical weather
Columbia, MO • 65203
Average low and high temperatures (°F)
37
19
48
27
66
41
70
51
75
55
84
67
88
72
86
65
83
60
73
51
56
39
46
29
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.8 hours in
June and 4.4 hours in December, which is comparable to the
U.S. average for solar exposure.
9.8 hrs
4.4 hrs
JuneDecember
Provided by Shadowmap
Sell confidently with a local market expert in Columbia. 3 minutes to get started.