It's in the top 10% of views. Tour it before it's gone!
Today:
About this home
Totally renovated and move-in ready in New Friarsgate! This beautifully updated three-bedroom, two-bath home offers a fresh, modern feel throughout. Originally designed with one and a half baths, the owner has thoughtfully converted the home to provide two full bathrooms. Fresh interior paint, new LVP flooring, updated fixtures, ceiling fans, and new kitchen appliances add to the home's appeal. Enjoy plenty of outdoor space with a large deck overlooking the huge backyard, perfect for relaxing, entertaining, or enjoying the outdoors. A fantastic opportunity to own a completely refreshed home in a desirable New Friarsgate location! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
Northwest Columbia, located between the Broad River and I-20, is a residential and river-adjacent Columbia neighborhood with wooded streets and a patchwork of mid-century ranches and newer infill. The neighborhood’s character concentrates around the River Drive corridor by the Broad River, where trailheads, boat landings, and river views set an outdoors-forward rhythm. Harbison State Forest frames the area with long, shaded paths and a quiet canopy. Riverbanks Zoo and Garden adds a cultural anchor with landscaped grounds and year-round programming. Broad River Greenway ties pockets together with boardwalks and overlooks. Daily life leans toward porches, backyards, and time outdoors rather than a dense main street.
Provided by Walk Score and Local Logic
Market insights
204 River Song Rd · $225,000
DAYS ON MARKET
1 days
The average home goes pending in 46 days.
SALE-TO-LIST
98.3%
Most homes are selling 2% below list price.
LIST PRICE
$225,000
Median sale price in this area is $284,068. (26% higher than this home)
PRICE DROP
1 price drop
28% of homes in this area have had a price drop in the past month.
Property details
Interior
Exterior
Finance
Kitchen
Bathroom
Bedroom
Living
Interior features
Masonry fireplace
Free-standing smooth-surface range
Bedrooms
Master bedroom on main level with private bath, private closet, and luxury vinyl plank floors
Bedroom 2 on main level with shared bath, private closet, and luxury vinyl plank floors
Bedroom 3 on main level with private and shared bath(s) and luxury vinyl plank floors
Bathrooms
Two full bathrooms
Kitchen
Tile floor
Dishwasher
Refrigerator
Laundry & utility
Laundry in closet on main level
Flooring
Luxury vinyl plank in bedrooms, living room, and formal dining room
Tile flooring in kitchen
Heating & cooling
Central heating
Central cooling
Exterior features
Deck
Paved road access
Public water
Home design
Single-story
Vinyl exterior finish
Construction
Crawlspace foundation
Utilities
Public sewer
Public water
Electricity and solar
View estimated energy costs and solar savings for this home
The RS district is intended to foster, preserve, and protect areas of the community in which the principal use of land is for detached, single-family dwellings, and certain residential support facilities at low densities.
Permitted uses
Include but are not limited to:
Housing-Single unit
Educational/school
Library
Post office
Park & open space
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
6/10 Heat Factor
7 days above 108° expected this year, 16 days in 30 years
6/10 Wind Factor
63% chance of strong winds in next 30 years
3/10 Air Factor
3 unhealthy days expected this year, 3 days in 30 years
Provided by First Street
Historical weather
Irmo, SC • 29063
Average low and high temperatures (°F)
53
33
60
40
72
48
79
56
80
62
89
70
91
75
83
70
84
64
74
54
68
47
57
38
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
97/ 100
Exceptional sunlight
Sunscore
This home ranks in the top 20% for direct sun exposure in Irmo. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
8.8 hrs
6.1 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 204 River Song Rd
$234,240
$9,240 over list price of $225K
More resources
Rental earnings
Est. $1,690 per month, based on comparable rentals
Tour for free, no strings attached
Make a winning offer with the help of a local agent