stdClass Object
(
[type] => Residential
[status] => stdClass Object
(
[current] => Active
[last] => Active
[changed] => 2025-05-17T16:22:00
)
[ml_number] => 2885718
[price] => stdClass Object
(
[amount] => 469425
[original] => 469425
[last_changed_on] => 2025-05-17T16:22:00
)
[listing_flags] => Array
(
[0] => New
)
[available_on] => stdClass Object
(
[$date] => 2025-05-15T04:00:00Z
)
[description] => The Palmer at Hampshire Hills by Smith Douglas Homes. Welcome to the Palmer, a large home featuring a standard first floor owner’s suite, with the unique option of a second owner’s suite upstairs. The first floor features open living and dining areas. At the top of the stairs, you’ll be greeted by a huge loft and three additional bedrooms, two with walk-in closets. A cozier yet ample loft area is included with the optional second owner’s suite. In either configuration, a junior en suite bedroom is standard.
[location] => stdClass Object
(
[city] => Columbia
[state] => Tennessee
[postal_code] => 38401
[county] => Maury County, TN
[subdivision] => Hampshire Hills
[street] => stdClass Object
(
[number] => 564
[name] => Nightengale Ridge Dr
[full] => 564 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] => Fiber Cement
[1] => Brick
)
[square_feet] => stdClass Object
(
[size] => 2934
[source] => Professional Measurement
)
[stories] => 2
[built_in] => 2025
[rooms] => stdClass Object
(
[bed] => stdClass Object
(
[count] => 4
)
[baths] => stdClass Object
(
[full] => 3
[half] => 1
)
)
[features] => Array
(
[0] => Entrance Foyer
[1] => Extra Closets
[2] => Pantry
[3] => Walk-In Closet(s)
[4] => 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 Door Opener
[1] => Garage Faces Front
)
[parking_spaces] => 2
[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] => Kizech
[last] => Washington
)
[phone] => stdClass Object
(
[preferred] => 5737173446
[mobile] => 5737173446
)
[agent_id] => 69794
)
[1] => stdClass Object
(
[name] => stdClass Object
(
[first] => Emily
[last] => Street
)
[phone] => stdClass Object
(
[preferred] => 9316260264
[mobile] => 9316260264
)
[agent_id] => 68909
)
)
[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/2885718/0.jpg
[215x] => https://new.photos.idx.io/rt2/2885718/0/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885718/0/440x.jpg
)
)
[1] => stdClass Object
(
[position] => 1
[description] => First floor.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885718/1.jpg
[215x] => https://new.photos.idx.io/rt2/2885718/1/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885718/1/440x.jpg
)
)
[2] => stdClass Object
(
[position] => 2
[description] => Second floor.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2885718/2.jpg
[215x] => https://new.photos.idx.io/rt2/2885718/2/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885718/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/2885718/3.jpg
[215x] => https://new.photos.idx.io/rt2/2885718/3/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885718/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/2885718/4.jpg
[215x] => https://new.photos.idx.io/rt2/2885718/4/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885718/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/2885718/5.jpg
[215x] => https://new.photos.idx.io/rt2/2885718/5/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885718/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/2885718/6.jpg
[215x] => https://new.photos.idx.io/rt2/2885718/6/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885718/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/2885718/7.jpg
[215x] => https://new.photos.idx.io/rt2/2885718/7/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885718/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/2885718/8.jpg
[215x] => https://new.photos.idx.io/rt2/2885718/8/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885718/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/2885718/9.jpg
[215x] => https://new.photos.idx.io/rt2/2885718/9/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885718/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/2885718/10.jpg
[215x] => https://new.photos.idx.io/rt2/2885718/10/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885718/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/2885718/11.jpg
[215x] => https://new.photos.idx.io/rt2/2885718/11/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885718/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/2885718/12.jpg
[215x] => https://new.photos.idx.io/rt2/2885718/12/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885718/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/2885718/13.jpg
[215x] => https://new.photos.idx.io/rt2/2885718/13/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885718/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/2885718/14.jpg
[215x] => https://new.photos.idx.io/rt2/2885718/14/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2885718/14/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-2885718
[added_at] => stdClass Object
(
[$date] => 2025-05-17T20:22:00Z
)
[source] => rt
[self_link] => https://api.idx.io/listings/rt-2885718
)
- Open House - Sunday, June 8 - 1:00 - 5:00
- Open House - Wednesday, June 11 - 1:00 - 5:00
Interior Details
- Bedrooms4
- Bathrooms3
- Half Baths1
- FeaturesEntrance Foyer, Extra Closets, Pantry, Walk-In Closet(s), Kitchen Island
- AppliancesDishwasher, Disposal, Microwave, Stainless Steel Appliance(s)
- HVACArray
Exterior Details
- ConstructionFiber Cement, Brick
- Built In2025
- Stories2
- ParkingGarage Door Opener, Garage Faces Front
- Garage Bays2
- SewerPublic Sewer