stdClass Object
(
[type] => Residential
[status] => stdClass Object
(
[current] => Active Under Contract
[last] => Active
[changed] => 2024-10-30T15:32:00
)
[ml_number] => 2745068
[price] => stdClass Object
(
[amount] => 519777
[original] => 529999
[last_changed_on] => 2024-10-18T03:39:00
)
[listing_flags] => Array
(
[0] => Financing
[1] => Approximate
)
[available_on] => stdClass Object
(
[$date] => 2024-10-05T04:00:00Z
)
[description] => Welcome Home! This 4 bedroom, 2.5 bath home on a private, fully fenced, wooded back lot has many upgrades and is move in ready. No neighbors behind you! All it's missing is you. Highly sought after neighborhood & school district. Spacious bedrooms w/ primary en-suite, boasting a large whirlpool tub, tile shower, double vanities, & walk- in closet. Chef's dream kitchen w/ large, walk- in pantry, double ovens, new sink, cabinets galore, stainless appliances, & huge island made from 100 year old wood from Historic Shackle Island. *Downstairs is wheelchair accessible from garage, allowing the comfort of the entire downstairs to be used, inc. front porch sitting & entertaining on the gorgeous back patio with built in fire pit & wooded views. Upstairs boasts 3 spacious bedrooms, full bath, bonus room, & large attic. Upgrades: light fixtures, fans, kitchen sink, faucets, knobs & hinges. Neighborhood: 2 pools, Clubhouse, pickleball courts, walking trails, & more! Don't miss out on this gem!
[location] => stdClass Object
(
[city] => Hendersonville
[state] => Tennessee
[postal_code] => 37075
[county] => Sumner County, TN
[subdivision] => Mansker Farms Ph 12
[street] => stdClass Object
(
[number] => 165
[name] => Trail Ridge Dr
[full] => 165 Trail Ridge Dr
)
[directions] => from 386: Exit 2- turn left on Centerpoint Road Left on Mansker Farms Blvd Left on Ridgeview Trace Round about, take Trail Ridge DRIVE- not "way" house is on the left
[coordinates] => stdClass Object
(
[latitude] => 36.338488
[longitude] => -86.667444
[geo_json] => stdClass Object
(
[type] => Point
[coordinates] => Array
(
[0] => -86.667444
[1] => 36.338488
)
)
)
)
[building] => stdClass Object
(
[construction] => Array
(
[0] => Brick
[1] => Vinyl Siding
)
[square_feet] => stdClass Object
(
[size] => 2393
[source] => Appraiser
)
[stories] => 2
[built_in] => 2005
[rooms] => stdClass Object
(
[bed] => stdClass Object
(
[count] => 4
)
[baths] => stdClass Object
(
[full] => 2
[half] => 1
)
)
[appliances] => Array
(
[0] => Dishwasher
[1] => Disposal
[2] => Microwave
)
[hvac] => Array
(
[0] => Array
(
[0] => Central Air
[1] => Electric
)
)
[fireplaces] => stdClass Object
(
[count] => 1
[exists] => 1
)
)
[surroundings] => stdClass Object
(
[sewer] => Array
(
[0] => Public Sewer
)
[services] => Array
(
[0] => Clubhouse
[1] => Playground
[2] => Pool
[3] => Sidewalks
)
[parking] => Array
(
[0] => Attached - Front
)
[parking_spaces] => 2
[land] => stdClass Object
(
[size] => stdClass Object
(
[dimensions] => 70 X 137.70
[acres] => 0.22
)
[description] => Array
(
[0] => Sloped
)
)
[school] => stdClass Object
(
[elementary] => Madison Creek Elementary
[junior] => T. W. Hunter Middle School
[high] => Beech Sr High School
)
)
[last_updated] => stdClass Object
(
[$date] => 2024-10-30T19:32:00Z
)
[office] => stdClass Object
(
[name] => One Stop Realty and Auction
[broker_id] => 1079
)
[agents] => Array
(
[0] => stdClass Object
(
[name] => stdClass Object
(
[first] => Tony
[last] => Robinson
)
[phone] => stdClass Object
(
[preferred] => 6153309387
[mobile] => 6153309387
[fax] => 6158229307
)
[agent_id] => 6906
)
[1] => stdClass Object
(
[name] => stdClass Object
(
[first] => Kyle
[middle] => Anthony
[last] => Robinson
)
[phone] => stdClass Object
(
[preferred] => 6153321969
[mobile] => 6153321969
)
[agent_id] => 61241
)
)
[media] => stdClass Object
(
[virtual_tours] => Array
(
[0] => https://www.youtube.com/watch?v=RwkCrJWxFMM
)
[photos] => Array
(
[0] => stdClass Object
(
[position] => 0
[description] => Welcome to your new home at 165 Trail Ridge Drive. Wooded, private lot on cul de sac road. Half a mile from the Clubhouse, main pool, walking trails, pickleball court, playground, and more.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/0.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/0/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/0/440x.jpg
)
)
[1] => stdClass Object
(
[position] => 1
[description] => This covered front porch is a great place to relax and enjoy the outdoors. It's the perfect spot to read or have your morning coffee.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/1.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/1/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/1/440x.jpg
)
)
[2] => stdClass Object
(
[position] => 2
[description] => This home has a lot of great features, including an extra parking pad that was added to the driveway. This is a great feature for those who have a lot of guests or who like to entertain.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/2.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/2/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/2/440x.jpg
)
)
[3] => stdClass Object
(
[position] => 3
[description] => The front of the house has shake siding that has been recently painted, adding curb appeal. The paint is fresh and the shakes are in good condition.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/3.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/3/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/3/440x.jpg
)
)
[4] => stdClass Object
(
[position] => 4
[description] => This property has been freshly landscaped to add curb appeal. The landscaping includes new much and shrubs.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/4.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/4/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/4/440x.jpg
)
)
[5] => stdClass Object
(
[position] => 5
[description] => This spacious living area has built-in shelving and waterproof LVT flooring. But the best part is that it opens to the large kitchen and dining room, making it perfect for entertaining.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/5.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/5/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/5/440x.jpg
)
)
[6] => stdClass Object
(
[position] => 6
[description] => This room has a gas fireplace, built-in shelving, and lots of natural lighting. The ceiling fan is new.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/6.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/6/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/6/440x.jpg
)
)
[7] => stdClass Object
(
[position] => 7
[description] => Dream kitchen! Cabinets galore. New sink, faucet, and drawer pulls. Large island made from 100- year old barn wood from Historic Shackle Island. **Stools convey** Amazing, large pantry with tons of shelving.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/7.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/7/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/7/440x.jpg
)
)
[8] => stdClass Object
(
[position] => 8
[description] => The kitchen has gorgeous tile flooring throughout. The sliding glass doors open to a large, private patio with a firepit. The backyard is fully fenced and wooded, providing a private outdoor oasis.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/8.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/8/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/8/440x.jpg
)
)
[9] => stdClass Object
(
[position] => 9
[description] => This large pantry is a dream! It has shelving galore, so you can store everything you need to feed your family.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/9.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/9/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/9/440x.jpg
)
)
[10] => stdClass Object
(
[position] => 10
[description] => This spacious home features an open floor plan that combines the entryway, living room, and dining room into one large, open space.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/10.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/10/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/10/440x.jpg
)
)
[11] => stdClass Object
(
[position] => 11
[description] => This beautiful dining room/flex room has new light fixtures, fresh paint, and 9-foot ceilings. The room is flooded with natural light, making it a great place to entertain guests or just relax and enjoy a meal.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/11.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/11/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/11/440x.jpg
)
)
[12] => stdClass Object
(
[position] => 12
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/12.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/12/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/12/440x.jpg
)
)
[13] => stdClass Object
(
[position] => 13
[description] => Your primary bedroom is on the main level. It's a large room with neutral colors, a new ceiling fan, and an en suite bathroom.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/13.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/13/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/13/440x.jpg
)
)
[14] => stdClass Object
(
[position] => 14
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/14.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/14/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/14/440x.jpg
)
)
[15] => stdClass Object
(
[position] => 15
[description] => The primary bathroom features neutral colors, double sinks, and new lighting, faucets, framed mirror, doorknobs, and hinges. It also has a large whirlpool tub and separate tile shower.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/15.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/15/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/15/440x.jpg
)
)
[16] => stdClass Object
(
[position] => 16
[description] => The bathroom has a large whirlpool tub that is surrounded by tile. There is a large window next to the tub that lets in lots of natural light.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/16.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/16/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/16/440x.jpg
)
)
[17] => stdClass Object
(
[position] => 17
[description] => This beautiful bathroom has a tiled shower, a water closet, and a walk-in closet. The shower has a built-in bench and a rain shower head.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/17.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/17/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/17/440x.jpg
)
)
[18] => stdClass Object
(
[position] => 18
[description] => This bathroom has a walk-in shower with a built-in bench and a rain shower head. The shower is tiled, as well as the bench.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/18.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/18/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/18/440x.jpg
)
)
[19] => stdClass Object
(
[position] => 19
[description] => This bedroom has a huge walk-in closet! It's large enough for both him and her...or just her!
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/19.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/19/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/19/440x.jpg
)
)
[20] => stdClass Object
(
[position] => 20
[description] => Another view of the primary walk in closet.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/20.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/20/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/20/440x.jpg
)
)
[21] => stdClass Object
(
[position] => 21
[description] => This home has a half bath off of the kitchen, which is the perfect location for guests.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/21.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/21/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/21/440x.jpg
)
)
[22] => stdClass Object
(
[position] => 22
[description] => Who doesn't love a large laundry room? This one is located on the first floor, and has plenty of space for all your laundry needs.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/22.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/22/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/22/440x.jpg
)
)
[23] => stdClass Object
(
[position] => 23
[description] => This is the first of three bedrooms upstairs. It has a new ceiling fan, new doorknobs and hinges, and a large walk-in closet. But what you'll really notice is the natural light!
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/23.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/23/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/23/440x.jpg
)
)
[24] => stdClass Object
(
[position] => 24
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/24.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/24/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/24/440x.jpg
)
)
[25] => stdClass Object
(
[position] => 25
[description] => This newly remodeled full bath is located upstairs. New additions include a light fixture, sink faucet, framed mirror, bead board, freshly painted cabinets & ceiling, doorknobs, & hinges. The wallpaper is peel & stick and can easily be removed.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/25.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/25/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/25/440x.jpg
)
)
[26] => stdClass Object
(
[position] => 26
[description] => The second additional bedroom is large and located upstairs. It has a spacious closet and a chandelier.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/26.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/26/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/26/440x.jpg
)
)
[27] => stdClass Object
(
[position] => 27
[description] => This spacious third bedroom is located upstairs. It has a large closet, a ceiling fan, and gets lots of natural light.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/27.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/27/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/27/440x.jpg
)
)
[28] => stdClass Object
(
[position] => 28
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/28.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/28/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/28/440x.jpg
)
)
[29] => stdClass Object
(
[position] => 29
[description] => This large bonus room is located in the center of the upstairs. Each of the bedrooms, as well as the full bath and large walk-in attic, are accessible from this room.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/29.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/29/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/29/440x.jpg
)
)
[30] => stdClass Object
(
[position] => 30
[description] => This bonus room is flooded with natural light from the large windows. It's a great space for a home office, game room, or playroom.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/30.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/30/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/30/440x.jpg
)
)
[31] => stdClass Object
(
[position] => 31
[description] => This is an additional view of the bonus room/flex space. This room is a great place to relax.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/31.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/31/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/31/440x.jpg
)
)
[32] => stdClass Object
(
[position] => 32
[description] => The outdoor patio is a great space for entertaining. It's quiet and private because there are no homes behind you, and it backs up to a wooded area.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/32.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/32/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/32/440x.jpg
)
)
[33] => stdClass Object
(
[position] => 33
[description] => The patio is located off the kitchen and features a fire pit, a large banana tree, and a wooded back lot. The patio is a great place to relax and enjoy the outdoors.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/33.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/33/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/33/440x.jpg
)
)
[34] => stdClass Object
(
[position] => 34
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/34.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/34/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/34/440x.jpg
)
)
[35] => stdClass Object
(
[position] => 35
[description] => This property is a gem! Enjoy comfort & privacy while being easily accessible to an array of shops and restaurants. Glenbrook is a 7 minute drive. Indian Lake is a short 10 minutes. Nashville is just 20. Don't let this one slip away!
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/35.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/35/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/35/440x.jpg
)
)
[36] => stdClass Object
(
[position] => 36
[description] => Street View. Notice you are right by the cul de sac, making this a quiet area of the neighborhood.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/36.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/36/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/36/440x.jpg
)
)
[37] => stdClass Object
(
[position] => 37
[description] => One of the two pools, Clubhouse, pickleball courts, basketball court, sand volleyball, playground, and walking trails. Additional pool, tennis, basketball, pond, and playground at the front pool house.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/37.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/37/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/37/440x.jpg
)
)
[38] => stdClass Object
(
[position] => 38
[description] => This additional street view shows the sidewalks and wooded area behind the home. The wooded area includes a creek and wildlife such as deer and turkey.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/38.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/38/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/38/440x.jpg
)
)
[39] => stdClass Object
(
[position] => 39
[description] => Entry to your new neighborhood.
[urls] => stdClass Object
(
[original] => https://new.photos.idx.io/rt2/2745068/39.jpg
[215x] => https://new.photos.idx.io/rt2/2745068/39/215x.jpg
[440x] => https://new.photos.idx.io/rt2/2745068/39/440x.jpg
)
)
)
)
[key] => rt-2745068
[added_at] => stdClass Object
(
[$date] => 2024-10-05T17:49:00Z
)
[source] => rt
[self_link] => https://api.idx.io/listings/rt-2745068
)
