Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(ExteriorFeatures eq 'Dishwasher,Disposal,Dryer,Freezer,Icemaker,Refrigerator,Washer,Microwave Above Stove' OR InteriorFeatures eq 'Dishwasher,Disposal,Dryer,Freezer,Icemaker,Refrigerator,Washer,Microwave Above Stove' OR Appliances eq 'Dishwasher,Disposal,Dryer,Freezer,Icemaker,Refrigerator,Washer,Microwave Above Stove')/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(ExteriorFeatures eq 'Dishwasher,Disposal,Dryer,Freezer,Icemaker,Refrigerator,Washer,Microwave Above Stove' OR InteriorFeatures eq 'Dishwasher,Disposal,Dryer,Freezer,Icemaker,Refrigerator,Washer,Microwave Above Stove' OR Appliances eq 'Dishwasher,Disposal,Dryer,Freezer,Icemaker,Refrigerator,Washer,Microwave Above Stove')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(ExteriorFeatures eq 'Dishwasher,Disposal,Dryer,Freezer,Icemaker,Refrigerator,Washer,Microwave Above Stove' OR InteriorFeatures eq 'Dishwasher,Disposal,Dryer,Freezer,Icemaker,Refrigerator,Washer,Microwave Above Stove' OR Appliances eq 'Dishwasher,Disposal,Dryer,Freezer,Icemaker,Refrigerator,Washer,Microwave Above Stove')/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(ExteriorFeatures eq 'Dishwasher,Disposal,Dryer,Freezer,Icemaker,Refrigerator,Washer,Microwave Above Stove' OR InteriorFeatures eq 'Dishwasher,Disposal,Dryer,Freezer,Icemaker,Refrigerator,Washer,Microwave Above Stove' OR Appliances eq 'Dishwasher,Disposal,Dryer,Freezer,Icemaker,Refrigerator,Washer,Microwave Above Stove')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3223 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3221 +post_id: "116058" +post_author: 1 +"ListingKey": "620271" +"ListingId": "620271" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-12-05T07:00:58Z" +"RFModificationTimestamp": "2025-12-05T07:13:05Z" +"ListPrice": 270000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.28 +"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": "Century 21 803 Realty" +"ListAgentMlsId": "10178" +"ListOfficeMlsId": "1073" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Welcome home to this gorgeous all-brick home offering nearly 2,000 square feet of comfortable living space. Located in Northeast Columbia, in the award-winning Richland 2 School District, this home features hardwood flooring throughout, and a semi-open floor plan with a spacious great room boasting cathedral ceilings, perfect for everyday living and entertaining. The kitchen comes loaded with GE stainless steel appliances, and a washer and dryer are also included for your convenience. Enjoy the added versatility of an enclosed, heated and cooled sunroom with LVP flooring, ideal for relaxing year-round, plus a bonus room with LVP flooring, excellent as a home office, playroom, or hobby space. This beauty sits in a prime location, close to shopping, dining, and with easy access to I-20, making your commute a breeze. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Dryer,Freezer,Icemaker,Refrigerator,Washer,Microwave Above Stove" +"ArchitecturalStyle": "Ranch" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Brick-All Sides-AbvFound" +"Cooling": "Central,Gas Pac" +"CountyOrParish": "Richland" +"CreationDate": "2025-10-24T14:57:20.695304+00:00" +"Directions": "Take I-20 E to Exit 80 (Clemson Rd) and turn left. Go 4.1 mi, turn right on Rhame Rd. After 1.4 mi, turn right on Turtle Creek Dr, then left on Loggerhead Dr, and first left on Box Turtle Ct. Home is on the right." +"ExteriorFeatures": "Deck" +"Fencing": "NONE" +"Heating": "Central" +"LaundryFeatures": "Closet,Heated Space" +"ListAgentEmail": "ljandrews.29@gmail.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2025-10-24" +"PhotosChangeTimestamp": "2025-12-05T07:00:58Z" +"PhotosCount": "23" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Cabinets-Natural,Eat In,Counter Tops-Granite" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Box Turtle" +"StreetNumber": "4" +"StreetSuffix": "Court" +"SubdivisionName": "TURTLE CREEK" +"WaterSource": "Public" +"TMS": "25904-01-24" +"Baths": "2" +"Range": "Free-standing,Gas,Self Clean" +"Garage": "Garage Attached, Front Entry" +"Address": "4 Box Turtle Court" +"AssnFee": "150" +"LVTDate": "2025-10-24" +"PowerOn": "Yes" +"BathsFull": "2" +"GreatRoom": "Ceilings-Cathedral,Fireplace,Floors-Hardwood,Molding,Ceiling Fan" +"#ofStories": "1.5" +"2ndBedroom": "Bath-Shared,Tub-Shower,Ceiling Fan,Closet-Private,Floors-Hardwood" +"3rdBedroom": "Bath-Shared,Tub-Shower,Ceiling Fan,Closet-Private,Floors-Hardwood" +"BathsCombo": "2 / 0" +"HighSchool": "Ridge View" +"IDXInclude": "Yes" +"New/Resale": "Resale" +"OtherRooms": "Bonus-Finished,FROG (No Closet)" +"class_name": "RE_1" +"GarageLevel": "Main" +"LA1UserCode": "TAYLORLI" +"GarageSpaces": "2" +"MiddleSchool": "Summit" +"PricePerSQFT": "153.76" +"ShortSaleY/N": "No" +"StatusDetail": "0" +"AgentHitCount": "72" +"Level-Kitchen": "Main" +"LockboxNumber": "32808363" +"MasterBedroom": "Double Vanity,Tub-Garden,Bath-Private,Separate Shower,Closet-Walk in,Ceiling Fan,Floors-Hardwood" +"FullBaths-Main": "2" +"GeoSubdivision": "SC" +"HalfBaths-Main": "0" +"Level-Bedroom2": "Main" +"Level-Bedroom3": "Main" +"SchoolDistrict": "Richland Two" +"LO1MainOfficeID": "1073" +"Level-GreatRoom": "Main" +"Level-OtherRoom": "Second" +"OtherHeatedSqFt": "200" +"ElementarySchool": "Bookman Road" +"FormalDiningRoom": "Floors-Hardwood,Molding,Ceiling Fan" +"LA1AgentLastName": "Taylor" +"ListPriceTotSqFt": "153.76" +"RollbackTax(Y/N)": "No" +"Assn/RegimeFeePer": "Yearly" +"LA1AgentFirstName": "Lindsey" +"Level-WasherDryer": "Main" +"ForeclosedProperty": "No" +"GeoUpdateTimestamp": "2025-10-24T14:52:54.8" +"AddressSearchNumber": "4" +"LO1OfficeIdentifier": "1073" +"Level-MasterBedroom": "Main" +"ListingTypeAgreement": "Exclusive Right to Sell" +"PublishtoInternetY/N": "Yes" +"Interior#ofFireplaces": "1" +"LO1OfficeAbbreviation": "WIHS01" +"FirstPhotoAddTimestamp": "2025-10-24T14:52:55.4" +"Level-FormalDiningRoom": "Main" +"MlsAreaMajor": "Columbia Northeast" +"PrivatePoolYN": "No" +"Media": array:23 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6202710" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/8d07af5f48c15fa171ae837577985993.webp" "ClassName" => "Single Family" "MediaSize" => 830301 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-8d07af5f48c15fa171ae837577985993.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6202711" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/fe078a5af5f8cdd842257fe47fafc2e7.webp" "ClassName" => "Single Family" "MediaSize" => 275725 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-fe078a5af5f8cdd842257fe47fafc2e7.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6202712" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/0158a9cff56ce7b15132872eae89e8ef.webp" "ClassName" => "Single Family" "MediaSize" => 326111 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-0158a9cff56ce7b15132872eae89e8ef.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6202713" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/325b95794fe2c722f7dc79685f64a092.webp" "ClassName" => "Single Family" "MediaSize" => 305318 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-325b95794fe2c722f7dc79685f64a092.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6202714" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/1746a498f35acc0d7ac883c3bd72c732.webp" "ClassName" => "Single Family" "MediaSize" => 255363 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-1746a498f35acc0d7ac883c3bd72c732.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6202715" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/16c9f330a016462d92175d9bb7dad2be.webp" "ClassName" => "Single Family" "MediaSize" => 422300 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-16c9f330a016462d92175d9bb7dad2be.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6202716" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/c66ac1f8d42b2470f699140c6b1380d8.webp" "ClassName" => "Single Family" "MediaSize" => 319759 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-c66ac1f8d42b2470f699140c6b1380d8.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6202717" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/5f5da75bbe35b8a22346b28b30904ec0.webp" "ClassName" => "Single Family" "MediaSize" => 204274 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-5f5da75bbe35b8a22346b28b30904ec0.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6202718" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/2d421a63210f84bae3a005464d2cb22e.webp" "ClassName" => "Single Family" "MediaSize" => 221977 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-2d421a63210f84bae3a005464d2cb22e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6202719" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/ca534c07e7c4f2ece37cdf3068ad5761.webp" "ClassName" => "Single Family" "MediaSize" => 211261 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-ca534c07e7c4f2ece37cdf3068ad5761.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "62027110" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/0e6aa1673f4905c7531d1a22e11d70a5.webp" "ClassName" => "Single Family" "MediaSize" => 137543 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-0e6aa1673f4905c7531d1a22e11d70a5.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "62027111" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/d5ce931b932d8eba2114573aaf38ed7b.webp" "ClassName" => "Single Family" "MediaSize" => 184499 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-d5ce931b932d8eba2114573aaf38ed7b.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "62027112" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/c0da960cb8d58f8ebb5a11889c047330.webp" "ClassName" => "Single Family" "MediaSize" => 179234 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-c0da960cb8d58f8ebb5a11889c047330.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "62027113" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/4c0093d4721fbd49ce5d4603df4359a1.webp" "ClassName" => "Single Family" "MediaSize" => 291659 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-4c0093d4721fbd49ce5d4603df4359a1.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "62027114" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/f8887e64828aec8221fe3836755a809a.webp" "ClassName" => "Single Family" "MediaSize" => 223007 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-f8887e64828aec8221fe3836755a809a.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "62027115" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/280aab94060265859f359aa71f91e859.webp" "ClassName" => "Single Family" "MediaSize" => 322491 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-280aab94060265859f359aa71f91e859.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "62027116" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/c60eb4d1ee982ea2ce7e475735741d84.webp" "ClassName" => "Single Family" "MediaSize" => 295619 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-c60eb4d1ee982ea2ce7e475735741d84.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "62027117" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/bc08869b5edd8584c4da6d8ccb518c98.webp" "ClassName" => "Single Family" "MediaSize" => 360141 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-bc08869b5edd8584c4da6d8ccb518c98.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "62027118" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/a9b88b176afbc17e64ff89ca8c13504b.webp" "ClassName" => "Single Family" "MediaSize" => 568276 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-a9b88b176afbc17e64ff89ca8c13504b.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "62027119" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/802a3ec5d52f61ef5aefa14779dcc38e.webp" "ClassName" => "Single Family" "MediaSize" => 1007929 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-802a3ec5d52f61ef5aefa14779dcc38e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "62027120" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/dd6ca7474305144699e302a6906fd482.webp" "ClassName" => "Single Family" "MediaSize" => 1023161 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-dd6ca7474305144699e302a6906fd482.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 21 => array:11 [ "Order" => 21 "MediaKey" => "62027121" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/8b8709c5b914421a1f705c6f7e061661.webp" "ClassName" => "Single Family" "MediaSize" => 1083568 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-8b8709c5b914421a1f705c6f7e061661.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] 22 => array:11 [ "Order" => 22 "MediaKey" => "62027122" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620271/8f04be301498f36aa520553e76091cde.webp" "ClassName" => "Single Family" "MediaSize" => 1067295 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620271/thumbnail-8f04be301498f36aa520553e76091cde.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620271" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('620271')" +"ID": "116058" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.23 seconds" ] "RF Cache Key: 25e93f6f9b7850fd50ecc1dd9d214afa7c6e91a0fdd78b9bf01d50f8f5572ff7" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3218 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3221} ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } ] ]
