stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-07-07T14:29:01
        )

    [ml_number] => 2929642
    [price] => stdClass Object
        (
            [amount] => 599900
            [original] => 599900
            [last_changed_on] => 2025-07-07T14:29:01
        )

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

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

    [description] => Coming soon to Bear Creek Overlook in Columbia.  (Home is at frame stage in early July) Abundant main level living with 3 bedrooms and study on the first floor!  Level home site with minimal steps. Main level includes private study, primary suite with walk-in shower, large vanity and huge walk-in closet.  Family room with tray ceiling and cedar beams, fireplace and Revwood flooring.  Outdoor living space adjacent the family room.  Beautiful cabinetry, quartz counters, tile, trim and more.  2 Car garage.  The second level features a functional game room, bedroom w/WIC, full bath and walk-in storage.  Home automation package included.  Ask about generous finance incentives with our preferred lender.
    [location] => stdClass Object
        (
            [city] => Columbia
            [state] => Tennessee
            [postal_code] => 38401
            [county] => Maury County, TN
            [subdivision] => Bear Creek Overlook
            [street] => stdClass Object
                (
                    [number] => 1925
                    [name] => Hildebrand Lane
                    [full] => 1925 Hildebrand Lane
                )

            [directions] => From Nashville, take I65 South to exit 46. Take a left turn onto Bear Creek Pike. Community is .25 miles on the right. Turn right onto Hildebrand at intersection and follow past amenity center. Home is ahead on the left.
            [coordinates] => stdClass Object
                (
                    [latitude] => 35.641636
                    [longitude] => -86.888794
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -86.888794
                                    [1] => 35.641636
                                )

                        )

                )

        )

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

            [construction] => Array
                (
                    [0] => Brick
                    [1] => Fiber Cement
                )

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

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

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

                )

            [features] => Array
                (
                    [0] => Entrance Foyer
                    [1] => Extra Closets
                    [2] => Open Floorplan
                    [3] => Pantry
                    [4] => Smart Light(s)
                    [5] => Smart Thermostat
                    [6] => Walk-In Closet(s)
                    [7] => High Speed Internet
                    [8] => Kitchen Island
                )

            [appliances] => Array
                (
                    [0] => Built-In Electric Oven
                    [1] => Electric Range
                    [2] => Dishwasher
                    [3] => Disposal
                    [4] => ENERGY STAR Qualified Appliances
                    [5] => Microwave
                    [6] => Stainless Steel 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] => Clubhouse
                    [1] => Dog Park
                    [2] => Playground
                    [3] => Pool
                    [4] => Underground Utilities
                )

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

            [parking_spaces] => 2
            [features] => Array
                (
                    [0] => Smart Light(s)
                    [1] => Smart Lock(s)
                )

            [land] => stdClass Object
                (
                    [description] => Array
                        (
                            [0] => Level
                        )

                )

            [school] => stdClass Object
                (
                    [elementary] => R Howell Elementary
                    [junior] => E. A. Cox Middle School
                    [high] => Columbia Central High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-07-26T16:57:00Z
        )

    [office] => stdClass Object
        (
            [name] => Drees Homes
            [broker_id] => 489
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Laura
                            [middle] => A.
                            [last] => Small
                        )

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

                    [agent_id] => 52748
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2929642
    [added_at] => stdClass Object
        (
            [$date] => 2025-07-07T18:29:01Z
        )

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

    Interior Details

  • Bedrooms4
  • Bathrooms3
  • FeaturesEntrance Foyer, Extra Closets, Open Floorplan, Pantry, Smart Light(s), Smart Thermostat, Walk-In Closet(s), High Speed Internet, Kitchen Island
  • AppliancesBuilt-In Electric Oven, Electric Range, Dishwasher, Disposal, ENERGY STAR Qualified Appliances, Microwave, Stainless Steel Appliance(s)
  • HVACArray
  • Fireplaces1

    Exterior Details

  • StyleContemporary
  • ConstructionBrick, Fiber Cement
  • Built In2025
  • Stories2
  • ParkingGarage Door Opener, Garage Faces Front
  • Garage Bays2
  • FeaturesSmart Light(s), Smart Lock(s)
  • ServicesClubhouse, Dog Park, Playground, Pool, Underground Utilities
  • SewerPublic Sewer
  • Lot DescriptionLevel

Request Information