stdClass Object
(
    [type] => Residential
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Coming Soon
            [changed] => 2025-04-18T11:00:00
        )

    [ml_number] => 2808674
    [price] => stdClass Object
        (
            [amount] => 249999
            [original] => 249999
            [last_changed_on] => 2025-03-25T15:42:00
        )

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

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

    [description] => Welcome to 142 Red Apple Ct in Clarksville, TN! This charming 3-bedroom, 2-bath home offers a cozy yet spacious layout, perfect for comfortable living. Enjoy the convenience of a one-car garage, a lovely deck for entertaining, and a fully fenced backyard for added privacy. Located in a great neighborhood, this home is a fantastic opportunity—don’t miss out!
    [location] => stdClass Object
        (
            [city] => Clarksville
            [state] => Tennessee
            [postal_code] => 37040
            [county] => Montgomery County, TN
            [subdivision] => Applegrove
            [street] => stdClass Object
                (
                    [number] => 1042
                    [name] => Red Apple Ct
                    [full] => 1042 Red Apple Ct
                )

            [directions] => Take I-24 W to exit 4 (US-79 S/Wilma Rudolph Blvd) in Clarksville. Turn right on US-79 S, then right on Needmore Rd. Turn right on Whitfield Rd, left on Granny White Rd, which becomes Red Apple Ct. 1042 Red Apple Ct is in the cul-de-sac.
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.595913
                    [longitude] => -87.340418
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.340418
                                    [1] => 36.595913
                                )

                        )

                )

        )

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

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

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

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

                )

            [features] => Array
                (
                    [0] => Extra Closets
                    [1] => Pantry
                )

            [appliances] => Array
                (
                    [0] => Electric Oven
                    [1] => Electric Range
                    [2] => Water Purifier
                )

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

                )

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

        )

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

            [parking] => Array
                (
                    [0] => Garage Faces Side
                    [1] => Driveway
                )

            [parking_spaces] => 1
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [acres] => 0.22
                        )

                )

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

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-04-18T15:00:00Z
        )

    [office] => stdClass Object
        (
            [name] => Mark Spain Real Estate
            [broker_id] => 4455
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Austin
                            [last] => Caron
                        )

                    [phone] => stdClass Object
                        (
                            [mobile] => 6154766608
                        )

                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2808674
    [added_at] => stdClass Object
        (
            [$date] => 2025-03-25T19:42:00Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms2
  • FeaturesExtra Closets, Pantry
  • AppliancesElectric Oven, Electric Range, Water Purifier
  • HVACArray

    Exterior Details

  • ConstructionBrick, Vinyl Siding
  • Built In2006
  • Stories1
  • ParkingGarage Faces Side, Driveway
  • Garage Bays1
  • SewerPublic Sewer
  • Acres0.22

Listing Brokerage: Mark Spain Real Estate
Listing Agent: Austin Caron () -

Listings courtesy of Realtracs as distributed by MLS GRID

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