
Member Features
Find Real Estate Bargain!
Full foreclosure details
Home value, equity and ownership info
Find homes priced below market
Get full access with a FREE Account
Already a member?
$1,145,257
Listing Price4beds
5baths
3,834sqft
47,045sqft lot
1506 Frye Rd, Columbia, TN 38401
Member Features
Find Real Estate Bargain!
Full foreclosure details
Home value, equity and ownership info
Find homes priced below market
Get full access with a FREE Account
Already a member?
For Sale
Off Market
Home type
Price / sqft
Year built
Home Details
The HOLLIS...TRUE SOUTHERN LIVING at it's finest! Secluded on 1.8 Acres & conveniently located less than 4 mi to SH Crossings for restaurants & retail! Your Front Veranda will be the hot spot while hosting as French Doors open to Formal DR! Fabulous OPEN 1st FLOOR DESIGN & the 9.5' Island draws in the crowd! Chef's Kitchen boasts Gas Cooktop, Wall-Oven/Microwave & 2 PANTRIES! One of them an Ole-South SCULLERY! Gorgeous Hardwoods, Stained Kit Cabs w/ brush-gold hardware w/ QUARTZ through-out the house! Main-Floor Primary is a retreat in itself with it's massive size, and the Wall-2-Wall Windows offering a peaceful & private view. Showstopping Bath boasts a 6x6 Tiled Shower, FREESTANDING TUB, Sep Vanities & W-I-C w/ Custom Built-Ins covering your storage needs! Upstairs find a HUGE PRINCESS ENSUITE, BR 3 Ensuite, and BR 4 just off the Oversized Bonus Rm! Secluded Covered Porch & Treed backyard view begs for fall gatherings! Oh.. can't forget about the DOG WASHING STATION!
Interior Details
3834
4
5
Has Heating:
Yes
Heating Type:
Heat Pump
Has Cooling:
Yes
Cooling Type:
N/A
Has Fuel:
No
Fuel Type:
N/A
Has Basement:
No
Basement Type:
N/A
Has Flooring:
No
Flooring Type:
N/A
Has Fireplace:
Yes
Fireplace Type:
N/A
Property Details
47045
Yes
Yes
Type:
Garage, Attached
Location:
N/A
Status:
N/A
Number of Spaces:
0
No
No
No
No
Yes
No
No
Construction Details
N/A
N/A
N/A
N/A
N/A
Tax History
Year
Amount
Land
Improvement
Percent Change
Assessment
Average Home Price in 38401
Nearby Properties
Zip Code
Price
Bed
Bath
Sqft
Lot
Sold Date
$838,225
$838,225
-- Beds
2.5 Baths
3,298 Sqft
48,352 Lot (sqft)
Sold 06/10/2026
$1,145,257
$1,145,257
4 Beds
5 Baths
3,834 Sqft
47,045 Lot (sqft)
Sold 09/29/2026
$649,990
-- Beds
3.5 Baths
3,359 Sqft
6,625 Lot (sqft)
Sold 10/05/2026



