stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active Under Contract
            [last] => Active
            [changed] => 2025-04-12T21:13:00
        )

    [ml_number] => 2813238
    [price] => stdClass Object
        (
            [amount] => 580000
            [original] => 580000
            [last_changed_on] => 2025-04-03T18:21:00
        )

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

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

    [description] => **MULTIPLE OFFERS RECEIVED! A Very Rare Opportunity in Coveted Clearview Estates! An Absolutely Phenomenal Setting on Almost an Acre, Backing up to Treeline and Farm with Mature Trees and Manicured Lawn. This Home Boasts a Beautifully Updated Kitchen / Dining, Great Room with Fireplace, Owner's Suite and Two Additional Bedrooms & Full Bath All on Main Level! The 2nd Floor Separate Oversized Bonus Room Can Also Serve as a 4th Bedroom. Custom Trim work and Detailed Ceilings Offer So Much Character Throughout. Rear-Entry Garage, Fully Fenced Yard, Large Deck, and Separate Storage Shed in Back Are Just a Few of the Extras This Beautiful Home Has to Offer! There's Even Approx 1000ft² of Space on 2nd Story That Could be Finished to Add More Bedrooms, Bathroom, Bonus Space, etc!
    [location] => stdClass Object
        (
            [city] => Mount Juliet
            [state] => Tennessee
            [postal_code] => 37122
            [county] => Wilson County, TN
            [subdivision] => Clearview 4
            [street] => stdClass Object
                (
                    [number] => 1710
                    [name] => Valleyview Dr
                    [full] => 1710 Valleyview Dr
                )

            [directions] => Exit I-40 to 226B North Mount Juliet Rd. North approx 1 Mile. Left on Weston Dr, 0.3 Miles then Right on Fairview Dr, Quick Left on Valleyview. 0.2 Miles, Home will be on the Right.
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.189632
                    [longitude] => -86.518682
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -86.518682
                                    [1] => 36.189632
                                )

                        )

                )

        )

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

            [square_feet] => stdClass Object
                (
                    [size] => 2300
                    [source] => Appraiser
                )

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

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

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

                )

            [features] => Array
                (
                    [0] => Built-in Features
                    [1] => Storage
                    [2] => Primary Bedroom Main Floor
                )

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

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

                )

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

        )

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

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

            [parking_spaces] => 2
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 140X286
                            [acres] => 0.94
                        )

                )

            [school] => stdClass Object
                (
                    [elementary] => Stoner Creek Elementary
                    [junior] => West Wilson Middle School
                    [high] => Mt. Juliet High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-04-13T01:13:00Z
        )

    [office] => stdClass Object
        (
            [name] => Parks Compass
            [broker_id] => 2614
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Christopher
                            [last] => Bagwell
                        )

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

                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2813238
    [added_at] => stdClass Object
        (
            [$date] => 2025-04-03T22:21:00Z
        )

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

    Interior Details

  • Bedrooms4
  • Bathrooms2
  • BasementCrawl Space
  • FeaturesBuilt-in Features, Storage, Primary Bedroom Main Floor
  • AppliancesRange, Dishwasher, Disposal, Ice Maker, Microwave, Refrigerator, Stainless Steel Appliance(s)
  • HVACArray

    Exterior Details

  • ConstructionBrick
  • Built In1983
  • Stories2
  • ParkingGarage Faces Rear
  • Garage Bays2
  • SewerPublic Sewer
  • Lot Dimensions140X286
  • Acres0.94

Listing Brokerage: Parks Compass
Listing Agent: Christopher Bagwell (615) 979-2077

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 4:15am. 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