stdClass Object
(
[type] => Residential
[status] => stdClass Object
(
[current] => Active
[last] => Active
[changed] => 2025-03-22T15:05:01
)
[ml_number] => 2807630
[price] => stdClass Object
(
[amount] => 410260
[original] => 410815
[last_changed_on] => 2025-04-12T12:19:00
)
[listing_flags] => Array
(
[0] => Spec
)
[available_on] => stdClass Object
(
[$date] => 2025-03-22T04:00:00Z
)
[description] => The Caldwell at Hampshire Hills by Smith Douglas is a great choice for those needing a first floor owner's suite. The hub of this home is the centrally located family room that's open to the kitchen and a covered rear porch. Single-level living can be easily achieved here because everything is just steps away, but a flexible second floor provides a bath and two additional bedrooms with a large loft and options for a fourth bedroom, third bathroom and media room
[location] => stdClass Object
(
[city] => Columbia
[state] => Tennessee
[postal_code] => 38401
[county] => Maury County, TN
[subdivision] => Hampshire Hills
[street] => stdClass Object
(
[number] => 1234
[name] => Nightengale Ridge Dr
[full] => 1234 Nightengale Ridge Dr
)
[directions] => From I-65, take exit 31A. Continue 6 miles onto exit 53, 396 W, Saturn Parkway. Drive 4.4 miles and turn right on Highway 31. Continue south on Highway 31, then turn right onto Highway 6. In 2.9 miles turn right onto Industrial Park Rd. Continue to N. Jam
[coordinates] => stdClass Object
(
[latitude] => 35.649038
[longitude] => -86.978075
[geo_json] => stdClass Object
(
[type] => Point
[coordinates] => Array
(
[0] => -86.978075
[1] => 35.649038
)
)
)
)
[building] => stdClass Object
(
[construction] => Array
(
[0] => Other
)
[square_feet] => stdClass Object
(
[size] => 2231
[source] => Builder
)
[stories] => 2
[built_in] => 2025
[rooms] => stdClass Object
(
[bed] => stdClass Object
(
[count] => 4
)
[baths] => stdClass Object
(
[full] => 2
[half] => 1
)
)
[features] => Array
(
[0] => Kitchen Island
)
[appliances] => Array
(
[0] => Gas Range
[1] => Dishwasher
[2] => Microwave
)
[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.28
)
)
[school] => stdClass Object
(
[elementary] => J. R. Baker Elementary
[junior] => Whitthorne Middle School
[high] => Columbia Central High School
)
)
[last_updated] => stdClass Object
(
[$date] => 2025-04-17T15:49:00Z
)
[office] => stdClass Object
(
[name] => SDH Nashville, LLC
[broker_id] => 4180
)
[agents] => Array
(
[0] => 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
[description] => *This is a marketing photo. Colors/options may be different.*
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2807630/0.jpg
[215x] => https://new.photos.idx.io/rt2/2807630/0/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2807630/0/440x.jpg
)
)
[1] => stdClass Object
(
[position] => 1
[description] => First Floor
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2807630/1.jpg
[215x] => https://new.photos.idx.io/rt2/2807630/1/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2807630/1/440x.jpg
)
)
[2] => stdClass Object
(
[position] => 2
[description] => Second floor
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2807630/2.jpg
[215x] => https://new.photos.idx.io/rt2/2807630/2/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2807630/2/440x.jpg
)
)
[3] => stdClass Object
(
[position] => 3
[description] => *This is a marketing photo. Colors/options may be different.*
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2807630/3.jpg
[215x] => https://new.photos.idx.io/rt2/2807630/3/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2807630/3/440x.jpg
)
)
[4] => stdClass Object
(
[position] => 4
[description] => *This is a marketing photo. Colors/options may be different.*
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2807630/4.jpg
[215x] => https://new.photos.idx.io/rt2/2807630/4/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2807630/4/440x.jpg
)
)
[5] => stdClass Object
(
[position] => 5
[description] => *This is a marketing photo. Colors/options may be different.*
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2807630/5.jpg
[215x] => https://new.photos.idx.io/rt2/2807630/5/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2807630/5/440x.jpg
)
)
[6] => stdClass Object
(
[position] => 6
[description] => *This is a marketing photo. Colors/options may be different.*
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2807630/6.jpg
[215x] => https://new.photos.idx.io/rt2/2807630/6/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2807630/6/440x.jpg
)
)
[7] => stdClass Object
(
[position] => 7
[description] => *This is a marketing photo. Colors/options may be different.*
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2807630/7.jpg
[215x] => https://new.photos.idx.io/rt2/2807630/7/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2807630/7/440x.jpg
)
)
[8] => stdClass Object
(
[position] => 8
[description] => *This is a marketing photo. Colors/options may be different.*
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2807630/8.jpg
[215x] => https://new.photos.idx.io/rt2/2807630/8/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2807630/8/440x.jpg
)
)
[9] => stdClass Object
(
[position] => 9
[description] => *This is a marketing photo. Colors/options may be different.*
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2807630/9.jpg
[215x] => https://new.photos.idx.io/rt2/2807630/9/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2807630/9/440x.jpg
)
)
[10] => stdClass Object
(
[position] => 10
[description] => *This is a marketing photo. Colors/options may be different.*
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2807630/10.jpg
[215x] => https://new.photos.idx.io/rt2/2807630/10/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2807630/10/440x.jpg
)
)
[11] => stdClass Object
(
[position] => 11
[description] => *This is a marketing photo. Colors/options may be different.*
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2807630/11.jpg
[215x] => https://new.photos.idx.io/rt2/2807630/11/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2807630/11/440x.jpg
)
)
[12] => stdClass Object
(
[position] => 12
[description] => *This is a marketing photo. Colors/options may be different.*
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2807630/12.jpg
[215x] => https://new.photos.idx.io/rt2/2807630/12/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2807630/12/440x.jpg
)
)
[13] => stdClass Object
(
[position] => 13
[description] => *This is a marketing photo. Colors/options may be different.*
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2807630/13.jpg
[215x] => https://new.photos.idx.io/rt2/2807630/13/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2807630/13/440x.jpg
)
)
[14] => stdClass Object
(
[position] => 14
[description] => *This is a marketing photo. Colors/options may be different.*
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2807630/14.jpg
[215x] => https://new.photos.idx.io/rt2/2807630/14/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2807630/14/440x.jpg
)
)
[15] => stdClass Object
(
[position] => 15
[description] => *This is a marketing photo. Colors/options may be different.*
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2807630/15.jpg
[215x] => https://new.photos.idx.io/rt2/2807630/15/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2807630/15/440x.jpg
)
)
[16] => stdClass Object
(
[position] => 16
[description] => *This is a marketing photo. Colors/options may be different.*
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2807630/16.jpg
[215x] => https://new.photos.idx.io/rt2/2807630/16/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2807630/16/440x.jpg
)
)
[17] => stdClass Object
(
[position] => 17
[description] => *This is a marketing photo. Colors/options may be different.*
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2807630/17.jpg
[215x] => https://new.photos.idx.io/rt2/2807630/17/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2807630/17/440x.jpg
)
)
)
)
[key] => rt-2807630
[added_at] => stdClass Object
(
[$date] => 2025-03-22T19:05:01Z
)
[source] => rt
[self_link] => https://api.idx.io/listings/rt-2807630
)
Interior Details
Bedrooms4
Bathrooms2
Half Baths1
FeaturesKitchen Island
AppliancesGas Range, Dishwasher, Microwave
HVACArray
Exterior Details
ConstructionOther
Built In2025
Stories2
ParkingGarage Faces Front
Garage Bays2
SewerPublic Sewer
Acres0.28
$410,260
1234 Nightengale Ridge Dr
Columbia,
Tennessee38401
4 beds
2 full, 1 half baths 2,231sq. ft.
The Caldwell at Hampshire Hills by Smith Douglas is a great choice for those needing a first floor owner's suite. The hub of this home is the centrally located family room that's open to the kitchen and a covered rear porch. Single-level living can be easily achieved here because everything is just steps away, but a flexible second floor provides a bath and two additional bedrooms with a large loft and options for a fourth bedroom, third bathroom and media room