None
224 Properties
Sort by:
2446a Main Street, Elgin, SC 29045
- $399,900
4703 Augusta Road, Lexington, SC 29073
- $1,700,000
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: 27c2e253212851d1172393c3e6680efafa0d6a9392c8451dd314d0c3eca81631" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3799 +items: array:4 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3212 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "587039" +"ListingId": "587039" +"PropertyType": "Commercial Sale" +"PropertySubType": "Commercial" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T15:42:48Z" +"RFModificationTimestamp": "2025-03-20T23:27:21Z" +"ListPrice": 399900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.92 +"LivingArea": 0 +"BuildingAreaTotal": 2400.0 +"City": "Elgin" +"PostalCode": "29045" +"UnparsedAddress": "2446a Main Street, Elgin, Sc 29045" +"Coordinates": array:2 [ 0 => -80.789269 1 => 34.172129 ] +"Latitude": 34.172129 +"Longitude": -80.789269 +"YearBuilt": 1960 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ERA Wilder Realty" +"ListAgentMlsId": "4032" +"ListOfficeMlsId": "406" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Live / Work Commercial Opportunity in the Heart of Elgin. Zoned G2 Commercial or Residential. Great for a business or for a family that needs an in-law suite or can be rented out as an apartment. 3 Full Bathrooms, Can easily be converted to a 3 or 4 Bedroom Home; seller will convert back to two additional bedrooms with acceptable purchase contract! Two living areas with endless possibilities, Sun Room. Oversized Carport and Detached garage. Renovated in 2023. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"BuildingAreaUnits": "Sqft" +"Cooling": "Central" +"CountyOrParish": "Kershaw" +"CreationDate": "2024-07-08T10:37:27.387418+00:00" +"Directions": "From Columbia toward Elgin on Hwy 1. Property is on the left in the Heart of Elgin." +"Heating": "Central" +"ListAgentEmail": "colarealestate@gmail.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OpenParkingSpaces": "4" +"OriginalEntryTimestamp": "2024-06-10" +"PhotosChangeTimestamp": "2025-01-02T15:42:48Z" +"PhotosCount": "21" +"Sewer": "Septic-Public Available" +"StateOrProvince": "SC" +"StreetName": "Main" +"StreetNumber": "2446a" +"StreetSuffix": "Street" +"WaterSource": "Public" +"Zoning": "GC2" +"Miscellaneous": "Out Storage" +"Address": "2446a Main Street" +"New/Resale": "Resale" +"Gross Heated SqFt": "2400" +"# of Stories": "1" +"LVT Date": "2024-06-10" +"Status Detail": "0" +"LO1Office Identifier": "406" +"Listing Type Agreement": "Exclusive Right to Sell" +"Geo Subdivision": "SC" +"class_name": "CI_3" +"LO1Main Office ID": "591" +"Construction": "Brick" +"Rollback Tax (Y/N)": "No" +"Price Per SQFT": "166.63" +"LO1Office Abbreviation": "WILD03" +"Publish to Internet Y/N": "Yes" +"First Photo Add Timestamp": "2024-09-04T13:29:25.7" +"Agent Hit Count": "133" +"LA1Agent Last Name": "Sharpe" +"Transaction": "Sale" +"LA1User Code": "SHARPR" +"TMS": "e3551800019" +"LA1Agent First Name": "Randy" +"Geo Update Timestamp": "2024-06-10T16:33:59.3" +"Address Search Number": "2446" +"MlsAreaMajor": "Kershaw County West - Lugoff, Elgin" +"Media": array:21 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "5870390" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/d5e8762a6e2f730ad2071d6721038f9f.webp" "MediaSize" => 542524 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-d5e8762a6e2f730ad2071d6721038f9f.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "5870391" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/acfd36ab984cb4cca35d06681e4ba756.webp" "MediaSize" => 727449 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-acfd36ab984cb4cca35d06681e4ba756.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "5870392" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/9947b24fdcb236ff511b50f600d7e1e2.webp" "MediaSize" => 581721 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-9947b24fdcb236ff511b50f600d7e1e2.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "5870393" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/990794ec4dbdc1a7752f39dbd9230096.webp" "MediaSize" => 505511 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-990794ec4dbdc1a7752f39dbd9230096.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "5870394" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/1326e049fb747effabbeeab109bed773.webp" "MediaSize" => 533781 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-1326e049fb747effabbeeab109bed773.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "5870395" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/1771486b87a8c59d8ddbf7450b623863.webp" "MediaSize" => 797161 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-1771486b87a8c59d8ddbf7450b623863.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "5870396" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/0948dd8dcee1dda342c209ce95c0abef.webp" "MediaSize" => 590042 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-0948dd8dcee1dda342c209ce95c0abef.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "5870397" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/49dd3e94e4d1126002bf6809c3892d9d.webp" "MediaSize" => 499023 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-49dd3e94e4d1126002bf6809c3892d9d.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "5870398" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/a8ea03567dc4f81fa6a3918cb125e8c0.webp" "MediaSize" => 583300 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-a8ea03567dc4f81fa6a3918cb125e8c0.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "5870399" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/1d9c6da35c372b1765e827516dd3480c.webp" "MediaSize" => 533781 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-1d9c6da35c372b1765e827516dd3480c.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "58703910" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/67c0e84d6568062f08951979abdb681b.webp" "MediaSize" => 819029 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-67c0e84d6568062f08951979abdb681b.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "58703911" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/e04a8358be0ec3fe52831b120433586a.webp" "MediaSize" => 707671 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-e04a8358be0ec3fe52831b120433586a.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "58703912" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/69a4532c4655e471855fd74dd681907a.webp" "MediaSize" => 859176 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-69a4532c4655e471855fd74dd681907a.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "58703913" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/55755546400db5db552a31d8d3b155af.webp" "MediaSize" => 328948 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-55755546400db5db552a31d8d3b155af.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "58703914" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/f8b389491535fe753faf1881f085685a.webp" "MediaSize" => 293573 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-f8b389491535fe753faf1881f085685a.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "58703915" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/9b5688c687325c4097fc4464c8b57c7d.webp" "MediaSize" => 199436 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-9b5688c687325c4097fc4464c8b57c7d.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "58703916" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/1177ed24e434e208ddf756f61615d7c2.webp" "MediaSize" => 505511 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-1177ed24e434e208ddf756f61615d7c2.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "58703917" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/867b2b4e1786ea9d415cf6b8b57cd0a5.webp" "MediaSize" => 224966 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-867b2b4e1786ea9d415cf6b8b57cd0a5.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "58703918" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/2847b6ee341a22aa63f0550974fb5762.webp" "MediaSize" => 643098 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-2847b6ee341a22aa63f0550974fb5762.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "58703919" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/b50c2f79fe1483cca0fb9a28e8f77099.webp" "MediaSize" => 565117 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-b50c2f79fe1483cca0fb9a28e8f77099.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "58703920" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/587039/6cad6b511901cfc17f21ef0b7e77782d.webp" "MediaSize" => 542524 "ResourceRecordKey" => "587039" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/587039/thumbnail-6cad6b511901cfc17f21ef0b7e77782d.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('587039')" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3205 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "598411" +"ListingId": "598411" +"PropertyType": "Commercial Sale" +"PropertySubType": "Commercial" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-12T15:08:38Z" +"RFModificationTimestamp": "2025-03-20T22:33:57Z" +"ListPrice": 75000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2700.0 +"City": "Bamberg" +"PostalCode": "29003" +"UnparsedAddress": "3077 Main Highway, Bamberg, Sc 29003" +"Coordinates": array:2 [ 0 => -81.034884 1 => 33.296426 ] +"Latitude": 33.296426 +"Longitude": -81.034884 +"YearBuilt": 1950 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Hubbard-Bowers Inc" +"ListAgentMlsId": "13641" +"ListOfficeMlsId": "194" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "This building is currently being used as a gym, but could be used as a retail business. The upgrading of this building would help with the revitalization of Bamberg." +"BuildingAreaUnits": "Sqft" +"Cooling": "Central" +"CountyOrParish": "Bamberg" +"CreationDate": "2025-03-20T22:33:56.478664+00:00" +"Directions": "Follow GPS" +"Heating": "Central" +"ListAgentEmail": "runelle@hubbardbowers.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OpenParkingSpaces": "8" +"OriginalEntryTimestamp": "2024-12-11" +"PhotosChangeTimestamp": "2024-12-11T16:24:59Z" +"PhotosCount": "2" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Main" +"StreetNumber": "3077" +"StreetSuffix": "Highway" +"WaterSource": "Public" +"Zoning": "Commercial" +"Address": "3077 Main Highway" +"New/Resale": "Resale" +"Gross Heated SqFt": "2700" +"# of Stories": "1" +"LVT Date": "2024-12-11" +"Status Detail": "0" +"LO1Office Identifier": "194" +"Best Use": "This building has recently been used as a gym, which is an amenity that would be great in Bamberg. The building can be used for any type of business, this would surely help the rebuilding of Bamberg." +"Listing Type Agreement": "Exclusive Right to Sell" +"Geo Subdivision": "SC" +"class_name": "CI_3" +"LO1Main Office ID": "194" +"Construction": "Brick" +"Rollback Tax (Y/N)": "No" +"Price Per SQFT": "27.78" +"LO1Office Abbreviation": "HUBB01" +"Publish to Internet Y/N": "Yes" +"First Photo Add Timestamp": "2024-12-11T16:24:59.9" +"Occupancy Date": "2025-01-31" +"Agent Hit Count": "67" +"LA1Agent Last Name": "Weeks" +"Transaction": "Sale" +"LA1User Code": "WEEKSR" +"TMS": "0087-02-03-007" +"LA1Agent First Name": "Runelle" +"Geo Update Timestamp": "2024-12-11T16:24:59.6" +"Address Search Number": "3077" +"MlsAreaMajor": "All Others SC Counties" +"Media": array:2 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "5984110" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/598411/02617ce9bb705e02c29249c70374dab7.webp" "MediaSize" => 1019955 "ResourceRecordKey" => "598411" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/598411/thumbnail-02617ce9bb705e02c29249c70374dab7.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "5984111" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/598411/f6b6686be168e1323511c9334db4086c.webp" "MediaSize" => 1092131 "ResourceRecordKey" => "598411" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/598411/thumbnail-f6b6686be168e1323511c9334db4086c.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('598411')" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3209 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "598403" +"ListingId": "598403" +"PropertyType": "Commercial Sale" +"PropertySubType": "Commercial" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-11T15:26:06Z" +"RFModificationTimestamp": "2025-03-20T22:34:46Z" +"ListPrice": 225000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.39 +"LivingArea": 0 +"BuildingAreaTotal": 1749.0 +"City": "Columbia" +"PostalCode": "29209" +"UnparsedAddress": "8033 Caughman Road, Columbia, Sc 29209" +"Coordinates": array:2 [ 0 => -80.907087 1 => 33.964075 ] +"Latitude": 33.964075 +"Longitude": -80.907087 +"YearBuilt": 1974 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Disharoon Homes LLC" +"ListAgentMlsId": "3392" +"ListOfficeMlsId": "1063" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "High traffic count at key SE Columbia road junction of Ulmer and Caughman Roads makes this property ideal for a new retail business in fast growing SE Columbia. Also can serve as a branch location for any Midlands based business that seeks to expand in southeast Columbia area without the headaches of Garners Ferry Road! Seating capacity - 77 - comfortably up to 100 limit. 2 bathrooms, small office area. Can be converted for other uses." +"BuildingAreaUnits": "Sqft" +"Cooling": "Central" +"CountyOrParish": "Richland" +"CreationDate": "2025-03-20T22:34:45.755042+00:00" +"Directions": "From I77, take Leesburg exit (9A), left on to Leesburg, LT onto Fairmont Rd which becomes Caughman Road. On left side of road" +"Heating": "Central,Heat Pump" +"ListAgentEmail": "Charlie@DisharoonHomes.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OpenParkingSpaces": "50" +"OriginalEntryTimestamp": "2024-12-11" +"PhotosChangeTimestamp": "2024-12-11T15:26:07Z" +"PhotosCount": "9" +"Roof": "Comp Shingle" +"Sewer": "Septic-Public Available" +"StateOrProvince": "SC" +"StreetName": "Caughman" +"StreetNumber": "8033" +"StreetSuffix": "Road" +"WaterSource": "Public" +"Zoning": "RS-LD" +"Address": "8033 Caughman Road" +"New/Resale": "Resale" +"Gross Heated SqFt": "1749" +"# of Stories": "1" +"LVT Date": "2024-12-11" +"Status Detail": "0" +"LO1Office Identifier": "1063" +"Best Use": "Church/Retail store/Office/Restaurant" +"Listing Type Agreement": "Exclusive Right to Sell" +"Geo Subdivision": "SC" +"class_name": "CI_3" +"LO1Main Office ID": "1063" +"Construction": "Frame" +"Rollback Tax (Y/N)": "No" +"Lockbox Number": "32803320" +"Price Per SQFT": "128.64" +"LO1Office Abbreviation": "DISH01" +"Publish to Internet Y/N": "Yes" +"First Photo Add Timestamp": "2024-12-11T15:26:07" +"Agent Hit Count": "96" +"LA1Agent Last Name": "Disharoon" +"Transaction": "Sale" +"LA1User Code": "DISHARC" +"Lot Size": "16988" +"TMS": "19116-11-02" +"LA1Agent First Name": "Charles" +"Geo Update Timestamp": "2024-12-11T15:25:55.9" +"Address Search Number": "8033" +"MlsAreaMajor": "Columbia - Southeast" +"Media": array:9 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "5984030" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/598403/609098104b4e80e76ebfd29b50789c0c.webp" "MediaSize" => 1128675 "ResourceRecordKey" => "598403" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/598403/thumbnail-609098104b4e80e76ebfd29b50789c0c.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "5984031" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/598403/b5eb169aa082c0e60e977901b6cd173d.webp" "MediaSize" => 1146169 "ResourceRecordKey" => "598403" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/598403/thumbnail-b5eb169aa082c0e60e977901b6cd173d.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "5984032" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/598403/8352aa3d42f674da08c7e2c911ebb6c7.webp" "MediaSize" => 1152351 "ResourceRecordKey" => "598403" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/598403/thumbnail-8352aa3d42f674da08c7e2c911ebb6c7.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "5984033" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/598403/5f66bd96c96c2b0104afacbb2fe98a31.webp" "MediaSize" => 1433777 "ResourceRecordKey" => "598403" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/598403/thumbnail-5f66bd96c96c2b0104afacbb2fe98a31.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "5984034" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/598403/37a69fbdb171668d7b50fae113c45712.webp" "MediaSize" => 866054 "ResourceRecordKey" => "598403" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/598403/thumbnail-37a69fbdb171668d7b50fae113c45712.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "5984035" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/598403/973b1a175be782156a0c9ed96a0f470d.webp" "MediaSize" => 858516 "ResourceRecordKey" => "598403" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/598403/thumbnail-973b1a175be782156a0c9ed96a0f470d.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "5984036" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/598403/868a35de7716eeadcde0d52c27a5834f.webp" "MediaSize" => 742361 "ResourceRecordKey" => "598403" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/598403/thumbnail-868a35de7716eeadcde0d52c27a5834f.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "5984037" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/598403/d225d759787f287152bc6aca754c0502.webp" "MediaSize" => 945185 "ResourceRecordKey" => "598403" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/598403/thumbnail-d225d759787f287152bc6aca754c0502.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "5984038" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/598403/84132b9e0627e4036b10bbbf5fc3eae4.webp" "MediaSize" => 820753 "ResourceRecordKey" => "598403" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/598403/thumbnail-84132b9e0627e4036b10bbbf5fc3eae4.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('598403')" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3214 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "597628" +"ListingId": "597628" +"PropertyType": "Commercial Sale" +"PropertySubType": "Commercial" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T18:28:19Z" +"RFModificationTimestamp": "2025-03-20T22:40:03Z" +"ListPrice": 1700000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 5.93 +"LivingArea": 0 +"BuildingAreaTotal": 2760.0 +"City": "Lexington" +"PostalCode": "29073" +"UnparsedAddress": "4703 Augusta Road, Lexington, Sc 29073" +"Coordinates": array:2 [ 0 => -81.179032 1 => 33.975635 ] +"Latitude": 33.975635 +"Longitude": -81.179032 +"YearBuilt": 1965 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Real Broker LLC" +"ListAgentMlsId": "5631" +"ListOfficeMlsId": "1582" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Prime commercial property located on busy Highway 1 in Lexington. This rare opportunity offers 291 feet of road frontage on Augusta Road and 287 feet on Laurel Road, with a total of 5.93 acres. Zoned ID, the property currently includes five separate buildings with tenants (please do not disturb tenants/business owners; appointments must be scheduled through the listing agent). The location offers excellent visibility and is conveniently close to I-20, Lexington, West Columbia, and Columbia. Don’t miss out on this incredible opportunity! The outlined property boundaries are not exact and are intended to provide a general idea of the property's limits. For precise property lines, please refer to the official survey or contact the listing agent for further details." +"BuildingAreaUnits": "Sqft" +"CoListAgentEmail": "austinkfranks@gmail.com" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-03-20T22:40:03.066689+00:00" +"Directions": "I20 to Augusta Road toward Columbia. Corner of Laurel Road and Augusta Road." +"Heating": "Heat Pump" +"ListAgentEmail": "devin@lakesideteam.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OpenParkingSpaces": "40" +"OriginalEntryTimestamp": "2024-11-26" +"PhotosChangeTimestamp": "2024-11-26T18:12:46Z" +"PhotosCount": "4" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Augusta" +"StreetNumber": "4703" +"StreetSuffix": "Road" +"WaterSource": "Public" +"Zoning": "ID" +"Address": "4703 Augusta Road" +"New/Resale": "Resale" +"Gross Heated SqFt": "2760" +"# of Stories": "1" +"LVT Date": "2024-11-26" +"Status Detail": "0" +"LO1Office Identifier": "1582" +"Co-List Agent": "17892" +"Listing Type Agreement": "Exclusive Right to Sell" +"Geo Subdivision": "SC" +"Power On": "Yes" +"class_name": "CI_3" +"Short Sale Y/N": "No" +"LO1Main Office ID": "1230" +"Construction": "Block,Brick,Metal" +"Rollback Tax (Y/N)": "Unknown" +"Price Per SQFT": "615.94" +"LO1Office Abbreviation": "RBRO02" +"Publish to Internet Y/N": "Yes" +"First Photo Add Timestamp": "2024-11-26T18:12:46.3" +"Agent Hit Count": "65" +"LA1Agent Last Name": "Ihme" +"Transaction": "Sale" +"LA1User Code": "IHMED" +"TMS": "005597-07-005" +"LA1Agent First Name": "Devin" +"Co-List Office": "1582" +"Warehouse SqFt": "2000" +"Geo Update Timestamp": "2024-11-26T18:28:19" +"Address Search Number": "4703" +"Foreclosed Property": "No" +"MlsAreaMajor": "Lexington and surrounding area" +"Media": array:4 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "5976280" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597628/26e07575eda3744a9530b0bc2192d420.webp" "MediaSize" => 1059976 "ResourceRecordKey" => "597628" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597628/thumbnail-26e07575eda3744a9530b0bc2192d420.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "5976281" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597628/57028c2acc24015920a6140c65f4bd40.webp" "MediaSize" => 1056100 "ResourceRecordKey" => "597628" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597628/thumbnail-57028c2acc24015920a6140c65f4bd40.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "5976282" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597628/12d55af48b60ccd029bb01ae2aaee6af.webp" "MediaSize" => 819174 "ResourceRecordKey" => "597628" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597628/thumbnail-12d55af48b60ccd029bb01ae2aaee6af.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "5976283" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/597628/9ec842f7b8c8110c7644dfc530f0e9f6.webp" "MediaSize" => 944990 "ResourceRecordKey" => "597628" "ResourceName" => "Property" "ClassName" => "Commercial" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/597628/thumbnail-9ec842f7b8c8110c7644dfc530f0e9f6.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('597628')" } ] +success: true +page_size: 10 +page_count: 23 +count: 224 +after_key: "" } ] ]