stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-04-25T21:07:00
        )

    [ml_number] => 2823152
    [price] => stdClass Object
        (
            [amount] => 475000
            [original] => 475000
            [last_changed_on] => 2025-04-25T21:07:00
        )

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

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

    [description] => If you are looking for Lakeside home with a stunning view this is it. Escape to your own private oasis in this stunning waterfront property. Being sold AS-IS. Has breath taking views of the lake, private dock and outdoor escape you will feel that your on a vacation everyday. Boating, fishing, swimming, hiking or just sit on your screened in porch and watch the sun rise and set. Home has 3 bedrooms, 2 full baths, primary with jetted tub. Office, Game room, Kitchen, open dinning area, living room, screened in porch with hot tub, Long front porch length of house. Detached 20 x 50 shop with 2 car carport. Beautiful pine staircase and high pine ceiling beams. Lots of natural light and open floorplan. Must see to appreciate. Danville Boat Dock launch  just down the road.
    [location] => stdClass Object
        (
            [city] => Stewart
            [state] => Tennessee
            [postal_code] => 37175
            [county] => Houston County, TN
            [street] => stdClass Object
                (
                    [number] => 11175
                    [name] => Highway 147
                    [full] => 11175 Highway 147
                )

            [directions] => Take Hwy 48 /TN13 South then turn right on Hwy TN-149 W until you come to Highway 49 west. Turn right on 49 west. Follow 49 west until you come to Highway 147 west. Turn left and follow until you come to home on your left.
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.311501
                    [longitude] => -87.926645
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.926645
                                    [1] => 36.311501
                                )

                        )

                )

        )

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

            [construction] => Array
                (
                    [0] => Wood Siding
                )

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

            [stories] => 2
            [built_in] => 1998
            [rooms] => stdClass Object
                (
                    [bed] => stdClass Object
                        (
                            [count] => 3
                        )

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

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

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Open Floorplan
                    [2] => High Speed Internet
                )

            [appliances] => Array
                (
                    [0] => Oven
                    [1] => Dishwasher
                    [2] => Ice Maker
                    [3] => Microwave
                    [4] => Refrigerator
                )

            [hvac] => Array
                (
                    [0] => Array
                        (
                            [0] => Electric
                        )

                )

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

        )

    [surroundings] => stdClass Object
        (
            [water] => Waterfront
            [sewer] => Array
                (
                    [0] => Private Sewer
                )

            [services] => Array
                (
                    [0] => Boat Dock
                )

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

            [parking_spaces] => 2
            [features] => Array
                (
                    [0] => Dock
                    [1] => Balcony
                )

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 125X225X115X225
                            [acres] => 0.62
                        )

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

                )

            [school] => stdClass Object
                (
                    [elementary] => Tennessee Ridge Elementary
                    [junior] => Houston Co Middle School
                    [high] => Houston Co High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-04-30T18:03:36Z
        )

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

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => David
                            [last] => Sykes
                        )

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

                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2823152
    [added_at] => stdClass Object
        (
            [$date] => 2025-04-26T01:07:00Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms2
  • BasementCrawl Space
  • FeaturesCeiling Fan(s), Open Floorplan, High Speed Internet
  • AppliancesOven, Dishwasher, Ice Maker, Microwave, Refrigerator
  • HVACArray
  • Fireplaces1

    Exterior Details

  • StyleOther
  • ConstructionWood Siding
  • Built In1998
  • Stories2
  • ParkingDetached
  • Garage Bays2
  • FeaturesDock, Balcony
  • ServicesBoat Dock
  • SewerPrivate Sewer
  • Lot DescriptionLevel, Views
  • Lot Dimensions125X225X115X225
  • Acres0.62

Listing Brokerage: Zach Taylor Real Estate
Listing Agent: David Sykes (931) 249-6358

Listings courtesy of Realtracs as distributed by MLS GRID

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