This amazing property is a once in a lifetime opportunity to own an retreat-like setting within the city limits! Tucked away on 20 acres with wildlife, woods, and a stocked pond for the tranquility you want, but located within city and just ''down the road'' for the convenience you need. It is a dream-come-true! Amazingly remodeled Main house, Over-sized Guest house, Additional detached garage, Detached shop, Lake Pavilion MAIN HOUSE: boasts an open floor plan with elevated ceilings and a wall of windows overlooking the lake. The updated kitchen is gorgeous and functional with large island, butler pantry, granite counters. Master bedroom has connected office with built-in book shelves. Upstairs is well-designed with elevated play area for the kids, 2 large bedrooms with character. .. and charm, bright and cheery craft room, large unfinished storage area. MAIN HOUSE LOWER LEVEL: includes another bedroom, family room, media room, bathroom, 2 storage rooms (one with John Deere doors for easy access for pond toys) GUEST HOUSE: This is a whole separate house with garage! Great for guests but also ideal for MOTHER-IN- LAW option! main floor- kitchen, living/dining, bedroom, bathroom with stackable washer/dryer. and the lower level includes another bedroom, family room, bathroom, and 2 storage rooms. PAVILION: A fabulously designed and constructed pavilion that overlooks the stocked lake. It provides shelter and entertainment area complete with gorgeous stone fireplace, bathroom, and storage area for pond toys and fishing equipment. ALSO: for all your outside tools and toys. .. .Detached 3 car garage PLUS a separate shop
*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
2
Baths
2
Stories
1
Lot width
—
Lot depth
—
Lot size
20.62 Acres
Year renovated
—
Sq. Ft.
1,502
Year built
1999
Style
Ranch
County
Boone County
APN
1770300000130001
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 9, 2026.
A
SR-O
Agricultural District
This district is intended to provide for large-scale agricultural uses contained within the city, certain public uses, and facilities or activities best located in a more isolated area. The principal land use is an agricultural area or public facility. Only one principal dwelling and one second principal dwelling are allowed on each lot.
Zone overlays
Scenic Roadway Overlay District
Permitted uses
Include but are not limited to:
Agriculture
Greenhouse / nursery
Community / recreation center
Religious facility
Housing-Group
Housing-Single unit
Fire house
Museum / gallery
Police station
Park & open space
May 3, 2023 • Final
Mechanical stand alone
Install a new furnace and air conditioning unit.
HVAC
Mar 6, 2023 • Final
Fuel gas permit not associated with any other
Gas
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: 6
Parking Features: Paved, Driveway, Attached
Interior
Virtual Tour
Bathroom Information
# of Full Bathrooms: 5
# of Half Bathrooms: 1
Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Heat Pump
Interior Features
Interior Features: Wet Bar, Granite Counters, Kitchen Island, Pantry, Walk-In Closet(s), Master Downstairs
Appliances: Disposal, Microwave
Flooring: Carpet, Wood
Has Fireplace
Fireplace Features: Living Room
Room Information
# of Rooms Total: 19
Has Basement
Basement Details: Walk-Out Access
Exterior
Exterior Features
Exterior Features: Storage
Patio And Porch Features: Covered, Screened, Front Porch
Building Information
Direction Faces: North
Sq. Ft.: 5734.0
Below Grade Finished Area: 2,120
Construction Materials: Wood Siding
Property Features
On Waterfront
Accessibility Features: Therapeutic Whirlpool
Other Structures: Storage, Workshop
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Raw Mls Property Sub Type: Single Family Residence
Property Condition: Updated/Remodeled
Land Information
Vegetation: Heavily Wooded
Lot Information
Lot Features: Sloped, Wooded, Cleared, Rolling Slope, Waterfront
Road Surface Type: Paved
Road Responsibility: Public Maintained Road
Lot Size : 20.62
Lot Size Area: 20.62
Lot Size Units: Acres
Lot Size Acres: 20.62
Zoning: Agricultural
Zoning Description: A- Agricultural*
Financial
Tax Information
Tax Annual Amount: $7,392.66
Utilities
Utility Information
Water Source: Public
Utilities: Electricity Available
Location
Schools Information
Elementary School: New Haven
Middle Or Junior School: Gentry
High School District: Columbia
High School: Rock Bridge
Location Information
Directions: Grindstone to Rock Quarry or 63 to Discovery Pkwy to Gans Rd to Rock Quarry
Subdivision Name: COLUMBIA
Public facts
Beds: 2
Baths: 2.0
Sq. Ft.: 1,502
Stories: 1.0
Lot Size: 20.62 acres
Style: Ranch
Year Built: 1999
Year Renovated: —
County: Boone County
APN: 1770300000130001
Home facts updated by county records on Sep 9, 2026
Other
Listing Information
List AOR: Columbia Board of REALTORS®
Around this home
Schools
Rock Bridge Elementary School
Public PreK-5 • Assigned • 5.2mi
8/10
Ann Hawkins Gentry Middle School
Public 6-8 • Assigned • 1.8mi
7/10
Rock Bridge Senior High School
Public 9-12 • Assigned • 1.5mi
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 106° 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
0 unhealthy days expected this year, 1 days in 30 years
Provided by First Street
Historical weather
Columbia, MO • 65201
Average low and high temperatures (°F)
36
19
47
27
64
40
70
50
74
55
82
66
88
71
85
64
83
59
73
50
56
38
45
27
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.7 hours in
June and 4.4 hours in December, which is comparable to the
U.S. average for solar exposure.
9.7 hrs
4.4 hrs
JuneDecember
Provided by Shadowmap
Sell confidently with a local market expert in Columbia. 3 minutes to get started.