stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2024-10-07T10:58:00
        )

    [ml_number] => 2745469
    [price] => stdClass Object
        (
            [amount] => 549900
            [original] => 549900
            [last_changed_on] => 2024-10-07T10:58:00
        )

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

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

    [description] => 1500 sq ft + .27 acre lot for under 550! Charming 3 bed and 2 bath with HUGE fenced front and back yards conveniently located near the interstate and just steps away from developing Dickerson Pike and 8 minutes to new Oracle development. Open layout, updated kitchen with stainless appliances, original pine hardwood floors and HUGE bedrooms. The home is also within walking distance to East Nashville favorites such as Crema, East Beer Works, Frans Karaoke Bar, Retrograde Coffee, and more. Recent upgrades include: 2023 HVAC, new pine floors on the previously carpeted side of the house, freshly painted interior and repainted + reglazed windows. The lot also includes a workshop and garage with electricity that needs some TLC. Great neighborhood with sidewalks - fantastic home for young families or as an investment property. BUYER AND/OR BUYERS AGENT TO VERIFY ALL INFO. LIMITED-SERVICE LISTING - CONTACT SELLER DIRECTLY FOR ALL SHOWINGS/INQUIRIES. SELLER TO BE MAIN POINT OF CONTACT.
    [location] => stdClass Object
        (
            [city] => Nashville
            [state] => Tennessee
            [postal_code] => 37207
            [county] => Davidson County, TN
            [subdivision] => J B Haynies Oriental
            [street] => stdClass Object
                (
                    [number] => 207
                    [name] => Queen Ave
                    [full] => 207 Queen Ave
                )

            [directions] => Turn left off of trinity down Sultana, make a left and drive straight until you see 207 Queen Ave. Alternatively, drive down Dickerson pike, make a left on Queen Ave and drive up the street until you see 207 Queen Ave.
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.208451
                    [longitude] => -86.764585
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -86.764585
                                    [1] => 36.208451
                                )

                        )

                )

        )

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

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

            [square_feet] => stdClass Object
                (
                    [size] => 1507
                    [source] => Appraiser
                )

            [stories] => 1
            [built_in] => 1950
            [rooms] => stdClass Object
                (
                    [bed] => stdClass Object
                        (
                            [count] => 3
                        )

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

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

                )

            [features] => Array
                (
                    [0] => Air Filter
                    [1] => Extra Closets
                    [2] => Pantry
                    [3] => Walk-In Closet(s)
                    [4] => Primary Bedroom Main Floor
                )

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

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

                )

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

        )

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

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

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

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 80 X 140
                            [acres] => 0.27
                        )

                    [description] => Array
                        (
                            [0] => Sloped
                        )

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2024-10-09T18:05:39Z
        )

    [office] => stdClass Object
        (
            [name] => Community Realty Services, Inc.
            [broker_id] => 1737
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => John
                            [middle] => C.
                            [last] => Rochford
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 6153302876
                            [mobile] => 6153302876
                            [fax] => 6152697675
                        )

                    [agent_id] => 23746
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2745469
    [added_at] => stdClass Object
        (
            [$date] => 2024-10-07T14:58:00Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms2
  • BasementCrawl Space
  • FeaturesAir Filter, Extra Closets, Pantry, Walk-In Closet(s), Primary Bedroom Main Floor
  • AppliancesDishwasher, Microwave, Refrigerator
  • HVACArray
  • Fireplaces1

    Exterior Details

  • StyleRanch
  • ConstructionVinyl Siding
  • Built In1950
  • Stories1
  • ParkingDetached, Driveway
  • Garage Bays2
  • FeaturesStorage
  • SewerPublic Sewer
  • Lot DescriptionSloped
  • Lot Dimensions80 X 140
  • Acres0.27

Listing Brokerage: Community Realty Services, Inc.
Listing Agent: John Rochford (615) 330-2876

Listings courtesy of Realtracs as distributed by MLS GRID

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