stdClass Object
(
[type] => Rental
[status] => stdClass Object
(
[current] => Active
[last] => Active
[changed] => 2025-04-22T14:25:00
)
[ml_number] => 2821137
[price] => stdClass Object
(
[amount] => 2950
[original] => 2950
[last_changed_on] => 2025-04-22T14:25:00
)
[listing_flags] => Array
(
[0] => New
)
[description] => LAST CHANCE TO SNAG THE BIG KAHUNA OF WATERCOLOUR HOMES! Step into the Columbia, a masterpiece crafted by the wizards at DR Horton. As you waltz through the foyer, you'll be greeted by a living room/study combo that's begging for your coziest armchair and a dining space that's ready to host feasts so grand, your guests might never leave. The open kitchen and living area are a dream for anyone who's ever juggled a spatula and a cocktail shaker at the same time—complete with an island for your sous-chef antics, countertop seating for your adoring fans, a breakfast nook for those lazy pancake mornings, and a pantry so spacious you might lose a small child in it (don't worry, they'll turn up eventually). Climb the stairs—if you can tear yourself away from the main floor fun—and discover a master bedroom that's basically a private retreat, a loft that's either your future yoga sanctuary or an extra bedroom for that cousin who ''just needs a place to crash for a bit,'' plus three more bedrooms and three full bathrooms. That's right, no more morning showdowns over shower time! This home is your triple-threat haven for living, working, and throwing parties that'll have the neighbors whispering, ''Why wasn't I invited?'' Now, let's talk swagger: 9-foot ceilings on the first floor so you can feel like royalty, shaker-style cabinetry that's too chic to call ''just cabinets,'' solid surface countertops with a 4-inch backsplash that says ''I've got style and substance,'' Whirlpool stainless steel appliances that practically cook for you, chrome plumbing fixtures with anti-scald shower valves (because ouch is not on the menu), Mohawk flooring that's tougher than your last DIY project, LED lighting to keep your vibe bright, architectural shingles that scoff at stormy weather, and a concrete rear patio perfect for grilling or chilling. Living in the Watercolour Subdivision is like joining an exclusive club where the perks include lake access with a dock and day docks
[location] => stdClass Object
(
[city] => Ooltewah
[state] => Tennessee
[postal_code] => 37363
[county] => Hamilton County, TN
[subdivision] => Watercolor
[street] => stdClass Object
(
[number] => 8192
[name] => Watercolour Lane
[full] => 8192 Watercolour Lane
)
[directions] => Directions From I-75N Take Exit 11 toward Ooltewah Use left two lanes to turn left onto US-11/US 64 Use right two lanes to turn right onto Mountain View Rd At the traffic circle, take the 2nd exit onto Ooltewah Georgetown Rd Turn left Destination will be on the left
[coordinates] => stdClass Object
(
[latitude] => 35.153327
[longitude] => -85.044327
[geo_json] => stdClass Object
(
[type] => Point
[coordinates] => Array
(
[0] => -85.044327
[1] => 35.153327
)
)
)
)
[building] => stdClass Object
(
[construction] => Array
(
[0] => Fiber Cement
[1] => Vinyl Siding
[2] => Other
[3] => Brick
)
[square_feet] => stdClass Object
(
[size] => 2724
)
[stories] => 2
[built_in] => 2024
[rooms] => stdClass Object
(
[bed] => stdClass Object
(
[count] => 4
)
[baths] => stdClass Object
(
[full] => 3
[half] => 1
)
)
[features] => Array
(
[0] => Open Floorplan
[1] => Walk-In Closet(s)
)
[appliances] => Array
(
[0] => Refrigerator
[1] => Microwave
[2] => Gas Range
[3] => Disposal
[4] => Dishwasher
)
[hvac] => Array
(
[0] => Array
(
[0] => Central Air
)
)
[fireplaces] => stdClass Object
(
[count] => 1
[exists] => 1
)
)
[surroundings] => stdClass Object
(
[sewer] => Array
(
[0] => Public Sewer
)
[services] => Array
(
[0] => Clubhouse
[1] => Pool
)
[parking] => Array
(
[0] => Garage Door Opener
[1] => Attached
)
[parking_spaces] => 2
[school] => stdClass Object
(
[elementary] => Ooltewah Elementary School
[junior] => Hunter Middle School
[high] => Ooltewah High School
)
)
[last_updated] => stdClass Object
(
[$date] => 2025-04-25T18:01:33Z
)
[office] => stdClass Object
(
[name] => RE/MAX Properties
[broker_id] => 5708
)
[agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Matthew
[last] => Mucciolo
)
[phone] => stdClass Object
(
[preferred] => 4238004488
[mobile] => 4238004488
)
)
)
[media] => stdClass Object
(
[photos] => Array
(
[0] => stdClass Object
(
[position] => 0
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/0.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/0/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/0/440x.jpg
)
)
[1] => stdClass Object
(
[position] => 1
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/1.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/1/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/1/440x.jpg
)
)
[2] => stdClass Object
(
[position] => 2
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/2.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/2/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/2/440x.jpg
)
)
[3] => stdClass Object
(
[position] => 3
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/3.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/3/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/3/440x.jpg
)
)
[4] => stdClass Object
(
[position] => 4
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/4.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/4/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/4/440x.jpg
)
)
[5] => stdClass Object
(
[position] => 5
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/5.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/5/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/5/440x.jpg
)
)
[6] => stdClass Object
(
[position] => 6
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/6.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/6/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/6/440x.jpg
)
)
[7] => stdClass Object
(
[position] => 7
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/7.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/7/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/7/440x.jpg
)
)
[8] => stdClass Object
(
[position] => 8
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/8.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/8/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/8/440x.jpg
)
)
[9] => stdClass Object
(
[position] => 9
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/9.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/9/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/9/440x.jpg
)
)
[10] => stdClass Object
(
[position] => 10
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/10.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/10/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/10/440x.jpg
)
)
[11] => stdClass Object
(
[position] => 11
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/11.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/11/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/11/440x.jpg
)
)
[12] => stdClass Object
(
[position] => 12
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/12.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/12/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/12/440x.jpg
)
)
[13] => stdClass Object
(
[position] => 13
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/13.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/13/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/13/440x.jpg
)
)
[14] => stdClass Object
(
[position] => 14
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/14.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/14/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/14/440x.jpg
)
)
[15] => stdClass Object
(
[position] => 15
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/15.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/15/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/15/440x.jpg
)
)
[16] => stdClass Object
(
[position] => 16
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/16.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/16/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/16/440x.jpg
)
)
[17] => stdClass Object
(
[position] => 17
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/17.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/17/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/17/440x.jpg
)
)
[18] => stdClass Object
(
[position] => 18
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/18.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/18/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/18/440x.jpg
)
)
[19] => stdClass Object
(
[position] => 19
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/19.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/19/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/19/440x.jpg
)
)
[20] => stdClass Object
(
[position] => 20
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/20.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/20/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/20/440x.jpg
)
)
[21] => stdClass Object
(
[position] => 21
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/21.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/21/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/21/440x.jpg
)
)
[22] => stdClass Object
(
[position] => 22
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/22.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/22/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/22/440x.jpg
)
)
[23] => stdClass Object
(
[position] => 23
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/23.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/23/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/23/440x.jpg
)
)
[24] => stdClass Object
(
[position] => 24
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/24.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/24/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/24/440x.jpg
)
)
[25] => stdClass Object
(
[position] => 25
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/25.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/25/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/25/440x.jpg
)
)
[26] => stdClass Object
(
[position] => 26
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/26.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/26/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/26/440x.jpg
)
)
[27] => stdClass Object
(
[position] => 27
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/27.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/27/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/27/440x.jpg
)
)
[28] => stdClass Object
(
[position] => 28
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/28.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/28/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/28/440x.jpg
)
)
[29] => stdClass Object
(
[position] => 29
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/29.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/29/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/29/440x.jpg
)
)
[30] => stdClass Object
(
[position] => 30
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/30.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/30/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/30/440x.jpg
)
)
[31] => stdClass Object
(
[position] => 31
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/31.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/31/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/31/440x.jpg
)
)
[32] => stdClass Object
(
[position] => 32
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/32.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/32/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/32/440x.jpg
)
)
[33] => stdClass Object
(
[position] => 33
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2821137/33.jpg
[215x] => https://new.photos.idx.io/rt2/2821137/33/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2821137/33/440x.jpg
)
)
)
)
[key] => rt-2821137
[added_at] => stdClass Object
(
[$date] => 2025-04-22T18:25:00Z
)
[source] => rt
[self_link] => https://api.idx.io/listings/rt-2821137
)
Interior Details
- Bedrooms4
- Bathrooms3
- Half Baths1
- FeaturesOpen Floorplan, Walk-In Closet(s)
- AppliancesRefrigerator, Microwave, Gas Range, Disposal, Dishwasher
- HVACArray
- Fireplaces1
Exterior Details
- ConstructionFiber Cement, Vinyl Siding, Other, Brick
- Built In2024
- Stories2
- ParkingGarage Door Opener, Attached
- Garage Bays2
- ServicesClubhouse, Pool
- SewerPublic Sewer
