$425,000
SOLD JUL 9, 2025
Last list price

4702 Rainbow Trout Dr Columbia, MO 65203

4 Beds
3 Baths
2,610 Sq Ft
10,454 Sq Ft Lot

Sale Details

Date Sold: July 9, 2025

$163 Per Sq Ft

3 Days on Market

Highlights

  • Deck
  • Ranch Style House
  • Breakfast Room
  • Paxton Keeley Elementary School Rated A-
  • Hydromassage or Jetted Bathtub
  • Utility Sink

About This Home

As of July 2025

Welcome to this beautifully maintained 4-bedroom, 3 full bathrooms, walk-out ranch located in Columbia's sought-after southwest. Located in Quail Creek Subdivision, this home offers a perfect blend of comfort, functionality, and style.
Step inside to find a welcoming layout featuring a formal dining room and a spacious kitchen with a sunny breakfast nook, abundant cabinet space, and room to gather. The split-bedroom design offers privacy and flexibility, with the generous master suite boasting a double vanity, jetted tub, stand-alone shower, and a walk-in closet.
The lower level includes a family room complete with a wet bar—ideal for entertaining—as well as ample unfinished space perfect for storage, a workshop, or future expansion.

Last Agent to Sell the Property

Steve Miller

REMAX Boone Realty License #1999121694 Listed on: 05/13/2025

REMAX Boone Realty

Last Buyer's Agent

Jennifer Zhang

REMAX Boone Realty License #2016035211

REMAX Boone Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,878

Year Built

  • Built in 2002

Lot Details

  • 10,400 Sq Ft Lot
  • Lot Dimensions are 80x130
  • North Facing Home

HOA Fees

  • $8 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Ranch Style House
  • Brick Veneer
  • Concrete Foundation
  • Poured Concrete
  • Architectural Shingle Roof
  • Vinyl Construction Material

Interior Spaces

  • Wet Bar
  • Paddle Fans
  • Gas Fireplace
  • Vinyl Clad Windows
  • Window Treatments
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Breakfast Room
  • Formal Dining Room

Kitchen

  • Electric Range
  • Microwave
  • Dishwasher
  • Laminate Countertops
  • Utility Sink
  • Disposal

Flooring

  • Carpet
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Split Bedroom Floorplan
  • Walk-In Closet
  • Bathroom on Main Level
  • 3 Full Bathrooms
  • Primary bathroom on main floor
  • Hydromassage or Jetted Bathtub
  • Bathtub with Shower
  • Shower Only

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Partially Finished Basement

  • Walk-Out Basement
  • Interior and Exterior Basement Entry

Home Security

  • Storm Doors
  • Fire and Smoke Detector

Outdoor Features

  • Deck
  • Patio
  • Rear Porch

Schools

  • Mary Paxton Keeley Elementary School
  • Smithton Middle School
  • Hickman High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • High Speed Internet
  • Cable TV Available

Community Details

  • Built by Herigon
  • Quail Creek Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1641200030570001

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,878

Year Built

Built in 2002

Lot Details

10,400 Sq Ft Lot

HOA Fees

$8 per month

Parking

2

Listing Details

  • Directions: Scott Blvd to Rainbow Trout
  • Lot Size: 80x130
  • Prop. Type: Residential
  • Bedroom 2 Level: Main
  • Dining Room Level: Main
  • Full Bathroom Level: Main
  • Kitchen Level: Main
  • Living Room Level: Main
  • Master Bathroom Level: Main
  • Primary Bedroom Level: Main
  • Year Built: 2002
  • BathsFull34LowerLevel: 1
  • BathsFull34MainLevel: 2
  • BathsFull34Total: 3
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.24
  • Road Surface Type: Paved, Public Maintained, Curbs and Gutters
  • Subdivision Name: QUAIL CREEK
  • Above Grade Finished Sq Ft: 1771.0
  • Architectural Style: Ranch
  • Foundation Type:Walkout Basement: Yes
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Foundation Access:Walkout: Yes
  • Foundation Material:Poured Concrete: Yes
  • Deck:Back: Yes
  • Dining:Breakfast Room: 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
  • Foundation Access:Outside Entrance: Yes
  • Dining:Formal Dining: Yes
  • Utilities:Electric-City: Yes
  • Utilities:Sewage-City: Yes
  • Utilities:Water-City: Yes
  • Flooring:Vinyl3: Yes
  • Patio:Concrete2: Yes
  • Exterior Finish:Vinyl2: Yes
  • Exterior Finish:Brick Veneer: Yes
  • Special Features: VirtualTour

Interior Features

  • Has Basement: Walk-Out Access
  • Bedroom 3 Level: Main
  • Bedroom 4 Level: Lower
  • Family Room Level: Lower
  • Flooring: Carpet, Tile, Vinyl
  • Interior Amenities: High Spd Int Access, Tub/Shower, Stand AloneShwr/MBR, Split Bedroom Design, Tub/Built In Jetted, Window Treatmnts All, Walk in Closet(s), Washer/DryerConnectn, Main Lvl Master Bdrm, Bar-Wet Bar, Breakfast Room, Formal Dining, Counter-Laminate, Cabinets-Wood, Pantry
  • Basement YN: Yes
  • Full Bathrooms: 3
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 839.0
  • Door Features: Storm Door(s)
  • Fireplace Features: In Living Room, Gas, In Family Room
  • Fireplace: Yes
  • Living Area: 2610.0
  • Window Features: Windows-Vinyl
  • Fireplace:Gas: Yes
  • Fireplace:In Family Room: Yes
  • 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:Microwave Oven: Yes
  • Kitchen Features Pantry: Yes
  • Fireplace:In Living Room: Yes
  • InteriorFeatures:Bar-Wet Bar: Yes
  • InteriorFeatures:Stand AloneShwrMBR: Yes
  • InteriorFeatures:TubBuilt In Jetted: Yes
  • InteriorFeatures:Utility Sink: Yes
  • InteriorFeatures:Window Treatmnts All: Yes
  • KitchenFeatures:Refrigerator: Yes
  • KitchenFeatures:Range-Electric: Yes
  • KitchenFeatures:Vent Fan: Yes
  • InteriorFeatures:Storm Door(s): Yes
  • InteriorFeatures:Dryer3: Yes
  • InteriorFeatures:Washing Machine2: Yes
  • KitchenFeatures:Counter-Laminate: Yes

Exterior Features

  • Builder Name: Herigon
  • Exterior Features: Driveway-Paved
  • Roof: ArchitecturalShingle
  • Direction Faces: North
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Concrete, Back, Deck
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Windows-Vinyl: Yes

Garage/Parking

  • Garage Spaces: 2.0
  • Parking Features: Garage Dr Opener(s), Attached
  • General Property Description:Garage Capacity: 2
  • InteriorFeatures:Garage Dr Opener(s): Yes

Utilities

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

Condo/Co-op/Association

  • Association Fee: 100.0
  • Association Fee Frequency: Annual
  • Association: Yes

Schools

  • Elementary School: Mary Paxton Keeley
  • Junior High Dist: Columbia
  • High School: Hickman
  • Middle Or Junior School: Smithton

Lot Info

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

Tax Info

  • Tax Annual Amount: 2877.6
  • Tax Year: 2024

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 13, 2025
Closed on
Jun 7, 2025
Sold by
Liu Ying-Hsiu
Bought by
Liu Bing and Zhou Xinyi
Seller's Agent
Steve Miller
REMAX Boone Realty
Buyer's Agent
Jennifer Zhang
REMAX Boone Realty
List Price
$425,000
Views
24
Current Estimated Value
$424,343

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-0.20%
Original Mortgage
$382,500
Outstanding Balance
$381,533
Interest Rate
6.89%
Mortgage Type
New Conventional
Estimated Equity
$42,810

Purchase Details

Listed on
May 26, 2016
Closed on
Jul 22, 2016
Sold by
Holstlaw William D and Holstlaw Shirley A
Bought by
Liu Ying Hsiu
Seller's Agent
Trisha Lee
REMAX Boone Realty
Buyer's Agent
Ling Bunch
Weichert, Realtors - House of Brokers
List Price
$274,900

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.54%
Original Mortgage
$209,600
Interest Rate
3.6%
Mortgage Type
New Conventional
Source: Public Records

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

Purchase History

Date Type Sale Price Title Company
Warranty Deed -- None Listed On Document
Warranty Deed -- None Listed On Document
Warranty Deed -- None Available
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $382,500 New Conventional
Closed $382,500 New Conventional
Previous Owner $209,600 New Conventional
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
07/09/2025 07/09/25 Sold -- -- --
05/16/2025 05/16/25 Pending -- -- --
05/13/2025 05/13/25 For Sale $425,000 +54.6% $163 / Sq Ft
07/22/2016 07/22/16 Sold -- -- -- View Prior Sale
06/15/2016 06/15/16 Pending -- -- --
05/26/2016 05/26/16 For Sale $274,900 -- $105 / Sq Ft
Source: Columbia Board of REALTORS®

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
2025 $3,199 $48,849 $7,182 $41,667
2024 $2,878 $42,655 $7,182 $35,473
2023 $2,854 $42,655 $7,182 $35,473
2022 $2,640 $39,501 $7,182 $32,319
2021 $2,645 $39,501 $7,182 $32,319
2020 $2,706 $37,979 $7,182 $30,797
2019 $2,706 $37,979 $7,182 $30,797
2018 $2,621 $0 $0 $0
2017 $2,589 $36,518 $7,182 $29,336
2016 $2,584 $36,518 $7,182 $29,336
2015 $2,373 $36,518 $7,182 $29,336
2014 $2,381 $36,518 $7,182 $29,336
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Columbia Board of REALTORS®

MLS Number: 427063

Columbia Board of REALTORS®

APN: 16-412-00-03-057-00-01

Your Personal Tour Guide

Ask me questions while you tour the home.