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
[last] => Coming Soon
[changed] => 2025-03-28T18:59:00
)
[ml_number] => 2809135
[price] => stdClass Object
(
[amount] => 460000
[original] => 475000
[last_changed_on] => 2025-04-14T21:06:00
)
[listing_flags] => Array
(
[0] => Existing
)
[available_on] => stdClass Object
(
[$date] => 2025-03-28T04:00:00Z
)
[description] => Prime location in the heart of MJ! This well maintained home is a perfect opportunity-desirable location, NO HOA, ample outdoor space, fenced backyard-all under 500k! Beautiful restored hardwood floors, new windows on main level, fenced backyard with beautiful established landscaping including a storage shed for additional storage. Main level is bright with natural light featuring 4 bedrooms and 2 bathrooms complete with original vintage bathroom tile in excellent condition. The full unfinished walk out basement features a gas fireplace and is the perfect canvas for doubling the square footage of this lovely home or simply TONS of storage. Large back sundeck right off the kitchen perfect for grilling and entertaining while the lower level has plenty of covered parking/entertainment area with a fenced backyard to boot. Neighboring home with finished basement sold in Nov' 2024 for over $600k! This is a well maintained home that you can move right into while putting your personal touches into the design all the while gaining equity. Great location on a quiet dead end road minutes from I-40 exchange within MJHS school zone. Fantastic Opportunity awaits!
[location] => stdClass Object
(
[city] => Mount Juliet
[state] => Tennessee
[postal_code] => 37122
[county] => Wilson County, TN
[subdivision] => Ridgecrest
[street] => stdClass Object
(
[number] => 86
[name] => E Hill St
[full] => 86 E Hill St
)
[directions] => Turn left onto TN-171 S/N Mt Juliet Rd Use the right lane to take the ramp to Nashville Follow I-40 to TN-255 S/Donelson Pike in Nashville. Take the 216/TN-255/Donelson Pike exit from I-40 Continue on TN-255 S/Donelson Pike to BNA Airport
[coordinates] => stdClass Object
(
[latitude] => 36.203575
[longitude] => -86.512274
[geo_json] => stdClass Object
(
[type] => Point
[coordinates] => Array
(
[0] => -86.512274
[1] => 36.203575
)
)
)
)
[building] => stdClass Object
(
[style] => Array
(
[0] => Ranch
)
[construction] => Array
(
[0] => Brick
)
[square_feet] => stdClass Object
(
[size] => 1632
[source] => Assessor
)
[stories] => 2
[built_in] => 1971
[rooms] => stdClass Object
(
[bed] => stdClass Object
(
[count] => 4
)
[baths] => stdClass Object
(
[full] => 2
)
[basement] => Array
(
[0] => Unfinished
)
)
[features] => Array
(
[0] => Ceiling Fan(s)
[1] => Storage
[2] => Primary Bedroom Main Floor
)
[appliances] => Array
(
[0] => Oven
[1] => Dishwasher
[2] => Dryer
[3] => Refrigerator
[4] => Washer
)
[hvac] => Array
(
[0] => Array
(
[0] => Central Air
)
)
[fireplaces] => stdClass Object
(
[count] => 1
[exists] => 1
)
)
[surroundings] => stdClass Object
(
[sewer] => Array
(
[0] => Public Sewer
)
[parking] => Array
(
[0] => Attached
[1] => Asphalt
)
[features] => Array
(
[0] => Storage Building
)
[land] => stdClass Object
(
[size] => stdClass Object
(
[dimensions] => 143 X 156.8
[acres] => 0.51
)
)
[school] => stdClass Object
(
[elementary] => Elzie D Patton Elementary School
[junior] => West Wilson Middle School
[high] => Mt. Juliet High School
)
)
[last_updated] => stdClass Object
(
[$date] => 2025-04-15T01:06:00Z
)
[office] => stdClass Object
(
[name] => Cedar City Properties
[broker_id] => 5015
)
[agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Rebecca
[middle] => H.
[last] => Shaffer
)
[phone] => stdClass Object
(
[preferred] => 6155598213
[mobile] => 6155598213
)
)
)
[media] => stdClass Object
(
[photos] => Array
(
[0] => stdClass Object
(
[position] => 0
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/0.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/0/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/0/440x.jpg
)
)
[1] => stdClass Object
(
[position] => 1
[description] => Sought after location-in the middle of MJ with NO HOA!
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/1.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/1/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/1/440x.jpg
)
)
[2] => stdClass Object
(
[position] => 2
[description] => Welcome home. Level front yard with beautiful maple tree and rocking chair front porch.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/2.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/2/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/2/440x.jpg
)
)
[3] => stdClass Object
(
[position] => 3
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/3.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/3/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/3/440x.jpg
)
)
[4] => stdClass Object
(
[position] => 4
[description] => Notice your pristine original hardwood floors in your main living and hallway!
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/4.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/4/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/4/440x.jpg
)
)
[5] => stdClass Object
(
[position] => 5
[description] => Large sunny living area
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/5.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/5/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/5/440x.jpg
)
)
[6] => stdClass Object
(
[position] => 6
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/6.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/6/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/6/440x.jpg
)
)
[7] => stdClass Object
(
[position] => 7
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/7.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/7/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/7/440x.jpg
)
)
[8] => stdClass Object
(
[position] => 8
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/8.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/8/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/8/440x.jpg
)
)
[9] => stdClass Object
(
[position] => 9
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/9.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/9/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/9/440x.jpg
)
)
[10] => stdClass Object
(
[position] => 10
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/10.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/10/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/10/440x.jpg
)
)
[11] => stdClass Object
(
[position] => 11
[description] => Light and bring with ample storage in your eat in kitchen.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/11.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/11/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/11/440x.jpg
)
)
[12] => stdClass Object
(
[position] => 12
[description] => Lovely view to your large sundeck-perferct for grilling!
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/12.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/12/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/12/440x.jpg
)
)
[13] => stdClass Object
(
[position] => 13
[description] => Plenty of prep space. **Stove does not convey
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/13.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/13/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/13/440x.jpg
)
)
[14] => stdClass Object
(
[position] => 14
[description] => Large Eat in kitchen
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/14.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/14/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/14/440x.jpg
)
)
[15] => stdClass Object
(
[position] => 15
[description] => Plenty of sunlight. Exit to your sundeck area from your dining area
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/15.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/15/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/15/440x.jpg
)
)
[16] => stdClass Object
(
[position] => 16
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/16.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/16/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/16/440x.jpg
)
)
[17] => stdClass Object
(
[position] => 17
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/17.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/17/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/17/440x.jpg
)
)
[18] => stdClass Object
(
[position] => 18
[description] => Large primary with en-suite
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/18.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/18/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/18/440x.jpg
)
)
[19] => stdClass Object
(
[position] => 19
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/19.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/19/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/19/440x.jpg
)
)
[20] => stdClass Object
(
[position] => 20
[description] => En-Suite bathroom. Shower with vintage tile
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/20.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/20/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/20/440x.jpg
)
)
[21] => stdClass Object
(
[position] => 21
[description] => 1 of 4 bedrooms
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/21.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/21/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/21/440x.jpg
)
)
[22] => stdClass Object
(
[position] => 22
[description] => Hall bath with excellent condition vintage tile
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/22.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/22/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/22/440x.jpg
)
)
[23] => stdClass Object
(
[position] => 23
[description] => 2 of 4 bedrooms
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/23.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/23/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/23/440x.jpg
)
)
[24] => stdClass Object
(
[position] => 24
[description] => 4th bedroom being used at a laundry area right off your open living space
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/24.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/24/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/24/440x.jpg
)
)
[25] => stdClass Object
(
[position] => 25
[description] => Plenty of room to host the Memorial Day BBQ here!
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/25.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/25/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/25/440x.jpg
)
)
[26] => stdClass Object
(
[position] => 26
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/26.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/26/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/26/440x.jpg
)
)
[27] => stdClass Object
(
[position] => 27
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/27.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/27/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/27/440x.jpg
)
)
[28] => stdClass Object
(
[position] => 28
[description] => Lovely established landscaping in your large FENCED backyard
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/28.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/28/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/28/440x.jpg
)
)
[29] => stdClass Object
(
[position] => 29
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/29.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/29/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/29/440x.jpg
)
)
[30] => stdClass Object
(
[position] => 30
[description] => Who doesn't want extra storage?
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/30.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/30/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/30/440x.jpg
)
)
[31] => stdClass Object
(
[position] => 31
[description] => Plenty of parking and covered parking or entertainment area
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/31.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/31/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/31/440x.jpg
)
)
[32] => stdClass Object
(
[position] => 32
[description] => Over sized lot-you don't get this much outdoor space in newer neighborhoods
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/32.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/32/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/32/440x.jpg
)
)
[33] => stdClass Object
(
[position] => 33
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/33.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/33/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/33/440x.jpg
)
)
[34] => stdClass Object
(
[position] => 34
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/34.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/34/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/34/440x.jpg
)
)
[35] => stdClass Object
(
[position] => 35
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/35.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/35/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/35/440x.jpg
)
)
[36] => stdClass Object
(
[position] => 36
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/36.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/36/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/36/440x.jpg
)
)
[37] => stdClass Object
(
[position] => 37
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/37.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/37/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/37/440x.jpg
)
)
[38] => stdClass Object
(
[position] => 38
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/38.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/38/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/38/440x.jpg
)
)
[39] => stdClass Object
(
[position] => 39
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/39.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/39/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/39/440x.jpg
)
)
[40] => stdClass Object
(
[position] => 40
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/40.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/40/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/40/440x.jpg
)
)
[41] => stdClass Object
(
[position] => 41
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/41.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/41/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/41/440x.jpg
)
)
[42] => stdClass Object
(
[position] => 42
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/42.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/42/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/42/440x.jpg
)
)
[43] => stdClass Object
(
[position] => 43
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/43.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/43/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/43/440x.jpg
)
)
[44] => stdClass Object
(
[position] => 44
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/44.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/44/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/44/440x.jpg
)
)
[45] => stdClass Object
(
[position] => 45
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/45.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/45/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/45/440x.jpg
)
)
[46] => stdClass Object
(
[position] => 46
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/46.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/46/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/46/440x.jpg
)
)
[47] => stdClass Object
(
[position] => 47
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/47.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/47/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/47/440x.jpg
)
)
[48] => stdClass Object
(
[position] => 48
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2809135/48.jpg
[215x] => https://new.photos.idx.io/rt2/2809135/48/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2809135/48/440x.jpg
)
)
)
)
[key] => rt-2809135
[added_at] => stdClass Object
(
[$date] => 2025-03-26T18:55:01Z
)
[source] => rt
[self_link] => https://api.idx.io/listings/rt-2809135
)
Interior Details
Bedrooms 4 Bathrooms 2 Basement Unfinished Features Ceiling Fan(s), Storage, Primary Bedroom Main Floor Appliances Oven, Dishwasher, Dryer, Refrigerator, Washer HVAC Array Fireplaces 1
Exterior Details
Style Ranch Construction Brick Built In 1971 Stories 2 Parking Attached, Asphalt Features Storage Building Sewer Public Sewer Lot Dimensions 143 X 156.8 Acres 0.51