stdClass Object
(
    [type] => Rental
    [status] => stdClass Object
        (
            [current] => Active
            [last] => Active
            [changed] => 2025-05-05T14:14:01
        )

    [ml_number] => 2866171
    [price] => stdClass Object
        (
            [amount] => 2225
            [original] => 2600
            [last_changed_on] => 2025-06-30T10:03:00
        )

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

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

    [description] => Welcome to 2508 Queen Bee Dr — this beautifully designed 5-bedroom, 3-bath home offers an awesome layout with room for everyone! Enjoy a private office (or 5th bedroom) on the main floor, plus a full hall bath and tons of storage with three large coat closets. The open-concept living room and kitchen feature abundant counter space, cabinets, and an adjacent dining area perfect for entertaining. Upstairs, a bright bonus room leads to 4 spacious bedrooms, including a primary suite with soaring ceilings and a massive walk-in closet. High ceilings throughout, a 2-car garage, and washer/dryer included complete the comfort. Pet Details: No Pets Allowed!
    [location] => stdClass Object
        (
            [city] => Columbia
            [state] => Tennessee
            [postal_code] => 38401
            [county] => Maury County, TN
            [subdivision] => Honey Farm Ph 2 Sec 3
            [street] => stdClass Object
                (
                    [number] => 2508
                    [name] => Queen Bee Dr
                    [full] => 2508 Queen Bee Dr
                )

            [directions] => Take I-65 South onto TN-396 Exit 53 (Saturn Pkwy) towards Columbia Exit left onto Hwy 31. Honey Farms will be on your left. Follow the LGI Homes Signs.  Information Ctr is on the left.
            [coordinates] => stdClass Object
                (
                    [latitude] => 35.623997
                    [longitude] => -87.00404
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.00404
                                    [1] => 35.623997
                                )

                        )

                )

        )

    [building] => stdClass Object
        (
            [square_feet] => stdClass Object
                (
                    [size] => 2743
                )

            [stories] => 2
            [built_in] => 2019
            [rooms] => stdClass Object
                (
                    [bed] => stdClass Object
                        (
                            [count] => 5
                        )

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

                )

            [appliances] => Array
                (
                    [0] => Dryer
                    [1] => Washer
                    [2] => Refrigerator
                    [3] => Microwave
                    [4] => Dishwasher
                    [5] => Oven
                    [6] => Range
                )

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

                )

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

        )

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

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

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

            [parking_spaces] => 2
            [school] => stdClass Object
                (
                    [elementary] => Battle Creek Elementary School
                    [junior] => Battle Creek Middle School
                    [high] => Spring Hill High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-06-30T14:03:00Z
        )

    [office] => stdClass Object
        (
            [name] => Gemstone Solutions Property Management and Realty
            [broker_id] => 3857
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Madeline
                            [last] => Gladden
                        )

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

                    [agent_id] => 72786
                )

            [1] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Matt
                            [last] => Phillips
                        )

                    [phone] => stdClass Object
                        (
                            [preferred] => 6159050322
                            [mobile] => 6152958676
                        )

                    [agent_id] => 45605
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2866171
    [added_at] => stdClass Object
        (
            [$date] => 2025-05-05T18:14:01Z
        )

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

    Interior Details

  • Bedrooms5
  • Bathrooms3
  • AppliancesDryer, Washer, Refrigerator, Microwave, Dishwasher, Oven, Range
  • HVACArray

    Exterior Details

  • Built In2019
  • Stories2
  • ParkingGarage Door Opener, Garage Faces Front
  • Garage Bays2
  • ServicesPark, Trail(s)
  • SewerPublic Sewer

Listing Brokerage: Gemstone Solutions Property Management and Realty
Listing Agent: Madeline Gladden () -

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of August 5, 2025 5:12pm. 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