stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-09-06T15:48:00
        )

    [ml_number] => 2975382
    [price] => stdClass Object
        (
            [amount] => 229900
            [original] => 229900
            [last_changed_on] => 2025-09-06T15:48:00
        )

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

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

    [description] => AMAZING investment opportunity!!! Unique, natural stone-built 4 bed, 1.5 bath home with spacious FULLY FENCED yard, with 50k wrought iron two-car carport, private pea gravel driveway and porch, massive 16x32 Haywood IN-GROUND POOL with waterslide and diving board, with NEW Haywood sand filter and pump, full length covered back patio and covered front porch. Walk right into the open foyer with huge windows and natural light to find so much potential! Bedrooms are all spaced out and will offer privacy, separate pantry beside kitchen, and huge walk-in laundry room with washer/dryer and cabinets for storage. Floor to ceiling, buck-stove fireplace in back bedroom with heater blowers!!  Listed as a manufactured home on the tax card because *some* parts were brought in originally, but home is closer to a SITE-BUILT home. Stonework was done by a master masonry and estimated to cost over 75k alone, foundation is incredibly solid, and the previous appraiser classified it as site built on the appraisal when it sold last. Home does need a lot of work, but seller is MOTIVATED and ready to sell at an unbeatable price for a quick close. Will be perfect for an investor as a fix/flip OR for a family that is ready to make renovations and get a great home with in-ground in a desirable location at a great price. Wheelchair accessible ramp wraps around to the back of the house, through shrubbery, trees, and vines, creating a private oasis in the back yard where you can relax on the patio while the kids swim in the pool!  Storage shed with working electric REMAINS.  Sitting at the end of a cul-de-sac, the private driveway, fenced acre of land, and shrubbery really make you feel separated / secluded from the neighbors.  ***NO HOA and NO restrictions*** VERY motivated to sell so ***bring us an offer!!*** Selling AS-IS and OPEN to ALL offers!!  Seller will need a week or two occupancy post closing. Please give 1 hr. notice for showings. Property condition disclosure attached to the listing.
    [location] => stdClass Object
        (
            [city] => Mount Juliet
            [state] => Tennessee
            [postal_code] => 37122
            [county] => Wilson County, TN
            [subdivision] => Terrace Hills 3
            [street] => stdClass Object
                (
                    [number] => 653
                    [name] => Terrace Hill Rd
                    [full] => 653 Terrace Hill Rd
                )

            [directions] => I-40 East Exit 226B Mt Juliet Rd North. Right onto Lebanon Rd about two miles. Left onto Terrace Hill. Home is at the end of the cul-de-sac on the left.
        )

    [building] => stdClass Object
        (
            [construction] => Array
                (
                    [0] => Stone
                    [1] => Vinyl Siding
                )

            [square_feet] => stdClass Object
                (
                    [size] => 1691
                    [source] => Professional Measurement
                )

            [stories] => 1
            [built_in] => 1980
            [rooms] => stdClass Object
                (
                    [bed] => stdClass Object
                        (
                            [count] => 4
                        )

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

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

                )

            [pool] => Array
                (
                    [0] => In Ground
                )

            [features] => Array
                (
                    [0] => Built-in Features
                    [1] => Ceiling Fan(s)
                    [2] => Entrance Foyer
                    [3] => Pantry
                    [4] => High Speed Internet
                )

            [appliances] => Array
                (
                    [0] => Electric Oven
                    [1] => Cooktop
                    [2] => Dishwasher
                    [3] => Dryer
                    [4] => Microwave
                    [5] => Refrigerator
                    [6] => Washer
                )

            [hvac] => Array
                (
                    [0] => Array
                        (
                            [0] => Central Air
                            [1] => Wall/Window Unit(s)
                        )

                )

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

        )

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

            [parking] => Array
                (
                    [0] => Private
                )

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 104 X 171 M IRR
                            [acres] => 0.39
                        )

                    [description] => Array
                        (
                            [0] => Cul-De-Sac
                            [1] => Private
                        )

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-09-06T19:48:00Z
        )

    [office] => stdClass Object
        (
            [name] => VOLUME Realty
            [broker_id] => 33657
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Aly
                            [last] => Clifton
                        )

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

                    [agent_id] => 57149
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2975382
    [added_at] => stdClass Object
        (
            [$date] => 2025-08-31T15:00:01Z
        )

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

    Interior Details

  • Bedrooms4
  • Bathrooms1
  • Half Baths1
  • BasementCrawl Space
  • FeaturesBuilt-in Features, Ceiling Fan(s), Entrance Foyer, Pantry, High Speed Internet
  • AppliancesElectric Oven, Cooktop, Dishwasher, Dryer, Microwave, Refrigerator, Washer
  • HVACCentral Air, Wall/Window Unit(s)

    Exterior Details

  • ConstructionStone, Vinyl Siding
  • Built In1980
  • Stories1
  • PoolIn Ground
  • ParkingPrivate
  • SewerPublic Sewer
  • Lot DescriptionCul-De-Sac, Private
  • Lot Dimensions104 X 171 M IRR
  • Acres0.39

Listing Brokerage: VOLUME Realty
Listing Agent: Aly Clifton (615) 712-0628

Listings courtesy of Realtracs as distributed by MLS GRID

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