stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Coming Soon
            [changed] => 2024-06-20T01:02:04
        )

    [ml_number] => 2668801
    [price] => stdClass Object
        (
            [amount] => 399900
            [original] => 399900
            [last_changed_on] => 2024-06-19T14:35:01
        )

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

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

    [description] => Welcome Home to this spacious 4 bedroom 2.5 bathroom in Sycamore Ridge! Inside you are greeted by a spacious open floorplan with that seamlessly blends the living spaces. The kitchen features white cabinets, granite countertops, SS appliances, pantry and oversized island. The second floor features the primary suite with walk in closet, dual vanities and walk in shower. Three remaining bedrooms all with ample closet space, shared bath and second floor laundry. Outside is a extended concrete and paver patio and level fenced yard. Great location and community- Check out the 3D tour online and schedule a private viewing today!
    [location] => stdClass Object
        (
            [city] => Ashland City
            [state] => Tennessee
            [postal_code] => 37015
            [county] => Cheatham County, TN
            [subdivision] => Sycamore Ridge Phase 2
            [street] => stdClass Object
                (
                    [number] => 9158
                    [name] => War Eagles Way
                    [full] => 9158 War Eagles Way
                )

            [directions] => From Ashland City Courthouse take TN-49N 6.8 miles until you arrive at War Eagle Way on your left. Take War Eagle Way 0.2 miles and your destination will be on your left.
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.365206
                    [longitude] => -87.047868
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.047868
                                    [1] => 36.365206
                                )

                        )

                )

        )

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

            [construction] => Array
                (
                    [0] => Brick
                    [1] => Vinyl Siding
                )

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

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

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

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Entry Foyer
                    [2] => Extra Closets
                    [3] => Pantry
                    [4] => Walk-In Closet(s)
                    [5] => Kitchen Island
                )

            [appliances] => Array
                (
                    [0] => Dishwasher
                    [1] => Microwave
                    [2] => Refrigerator
                )

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

                )

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

        )

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

            [parking] => Array
                (
                    [0] => Attached - Front
                    [1] => Concrete
                    [2] => Driveway
                )

            [parking_spaces] => 2
            [features] => Array
                (
                    [0] => Garage Door Opener
                )

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [acres] => 0.11
                        )

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

                )

            [school] => stdClass Object
                (
                    [elementary] => Ashland City Elementary
                    [junior] => Cheatham Middle School
                    [high] => Cheatham Co Central
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2024-06-22T19:01:04Z
        )

    [office] => stdClass Object
        (
            [name] => Redfin
            [broker_id] => 3525
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Bob
                            [last] => Poyo
                        )

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

                    [agent_id] => 60647
                )

        )

    [media] => stdClass Object
        (
            [virtual_tours] => Array
                (
                    [0] => https://my.matterport.com/show/?m=AbN4j5kph7D&brand=0&mls=1&
                )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2668801
    [added_at] => stdClass Object
        (
            [$date] => 2024-06-18T22:21:00Z
        )

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

    Interior Details

  • Bedrooms4
  • Bathrooms2
  • Half Baths1
  • FeaturesCeiling Fan(s), Entry Foyer, Extra Closets, Pantry, Walk-In Closet(s), Kitchen Island
  • AppliancesDishwasher, Microwave, Refrigerator
  • HVACArray

    Exterior Details

  • StyleTraditional
  • ConstructionBrick, Vinyl Siding
  • Built In2021
  • Stories2
  • ParkingAttached - Front, Concrete, Driveway
  • Garage Bays2
  • FeaturesGarage Door Opener
  • SewerPublic Sewer
  • Lot DescriptionLevel
  • Acres0.11

Listing Brokerage: Redfin
Listing Agent: Bob Poyo (847) 529-4700

Listings courtesy of Realtracs as distributed by MLS GRID

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