stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Pending
            [last] => Active Under Contract
            [changed] => 2025-05-01T17:32:00
        )

    [ml_number] => 2801097
    [price] => stdClass Object
        (
            [amount] => 819900
            [original] => 819900
            [last_changed_on] => 2025-03-07T11:38:01
        )

    [listing_flags] => Array
        (
            [0] => Financing
            [1] => Existing
        )

    [available_on] => stdClass Object
        (
            [$date] => 2025-03-13T04:00:00Z
        )

    [description] => Your dream home awaits. Better, much better than new with this meticulously maintained home filled with upgrades. First and foremost your outdoor living space is magnificent, with an inground, heated(new pool heater), saltwater pool and covered patio with powered sun-shade. Enjoy and relax in your expansive main floor owner's suite with dual vanities & separate soaking tub/shower. For multi-generational living there's an easy no-step entry through the front door to a secondary bedroom & full bath. Other upgrades/features include fully fenced backyard, butler's pantry w/electrical, irrigation, Zoysia sod front and back, stacked stone wall with landscaping, a pergola, storage building, & water softener/filter, A huge bonus is the 3rd car carriage garage, all bedrooms have coax/ethernet, bonus room is prewired for surround sound, there's motion sensor flood lights, & storage shed. All interior walls professionally painted with a washable satin. Items that will remain are, refrigerator, washer/dryer, utility sink, doorbell camera, grill, pool cleaning bot, & all equipment/chemicals..
    [location] => stdClass Object
        (
            [city] => Mount Juliet
            [state] => Tennessee
            [postal_code] => 37122
            [county] => Wilson County, TN
            [subdivision] => Oakvale Subdivison Ph2
            [street] => stdClass Object
                (
                    [number] => 709
                    [name] => Mercer Rd
                    [full] => 709 Mercer Rd
                )

            [directions] => I40 to S. Mount Juliet Rd, Go south, left on Stewarts Ferry, right on Oakvale Ln, right on Mercer. Home is on the left.
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.114379
                    [longitude] => -86.469607
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -86.469607
                                    [1] => 36.114379
                                )

                        )

                )

        )

    [building] => stdClass Object
        (
            [construction] => Array
                (
                    [0] => Masonite
                )

            [square_feet] => stdClass Object
                (
                    [size] => 3158
                    [source] => Assessor
                )

            [stories] => 2
            [built_in] => 2021
            [rooms] => stdClass Object
                (
                    [bed] => stdClass Object
                        (
                            [count] => 4
                        )

                    [baths] => stdClass Object
                        (
                            [full] => 3
                        )

                )

            [pool] => Array
                (
                    [0] => In Ground
                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Open Floorplan
                    [2] => Pantry
                    [3] => Walk-In Closet(s)
                    [4] => Primary Bedroom Main Floor
                    [5] => Kitchen Island
                )

            [appliances] => Array
                (
                    [0] => Built-In Electric Oven
                    [1] => Dishwasher
                    [2] => Disposal
                    [3] => Dryer
                    [4] => Microwave
                    [5] => Refrigerator
                    [6] => Stainless Steel Appliance(s)
                    [7] => Washer
                )

            [hvac] => Array
                (
                    [0] => Array
                        (
                            [0] => Central Air
                        )

                )

            [fireplaces] => stdClass Object
                (
                    [count] => 1
                    [exists] => 1
                )

        )

    [surroundings] => stdClass Object
        (
            [sewer] => Array
                (
                    [0] => STEP System
                )

            [services] => Array
                (
                    [0] => Playground
                    [1] => Underground Utilities
                )

            [parking] => Array
                (
                    [0] => Garage Door Opener
                    [1] => Garage Faces Side
                )

            [parking_spaces] => 3
            [features] => Array
                (
                    [0] => Gas Grill
                    [1] => Storage Building
                )

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 86.59 X150 IRR
                            [acres] => 0.36
                        )

                    [description] => Array
                        (
                            [0] => Cul-De-Sac
                        )

                )

            [school] => stdClass Object
                (
                    [elementary] => Gladeville Elementary
                    [junior] => Gladeville Middle School
                    [high] => Wilson Central High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-05-01T21:32:00Z
        )

    [office] => stdClass Object
        (
            [name] => Benchmark Realty, LLC
            [broker_id] => 3865
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Greg
                            [last] => Stroud
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 6159700056
                            [mobile] => 6159700056
                            [fax] => 6155534921
                        )

                )

        )

    [media] => stdClass Object
        (
            [photos] => Array
                (
                    [0] => stdClass Object
                        (
                            [position] => 0
                            [description] => Yes, yes!! Just in time for summer. Heated Saltwater Pool. Photos taken summer of 2024.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/0.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/0/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/0/440x.jpg
                                )

                        )

                    [1] => stdClass Object
                        (
                            [position] => 1
                            [description] => Welcome to 709 Mercer Rd in beautiful Mount Juliet.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/1.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/1/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/1/440x.jpg
                                )

                        )

                    [2] => stdClass Object
                        (
                            [position] => 2
                            [description] => View of carriage garage and the partition to hide the garbage can. You'll appreciate the little things.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/2.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/2/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/2/440x.jpg
                                )

                        )

                    [3] => stdClass Object
                        (
                            [position] => 3
                            [description] => Large family room with vented gas fireplace.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/3.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/3/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/3/440x.jpg
                                )

                        )

                    [4] => stdClass Object
                        (
                            [position] => 4
                            [description] => View from the family room towards kitchen & breakfast nook
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/4.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/4/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/4/440x.jpg
                                )

                        )

                    [5] => stdClass Object
                        (
                            [position] => 5
                            [description] => Another view from family room
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/5.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/5/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/5/440x.jpg
                                )

                        )

                    [6] => stdClass Object
                        (
                            [position] => 6
                            [description] => This kitchen is spacious and very functional. Hood vents to outside.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/6.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/6/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/6/440x.jpg
                                )

                        )

                    [7] => stdClass Object
                        (
                            [position] => 7
                            [description] => No wire shelves in this walk in pantry. Another thoughtful upgrade.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/7.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/7/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/7/440x.jpg
                                )

                        )

                    [8] => stdClass Object
                        (
                            [position] => 8
                            [description] => One oven in the range and a microwave & wall oven next to fridge.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/8.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/8/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/8/440x.jpg
                                )

                        )

                    [9] => stdClass Object
                        (
                            [position] => 9
                            [description] => Island has pull out trash/recycle cans.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/9.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/9/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/9/440x.jpg
                                )

                        )

                    [10] => stdClass Object
                        (
                            [position] => 10
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/10.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/10/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/10/440x.jpg
                                )

                        )

                    [11] => stdClass Object
                        (
                            [position] => 11
                            [description] => Dining area
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/11.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/11/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/11/440x.jpg
                                )

                        )

                    [12] => stdClass Object
                        (
                            [position] => 12
                            [description] => Butler's pantry with shelves and plenty of drawers.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/12.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/12/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/12/440x.jpg
                                )

                        )

                    [13] => stdClass Object
                        (
                            [position] => 13
                            [description] => Owner's suite Very spacious.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/13.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/13/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/13/440x.jpg
                                )

                        )

                    [14] => stdClass Object
                        (
                            [position] => 14
                            [description] => Another view of owner's suite
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/14.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/14/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/14/440x.jpg
                                )

                        )

                    [15] => stdClass Object
                        (
                            [position] => 15
                            [description] => Owner's suite bath.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/15.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/15/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/15/440x.jpg
                                )

                        )

                    [16] => stdClass Object
                        (
                            [position] => 16
                            [description] => Owner's suite soaking tub and separate shower.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/16.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/16/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/16/440x.jpg
                                )

                        )

                    [17] => stdClass Object
                        (
                            [position] => 17
                            [description] => Primary closet with built in shelving.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/17.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/17/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/17/440x.jpg
                                )

                        )

                    [18] => stdClass Object
                        (
                            [position] => 18
                            [description] => Another view of primary closet with built in shelving.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/18.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/18/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/18/440x.jpg
                                )

                        )

                    [19] => stdClass Object
                        (
                            [position] => 19
                            [description] => Bonus/Media room, wired for surround sound.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/19.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/19/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/19/440x.jpg
                                )

                        )

                    [20] => stdClass Object
                        (
                            [position] => 20
                            [description] => Another view of the bonus/media room.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/20.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/20/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/20/440x.jpg
                                )

                        )

                    [21] => stdClass Object
                        (
                            [position] => 21
                            [description] => This conditioned space would work well as a craft room, storage or office. Door in picture leads to stand up attic storage.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/21.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/21/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/21/440x.jpg
                                )

                        )

                    [22] => stdClass Object
                        (
                            [position] => 22
                            [description] => Outdoor living is a 5 star with this covered porch and electric sunshade to block the afternoon sun.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/22.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/22/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/22/440x.jpg
                                )

                        )

                    [23] => stdClass Object
                        (
                            [position] => 23
                            [description] => Upstairs bedroom with walk in closet.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/23.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/23/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/23/440x.jpg
                                )

                        )

                    [24] => stdClass Object
                        (
                            [position] => 24
                            [description] => 2nd floor bath with tub/shower.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/24.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/24/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/24/440x.jpg
                                )

                        )

                    [25] => stdClass Object
                        (
                            [position] => 25
                            [description] => Secondary bedroom on second floor
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/25.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/25/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/25/440x.jpg
                                )

                        )

                    [26] => stdClass Object
                        (
                            [position] => 26
                            [description] => Full bath on the first floor which serves guests and the adjacent bedroom
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/26.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/26/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/26/440x.jpg
                                )

                        )

                    [27] => stdClass Object
                        (
                            [position] => 27
                            [description] => No carpet on these stairs, these hardwood stair treads are beautiful.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/27.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/27/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/27/440x.jpg
                                )

                        )

                    [28] => stdClass Object
                        (
                            [position] => 28
                            [description] => Sitting room or an office on the main floor, you decide the best use for this space.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/28.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/28/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/28/440x.jpg
                                )

                        )

                    [29] => stdClass Object
                        (
                            [position] => 29
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/29.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/29/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/29/440x.jpg
                                )

                        )

                    [30] => stdClass Object
                        (
                            [position] => 30
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/30.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/30/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/30/440x.jpg
                                )

                        )

                    [31] => stdClass Object
                        (
                            [position] => 31
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/31.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/31/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/31/440x.jpg
                                )

                        )

                    [32] => stdClass Object
                        (
                            [position] => 32
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/32.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/32/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/32/440x.jpg
                                )

                        )

                    [33] => stdClass Object
                        (
                            [position] => 33
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/33.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/33/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/33/440x.jpg
                                )

                        )

                    [34] => stdClass Object
                        (
                            [position] => 34
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/34.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/34/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/34/440x.jpg
                                )

                        )

                    [35] => stdClass Object
                        (
                            [position] => 35
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/35.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/35/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/35/440x.jpg
                                )

                        )

                    [36] => stdClass Object
                        (
                            [position] => 36
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/36.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/36/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/36/440x.jpg
                                )

                        )

                    [37] => stdClass Object
                        (
                            [position] => 37
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/37.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/37/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/37/440x.jpg
                                )

                        )

                    [38] => stdClass Object
                        (
                            [position] => 38
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/38.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/38/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/38/440x.jpg
                                )

                        )

                    [39] => stdClass Object
                        (
                            [position] => 39
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2801097/39.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2801097/39/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2801097/39/440x.jpg
                                )

                        )

                )

        )

    [selling_agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Cherri
                            [last] => Nolan
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 4079631945
                            [mobile] => 4079631945
                            [fax] => 6157909446
                        )

                )

        )

    [key] => rt-2801097
    [added_at] => stdClass Object
        (
            [$date] => 2025-03-07T03:31:01Z
        )

    [source] => rt
    [self_link] => https://api.idx.io/listings/rt-2801097
)
			

    Interior Details

  • Bedrooms4
  • Bathrooms3
  • FeaturesCeiling Fan(s), Open Floorplan, Pantry, Walk-In Closet(s), Primary Bedroom Main Floor, Kitchen Island
  • AppliancesBuilt-In Electric Oven, Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Stainless Steel Appliance(s), Washer
  • HVACArray
  • Fireplaces1

    Exterior Details

  • ConstructionMasonite
  • Built In2021
  • Stories2
  • PoolIn Ground
  • ParkingGarage Door Opener, Garage Faces Side
  • Garage Bays3
  • FeaturesGas Grill, Storage Building
  • ServicesPlayground, Underground Utilities
  • SewerSTEP System
  • Lot DescriptionCul-De-Sac
  • Lot Dimensions86.59 X150 IRR
  • Acres0.36

Request Information