stdClass Object
(
[type] => Residential
[status] => stdClass Object
(
[current] => Active
[last] => Active
[changed] => 2025-06-07T01:03:01
)
[ml_number] => 2900464
[price] => stdClass Object
(
[amount] => 450000
[original] => 450000
[last_changed_on] => 2025-06-07T01:03:01
)
[listing_flags] => Array
(
[0] => Existing
)
[available_on] => stdClass Object
(
[$date] => 2025-06-07T04:00:00Z
)
[description] => Beautifully fully-renovated home in the heart of one of Mt. Juliet's sought after neighborhoods, Shiloh Park. Stainless Steel appliances, fantastic fixtures, and marble countertops with fully renovated upstairs office space and additional bedroom/flex-room. This beautiful property backs up to farmland; the fully finished outdoor patio provides additional serenity and relaxation alongside a finished basement and two car garage. Stainless Steel appliances, Refrigerator, Oven, Range, and Hood to be installed.
[location] => stdClass Object
(
[city] => Old Hickory
[state] => Tennessee
[postal_code] => 37138
[county] => Wilson County, TN
[subdivision] => Shiloh Park 3
[street] => stdClass Object
(
[number] => 4837
[name] => Matterhorn Dr
[full] => 4837 Matterhorn Dr
)
[directions] => TN-45N, Turn right onto Andrew Jackson Pkwy, Turn right onto Lebanon Pike, Turn left onto Big Horn Dr, Turn left onto Matterhorn Drive, Property is on the right.
[coordinates] => stdClass Object
(
[latitude] => 36.226299
[longitude] => -86.584974
[geo_json] => stdClass Object
(
[type] => Point
[coordinates] => Array
(
[0] => -86.584974
[1] => 36.226299
)
)
)
)
[building] => stdClass Object
(
[construction] => Array
(
[0] => Brick
)
[square_feet] => stdClass Object
(
[size] => 2200
[source] => Professional Measurement
)
[stories] => 3
[built_in] => 1972
[rooms] => stdClass Object
(
[bed] => stdClass Object
(
[count] => 3
)
[baths] => stdClass Object
(
[full] => 3
)
[basement] => Array
(
[0] => Exterior Entry
)
)
[features] => Array
(
[0] => Ceiling Fan(s)
[1] => Open Floorplan
[2] => Walk-In Closet(s)
[3] => Kitchen Island
)
[appliances] => Array
(
[0] => Electric Oven
[1] => Dishwasher
[2] => Disposal
[3] => Microwave
[4] => Refrigerator
)
[hvac] => Array
(
[0] => Array
(
[0] => Central Air
)
)
[fireplaces] => stdClass Object
(
[exists] =>
)
)
[surroundings] => stdClass Object
(
[sewer] => Array
(
[0] => Public Sewer
)
[parking] => Array
(
[0] => Attached
)
[parking_spaces] => 2
[land] => stdClass Object
(
[size] => stdClass Object
(
[dimensions] => 70.86 X 152.70 IRR
[acres] => 0.27
)
[description] => Array
(
[0] => Private
)
)
[school] => stdClass Object
(
[elementary] => W A Wright Elementary
[junior] => Mt. Juliet Middle School
[high] => Green Hill High School
)
)
[last_updated] => stdClass Object
(
[$date] => 2025-06-17T18:07:01Z
)
[office] => stdClass Object
(
[name] => Pilkerton Realtors
[broker_id] => 1452
)
[agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Thomas
[middle] => Theodoros
[last] => Campanis
)
[phone] => stdClass Object
(
[preferred] => 6153105414
[mobile] => 6153105414
[fax] => 6153836966
)
[agent_id] => 47125
)
)
[media] => stdClass Object
(
[photos] => Array
(
[0] => stdClass Object
(
[position] => 0
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/0.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/0/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/0/440x.jpg
)
)
[1] => stdClass Object
(
[position] => 1
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/1.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/1/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/1/440x.jpg
)
)
[2] => stdClass Object
(
[position] => 2
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/2.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/2/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/2/440x.jpg
)
)
[3] => stdClass Object
(
[position] => 3
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/3.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/3/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/3/440x.jpg
)
)
[4] => stdClass Object
(
[position] => 4
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/4.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/4/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/4/440x.jpg
)
)
[5] => stdClass Object
(
[position] => 5
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/5.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/5/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/5/440x.jpg
)
)
[6] => stdClass Object
(
[position] => 6
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/6.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/6/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/6/440x.jpg
)
)
[7] => stdClass Object
(
[position] => 7
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/7.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/7/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/7/440x.jpg
)
)
[8] => stdClass Object
(
[position] => 8
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/8.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/8/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/8/440x.jpg
)
)
[9] => stdClass Object
(
[position] => 9
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/9.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/9/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/9/440x.jpg
)
)
[10] => stdClass Object
(
[position] => 10
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/10.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/10/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/10/440x.jpg
)
)
[11] => stdClass Object
(
[position] => 11
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/11.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/11/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/11/440x.jpg
)
)
[12] => stdClass Object
(
[position] => 12
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/12.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/12/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/12/440x.jpg
)
)
[13] => stdClass Object
(
[position] => 13
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/13.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/13/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/13/440x.jpg
)
)
[14] => stdClass Object
(
[position] => 14
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/14.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/14/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/14/440x.jpg
)
)
[15] => stdClass Object
(
[position] => 15
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/15.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/15/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/15/440x.jpg
)
)
[16] => stdClass Object
(
[position] => 16
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/16.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/16/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/16/440x.jpg
)
)
[17] => stdClass Object
(
[position] => 17
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/17.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/17/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/17/440x.jpg
)
)
[18] => stdClass Object
(
[position] => 18
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/18.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/18/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/18/440x.jpg
)
)
[19] => stdClass Object
(
[position] => 19
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/19.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/19/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/19/440x.jpg
)
)
[20] => stdClass Object
(
[position] => 20
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/20.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/20/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/20/440x.jpg
)
)
[21] => stdClass Object
(
[position] => 21
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/21.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/21/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/21/440x.jpg
)
)
[22] => stdClass Object
(
[position] => 22
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/22.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/22/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/22/440x.jpg
)
)
[23] => stdClass Object
(
[position] => 23
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/23.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/23/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/23/440x.jpg
)
)
[24] => stdClass Object
(
[position] => 24
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/24.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/24/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/24/440x.jpg
)
)
[25] => stdClass Object
(
[position] => 25
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2900464/25.jpg
[215x] => https://new.photos.idx.io/rt2/2900464/25/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2900464/25/440x.jpg
)
)
)
)
[key] => rt-2900464
[added_at] => stdClass Object
(
[$date] => 2025-06-05T19:44:00Z
)
[source] => rt
[self_link] => https://api.idx.io/listings/rt-2900464
)
Interior Details
- Bedrooms3
- Bathrooms3
- BasementExterior Entry
- FeaturesCeiling Fan(s), Open Floorplan, Walk-In Closet(s), Kitchen Island
- AppliancesElectric Oven, Dishwasher, Disposal, Microwave, Refrigerator
- HVACArray
Exterior Details
- ConstructionBrick
- Built In1972
- Stories3
- ParkingAttached
- Garage Bays2
- SewerPublic Sewer
- Lot DescriptionPrivate
- Lot Dimensions70.86 X 152.70 IRR
- Acres0.27