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 Price

4beds

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

Single Family

Home type

274.45

Price / sqft

2024

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

Square Feet
  • 3834

Bedrooms
  • 4

Bathrooms
  • 5

Heating
  • Has Heating:

    Yes

  • Heating Type:

    Heat Pump

Cooling
  • Has Cooling:

    Yes

  • Cooling Type:

    N/A

Fuel
  • Has Fuel:

    No

  • Fuel Type:

    N/A

Basement
  • Has Basement:

    No

  • Basement Type:

    N/A

Flooring
  • Has Flooring:

    No

  • Flooring Type:

    N/A

Fireplace
  • Has Fireplace:

    Yes

  • Fireplace Type:

    N/A

Property Details

Lot Size
  • 47045

Water
  • Yes

Sewer
  • Yes

Parking
  • Type:

    Garage, Attached

  • Location:

    N/A

  • Status:

    N/A

  • Number of Spaces:

    0

Deck
  • No

Patio
  • No

Fence
  • No

Pool
  • No

Porch
  • Yes

Stoop
  • No

Breezeway
  • No

Construction Details

Number of Stories
  • 2

Style
  • N/A

Exterior
  • N/A

Foundation
  • N/A

Roof
  • N/A

Roofing Material
  • N/A

Tax History

Year

Amount

Land

Improvement

Percent Change

Assessment

percent-home-icon

Average Home Price in 38401

Nearby Properties

Zip Code

Price

Bed

Bath

Sqft

Lot

Sold Date

$838,225

-- Beds

2.5 Baths

3,298 Sqft

48,352 Lot (sqft)

Sold 06/10/2026

$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

percent-home-icon

Calculators

Mortgage

Mortgage Calculator

Calculate your monthly mortgage payments.
Household Income
70,000
$
Home price
1,145,257
$
Down payment
229,051.40
$
Mortgage Rate
6.5
%
Loan Term
Property Tax Rate
1.1
%
Homeowner's Insurance (Annual)
6,871.54
$
HOA (Monthly)
0
$
PMI
0
$
$7,414
Your Payment
Total Monthly Payment:$7,414
Percent of Income:127%
Affordable:No

Details for 1506 FRYE RD

Property Debt

Foreclosure Contact Details

Similar Homes Nearby