stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-01-29T14:30:00
        )

    [ml_number] => 2767852
    [price] => stdClass Object
        (
            [amount] => 524900
            [original] => 549000
            [last_changed_on] => 2025-03-19T17:10:02
        )

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

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

    [description] => Located on one of Cookeville’s nicest streets, 600 N. Pickard Avenue offers 2,145 sq. ft. of potential in a well-established, sought-after neighborhood. This spacious home features a full basement and classic design, providing a fantastic opportunity for those looking to personalize and update to their taste. With a large corner lot, there’s plenty of outdoor space to enjoy or enhance, whether you’re adding landscaping or creating a backyard retreat. The home is in a prime location on a tree-lined street, offering a sense of community and convenience in one of Cookeville’s most sought-after areas. Don’t miss the chance to make this home your own and enjoy all the benefits of living on one of Cookeville's most desirable roads. Schedule a showing today!
    [location] => stdClass Object
        (
            [city] => Cookeville
            [state] => Tennessee
            [postal_code] => 38501
            [county] => Putnam County, TN
            [subdivision] => Castleberry
            [street] => stdClass Object
                (
                    [number] => 600
                    [name] => N Pickard Ave
                    [full] => 600 N Pickard Ave
                )

            [directions] => From PCCH: Turn right onto E Spring St, Turn left onto S Elm Ave, Turn right onto E Broad St, Turn left onto N Pickard Ave, Home on Left See Sign.
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.170098
                    [longitude] => -85.477615
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -85.477615
                                    [1] => 36.170098
                                )

                        )

                )

        )

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

            [construction] => Array
                (
                    [0] => Brick
                )

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

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

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

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

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => High Speed Internet
                )

            [appliances] => Array
                (
                    [0] => Dishwasher
                    [1] => Refrigerator
                    [2] => Electric Oven
                    [3] => Cooktop
                )

            [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] => Garage Faces Rear
                )

            [parking_spaces] => 2
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 70 X 218.4 IRR
                            [acres] => 0.4
                        )

                    [description] => Array
                        (
                            [0] => Corner Lot
                            [1] => Cul-De-Sac
                            [2] => Level
                        )

                )

            [school] => stdClass Object
                (
                    [elementary] => Northeast Elementary
                    [junior] => Avery Trace Middle School
                    [high] => Cookeville High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-03-23T20:02:01Z
        )

    [office] => stdClass Object
        (
            [name] => Keller Williams Realty DBA Cookeville RE Company
            [broker_id] => 5562
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Robert
                            [middle] => Warren
                            [last] => Cole
                        )

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

                    [agent_id] => 71791
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2767852
    [added_at] => stdClass Object
        (
            [$date] => 2025-01-29T19:30:00Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms2
  • BasementUnfinished
  • FeaturesCeiling Fan(s), High Speed Internet
  • AppliancesDishwasher, Refrigerator, Electric Oven, Cooktop
  • HVACArray

    Exterior Details

  • StyleOther
  • ConstructionBrick
  • Built In1987
  • Stories1
  • ParkingGarage Faces Rear
  • Garage Bays2
  • SewerPublic Sewer
  • Lot DescriptionCorner Lot, Cul-De-Sac, Level
  • Lot Dimensions70 X 218.4 IRR
  • Acres0.4

Listing Brokerage: Keller Williams Realty DBA Cookeville RE Company
Listing Agent: Robert Cole (931) 316-1114

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of April 19, 2025 7:46pm. 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