stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Hold
            [changed] => 2024-11-03T21:03:00
        )

    [ml_number] => 2747774
    [price] => stdClass Object
        (
            [amount] => 494900
            [original] => 495800
            [last_changed_on] => 2024-11-07T19:40:00
        )

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

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

    [description] => Don't miss this 3 BR/2/1Bath home on a quiet cul-de-sac in the coveted Brookstone Subdivision!  This is the largest lot in subdivision!  Custom home -  built by Architect, larger laundry room - larger primary BR.  All new laminate planking downstairs and on stairway.  New water heater 2019, Plumbing & electricity checked 2024, New HVAC 2023, Foundation repair 2024 with lifetime warranty.  New stainless steel appliances included, Quartz counter top.  Large back yard with fresh-water spring  Fences are not part of the property.  Back deck and covered front porch. Gutterguards on gutters. Just needs a little refresh of paint. Large Bonus room on 2nd floor may also be 4th bedroom.  Encapsulated crawl space with dehumidifier.  Walk to Mt. Juliet Greenway and Eagle Park!  Seller is offering $500 Home Warranty
    [location] => stdClass Object
        (
            [city] => Mount Juliet
            [state] => Tennessee
            [postal_code] => 37122
            [county] => Wilson County, TN
            [subdivision] => Brookstone Phase 2
            [street] => stdClass Object
                (
                    [number] => 2403
                    [name] => Brookstone Pl
                    [full] => 2403 Brookstone Pl
                )

            [directions] => From 40 W - Exit 229 Gold Bear Gateway - 1.5 Miles left on E Division - 3.3 Miles L Brookstone Blvd - .1 Mile = right Brookstone Dr - .02 miles Left Brookstone PL
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.202039
                    [longitude] => -86.53991
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -86.53991
                                    [1] => 36.202039
                                )

                        )

                )

        )

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

            [construction] => Array
                (
                    [0] => Brick
                    [1] => Vinyl Siding
                )

            [square_feet] => stdClass Object
                (
                    [size] => 2188
                )

            [stories] => 2
            [built_in] => 1991
            [rooms] => stdClass Object
                (
                    [bed] => stdClass Object
                        (
                            [count] => 3
                        )

                    [baths] => stdClass Object
                        (
                            [full] => 2
                            [half] => 1
                        )

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

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Dehumidifier
                    [2] => High Ceilings
                    [3] => Pantry
                    [4] => Walk-In Closet(s)
                    [5] => High Speed Internet
                )

            [appliances] => Array
                (
                    [0] => Dishwasher
                    [1] => Disposal
                    [2] => Microwave
                    [3] => Refrigerator
                    [4] => Stainless Steel Appliance(s)
                )

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

                )

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

        )

    [surroundings] => stdClass Object
        (
            [sewer] => Array
                (
                    [0] => Public Sewer
                )

            [services] => Array
                (
                    [0] => Clubhouse
                    [1] => Fitness Center
                    [2] => Pool
                    [3] => Tennis Court(s)
                )

            [parking] => Array
                (
                    [0] => Attached - Front
                    [1] => Aggregate
                )

            [parking_spaces] => 2
            [features] => Array
                (
                    [0] => Garage Door Opener
                )

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 91X167
                            [acres] => 0.35
                        )

                )

            [school] => stdClass Object
                (
                    [elementary] => Mt. Juliet Elementary
                    [junior] => Mt. Juliet Middle School
                    [high] => Green Hill High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2024-11-08T00:40:00Z
        )

    [office] => stdClass Object
        (
            [name] => Crye-Leike, Inc., REALTORS
            [broker_id] => 398
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Tina
                            [middle] => louise
                            [last] => Dorow
                        )

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

                    [agent_id] => 61770
                )

        )

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

                        )

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

                        )

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

                        )

                    [3] => stdClass Object
                        (
                            [position] => 3
                            [description] => Tennis Courts & Pool
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2747774/3.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2747774/3/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2747774/3/440x.jpg
                                )

                        )

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

                        )

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

                        )

                    [6] => stdClass Object
                        (
                            [position] => 6
                            [description] => Large window on landing provides lots of light!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2747774/6.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2747774/6/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2747774/6/440x.jpg
                                )

                        )

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

                        )

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

                        )

                    [9] => stdClass Object
                        (
                            [position] => 9
                            [description] => Kitchen opens to Back Deck
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2747774/9.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2747774/9/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2747774/9/440x.jpg
                                )

                        )

                    [10] => stdClass Object
                        (
                            [position] => 10
                            [description] => Laundry room off garage
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2747774/10.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2747774/10/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2747774/10/440x.jpg
                                )

                        )

                    [11] => stdClass Object
                        (
                            [position] => 11
                            [description] => Brand new half bath downstairs
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2747774/11.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2747774/11/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2747774/11/440x.jpg
                                )

                        )

                    [12] => stdClass Object
                        (
                            [position] => 12
                            [description] => Hall to Front Door
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2747774/12.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2747774/12/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2747774/12/440x.jpg
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [21] => stdClass Object
                        (
                            [position] => 21
                            [description] => Primary BR - Oversized
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2747774/21.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2747774/21/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2747774/21/440x.jpg
                                )

                        )

                    [22] => stdClass Object
                        (
                            [position] => 22
                            [description] => Primary leading into ensuite
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2747774/22.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2747774/22/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2747774/22/440x.jpg
                                )

                        )

                    [23] => stdClass Object
                        (
                            [position] => 23
                            [description] => Garden tub in ensuite
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2747774/23.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2747774/23/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2747774/23/440x.jpg
                                )

                        )

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

                        )

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

                        )

                    [26] => stdClass Object
                        (
                            [position] => 26
                            [description] => Walk in closet off ensuite
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2747774/26.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2747774/26/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2747774/26/440x.jpg
                                )

                        )

                    [27] => stdClass Object
                        (
                            [position] => 27
                            [description] => Side of house
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2747774/27.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2747774/27/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2747774/27/440x.jpg
                                )

                        )

                    [28] => stdClass Object
                        (
                            [position] => 28
                            [description] => Beautiful back yard
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2747774/28.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2747774/28/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2747774/28/440x.jpg
                                )

                        )

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

                        )

                    [30] => stdClass Object
                        (
                            [position] => 30
                            [description] => Eagle Park across from Subdivision
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2747774/30.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2747774/30/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2747774/30/440x.jpg
                                )

                        )

                    [31] => stdClass Object
                        (
                            [position] => 31
                            [description] => Walking Trails Across from subdivision
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2747774/31.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2747774/31/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2747774/31/440x.jpg
                                )

                        )

                )

        )

    [key] => rt-2747774
    [added_at] => stdClass Object
        (
            [$date] => 2024-10-13T21:04:04Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms2
  • Half Baths1
  • BasementCrawl Space
  • FeaturesCeiling Fan(s), Dehumidifier, High Ceilings, Pantry, Walk-In Closet(s), High Speed Internet
  • AppliancesDishwasher, Disposal, Microwave, Refrigerator, Stainless Steel Appliance(s)
  • HVACArray
  • Fireplaces1

    Exterior Details

  • StyleColonial
  • ConstructionBrick, Vinyl Siding
  • Built In1991
  • Stories2
  • ParkingAttached - Front, Aggregate
  • Garage Bays2
  • FeaturesGarage Door Opener
  • ServicesClubhouse, Fitness Center, Pool, Tennis Court(s)
  • SewerPublic Sewer
  • Lot Dimensions91X167
  • Acres0.35

Listing Brokerage: Crye-Leike, Inc., REALTORS
Listing Agent: Tina Dorow (615) 982-0260

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of June 21, 2025 5:04pm. 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