stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Coming Soon
            [changed] => 2025-04-02T01:02:07
        )

    [ml_number] => 2811868
    [price] => stdClass Object
        (
            [amount] => 485000
            [original] => 485000
            [last_changed_on] => 2025-04-01T16:04:00
        )

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

    [available_on] => stdClass Object
        (
            [$date] => 2025-04-02T04:00:00Z
        )

    [description] => BETTER THAN NEW! $15,000 of updates and sprucing up was completed on this listing over the past few weeks. Lower County Taxes are here! Owner/Agent FULL POND VIEW HOME WITH OWNERS BEDROOM SUITE ON THE MAIN FLOOR! More Photos Coming This Week! From the moment you walk in you will love your screened in patio overlooking a gorgeous pond. Inside, tall floor-to-ceiling windows in the great room bring the outdoors in and flood the space with natural lighting. The kitchen offers all stainless steel appliances, granite countertops and a tile backsplash. Just installed ALL NEW Beautiful wide wood plank floors and NEW Carpet in all the upstairs bedrooms!  Best of all, the Owners Suite is conveniently located on the main floor! Also, this is the ONLY Courtyard Garage home in all of Farmington located on the pond and access to the walking pond trail with the garage on the side of a cul-de-sac making it perfect for kids to ride their bikes and you to pull out each day.
    [location] => stdClass Object
        (
            [city] => Clarksville
            [state] => Tennessee
            [postal_code] => 37043
            [county] => Montgomery County, TN
            [subdivision] => Farmington
            [street] => stdClass Object
                (
                    [number] => 1501
                    [name] => Covey Rise Ct
                    [full] => 1501 Covey Rise Ct
                )

            [directions] => Take Rossview Road to Farmington Subdivision, turn on Pressler Way, right on Fantasia, left on Green Grove, left on Covey Rise, house is 2nd on the right, in the cul-de-sac.
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.512666
                    [longitude] => -87.301283
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.301283
                                    [1] => 36.512666
                                )

                        )

                )

        )

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

            [construction] => Array
                (
                    [0] => Brick
                    [1] => Wood Siding
                )

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

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

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

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

                )

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

            [appliances] => Array
                (
                    [0] => Electric Oven
                    [1] => Electric Range
                    [2] => Disposal
                    [3] => ENERGY STAR Qualified Appliances
                    [4] => Ice Maker
                    [5] => Microwave
                    [6] => Refrigerator
                )

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

                )

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

        )

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

            [services] => Array
                (
                    [0] => Trail(s)
                )

            [parking] => Array
                (
                    [0] => Garage Door Opener
                    [1] => Garage Faces Side
                    [2] => Concrete
                    [3] => Driveway
                )

            [parking_spaces] => 2
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 96
                            [acres] => 0.37
                        )

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

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-04-17T17:05:00Z
        )

    [office] => stdClass Object
        (
            [name] => eXp Realty
            [broker_id] => 3635
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => April
                            [middle] => Michelle
                            [last] => Consulo
                        )

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

                )

        )

    [media] => stdClass Object
        (
            [photos] => Array
                (
                    [0] => stdClass Object
                        (
                            [position] => 0
                            [description] => Welcome Home To The Prestigious Neighborhood Of Farmington. This Beautiful All Brick Home Is a RARE Find As It Has NO Close Up Rear Neighbors And Is The ONLY Home Located On The Large Pond With A Courtyard Garage Facing Into The Cul-de-sac.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/0.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/0/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/0/440x.jpg
                                )

                        )

                    [1] => stdClass Object
                        (
                            [position] => 1
                            [description] => From The Moment You Walk Up To Your Grand Entrance You Will Notice The Large Covered Porch, A Beautiful Beveled Glass Door With Side Panels, Chocolate Iron Rails And HUGE Flower Beds Ready For Your Landscapers Touch!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/1.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/1/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/1/440x.jpg
                                )

                        )

                    [2] => stdClass Object
                        (
                            [position] => 2
                            [description] => PRIVACY- NO CLOSE REAR NEIGHBORS!!! Imagine Staring At This Every Day From The Moment You Wake Up From Virtually Every Room Inside This Home, Don’t Miss This Gorgeous RARE Location In Farmington. Call For Your Private Showing Now!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/2.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/2/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/2/440x.jpg
                                )

                        )

                    [3] => stdClass Object
                        (
                            [position] => 3
                            [description] => This Incredible Oversized Level Yard Flows Straight Down To The Beautiful Pond With Nature Walking Trails With Adorable Ducks Swimming And Bunny’s Frolicking And Playing.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/3.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/3/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/3/440x.jpg
                                )

                        )

                    [4] => stdClass Object
                        (
                            [position] => 4
                            [description] => Soaring Ceilings, Gorgeous Natural Lighting & Stunning Wall To Wall Windows With Upgraded Trim Package And A Lovely Tiled Fireplace Are What You Will See From The Moment You Walk Into This Spectacular RARE Pond Listing In The Farmington Community.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/4.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/4/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/4/440x.jpg
                                )

                        )

                    [5] => stdClass Object
                        (
                            [position] => 5
                            [description] => What A Spectacular Feeling You Get When You Walk Into This Functional Flowing Floorplan, Notice The Lovely Arches And 20 Feet Ceilings That Captivate The Natural Lighting Throughout!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/5.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/5/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/5/440x.jpg
                                )

                        )

                    [6] => stdClass Object
                        (
                            [position] => 6
                            [description] => Entertain And Delight Your Friends And Guests In Your Open And Inviting Living Room With Massive 20 Foot Ceilings, Dual Ceiling Fans, A Lovely Fireplace With Surround Tile Décor, Unbelievable Natural Lighting, And All New Flooring And Neutral Paint.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/6.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/6/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/6/440x.jpg
                                )

                        )

                    [7] => stdClass Object
                        (
                            [position] => 7
                            [description] => This View NEVER Gets Old As You Make Your Way Downstairs And Enjoy The Oversized Windows And 20 Feet Ceilings For Added Sunlight.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/7.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/7/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/7/440x.jpg
                                )

                        )

                    [8] => stdClass Object
                        (
                            [position] => 8
                            [description] => This Lovely Formal Dining Room Space Is Such A Great Flex Space And Can Also Be Used As An In Home Office, Formal Living Room Or Even The Kids Playroom.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/8.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/8/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/8/440x.jpg
                                )

                        )

                    [9] => stdClass Object
                        (
                            [position] => 9
                            [description] => Wake Up Your Inner Chef And Create Family Feasts In Your Gorgeous Open Kitchen Complete With Granite Counter Tops, Stainless Steel Appliances, A Walk In Pantry And A View To Die For While Washing Dishes And Overlooking The Glistening Pond.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/9.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/9/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/9/440x.jpg
                                )

                        )

                    [10] => stdClass Object
                        (
                            [position] => 10
                            [description] => This Additional View Of Your Gourmet Kitchen Shows How It Flows Directly Into Your Formal Dining Area And It Also Offers A HUGE Walk Pantry And Notice All Of The Fabulous Granite Counter Top Space With Tons Of Cabinetry.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/10.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/10/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/10/440x.jpg
                                )

                        )

                    [11] => stdClass Object
                        (
                            [position] => 11
                            [description] => You Will LOVE This Oversized Eat In Kitchen With Amazing Windows Viewing Onto The Pond And With Added Access Straight Out To Your Screened In Porch For Celebration Parties And Gatherings. It Also Offers A Bar Top And Eat In Dining Option.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/11.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/11/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/11/440x.jpg
                                )

                        )

                    [12] => stdClass Object
                        (
                            [position] => 12
                            [description] => Washing Dishes Will NEVER Be The Same When You Can Enjoy This One Of A Kind Full Pond View. This Also Allows You To Watch The Kids As They Play Outside And Added Ease When Hosting Your BBQ Gatherings!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/12.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/12/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/12/440x.jpg
                                )

                        )

                    [13] => stdClass Object
                        (
                            [position] => 13
                            [description] => Sweet Dreams In Your HUGE Owners Suite With Walk In Closet, Large Bathroom, Designer Double Trey Ceilings And A Full View Of The Phenomenal Pond From Your Bedroom Windows, What A Way To Wake Up AND Notice Your NEW CARPET & PAD IN EVERY BEDROOM!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/13.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/13/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/13/440x.jpg
                                )

                        )

                    [14] => stdClass Object
                        (
                            [position] => 14
                            [description] => You Will Love Your Double Marble Vanity, Mirrors And Lighting Each Morning As You Prepare For Your Day.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/14.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/14/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/14/440x.jpg
                                )

                        )

                    [15] => stdClass Object
                        (
                            [position] => 15
                            [description] => Time To Relax In Your Fabulous Garden Tub, And Lovely Owners Bath With Dual Vanities, And A Separate Gorgeous Tile Shower. Notice The HUGE Window Over The Tub Creating Natural Lighting For Primping And Makeup.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/15.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/15/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/15/440x.jpg
                                )

                        )

                    [16] => stdClass Object
                        (
                            [position] => 16
                            [description] => This Lovely Bathroom Is Centrally Located Upstairs Between The Bedrooms/Bonus Room For Your Guests And Family!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/16.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/16/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/16/440x.jpg
                                )

                        )

                    [17] => stdClass Object
                        (
                            [position] => 17
                            [description] => You Will Love Your Walk In Laundry Room Conveniently Located Directly Off The Kitchen With Lots Of Cabinets, A Massive Coat/Storage Closet, Lovely Tile And Easy Access To Your Oversized 2 Car Garage.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/17.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/17/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/17/440x.jpg
                                )

                        )

                    [18] => stdClass Object
                        (
                            [position] => 18
                            [description] => WOW, Look At Your Fabulous Attached Screened Porch, Cul-de-sac Garage Setting For Added Ease When Backing Out To The Street And The Kiddos To Play And Ride Their Bikes. PS, This Property Also Has A Connection To The Beautiful Pond Walking Trails.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2811868/18.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2811868/18/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2811868/18/440x.jpg
                                )

                        )

                )

        )

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

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

    Interior Details

  • Bedrooms4
  • Bathrooms2
  • Half Baths1
  • BasementCrawl Space
  • FeaturesCeiling Fan(s), Entrance Foyer, High Ceilings, Walk-In Closet(s), Primary Bedroom Main Floor
  • AppliancesElectric Oven, Electric Range, Disposal, ENERGY STAR Qualified Appliances, Ice Maker, Microwave, Refrigerator
  • HVACArray
  • Fireplaces1

    Exterior Details

  • StyleContemporary
  • ConstructionBrick, Wood Siding
  • Built In2010
  • Stories2
  • ParkingGarage Door Opener, Garage Faces Side, Concrete, Driveway
  • Garage Bays2
  • ServicesTrail(s)
  • SewerPublic Sewer
  • Lot DescriptionCul-De-Sac, Level
  • Lot Dimensions96
  • Acres0.37

Request Information