This home's estimate is 9.6% higher than the average sale price ($321K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate
516 N Fairgrounds Rd, Sturgeon, MO 65284
About this home
Immaculate 4 Bedroom, 2 Bath Hansman Custom Built Home. 1895 Sq Ft, Energy Star Program, Fresh Air System, Maple Cabinets, Quartz Counter, Glass back Splash. All Stainless Steel Appliances 8'-10' ceilings, tray ceilings & crown molding MB & Formal Dining Room. Mud room separate laundry, beautiful landscaping, fenced backyard. Many Upgrades!
Redfin Estimate
Earn from this home
List your home for rent
Market trends in 65284, MO
Last updated August 2026
Buyer's Market
Seller's Market
Seller's market
0.0% MoM
See all
Provided by Redfin
Sale history for 516 N Fairgrounds Rd
$121/sq ft
Tax history for 516 N Fairgrounds Rd
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Property details
Parking
- Parking/Garage Information
- Has Garage
- # of Garage Spaces: 2
- Parking Features: Garage Door Opener, Paved, Driveway, Attached
Interior
- Bathroom Information
- # of Full Bathrooms: 2
- Heating & Cooling
- Has Cooling
- Cooling: Central Air
- Has Heating
- Heating: Natural Gas, Forced Air, Exhaust Fan
- Interior Features
- Interior Features: Eat-in Kitchen, Pantry, Walk-In Closet(s), Ceiling Fan(s), Master Downstairs
- Window Features: Window Treatments
- Appliances: Water Softener Owned, Dishwasher, Disposal, Microwave, Electric Range, Refrigerator, Exhaust Fan
- Flooring: Carpet, Ceramic Tile, Laminate, Tile
- Room Information
- # of Rooms Total: 13
Exterior
- Exterior Features
- Patio And Porch Features: Front Porch, Covered
- Fencing: Back Yard, Vinyl
- Building Information
- Direction Faces: West
- Sq. Ft.: 1895.0
- Builder Name: Hansman
- Construction Materials: Fiber Cement
- Foundation Details: Slab
- Property Features
- Security Features: Smoke Detector(s)
- Property Information
- Property Type: Residential
- Property Sub Type: Single Family Residence
- Raw Mls Property Sub Type: Single Family Residence
- Lot Information
- Lot Features: Level
- Road Surface Type: Paved
- Road Responsibility: Public Maintained Road
- Lot Size Dimensions: 127.50 x 197.20
- Zoning: Single Family Res
- Zoning Description: R-1 One- Family Dwelling*
Financial
- Tax Information
- Tax Annual Amount: $2,042.76
Utilities
- Utility Information
- Water Source: Public
- Utilities: Electricity Available, Natural Gas Available
Location
- Schools Information
- Elementary School: Sturgeon
- Middle Or Junior School: Sturgeon
- High School District: Sturgeon
- High School: Sturgeon
- Location Information
- Directions: US 63 N to Hwy 22 Exit, Right on Hwy 22 to Right on Fairgrounds Road.
- Subdivision Name: STURGEON
Public facts
- Beds: 4
- Baths: 2.0
- Sq. Ft.: 1,826
- Stories: 1.0
- Lot Size: 0.58 acres
- Style: Single Family Residential
- Year Built: 2010
- Year Renovated: —
- County: Boone County
- APN: 0310800010390101
Other
- Listing Information
- List AOR: Columbia Board of REALTORS®
Around this home
Schools
Public PreK-5 • Assigned • 0.3mi
Public 6-8 • Assigned • 0.3mi
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
Minimal risk of a flood reaching the building in the next 30 years
Unlikely to be in a wildfire in next 30 years
7 days above 105° expected this year, 18 days in 30 years
0% chance of strong winds in next 30 years
0 unhealthy days expected this year, 0 days in 30 years
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.
Sell confidently with a local market expert in Sturgeon. 3 minutes to get started.
Nearby similar homes
New listings for sale in 65284
Home values near 516 N Fairgrounds Rd
| Address | Redfin Estimate |
|---|---|
3 Beds | 2.5 Baths | 1848 Sq. Ft. | $383,624 |
2 Beds | 1 Baths | 900 Sq. Ft. | $171,099 |
| Address | Redfin Estimate |
|---|---|
1 Beds | 1 Baths | 476 Sq. Ft. | $105,964 |
3 Beds | 2.5 Baths | 1735 Sq. Ft. | $340,470 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 2 Baths | 2558 Sq. Ft. | $454,453 |
3 Beds | 2 Baths | 1672 Sq. Ft. | $382,486 |
More real estate resources
- Zip Codes
- Cities
- Popular Searches
| 65284 homes for sale | |||
| 65240 homes for sale | |||
| 65243 homes for sale |
| Moberly homes for sale | |||
| Centralia homes for sale | |||
| Columbia homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.
Do not sell or share my personal information.
REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.
California DRE #01521930
Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures
New Mexico Real Estate Licenses
TREC: Info About Brokerage Services, Consumer Protection Notice
All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.
Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.
If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.
REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.
































United States
Canada