stdClass Object
(
    [type] => Condominium & Townhouse
    [status] => stdClass Object
        (
            [current] => Active Under Contract
            [last] => Active
            [changed] => 2024-11-02T16:11:01
        )

    [ml_number] => 2705791
    [price] => stdClass Object
        (
            [amount] => 421900
            [original] => 424900
            [last_changed_on] => 2024-10-18T17:24:00
        )

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

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

    [description] => PRICE IMPROVEMENT- This beautiful courtyard home features outdoor privacy and indoor luxury- Beautiful 5" hardwoods, new paint throughout, new carpet in each of the bedrooms, striking tile shower in over-sized main bathroom, large kitchen with ample sized pantry and upgraded cabinetry and hardware. So convenient for enjoying an active lifestyle with essential shopping, dining, theater and more within easy walking distance. Exterior and grounds maintenance, internet/cable included in HOA leaving extra time for socializing at private Grasslands Country Club if desired, travel or continuing education at Vol State.**Preferred Lending partner Lauri Hodges with CMG Home Loans is offering incentive of 1% of loan amt. to be used towards one yr. temporary rate buydown or towards Closing costs. Information deemed reliable, buyer to verify.
    [location] => stdClass Object
        (
            [city] => Gallatin
            [state] => Tennessee
            [postal_code] => 37066
            [county] => Sumner County, TN
            [subdivision] => The Retreat at Fairvue
            [street] => stdClass Object
                (
                    [number] => 244
                    [name] => Glennister Ct
                    [full] => 244 Glennister Ct
                )

            [directions] => I-65 N to Vietnam Vets Blvd (exit 95) Continue on TN-386 for 8.9 mi., merge onto US-31 N/TN-6 (exit 9). Continue on US-31 N for 4.1 mi. Turn R onto Plantation Blvd. L onto Noah Ln. R. onto Chloe Dr. R onto Chesham, L to 1st drive-  244 Glennister Ct.
            [coordinates] => stdClass Object
                (
                    [latitude] => 36.355056
                    [longitude] => -86.498843
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -86.498843
                                    [1] => 36.355056
                                )

                        )

                )

        )

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

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

            [square_feet] => stdClass Object
                (
                    [size] => 1505
                )

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

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

                )

            [features] => Array
                (
                    [0] => High Ceilings
                    [1] => Pantry
                    [2] => Storage
                    [3] => Primary Bedroom Main Floor
                )

            [appliances] => Array
                (
                    [0] => Dishwasher
                    [1] => Disposal
                    [2] => ENERGY STAR Qualified Appliances
                    [3] => Microwave
                    [4] => Refrigerator
                )

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

                )

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

        )

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

            [parking] => Array
                (
                    [0] => Attached
                )

            [parking_spaces] => 2
            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [acres] => 0.08
                        )

                    [description] => Array
                        (
                            [0] => Corner Lot
                            [1] => Level
                        )

                )

            [school] => stdClass Object
                (
                    [elementary] => Jack Anderson Elementary
                    [junior] => Station Camp Middle School
                    [high] => Station Camp High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2024-11-02T20:11:01Z
        )

    [office] => stdClass Object
        (
            [name] => Coldwell Banker Southern Realty
            [broker_id] => 330
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Stacy
                            [last] => Reynolds
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 6159771643
                            [mobile] => 6159771643
                            [fax] => 6158248435
                        )

                    [agent_id] => 41784
                )

        )

    [media] => stdClass Object
        (
            [photos] => Array
                (
                    [0] => stdClass Object
                        (
                            [position] => 0
                            [description] => Welcome to this lovely brick home! Upon entering to right is a light filled room perfect for office, library/media or craft area. An elegant arched doorway leads into open and spacious living room.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/0.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/0/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/0/440x.jpg
                                )

                        )

                    [1] => stdClass Object
                        (
                            [position] => 1
                            [description] => Handsome stacked stone covered entrance.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/1.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/1/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/1/440x.jpg
                                )

                        )

                    [2] => stdClass Object
                        (
                            [position] => 2
                            [description] => This handsome home boasts an abundance of custom features- a generous wall of windows overlooking a large corner lot, custom built exterior wood shutters and stacked chimney detail.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/2.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/2/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/2/440x.jpg
                                )

                        )

                    [3] => stdClass Object
                        (
                            [position] => 3
                            [description] => Virtually staged room. * NEW neutral paint color 9.18.24!*New color shown on following image- This light filled area is the perfect office, library/media or hobby room.  Custom wood blinds on windows and door remain. *Color shown on following image-
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/3.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/3/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/3/440x.jpg
                                )

                        )

                    [4] => stdClass Object
                        (
                            [position] => 4
                            [description] => *NEW paint 9.18.24! The perfect canvas for library/media or hobby room.  Custom wood blinds on windows and door remain.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/4.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/4/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/4/440x.jpg
                                )

                        )

                    [5] => stdClass Object
                        (
                            [position] => 5
                            [description] => View from front door featuring graceful arched opening to living area. The hardwood floors throughout living areas are exceptional! Custom wood blinds remain.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/5.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/5/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/5/440x.jpg
                                )

                        )

                    [6] => stdClass Object
                        (
                            [position] => 6
                            [description] => Virtually staged.*NEW paint color! This beautiful room shows how inviting this space truly is! Notice arched doorway at front of home leading to optional space- perfect for office, library/media. Primary bedroom suite located to right of arch.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/6.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/6/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/6/440x.jpg
                                )

                        )

                    [7] => stdClass Object
                        (
                            [position] => 7
                            [description] => *NEW paint color 9.18.24. Open Living and dining room with graceful arched doorway to front entry. Kitchen located to right and conveniently overlooks dining and living room areas for entertaining with ease!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/7.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/7/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/7/440x.jpg
                                )

                        )

                    [8] => stdClass Object
                        (
                            [position] => 8
                            [description] => *NEW paint and *NEW carpet installed 9.18.24! Be the first to enjoy this better than new luxurious main bedroom with attractive ceiling details and oversized main bathroom, adjacent walk in closet.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/8.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/8/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/8/440x.jpg
                                )

                        )

                    [9] => stdClass Object
                        (
                            [position] => 9
                            [description] => *NEW paint and *NEW carpet installed 9.18.24! Be the first to enjoy this better than new luxurious main bedroom with attractive ceiling details and oversized main bathroom and adjacent walk in closet.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/9.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/9/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/9/440x.jpg
                                )

                        )

                    [10] => stdClass Object
                        (
                            [position] => 10
                            [description] => *NEW paint and *NEW carpet installed 9.18.24! Be the first to enjoy this better than new luxurious main bedroom with attractive ceiling details and oversized main bathroom and adjacent walk in closet.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/10.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/10/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/10/440x.jpg
                                )

                        )

                    [11] => stdClass Object
                        (
                            [position] => 11
                            [description] => The stately main bathroom with adjacent walk in closet. *NEW paint 9.18.24! and NEW carpet!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/11.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/11/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/11/440x.jpg
                                )

                        )

                    [12] => stdClass Object
                        (
                            [position] => 12
                            [description] => *NEW Paint and *NEW carpet in main bedroom and closet, installed 9.18.24!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/12.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/12/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/12/440x.jpg
                                )

                        )

                    [13] => stdClass Object
                        (
                            [position] => 13
                            [description] => Over sized shower features custom tile design and handheld shower spray for the ultimate shower experience. Linen closet adds extra storage in the main bedroom suite.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/13.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/13/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/13/440x.jpg
                                )

                        )

                    [14] => stdClass Object
                        (
                            [position] => 14
                            [description] => Luxurious and efficient customized tile walk- in shower provides the ultimate shower experience! Main bedroom/ bathroom suite.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/14.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/14/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/14/440x.jpg
                                )

                        )

                    [15] => stdClass Object
                        (
                            [position] => 15
                            [description] => * NEW paint color 9.18.24! Large combination living /dining area features FOUR windows all looking out onto greenspace corner lot maintained by HOA.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/15.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/15/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/15/440x.jpg
                                )

                        )

                    [16] => stdClass Object
                        (
                            [position] => 16
                            [description] => Custom details abound in this beautiful kitchen! Large walk in pantry and plenty of cabinet storage for your kitchen essentials and more. Stainless steel refrigerator and all appliances remain.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/16.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/16/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/16/440x.jpg
                                )

                        )

                    [17] => stdClass Object
                        (
                            [position] => 17
                            [description] => Beautiful like- new range and microwave play a beautiful part in this showy kitchen.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/17.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/17/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/17/440x.jpg
                                )

                        )

                    [18] => stdClass Object
                        (
                            [position] => 18
                            [description] => Large storage pantry *NEW paint 9.18.24!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/18.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/18/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/18/440x.jpg
                                )

                        )

                    [19] => stdClass Object
                        (
                            [position] => 19
                            [description] => A stainless steel appliances remain, Walk in pantry behind door. Beautiful view of courtyard/patio from kitchen window. Custom wood blinds remain. *NEW paint 9.18.24
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/19.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/19/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/19/440x.jpg
                                )

                        )

                    [20] => stdClass Object
                        (
                            [position] => 20
                            [description] => Kitchen window looks out onto private courtyard/patio and covered walkway to garage. Ample countertop space and large peninsula are perfect for entertaining.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/20.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/20/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/20/440x.jpg
                                )

                        )

                    [21] => stdClass Object
                        (
                            [position] => 21
                            [description] => Ample countertop space and large peninsula are perfect for entertaining guests or pull up bar stools for casual dining.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/21.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/21/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/21/440x.jpg
                                )

                        )

                    [22] => stdClass Object
                        (
                            [position] => 22
                            [description] => *NEW paint 9.18.24. This is just one of the lovely views of this gorgeous kitchen. Dining room and living room areas seen in the distance. Laundry conveniently located behind attractive double doors.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/22.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/22/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/22/440x.jpg
                                )

                        )

                    [23] => stdClass Object
                        (
                            [position] => 23
                            [description] => *NEW paint and *NEW carpet installed 9.18.24! Bedroom 2 boasts large double window and extra large closet overlooking private patio area. This room would be a great hobby room or studio!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/23.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/23/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/23/440x.jpg
                                )

                        )

                    [24] => stdClass Object
                        (
                            [position] => 24
                            [description] => *NEW paint 9.18.24! Beautiful full bathroom with convenient access for guests.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/24.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/24/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/24/440x.jpg
                                )

                        )

                    [25] => stdClass Object
                        (
                            [position] => 25
                            [description] => Locked and gated courtyard with landscaped borders along sidewalk.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/25.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/25/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/25/440x.jpg
                                )

                        )

                    [26] => stdClass Object
                        (
                            [position] => 26
                            [description] => Private patio/courtyard features gated access.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/26.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/26/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/26/440x.jpg
                                )

                        )

                    [27] => stdClass Object
                        (
                            [position] => 27
                            [description] => Striking foliage returns each year! Large, private patio area. Locked and gated courtyard with landscaped borders along sidewalk. Garage entry seen at door to right.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/27.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/27/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/27/440x.jpg
                                )

                        )

                    [28] => stdClass Object
                        (
                            [position] => 28
                            [description] => Lush landscaped borders welcome you and your guests from the rear of the home!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/28.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/28/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/28/440x.jpg
                                )

                        )

                    [29] => stdClass Object
                        (
                            [position] => 29
                            [description] => Garage entry and/or gated access to private courtyard/ porch.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/29.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/29/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/29/440x.jpg
                                )

                        )

                    [30] => stdClass Object
                        (
                            [position] => 30
                            [description] => This is the most convenient luxury location in Fairvue, within walking distance to essential shopping, dining, medical care, higher education and so much more!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/30.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/30/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/30/440x.jpg
                                )

                        )

                    [31] => stdClass Object
                        (
                            [position] => 31
                            [description] => Overview of Retreat at Fairvue. 244 Glennister is located on front right corner at bottom of drone image.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/31.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/31/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/31/440x.jpg
                                )

                        )

                    [32] => stdClass Object
                        (
                            [position] => 32
                            [description] => Overview of Retreat at Fairvue proximity to area amenities.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/32.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/32/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/32/440x.jpg
                                )

                        )

                    [33] => stdClass Object
                        (
                            [position] => 33
                            [description] => Amenities also include walking trails and easy lake access.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/33.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/33/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/33/440x.jpg
                                )

                        )

                    [34] => stdClass Object
                        (
                            [position] => 34
                            [description] => Lake life, country club life, or the good life any way you choose to live it!
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2705791/34.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2705791/34/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2705791/34/440x.jpg
                                )

                        )

                )

        )

    [key] => rt-2705791
    [added_at] => stdClass Object
        (
            [$date] => 2024-09-19T17:50:00Z
        )

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

    Interior Details

  • Bedrooms2
  • Bathrooms2
  • FeaturesHigh Ceilings, Pantry, Storage, Primary Bedroom Main Floor
  • AppliancesDishwasher, Disposal, ENERGY STAR Qualified Appliances, Microwave, Refrigerator
  • HVACArray

    Exterior Details

  • StyleTraditional
  • ConstructionBrick
  • Built In2016
  • Stories1
  • ParkingAttached
  • Garage Bays2
  • SewerPublic Sewer
  • Lot DescriptionCorner Lot, Level
  • Acres0.08

Request Information