stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Coming Soon
            [last] => Coming Soon
            [changed] => 2025-04-03T13:28:00
        )

    [ml_number] => 2812958
    [price] => stdClass Object
        (
            [amount] => 500000
            [original] => 500000
            [last_changed_on] => 2025-04-03T13:28:00
        )

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

    [description] => Welcome to 943 Overlook Trail, Stewart, TN 37175 — a beautiful new construction home offering modern design, thoughtful features, and incredible flexibility. This 3-bedroom, 2.5-bath home boasts an open floor plan, perfect for both everyday living and entertaining. Natural light flows throughout the living spaces, creating a warm and inviting atmosphere you'll love coming home to.  Step outside and enjoy the outdoors with a covered back porch, a spacious deck, and even a rooftop area, perfect for relaxing or hosting guests. A 2-car garage adds convenience and ample storage.  One of the most unique features of this property is the second build spot on the lot, which already has septic approval. Whether you're envisioning a mother-in-law suite, a second home for extended family, or an Airbnb for extra income, this added space gives you options and potential rarely found.  And the best part? Buyers still have the opportunity to choose their own flooring, tile, and paint, allowing you to personalize the home to fit your exact style and taste.  Don't miss this amazing opportunity to own a versatile, customizable new home with added investment value.
    [location] => stdClass Object
        (
            [city] => Stewart
            [state] => Tennessee
            [postal_code] => 37175
            [county] => Houston County, TN
            [subdivision] => Vista Ridge
            [street] => stdClass Object
                (
                    [number] => 943
                    [name] => Overlook Trl
                    [full] => 943 Overlook Trl
                )

            [directions] => Start by heading west on I-40 W from Nashville.?  Continue on I-40 W for approximately 40 miles.?  Take exit 143 to merge onto TN-13 N toward Waverly.?  Follow TN-13 N for about 20 miles.?  Turn left onto TN-49 W and continue for approximately 10 miles.?
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.285238
                    [longitude] => -87.923355
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.923355
                                    [1] => 36.285238
                                )

                        )

                )

        )

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

            [square_feet] => stdClass Object
                (
                    [size] => 1466
                    [source] => Builder
                )

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

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

                )

            [appliances] => Array
                (
                    [0] => Built-In Electric Range
                )

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

                )

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

        )

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

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

            [parking_spaces] => 2
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [acres] => 15.07
                        )

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-04-10T02:02:00Z
        )

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

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Nechole
                            [last] => Thompson
                        )

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

                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2812958
    [added_at] => stdClass Object
        (
            [$date] => 2025-04-03T17:28:00Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms2
  • Half Baths1
  • AppliancesBuilt-In Electric Range
  • HVACArray

    Exterior Details

  • ConstructionMasonite
  • Built In2025
  • Stories2
  • ParkingAttached
  • Garage Bays2
  • SewerSeptic Tank
  • Acres15.07

Request Information