Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:1 [ "RF Cache Key: fb9824a200da4ccb54d54c23743d9810ddc10cf6513274b59a1cfc7cdadf5e44" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3757 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3210 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "597499" +"ListingId": "597499" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-22T22:26:00Z" +"RFModificationTimestamp": "2025-05-22T22:33:49Z" +"ListPrice": 280000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.283 +"LivingArea": 1756.0 +"BuildingAreaTotal": 1956.0 +"City": "Columbia" +"PostalCode": "29229" +"UnparsedAddress": "4 Box Turtle Court, Columbia, Sc 29229" +"Coordinates": array:2 [ 0 => -80.864279 1 => 34.145313 ] +"Latitude": 34.145313 +"Longitude": -80.864279 +"YearBuilt": 1999 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "First Trust Real Est Serv LLC" +"ListAgentMlsId": "5353" +"ListOfficeMlsId": "914" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Come check out this all-brick home. All the rooms are spacious. It has high ceilings, cathedral ceilings, and crown molding in various areas of the home. It is "carpet free" boasting hardwood and luxury vinyl plank (LVP) throughout the house. If you want to take in the sun, but you don't want to go outside on the freshly painted stained deck, well you can relax in the heated/cooled sunroom. The master suite has a separate shower, garden tub, and a good size walk in closet. This is a very desirable neighborhood with sidewalks, and good schools. it is located just minutes from all the shopping amenities and I-77. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Dryer,Refrigerator,Washer,Microwave Above Stove,Gas Water Heater" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Brick-All Sides-AbvFound" +"Cooling": "Central" +"CountyOrParish": "Richland" +"CreationDate": "2025-03-20T04:17:18.230878+00:00" +"Directions": "Clemson to Rhame, 1.5 miles to Turtle Creek entrance on the right, left onto Loggerhead, left onto Box Turtle, the house is on the right." +"ExteriorFeatures": "Deck" +"FireplaceFeatures": "Gas Log-Natural" +"Heating": "Central" +"InteriorFeatures": "Attic Storage,Garage Opener" +"LaundryFeatures": "Closet" +"ListAgentEmail": "Acmccoy7@yahoo.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OriginalEntryTimestamp": "2024-11-23" +"PhotosChangeTimestamp": "2024-11-23T14:04:19Z" +"PhotosCount": "24" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Cabinets-Natural,Eat In,Counter Tops-Granite,Floors - Other" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Box Turtle" +"StreetNumber": "4" +"StreetSuffix": "Court" +"SubdivisionName": "TURTLE CREEK" +"WaterSource": "Public" +"Baths Full": "2" +"2nd Bedroom": "Ceiling Fan,Closet-Private,Floors-Hardwood" +"Address": "4 Box Turtle Court" +"Assn Fee": "150" +"Great Room": "Ceilings-Cathedral,Fireplace,Floors-Hardwood,Ceiling Fan" +"Assoc Fee Includes": "Common Area Maintenance,Road Maintenance" +"New/Resale": "Resale" +"Level-Other Room 2": "Main" +"# of Stories": "1.5" +"Baths": "2" +"LO1Office Identifier": "914" +"Power On": "Yes" +"LO1Main Office ID": "914" +"Level-Kitchen": "Main" +"Half Baths-Main": "0" +"Full Baths-Main": "2" +"Lockbox Number": "32801316" +"Price Per SQFT": "159.45" +"LO1Office Abbreviation": "FTRE01" +"Range": "Gas,Self Clean" +"High School": "Ridge View" +"Level-Formal Dining Room": "Main" +"Agent Hit Count": "241" +"Garage Spaces": "2" +"Level-Washer Dryer": "Main" +"LA1User Code": "MCCOYA" +"Avail Financing": "Cash,Conventional,FHA,VA" +"LA1Agent First Name": "Arleen" +"Baths Combo": "2 / 0" +"Address Search Number": "4" +"Level-Master Bedroom": "Main" +"School District": "Richland Two" +"LVT Date": "2024-11-23" +"Middle School": "Summit" +"3rd Bedroom": "Ceiling Fan,Closet-Private,Floors-Hardwood" +"Interior # of Fireplaces": "1" +"Status Detail": "0" +"Master Bedroom": "Double Vanity,Tub-Garden,Bath-Private,Separate Shower,Closet-Walk in,Ceilings-Box,Ceiling Fan,Floors-Hardwood" +"Other Heated SqFt": "200" +"Detitled Mobile Y/N": "N" +"Listing Type Agreement": "Exclusive Right to Sell" +"Geo Subdivision": "SC" +"class_name": "RE_1" +"Short Sale Y/N": "No" +"Level-Bedroom 3": "Main" +"Level-Great Room": "Main" +"Rollback Tax (Y/N)": "No" +"IDX Include": "Yes" +"Level-Bedroom 2": "Main" +"List Price Tot SqFt": "159.45" +"Level-Other Room": "Main" +"Elementary School": "Bookman Road" +"Publish to Internet Y/N": "Yes" +"First Photo Add Timestamp": "2024-11-23T14:04:19.9" +"Garage": "Garage Attached, Front Entry" +"LA1Agent Last Name": "Irby" +"Senior Living Y/N": "N" +"Assn/Regime Fee Per": "Yearly" +"TMS": "25904-01-24" +"Formal Dining Room": "Area,Floors-Hardwood" +"Geo Update Timestamp": "2024-11-23T14:04:18.8" +"Other Rooms": "Sun Room,FROG (No Closet)" +"Foreclosed Property": "No" +"PrivatePoolYN": "No" +"MlsAreaMajor": "Columbia Northeast" +"Media": array:24 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "5974990" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/de9984e3051688573eb80ebb72fc710b.webp" "MediaSize" => 582011 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-de9984e3051688573eb80ebb72fc710b.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "5974991" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/b81538dfd6a3cce1303a81fa62719987.webp" "MediaSize" => 507241 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-b81538dfd6a3cce1303a81fa62719987.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "5974992" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/c9cc83926c6ab06e4023c1f9e6728375.webp" "MediaSize" => 457382 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-c9cc83926c6ab06e4023c1f9e6728375.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "5974993" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/0e926eacd209412a79868f035764407e.webp" "MediaSize" => 472517 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-0e926eacd209412a79868f035764407e.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "5974994" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/df13a8939bfe7a43aecb6ef6221dbc26.webp" "MediaSize" => 554101 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-df13a8939bfe7a43aecb6ef6221dbc26.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "5974995" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/045b86b656a22b10bcd82a7755fec069.webp" "MediaSize" => 497870 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-045b86b656a22b10bcd82a7755fec069.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "5974996" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/a8778ebf8adf8f3a24d18fd1f930c413.webp" "MediaSize" => 331391 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-a8778ebf8adf8f3a24d18fd1f930c413.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "5974997" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/e519a6ac72ee87e81a4239ea7cce3674.webp" "MediaSize" => 478056 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-e519a6ac72ee87e81a4239ea7cce3674.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "5974998" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/306e83711d6ba965f07cb806d8c33c1c.webp" "MediaSize" => 522810 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-306e83711d6ba965f07cb806d8c33c1c.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "5974999" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/8cbe50ec1cf85644417104f609f20222.webp" "MediaSize" => 537371 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-8cbe50ec1cf85644417104f609f20222.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "59749910" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/a866d8d6905844eb82eef5b03a6f1a2f.webp" "MediaSize" => 446189 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-a866d8d6905844eb82eef5b03a6f1a2f.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "59749911" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/482955c05f5ce52b98499e041e65402e.webp" "MediaSize" => 521719 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-482955c05f5ce52b98499e041e65402e.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "59749912" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/849a94a60aabcdf88920afe9207325a4.webp" "MediaSize" => 292198 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-849a94a60aabcdf88920afe9207325a4.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "59749913" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/fc1eb7a9b465502796c7160aa78aafc8.webp" "MediaSize" => 316511 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-fc1eb7a9b465502796c7160aa78aafc8.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "59749914" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/f45611798573b0eaa0136c2be6ae09f4.webp" "MediaSize" => 342073 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-f45611798573b0eaa0136c2be6ae09f4.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "59749915" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/18a8d9ca328f512d866a328ae18d6caa.webp" "MediaSize" => 460813 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-18a8d9ca328f512d866a328ae18d6caa.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "59749916" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/bf1370c8e64b81dccddcca222a9abd6d.webp" "MediaSize" => 442302 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-bf1370c8e64b81dccddcca222a9abd6d.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "59749917" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/84d8a190ef27d3f3a5fcecbf4c521a60.webp" "MediaSize" => 400051 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-84d8a190ef27d3f3a5fcecbf4c521a60.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "59749918" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/e4866a1bdc39835ea861b06f79c7caad.webp" "MediaSize" => 356921 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-e4866a1bdc39835ea861b06f79c7caad.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "59749919" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/8c076feb944d28751b06a36248757b68.webp" "MediaSize" => 320613 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-8c076feb944d28751b06a36248757b68.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "59749920" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/7b4c1b2a7d7755ac6e03000e0af1f05c.webp" "MediaSize" => 334968 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-7b4c1b2a7d7755ac6e03000e0af1f05c.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 21 => array:11 [ "Order" => 21 "MediaKey" => "59749921" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/229df35f25abc734c8b37a6e31b59279.webp" "MediaSize" => 336780 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-229df35f25abc734c8b37a6e31b59279.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 22 => array:11 [ "Order" => 22 "MediaKey" => "59749922" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/bb8227614531bed5f5bbb622a17e2e26.webp" "MediaSize" => 543823 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-bb8227614531bed5f5bbb622a17e2e26.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 23 => array:11 [ "Order" => 23 "MediaKey" => "59749923" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597499/a5497ce9ceb7b929ec4d46083e317fd1.webp" "MediaSize" => 612020 "ResourceRecordKey" => "597499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597499/thumbnail-a5497ce9ceb7b929ec4d46083e317fd1.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('597499')" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } ] ]
