stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Coming Soon
            [changed] => 2025-05-10T17:02:13
        )

    [ml_number] => 2825201
    [price] => stdClass Object
        (
            [amount] => 500000
            [original] => 500000
            [last_changed_on] => 2025-05-01T08:56:00
        )

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

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

    [description] => Welcome to your peaceful retreat just minutes from the water! This beautifully renovated 3-bedroom, 2.5 bath home and large finished basement offers the perfect blend of comfort, convenience, and outdoor living. Nestled in a quiet neighborhood near the lake, you'll enjoy the best of Mt. Juliet's beauty.  Step inside to find an open layout filled with natural light. The living area flows into a show stopping kitchen, while each bedroom provides a cozy escape with walk-in closets.  Large, fenced-in private yard with huge carport and 2-car garage.  Spacious parking for RVs and boats, because there is No HOA!  Has updated plumbing, electrical, new HVAC, new windows, new kitchen cabinets with quartz countertop, refinished original oak flooring on main, new waterproof LVP in basement, all new kitchen appliances, 3 year old water heater, and roof is 11 years old.
    [location] => stdClass Object
        (
            [city] => Mount Juliet
            [state] => Tennessee
            [postal_code] => 37122
            [county] => Wilson County, TN
            [subdivision] => Edgewater Est Sec 1
            [street] => stdClass Object
                (
                    [number] => 210
                    [name] => NW Clearview Dr
                    [full] => 210 NW Clearview Dr
                )

            [directions] => From Lebanon Rd. North on Andrew Jackson Pkwy. Straight on Saundersville Rd, Left on Saundersville Ferry road. Left on Edgewater. Left on Northwest Clearview. House is on the Right.
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.267117
                    [longitude] => -86.554168
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -86.554168
                                    [1] => 36.267117
                                )

                        )

                )

        )

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

            [square_feet] => stdClass Object
                (
                    [size] => 2000
                    [source] => Agent Measured
                )

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

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

                    [basement] => Array
                        (
                            [0] => Finished
                        )

                )

            [appliances] => Array
                (
                    [0] => Electric Oven
                    [1] => Electric Range
                    [2] => Dishwasher
                    [3] => Dryer
                    [4] => Ice Maker
                    [5] => Microwave
                    [6] => Refrigerator
                    [7] => Stainless Steel Appliance(s)
                    [8] => Washer
                )

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

                )

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

        )

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

            [parking] => Array
                (
                    [0] => Garage Faces Rear
                )

            [parking_spaces] => 2
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 110 X 129 IRR
                            [acres] => 0.41
                        )

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-05-10T21:02:13Z
        )

    [office] => stdClass Object
        (
            [name] => Zach Taylor Real Estate
            [broker_id] => 4943
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Brian
                            [last] => Maples
                        )

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

                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2825201
    [added_at] => stdClass Object
        (
            [$date] => 2025-05-01T12:56:00Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms2
  • Half Baths1
  • BasementFinished
  • AppliancesElectric Oven, Electric Range, Dishwasher, Dryer, Ice Maker, Microwave, Refrigerator, Stainless Steel Appliance(s), Washer
  • HVACArray

    Exterior Details

  • ConstructionBrick
  • Built In1967
  • Stories1
  • ParkingGarage Faces Rear
  • Garage Bays2
  • SewerSeptic Tank
  • Lot Dimensions110 X 129 IRR
  • Acres0.41

Listing Brokerage: Zach Taylor Real Estate
Listing Agent: Brian Maples (615) 609-6528

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 3:22pm. 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