stdClass Object
(
    [type] => Land
    [status] => stdClass Object
        (
            [current] => Active Under Contract
            [last] => Active Under Contract
            [changed] => 2025-07-02T14:05:02
        )

    [ml_number] => 2908372
    [price] => stdClass Object
        (
            [amount] => 90000
            [original] => 90000
            [last_changed_on] => 2025-07-02T14:05:02
        )

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

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

    [description] => Prime Corner Lots in Sought-After Riverside | Columbia, TN. Don’t miss this rare opportunity to own two recorded and engineered vacant lots on the corner of 8th Ave and Waters in Columbia’s desirable Riverside community. With engineering already completed and attached to the listing, these lots are shovel-ready and waiting for your dream build. Whether you're a builder looking for your next project or a homeowner ready to plant roots in a vibrant, growing area, this location offers unbeatable potential. Walkable to Riverside Elementary and just minutes from downtown Columbia, shopping, restaurants, and the Duck River. Come build your vision in one of Columbia’s most beloved neighborhoods!
    [location] => stdClass Object
        (
            [city] => Columbia
            [state] => Tennessee
            [postal_code] => 38401
            [county] => Maury County, TN
            [subdivision] => Riverside
            [street] => stdClass Object
                (
                    [number] => 0
                    [name] => 8th Ave
                    [full] => 0 8th Ave
                )

            [directions] => Nashville HWY south to 8th Ave. Turn left on 8th. Lots are on the corner of 8th Ave and Waters.
            [coordinates] => stdClass Object
                (
                    [latitude] => 35.627164
                    [longitude] => -87.027341
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.027341
                                    [1] => 35.627164
                                )

                        )

                )

        )

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

        )

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

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => .19
                        )

                    [description] => Array
                        (
                            [0] => Corner Lot
                        )

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-07-02T18:05:02Z
        )

    [office] => stdClass Object
        (
            [name] => The Designated Agency, Inc.
            [broker_id] => 4688
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Trey
                            [last] => Ellis
                        )

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

                    [agent_id] => 30176
                )

        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2908372
    [added_at] => stdClass Object
        (
            [$date] => 2025-06-13T18:09:02Z
        )

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

    Exterior Details

  • SewerPublic Sewer
  • Lot DescriptionCorner Lot
  • Lot Dimensions.19

Request Information