stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-03-27T20:30:00
        )

    [ml_number] => 2809848
    [price] => stdClass Object
        (
            [amount] => 459900
            [original] => 459900
            [last_changed_on] => 2025-03-27T20:30:00
        )

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

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

    [description] => All brick on large corner lot, New roof, new windows, new HVAC, new storm doors, granite counter tops, hardwood and laminate floors, farm sink, circular driveway. Original garage has been converted to living space and would make a great office/exercise/playroom/den.
    [location] => stdClass Object
        (
            [city] => Mount Juliet
            [state] => Tennessee
            [postal_code] => 37122
            [county] => Wilson County, TN
            [subdivision] => Edgewater Est Sec 2
            [street] => stdClass Object
                (
                    [number] => 240
                    [name] => NW Clearview Dr
                    [full] => 240 NW Clearview Dr
                )

            [directions] => Lebanon Rd East, Left on Andrew Jackson/Saundersville Rd, Left on Saundersville Ferry, Left on Edgewater Dr, Left on NW Clearview Dr, property is on the right
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.267856
                    [longitude] => -86.559327
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -86.559327
                                    [1] => 36.267856
                                )

                        )

                )

        )

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

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

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

            [stories] => 1
            [built_in] => 1972
            [rooms] => stdClass Object
                (
                    [bed] => stdClass Object
                        (
                            [count] => 3
                        )

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

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

                )

            [appliances] => Array
                (
                    [0] => Electric Oven
                    [1] => Electric Range
                    [2] => Dishwasher
                    [3] => Microwave
                )

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

                )

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

        )

    [surroundings] => stdClass Object
        (
            [sewer] => Array
                (
                    [0] => Septic Tank
                )

            [parking] => Array
                (
                    [0] => Circular Driveway
                    [1] => Concrete
                )

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 135 X 180 IRR
                            [acres] => 0.49
                        )

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

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-04-11T18:03:44Z
        )

    [office] => stdClass Object
        (
            [name] => Coldwell Banker Southern Realty
            [broker_id] => 332
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Judy
                            [last] => Hughes
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 6154295646
                            [mobile] => 6154295646
                            [fax] => 6157580406
                        )

                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [29] => stdClass Object
                        (
                            [position] => 29
                            [description] => View from the Living Room window
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2809848/29.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2809848/29/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2809848/29/440x.jpg
                                )

                        )

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

                        )

                )

        )

    [key] => rt-2809848
    [added_at] => stdClass Object
        (
            [$date] => 2025-03-28T00:30:00Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms1
  • Half Baths1
  • BasementCrawl Space
  • AppliancesElectric Oven, Electric Range, Dishwasher, Microwave
  • HVACArray

    Exterior Details

  • StyleRanch
  • ConstructionBrick
  • Built In1972
  • Stories1
  • ParkingCircular Driveway, Concrete
  • SewerSeptic Tank
  • Lot DescriptionSloped
  • Lot Dimensions135 X 180 IRR
  • Acres0.49

Listing Brokerage: Coldwell Banker Southern Realty
Listing Agent: Judy Hughes (615) 429-5646

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of May 13, 2025 7:37am. 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