stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-04-16T19:54:00
        )

    [ml_number] => 2819019
    [price] => stdClass Object
        (
            [amount] => 547985
            [original] => 547985
            [last_changed_on] => 2025-04-16T19:54:00
        )

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

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

    [description] => Near Indian Lake shopping, near Main St. near multiple marinas. Fully renovated modern ranch located in the heart of Hendersonville, TN. This beautifully updated 4-bedroom, 3-bathroom home offers a perfect blend of country living and lakefront charm. Situated on over half an acre, this one-level home features an open concept design, new 2" Red Oak hardwood floors, quartz and butcher block countertops, brand new smart appliances and two primary bedrooms with full bathrooms on opposite sides of the home. The primary bedroom with a private entrance is ideal for an in-law suite or could be used for rental income. This renovation was taken down to the studs and brought back to life meticulously and with city oversight - enjoy peace of mind with all inspections passed and recent updates, including a new roof, new fascia/soffit/gutters, new porch and deck, new plumbing, ducts, electrical and well-maintained water heater and HVAC. The massive storage barn adds even more convenience to the property. Enjoy those cool nights next to the fire pit! No HOA. This home is move-in ready!!
    [location] => stdClass Object
        (
            [city] => Hendersonville
            [state] => Tennessee
            [postal_code] => 37075
            [county] => Sumner County, TN
            [subdivision] => Forest Retreat
            [street] => stdClass Object
                (
                    [number] => 124
                    [name] => Forest Retreat Rd
                    [full] => 124 Forest Retreat Rd
                )

            [directions] => Directions: Gallatin Pike North / Main St. into Hendersonville. Turn left onto Forest Retreat Rd. House in on Right side.
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.30645
                    [longitude] => -86.641532
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -86.641532
                                    [1] => 36.30645
                                )

                        )

                )

        )

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

            [construction] => Array
                (
                    [0] => Brick
                    [1] => Fiber Cement
                )

            [square_feet] => stdClass Object
                (
                    [size] => 1800
                    [source] => Owner
                )

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

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

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

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Extra Closets
                    [2] => In-Law Floorplan
                    [3] => Open Floorplan
                    [4] => Pantry
                    [5] => Storage
                    [6] => Walk-In Closet(s)
                    [7] => High Speed Internet
                    [8] => Kitchen Island
                )

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

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

                )

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

        )

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

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

            [features] => Array
                (
                    [0] => Storage Building
                )

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 90X236M IRR
                            [acres] => 0.65
                        )

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

                )

            [school] => stdClass Object
                (
                    [elementary] => Gene W. Brown Elementary
                    [junior] => V G Hawkins Middle School
                    [high] => Hendersonville High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-04-28T19:45:00Z
        )

    [office] => stdClass Object
        (
            [name] => Benchmark Realty, LLC
            [broker_id] => 4009
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Francisco
                            [middle] => Javier
                            [last] => Melgar
                        )

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

                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2819019
    [added_at] => stdClass Object
        (
            [$date] => 2025-04-16T23:54:00Z
        )

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

    Interior Details

  • Bedrooms4
  • Bathrooms3
  • BasementCrawl Space
  • FeaturesCeiling Fan(s), Extra Closets, In-Law Floorplan, Open Floorplan, Pantry, Storage, Walk-In Closet(s), High Speed Internet, Kitchen Island
  • AppliancesElectric Oven, Electric Range, Dishwasher, Disposal, Ice Maker, Microwave, Refrigerator, Stainless Steel Appliance(s), Smart Appliance(s)
  • HVACArray

    Exterior Details

  • StyleRanch
  • ConstructionBrick, Fiber Cement
  • Built In1973
  • Stories1
  • ParkingConcrete
  • FeaturesStorage Building
  • SewerSeptic Tank
  • Lot DescriptionLevel
  • Lot Dimensions90X236M IRR
  • Acres0.65

Listing Brokerage: Benchmark Realty, LLC
Listing Agent: Francisco Melgar (615) 663-8811

Listings courtesy of Realtracs as distributed by MLS GRID

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