stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-08-11T20:48:00
        )

    [ml_number] => 2958465
    [price] => stdClass Object
        (
            [amount] => 499000
            [original] => 499000
            [last_changed_on] => 2025-08-11T20:48:00
        )

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

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

    [description] => Beautiful home on half an acre with 3 sides brick and detailed exterior stone work. The corner lot makes it one of the largest, tree'd lots in Cambria Subdivision.  This home features an open floor plan, soaring ceilings, hardwood and tile floors, custom cabinets, beautiful remodeled chefs kitchen with quartz countertops, glass rinser at the sink and gas stove! Freshly painted with timeless neutral colors that enhance light and space in primary areas. Extra countertop space for a barista bar, crafts, baking or entertaining- convenient beverage fridge just below. Huge bonus room with extra attic storage! Plenty room for backyard  gatherings. Don't miss the garage screen that most neighbors envy and be sure to check out the extra storage closet with built in small pet door in garage. Large HVAC for main level and hot water heater replaced in 2021. Minutes to I65, shops, parks, schools and the brand-new Publix just minutes away. Shed in back does not convey.
    [location] => stdClass Object
        (
            [city] => White House
            [state] => Tennessee
            [postal_code] => 37188
            [county] => Sumner County, TN
            [subdivision] => Cambria Phase 1
            [street] => stdClass Object
                (
                    [number] => 100
                    [name] => Artesa Dr
                    [full] => 100 Artesa Dr
                )

            [directions] => I-65N exit 108 turn right onto Hwy 76 then right on Raymond Hirsch turn right onto 31W left onto Cedar Brook then right onto McCurdy then  Left on Cambria. Go to Round About and home will be on corner. Sign in yard.
        )

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

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

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

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

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

                )

            [appliances] => Array
                (
                    [0] => Built-In Gas Oven
                )

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

                )

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

        )

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

            [parking] => Array
                (
                    [0] => Garage Faces Side
                )

            [parking_spaces] => 2
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 113.92 X 133.58 IRR
                        )

                )

            [school] => stdClass Object
                (
                    [elementary] => Harold B. Williams Elementary School
                    [junior] => White House Middle School
                    [high] => White House High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-08-12T00:48:00Z
        )

    [office] => stdClass Object
        (
            [name] => simpliHOM
            [broker_id] => 4877
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Amber
                            [last] => Carlson
                        )

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

                    [agent_id] => 24964
                )

        )

    [media] => stdClass Object
        (
            [photos] => Array
                (
                    [0] => stdClass Object
                        (
                            [position] => 0
                            [description] => Half an acre lot. Night lighting. fresh mulch. Sought after and well maintained neighborhood.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2958465/0.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2958465/0/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2958465/0/440x.jpg
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2958465
    [added_at] => stdClass Object
        (
            [$date] => 2025-08-03T21:02:19Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms2
  • BasementCrawl Space
  • AppliancesBuilt-In Gas Oven
  • HVACArray
  • Fireplaces1

    Exterior Details

  • ConstructionBrick, Vinyl Siding
  • Built In2007
  • Stories2
  • ParkingGarage Faces Side
  • Garage Bays2
  • SewerPublic Sewer
  • Lot Dimensions113.92 X 133.58 IRR

Listing Brokerage: simpliHOM
Listing Agent: Amber Carlson (615) 438-8728

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of August 20, 2025 11:26pm. 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