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: 495a66f022a2780f34c4022b552a9e9eb0aba4f81c8081d92ef212756f629082" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3758 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3210 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "620067" +"ListingId": "620067" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-04T21:00:08Z" +"RFModificationTimestamp": "2025-11-04T21:07:37Z" +"ListPrice": 479500.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.26 +"LivingArea": 1963.0 +"BuildingAreaTotal": 1963.0 +"City": "Columbia" +"PostalCode": "29204" +"UnparsedAddress": "3111 Trenholm Road, Columbia, SC 29204" +"Coordinates": array:2 [ 0 => -80.996105 1 => 34.009348 ] +"Latitude": 34.009348 +"Longitude": -80.996105 +"YearBuilt": 1952 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Wolfe and Taylor Inc" +"ListAgentMlsId": "9220" +"ListOfficeMlsId": "1015" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Charming Heathwood Bungalow! Well-maintained 3-bedroom, 3-bath home located in the highly sought-after Heathwood neighborhood. This 1,963 sq. ft. bungalow features beautiful hardwood floors throughout, a welcoming living room with fireplace, formal dining room, and a bright sunroom. The spacious kitchen offers ample cabinetry, stainless steel appliances & counter top, and an eat-in area perfect for everyday meals. Enjoy outdoor living in the large fenced backyard with a deck, plenty of parking, and storage building. Conveniently located near shopping, dining, and downtown Columbia. Zoned for award winning schools to include Satchel Ford Elementary. This home combines classic charm with comfortable living—ready for its next owner to love! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Dryer,Refrigerator,Washer" +"ArchitecturalStyle": "Bungalow" +"AssociationYN": false +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Brick-All Sides-AbvFound" +"Cooling": "Central" +"CountyOrParish": "Richland" +"CreationDate": "2025-10-22T15:18:22.487692+00:00" +"Directions": "Gervais Street to Trenholm Road. House on left, just past Glenwood." +"ExteriorFeatures": "Deck,Shed,Landscape Lighting,Gutters - Full" +"Fencing": "Privacy Fence" +"FireplaceFeatures": "Gas Log-Natural" +"Heating": "Central,Gas 1st Lvl" +"InteriorFeatures": "Attic Pull-Down Access,Attic Storage,BookCase,Ceiling Fan,Security System-Owned,Smoke Detector" +"ListAgentEmail": "chachere@wolfeandtaylor.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OriginalEntryTimestamp": "2025-10-21" +"PhotosChangeTimestamp": "2025-10-23T13:00:12Z" +"PhotosCount": "28" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Eat In,Pantry,Floors-Tile,Counter Tops - Other,Backsplash-Other,Cabinets-Painted" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Trenholm" +"StreetNumber": "3111" +"StreetSuffix": "Road" +"SubdivisionName": "HEATHWOOD" +"WaterSource": "Public" +"TMS": "13903-05-32" +"Baths": "3" +"Range": "Free-standing,Smooth Surface" +"Energy": "Storm Doors,Storm Windows" +"Garage": "None" +"Address": "3111 Trenholm Road" +"LVTDate": "2025-10-22" +"PowerOn": "Yes" +"Handicap": "Ramp" +"BathsFull": "3" +"#ofStories": "1" +"2ndBedroom": "Bath-Private,Separate Shower,Closet-Walk in,Whirlpool,Ceilings-High (over 9 Ft),Ceiling Fan,Floors-Hardwood" +"3rdBedroom": "Ceilings-High (over 9 Ft),Ceiling Fan,Floors-Hardwood" +"BathsCombo": "3 / 0" +"HighSchool": "A. C. Flora" +"IDXInclude": "Yes" +"LivingRoom": "Fireplace,Floors-Hardwood,Molding,Ceilings-High (over 9 Ft)" +"New/Resale": "Resale" +"OtherRooms": "Sun Room" +"class_name": "RE_1" +"LA1UserCode": "FREEMANC" +"GarageSpaces": "0" +"MiddleSchool": "Crayton" +"PricePerSQFT": "244.27" +"StatusDetail": "0" +"AgentHitCount": "116" +"Level-Kitchen": "Main" +"LockboxNumber": "31679783" +"MasterBedroom": "Bath-Private,Separate Shower,Closet-Walk in,Ceilings-High (over 9 Ft),Ceiling Fan,Floors-Hardwood" +"Miscellaneous": "Built-ins,Cable TV Available" +"FullBaths-Main": "3" +"GeoSubdivision": "SC" +"HalfBaths-Main": "0" +"Level-Bedroom2": "Main" +"Level-Bedroom3": "Main" +"SchoolDistrict": "Richland One" +"LO1MainOfficeID": "1015" +"Level-OtherRoom": "Main" +"OtherHeatedSqFt": "0" +"ElementarySchool": "Satchel Ford" +"FormalDiningRoom": "Floors-Hardwood,Molding,Ceilings-High (over 9 Ft)" +"LA1AgentLastName": "Freeman" +"Level-LivingRoom": "Main" +"ListPriceTotSqFt": "244.27" +"RollbackTax(Y/N)": "No" +"LA1AgentFirstName": "Chachere" +"Level-WasherDryer": "Main" +"GeoUpdateTimestamp": "2025-10-22T15:13:56.7" +"AddressSearchNumber": "3111" +"LO1OfficeIdentifier": "1015" +"Level-MasterBedroom": "Main" +"ListingTypeAgreement": "Exclusive Right to Sell" +"PublishtoInternetY/N": "Yes" +"Interior#ofFireplaces": "1" +"LO1OfficeAbbreviation": "WOTA01" +"FirstPhotoAddTimestamp": "2025-10-22T15:13:59.4" +"Level-FormalDiningRoom": "Main" +"MlsAreaMajor": "East Columbia" +"Media": array:28 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6200670" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/2f1bf6de74505d3640fd2a7a30b296bd.webp" "ClassName" => "Single Family" "MediaSize" => 778834 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-2f1bf6de74505d3640fd2a7a30b296bd.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6200671" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/fdce84ad54e2dd1491a392c2967a2713.webp" "ClassName" => "Single Family" "MediaSize" => 849188 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-fdce84ad54e2dd1491a392c2967a2713.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6200672" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/c75a5c18d0a183e9c5fbc3bb2870b9d8.webp" "ClassName" => "Single Family" "MediaSize" => 779086 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-c75a5c18d0a183e9c5fbc3bb2870b9d8.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6200673" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/bc93943469ba17418ddd7fd1a8198985.webp" "ClassName" => "Single Family" "MediaSize" => 384309 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-bc93943469ba17418ddd7fd1a8198985.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6200674" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/c9b858d8d05674e4ed77d93b43269055.webp" "ClassName" => "Single Family" "MediaSize" => 315512 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-c9b858d8d05674e4ed77d93b43269055.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6200675" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/98e91ac42430040ba9153592236dc690.webp" "ClassName" => "Single Family" "MediaSize" => 407419 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-98e91ac42430040ba9153592236dc690.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6200676" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/d5a6b9e33e6356ac1324ea708cc53dc8.webp" "ClassName" => "Single Family" "MediaSize" => 391579 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-d5a6b9e33e6356ac1324ea708cc53dc8.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6200677" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/c572ae1fc8329c2f042820ef354f0764.webp" "ClassName" => "Single Family" "MediaSize" => 371551 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-c572ae1fc8329c2f042820ef354f0764.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6200678" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/5cf54a36d8b49a74223d738e40104923.webp" "ClassName" => "Single Family" "MediaSize" => 374137 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-5cf54a36d8b49a74223d738e40104923.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6200679" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/2b4ec35f33e925841971646157ce265f.webp" "ClassName" => "Single Family" "MediaSize" => 308984 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-2b4ec35f33e925841971646157ce265f.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "62006710" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/353c79614ccd85d399df4cf9ad9a8874.webp" "ClassName" => "Single Family" "MediaSize" => 394095 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-353c79614ccd85d399df4cf9ad9a8874.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "62006711" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/a435fa54b3c0810ae09b695cb8e00752.webp" "ClassName" => "Single Family" "MediaSize" => 405921 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-a435fa54b3c0810ae09b695cb8e00752.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "62006712" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/fe5e94626a581c5674f0bd1e64ecdc46.webp" "ClassName" => "Single Family" "MediaSize" => 457130 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-fe5e94626a581c5674f0bd1e64ecdc46.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "62006713" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/3c27f32c903b597562ff52e6d6d61dc9.webp" "ClassName" => "Single Family" "MediaSize" => 444490 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-3c27f32c903b597562ff52e6d6d61dc9.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "62006714" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/eca14879767a028c026f380177d4593b.webp" "ClassName" => "Single Family" "MediaSize" => 274858 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-eca14879767a028c026f380177d4593b.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "62006715" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/6b5f3493b4cb3985c090d3596635a857.webp" "ClassName" => "Single Family" "MediaSize" => 310227 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-6b5f3493b4cb3985c090d3596635a857.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "62006716" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/bd1a9982fce15af38734176ad04415ba.webp" "ClassName" => "Single Family" "MediaSize" => 287891 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-bd1a9982fce15af38734176ad04415ba.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "62006717" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/e9eb4b24c469e88f46fcbd0de436fb1b.webp" "ClassName" => "Single Family" "MediaSize" => 269189 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-e9eb4b24c469e88f46fcbd0de436fb1b.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "62006718" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/d0824aa87e9f4a857093962a4ef72c7c.webp" "ClassName" => "Single Family" "MediaSize" => 300584 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-d0824aa87e9f4a857093962a4ef72c7c.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "62006719" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/99cbf4c0674c4c16871f2de2674e633a.webp" "ClassName" => "Single Family" "MediaSize" => 317015 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-99cbf4c0674c4c16871f2de2674e633a.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "62006720" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/25d0d9bd1d8440261bd7f547dd77abc2.webp" "ClassName" => "Single Family" "MediaSize" => 209894 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-25d0d9bd1d8440261bd7f547dd77abc2.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 21 => array:11 [ "Order" => 21 "MediaKey" => "62006721" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/75485f4687355239b30ed5739d52de29.webp" "ClassName" => "Single Family" "MediaSize" => 355192 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-75485f4687355239b30ed5739d52de29.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 22 => array:11 [ "Order" => 22 "MediaKey" => "62006722" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/46e5bf0adbf9df5bde72cc7607ce8a15.webp" "ClassName" => "Single Family" "MediaSize" => 311446 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-46e5bf0adbf9df5bde72cc7607ce8a15.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 23 => array:11 [ "Order" => 23 "MediaKey" => "62006723" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/25c7062f5c943ff59e4e80f3a2e5d277.webp" "ClassName" => "Single Family" "MediaSize" => 411297 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-25c7062f5c943ff59e4e80f3a2e5d277.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 24 => array:11 [ "Order" => 24 "MediaKey" => "62006724" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/06b99a68d06787e398ddc4fbaa1faf47.webp" "ClassName" => "Single Family" "MediaSize" => 680598 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-06b99a68d06787e398ddc4fbaa1faf47.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 25 => array:11 [ "Order" => 25 "MediaKey" => "62006725" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/f26cf01ce124e7e16f343e539136e3a7.webp" "ClassName" => "Single Family" "MediaSize" => 672722 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-f26cf01ce124e7e16f343e539136e3a7.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 26 => array:11 [ "Order" => 26 "MediaKey" => "62006726" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/340a10dc926b9d99726c26b354f2cdbf.webp" "ClassName" => "Single Family" "MediaSize" => 775205 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-340a10dc926b9d99726c26b354f2cdbf.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] 27 => array:11 [ "Order" => 27 "MediaKey" => "62006727" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/620067/72b05478368ec6601503592d3791d9d7.webp" "ClassName" => "Single Family" "MediaSize" => 851425 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/620067/thumbnail-72b05478368ec6601503592d3791d9d7.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "620067" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('620067')" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } ] ]
