NOT LISTED FOR SALE

651 W Covered Bridge Rd Columbia, MO 65203

Estimated Value: $1,490,000 - $2,367,000

7 Beds
9 Baths
8,951 Sq Ft
$221/Sq Ft Est. Value

Last Sold August 19, 2022

Current estimated payment $12,236/month

23 Days on Market

Highlights

  • In Ground Pool
  • Community Lake
  • Partially Wooded Lot
  • Ann Hawkins Gentry Middle School Rated A-
  • Fireplace in Primary Bedroom
  • Traditional Architecture

About This Home

As of August 2022

Welcome to this sophisticated and elegant brick Hill Creek home with a private drive leading to the most exquisite and spacious home set on almost 11 beautiful acres. Within steps of entering this masterful, total renovation (2020 by Anderson Homes), you will know this home is special. Two story foyer w/curved staircase, two story great room w/floor to ceiling windows offering beautiful views for year round enjoyment. Gourmet kitchen w/large island (with hidden pantry/prep room) is open to breakfast and sitting room. Main level owners wing is a private sanctuary complete w/fireplace & patio, w/luxury en suite. A gorgeous library, formal dining, game room, media room and more for entertaining. Functionality, luxury, modern lines with a warm home feel...

Last Agent to Sell the Property

Erin Hendershott

573 Realty, LLC License #2016045114 Listed on: 07/07/2022

Co-Listed By

Katie Wagner

573 Realty, LLC License #2015010198

Last Buyer's Agent

Andy Boyles

Iron Gate Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $13,441

Year Built

  • Built in 1995

Lot Details

  • 10.49 Acre Lot
  • Back Yard Fenced
  • Aluminum or Metal Fence
  • Partially Wooded Lot

Parking

  • 4 Car Attached Garage
  • Rear-Facing Garage
  • Side Facing Garage
  • Tandem Parking
  • Garage Door Opener
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Veneer
  • Concrete Foundation
  • Poured Concrete
  • Architectural Shingle Roof

Interior Spaces

  • Wet Bar
  • Wired For Sound
  • Ceiling Fan
  • Paddle Fans
  • Gas Fireplace
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Formal Dining Room
  • Partially Finished Basement
  • Walk-Out Basement

Kitchen

  • Eat-In Kitchen
  • Gas Cooktop
  • Microwave
  • Dishwasher
  • ENERGY STAR Qualified Appliances
  • Kitchen Island
  • Built-In or Custom Kitchen Cabinets
  • Utility Sink
  • Disposal
  • Fireplace in Kitchen

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 7 Bedrooms
  • Primary Bedroom on Main
  • Fireplace in Primary Bedroom
  • Split Bedroom Floorplan
  • Walk-In Closet
  • Shower Only
  • Garden Bath

Home Security

  • Home Security System
  • Exterior Cameras
  • Fire and Smoke Detector

Outdoor Features

  • In Ground Pool
  • Covered patio or porch
  • Gazebo

Schools

  • Rock Bridge Elementary School
  • Gentry Middle School
  • Rock Bridge High School

Farming

  • Equipment Barn

Utilities

  • Forced Air Zoned Cooling and Heating System
  • Heating System Uses Natural Gas
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Hillcreek Subdivision
  • Community Lake

Listing and Financial Details

  • Assessor Parcel Number 2030311010010001

Home Details

Home Type

Single Family

Est. Annual Taxes

$13,441

Year Built

Built in 1995

Lot Details

0

Parking

4

Listing Details

  • Directions: S Route K to S Hill Creek Rd, right on W Covered Bridge Rd.
  • Prop. Type: Residential
  • Year Built: 1995
  • BathsFull34LowerLevel: 2
  • BathsFull34MainLevel: 1
  • BathsFull34Total: 7
  • BathsFull34UpperLevel: 4
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 10.49
  • Road Surface Type: Paved, Public Maintained
  • Co List Office Mls Id: 510002252
  • Subdivision Name: HILLCREEK
  • Above Grade Finished Sq Ft: 5459.0
  • Architectural Style: 15 Story
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Foundation Access:Walkout: Yes
  • Foundation Material:Poured Concrete: Yes
  • ArchStyle:Traditional: Yes
  • TopoLot Description:Partially Wooded: Yes
  • Roof:ArchitecturalShingle: Yes
  • Utilities:Gas-Natural: Yes
  • Flooring:Carpet: Yes
  • Flooring:Tile: Yes
  • Heat Fuel:Natural Gas: Yes
  • Heat Type:Forced Air: Yes
  • Patio:Back3: Yes
  • Baths-Half:Main Level2: 1
  • Baths-Half:Total2: 2
  • Foundation Type:Full Bsmt Part Fin: Yes
  • Dining:Eat-In Kitchen: Yes
  • Dining:Formal Dining: Yes
  • Utilities:Electric-City: Yes
  • Utilities:Water-City: Yes
  • Flooring:Wood2: Yes
  • Patio:Concrete2: Yes
  • Patio:Covered3: Yes
  • Fence:Backyard: Yes
  • Porch:Covered2: Yes
  • Porch:Front2: Yes
  • Fence:Partial: Yes
  • Baths-Half:Lower Level2: 1
  • Exterior Finish:Brick Veneer: Yes
  • Fence Material:Metal4: Yes
  • Patio:Brick3: Yes
  • Outbuildings:Gazebo: Yes
  • Outbuildings:Equipment Bldg: Yes
  • Special Features: None

Interior Features

  • Flooring: Wood, Carpet, Tile
  • Interior Amenities: Utility Sink, Stand AloneShwr/MBR, Split Bedroom Design, Tub-Garden, Wired for Audio, Walk in Closet(s), Main Lvl Master Bdrm, Remodeled, Cable Available, Bar-Wet Bar, Ceiling/PaddleFan(s), Cable Ready, Dual Zone Control HVAC, Security System, Smoke Detector(s), Garage Dr Opener(s), Eat-in Kitchen, Formal Dining, Cabinets-Custom Blt, Cabinets-Wood, Kitchen Island, Pantry
  • Basement YN: Yes
  • Full Bathrooms: 7
  • Half Bathrooms: 2
  • Total Bedrooms: 7
  • Below Grade Sq Ft: 3492.0
  • Fireplace Features: In Master Bedroom, In Living Room, In Kitchen, Gas, In Family Room
  • Fireplace: Yes
  • Living Area: 8951.0
  • Fireplace:Gas: Yes
  • Fireplace:In Family Room: Yes
  • InteriorFeatures:Cable Ready: Yes
  • InteriorFeatures:CeilingPaddleFan(s): Yes
  • InteriorFeatures:Main Lvl Master Bdrm: Yes
  • InteriorFeatures:Smoke Detector(s): Yes
  • InteriorFeatures:Split Bedroom Design: Yes
  • InteriorFeatures:Tub-Garden: Yes
  • InteriorFeatures:Walk in Closet(s): Yes
  • KitchenFeatures:Cabinets-Custom Blt: Yes
  • KitchenFeatures:Cabinets-Wood: Yes
  • KitchenFeatures:Dishwasher-Built In: Yes
  • KitchenFeatures:Garbage Disposal: Yes
  • KitchenFeatures:Island: Yes
  • KitchenFeatures:Microwave Oven: Yes
  • Kitchen Features Pantry: Yes
  • Fireplace:In Kitchen: Yes
  • Fireplace:In Living Room: Yes
  • InteriorFeatures:Bar-Wet Bar: Yes
  • InteriorFeatures:Cable Available: Yes
  • InteriorFeatures:Dual Zone Control HVAC: Yes
  • InteriorFeatures:ENERGY STAR Qualified Appliances: Yes
  • InteriorFeatures:Remodeled: Yes
  • InteriorFeatures:Security System: Yes
  • InteriorFeatures:Stand AloneShwrMBR: Yes
  • InteriorFeatures:Utility Sink: Yes
  • InteriorFeatures:Wired for Audio: Yes
  • KitchenFeatures:Cooktop-Gas: Yes
  • Fireplace:In Master Bedroom: Yes

Exterior Features

  • Exterior Features: Security Cameras, Community Lake, Driveway-Paved, Pool-In Ground
  • Roof: ArchitecturalShingle
  • Fencing: Backyard, Partial, Metal
  • Foundation Details: Poured Concrete
  • Other Structures: Gazebo, Equipment Bldg
  • Patio And Porch Features: Concrete, Back, Covered, Brick, Front Porch
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Community Lake: Yes
  • Exterior Features:Pool-In Ground: Yes
  • Exterior Features:Security Cameras: Yes

Garage/Parking

  • Garage Spaces: 4.0
  • Parking Features: Attached, Rear Entry, Side Entry, Tandem
  • General Property Description:Garage Capacity: 4
  • InteriorFeatures:Garage Dr Opener(s): Yes
  • Garage Type:Side Entry: Yes
  • Garage Type:Rear Entry: Yes
  • Garage Type:Tandem: Yes

Utilities

  • Utilities: Water-City, Gas-Natural, Electric-City, Trash-City
  • Cooling: Central Electric
  • Heating: Forced Air, Natural Gas
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Association Fee Frequency: Annual
  • Association: No

Schools

  • Elementary School: Rock Bridge
  • Junior High Dist: Columbia
  • High School: Rock Bridge
  • Middle Or Junior School: Gentry

Lot Info

  • Land Lease Amount Frequency: N/A
  • Land Lease: No
  • Lot Size Sq Ft: 456944.4
  • Parcel #: 2030311010010001
  • Zoning Description: R-1 One- Family Dwelling*
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Annual Amount: 13441.41

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 7, 2022
Closed on
Aug 19, 2022
Sold by
Alan Maclellan Jeffrey and Alan Elizabeth Jane
Bought by
Lrl And Sel Revocable Trust
Seller's Agent
Erin Hendershott
573 Realty, LLC
Buyer's Agent
Andy Boyles
Iron Gate Real Estate
List Price
$2,100,000
Sold Price
$1,950,000
Premium/Discount to List
-$150,000
-7.14%
Current Estimated Value
$1,977,768

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$27,768
Avg. Annual Appreciation
0.50%
Original Mortgage
$1,137,500
Interest Rate
5.54%
Mortgage Type
New Conventional

Purchase Details

Listed on
Mar 14, 2019
Closed on
Aug 30, 2019
Sold by
The Curators The University Of Missouri
Bought by
Maclellan Jeffrey Alan and Maclellan Jane Elizabeth
Seller's Agent
Wendy Swetz
The Company, Wendy C. Swetz Real Estate
Buyer's Agent
Martha McKim
Iron Gate Real Estate
List Price
$950,000
Sold Price
$750,000
Premium/Discount to List
-$200,000
-21.05%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
38.10%
Original Mortgage
$750,000
Interest Rate
4%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Aug 8, 2018
Sold by
Whiteside John L
Bought by
The Curators Of The University Of Missou
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Lrl And Sel Revocable Trust -- Boone Central Title
Maclellan Jeffrey Alan -- None Available
The Curators Of The University Of Missou -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Lrl And Sel Revocable Trust $2,330,000
Closed Lrl And Sel Revocable Trust $1,137,500
Previous Owner Maclellan Jane Elizabeth $100,000
Previous Owner Maclellan Jane Elizabeth $647,200
Previous Owner Maclellan Jane Elizabeth $510,400
Previous Owner Maclellan Jane Elizabeth $325,000
Previous Owner Maclellan Jeffrey Alan $870,000
Previous Owner Maclellan Jeffrey Alan $750,000
Previous Owner Creighton Donald L $417,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/19/2022 08/19/22 Sold -- -- --
07/29/2022 07/29/22 Off Market -- -- --
07/22/2022 07/22/22 Price Changed $1,950,000 +63.2% $218 / Sq Ft
07/22/2022 07/22/22 Price Changed $1,195,000 -90.0% $134 / Sq Ft
07/22/2022 07/22/22 Price Changed $11,950,000 +469.0% $1,335 / Sq Ft
07/06/2022 07/06/22 For Sale $2,100,000 +121.1% $235 / Sq Ft
09/03/2019 09/03/19 Sold -- -- --
07/24/2019 07/24/19 Pending -- -- --
03/14/2019 03/14/19 For Sale $950,000 -- $90 / Sq Ft
Source: Columbia Board of REALTORS®

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $14,628 $202,293 $16,717 $185,576
2023 $14,504 $202,293 $16,717 $185,576
2022 $13,421 $187,321 $16,717 $170,604
2021 $13,441 $187,321 $16,717 $170,604
2020 $10,039 $132,050 $19,361 $112,689
2019 $11,108 $0 $0 $0
2018 $11,108 $0 $0 $0
2017 $10,982 $145,198 $19,361 $125,837
2016 $10,964 $145,198 $19,361 $125,837
2015 $10,125 $145,198 $19,361 $125,837
2014 -- $145,198 $19,361 $125,837
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Columbia Board of REALTORS®

MLS Number: 408288

Columbia Board of REALTORS®

APN: 20-303-11-01-001-00-01