stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-08-21T17:33:00
        )

    [ml_number] => 2976287
    [price] => stdClass Object
        (
            [amount] => 335000
            [original] => 335000
            [last_changed_on] => 2025-08-21T17:33:00
        )

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

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

    [description] => Everything is BRAND NEW in this stunning 3-bedroom, 1-bath home—making it feel like new construction without the price tag! Enjoy peace of mind with a new roof, new HVAC, new electrical throughout, and new subfloors and flooring. The interior features fresh drywall and paint, all-new ceilings, and a beautifully redesigned kitchen with granite countertops, tile backsplash, and brand-new stainless steel appliances. Every inch of this home has been thoughtfully upgraded for modern living. Located in a community with highly rated schools, this home is move-in ready and should be treated as a completely new build. Don't miss your chance to own this turn-key gem!
    [location] => stdClass Object
        (
            [city] => Mount Juliet
            [state] => Tennessee
            [postal_code] => 37122
            [county] => Wilson County, TN
            [subdivision] => Hermitage Plantation Est
            [street] => stdClass Object
                (
                    [number] => 185
                    [name] => Williamsburg Rd NE
                    [full] => 185 Williamsburg Rd NE
                )

            [directions] => I-40, take Exit 226 onto N. Mt. Juliet Rd (SR 171 Turn Left onto Hwy 70 (Lebanon Rd Then in about 4 miles turn right onto Williamsburg
        )

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

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

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

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

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Extra Closets
                    [2] => Walk-In Closet(s)
                )

            [appliances] => Array
                (
                    [0] => Electric Range
                )

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

                )

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

        )

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

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

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 100 X 152.4 IRR
                            [acres] => 0.35
                        )

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-08-21T21:33:00Z
        )

    [office] => stdClass Object
        (
            [name] => Mark Spain Real Estate
            [broker_id] => 4455
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Stephen
                            [middle] => Louis
                            [last] => Caron
                        )

                    [phone] => stdClass Object
                        (
                            [mobile] => 6154763708
                        )

                    [agent_id] => 140871
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2976287
    [added_at] => stdClass Object
        (
            [$date] => 2025-08-21T21:33:00Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms1
  • FeaturesCeiling Fan(s), Extra Closets, Walk-In Closet(s)
  • AppliancesElectric Range
  • HVACCentral Air

    Exterior Details

  • ConstructionVinyl Siding
  • Built In1965
  • Stories1
  • ParkingDriveway
  • SewerPublic Sewer
  • Lot Dimensions100 X 152.4 IRR
  • Acres0.35

Listing Brokerage: Mark Spain Real Estate
Listing Agent: Stephen Caron () -

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 2:42pm. 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