71% of homes accept an offer within a week. Tour it before it's gone!
Tomorrow:
About this home
~RATES AS LOW AS 4.99% AVAILABLE MUST QUALIFY AND USE SELLER''S LENDER NEW CONSTRUCTION in Ooltewah, Tennessee - Introducing one of Ooltewah's newest communities, The Farms at Creekside. Located just off Ooltwah-Ringgold Road so it falls into the sought-after Apison Elementary School Zone. Conveniently located just minutes from Cambridge Square, Hamilton Place, and quick I-75 access. Convenience and a gorgeous backdrop set this piece of land apart from the rest. The Hudson home offers charming curb appeal with its two-levels and abundance of windows. Step inside the welcoming foyer and the style continues throughout the home. An open-concept floor plan that features a gorgeous kitchen with gas range, stainless steel range hood and a sleek wall oven. The huge island is great for cooking and entertaining. Soft close cabinets, beautiful quartz counter-tops, classic tile backsplash and under cabinet lighting highlight this dynamic kitchen layout. The spacious kitchen and great room are filled with natural light from the wall of windows, making every morning a cheerful one. You will also find a drop zone with those great storage cubbies. The upstairs features an open loft area, a comfortably-sized laundry room with additional sink, granite counter-top, and cabinetry. The 2nd level also offers an efficient office space and the home's three bedrooms. Enjoy the spacious main bedroom complete with a luxurious, spa-worthy en suite that includes a tile shower, separate water closet, double vanity and walk-in closet for all your attire. Step out to the rear covered patio overlooking a wooded area to enjoy your monring coffe or tea. Great location and a beautiful neighborhood await you at The Farms at Creekside.
~RATES AS LOW AS 4.99% AVAILABLE MUST QUALIFY AND USE SELLER''S LENDER NEW CONSTRUCTION in Ooltewah, Tennessee - Introducing one of Ooltewah's newest communities, The Farms at Creekside. Located just off Ooltwah-Ringgold Road so it falls into the sought-after Apison Elementary School Zone. Conveniently located just minutes from Cambridge Square, Hamilton Place, and quick I-75 access. Convenience and a gorgeous backdrop set this piece of land apart from the rest. The Hudson home offers charming curb appeal with its two-levels and abundance of windows. Step inside the welcoming foyer and the style continues throughout the home. An open-concept floor plan that features a gorgeous kitchen with gas range, stainless steel range hood and a sleek wall oven. The huge island is great for cooking and entertaining. Soft close cabinets, beautiful quartz counter-tops, classic tile backsplash and under cabinet lighting highlight this dynamic kitchen layout. The spacious kitchen and great room are filled with natural light from the wall of windows, making every morning a cheerful one. You will also find a drop zone with those great storage cubbies. The upstairs features an open loft area, a comfortably-sized laundry room with additional sink, granite counter-top, and cabinetry. The 2nd level also offers an efficient office space and the home's three bedrooms. Enjoy the spacious main bedroom complete with a luxurious, spa-worthy en suite that includes a tile shower, separate water closet, double vanity and walk-in closet for all your attire. Step out to the rear covered patio overlooking a wooded area to enjoy your monring coffe or tea. Great location and a beautiful neighborhood await you at The Farms at Creekside.
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
Tbd
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jun 22, 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
Ooltewah, 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
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
8.8 hrs
5.9 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 9828 Mayfly Rd #73
We cannot show automated home-value estimates for this home.
Nearby homes have recently sold between $489,000 and $685,000.
Nearby comparable homes
The Redfin Estimate uses 5 recent nearby sales, priced between $489K to $685K.