stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-06-21T01:02:06
        )

    [ml_number] => 2920805
    [price] => stdClass Object
        (
            [amount] => 599000
            [original] => 575000
            [last_changed_on] => 2025-07-14T15:14:00
        )

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

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

    [description] => Welcome Home Manchester, TN! This beautiful new construction home over 10 acres of Little Duck Riverfront Oasis is waiting for you! Come enjoy the convenience of city living all while feeling like you are in the wilderness.  Nearly two acres of cleared back yard for family and critters alike to roam!  Open floorplan with primary bedroom w/ ensuite bath on main!  Upscale kitchen with stone counters and stainless appliances and half bath down!    3 Bedrooms and 2 full bathrooms up as well as an office and a bonus room!  Call listing agent today and schedule your showing before this opportunity floats on by!
    [location] => stdClass Object
        (
            [city] => Manchester
            [state] => Tennessee
            [postal_code] => 37355
            [county] => Coffee County, TN
            [street] => stdClass Object
                (
                    [number] => 499
                    [name] => Shelton Rd
                    [full] => 499 Shelton Rd
                )

            [directions] => I-24, exit 111 for hwy 55 TN W toward Manchester, merge onto TN-55W, turn left onto Hillsboro Blvd, left onto Shelton road. Continue on Shelton Road, past Dead End Sign, continue on Shelton. House located on the left Lot 3, 499 Shelton Road, long driveway
            [coordinates] => stdClass Object
                (
                    [latitude] => 35.468119
                    [longitude] => -86.063884
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -86.063884
                                    [1] => 35.468119
                                )

                        )

                )

        )

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

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

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

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

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Extra Closets
                    [2] => High Ceilings
                    [3] => Open Floorplan
                    [4] => Storage
                    [5] => Walk-In Closet(s)
                    [6] => Primary Bedroom Main Floor
                    [7] => High Speed Internet
                )

            [appliances] => Array
                (
                    [0] => Electric Oven
                    [1] => Electric Range
                    [2] => Dishwasher
                )

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

                )

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

        )

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

            [parking] => Array
                (
                    [0] => Garage Faces Front
                    [1] => Driveway
                )

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

                    [description] => Array
                        (
                            [0] => Private
                            [1] => Wooded
                        )

                )

            [school] => stdClass Object
                (
                    [elementary] => College Street Elementary
                    [junior] => Westwood Middle School
                    [high] => Coffee County Central High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-07-14T19:14:00Z
        )

    [office] => stdClass Object
        (
            [name] => Epique Realty
            [broker_id] => 5773
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Chris
                            [last] => Rains
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 8656843603
                            [mobile] => 8656843603
                            [fax] => 6152204237
                        )

                    [agent_id] => 55609
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2920805
    [added_at] => stdClass Object
        (
            [$date] => 2025-06-21T05:02:06Z
        )

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

    Interior Details

  • Bedrooms4
  • Bathrooms3
  • Half Baths1
  • FeaturesCeiling Fan(s), Extra Closets, High Ceilings, Open Floorplan, Storage, Walk-In Closet(s), Primary Bedroom Main Floor, High Speed Internet
  • AppliancesElectric Oven, Electric Range, Dishwasher
  • HVACArray

    Exterior Details

  • ConstructionMasonite
  • Built In2025
  • Stories2
  • ParkingGarage Faces Front, Driveway
  • Garage Bays2
  • SewerPublic Sewer
  • Lot DescriptionPrivate, Wooded
  • Acres10

Listing Brokerage: Epique Realty
Listing Agent: Chris Rains (865) 684-3603

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of July 26, 2025 8:32am. 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