OFF MARKET

Off market sep 2006 for $792K

—

Est. refi paymentEst. refi $5,423/mo

160

•

64 ba

•

80,796

sq ft

4020 Ulmer Rd, Columbia, SC 29209

About this home

4020 Ulmer Rd is a 80,796 square foot multi-family home on a 6.88 acre lot with 160 bedrooms and 64 bathrooms. - it last sold on September 15, 2006 for $792,000.

Multi-familyProperty Type

2007Year Built

6.88 acresLot Size

$10Price/Sq.Ft.

Source:Public Records

Redfin Estimate

There isn’t enough information to generate an accurate estimate at this time. Learn More

Market trends in 29209, SC

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

97.2%

+0.2% MoM

Median sale price

$261K

$8K MoM

Avg. days on market

47d

5 days MoM

Recently sold homes

158

3 MoM

New listings for sale

OPEN SUN, 1PM TO 3PM
$296,400
4 beds2.5 baths2,394 sq ft
740 Applegate Ln, Columbia, SC 29209
OPEN THU, 4:30PM TO 6PM
$469,900
4 beds2.5 baths2,300 sq ft
117 Chimney Hill Rd, Columbia, SC 29209
NEW 8 HRS AGO
$139,900
3 beds2 baths1,599 sq ft
2112 Atlas Rd, Columbia, SC 29209
NEW 17 HRS AGO
$279,000
5 beds2.5 baths2,200 sq ft
3057 Blue Brook Ln, Columbia, SC 29209
NEW 30 HRS AGO
$167,900
2 beds2 baths1,040 sq ft
55 Monmouth Ct, Columbia, SC 29209
$190,000
2 beds2.5 baths1,183 sq ft
847 Forest Park Rd, Columbia, SC 29209
$154,900
3 beds1.5 baths1,075 sq ft
3724 Anwood Dr, Columbia, SC 29209
3D WALKTHROUGH
$176,000
1 bed1 bath569 sq ft
1005 Brandon Ave, Columbia, SC 29209
$238,000
3 beds2 baths1,548 sq ft
931 Cedar Ter, Columbia, SC 29209
$184,900
Studio— baths1 sq ft
6109 Fitzgibbon Dr, Columbia, SC 29209
See all

Provided by Redfin

Sale history for 4020 Ulmer Rd

Year

Property tax

Land + Additions

Assessment*

2025

$80,872 (+2.1%)

2024

$79,228 (−13.1%)

2023

$91,196 (−0.8%)

$264,000 + $2,913,600

$3,177,600

2022

$91,886 (−0.8%)

$264,000 + $2,913,600

$3,177,600

2021

$92,629 (−1.4%)

$275,200 + $2,902,400

$3,177,600

2020

$93,945 (−0.3%)

$275,200 + $2,902,400

$3,177,600

2019

$94,199 (+13.6%)

$275,200 + $2,902,400

$3,177,600

2018

$82,909 (+2.8%)

$275,200 + $2,487,900

$2,763,100

2017

$80,635 (+2.8%)

$275,200 + $2,487,900

$2,763,100

2016

$78,410 (+1.5%)

$275,200 + $2,487,900

$2,763,100

2014

$77,245 (+16.9%)

$275,200 + $2,487,900

$2,763,100

2013

$66,094

$16,510 + $127,650

$144,160

Tax history for 4020 Ulmer Rd

Year

Property tax

Land + Additions

Assessment*

2025

$80,872 (+2.1%)

2024

$79,228 (−13.1%)

2023

$91,196 (−0.8%)

$264,000 + $2,913,600

$3,177,600

2022

$91,886 (−0.8%)

$264,000 + $2,913,600

$3,177,600

2021

$92,629 (−1.4%)

$275,200 + $2,902,400

$3,177,600

2020

$93,945 (−0.3%)

$275,200 + $2,902,400

$3,177,600

2019

$94,199 (+13.6%)

$275,200 + $2,902,400

$3,177,600

2018

$82,909 (+2.8%)

$275,200 + $2,487,900

$2,763,100

2017

$80,635 (+2.8%)

$275,200 + $2,487,900

$2,763,100

2016

$78,410 (+1.5%)

$275,200 + $2,487,900

$2,763,100

2014

$77,245 (+16.9%)

$275,200 + $2,487,900

$2,763,100

2013

$66,094

$16,510 + $127,650

$144,160

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Zoning and permits

Zoning
Permits

MU-2

Mixed-Use District

The purpose of the Mixed-Use (MU-2) District is to provide lands that accommodate medium-density, walkable mixed-use development in a gridded street pattern. Allowed uses include singlefamily, two-family, townhouse, and multi-family development, as well as a moderate range of neighborhood-serving mixeduse, retail, office, and personal services development.

Permitted uses

Include but are not limited to:

Community / recreation center
Bank
General retail
Retail-Grocery
Housing-Single unit
Housing-Multiple units
Manufacturing
Mixed use
Office
Medical office

Property details

Interior

Heating & Cooling
Air Conditioning Type: Central
Heating Type: Forced Air

Exterior

Exterior Information
Foundation Type: Slab
Building Style Type: Conventional
Exterior Wall: Frame/Shingle Siding
Roof Framing Type: Wood
Roof Shape Type: Gable/Hip

Property Information
Subdivision Name: MADISON STATION
Living Sq. Ft: 80,796
Building Sq. Ft: 84,212
# of Stories: 3
Legal Description: TRACT 2 220.6X173.7X367X416.5X458.9XET #SU MADISON STATION APTS #PR D-2 52-328 RB1090-718

Lot Information
# of Buildings: 1
Land Sq. Ft: 299,693
Municipality Name: CITY COLUMBIA
Acres: 6.88
Zoning Code: MU-2
County Use Description: MULTIPLE UNIT

Utility Information
Sewer Type: Septic
Water Service Type: Private

Financial

Assessor Information
Assessment Year: 2025

Public facts

Beds: 160
Baths: 64.0
Sq. Ft.: 80,796
Stories: 3.0
Lot Size: 6.88 acres
Style: Multi-Family (5+ Unit)
Year Built: 2007
Year Renovated: 2007
County: Richland County
APN: 192160601

Home facts updated by county records on Aug 10, 2026

Around this home

Schools

Caughman Road Elementary School

Public PreK-5 • Assigned • 1.3mi

2/10

Hopkins Middle School

Public 6-8 • Assigned • 7.2mi

3/10

Lower Richland High School

Public 9-12 • Assigned • 2.8mi

2/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

2/10 Fire Factor

0.77% chance of being in a wildfire in next 30 years

7/10 Heat Factor

7 hot days expected this year, 16 days in 30 years

Wind Factor

We're working on getting current and accurate wind risk information for this home.

Air Factor

We're working on getting current and accurate air risk information for this home.

Provided by First Street

Historical weather

Columbia, SC • 29209

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 9.2 hours in June and 5.5 hours in December, placing it above the U.S. average for solar exposure.

9.2 hrs

5.5 hrs

JuneDecember

Provided by Shadowmap

Is this your home?

Track this home’s value and nearby sales activity

Nearby similar homes

$300,000

12 beds8 baths4,650 sq ft

2081 Highway 178, Swansea, SC 29160

$598,000

10 beds10 baths5,040 sq ft

136 Dowdy St, Eastover, SC 29044

$275,000

13 beds12 baths10,686 sq ft

1054 Edgewater Rd, Pineville, SC 29468

$699,000

10 beds7 baths4,225 sq ft

2620 Main St, Columbia, SC 29201

$795,000

3 beds3 baths— sq ft

913 Prestwood Dr, Hartsville, SC 29550

$59,000

3 beds2 baths924 sq ft

303 Crane Creek Dr, Columbia, SC 29203

New listings for sale in 29209

OPEN SUN, 1PM TO 3PM3D WALKTHROUGH

$296,400

4 beds2.5 baths2,394 sq ft

740 Applegate Ln, Columbia, SC 29209

OPEN THU, 4:30PM TO 6PM

$469,900

4 beds2.5 baths2,300 sq ft

117 Chimney Hill Rd, Columbia, SC 29209

NEW 8 HRS AGO

$139,900

3 beds2 baths1,599 sq ft

2112 Atlas Rd, Columbia, SC 29209

NEW 17 HRS AGO

$279,000

5 beds2.5 baths2,200 sq ft

3057 Blue Brook Ln, Columbia, SC 29209

NEW 30 HRS AGO

$167,900

2 beds2 baths1,040 sq ft

55 Monmouth Ct, Columbia, SC 29209

$190,000

2 beds2.5 baths1,183 sq ft

847 Forest Park Rd, Columbia, SC 29209

$154,900

3 beds1.5 baths1,075 sq ft

3724 Anwood Dr, Columbia, SC 29209

3D WALKTHROUGH

$176,000

1 bed1 bath569 sq ft

1005 Brandon Ave, Columbia, SC 29209

$238,000

3 beds2 baths1,548 sq ft

931 Cedar Ter, Columbia, SC 29209

Home values near 4020 Ulmer Rd

Data from public records.

Address	Redfin Estimate
4001 Ulmer Road, Columbia, SC 4 Beds \| 2 Baths \| 1711 Sq. Ft.	$266,961
4017 Ulmer Road, Columbia, SC 4 Beds \| 2 Baths \| 2020 Sq. Ft.	$243,038

Address	Redfin Estimate
4022 Ulmer Road, Columbia, SC 120 Beds \| 72 Baths \| 60128 Sq. Ft.	—
4007 Ulmer Road, Columbia, SC 4 Beds \| 2 Baths \| 1966 Sq. Ft.	$285,796

Address	Redfin Estimate
4013 Ulmer Road, Columbia, SC 3 Beds \| 2 Baths \| 1664 Sq. Ft.	$267,301
4009 Ulmer Road, Columbia, SC 4 Beds \| 3 Baths \| 1923 Sq. Ft.	$292,050

Property information provided by undefined .

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

29016 homes for sale
29203 homes for sale
29223 homes for sale
29229 homes for sale
29212 homes for sale

Houses for rent in Columbia	Agents near me	Columbia, SC homes for sale	Columbia Housing Market
Houses for sale near me	Charleston, SC homes for sale	Summerville, SC homes for sale
Land for sale near me	Greenville, SC homes for sale	Fort Mill, SC homes for sale
Open Houses near me	Myrtle Beach, SC homes for sale	Columbia Property Records
Condos for sale near me	Mount Pleasant, SC homes for sale	SC New Listings

Blythewood homes for sale
Irmo homes for sale
Lexington homes for sale

About this home

Redfin Estimate

Market trends in 29209, SC

Sale history for 4020 Ulmer Rd

Tax history for 4020 Ulmer Rd

Zoning and permits

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Is this your home?

Nearby similar homes

New listings for sale in 29209

Home values near 4020 Ulmer Rd

More real estate resources