73% of homes accept an offer within a week. Tour it before it's gone!
Today:
About this home
NEW CONSTRUCTION in Ooltewah, Tennessee - This charming new home is situated in the stunning Farms at Creekside community. Enjoy a picturesque stroll through the community situated at the base of White Oak Mountain, plenty of tree privacy and green spaces. More than just a home, the Waterford home design is a haven. Room for everyone, everything, and every activity. The large Kitchen boasts a Butler's Pantry that makes entertaining in the Formal Dining Room a breeze. The kitchen also features an elegant backsplash, Quartz countertops, soft close cabinets, gas cooktop and sleek wall oven. The first floor Main Bedroom features a huge walk-in-closet and en suite full bath with double vanity and fully-tiled shower. Additionally, there is a dedicated Study at the front of the home for late-night work sessions or storing hobby materials. A useful drop zone is great for storing back-packs, briefcases or sports equipment on the bench with shoe cubbies and hooks. The laundry room features a laundry sink, cabinets and a granite top perfect for those pesky laundry duties. Venture upstairs to find 3 more bedrooms and 2 additional full bathrooms. Enjoy a cup of coffee on the peacefully private covered patio overlooking the backyard space . See this dynamic design today!
NEW CONSTRUCTION in Ooltewah, Tennessee - This charming new home is situated in the stunning Farms at Creekside community. Enjoy a picturesque stroll through the community situated at the base of White Oak Mountain, plenty of tree privacy and green spaces. More than just a home, the Waterford home design is a haven. Room for everyone, everything, and every activity. The large Kitchen boasts a Butler's Pantry that makes entertaining in the Formal Dining Room a breeze. The kitchen also features an elegant backsplash, Quartz countertops, soft close cabinets, gas cooktop and sleek wall oven. The first floor Main Bedroom features a huge walk-in-closet and en suite full bath with double vanity and fully-tiled shower. Additionally, there is a dedicated Study at the front of the home for late-night work sessions or storing hobby materials. A useful drop zone is great for storing back-packs, briefcases or sports equipment on the bench with shoe cubbies and hooks. The laundry room features a laundry sink, cabinets and a granite top perfect for those pesky laundry duties. Venture upstairs to find 3 more bedrooms and 2 additional full bathrooms. Enjoy a cup of coffee on the peacefully private covered patio overlooking the backyard space . See this dynamic design today!
REALTRACS as Distributed by MLS Grid #3258660
May 27, 2026
Listed
$575,000
$206/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 May 27, 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
87
68
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
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 9839 Mayfly Rd #87
We cannot show automated home-value estimates for this home.
Nearby homes have recently sold between $464,200 and $685,000.
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $464K to $685K.