CURRENTLY RENTED MONTH-TO-MONTH STARTING JULY 2026! If you love original character or you're looking for a sharp rental property close to downtown, this 3-bedroom, 1-bathroom home is packed with potential. The main floor features original hardwood floors that flow into a kitchen updated with custom oak countertops, open shelving, and modern fixtures. Upstairs, you'll find fresh flooring and a super versatile studio space that works perfectly as a bedroom, home office, or creative hangout. Enjoy the private, fully fenced backyard tucked under mature trees. Bring your tool belt and your vision since this cash-flowing opportunity awaits its next owner.
Est. $1,174 per month, based on comparable rentals
Sale and tax history for 509 N Providence Rd
Sale History
Tax History
Date
Event
Price
Public Records
Jul 16, 2026
Sold
—
CBORMLS #432380
Jul 19, 2026
Delisted
—
Jul 16, 2026
Sold
—
Jul 8, 2026
Pending
—
Jul 5, 2026
Price Changed
$132,815
$110/sq ft
Jun 29, 2026
Price Changed
$134,815
$112/sq ft
Feb 19, 2026
Listed
$137,815
$114/sq ft
CURRENTLY RENTED MONTH-TO-MONTH STARTING JULY 2026! If you love original character or you're looking for a sharp rental property close to downtown, this 3-bedroom, 1-bathroom home is packed with potential. The main floor features original hardwood floors that flow into a kitchen updated with custom oak countertops, open shelving, and modern fixtures. Upstairs, you'll find fresh flooring and a super versatile studio space that works perfectly as a bedroom, home office, or creative hangout. Enjoy the private, fully fenced backyard tucked under mature trees. Bring your tool belt and your vision since this cash-flowing opportunity awaits its next owner.
CBORMLS #432383
Jul 17, 2026
Delisted
—
Jul 16, 2026
Sold
—
Jul 8, 2026
Pending
—
Jul 5, 2026
Price Changed
$132,815
$110/sq ft
Jun 29, 2026
Price Changed
$134,815
$112/sq ft
Feb 19, 2026
Listed
$137,815
$114/sq ft
CBORMLS #391784
Dec 14, 2020
Sold
—
Nov 13, 2020
Listed
$86,200
$72/sq ft
This 3 bedroom, 1 bathroom home offers real wood floors on the main with a dry and usable unfinished basement and centrally located to everything Columbia. Upgraded kitchen boasting custom oak countertops and shelves plus modern fixtures. Take advantage of the upper level bedroom and the roomy back porch with dual ways to get to the basement. Covered front porch with a secluded backyard under mature trees and a private setting.
CBORMLS #117812
Jun 17, 2005
Sold
—
Feb 8, 2005
Listed
$59,900
$50/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$913 (+11.2%)
$2,128 + $11,818
$13,946
2024
$822 (+0.8%)
$2,128 + $11,818
$13,946
2023
$815 (+12.2%)
$2,128 + $10,051
$12,179
2022
$726 (−0.2%)
$2,128 + $10,051
$12,179
2021
$728 (+5.2%)
$2,128 + $8,740
$10,868
2020
$692
$2,128 + $8,740
$10,868
2019
$692 (+7.2%)
$2,128 + $7,577
$9,705
2018
$645 (+1.2%)
$2,128 + $7,577
$9,705
2017
$637 (−2.4%)
$2,128 + $6,859
$8,987
2016
$653 (+8.3%)
$2,128 + $6,859
$8,987
2015
$603 (−0.5%)
$2,128 + $6,859
$8,987
2014
$606
$2,128 + $6,859
$8,987
Public record
Public record
Zoning
Beds
3
Baths
1
Stories
1
Lot width
48 ft.
Lot depth
122 ft.
Lot size
5,856 Sq. Ft.
Year renovated
—
Sq. Ft.
1,019
Year built
1935
Style
Single Family Residential
County
Boone County
APN
1631500160330001
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 9, 2026.
R-2
Two-Family Dwelling District
This district is intended to provide for a blend of one-and two-family residential developments that will promote strong neighborhoods. The district is intended to accommodate both standard residential development and small pockets of affordable small lot infill cottage residential development. The cottage standards require approval by the board of adjustment pursuant to section 29-6.4(j). The principal land use is one-family or duplex residential dwellings, as shown in Table 29-3.1 (Permitted Use Table). One principal structure is allowed per lot; two or more single-family detached dwellings are not permitted on a single lot.
Fencing: Back Yard, Partial, Wire, Chain Link, Wood
Building Information
Direction Faces: East
Sq. Ft.: 1205.0
Builder Name: UNKNOWN
Construction Materials: Aluminum Siding, Brick Veneer, Wood Siding
Foundation Details: Block, Brick/Mortar
Property Features
Security Features: Smoke Detector(s)
Other Structures: None
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Raw Mls Property Sub Type: Single Family Residence
Lot Information
Road Surface Type: Paved
Lot Size Dimensions: 48 x 122
Zoning: Single Family Res
Zoning Description: R-2 Two- Family Dwelling*
Financial
Tax Information
Tax Annual Amount: $913.24
Utilities
Utility Information
Water Source: Public
Utilities: Cable Available, Electricity Available, Natural Gas Available
Location
Schools Information
Elementary School: Benton
Middle Or Junior School: Jefferson
High School District: Columbia
High School: Hickman
Location Information
Directions: GOOGLE.COM/MAPS *OR* HOME SITS 5 HOMES NORTHWEST OF THE INTERSECTION OF N PROVIDENCE RD & E WORLEY ST. TWO HOMES SOUTH OF HICKMAN AVE ON THE WEST SIDE OF N PROVIDENCE RD.
Subdivision Name: WOODLAWN
Cross Street: HICKMAN
Public facts
Beds: 3
Baths: 1.0
Sq. Ft.: 1,019
Stories: 1.0
Lot Size: 5,856 square feet
Style: Single Family Residential
Year Built: 1935
Year Renovated: —
County: Boone County
APN: 1631500160330001
Home facts updated by county records on Sep 9, 2026
Other
Listing Information
List AOR: Columbia Board of REALTORS®
Around this home
Schools
Thomas Benton Elementary School
Public PreK-5 • Assigned • 0.8mi
8/10
Jefferson Jr. High School
Public 6-8 • Assigned • 0.3mi
9/10
David H. Hickman High School
Public 9-12 • Assigned • 0.3mi
7/10
Provided by GreatSchools
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
4/10 Heat Factor
7 days above 108° expected this year, 19 days in 30 years
2/10 Wind Factor
Minor risk of severe winds over next 30 years
1/10 Air Factor
0 unhealthy days expected this year, 0 days in 30 years
Provided by First Street
Historical weather
Columbia, MO • 65203
Average low and high temperatures (°F)
37
19
48
27
66
41
70
51
75
55
84
67
88
72
86
65
83
60
73
51
56
39
46
29
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
95/ 100
Exceptional sunlight
Sunscore
This home receives average direct sun exposure in Columbia. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
9.5 hrs
6.1 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$147,000 – $178,000
Sell confidently with a local market expert in Columbia.