stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-07-08T11:37:00
        )

    [ml_number] => 2928115
    [price] => stdClass Object
        (
            [amount] => 469900
            [original] => 469900
            [last_changed_on] => 2025-07-08T11:37:00
        )

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

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

    [description] => "The Elizabeth" Built by Core Construction LLC. Grand 2 Story Foyer Welcomes You In! Large Living Rm w/ Stone FP & Floating Mantle! Kitchen Features a Massive Island w/ an Extended Countertop for Wraparound Seating; Double Oven, Cooktop, Granite Tops, HUGE Walk-in Pantry w/ a Decorative Door, Open Eat-in Area, Finished Storage Area & Lots of Cabinet Space! Spacious Formal Dining Rm w/ Wainscoting & a Coffered Ceiling! Downstairs there is also a Large Guest Rm or Office w/ a Beautiful Glass Door! Primary Suite is the Presidential Suite of Bedrms! It Features a Double Tray Ceiling, En Suite Bathrm w/ a Tile Shower, Soaking Tub, Huge Double Vanity, Toilet Closet & a Double Octagonal Tray Ceiling w/ LED Lighting in Both Trays! Through the Bathrm is a Private Hall that Leads to 2 Large Walk-In Closets, a Linen Closet & Private Access into the Laundry Rm!!! Large Guest Rms Upstairs ALL w/ Walk-in Closets! SPC Flooring Throughout Main Areas, Tile in all Wet Areas, Crown Molding, Custom Trim & a Large Covered Patio!
    [location] => stdClass Object
        (
            [city] => Clarksville
            [state] => Tennessee
            [postal_code] => 37042
            [county] => Montgomery County, TN
            [subdivision] => Sycamore Hill
            [street] => stdClass Object
                (
                    [number] => 70
                    [name] => Sycamore Hill
                    [full] => 70 Sycamore Hill
                )

            [directions] => Head West on Purple Heart Pkwy, Right onto Lafayette Rd, Right onto Sycamore Hill Dr, Continue Straight onto Sycamore Hill Ct, Home will be on the Right. Physical Address: 189 Sycamore Hill Ct.
        )

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

            [square_feet] => stdClass Object
                (
                    [size] => 2775
                )

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

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

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Entrance Foyer
                    [2] => Extra Closets
                    [3] => High Ceilings
                    [4] => Open Floorplan
                    [5] => Pantry
                    [6] => Storage
                    [7] => Walk-In Closet(s)
                )

            [appliances] => Array
                (
                    [0] => Double Oven
                    [1] => Cooktop
                    [2] => Dishwasher
                    [3] => Disposal
                    [4] => Microwave
                    [5] => Stainless Steel Appliance(s)
                    [6] => Smart Appliance(s)
                )

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

                )

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

        )

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

            [services] => Array
                (
                    [0] => Playground
                    [1] => Sidewalks
                    [2] => Underground Utilities
                )

            [parking] => Array
                (
                    [0] => Garage Door Opener
                    [1] => Attached
                    [2] => Concrete
                    [3] => Driveway
                )

            [parking_spaces] => 2
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 142x79x129x62
                        )

                )

            [school] => stdClass Object
                (
                    [elementary] => Minglewood Elementary
                    [junior] => New Providence Middle
                    [high] => Northwest High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-07-08T15:37:00Z
        )

    [office] => stdClass Object
        (
            [name] => Keller Williams Realty
            [broker_id] => 851
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Laura
                            [last] => Stasko
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 9315515076
                            [mobile] => 9315515076
                            [fax] => 9316488551
                        )

                    [agent_id] => 32524
                )

        )

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

                        )

                    [1] => stdClass Object
                        (
                            [position] => 1
                            [description] => EXAMPLE>>>Large 2 Story Entry Foyer with an Elegant Staircase with Rod Iron Spindles & a Beautiful Chandelier!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/1.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/1/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/1/440x.jpg
                                )

                        )

                    [2] => stdClass Object
                        (
                            [position] => 2
                            [description] => EXAMPLE>>>Another View of the Entry Foyer!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/2.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/2/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/2/440x.jpg
                                )

                        )

                    [3] => stdClass Object
                        (
                            [position] => 3
                            [description] => EXAMPLE>>>Downstairs Guest Bedroom or Office with a Beautiful Glass Door!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/3.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/3/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/3/440x.jpg
                                )

                        )

                    [4] => stdClass Object
                        (
                            [position] => 4
                            [description] => EXAMPLE>>>Large Living Room with a Stone Fireplace, Floating Wood Mantle, Recessed Lighting, Crown Molding and Access to the Large Covered Patio!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/4.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/4/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/4/440x.jpg
                                )

                        )

                    [5] => stdClass Object
                        (
                            [position] => 5
                            [description] => EXAMPLE>>>Open Layout Downstairs and SPC Flooring Throughout the Foyer, Downstairs Hallway, Living Room, Kitchen and Dining Room!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/5.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/5/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/5/440x.jpg
                                )

                        )

                    [6] => stdClass Object
                        (
                            [position] => 6
                            [description] => EXAMPLE>>>Large Kitchen with a Cooktop, Smart Double Oven, Granite Countertops, Tile Backsplash, Recessed Lighting, Large Island and Lots of Cabinetry - All with Soft Close Doors and Drawers!!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/6.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/6/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/6/440x.jpg
                                )

                        )

                    [7] => stdClass Object
                        (
                            [position] => 7
                            [description] => EXAMPLE>>>Another View of the Kitchen! There's Even a Finished Storage Area!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/7.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/7/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/7/440x.jpg
                                )

                        )

                    [8] => stdClass Object
                        (
                            [position] => 8
                            [description] => EXAMPLE>>>Cooktop, Double Oven and a Decorative Glass Pantry Door!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/8.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/8/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/8/440x.jpg
                                )

                        )

                    [9] => stdClass Object
                        (
                            [position] => 9
                            [description] => EXAMPLE>>>HUGE Pantry with TONS of Shelving!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/9.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/9/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/9/440x.jpg
                                )

                        )

                    [10] => stdClass Object
                        (
                            [position] => 10
                            [description] => EXAMPLE>>>Large Formal Dining Room with Chair Railing, Wainscoting and Coffered Ceiling!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/10.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/10/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/10/440x.jpg
                                )

                        )

                    [11] => stdClass Object
                        (
                            [position] => 11
                            [description] => EXAMPLE>>>Large Open Upstairs Hallway with an Overlook to the Foyer!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/11.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/11/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/11/440x.jpg
                                )

                        )

                    [12] => stdClass Object
                        (
                            [position] => 12
                            [description] => EXAMPLE>>>You Will Fall in Love with the Primary Suite! Not Only is there an AMAZING En Suite Bathroom, there's also a Hallway from the Bathroom Leading to TWO Walk-In Closets, a Linen Closet and Private Access into the Laundry Room!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/12.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/12/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/12/440x.jpg
                                )

                        )

                    [13] => stdClass Object
                        (
                            [position] => 13
                            [description] => EXAMPLE>>>Primary Bedroom Features a Double Tray Ceiling, Crown Molding and Recessed Lighting!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/13.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/13/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/13/440x.jpg
                                )

                        )

                    [14] => stdClass Object
                        (
                            [position] => 14
                            [description] => EXAMPLE>>>Amazing Primary Bathroom Features Tile Flooring, Recessed Lighting, a Gorgeous Double Tray Ceiling with Lighting, Crown Molding, a Tile Shower, Soaker Tub, Huge Double Vanity and a Toilet Room!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/14.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/14/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/14/440x.jpg
                                )

                        )

                    [15] => stdClass Object
                        (
                            [position] => 15
                            [description] => EXAMPLE>>>Double Vanity with Cosmetic Vanity in the Middle! Lots of Cabinet Storage, Modern Lighting and Large Mirrors!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/15.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/15/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/15/440x.jpg
                                )

                        )

                    [16] => stdClass Object
                        (
                            [position] => 16
                            [description] => EXAMPLE>>>Large Soaker Tub and Beautiful Tile Shower with a Bench!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/16.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/16/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/16/440x.jpg
                                )

                        )

                    [17] => stdClass Object
                        (
                            [position] => 17
                            [description] => EXAMPLE>>>Double Tray Ceiling with LED Lighting in Both Trays! Lights Have Multiple Color Options!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/17.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/17/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/17/440x.jpg
                                )

                        )

                    [18] => stdClass Object
                        (
                            [position] => 18
                            [description] => EXAMPLE>>>One of the Walk-in Closets, This One Has Built-In Shelving and a Bench!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/18.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/18/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/18/440x.jpg
                                )

                        )

                    [19] => stdClass Object
                        (
                            [position] => 19
                            [description] => EXAMPLE>>>The Other Walk-in Closet! Tons of Shelving and Natural Lighting!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/19.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/19/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/19/440x.jpg
                                )

                        )

                    [20] => stdClass Object
                        (
                            [position] => 20
                            [description] => EXAMPLE>>>Large Laundry Room with Tile Flooring and Shelving! Laundry Connects to the Primary Closet Hallway and The Main Hallway!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/20.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/20/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/20/440x.jpg
                                )

                        )

                    [21] => stdClass Object
                        (
                            [position] => 21
                            [description] => EXAMPLE>>>Guest Bathroom has a Large Double Vanity with TONS of Storage & a Separate Shower/Toilet Area!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/21.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/21/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/21/440x.jpg
                                )

                        )

                    [22] => stdClass Object
                        (
                            [position] => 22
                            [description] => EXAMPLE>>>Storage Space Inside of one of the Primary Bedroom Closets!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/22.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/22/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/22/440x.jpg
                                )

                        )

                    [23] => stdClass Object
                        (
                            [position] => 23
                            [description] => EXAMPLE>>>Another Storage Space Inside the Other Primary Bedroom Closet!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/23.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/23/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/23/440x.jpg
                                )

                        )

                    [24] => stdClass Object
                        (
                            [position] => 24
                            [description] => EXAMPLE>>>Large Covered Deck with Ceiling Fan! Perfect for Entertaining! (Deck or Patio Depending on Grade of Lot!)
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2928115/24.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2928115/24/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2928115/24/440x.jpg
                                )

                        )

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

                        )

                )

        )

    [key] => rt-2928115
    [added_at] => stdClass Object
        (
            [$date] => 2025-07-08T15:37:00Z
        )

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

    Interior Details

  • Bedrooms5
  • Bathrooms3
  • FeaturesCeiling Fan(s), Entrance Foyer, Extra Closets, High Ceilings, Open Floorplan, Pantry, Storage, Walk-In Closet(s)
  • AppliancesDouble Oven, Cooktop, Dishwasher, Disposal, Microwave, Stainless Steel Appliance(s), Smart Appliance(s)
  • HVACArray
  • Fireplaces1

    Exterior Details

  • ConstructionBrick, Vinyl Siding
  • Built In2025
  • Stories2
  • ParkingGarage Door Opener, Attached, Concrete, Driveway
  • Garage Bays2
  • ServicesPlayground, Sidewalks, Underground Utilities
  • SewerPublic Sewer
  • Lot Dimensions142x79x129x62

Request Information