Skip to content
Skip to content
TopHapOpen in map
Single Family ResidenceResidential
$189,338$218 / ft²
TopHap EstimateOur estimate of what this home would sell for today, based on nearby sales, the home's size and features, and local price trends. It is a starting point, not an appraisal.· confidence 95How well the pricing models agreed with each other on this home. Higher means the estimate rests on stronger, more consistent data.· as of Jul 14, 2026
Last sold for $168,000 on Sep 16, 2022

87 ROSE DR

COLUMBIA, SC 29205
2
Beds
2
Baths
868 ft²
Living AreaTotal finished area of the structures, from county records. Some counties include shared space like hallways or a building gym, so it may not match a listing.
0.18 ac
Lot SizeThe size of the land the home sits on, from county records.
1954
Year BuiltThe year the home was originally built, according to county records.
1
StoriesHow many floors the home has above ground.

Valuation

$189K
$181K low$198K high
Last SaleThe most recent sale price and date from the recorded deed. Transfers between family members or companies may not reflect market value.$168,000 · Sep 16, 2022
Est. Owner EquityRoughly how much of the home's value the owner would keep after paying off known loans. It is our estimate minus the loans still owed.$29,738
Est. Lendable EquityThe part of the owner's equity a lender would typically let them borrow against — about 80% of their equity.$23,790
Loan-to-ValueHow much is still owed on the home compared to what it is worth. 80% means loans equal 80% of our estimate, so it shifts when the estimate does.87%
1st MortgageA loan still believed to be open on this home, in the order lenders get repaid. The first position is paid back before the second.$159,600
MOVEMENT MORTGAGE · recorded Sep 16, 2022

Tax & Assessment

Property TaxThe property tax billed for this tax year. It usually pays for schools, roads, and local services.$801 (2025)
Assessed ValueThe value the county assigns to this home to calculate property tax. It is often lower than what the home would sell for.$1,508 (2025)
Previous AssessedThe county's assessed value from the year before, useful for seeing how the assessment changed.$111,900
Assessor Market ValueThe county assessor's own opinion of market value. It is separate from our estimate and updates on the county's schedule.$111,900

Climate Risk

Overall riskThe average of the five hazard scores below, on a 0 to 100 scale. Higher means greater projected risk over the coming decades.38
1
FloodProjected flooding risk from rivers, heavy rain, and storm surge, scored 0 to 100. Higher is riskier.
8
WildfireProjected wildfire risk, scored 0 to 100, based on how much land burns in a typical year. Higher is riskier.
89
HeatProjected heat risk, scored 0 to 100, based on how many extremely hot days a year are expected. Higher is riskier.
76
StormProjected risk from heavy rainstorms, scored 0 to 100, based on how often extreme rainfall is expected. Higher is riskier.
20
DroughtProjected water shortage risk, scored 0 to 100. Higher means more strain on the local water supply.

Scores 0–100; higher = greater projected risk.

Property Facts

Property TypeThe broad category the county puts this property in, such as residential or commercial.Single Family Residence
StyleThe architectural style of the home, such as ranch or colonial.Raised Ranch
CountyRICHLAND
Effective Year BuiltAn adjusted build year that accounts for condition and major remodels. A big renovation can make a home count as newer than it is.1995
Lot (acres)The size of the land the home sits on, from county records.0.18
ConstructionThe main material the home's frame and walls are built from.Frame (Unspecified)
FoundationWhat the home is built on, such as a concrete slab, a crawl space, or a basement.No Foundation
RoofThe main material covering the roof, such as asphalt shingle or tile.Composition Shingle
HeatingThe type of heating system in the home.Forced Air With Air Conditioning
CoolingThe type of cooling or air conditioning in the home.Central
PoolWhether the property has a pool, and what kind, such as in-ground.No
FeaturesExtra features found in county records. Records are not complete everywhere, so a missing feature does not always mean the home lacks it.Porch · 78 ft²

Transaction History(4)

Sales and refinances filed with the county for this home. Not every transfer is a normal sale, so check the type before comparing prices.

Assigned SchoolsThe public schools this address is zoned for. Boundaries change, so confirm with the district before you count on it.

E
Rosewood Elementary SchoolC
Elementary · Grades KG–5 · 1.0 mi
M
Hand Middle SchoolC+
Middle · Grades 6–8 · 1.6 mi
H
Dreher High SchoolB+
High · Grades 9–12 · 1.8 mi

District: Richland School District 1

Neighborhood · ZIP 29205These are comparison scores, not percentages. 100 equals the national average, so 150 means about 50% above average.

CrimeLocal crime compared with the rest of the country, where 100 is average. It reflects things like population density, income, and how crime gets reported.135
Air pollutionOverall air pollution compared with the rest of the country, where 100 is average. Lower is cleaner.85
EarthquakeEarthquake risk and likely building damage compared with the rest of the country, where 100 is average. Scores can run far above 100.151

Index scale: 100 = US average (tick). Lower is better.

Homes occupiedThe share of homes here that someone lives in. The rest sit empty, including vacation and for-sale homes.88%
Bachelor's or higherThe share of adults 25 and older whose highest degree is a bachelor's degree.31%
Poverty rateThe share of people whose household income falls below the federal poverty line, which varies by family size.19%
UnemploymentThe share of men 16 and older who are out of work and actively looking. Only men are counted in this figure.1.3%
PopulationHow many people live in this area.24,484
DensityPeople per square mile. Higher numbers mean a more crowded, urban area.3,785 / mi²
Median incomeThe middle household income here — half of households earn more, half earn less.$79,825
Average incomeThe average household income. It runs higher than the median when a few high earners pull it up.$107,282
Average tempThe average temperature here across a full year.64°F
Annual precipHow much rain and melted snow falls here in a typical year.48 in
SunshineThe share of daylight hours that get direct sun in a typical year, counting cloud cover.64%

Ownership

OccupancyWhether the owner appears to live here or somewhere else. It is inferred from the mailing address on record.Owner occupied
Company ownedWhether the owner is a company or trust rather than a person.No

Data by ATTOM. Valuations are automated estimates, not appraisals. Photos from Google Street View and may not depict the current property state.

How this home compares

87 Rose Dr measured against every home in its neighborhood, its ZIP code and its county, using county assessor records refreshed nightly. A home can stand out in one of those areas and look ordinary in another, because each one holds a different mix of homes.

  • Worth less than 77% of homes in Columbia 29205
  • Costs more per square foot than 90% of homes in Richland County
  • Smaller than 96% of homes in Richland County
  • Has a smaller lot than 78% of homes in Richland County
  • Older than 86% of homes in Richland County

What homes are worth in Columbia 29205

Each bar is how many homes fall in that price range. The marker is this home.

This home
$60K$1.2M

This home is worth more than 23% of homes in Columbia 29205.

How it measures up in Columbia 29205

The dot is this home. The mark in the middle is the typical home in Columbia 29205.

Estimated value$189,338
CheaperTypical $320,915Pricier

Pricier than 23% of homes nearby

Price per ft²$218
CheaperTypical $216Pricier

Pricier than 52% of homes nearby

Living area868 ft²
SmallerTypical 1,773 ft²Bigger

Bigger than 8% of homes nearby

Lot size0.18 ac
SmallerTypical 0.22 acBigger

Bigger than 32% of homes nearby

Year built1954
OlderTypical 1949Newer

Newer than 65% of homes nearby

How 87 Rose Dr ranks against every home in each area.
MeasureThis homeColumbia 29205Richland County
Estimated valuepricier than$189,33823% of homes30% of homes
Price per ft²pricier than$21852% of homes90% of homes
Living areabigger than868 ft²8% of homes4% of homes
Lot sizebigger than0.18 ac32% of homes22% of homes
Year builtnewer than195465% of homes14% of homes

About 87 Rose Dr

How much is 87 Rose Dr, Columbia, SC worth?

The TopHap Estimate for 87 Rose Dr, Columbia, SC is $189,338 as of Jul 14, 2026. The likely range is $180,798 to $197,878. The estimate is modelled from recorded sales, assessments and the property's own characteristics — it is not an appraisal.

When did 87 Rose Dr, Columbia, SC last sell?

87 Rose Dr, Columbia, SC last sold on Sep 16, 2022 for $168,000, according to the county's recorded deed. TopHap holds 3 recorded sales for this parcel.

How big is 87 Rose Dr, Columbia, SC?

87 Rose Dr, Columbia, SC has 2 bedrooms, 2 bathrooms, 868 square feet of living space and a 0.18-acre lot.

When was 87 Rose Dr, Columbia, SC built?

87 Rose Dr, Columbia, SC was built in 1954, making it 72 years old. It is a raised ranch home. The building has 1 story.

What schools serve 87 Rose Dr, Columbia, SC?

87 Rose Dr, Columbia, SC is assigned to Rosewood Elementary School (elementary), rated C; Hand Middle School (middle), rated C+; Dreher High School (high), rated B+. All sit in Richland School District 1. Attendance boundaries change — confirm with the district before relying on an assignment.

How does 87 Rose Dr, Columbia, SC compare to other homes in Columbia 29205?

Among the 9,910 homes in Columbia 29205, it is worth more than 23% of them ($189,338 against a typical $320,915), its price per square foot is higher than 52% of them ($218 against a typical $216), it is bigger than 8% of them (868 ft² against a typical 1,773 ft²), its lot is bigger than 32% of them (0.18 ac against a typical 0.22 ac) and it is newer than 65% of them (1954 against a typical 1949). Measured against all of Richland County, it is worth more than 30% of homes there. These shares are recounted nightly from the full county assessor record for each area, not from active listings.

What are the property taxes on 87 Rose Dr, Columbia, SC?

The 2025 property tax bill for 87 Rose Dr, Columbia, SC was $801. The county assessed it at $1,508.

Closest homes

More homes in Columbia 29205

Assigned schools

Explore the area

See this home in context

Open 87 Rose Dr on TopHap’s interactive map to compare it against every sale nearby, overlay school zones and flood risk, and run a CMA.

Open in map
A flyover of TopHap's photorealistic 3D map, with recorded sale prices pinned to homes
Search any address, city, zip, or county…3D$1.9M$6.25MOpen in map