stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-03-08T16:51:01
        )

    [ml_number] => 2801769
    [price] => stdClass Object
        (
            [amount] => 499900
            [original] => 499900
            [last_changed_on] => 2025-03-08T16:51:01
        )

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

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

    [description] => AMAZING brick home located in the heart of the desirable Farmington subdivision. This home sits on a huge lot with a spacious level and fenced in backyard and recently expanded deck AND patio area. A beautiful pond with paved walking path is only a minute walk across the street! The first floor of this home boasts soaring ceilings, a natural gas fireplace, a chef’s kitchen complete with double ovens and an electric range, and your primary suite retreat! The primary bathroom has a large walk-in shower, a large jacuzzi soaking tub, and on theme with the rest of the primary, a very LARGE walk-in closet! Upstairs you will find two generous sized guest bedrooms along with a huge bonus room over the garage with plenty of room for a home theater/gaming room. The attic space in the bonus room offers ample storage space. The garage floor has been professionally epoxied so cleanup is a breeze. This home is a stunner!
    [location] => stdClass Object
        (
            [city] => Clarksville
            [state] => Tennessee
            [postal_code] => 37043
            [county] => Montgomery County, TN
            [subdivision] => Farmington
            [street] => stdClass Object
                (
                    [number] => 1517
                    [name] => Edgewater Ln
                    [full] => 1517 Edgewater Ln
                )

            [directions] => Rossview Rd towards Adams- then Take Left onto Pressler then Right onto Fantasia & Left onto Edgewater, home is on the right
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.564631
                    [longitude] => -87.222883
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.222883
                                    [1] => 36.564631
                                )

                        )

                )

        )

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

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

            [stories] => 2
            [built_in] => 2010
            [rooms] => stdClass Object
                (
                    [bed] => stdClass Object
                        (
                            [count] => 3
                        )

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

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

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Entrance Foyer
                    [2] => Extra Closets
                    [3] => High Ceilings
                    [4] => Pantry
                    [5] => Walk-In Closet(s)
                    [6] => Primary Bedroom Main Floor
                )

            [appliances] => Array
                (
                    [0] => Built-In Electric Oven
                    [1] => Double Oven
                    [2] => Electric Oven
                    [3] => Built-In Electric Range
                    [4] => Dishwasher
                    [5] => Disposal
                    [6] => Microwave
                    [7] => Refrigerator
                )

            [hvac] => Array
                (
                    [0] => Array
                        (
                            [0] => Ceiling Fan(s)
                            [1] => Central Air
                            [2] => Electric
                        )

                )

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

        )

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

            [services] => Array
                (
                    [0] => Sidewalks
                    [1] => Underground Utilities
                )

            [parking] => Array
                (
                    [0] => Garage Door Opener
                    [1] => Garage Faces Front
                )

            [parking_spaces] => 2
            [features] => Array
                (
                    [0] => Garage Door Opener
                )

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

                )

            [school] => stdClass Object
                (
                    [elementary] => Kirkwood Elementary
                    [junior] => Kirkwood Middle
                    [high] => Kirkwood High
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-03-29T01:56:00Z
        )

    [office] => stdClass Object
        (
            [name] => RE/MAX NorthStar
            [broker_id] => 1792
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => SCOTT
                            [last] => STEPHENSON
                        )

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

                )

            [1] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Joseph
                            [last] => Hedrick
                        )

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

                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2801769
    [added_at] => stdClass Object
        (
            [$date] => 2025-03-08T21:51:01Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms2
  • Half Baths1
  • BasementCrawl Space
  • FeaturesCeiling Fan(s), Entrance Foyer, Extra Closets, High Ceilings, Pantry, Walk-In Closet(s), Primary Bedroom Main Floor
  • AppliancesBuilt-In Electric Oven, Double Oven, Electric Oven, Built-In Electric Range, Dishwasher, Disposal, Microwave, Refrigerator
  • HVACArray
  • Fireplaces1

    Exterior Details

  • ConstructionBrick
  • Built In2010
  • Stories2
  • ParkingGarage Door Opener, Garage Faces Front
  • Garage Bays2
  • FeaturesGarage Door Opener
  • ServicesSidewalks, Underground Utilities
  • SewerPublic Sewer
  • Acres0.41

Listing Brokerage: RE/MAX NorthStar
Listing Agent: SCOTT STEPHENSON (615) 420-8369

Listings courtesy of Realtracs as distributed by MLS GRID

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