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

    [ml_number] => 2792392
    [price] => stdClass Object
        (
            [amount] => 365000
            [original] => 365000
            [last_changed_on] => 2025-02-16T19:52:00
        )

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

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

    [description] => BUYER INCENTIVE! WHEN USING SELLER’S PREFERRED LENDER ERNESTO ALDRETE PMR - PREMIER MORTGAGE RESOURCES IS OFFERING 1% (UP TO $3,650) OF THE LOAN AMOUNT TOWARD THE BUYER’S CLOSING COSTS OR A RATE BUY DOWN!* Your charming 3 Bed, 2 Bath, 1930 sqft home in popular Fieldstone Farms awaits! Greeted by a stately Brick front, you'll step inside to discover a bright and inviting living space. This spacious one-level living home with huge Bonus room down just a couple steps offers a large living room with vaulted ceilings, refreshed paint and Brand NEW carpet in living room and bedrooms. Bonus room features its own private entrance, with NEW LVP flooring and paint. The primary suite includes tray ceiling, walk-in closet, and en-suite bath with double-sink vanity. Enjoy outdoor living in the in the large, fully privacy-fenced backyard with deck - perfect for entertaining or unwinding after a long day. HVAC NEW in 2023. Kitchen features ample wood cabinets with pantry, Stainless Steel refrigerator and microwave are newer- Fridge stays! Located in desirable location of Columbia, this home is just minutes from the Bypass, shopping & dining, and downtown Columbia making it an ideal location for convenience and community. Don’t miss your chance to own this lovely home in one of Columbia’s most desirable neighborhoods!
    [location] => stdClass Object
        (
            [city] => Columbia
            [state] => Tennessee
            [postal_code] => 38401
            [county] => Maury County, TN
            [subdivision] => Fieldstone Farms Sec 2
            [street] => stdClass Object
                (
                    [number] => 1937
                    [name] => Sheffield Ln
                    [full] => 1937 Sheffield Ln
                )

            [directions] => From I-65 S TN-396/Saturn Pkwy toward Columbia/Spring Hill, Merge onto US-31 S, Turn R onto US-412/US-43 S, Take exit toward Centerville, Turn L onto TN-50 W, Turn L onto Golden Pl, Turn L onto Farmington Ct, Turn R onto Sheffield Ln, House on Left.
            [coordinates] => stdClass Object
                (
                    [latitude] => 35.626607
                    [longitude] => -87.11443
                    [geo_json] => stdClass Object
                        (
                            [type] => Point
                            [coordinates] => Array
                                (
                                    [0] => -87.11443
                                    [1] => 35.626607
                                )

                        )

                )

        )

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

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

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

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

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

                )

            [features] => Array
                (
                    [0] => Ceiling Fan(s)
                    [1] => Primary Bedroom Main Floor
                )

            [appliances] => Array
                (
                    [0] => Electric Oven
                    [1] => Electric Range
                    [2] => Dishwasher
                    [3] => Microwave
                    [4] => Refrigerator
                )

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

                )

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

        )

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

            [land] => stdClass Object
                (
                    [size] => stdClass Object
                        (
                            [dimensions] => 75.00X134.94
                            [acres] => 0.23
                        )

                )

            [school] => stdClass Object
                (
                    [elementary] => J. R. Baker Elementary
                    [junior] => Whitthorne Middle School
                    [high] => Columbia Central High School
                )

        )

    [last_updated] => stdClass Object
        (
            [$date] => 2025-04-30T18:01:55Z
        )

    [office] => stdClass Object
        (
            [name] => Synergy Realty Network, LLC
            [broker_id] => 2476
        )

    [agents] => Array
        (
            [0] => stdClass Object
                (
                    [name] => stdClass Object
                        (
                            [first] => Elizabeth
                            [last] => Leanza
                        )

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

                    [agent_id] => 50212
                )

        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [5] => stdClass Object
                        (
                            [position] => 5
                            [description] => *Virtually staged to show design ideas.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2792392/5.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2792392/5/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2792392/5/440x.jpg
                                )

                        )

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

                        )

                    [7] => stdClass Object
                        (
                            [position] => 7
                            [description] => *Virtually staged to show design ideas.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2792392/7.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2792392/7/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2792392/7/440x.jpg
                                )

                        )

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

                        )

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

                        )

                    [10] => stdClass Object
                        (
                            [position] => 10
                            [description] => *Virtually staged to show design ideas.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2792392/10.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2792392/10/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2792392/10/440x.jpg
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [20] => stdClass Object
                        (
                            [position] => 20
                            [description] => *Virtually staged to show design ideas.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2792392/20.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2792392/20/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2792392/20/440x.jpg
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                    [29] => stdClass Object
                        (
                            [position] => 29
                            [description] => Bonus room - *Virtually staged to show design ideas.
                            [urls] => stdClass Object
                                (
                                    [original] => https://new.photos.idx.io/rt2/2792392/29.jpg
                                    [215x] => https://new.photos.idx.io/rt2/2792392/29/215x.jpg
                                    [440x] => https://new.photos.idx.io/rt2/2792392/29/440x.jpg
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

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

                        )

                )

        )

    [key] => rt-2792392
    [added_at] => stdClass Object
        (
            [$date] => 2025-02-17T00:52:00Z
        )

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

    Interior Details

  • Bedrooms3
  • Bathrooms2
  • BasementCrawl Space
  • FeaturesCeiling Fan(s), Primary Bedroom Main Floor
  • AppliancesElectric Oven, Electric Range, Dishwasher, Microwave, Refrigerator
  • HVACArray

    Exterior Details

  • ConstructionBrick, Vinyl Siding
  • Built In2004
  • Stories1
  • SewerPublic Sewer
  • Lot Dimensions75.00X134.94
  • Acres0.23

Listing Brokerage: Synergy Realty Network, LLC
Listing Agent: Elizabeth Leanza (615) 490-4953

Listings courtesy of Realtracs as distributed by MLS GRID

RealTracs MLS GRID Based on information submitted to the MLS GRID as of May 10, 2025 3:46am. 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