stdClass Object
(
[type] => Residential
[status] => stdClass Object
(
[current] => Active
[last] => Active
[changed] => 2025-05-15T14:59:01
)
[ml_number] => 2885725
[price] => stdClass Object
(
[amount] => 430935
[original] => 430935
[last_changed_on] => 2025-05-15T14:59:01
)
[listing_flags] => Array
(
[0] => New
)
[available_on] => stdClass Object
(
[$date] => 2025-05-15T04:00:00Z
)
[description] => The Avondale at Hampshire Hills by Smith Douglas Homes. The Avondale is a beautiful home with excellent curb appeal and a welcoming design. It features a center island kitchen, a dining room, and a large family room connected to a covered back patio, making it perfect for entertaining. The owner's suite is in the back, offering a luxurious retreat with two walk-in closets, a linen closet, and easy access to the laundry room. Additionally, there are two bedrooms and a full bath in the front of the home, and a private study that can be converted into a fourth bedroom. Estimated completion date of August 2025.
[location] => stdClass Object
(
[city] => Columbia
[state] => Tennessee
[postal_code] => 38401
[county] => Maury County, TN
[subdivision] => Hampshire Hills
[street] => stdClass Object
(
[number] => 545
[name] => Nightengale Ridge Dr
[full] => 545 Nightengale Ridge Dr
)
[directions] => From I-65 S, take Exit 53 for TN-396. Follow 4.5 mi, then exit to US-31 S. Go 8.9 mi, turn right on US-43 S. After 2.9 mi, exit to Industrial Park Rd. Left on Industrial, right on James Campbell, right on Hampshire Pike, right on Iberia, left on Avalon.
[coordinates] => stdClass Object
(
[latitude] => 35.621692
[longitude] => -87.079975
[geo_json] => stdClass Object
(
[type] => Point
[coordinates] => Array
(
[0] => -87.079975
[1] => 35.621692
)
)
)
)
[building] => stdClass Object
(
[style] => Array
(
[0] => Ranch
)
[construction] => Array
(
[0] => Fiber Cement
[1] => Brick
)
[square_feet] => stdClass Object
(
[size] => 2203
[source] => Professional Measurement
)
[stories] => 1
[built_in] => 2025
[rooms] => stdClass Object
(
[bed] => stdClass Object
(
[count] => 3
)
[baths] => stdClass Object
(
[full] => 2
)
)
[features] => Array
(
[0] => Entrance Foyer
[1] => Extra Closets
[2] => Open Floorplan
[3] => Pantry
[4] => Walk-In Closet(s)
[5] => Kitchen Island
)
[appliances] => Array
(
[0] => Dishwasher
[1] => Disposal
[2] => Microwave
[3] => Stainless Steel Appliance(s)
)
[hvac] => Array
(
[0] => Array
(
[0] => Central Air
)
)
[fireplaces] => stdClass Object
(
[exists] =>
)
)
[surroundings] => stdClass Object
(
[sewer] => Array
(
[0] => Public Sewer
)
[parking] => Array
(
[0] => Garage Faces Front
)
[parking_spaces] => 2
[land] => stdClass Object
(
[size] => stdClass Object
(
[acres] => 0.316
)
)
[school] => stdClass Object
(
[elementary] => J. R. Baker Elementary
[junior] => Whitthorne Middle School
[high] => Columbia Central High School
)
)
[last_updated] => stdClass Object
(
[$date] => 2025-06-04T22:02:01Z
)
[office] => stdClass Object
(
[name] => SDH Nashville, LLC
[broker_id] => 4180
)
[agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Emily
[last] => Street
)
[phone] => stdClass Object
(
[preferred] => 9316260264
[mobile] => 9316260264
)
[agent_id] => 68909
)
[1] => stdClass Object
(
[name] => stdClass Object
(
[first] => Kizech
[last] => Washington
)
[phone] => stdClass Object
(
[preferred] => 5737173446
[mobile] => 5737173446
)
[agent_id] => 69794
)
)
[media] => stdClass Object
(
[photos] => Array
(
[0] => stdClass Object
(
[position] => 0
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/0.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/0/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/0/440x.jpg
)
)
[1] => stdClass Object
(
[position] => 1
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/1.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/1/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/1/440x.jpg
)
)
[2] => stdClass Object
(
[position] => 2
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/2.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/2/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/2/440x.jpg
)
)
[3] => stdClass Object
(
[position] => 3
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/3.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/3/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/3/440x.jpg
)
)
[4] => stdClass Object
(
[position] => 4
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/4.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/4/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/4/440x.jpg
)
)
[5] => stdClass Object
(
[position] => 5
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/5.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/5/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/5/440x.jpg
)
)
[6] => stdClass Object
(
[position] => 6
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/6.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/6/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/6/440x.jpg
)
)
[7] => stdClass Object
(
[position] => 7
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/7.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/7/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/7/440x.jpg
)
)
[8] => stdClass Object
(
[position] => 8
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/8.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/8/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/8/440x.jpg
)
)
[9] => stdClass Object
(
[position] => 9
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/9.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/9/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/9/440x.jpg
)
)
[10] => stdClass Object
(
[position] => 10
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/10.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/10/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/10/440x.jpg
)
)
[11] => stdClass Object
(
[position] => 11
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/11.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/11/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/11/440x.jpg
)
)
[12] => stdClass Object
(
[position] => 12
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/12.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/12/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/12/440x.jpg
)
)
[13] => stdClass Object
(
[position] => 13
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/13.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/13/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/13/440x.jpg
)
)
[14] => stdClass Object
(
[position] => 14
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/14.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/14/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/14/440x.jpg
)
)
[15] => stdClass Object
(
[position] => 15
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/15.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/15/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/15/440x.jpg
)
)
[16] => stdClass Object
(
[position] => 16
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/16.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/16/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/16/440x.jpg
)
)
[17] => stdClass Object
(
[position] => 17
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/17.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/17/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/17/440x.jpg
)
)
[18] => stdClass Object
(
[position] => 18
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885725/18.jpg
[215x] => https://new.photos.idx.io/rt2/2885725/18/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885725/18/440x.jpg
)
)
)
)
[open_houses] => Array
(
[0] => stdClass Object
(
[starts_at] => stdClass Object
(
[$date] => 2025-06-08T18:00:00Z
)
[ends_at] => stdClass Object
(
[$date] => 2025-06-08T22:00:00Z
)
[status] => Active
)
[1] => stdClass Object
(
[starts_at] => stdClass Object
(
[$date] => 2025-06-11T18:00:00Z
)
[ends_at] => stdClass Object
(
[$date] => 2025-06-11T22:00:00Z
)
[status] => Active
)
)
[key] => rt-2885725
[added_at] => stdClass Object
(
[$date] => 2025-05-15T18:59:01Z
)
[source] => rt
[self_link] => https://api.idx.io/listings/rt-2885725
)
- Open House - Sunday, June 8 - 1:00 - 5:00
- Open House - Wednesday, June 11 - 1:00 - 5:00
Interior Details
- Bedrooms3
- Bathrooms2
- FeaturesEntrance Foyer, Extra Closets, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island
- AppliancesDishwasher, Disposal, Microwave, Stainless Steel Appliance(s)
- HVACArray
Exterior Details
- StyleRanch
- ConstructionFiber Cement, Brick
- Built In2025
- Stories1
- ParkingGarage Faces Front
- Garage Bays2
- SewerPublic Sewer
- Acres0.316