stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-01-22T13:39:00
        )

    [ml_number] => 2780618
    [price] => stdClass Object
        (
            [amount] => 330000
            [original] => 375000
            [last_changed_on] => 2025-03-18T09:54:01
        )

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

    [available_on] => stdClass Object
        (
            [$date] => 2025-01-21T05:00:00Z
        )

    [description] => Discover an exceptional investment opportunity at 196 Queen Avenue in the vibrant and rapidly developing East Nashville area. This charming property offers two build possibilities on a generous 6,969 square foot lot, making it an ideal choice for investors looking to capitalize on the neighborhood's growth.Don't miss your chance to invest in this hot and upcoming area!
    [location] => stdClass Object
        (
            [city] => Nashville
            [state] => Tennessee
            [postal_code] => 37207
            [county] => Davidson County, TN
            [subdivision] => Haynies Oriental
            [street] => stdClass Object
                (
                    [number] => 196
                    [name] => Queen Ave
                    [full] => 196 Queen Ave
                )

            [directions] => From 2nd Avenue, take a right on Church Street, left onto 1st Ave. N., continue on Woodland St. then Union St. then turn left onto S. 1st Street, slight left onto N. 1st Street, turn right onto Queen Avenue
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.20813
                    [longitude] => -86.765769
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -86.765769
                                    [1] => 36.20813
                                )

                        )

                )

        )

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

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

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

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

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

                )

            [appliances] => Array
                (
                    [0] => Built-In Electric Oven
                    [1] => Built-In Electric Range
                )

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

                )

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

        )

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

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

            [parking_spaces] => 1
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 50 X 140
                            [acres] => 0.16
                        )

                )

            [school] => stdClass Object
                (
                    [elementary] => Tom Joy Elementary
                    [junior] => Jere Baxter Middle
                    [high] => Maplewood Comp High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-03-20T18:02:31Z
        )

    [office] => stdClass Object
        (
            [name] => Parks Compass
            [broker_id] => 3139
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Kina
                            [last] => McKissack
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 6154835066
                            [mobile] => 6154835066
                            [fax] => 6155835051
                        )

                    [agent_id] => 39665
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2780618
    [added_at] => stdClass Object
        (
            [$date] => 2025-01-21T19:04:00Z
        )

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

    Interior Details

  • Bedrooms2
  • Bathrooms1
  • BasementCrawl Space
  • AppliancesBuilt-In Electric Oven, Built-In Electric Range
  • HVACArray

    Exterior Details

  • ConstructionAluminum Siding
  • Built In1948
  • Stories1
  • ParkingDetached
  • Garage Bays1
  • SewerPublic Sewer
  • Lot Dimensions50 X 140
  • Acres0.16

Request Information