NOT LISTED FOR SALE

704 Bodega Trail Columbia, MO 65201

Shepard Boulevard Neighborhood

Estimated Value: $460,000 - $499,149

3 Beds
2 Baths
1,800 Sq Ft
$263/Sq Ft Est. Value

Sale Details

Date Sold: September 15, 2023

Current estimated payment $3,007 / mo

174 Days on Market

Highlights

  • Clubhouse
  • Ranch Style House
  • Community Pool
  • Jefferson Middle School Rated A-
  • Quartz Countertops
  • Covered Patio or Porch

About This Home

As of September 2023

Amazing DYNAMIC Home in The Brooks Subdivision! Same quality that you have come to expect from Dynamic Builders in an 1800 sq ft - 3 Bedroom - 2 bathroom - 3 car garage with a POCKET OFFICE!!! This one is going to knock your socks off!! The open concept, split bedroom design offers a beautiful kitchen with gorgeous countertops, stainless steel appliances and a VERY LARGE pantry! You will find a stunning custom tiled shower in the master bathroom and outside you will enjoy looking at the trees on the covered patio!! Schedule your appointment today!

Last Agent to Sell the Property

Karla Hill, P.C.

Weichert, Realtors - First Tier License #2009021674 Listed on: 08/21/2023

Co-Listed By

Mike Hill

Weichert, Realtors - House of Brokers License #2004013721

Last Buyer's Agent

MARSHELLE CLARK

Assist2Sell Buyers & Sellers Realty

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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 Details

Home Type

  • Single Family

Year Built

  • Built in 2023

Lot Details

  • Lot Dimensions are 77.52x125.46
  • Sprinkler System
  • Cleared Lot

HOA Fees

  • $33 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Ranch Style House
  • Traditional Architecture
  • Concrete Foundation
  • Slab Foundation
  • Poured Concrete
  • Architectural Shingle Roof
  • Radon Mitigation System
  • Stone Veneer

Interior Spaces

  • 1,800 Sq Ft Home
  • Paddle Fans
  • Electric Fireplace
  • Vinyl Clad Windows
  • Living Room with Fireplace
  • Breakfast Room
  • Fire and Smoke Detector

Kitchen

  • Gas Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops
  • Disposal

Flooring

  • Carpet
  • Laminate
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Split Bedroom Floorplan
  • Walk-In Closet
  • 2 Full Bathrooms
  • Bathtub with Shower
  • Shower

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Outdoor Features

  • Covered Patio or Porch

Schools

  • Cedar Ridge Elementary School
  • Oakland Middle School
  • Battle High School

Utilities

  • Humidifier
  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Municipal Utilities District Water
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 17-502-00-06-270.00 01

Community Details

Overview

  • $300 Initiation Fee
  • Built by Dynamic Builders
  • The Brooks Subdivision

Amenities

  • Clubhouse

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Year Built

Built in 2023

Lot Details

0 Sq Ft Lot

HOA Fees

$33 per month

Parking

3

Listing Details

  • Directions: WW to Hoylake Drive to Left on Stayton Ferry (directly across from Subdivision Pool) to first right on Bodega Drive - House is on the right. (New Construction phase has no street signs currently)
  • Lot Size: 77.52x125.46
  • Prop. Type: Residential
  • Year Built: 2023
  • BathsFull34MainLevel: 2
  • BathsFull34Total: 2
  • Property Sub Type: Single Family Residence
  • Road Surface Type: Paved, Public Maintained, Curbs and Gutters
  • Co List Office Phone: 573-256-8601
  • Subdivision Name: THE BROOKS
  • Above Grade Finished Sq Ft: 1800.0
  • Architectural Style: Ranch
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Exterior Finish:Concrete BoardFiber Cement: Yes
  • Foundation Material:Poured Concrete: Yes
  • ArchStyle:Traditional: Yes
  • Dining:Breakfast Room: Yes
  • Roof:ArchitecturalShingle: Yes
  • Utilities:Electric-County: Yes
  • Utilities:Gas-Natural: Yes
  • Water District: Yes
  • Flooring:Carpet: Yes
  • Flooring:Laminate: Yes
  • Flooring:Tile: Yes
  • Heat Fuel:Natural Gas: Yes
  • Heat Type:Forced Air: Yes
  • Patio:Back3: Yes
  • Exterior Finish:Stone Veneer: Yes
  • TopoLot Description:Cleared: Yes
  • Utilities:Sewage-City: Yes
  • Patio:Concrete2: Yes
  • Patio:Covered3: Yes
  • Porch:Covered2: Yes
  • Porch:Front2: Yes
  • Foundation Type:Slab: Yes
  • Special Features: NewHome

Interior Features

  • Flooring: Carpet, Laminate, Tile
  • Interior Amenities: High Spd Int Access, Tub/Shower, Stand AloneShwr/MBR, Split Bedroom Design, Walk in Closet(s), Washer/DryerConnectn, Main Lvl Master Bdrm, Radon Mit Ready, Home Warranty, Breakfast Room, Cabinets-Wood, Kitchen Island, Pantry, Counter-Quartz
  • Appliances: Humidifier
  • Basement YN: No
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Fireplace Features: In Living Room
  • Fireplace: Yes
  • Living Area: 1800.0
  • Window Features: Windows-Vinyl
  • InteriorFeatures:Cable Ready: Yes
  • InteriorFeatures:CeilingPaddleFan(s): Yes
  • InteriorFeatures:High Spd Int Access: Yes
  • InteriorFeatures:Laundry-Main Floor: Yes
  • InteriorFeatures:Main Lvl Master Bdrm: Yes
  • InteriorFeatures:Smoke Detector(s): Yes
  • InteriorFeatures:Split Bedroom Design: Yes
  • InteriorFeatures:TubShower: Yes
  • InteriorFeatures:Walk in Closet(s): Yes
  • InteriorFeatures:WasherDryerConnectn: 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
  • KitchenFeatures:Range-Gas: Yes
  • Fireplace:In Living Room: Yes
  • InteriorFeatures:Cable Available: Yes
  • InteriorFeatures:Humidifier: Yes
  • InteriorFeatures:Stand AloneShwrMBR: Yes
  • InteriorFeatures:Home Warranty: Yes
  • InteriorFeatures:Radon Mit Ready: Yes
  • KitchenFeatures:Counter-Quartz: Yes
  • Fireplace:Electric3: Yes

Exterior Features

  • Builder Name: Dynamic Builders
  • Exterior Features: Driveway-Paved
  • Roof: ArchitecturalShingle
  • Lot Features: Sprinkler-In Ground, Cleared
  • Pool Features: Pool-Community
  • Foundation Details: Poured Concrete, Slab
  • Patio And Porch Features: Concrete, Back, Covered, Front Porch
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Sprinkler-In Ground: Yes
  • Exterior Features:Windows-Vinyl: Yes
  • Exterior Features:Clubhouse-Community: Yes
  • Exterior Features:Pool-Community: Yes

Garage/Parking

  • Garage Spaces: 3.0
  • Parking Features: Garage Dr Opener(s), Attached
  • General Property Description:Garage Capacity: 3
  • InteriorFeatures:Garage Dr Opener(s): Yes
  • Foundation Access:Garage: Yes

Utilities

  • Utilities: Water-District, Cable Available, Cable Ready, Electric-County, Gas-Natural, Sewage-City, Trash-City
  • Cooling: Central Electric, Ceiling/PaddleFan(s)
  • Heating: Forced Air, Electric, Natural Gas
  • Laundry Features: Laundry-Main Floor
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Community Features: Clubhouse-Community
  • Association #2 Fee: 300.0
  • Association Fee: 400.0
  • Association Fee Frequency: Annual
  • Association: Yes

Schools

  • Elementary School: Cedar Ridge
  • Junior High Dist: Columbia
  • High School: Battle
  • Middle Or Junior School: Oakland

Lot Info

  • Land Lease Amount Frequency: N/A
  • Land Lease: No
  • Parcel #: 17-502-00-06-270.00 01
  • Zoning Description: R-1 One- Family Dwelling*

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 21, 2023
Closed on
Sep 15, 2023
Sold by
Bought by
Seller's Agent
Karla Hill, P.C.
Weichert, Realtors - First Tier
Buyer's Agent
MARSHELLE CLARK
Assist2Sell Buyers & Sellers Realty
List Price
$450,000
Views
6
Current Estimated Value
$474,287

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
2.60%
Original Mortgage
$75,000
Outstanding Balance
$69,721
Interest Rate
6.9%
Mortgage Type
Credit Line Revolving
Estimated Equity
$404,566
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Agents Specializing in Shepard Boulevard, MO

  • Lori Brockman Real Estate Agent - Weichert, Realtors - House of Brokers

    Lori Brockman

    Weichert, Realtors - House of Brokers

    (573) 615-8127

    269 Total Sales

    2 in Shepard Boulevard

    $272K - $275K Price Range

    Lori Brockman
     Section Image
  • Billy Dexheimer Real Estate Agent - North Star Real Estate

    Billy Dexheimer

    North Star Real Estate

    (573) 615-9102

    166 Total Sales

    1 in Shepard Boulevard

    $389,000 Price

    Billy Dexheimer
     Section Image
  • Stacey Swalla Real Estate Agent - Weichert, Realtors - House of Brokers

    Stacey Swalla

    Weichert, Realtors - House of Brokers

    (573) 615-9471

    316 Total Sales

    5 in Shepard Boulevard

    $302K - $450K Price Range

    Stacey Swalla
     Section Image
  • Scott Jackson Real Estate Agent - Weichert, Realtors - House of Brokers

    Scott Jackson

    Responds Quickly

    Weichert, Realtors - House of Brokers

    (573) 615-9806

    52 Total Sales

    1 in Shepard Boulevard

    $155,000 Price

    Scott Jackson
     Section Image
  • David Townsend Real Estate Agent - RE/MAX Boone Realty

    David Townsend

    Responds Quickly

    RE/MAX Boone Realty

    103 Total Sales

    3 in Shepard Boulevard

    $128K - $455K Price Range

    David Townsend
     Section Image
  • Sean Moore Real Estate Agent - RE/MAX Boone Realty

    Sean Moore

    Responds Quickly

    RE/MAX Boone Realty

    (573) 615-8079

    698 Total Sales

    10 in Shepard Boulevard

    $35K - $575K Price Range

    Sean Moore
     Section Image
See All Agents

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
-- Boone Central Title
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $75,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
09/15/2023 09/15/23 Sold -- -- --
08/30/2023 08/30/23 Pending -- -- --
08/21/2023 08/21/23 For Sale $450,000 0.0% $250 / Sq Ft
07/27/2023 07/27/23 Pending -- -- --
06/10/2023 06/10/23 Price Changed $450,000 -2.2% $250 / Sq Ft
03/08/2023 03/08/23 For Sale $460,000 -- $256 / Sq Ft
Source: Columbia Board of REALTORS®

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
2025 $4,409 $72,124 $13,300 $58,824
2024 $4,407 $62,985 $13,300 $49,685
2023 $3,293 $47,443 $13,300 $34,143
2022 $0 $0 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • K

    Seller's Agent in 2023

    Karla Hill, P.C.

    Weichert, Realtors - First Tier

  • Mike Hill Real Estate Agent - Weichert, Realtors - House of Brokers

    Seller Co-Listing Agent in 2023

    Mike Hill

    Weichert, Realtors - House of Brokers

    (573) 489-0052

    5 in this area

    209 Total Sales

    Mike Hill
    Section Image

  • M

    Buyer's Agent in 2023

    MARSHELLE CLARK

    Assist2Sell Buyers & Sellers Realty

  • M

    Buyer's Agent in 2023

    Marshelle Clark, PC

    Weichert, Realtors - First Tier

See All Agents

Map

Source: Columbia Board of REALTORS®

MLS Number: 412164

Columbia Board of REALTORS®

APN: 17-502-00-06-270.00 01

Missouri Boone County Columbia 65201 Shepard Boulevard

704 Bodega Trail, Columbia, MO

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Columbia Board of REALTORS® IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.