Price - High to Low Price - Low to High Date Listed - New to Old Date Listed - Old to New
stdClass Object
(
[type] => Residential
[status] => stdClass Object
(
[current] => Active Under Contract
[last] => Active
[changed] => 2025-04-23T14:16:01
)
[ml_number] => 2813909
[price] => stdClass Object
(
[amount] => 449777
[original] => 449777
[last_changed_on] => 2025-04-06T14:30:02
)
[listing_flags] => Array
(
[0] => Inspection
[1] => Renovated
)
[available_on] => stdClass Object
(
[$date] => 2025-04-09T04:00:00Z
)
[description] => If you are looking for a water view without breaking the budget then look no further! This all-brick renovated home offers the perfect oasis! Brand new roof 3/25 (with transferrable warranty for new homeowner), granite in kitchen, beautiful refinished hardwood floors, beautiful landscaping, huge corner lot and a view that will end each day perfectly as you enjoy it from your back deck. Would be a great setup for multi-generational living with walk-out basement with full bath. Other renovations/updates include: basement (2019), HVAC (2018), front door w/sidelights (2020), windows (2016), kitchen (2015).
[location] => stdClass Object
(
[city] => Mount Juliet
[state] => Tennessee
[postal_code] => 37122
[county] => Wilson County, TN
[subdivision] => Edgewater Est Sec 1
[street] => stdClass Object
(
[number] => 227
[name] => Edgewater Dr
[full] => 227 Edgewater Dr
)
[directions] => From I-40, take Mt. Juliet Exit at Providence. Go towards Mt. Juliet. Left on to Lebanon Rd. Right on to N. Greenhill Rd. Right on to Saundersville Ferry Rd. Left on to Edgewater Dr. Left on to NW Clearview Dr. Left on to Edgewater Dr.
[coordinates] => stdClass Object
(
[latitude] => 36.267205
[longitude] => -86.554887
[geo_json] => stdClass Object
(
[type] => Point
[coordinates] => Array
(
[0] => -86.554887
[1] => 36.267205
)
)
)
)
[building] => stdClass Object
(
[style] => Array
(
[0] => Traditional
)
[construction] => Array
(
[0] => Brick
)
[square_feet] => stdClass Object
(
[size] => 1875
[source] => Assessor
)
[stories] => 1
[built_in] => 1968
[rooms] => stdClass Object
(
[bed] => stdClass Object
(
[count] => 3
)
[baths] => stdClass Object
(
[full] => 2
[half] => 1
)
[basement] => Array
(
[0] => Finished
)
)
[appliances] => Array
(
[0] => Built-In Electric Oven
[1] => Cooktop
[2] => Dishwasher
[3] => Refrigerator
[4] => Stainless Steel Appliance(s)
)
[hvac] => Array
(
[0] => Array
(
[0] => Central Air
)
)
[fireplaces] => stdClass Object
(
[exists] =>
)
)
[surroundings] => stdClass Object
(
[sewer] => Array
(
[0] => Septic Tank
)
[parking] => Array
(
[0] => Basement
)
[parking_spaces] => 2
[land] => stdClass Object
(
[size] => stdClass Object
(
[dimensions] => 160 X 140 M IRR
[acres] => 0.53
)
)
[school] => stdClass Object
(
[elementary] => Lakeview Elementary School
[junior] => Mt. Juliet Middle School
[high] => Green Hill High School
)
)
[last_updated] => stdClass Object
(
[$date] => 2025-04-23T18:16:01Z
)
[office] => stdClass Object
(
[name] => EXIT Realty Refined
[broker_id] => 3555
)
[agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Shelly
[last] => Gregory
)
[phone] => stdClass Object
(
[preferred] => 6155137963
[mobile] => 6155137963
)
)
)
[media] => stdClass Object
(
[virtual_tours] => Array
(
[0] => https://www.youtube.com/embed/iP70s6VKsC4
)
[photos] => Array
(
[0] => stdClass Object
(
[position] => 0
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/0.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/0/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/0/440x.jpg
)
)
[1] => stdClass Object
(
[position] => 1
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/1.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/1/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/1/440x.jpg
)
)
[2] => stdClass Object
(
[position] => 2
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/2.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/2/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/2/440x.jpg
)
)
[3] => stdClass Object
(
[position] => 3
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/3.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/3/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/3/440x.jpg
)
)
[4] => stdClass Object
(
[position] => 4
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/4.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/4/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/4/440x.jpg
)
)
[5] => stdClass Object
(
[position] => 5
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/5.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/5/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/5/440x.jpg
)
)
[6] => stdClass Object
(
[position] => 6
[description] => Living room (virtually staged)
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/6.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/6/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/6/440x.jpg
)
)
[7] => stdClass Object
(
[position] => 7
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/7.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/7/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/7/440x.jpg
)
)
[8] => stdClass Object
(
[position] => 8
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/8.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/8/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/8/440x.jpg
)
)
[9] => stdClass Object
(
[position] => 9
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/9.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/9/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/9/440x.jpg
)
)
[10] => stdClass Object
(
[position] => 10
[description] => Photo virtually staged
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/10.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/10/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/10/440x.jpg
)
)
[11] => stdClass Object
(
[position] => 11
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/11.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/11/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/11/440x.jpg
)
)
[12] => stdClass Object
(
[position] => 12
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/12.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/12/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/12/440x.jpg
)
)
[13] => stdClass Object
(
[position] => 13
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/13.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/13/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/13/440x.jpg
)
)
[14] => stdClass Object
(
[position] => 14
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/14.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/14/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/14/440x.jpg
)
)
[15] => stdClass Object
(
[position] => 15
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/15.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/15/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/15/440x.jpg
)
)
[16] => stdClass Object
(
[position] => 16
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/16.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/16/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/16/440x.jpg
)
)
[17] => stdClass Object
(
[position] => 17
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/17.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/17/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/17/440x.jpg
)
)
[18] => stdClass Object
(
[position] => 18
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/18.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/18/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/18/440x.jpg
)
)
[19] => stdClass Object
(
[position] => 19
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/19.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/19/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/19/440x.jpg
)
)
[20] => stdClass Object
(
[position] => 20
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/20.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/20/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/20/440x.jpg
)
)
[21] => stdClass Object
(
[position] => 21
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/21.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/21/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/21/440x.jpg
)
)
[22] => stdClass Object
(
[position] => 22
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/22.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/22/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/22/440x.jpg
)
)
[23] => stdClass Object
(
[position] => 23
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/23.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/23/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/23/440x.jpg
)
)
[24] => stdClass Object
(
[position] => 24
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/24.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/24/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/24/440x.jpg
)
)
[25] => stdClass Object
(
[position] => 25
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/25.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/25/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/25/440x.jpg
)
)
[26] => stdClass Object
(
[position] => 26
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/26.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/26/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/26/440x.jpg
)
)
[27] => stdClass Object
(
[position] => 27
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/27.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/27/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/27/440x.jpg
)
)
[28] => stdClass Object
(
[position] => 28
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/28.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/28/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/28/440x.jpg
)
)
[29] => stdClass Object
(
[position] => 29
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/29.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/29/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/29/440x.jpg
)
)
[30] => stdClass Object
(
[position] => 30
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/30.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/30/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/30/440x.jpg
)
)
[31] => stdClass Object
(
[position] => 31
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/31.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/31/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/31/440x.jpg
)
)
[32] => stdClass Object
(
[position] => 32
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2813909/32.jpg
[215x] => https://new.photos.idx.io/rt2/2813909/32/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2813909/32/440x.jpg
)
)
)
)
[key] => rt-2813909
[added_at] => stdClass Object
(
[$date] => 2025-04-04T21:49:00Z
)
[source] => rt
[self_link] => https://api.idx.io/listings/rt-2813909
)
Interior Details
Bedrooms 3 Bathrooms 2 Half Baths 1 Basement Finished Appliances Built-In Electric Oven, Cooktop, Dishwasher, Refrigerator, Stainless Steel Appliance(s) HVAC Array
Exterior Details
Style Traditional Construction Brick Built In 1968 Stories 1 Parking Basement Garage Bays 2 Sewer Septic Tank Lot Dimensions 160 X 140 M IRR Acres 0.53