stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Pending
            [last] => Active Under Contract
            [changed] => 2024-10-18T16:34:00
        )

    [ml_number] => 2703658
    [price] => stdClass Object
        (
            [amount] => 545000
            [original] => 545000
            [last_changed_on] => 2024-09-18T20:49:01
        )

    [listing_flags] => Array
        (
            [0] => Sale of Home
            [1] => Existing
        )

    [available_on] => stdClass Object
        (
            [$date] => 2024-09-19T04:00:00Z
        )

    [description] => Charming 4-bedroom home with 3 bedrooms on the main level, plus a private upstairs bedroom with full bath and large bonus room. Enjoy the 3-car side-entry garage, fenced backyard perfect for kids and pets, and a covered patio with a grilling area. Inside features include a cozy wood-burning fireplace, breakfast area, formal dining room, and convenient extra storage off the bonus room. No HOA! Prime location just 27 minutes to BNA Airport, close to Costco, BJ's, and Providence. Zoned for Award-Winning Gladeville Schools!
    [location] => stdClass Object
        (
            [city] => Mount Juliet
            [state] => Tennessee
            [postal_code] => 37122
            [county] => Wilson County, TN
            [subdivision] => Stonefield Sec 2
            [street] => stdClass Object
                (
                    [number] => 417
                    [name] => Cobblestone Way
                    [full] => 417 Cobblestone Way
                )

            [directions] => From Nashville: Take I-40 E to 226A (Mt. Juliet Road). Left on Stewarts Ferry Pike. Subdivision on right before 840.
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.1101
                    [longitude] => -86.425441
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -86.425441
                                    [1] => 36.1101
                                )

                        )

                )

        )

    [building] => stdClass Object
        (
            [style] => Array
                (
                    [0] => Contemporary
                )

            [construction] => Array
                (
                    [0] => Brick
                )

            [square_feet] => stdClass Object
                (
                    [size] => 2250
                    [source] => Owner
                )

            [stories] => 1.5
            [built_in] => 2008
            [rooms] => stdClass Object
                (
                    [bed] => stdClass Object
                        (
                            [count] => 4
                        )

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

                    [basement] => Array
                        (
                            [0] => Crawl Space
                        )

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Storage
                    [2] => Walk-In Closet(s)
                    [3] => Primary Bedroom Main Floor
                )

            [appliances] => Array
                (
                    [0] => Dishwasher
                    [1] => Microwave
                    [2] => Refrigerator
                )

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

                )

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

        )

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

            [parking] => Array
                (
                    [0] => Attached - Side
                )

            [parking_spaces] => 3
            [features] => Array
                (
                    [0] => Garage Door Opener
                    [1] => Storage
                )

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 132.5 X 199.24 IRR
                            [acres] => 0.61
                        )

                    [description] => Array
                        (
                            [0] => Level
                        )

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2024-10-18T20:34:00Z
        )

    [office] => stdClass Object
        (
            [name] => PARKS
            [broker_id] => 3139
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Fiorella
                            [middle] => M.
                            [last] => Villarruel
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 6462416771
                            [mobile] => 6462416771
                        )

                    [agent_id] => 59202
                )

        )

    [media] => stdClass Object
        (
            [virtual_tours] => Array
                (
                    [0] => https://player.vimeo.com/video/1008298037?byline=0&title=0&owner=0&name=0&logos=0&profile=0&profilepicture=0&vimeologo=0&portrait=0
                )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [selling_agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Christian
                            [last] => Wilson
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 4077168799
                            [mobile] => 4077168799
                        )

                    [agent_id] => 50640
                )

        )

    [key] => rt-2703658
    [added_at] => stdClass Object
        (
            [$date] => 2024-09-19T00:49:01Z
        )

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

    Interior Details

  • Bedrooms4
  • Bathrooms3
  • BasementCrawl Space
  • FeaturesCeiling Fan(s), Storage, Walk-In Closet(s), Primary Bedroom Main Floor
  • AppliancesDishwasher, Microwave, Refrigerator
  • HVACArray
  • Fireplaces1

    Exterior Details

  • StyleContemporary
  • ConstructionBrick
  • Built In2008
  • Stories1.5
  • ParkingAttached - Side
  • Garage Bays3
  • FeaturesGarage Door Opener, Storage
  • SewerSTEP System
  • Lot DescriptionLevel
  • Lot Dimensions132.5 X 199.24 IRR
  • Acres0.61

Listing Brokerage: PARKS
Listing Agent: Fiorella Villarruel (646) 241-6771

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of May 12, 2025 10:00am. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.

This property information delivered from various sources that may include, but not be limited to, county records and the multiple listing service. Although the information is believed to be reliable, it is not warranted and you should not rely upon it without independent verification. Property information is subject to errors, omissions, changes, including price, or withdrawal without notice.

For issues regarding this website, please contact Eyesore at 678.692.8512.

Request Information