stdClass Object
(
    [type] => Rental
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Coming Soon
            [changed] => 2024-11-08T08:14:00
        )

    [ml_number] => 2754355
    [price] => stdClass Object
        (
            [amount] => 1400
            [original] => 1400
            [last_changed_on] => 2024-10-31T15:24:00
        )

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

    [available_on] => stdClass Object
        (
            [$date] => 2024-11-08T05:00:00Z
        )

    [description] => Brick home near shopping, dining, and hospital.  New granite countertop, new kitchen floor, new blinds, freshly painted, new ductwork, hardwood floors, large screened in patio, large yard, storage building. Flex room could be a 3rd bedroom, hobby room, office, etc.
    [location] => stdClass Object
        (
            [city] => Columbia
            [state] => Tennessee
            [postal_code] => 38401
            [county] => Maury County, TN
            [subdivision] => S W Pk Sec E
            [street] => stdClass Object
                (
                    [number] => 1818
                    [name] => Sunset Ave
                    [full] => 1818 Sunset Ave
                )

            [directions] => Hatcher Lane to Sunset Ave, house on right
            [coordinates] => stdClass Object
                (
                    [latitude] => 35.601518
                    [longitude] => -87.055046
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.055046
                                    [1] => 35.601518
                                )

                        )

                )

        )

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

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

            [stories] => 1
            [built_in] => 1956
            [rooms] => stdClass Object
                (
                    [bed] => stdClass Object
                        (
                            [count] => 2
                        )

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

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

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                )

            [appliances] => Array
                (
                    [0] => Oven
                    [1] => Refrigerator
                )

            [hvac] => Array
                (
                    [0] => Array
                        (
                            [0] => Ceiling Fan(s)
                            [1] => Central Air
                        )

                )

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

        )

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

            [parking] => Array
                (
                    [0] => Asphalt
                )

            [features] => Array
                (
                    [0] => Storage
                )

            [school] => stdClass Object
                (
                    [elementary] => Highland Park Elementary
                    [junior] => Whitthorne Middle School
                    [high] => Columbia Central High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2024-11-09T14:44:00Z
        )

    [office] => stdClass Object
        (
            [name] => College Park Realty
            [broker_id] => 355
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Cheryl
                            [last] => Selle Watson
                        )

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

                    [agent_id] => 1982
                )

        )

    [media] => stdClass Object
        (
            [photos] => Array
                (
                    [0] => stdClass Object
                        (
                            [position] => 0
                            [description] => Welcome to Sunset Avenue.  This home sits on a large lot with a fenced back yard. The home has been freshly painted, hardwood floors, new kitchen flooring, granite countertop, large covered, screened in patio, plus much more!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2754355/0.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2754355/0/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2754355/0/440x.jpg
                                )

                        )

                    [1] => stdClass Object
                        (
                            [position] => 1
                            [description] => Side view of home showing large covered, partially screened in patio, new side entrance and storage building in back yard.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2754355/1.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2754355/1/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2754355/1/440x.jpg
                                )

                        )

                    [2] => stdClass Object
                        (
                            [position] => 2
                            [description] => The home has a large side and back yard.  The back yard has a chain link fence.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2754355/2.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2754355/2/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2754355/2/440x.jpg
                                )

                        )

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

                        )

                    [4] => stdClass Object
                        (
                            [position] => 4
                            [description] => Another view of the covered screened patio.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2754355/4.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2754355/4/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2754355/4/440x.jpg
                                )

                        )

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

                        )

                    [6] => stdClass Object
                        (
                            [position] => 6
                            [description] => The kitchen has new flooring, light fixture, sink and a new granite countertop.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2754355/6.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2754355/6/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2754355/6/440x.jpg
                                )

                        )

                    [7] => stdClass Object
                        (
                            [position] => 7
                            [description] => Another view of the kitchen.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2754355/7.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2754355/7/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2754355/7/440x.jpg
                                )

                        )

                    [8] => stdClass Object
                        (
                            [position] => 8
                            [description] => Spacious living room with hardwood floors and lots of natural light.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2754355/8.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2754355/8/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2754355/8/440x.jpg
                                )

                        )

                    [9] => stdClass Object
                        (
                            [position] => 9
                            [description] => Full tile bath with tub/shower combo.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2754355/9.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2754355/9/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2754355/9/440x.jpg
                                )

                        )

                    [10] => stdClass Object
                        (
                            [position] => 10
                            [description] => Flex room with wood panel walls and built-in shelf.  Could be a 3rd bedroom, office, hobby room, dining room, etc.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2754355/10.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2754355/10/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2754355/10/440x.jpg
                                )

                        )

                    [11] => stdClass Object
                        (
                            [position] => 11
                            [description] => The bedrooms have hardwood floors, new blinds, ceiling fans and the home has been freshly painted.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2754355/11.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2754355/11/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2754355/11/440x.jpg
                                )

                        )

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

                        )

                )

        )

    [key] => rt-2754355
    [added_at] => stdClass Object
        (
            [$date] => 2024-10-31T19:24:00Z
        )

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

    Interior Details

  • Bedrooms2
  • Bathrooms1
  • BasementCrawl Space
  • FeaturesCeiling Fan(s)
  • AppliancesOven, Refrigerator
  • HVACArray

    Exterior Details

  • ConstructionBrick
  • Built In1956
  • Stories1
  • ParkingAsphalt
  • FeaturesStorage
  • SewerPublic Sewer

Request Information