stdClass Object
(
[type] => Residential
[status] => stdClass Object
(
[current] => Active
[last] => Active
[changed] => 2025-08-24T17:02:18
)
[ml_number] => 2970008
[price] => stdClass Object
(
[amount] => 1300000
[original] => 1300000
[last_changed_on] => 2025-08-24T17:02:18
)
[listing_flags] => Array
(
[0] => Existing
)
[available_on] => stdClass Object
(
[$date] => 2025-08-06T04:00:00Z
)
[description] => Nestled in a peaceful neighborhood, this beautiful home offers the perfect blend of comfort, convenience, and lake-life living. Home is situated in a neighborhood that is walking distance to the lake. Seller is also selling a lake lot in same subdivision (O Saundersville Ferry, mls# 2970323). NEW AND AMAZING kitchen re model with all the bells and whistle.. custom made cabinets, appliance garage to hide appliances that sit on the countertop, a super cool Murphy door that offers storage, recycle trash can and also leads to the basement. Huge master bedroom with custom fireplace and new floors, The Master bathroom has also been re modeled with custom finishes and newly organized closet organizer in master closet. Foyer area , office and sitting area have new black and white porcelain tile with a beautiful fireplace in sitting room Basement area has tons of space for hanging out with full bathroom downstairs and a custom built in bar area.
Now.. you step outside to a in ground salt water swimming pool with a fireplace. Yard is fully secluded with tons of space to enjoy the outdoors. Upgrade list of everything done to the house is attached. Come take a look at this house. You won't be disappointed!!!
[location] => stdClass Object
(
[city] => Mount Juliet
[state] => Tennessee
[postal_code] => 37122
[county] => Wilson County, TN
[subdivision] => Hickory Isles 1
[street] => stdClass Object
(
[number] => 1009
[name] => Mystic Streams Dr
[full] => 1009 Mystic Streams Dr
)
[directions] => From Nashville: I-40 East. Exit 221A Old Hickory Blvd (Hermitage). Right on Andrew Jackson. Continue on Saundersville Rd. Left on Saundersville Ferry Rd. Left into Hickory Isle.
)
[building] => stdClass Object
(
[style] => Array
(
[0] => Other
)
[construction] => Array
(
[0] => Stucco
)
[square_feet] => stdClass Object
(
[size] => 4656
[source] => Appraiser
)
[stories] => 2
[built_in] => 1993
[rooms] => stdClass Object
(
[bed] => stdClass Object
(
[count] => 4
)
[baths] => stdClass Object
(
[full] => 4
[half] => 1
)
[basement] => Array
(
[0] => Finished
[1] => Full
)
)
[pool] => Array
(
[0] => In Ground
)
[appliances] => Array
(
[0] => Built-In Electric Oven
[1] => Double Oven
[2] => Built-In Electric Range
[3] => Cooktop
[4] => Dishwasher
[5] => Disposal
[6] => Dryer
[7] => Ice Maker
[8] => Microwave
[9] => Refrigerator
[10] => Washer
)
[hvac] => Array
(
[0] => Array
(
[0] => Central Air
[1] => Electric
)
)
[fireplaces] => stdClass Object
(
[count] => 2
[exists] => 1
)
)
[surroundings] => stdClass Object
(
[sewer] => Array
(
[0] => Septic Tank
)
[parking] => Array
(
[0] => Garage Faces Rear
)
[parking_spaces] => 2
[features] => Array
(
[0] => Balcony
)
[land] => stdClass Object
(
[size] => stdClass Object
(
[dimensions] => 138X280
[acres] => 0.88
)
[description] => Array
(
[0] => Cleared
[1] => Level
)
)
[school] => stdClass Object
(
[elementary] => Lakeview Elementary School
[junior] => Mt. Juliet Middle School
[high] => Green Hill High School
)
)
[last_updated] => stdClass Object
(
[$date] => 2025-08-24T21:02:18Z
)
[office] => stdClass Object
(
[name] => Keller Williams Realty Mt. Juliet
[broker_id] => 1642
)
[agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Christi
[last] => Roberts
)
[phone] => stdClass Object
(
[preferred] => 6153974166
[mobile] => 6153974166
[fax] => 6156907953
)
[agent_id] => 25159
)
)
[media] => stdClass Object
(
[photos] => Array
(
[0] => stdClass Object
(
[position] => 0
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/0.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/0/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/0/440x.jpg
)
)
[1] => stdClass Object
(
[position] => 1
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/1.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/1/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/1/440x.jpg
)
)
[2] => stdClass Object
(
[position] => 2
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/2.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/2/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/2/440x.jpg
)
)
[3] => stdClass Object
(
[position] => 3
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/3.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/3/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/3/440x.jpg
)
)
[4] => stdClass Object
(
[position] => 4
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/4.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/4/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/4/440x.jpg
)
)
[5] => stdClass Object
(
[position] => 5
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/5.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/5/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/5/440x.jpg
)
)
[6] => stdClass Object
(
[position] => 6
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/6.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/6/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/6/440x.jpg
)
)
[7] => stdClass Object
(
[position] => 7
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/7.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/7/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/7/440x.jpg
)
)
[8] => stdClass Object
(
[position] => 8
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/8.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/8/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/8/440x.jpg
)
)
[9] => stdClass Object
(
[position] => 9
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/9.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/9/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/9/440x.jpg
)
)
[10] => stdClass Object
(
[position] => 10
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/10.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/10/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/10/440x.jpg
)
)
[11] => stdClass Object
(
[position] => 11
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/11.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/11/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/11/440x.jpg
)
)
[12] => stdClass Object
(
[position] => 12
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/12.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/12/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/12/440x.jpg
)
)
[13] => stdClass Object
(
[position] => 13
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/13.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/13/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/13/440x.jpg
)
)
[14] => stdClass Object
(
[position] => 14
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/14.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/14/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/14/440x.jpg
)
)
[15] => stdClass Object
(
[position] => 15
[description] => Murphy Door leading to basement in kitchen
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/15.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/15/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/15/440x.jpg
)
)
[16] => stdClass Object
(
[position] => 16
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/16.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/16/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/16/440x.jpg
)
)
[17] => stdClass Object
(
[position] => 17
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/17.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/17/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/17/440x.jpg
)
)
[18] => stdClass Object
(
[position] => 18
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/18.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/18/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/18/440x.jpg
)
)
[19] => stdClass Object
(
[position] => 19
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/19.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/19/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/19/440x.jpg
)
)
[20] => stdClass Object
(
[position] => 20
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/20.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/20/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/20/440x.jpg
)
)
[21] => stdClass Object
(
[position] => 21
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/21.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/21/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/21/440x.jpg
)
)
[22] => stdClass Object
(
[position] => 22
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/22.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/22/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/22/440x.jpg
)
)
[23] => stdClass Object
(
[position] => 23
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/23.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/23/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/23/440x.jpg
)
)
[24] => stdClass Object
(
[position] => 24
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/24.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/24/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/24/440x.jpg
)
)
[25] => stdClass Object
(
[position] => 25
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/25.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/25/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/25/440x.jpg
)
)
[26] => stdClass Object
(
[position] => 26
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/26.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/26/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/26/440x.jpg
)
)
[27] => stdClass Object
(
[position] => 27
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/27.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/27/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/27/440x.jpg
)
)
[28] => stdClass Object
(
[position] => 28
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/28.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/28/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/28/440x.jpg
)
)
[29] => stdClass Object
(
[position] => 29
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/29.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/29/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/29/440x.jpg
)
)
[30] => stdClass Object
(
[position] => 30
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/30.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/30/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/30/440x.jpg
)
)
[31] => stdClass Object
(
[position] => 31
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/31.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/31/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/31/440x.jpg
)
)
[32] => stdClass Object
(
[position] => 32
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/32.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/32/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/32/440x.jpg
)
)
[33] => stdClass Object
(
[position] => 33
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2970008/33.jpg
[215x] => https://new.photos.idx.io/rt2/2970008/33/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2970008/33/440x.jpg
)
)
)
)
[key] => rt-2970008
[added_at] => stdClass Object
(
[$date] => 2025-08-24T21:02:18Z
)
[source] => rt
[self_link] => https://api.idx.io/listings/rt-2970008
)
- Bedrooms4
- Bathrooms4
- Half Baths1
- BasementFinished, Full
- AppliancesBuilt-In Electric Oven, Double Oven, Built-In Electric Range, Cooktop, Dishwasher, Disposal, Dryer, Ice Maker, Microwave, Refrigerator, Washer
- HVACCentral Air, Electric
- Fireplaces2
Interior Details
- StyleOther
- ConstructionStucco
- Built In1993
- Stories2
- PoolIn Ground
- ParkingGarage Faces Rear
- Garage Bays2
- FeaturesBalcony
- SewerSeptic Tank
- Lot DescriptionCleared, Level
- Lot Dimensions138X280
- Acres0.88