stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2024-08-23T11:14:00
        )

    [ml_number] => 2695239
    [price] => stdClass Object
        (
            [amount] => 459000
            [original] => 499999
            [last_changed_on] => 2024-10-16T19:05:00
        )

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

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

    [description] => Stunning downtown cottage renovation! This updated 1946 cottage boasts 4 bedrooms and 3 full bathrooms including a stunning master suite oasis with vaulted ceilings, updated bathroom, walk-in closet, and sitting room. Newly refinished original oak and pine hardwood floors throughout main and 2nd floors. Open concept living room and dining room with brand new stone fireplace and gas logs. Kitchen includes new cabinetry, countertops, and stainless steel appliances. Full basement includes great room, bedroom, full bathroom, and a massive laundry room with new cabinets and countertops! Other upgrades include a newly concreted driveway, paint inside and out, lighting throughout, brand new HVAC system, recent siding and windows, and new electrical panel upgrades! TRULY move-in ready!
    [location] => stdClass Object
        (
            [city] => Columbia
            [state] => Tennessee
            [postal_code] => 38401
            [county] => Maury County, TN
            [subdivision] => Oakdale
            [street] => stdClass Object
                (
                    [number] => 1010
                    [name] => Trotwood Ave
                    [full] => 1010 Trotwood Ave
                )

            [directions] => From N Garden Street: Turn right on W 7th Street, and veer left onto Trotwood Avenue. Continue approximately 0.4 miles and 1010 Trotwood Avenue will be located on the right side of the street.
            [coordinates] => stdClass Object
                (
                    [latitude] => 35.614009
                    [longitude] => -87.05304
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.05304
                                    [1] => 35.614009
                                )

                        )

                )

        )

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

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

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

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

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

                    [basement] => Array
                        (
                            [0] => Finished
                        )

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Walk-In Closet(s)
                )

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

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

                )

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

        )

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

            [parking] => Array
                (
                    [0] => Basement
                    [1] => Attached
                    [2] => Concrete
                )

            [parking_spaces] => 1
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 75X133
                            [acres] => 0.24
                        )

                    [description] => Array
                        (
                            [0] => Rolling Slope
                            [1] => Wooded
                        )

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2024-10-16T23:05:00Z
        )

    [office] => stdClass Object
        (
            [name] => ListWithFreedom.com
            [broker_id] => 3994
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Ralph
                            [last] => Harvey
                        )

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

                    [agent_id] => 47288
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2695239
    [added_at] => stdClass Object
        (
            [$date] => 2024-08-23T15:14:00Z
        )

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

    Interior Details

  • Bedrooms4
  • Bathrooms3
  • BasementFinished
  • FeaturesCeiling Fan(s), Walk-In Closet(s)
  • AppliancesDishwasher, Disposal, Microwave
  • HVACArray

    Exterior Details

  • StyleCottage
  • ConstructionBrick, Vinyl Siding
  • Built In1946
  • Stories2
  • ParkingBasement, Attached, Concrete
  • Garage Bays1
  • SewerPublic Sewer
  • Lot DescriptionRolling Slope, Wooded
  • Lot Dimensions75X133
  • Acres0.24

Listing Brokerage: ListWithFreedom.com
Listing Agent: Ralph Harvey (855) 456-4945

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of April 20, 2025 5:01am. 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