71% of homes accept an offer within a week. Tour it before it's gone!
Today:
About this home
~RATES AS LOW AS 4.99% AVAILABLE MUST QUALIFY AND USE SELLER''S LENDER NEW CONSTRUCTION in Ooltewah, TN -- Nestled in the beautiful community of Farms at Creekside, Pratt Home Builders presents to you the coveted New Haven home plan. Welcome home to one of the newest home plans designed by Pratt Home Buiilders: The New Haven. This classic yet timeless home plan is designed for multi-generational living with intentional features and layout choices to make it last. Walking in the front door, you'll enter in the foyer where you'll be able to use the dedicated study and across from that will be the two guest bedrooms that share a full bathroom. Continuing down the hall past the staircase, imagine the awesome entertaining you'll be doing in this grand, open-concept great room with your dining area and over-sized kitchen. From here you can walk out to your cozy patio to enjoy your morning coffee, or enter your master bedroom with a huge walk-in closet. This home plan also features a drop zone between the garage and great room where you can leave your muddy shoes and access your laundry room as well. Space to organize everyone's items is definitely a priority with this design! Lastly, when you head upstairs, you'll appreciate the bonus space, study area , extra bedroom and full bathroom with a walk out attic space as well! The New Haven is designed with growth in mind.
~RATES AS LOW AS 4.99% AVAILABLE MUST QUALIFY AND USE SELLER''S LENDER NEW CONSTRUCTION in Ooltewah, TN -- Nestled in the beautiful community of Farms at Creekside, Pratt Home Builders presents to you the coveted New Haven home plan. Welcome home to one of the newest home plans designed by Pratt Home Buiilders: The New Haven. This classic yet timeless home plan is designed for multi-generational living with intentional features and layout choices to make it last. Walking in the front door, you'll enter in the foyer where you'll be able to use the dedicated study and across from that will be the two guest bedrooms that share a full bathroom. Continuing down the hall past the staircase, imagine the awesome entertaining you'll be doing in this grand, open-concept great room with your dining area and over-sized kitchen. From here you can walk out to your cozy patio to enjoy your morning coffee, or enter your master bedroom with a huge walk-in closet. This home plan also features a drop zone between the garage and great room where you can leave your muddy shoes and access your laundry room as well. Space to organize everyone's items is definitely a priority with this design! Lastly, when you head upstairs, you'll appreciate the bonus space, study area , extra bedroom and full bathroom with a walk out attic space as well! The New Haven is designed with growth in mind.
REALTRACS as Distributed by MLS Grid #3276633
Jul 10, 2026
Listed
$640,000
$204/sq ft
As the MLS and public records start to fill up, we'll list the details here.
Public record
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Finished Sq. Ft.
—
Unfinished Sq. Ft.
—
Total Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Hamilton County
APN
160c K 021
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 17, 2026.
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 103° expected this year, 19 days in 30 years
4/10 Wind Factor
10% chance of strong winds in next 30 years
3/10 Air Factor
2 unhealthy days expected this year, 2 days in 30 years
Provided by First Street
Historical weather
Collegedale, TN • 37363
Average low and high temperatures (°F)
48
29
58
37
70
46
76
55
77
60
86
68
91
72
85
67
83
64
74
52
64
44
54
35
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
87/ 100
Very good sunlight
Sunscore
This home receives average direct sun exposure in Collegedale. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
9.4 hrs
5.9 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 9851 Mayfly Rd #86
We cannot show automated home-value estimates for this home.
Nearby homes have recently sold between $510,000 and $685,000.
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $510K to $685K.