NOT LISTED FOR SALE

200 E Brandon Rd Columbia, MO 65203

Estimated Value: $425,000 - $716,000

4 Beds
3 Baths
2,411 Sq Ft
$257/Sq Ft Est. Value

Last Sold March 22, 2024

Current estimated payment $3,865/month

1 Day on Market

Highlights

  • Deck
  • Contemporary Architecture
  • Wood Flooring
  • David H. Hickman High School Rated A-
  • Partially Wooded Lot
  • Main Floor Bedroom

About This Home

As of March 2024

Step into a timeless embrace of mid-century elegance with this captivating residence! Nestled in the sought-after Grasslands neighborhood on a tranquil street, this home is a manifestation of character and meticulous detailing. Resting on nearly an acre, the property boasts a unique design adorned with sleek finishes and chic vibes.

Discover the perfect harmony of functionality and style with four bedrooms, three full bathrooms, and a lower level den. Sunlight dances through picturesque windows, creating an inviting atmosphere throughout the entire home. Ascend to the rooftop deck for breathtaking views or unwind in the comfort of a cozy screened-in patio overlooking a serene backyard with year-round views.

Immerse yourself in the vibrant community, as this home offers the luxury Step into a timeless embrace of mid-century elegance with this captivating residence! Nestled in the sought-after Grasslands neighborhood on a tranquil street, this home is a manifestation of character and meticulous detailing. Resting on nearly an acre, the property boasts a unique design adorned with sleek finishes and chic vibes.

Discover the perfect harmony of functionality and style with four bedrooms, three full bathrooms, and a lower level den. Sunlight dances through picturesque windows, creating an inviting atmosphere throughout the entire home. Ascend to the rooftop deck for breathtaking views or unwind in the comfort of a cozy screened-in patio overlooking a serene backyard with year-round vistas.

Immerse yourself in the vibrant community, as this home offers the luxury of being within walking distance to Faurot Field, the Katy Trail, and downtown Columbia. This residence is not just a house; it's an extraordinary living experience, a true one-of-a-kind gem waiting to be discovered and cherished. Welcome to the epitome of unique charm and timeless allure!

Last Listed By

Lori Brockman

Weichert, Realtors - First Tier License #2002020294 Listed on: 02/02/2024

Weichert, Realtors - First Tier

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,925

Year Built

  • Built in 1950

Lot Details

  • Lot Dimensions are 149.6 x 299.15 x 150 x 286.85
  • Home fronts a stream
  • North Facing Home
  • Lot Has A Rolling Slope
  • Partially Wooded Lot

Parking

  • 1 Car Attached Garage
  • Garage Door Opener
  • Driveway
  • Open Parking

Home Design

  • Contemporary Architecture
  • Traditional Architecture
  • Concrete Foundation
  • Poured Concrete
  • Architectural Shingle Roof

Interior Spaces

  • 1.5-Story Property
  • Gas Fireplace
  • Window Treatments
  • Family Room with Fireplace
  • Living Room
  • Formal Dining Room
  • Screened Porch
  • Fire and Smoke Detector
  • Washer and Dryer Hookup

Kitchen

  • Eat-In Kitchen
  • Built-In Double Oven
  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Built-In or Custom Kitchen Cabinets
  • Utility Sink

Flooring

  • Wood
  • Carpet
  • Concrete
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Main Floor Bedroom
  • Bathroom Rough-In
  • Bathroom on Main Level
  • 3 Full Bathrooms
  • Hydromassage or Jetted Bathtub
  • Bathtub with Shower
  • Shower Only

Partially Finished Basement

  • Interior Basement Entry
  • Crawl Space

Outdoor Features

  • Deck
  • Patio

Schools

  • Grant Elementary School
  • Jefferson Middle School
  • Hickman High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Heat Pump System
  • High-Efficiency Furnace
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Grasslands Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1661100011320001

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,925

Year Built

Built in 1950

Lot Details

0

Parking

1

Listing Details

  • Directions: South on Providence to Brandon Rd.
  • Lot Size: 149.6 x 299.15 x 150 x 286.85
  • Prop. Type: Residential
  • Bedroom 2 Level: Main
  • Dining Room Level: Main
  • Full Bathroom Level: Main
  • Kitchen Level: Main
  • Living Room Level: Main
  • Primary Bedroom Level: Upper
  • Year Built: 1950
  • BathsFull34MainLevel: 1
  • BathsFull34UpperLevel: 2
  • Property Sub Type: Single Family Residence
  • Road Surface Type: Paved, Public Maintained
  • Co List Office Mls Id: 10740
  • Co List Office Phone: 573-256-8601
  • Subdivision Name: GRASSLANDS
  • Above Grade Finished Sq Ft: 2058.0
  • Architectural Style: 1.5 Story
  • Garage Type Attached: Yes
  • Cooling:Central Electric: 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
  • Rooms:Dining Room: Yes
  • Rooms:Family Room2: Yes
  • Rooms:Living Room: Yes
  • Foundation Type:Full Bsmt Part Fin: Yes
  • Foundation Access:Inside Entrance: Yes
  • Dining:Eat-In Kitchen: Yes
  • Dining:Formal Dining: Yes
  • Utilities:Electric-City: Yes
  • Utilities:Sewage-City: Yes
  • Utilities:Water-City: Yes
  • Flooring:Wood2: Yes
  • Heat Fuel:Electricity: Yes
  • Heat Type:Heat Pump(s)2: Yes
  • Heat Type:High Efficiency Furnace: Yes
  • Patio:Concrete2: Yes
  • Porch:Covered2: Yes
  • Foundation Type:Crawl Space: Yes
  • Deck:Side: Yes
  • Porch:Side2: Yes
  • Flooring:Concrete: Yes
  • ArchStyle:Contemporary: Yes
  • Porch:Screened2: Yes
  • Special Features: None

Interior Features

  • Has Basement: Crawl Space
  • Bedroom 3 Level: Upper
  • Bedroom 4 Level: Upper
  • Family Room Level: Lower
  • Flooring: Wood, Carpet, Concrete, Tile
  • Interior Amenities: High Spd Int Access, Utility Sink, Tub/Shower, Stand AloneShwr/MBR, Tub/Built In Jetted, Window Treatmnts All, Washer/DryerConnectn, Cable Available, Additional Laundry Hookup(s), Rough in Bath, Smoke Detector(s), Garage Dr Opener(s), Eat-in Kitchen, Formal Dining, Cabinets-Custom Blt, Granite Counters, Cabinets-Wood, Kitchen Island, Pantry
  • Basement YN: Yes
  • Full Bathrooms: 3
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 353.0
  • Fireplace Features: Gas, In Family Room
  • Fireplace: Yes
  • Living Area: 2411.0
  • Fireplace:Gas: Yes
  • Fireplace:In Family Room: Yes
  • InteriorFeatures:High Spd Int Access: Yes
  • InteriorFeatures:Smoke Detector(s): Yes
  • InteriorFeatures:TubShower: Yes
  • InteriorFeatures:WasherDryerConnectn: Yes
  • KitchenFeatures:Cabinets-Custom Blt: Yes
  • KitchenFeatures:Cabinets-Wood: Yes
  • KitchenFeatures:Dishwasher-Built In: Yes
  • KitchenFeatures:Island: Yes
  • KitchenFeatures:Microwave Oven: Yes
  • Kitchen Features Pantry: Yes
  • InteriorFeatures:Cable Available: Yes
  • InteriorFeatures:Stand AloneShwrMBR: Yes
  • InteriorFeatures:TubBuilt In Jetted: Yes
  • InteriorFeatures:Utility Sink: Yes
  • InteriorFeatures:Window Treatmnts All: Yes
  • KitchenFeatures:Cooktop-Gas: Yes
  • KitchenFeatures:Counter-Granite: Yes
  • KitchenFeatures:Refrigerator: Yes
  • KitchenFeatures:Double Oven: Yes
  • KitchenFeatures:Vent Fan: Yes
  • KitchenFeatures:Wall Oven(s): Yes
  • InteriorFeatures:Additional Laundry Hookup(s): Yes
  • InteriorFeatures:Rough in Bath: Yes

Exterior Features

  • Exterior Features: Driveway-Paved
  • Roof: ArchitecturalShingle
  • Lot Features: Rolling Slope
  • Waterfront Features: Stream
  • Waterfront: Yes
  • Direction Faces: North
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Concrete, Back, Deck, Side Porch
  • Exterior Features:Driveway-Paved: Yes

Garage/Parking

  • Garage Spaces: 1.0
  • Open Parking: Yes
  • Parking Features: Attached
  • General Property Description:Garage Capacity: 1
  • InteriorFeatures:Garage Dr Opener(s): Yes
  • General Property Description:Uncovered Parking: Parking Pad

Utilities

  • Utilities: Water-City, Gas-Natural, Sewage-City, Electric-City, Trash-City
  • Cooling: Central Electric
  • Heating: Heat Pump(s), High Efficiency Furnace, Forced Air, Electric, Natural Gas
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Association: No

Schools

  • Elementary School: Grant
  • Junior High Dist: Columbia
  • High School: Hickman
  • Middle Or Junior School: Jefferson

Lot Info

  • Land Lease Amount Frequency: N/A
  • Land Lease: No
  • Parcel #: 1661100011320001
  • Zoning Description: R-1 One- Family Dwelling*

Tax Info

  • Tax Annual Amount: 4924.62
  • Tax Year: 2023

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
May 2, 2025
Sold by
Stegmaier Mary and Leone Ronald
Bought by
Mary A Stegmaier Trust and Ronald J Leone Trust
Total Days on Market
1
Current Estimated Value
$619,410

Purchase Details

Listed on
Feb 2, 2024
Closed on
Mar 22, 2024
Sold by
Guy Thomas M and Guy Lori L
Bought by
Stegmaier Mary and Leone Ronald
Seller's Agent
Lori Brockman
Weichert, Realtors - First Tier
Buyer's Agent
Brent Gardner
Berkshire Hathaway HomeServices | Vision Real Estate
List Price
$675,000
Sold Price
$701,000
Premium/Discount to List
$26,000
3.85%
Views
77

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-10.12%
Original Mortgage
$426,000
Interest Rate
6.64%
Mortgage Type
New Conventional

Purchase Details

Listed on
Apr 25, 2017
Closed on
Jun 16, 2017
Sold by
Ns Cee Llc
Bought by
Guy Thomas M and Guy Lori Lynn
Seller's Agent
Carol Denninghoff
House of Brokers Realty, Inc.
Buyer's Agent
Jackie Bulgin
House of Brokers Realty, Inc.
List Price
$525,000
Sold Price
$517,500
Premium/Discount to List
-$7,500
-1.43%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.58%
Original Mortgage
$414,000
Interest Rate
4.02%
Mortgage Type
New Conventional

Purchase Details

Closed on
Feb 21, 2014
Sold by
Central Trust & Investment Co
Bought by
Nscee Llc

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

Similar Homes in Columbia, MO

  • 424 Angels Rest Way, Columbia, MO 65203

    $619,000

    • 3 Beds
    • 2.5 Baths
    • 2,007 Sq Ft
    • 424 Angels Rest Way
    • Columbia, MO

    Welcome to your dream home! This unique modern home seamlessly blends sophistication with comfort, offering an unparalleled living experience. Step inside to discover soaring ceilings leading you into a space filled with natural light and contemporary charm.Nestled in a desirable area, this home ensures privacy and tranquility with a spacious backyard, perfect for relaxing or entertaining guests.

    Joan Wilkerson Girard Realty

    Section Image
  • 6600 Walsby Dr, Columbia, MO 65201

    $750,000

    • 4 Beds
    • 2.5 Baths
    • 2,577 Sq Ft
    • 6600 Walsby Dr
    • Columbia, MO

    Welcome to this stunning custom-built ranch-style home nestled in the prestigious Old Hawthorne community. Spanning 2,577 square feet all on one level, this home perfectly blends modern design, high-end finishes, and practical luxury. 3 Spacious Bedrooms, 2.5 Bathrooms, and a 3-Car Garage Step inside to find an open-concept layout with soaring ceilings, wide plank flooring, and abundant natural

    Joan Wilkerson Girard Realty

    Section Image
  • 1004 Lakeshore Dr, Columbia, MO 65203

    $475,000

    • 4 Beds
    • 3 Baths
    • 2,349 Sq Ft
    • 1004 Lakeshore Dr
    • Columbia, MO

    Embrace unrivaled serenity in the coveted Quarry Heights, where nature-inspired living meets thoughtful design. Nestled just 750 feet from the MKT Trail and Quarry Member's access point, this property is a dream for outdoor enthusiasts. With many recreational activities at your fingertips, the Quarry Lifestyle offers a harmonious blend of adventure and tranquility. This home captivates with

    Bev Curtis Bev & Co. Realty, LLC

    Section Image
  • 504 S Glenwood Ave, Columbia, MO 65203

    $625,000

    • 3 Beds
    • 3.5 Baths
    • 2,948 Sq Ft
    • 504 S Glenwood Ave
    • Columbia, MO

    Discover the charm and character of this classic 2-story home located on one of Columbia's historic streets in the sought-after Old Southwest neighborhood. Just minutes from downtown, the library, parks, shopping, and popular local restaurants, this home offers both convenience and timeless appeal. With loads of potential and a deep lot perfect for gardening, entertaining, or future expansion,

    Jay Wilson Weichert, Realtors - First Tier

    Section Image
  • 2002 Valley View Rd, Columbia, MO 65201

    $540,000

    • 4 Beds
    • 3 Baths
    • 2,338 Sq Ft
    • 2002 Valley View Rd
    • Columbia, MO

    Rare find! Totally remodeled home overlooking the Hinkson Creek Valley, looking west at the Mizzou Vet School. The property sits on 1.2 acres, and connected to the Columbia Trail System, which connects to Grindstone Nature Area and Clyde Wilson Park. The house sits at the end of a cul-de-sac and feels brand new. Enjoy 4 bedrooms and 3 full bathrooms and a wonderful open kitchen, walking out to a

    Brent Gardner Berkshire Hathaway HomeServices | Vision Real Estate

    Section Image
  • 1825 Cliff Dr, Columbia, MO 65201

    $690,000

    • 5 Beds
    • 4 Baths
    • 4,436 Sq Ft
    • 1825 Cliff Dr
    • Columbia, MO

    This home is a rare find, close to MU campus, all hospitals, Stephens Park and College. Bright and fully remodeled Mid-Century Modern home in the heart of Columbia. This walkout ranch has over 4400 finished square feet, with 5 bedrooms and 4 full bathrooms. Very spacious throughout, including a very large open kitchen and dining room. Many oversized windows let in quantities of light, showing

    Brent Gardner Berkshire Hathaway HomeServices | Vision Real Estate

    Section Image
  • 5005 Kiawah Ln, Columbia, MO 65203

    $700,000

    • 5 Beds
    • 3 Baths
    • 3,146 Sq Ft
    • 5005 Kiawah Ln
    • Columbia, MO

    This stunning Hemme Construction home, built in 2022, offers 5 bedrooms, 3 bathrooms, a 3-car garage, and 3,146 sqft of beautifully designed living space. Located in the desirable Creeks Edge Subdivision, this walk-out ranch is a true showstopper. As you step through the front door, you'll be greeted by an open floor plan featuring expansive windows that flood the space with natural light and

    Sharon Bennett RE/MAX Boone Realty

    Section Image
  • 2004 Bluff Pointe Dr, Columbia, MO 65201

    $485,000

    • 4 Beds
    • 3 Baths
    • 3,330 Sq Ft
    • 2004 Bluff Pointe Dr
    • Columbia, MO

    Enjoy the serene setting of this well-maintained home in East Pointe Subdivision, situated on a 300' deep lot backing to Grindstone Creek. Privacy, but open space, with a level backyard perfect for relaxing or entertaining. Thoughtfully built with 6'' exterior walls, this home features an updated kitchen w/granite, fresh interior paint, and a spacious layout including a formal dining room, large

    Susan Myers, PC Weichert, Realtors - First Tier

    Section Image
  • 3405 Woodrail Terrace, Columbia, MO 65203

    $549,900

    • 4 Beds
    • 3.5 Baths
    • 3,380 Sq Ft
    • 3405 Woodrail Terrace
    • Columbia, MO

    This beautifully remodeled home in Woodrail is just down the street from CCMO club house, pool, tennis courts and golf. Buyers will love the hardwood floors, remodeled kitchen, induction cooktop, beverage bar and plenty of cabinet space. Cozy up with 2 fireplaces one in the great room and the other in the all seasons room or enjoy the private outdoor patio for entertaining. The primary suite

    Jen McCallister 573 Realty, LLC

    Section Image

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
Mary A Stegmaier Trust -- None Listed On Document
Mary A Stegmaier Trust -- None Listed On Document
Stegmaier Mary -- Boone Central Title
Guy Thomas M -- Boone Central Title Co
Nscee Llc -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Stegmaier Mary $426,000
Previous Owner Guy Thomas M $213,550
Previous Owner Guy Thomas M $381,974
Previous Owner Guy Thomas M $395,000
Previous Owner Guy Thomas M $414,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/22/2024 03/22/24 Sold -- -- --
02/04/2024 02/04/24 Pending -- -- --
02/02/2024 02/02/24 For Sale $675,000 +28.6% $280 / Sq Ft
06/16/2017 06/16/17 Sold -- -- --
04/28/2017 04/28/17 Pending -- -- --
04/25/2017 04/25/17 For Sale $525,000 -- $218 / 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 $4,966 $73,606 $7,163 $66,443
2023 $4,925 $73,606 $7,163 $66,443
2022 $4,555 $68,153 $7,163 $60,990
2021 $4,564 $68,153 $7,163 $60,990
2020 $4,497 $63,099 $7,163 $55,936
2019 $4,497 $63,099 $7,163 $55,936
2018 $4,193 $0 $0 $0
2017 $2,155 $30,400 $7,163 $23,237
2016 $2,212 $30,400 $7,163 $23,237
2015 $2,041 $30,400 $7,163 $23,237
2014 -- $35,283 $6,612 $28,671
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Columbia Board of REALTORS®

MLS Number: 418085

Columbia Board of REALTORS®

APN: 16-611-00-01-132-00-01