stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2024-06-10T13:23:00
        )

    [ml_number] => 2664755
    [price] => stdClass Object
        (
            [amount] => 234998
            [original] => 265000
            [last_changed_on] => 2024-09-27T11:15:00
        )

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

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

    [description] => STUNNING NEW HOME IN PRIME LOCATION. Introducing a meticulously newly renovated home in a prime Cookeville location. Featuring comprehensive updates, including new roofing & gutters ,high end new plumbing fixtures with all new plumbing lines. New High efficiency HVAC. New electric throughout the home, with new drywall, & all new framing. This residence showcases amazing, NEED TO BE SEEN, luxurious finishes, including, quartz countertops, premium fixtures, & state-of-the-art kitchens & bathrooms. Ensuring a modern warm elegance throughout the home. Ideally situated amidst Cookeville's best amenities, including shopping & parks. Close to everything; this property offers everything you would want, with unparalleled convenience. And there will be a DOG PARK available for your 4-legged friends! Don't miss out on this turnkey home, homes are going fast—act now & make it yours!
    [location] => stdClass Object
        (
            [city] => Cookeville
            [state] => Tennessee
            [postal_code] => 38501
            [county] => Putnam County, TN
            [subdivision] => The Villas
            [street] => stdClass Object
                (
                    [number] => 123
                    [name] => Boatman St
                    [full] => 123 Boatman St
                )

            [directions] => From PCCH: go W on E Spring St toward Jefferson Ave, go L on S Jefferson Ave, go R on Foutch Dr, go L on S Walnut Ave, go R on Boatman Sr, house will be on your R, see sign!
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.149356
                    [longitude] => -85.509775
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -85.509775
                                    [1] => 36.149356
                                )

                        )

                )

        )

    [building] => stdClass Object
        (
            [construction] => Array
                (
                    [0] => Frame
                    [1] => Brick
                )

            [square_feet] => stdClass Object
                (
                    [size] => 988
                    [source] => Owner
                )

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

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

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

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Primary Bedroom Main Floor
                )

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

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

                )

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

        )

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

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [acres] => 0.25
                        )

                )

            [school] => stdClass Object
                (
                    [elementary] => Park View Elementary
                    [junior] => Prescott South Middle School
                    [high] => Cookeville High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2024-09-28T18:17:01Z
        )

    [office] => stdClass Object
        (
            [name] => Elevate Real Estate Inc
            [broker_id] => 4458
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Elijah
                            [last] => Castelli
                        )

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

                    [agent_id] => 53184
                )

        )

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

                        )

                    [1] => stdClass Object
                        (
                            [position] => 1
                            [description] => Dog park for your four legged friends
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2664755/1.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2664755/1/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2664755/1/440x.jpg
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [28] => stdClass Object
                        (
                            [position] => 28
                            [description] => Laundry Room for stackable washer & dryer
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2664755/28.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2664755/28/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2664755/28/440x.jpg
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2664755
    [added_at] => stdClass Object
        (
            [$date] => 2024-06-10T17:23:00Z
        )

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

    Interior Details

  • Bedrooms2
  • Bathrooms2
  • BasementCrawl Space
  • FeaturesCeiling Fan(s), Primary Bedroom Main Floor
  • AppliancesDishwasher, Microwave, Refrigerator
  • HVACArray

    Exterior Details

  • ConstructionFrame, Brick
  • Built In1960
  • Stories1
  • SewerPublic Sewer
  • Acres0.25

Listing Brokerage: Elevate Real Estate Inc
Listing Agent: Elijah Castelli (931) 283-2312

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 4:11am. 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