array:3 [
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(Appliances eq 'Microwave Countertop' OR ArchitecturalStyle eq 'Microwave Countertop' OR CommunityFeatures eq 'Microwave Countertop' OR Cooling eq 'Microwave Countertop' OR CountyOrParish eq 'Microwave Countertop' OR ElementarySchool eq 'Microwave Countertop' OR ExteriorFeatures eq 'Microwave Countertop' OR Flooring eq 'Microwave Countertop' OR Heating eq 'Microwave Countertop' OR HighSchool eq 'Microwave Countertop' OR InteriorFeatures eq 'Microwave Countertop' OR ListingTerms eq 'Microwave Countertop' OR MiddleOrJuniorSchool eq 'Microwave Countertop' OR ParkingFeatures eq 'Microwave Countertop' OR PoolFeatures eq 'Microwave Countertop' OR PropertyType eq 'Microwave Countertop' OR Roof eq 'Microwave Countertop' OR SchoolDistrict eq 'Microwave Countertop' OR Sewer eq 'Microwave Countertop' OR Utilities eq 'Microwave Countertop' OR WaterfrontFeatures eq 'Microwave Countertop') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3429
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3427
+post_id: "131856"
+post_author: 1
+"ListingKey": "637032"
+"ListingId": "637032"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T15:20:27Z"
+"RFModificationTimestamp": "2026-06-23T15:27:19Z"
+"ListPrice": 239900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.1
+"LivingArea": 1412.0
+"BuildingAreaTotal": 1412.0
+"City": "West Columbia"
+"PostalCode": "29169"
+"UnparsedAddress": "311 Hudson Street, West Columbia, SC 29169"
+"Coordinates": array:2 [
0 => -81.053069
1 => 33.992253
]
+"Latitude": 33.992253
+"Longitude": -81.053069
+"YearBuilt": 1905
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "The Real Estate Company"
+"ListAgentMlsId": "6658"
+"ListOfficeMlsId": "1968"
+"OriginatingSystemName": "columbiamls"
+"PublicRemarks": "Charming 1905 home ideally located just minutes from Downtown Columbia, USC, shopping, dining, and entertainment. Situated in a revitalizing area on the outskirts of The Avenues, this neighborhood is being improved with new construction, renovated historic homes, upgraded water lines, repaved roads, and a recently renovated park at the end of the street. Full of character, this home has benefited from numerous major system updates over the past nine years, including electrical improvements, replacement ductwork, roof replacement, added insulation, crawl space improvements (sump pump, dehumidifier, and vapor barrier), HVAC condenser replacement, and a newer air handler coil. Additional features include ceiling-mounted speakers on the main level and a reverse osmosis water filtration system. Downstairs, there is a living room, kitchen, laundry room, full bathroom. There is also a small room with a bathroom, currently being used as a home gym that easily be a home office, and only lacks a closet from being a 3rd bedroom. Upstairs there are 2 bedrooms, each with a private bathroom. The yard has a screen porch, extra uncovered porch for the nice days, and a fully fenced yard with privacy. There is alley parking behind the home and a driveway so your car doesn’t have to be parked on the street. There was some settling in the right rear due to water intrusion in the crawl space and that is why the sump pump/dehumidifier/vapor barrier was added. This could be an ideal home for an FHA renovation loan if you’re looking for a classic home to redesign in your style. Sold As-Is but home should qualify for a conventional loan or FHA 203k Rehab Loan, and seller may consider a renovation allowance. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings."
+"Appliances": "Microwave Countertop"
+"ArchitecturalStyle": "Traditional"
+"AssociationYN": false
+"Basement": "No Basement"
+"BuildingAreaUnits": "Sqft"
+"ConstructionMaterials": "Aluminum"
+"Cooling": "Central,Heat Pump 1st Lvl,Heat Pump 2nd Lvl"
+"CountyOrParish": "Lexington"
+"CreationDate": "2026-06-23T15:27:15.922718+00:00"
+"Directions": "From I-26, take Exit 108 B/A to I-126 towards Columbia, R Huger, R Gervais, L Alexander, R Oliver, L Norfolk, R Hudson. This is also alley parking behind the home."
+"ExteriorFeatures": "Gutters - Full,Front Porch - Uncovered,Back Porch - Uncovered,Back Porch - Screened"
+"Fencing": "Rear Only Wood,Rear Only-Chain Link"
+"FireplaceFeatures": "Gas Log-Natural"
+"Heating": "Central,Heat Pump 1st Lvl,Heat Pump 2nd Lvl"
+"InteriorFeatures": "Attic Pull-Down Access"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": "Heated Space,Mud Room"
+"ListAgentEmail": "HoffmanGroupRealty@gmail.com"
+"LivingAreaUnits": "Sqft"
+"LotSizeUnits": "Sqft"
+"MlsStatus": "ACTIVE"
+"OriginalEntryTimestamp": "2026-06-23"
+"PhotosChangeTimestamp": "2026-06-23T15:20:27Z"
+"PhotosCount": "22"
+"RoadFrontageType": "Paved"
+"RoomKitchenFeatures": "Floors-Hardwood,Pantry,Counter Tops-Formica,Cabinets-Stained"
+"Sewer": "Public"
+"StateOrProvince": "SC"
+"StreetName": "Hudson"
+"StreetNumber": "311"
+"StreetSuffix": "Street"
+"SubdivisionName": "NONE"
+"WaterSource": "Public"
+"TMS": "004647-18-005"
+"Baths": "4"
+"Range": "Free-standing,Gas"
+"Garage": "None"
+"Address": "311 Hudson Street"
+"LVTDate": "2026-06-23"
+"LotSize": "4250"
+"BathsFull": "3"
+"#ofStories": "2"
+"2ndBedroom": "Closet-His & Her,Closet-Walk in,Floors-Hardwood"
+"BathsCombo": "3 / 1"
+"HighSchool": "Brookland-Cayce"
+"IDXInclude": "Yes"
+"New/Resale": "Resale"
+"class_name": "RE_1"
+"LA1UserCode": "HOFFMAB"
+"GarageSpaces": "0"
+"MiddleSchool": "Busbee"
+"PricePerSQFT": "169.9"
+"StatusDetail": "0"
+"FullBaths-2nd": "2"
+"Level-Kitchen": "Main"
+"MasterBedroom": "Double Vanity,Closet-His & Her,Separate Shower,Closet-Walk in,Floors-Hardwood"
+"Miscellaneous": "Surround Sound Wiring"
+"AvailFinancing": "Cash,Conventional,FHA,VA"
+"FullBaths-Main": "1"
+"GeoSubdivision": "SC"
+"HalfBaths-Main": "1"
+"SchoolDistrict": "Lexington Two"
+"LO1MainOfficeID": "1968"
+"OtherHeatedSqFt": "0"
+"ElementarySchool": "Cayce Elementary"
+"FormalLivingRoom": "Fireplace,Floors-Hardwood,Ceiling Fan"
+"LA1AgentLastName": "Hoffman"
+"ListPriceTotSqFt": "169.9"
+"RollbackTax(Y/N)": "No"
+"LA1AgentFirstName": "Brandon"
+"GeoUpdateTimestamp": "2026-06-23T15:20:26.1"
+"AddressSearchNumber": "311"
+"LO1OfficeIdentifier": "1968"
+"Level-MasterBedroom": "Main"
+"ListingTypeAgreement": "Exclusive Right to Sell"
+"PublishtoInternetY/N": "Yes"
+"Interior#ofFireplaces": "1"
+"LA1AgentMiddleInitial": "M"
+"LO1OfficeAbbreviation": "REEC01"
+"FirstPhotoAddTimestamp": "2026-06-23T15:20:27.1"
+"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree"
+"Media": array:22 [
0 => array:11 [
"Order" => 0
"MediaKey" => "6370320"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/e8078ee1c7e79811961fce80a515daea.webp"
"ClassName" => "Single Family"
"MediaSize" => 1063704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-e8078ee1c7e79811961fce80a515daea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
1 => array:11 [
"Order" => 1
"MediaKey" => "6370321"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/7ea202112d7f827d2110ee97f5779784.webp"
"ClassName" => "Single Family"
"MediaSize" => 1068101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-7ea202112d7f827d2110ee97f5779784.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
2 => array:11 [
"Order" => 2
"MediaKey" => "6370322"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/985cb65b14ad7a2295b852404b10042c.webp"
"ClassName" => "Single Family"
"MediaSize" => 1063755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-985cb65b14ad7a2295b852404b10042c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
3 => array:11 [
"Order" => 3
"MediaKey" => "6370323"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/d93b0ecbb7534b76635481a8ff2ff4c0.webp"
"ClassName" => "Single Family"
"MediaSize" => 1042269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-d93b0ecbb7534b76635481a8ff2ff4c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
4 => array:11 [
"Order" => 4
"MediaKey" => "6370324"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/26574325e6d2e553c531c26afebe6f48.webp"
"ClassName" => "Single Family"
"MediaSize" => 1085061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-26574325e6d2e553c531c26afebe6f48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
5 => array:11 [
"Order" => 5
"MediaKey" => "6370325"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/40ef6309886e6ac2263a836347940407.webp"
"ClassName" => "Single Family"
"MediaSize" => 862277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-40ef6309886e6ac2263a836347940407.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
6 => array:11 [
"Order" => 6
"MediaKey" => "6370326"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/00e11f4aae1fa8a5aa3c8a65a22446fc.webp"
"ClassName" => "Single Family"
"MediaSize" => 917757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-00e11f4aae1fa8a5aa3c8a65a22446fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
7 => array:11 [
"Order" => 7
"MediaKey" => "6370327"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/699a30df8925aee29553c26773126731.webp"
"ClassName" => "Single Family"
"MediaSize" => 1018500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-699a30df8925aee29553c26773126731.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
8 => array:11 [
"Order" => 8
"MediaKey" => "6370328"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/3917c2ede8bb8a3e565e63a44e73be81.webp"
"ClassName" => "Single Family"
"MediaSize" => 863325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-3917c2ede8bb8a3e565e63a44e73be81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
9 => array:11 [
"Order" => 9
"MediaKey" => "6370329"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/02aa4a363379cc46f71fc0306df3491c.webp"
"ClassName" => "Single Family"
"MediaSize" => 794910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-02aa4a363379cc46f71fc0306df3491c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
10 => array:11 [
"Order" => 10
"MediaKey" => "63703210"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/57f79ce09e88a36c6817a49add1a4861.webp"
"ClassName" => "Single Family"
"MediaSize" => 714568
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-57f79ce09e88a36c6817a49add1a4861.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
11 => array:11 [
"Order" => 11
"MediaKey" => "63703211"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/7fd24bbc73871fd1de40538274400cfd.webp"
"ClassName" => "Single Family"
"MediaSize" => 837161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-7fd24bbc73871fd1de40538274400cfd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
12 => array:11 [
"Order" => 12
"MediaKey" => "63703212"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/91286b0585d3fbe6e7256a367c267150.webp"
"ClassName" => "Single Family"
"MediaSize" => 1056528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-91286b0585d3fbe6e7256a367c267150.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
13 => array:11 [
"Order" => 13
"MediaKey" => "63703213"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/58a3c2037a636fc1ef8d4dcf27ce787a.webp"
"ClassName" => "Single Family"
"MediaSize" => 797892
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-58a3c2037a636fc1ef8d4dcf27ce787a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
14 => array:11 [
"Order" => 14
"MediaKey" => "63703214"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/4c31a7bc60a1d678684066f1a8f0ab24.webp"
"ClassName" => "Single Family"
"MediaSize" => 748783
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-4c31a7bc60a1d678684066f1a8f0ab24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
15 => array:11 [
"Order" => 15
"MediaKey" => "63703215"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/b60c5c2b45a9959ef5520480ac90b1cb.webp"
"ClassName" => "Single Family"
"MediaSize" => 1071767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-b60c5c2b45a9959ef5520480ac90b1cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
16 => array:11 [
"Order" => 16
"MediaKey" => "63703216"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/90dc5dc54ccf3b7cc01f10ee7e982c3d.webp"
"ClassName" => "Single Family"
"MediaSize" => 1018216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-90dc5dc54ccf3b7cc01f10ee7e982c3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
17 => array:11 [
"Order" => 17
"MediaKey" => "63703217"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/be1447ad8dfc4eee2e1bd5ee6e874c22.webp"
"ClassName" => "Single Family"
"MediaSize" => 1063367
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-be1447ad8dfc4eee2e1bd5ee6e874c22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
18 => array:11 [
"Order" => 18
"MediaKey" => "63703218"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/50bc782647473b36784c9973933ac652.webp"
"ClassName" => "Single Family"
"MediaSize" => 1246849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-50bc782647473b36784c9973933ac652.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
19 => array:11 [
"Order" => 19
"MediaKey" => "63703219"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/e1e7676ae6f8ebfd5f6cefeba6301ffc.webp"
"ClassName" => "Single Family"
"MediaSize" => 1366597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-e1e7676ae6f8ebfd5f6cefeba6301ffc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
20 => array:11 [
"Order" => 20
"MediaKey" => "63703220"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/14f2f57e4da4756c635c0b663bc367af.webp"
"ClassName" => "Single Family"
"MediaSize" => 1198807
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-14f2f57e4da4756c635c0b663bc367af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
21 => array:11 [
"Order" => 21
"MediaKey" => "63703221"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/78ac1b1674f8a898b4eea996a71ba166.webp"
"ClassName" => "Single Family"
"MediaSize" => 1139559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-78ac1b1674f8a898b4eea996a71ba166.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('637032')"
+"ID": "131856"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
"RF Cache Key: d9bd23568b55c39c86367693c3049664beb77f1052deb2e641cc81e21954d968" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3420
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3427}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 637032 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4350
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4353
+post_id: "131856"
+post_author: 1
+"ListingKey": "637032"
+"ListingId": "637032"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T15:20:27Z"
+"RFModificationTimestamp": "2026-06-23T15:27:19Z"
+"ListPrice": 239900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.1
+"LivingArea": 1412.0
+"BuildingAreaTotal": 1412.0
+"City": "West Columbia"
+"PostalCode": "29169"
+"UnparsedAddress": "311 Hudson Street, West Columbia, SC 29169"
+"Coordinates": array:2 [
0 => -81.053069
1 => 33.992253
]
+"Latitude": 33.992253
+"Longitude": -81.053069
+"YearBuilt": 1905
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "The Real Estate Company"
+"ListAgentMlsId": "6658"
+"ListOfficeMlsId": "1968"
+"OriginatingSystemName": "columbiamls"
+"PublicRemarks": "Charming 1905 home ideally located just minutes from Downtown Columbia, USC, shopping, dining, and entertainment. Situated in a revitalizing area on the outskirts of The Avenues, this neighborhood is being improved with new construction, renovated historic homes, upgraded water lines, repaved roads, and a recently renovated park at the end of the street. Full of character, this home has benefited from numerous major system updates over the past nine years, including electrical improvements, replacement ductwork, roof replacement, added insulation, crawl space improvements (sump pump, dehumidifier, and vapor barrier), HVAC condenser replacement, and a newer air handler coil. Additional features include ceiling-mounted speakers on the main level and a reverse osmosis water filtration system. Downstairs, there is a living room, kitchen, laundry room, full bathroom. There is also a small room with a bathroom, currently being used as a home gym that easily be a home office, and only lacks a closet from being a 3rd bedroom. Upstairs there are 2 bedrooms, each with a private bathroom. The yard has a screen porch, extra uncovered porch for the nice days, and a fully fenced yard with privacy. There is alley parking behind the home and a driveway so your car doesn’t have to be parked on the street. There was some settling in the right rear due to water intrusion in the crawl space and that is why the sump pump/dehumidifier/vapor barrier was added. This could be an ideal home for an FHA renovation loan if you’re looking for a classic home to redesign in your style. Sold As-Is but home should qualify for a conventional loan or FHA 203k Rehab Loan, and seller may consider a renovation allowance. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings."
+"Appliances": "Microwave Countertop"
+"ArchitecturalStyle": "Traditional"
+"AssociationYN": false
+"Basement": "No Basement"
+"BuildingAreaUnits": "Sqft"
+"ConstructionMaterials": "Aluminum"
+"Cooling": "Central,Heat Pump 1st Lvl,Heat Pump 2nd Lvl"
+"CountyOrParish": "Lexington"
+"CreationDate": "2026-06-23T15:27:15.922718+00:00"
+"Directions": "From I-26, take Exit 108 B/A to I-126 towards Columbia, R Huger, R Gervais, L Alexander, R Oliver, L Norfolk, R Hudson. This is also alley parking behind the home."
+"ExteriorFeatures": "Gutters - Full,Front Porch - Uncovered,Back Porch - Uncovered,Back Porch - Screened"
+"Fencing": "Rear Only Wood,Rear Only-Chain Link"
+"FireplaceFeatures": "Gas Log-Natural"
+"Heating": "Central,Heat Pump 1st Lvl,Heat Pump 2nd Lvl"
+"InteriorFeatures": "Attic Pull-Down Access"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": "Heated Space,Mud Room"
+"ListAgentEmail": "HoffmanGroupRealty@gmail.com"
+"LivingAreaUnits": "Sqft"
+"LotSizeUnits": "Sqft"
+"MlsStatus": "ACTIVE"
+"OriginalEntryTimestamp": "2026-06-23"
+"PhotosChangeTimestamp": "2026-06-23T15:20:27Z"
+"PhotosCount": "22"
+"RoadFrontageType": "Paved"
+"RoomKitchenFeatures": "Floors-Hardwood,Pantry,Counter Tops-Formica,Cabinets-Stained"
+"Sewer": "Public"
+"StateOrProvince": "SC"
+"StreetName": "Hudson"
+"StreetNumber": "311"
+"StreetSuffix": "Street"
+"SubdivisionName": "NONE"
+"WaterSource": "Public"
+"TMS": "004647-18-005"
+"Baths": "4"
+"Range": "Free-standing,Gas"
+"Garage": "None"
+"Address": "311 Hudson Street"
+"LVTDate": "2026-06-23"
+"LotSize": "4250"
+"BathsFull": "3"
+"#ofStories": "2"
+"2ndBedroom": "Closet-His & Her,Closet-Walk in,Floors-Hardwood"
+"BathsCombo": "3 / 1"
+"HighSchool": "Brookland-Cayce"
+"IDXInclude": "Yes"
+"New/Resale": "Resale"
+"class_name": "RE_1"
+"LA1UserCode": "HOFFMAB"
+"GarageSpaces": "0"
+"MiddleSchool": "Busbee"
+"PricePerSQFT": "169.9"
+"StatusDetail": "0"
+"FullBaths-2nd": "2"
+"Level-Kitchen": "Main"
+"MasterBedroom": "Double Vanity,Closet-His & Her,Separate Shower,Closet-Walk in,Floors-Hardwood"
+"Miscellaneous": "Surround Sound Wiring"
+"AvailFinancing": "Cash,Conventional,FHA,VA"
+"FullBaths-Main": "1"
+"GeoSubdivision": "SC"
+"HalfBaths-Main": "1"
+"SchoolDistrict": "Lexington Two"
+"LO1MainOfficeID": "1968"
+"OtherHeatedSqFt": "0"
+"ElementarySchool": "Cayce Elementary"
+"FormalLivingRoom": "Fireplace,Floors-Hardwood,Ceiling Fan"
+"LA1AgentLastName": "Hoffman"
+"ListPriceTotSqFt": "169.9"
+"RollbackTax(Y/N)": "No"
+"LA1AgentFirstName": "Brandon"
+"GeoUpdateTimestamp": "2026-06-23T15:20:26.1"
+"AddressSearchNumber": "311"
+"LO1OfficeIdentifier": "1968"
+"Level-MasterBedroom": "Main"
+"ListingTypeAgreement": "Exclusive Right to Sell"
+"PublishtoInternetY/N": "Yes"
+"Interior#ofFireplaces": "1"
+"LA1AgentMiddleInitial": "M"
+"LO1OfficeAbbreviation": "REEC01"
+"FirstPhotoAddTimestamp": "2026-06-23T15:20:27.1"
+"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree"
+"Media": array:22 [
0 => array:11 [
"Order" => 0
"MediaKey" => "6370320"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/e8078ee1c7e79811961fce80a515daea.webp"
"ClassName" => "Single Family"
"MediaSize" => 1063704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-e8078ee1c7e79811961fce80a515daea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
1 => array:11 [
"Order" => 1
"MediaKey" => "6370321"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/7ea202112d7f827d2110ee97f5779784.webp"
"ClassName" => "Single Family"
"MediaSize" => 1068101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-7ea202112d7f827d2110ee97f5779784.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
2 => array:11 [
"Order" => 2
"MediaKey" => "6370322"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/985cb65b14ad7a2295b852404b10042c.webp"
"ClassName" => "Single Family"
"MediaSize" => 1063755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-985cb65b14ad7a2295b852404b10042c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
3 => array:11 [
"Order" => 3
"MediaKey" => "6370323"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/d93b0ecbb7534b76635481a8ff2ff4c0.webp"
"ClassName" => "Single Family"
"MediaSize" => 1042269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-d93b0ecbb7534b76635481a8ff2ff4c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
4 => array:11 [
"Order" => 4
"MediaKey" => "6370324"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/26574325e6d2e553c531c26afebe6f48.webp"
"ClassName" => "Single Family"
"MediaSize" => 1085061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-26574325e6d2e553c531c26afebe6f48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
5 => array:11 [
"Order" => 5
"MediaKey" => "6370325"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/40ef6309886e6ac2263a836347940407.webp"
"ClassName" => "Single Family"
"MediaSize" => 862277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-40ef6309886e6ac2263a836347940407.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
6 => array:11 [
"Order" => 6
"MediaKey" => "6370326"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/00e11f4aae1fa8a5aa3c8a65a22446fc.webp"
"ClassName" => "Single Family"
"MediaSize" => 917757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-00e11f4aae1fa8a5aa3c8a65a22446fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
7 => array:11 [
"Order" => 7
"MediaKey" => "6370327"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/699a30df8925aee29553c26773126731.webp"
"ClassName" => "Single Family"
"MediaSize" => 1018500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-699a30df8925aee29553c26773126731.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
8 => array:11 [
"Order" => 8
"MediaKey" => "6370328"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/3917c2ede8bb8a3e565e63a44e73be81.webp"
"ClassName" => "Single Family"
"MediaSize" => 863325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-3917c2ede8bb8a3e565e63a44e73be81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
9 => array:11 [
"Order" => 9
"MediaKey" => "6370329"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/02aa4a363379cc46f71fc0306df3491c.webp"
"ClassName" => "Single Family"
"MediaSize" => 794910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-02aa4a363379cc46f71fc0306df3491c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
10 => array:11 [
"Order" => 10
"MediaKey" => "63703210"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/57f79ce09e88a36c6817a49add1a4861.webp"
"ClassName" => "Single Family"
"MediaSize" => 714568
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-57f79ce09e88a36c6817a49add1a4861.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
11 => array:11 [
"Order" => 11
"MediaKey" => "63703211"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/7fd24bbc73871fd1de40538274400cfd.webp"
"ClassName" => "Single Family"
"MediaSize" => 837161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-7fd24bbc73871fd1de40538274400cfd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
12 => array:11 [
"Order" => 12
"MediaKey" => "63703212"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/91286b0585d3fbe6e7256a367c267150.webp"
"ClassName" => "Single Family"
"MediaSize" => 1056528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-91286b0585d3fbe6e7256a367c267150.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
13 => array:11 [
"Order" => 13
"MediaKey" => "63703213"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/58a3c2037a636fc1ef8d4dcf27ce787a.webp"
"ClassName" => "Single Family"
"MediaSize" => 797892
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-58a3c2037a636fc1ef8d4dcf27ce787a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
14 => array:11 [
"Order" => 14
"MediaKey" => "63703214"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/4c31a7bc60a1d678684066f1a8f0ab24.webp"
"ClassName" => "Single Family"
"MediaSize" => 748783
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-4c31a7bc60a1d678684066f1a8f0ab24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
15 => array:11 [
"Order" => 15
"MediaKey" => "63703215"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/b60c5c2b45a9959ef5520480ac90b1cb.webp"
"ClassName" => "Single Family"
"MediaSize" => 1071767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-b60c5c2b45a9959ef5520480ac90b1cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
16 => array:11 [
"Order" => 16
"MediaKey" => "63703216"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/90dc5dc54ccf3b7cc01f10ee7e982c3d.webp"
"ClassName" => "Single Family"
"MediaSize" => 1018216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-90dc5dc54ccf3b7cc01f10ee7e982c3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
17 => array:11 [
"Order" => 17
"MediaKey" => "63703217"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/be1447ad8dfc4eee2e1bd5ee6e874c22.webp"
"ClassName" => "Single Family"
"MediaSize" => 1063367
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-be1447ad8dfc4eee2e1bd5ee6e874c22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
18 => array:11 [
"Order" => 18
"MediaKey" => "63703218"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/50bc782647473b36784c9973933ac652.webp"
"ClassName" => "Single Family"
"MediaSize" => 1246849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-50bc782647473b36784c9973933ac652.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
19 => array:11 [
"Order" => 19
"MediaKey" => "63703219"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/e1e7676ae6f8ebfd5f6cefeba6301ffc.webp"
"ClassName" => "Single Family"
"MediaSize" => 1366597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-e1e7676ae6f8ebfd5f6cefeba6301ffc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
20 => array:11 [
"Order" => 20
"MediaKey" => "63703220"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/14f2f57e4da4756c635c0b663bc367af.webp"
"ClassName" => "Single Family"
"MediaSize" => 1198807
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-14f2f57e4da4756c635c0b663bc367af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
21 => array:11 [
"Order" => 21
"MediaKey" => "63703221"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/121/637032/78ac1b1674f8a898b4eea996a71ba166.webp"
"ClassName" => "Single Family"
"MediaSize" => 1139559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/637032/thumbnail-78ac1b1674f8a898b4eea996a71ba166.webp"
"ResourceName" => "Property"
"MediaCategory" => "Photo"
"MediaObjectID" => ""
"ResourceRecordKey" => "637032"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('637032')"
+"ID": "131856"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
]
