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: f9f203a773bd7862b60b0857523c2406846648f836c0b731140f450e9c520f7d" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3765 +items: array:2 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3212 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "599817" +"ListingId": "599817" +"PropertyType": "Residential" +"PropertySubType": "Condo" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-06T18:07:50Z" +"RFModificationTimestamp": "2025-10-06T18:14:58Z" +"ListPrice": 50000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0.01 +"LivingArea": 1100.0 +"BuildingAreaTotal": 1100.0 +"City": "Columbia" +"PostalCode": "29210" +"UnparsedAddress": "1208 Bush River Road Unit E9, Columbia, SC 29210" +"Coordinates": array:2 [ 0 => -81.104594 1 => 34.029238 ] +"Latitude": 34.029238 +"Longitude": -81.104594 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Keller Williams Realty" +"ListAgentMlsId": "7789" +"ListOfficeMlsId": "669" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Owner prefers to sell as a package deal-12 units at Lexington Green. Gross Rent Roll is $8,075. To preview any of the units proof of funds and 72 hours notice needed to set them up. Keys will have to be picked up and dropped off at Affinity Management at One Harbison Way Suite 112 Columbia SC 29212 Monday-Friday 9am-5pm. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"ArchitecturalStyle": "Ranch" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-06-02T20:04:54.960807+00:00" +"Directions": "I-26 to exit 107A toward Augusta. Take exit 63 toward Bush River. Turn left onto Bush River Road toward Columbia/Bush River Rd. Turn right for .2 mi. Turn right." +"ExteriorFeatures": "Patio" +"Fencing": "Rear Only-Chain Link" +"Heating": "Central" +"LaundryFeatures": "Heated Space" +"ListAgentEmail": "jtsellscolumbia@gmail.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OpenParkingSpaces": "2" +"OriginalEntryTimestamp": "2025-01-10" +"PhotosChangeTimestamp": "2025-06-04T19:09:49Z" +"PhotosCount": "12" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Cabinets-Painted" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Bush River" +"StreetNumber": "1208" +"StreetSuffix": "Road" +"SubdivisionName": "LEXINGTON GREEN" +"UnitNumber": "E9" +"WaterSource": "Public" +"TMS": "003639-01-0192" +"Baths": "2" +"Range": "Free-standing" +"Garage": "None" +"Address": "1208 Bush River Road E9" +"Assn Fee": "313" +"LVT Date": "2025-01-10" +"Lot Size": "541" +"Power On": "Yes" +"Baths Full": "2" +"New/Resale": "Resale" +"class_name": "RE_1" +"2nd Bedroom": "Tub-Shower,Closet-Private" +"Baths Combo": "2 / 0" +"High School": "Columbia" +"IDX Include": "Yes" +"# of Stories": "1" +"LA1User Code": "LIVINGJT" +"Garage Spaces": "0" +"Level-Kitchen": "Main" +"Middle School": "St Andrews" +"Status Detail": "0" +"Master Bedroom": "Closet-Private" +"Price Per SQFT": "45.45" +"Short Sale Y/N": "No" +"Agent Hit Count": "408" +"Avail Financing": "Cash,Conventional" +"Full Baths-Main": "2" +"Geo Subdivision": "SC" +"Half Baths-Main": "0" +"Level-Bedroom 2": "Main" +"School District": "Richland One" +"Elementary School": "Rhame" +"LO1Main Office ID": "669" +"Level-Living Room": "Main" +"Other Heated SqFt": "0" +"Assoc Fee Includes": "Back Yard Maintenance,Cable TV,Common Area Maintenance,Exterior Maintenance,Front Yard Maintenance,Landscaping,Street Light Maintenance,Trash,Green Areas,Pest Control" +"Formal Dining Room": "Area,Floors - Carpet" +"Formal Living Room": "Floors - Carpet" +"LA1Agent Last Name": "Livingston" +"Level-Washer Dryer": "Main" +"Rollback Tax (Y/N)": "Unknown" +"Address Search Unit": "9" +"Assn/Regime Fee Per": "Monthly" +"Foreclosed Property": "No" +"LA1Agent First Name": "JT" +"List Price Tot SqFt": "45.45" +"Geo Update Timestamp": "2025-01-10T18:12:56.6" +"LO1Office Identifier": "669" +"Level-Master Bedroom": "Main" +"Address Search Number": "1208" +"LO1Office Abbreviation": "KELL01" +"Listing Type Agreement": "Exclusive Right to Sell" +"Publish to Internet Y/N": "Yes" +"Interior # of Fireplaces": "0" +"Level-Formal Dining Room": "Main" +"First Photo Add Timestamp": "2025-01-10T18:12:57.6" +"MlsAreaMajor": "Irmo/St Andrews/Ballentine" +"PrivatePoolYN": "No" +"Media": array:12 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "5998170" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599817/a95d81c1a641fa26fd56e9f028ec2ba0.webp" "ClassName" => "Condo" "MediaSize" => 676540 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599817/thumbnail-a95d81c1a641fa26fd56e9f028ec2ba0.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599817" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "5998171" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599817/d030679f4cd031646ec4affbddefc210.webp" "ClassName" => "Condo" "MediaSize" => 42166 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599817/thumbnail-d030679f4cd031646ec4affbddefc210.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599817" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "5998172" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599817/f2b2459024682bb68ed2fd77bcb1c5d7.webp" "ClassName" => "Condo" "MediaSize" => 77254 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599817/thumbnail-f2b2459024682bb68ed2fd77bcb1c5d7.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599817" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "5998173" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599817/c9d47ea2adb24bc6ac81d37414f20979.webp" "ClassName" => "Condo" "MediaSize" => 68677 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599817/thumbnail-c9d47ea2adb24bc6ac81d37414f20979.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599817" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "5998174" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599817/bc3a3d3fabae38a44e3eb8c67b5f1616.webp" "ClassName" => "Condo" "MediaSize" => 87163 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599817/thumbnail-bc3a3d3fabae38a44e3eb8c67b5f1616.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599817" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "5998175" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599817/fede36ceff2381d63893b5af7fdb6d57.webp" "ClassName" => "Condo" "MediaSize" => 57994 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599817/thumbnail-fede36ceff2381d63893b5af7fdb6d57.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599817" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "5998176" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599817/628f7da518f95a4553699b015d23989d.webp" "ClassName" => "Condo" "MediaSize" => 90105 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599817/thumbnail-628f7da518f95a4553699b015d23989d.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599817" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "5998177" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599817/80afb4e8751f71dc5e8f5a563fc0ceb1.webp" "ClassName" => "Condo" "MediaSize" => 72974 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599817/thumbnail-80afb4e8751f71dc5e8f5a563fc0ceb1.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599817" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "5998178" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599817/3d56c414066099664f863a6faa55d526.webp" "ClassName" => "Condo" "MediaSize" => 77423 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599817/thumbnail-3d56c414066099664f863a6faa55d526.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599817" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "5998179" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599817/a9918c18c905374d311b2b88019a3c85.webp" "ClassName" => "Condo" "MediaSize" => 65634 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599817/thumbnail-a9918c18c905374d311b2b88019a3c85.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599817" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "59981710" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599817/8b5f04bea9b10189fb013631cf66ed7d.webp" "ClassName" => "Condo" "MediaSize" => 83621 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599817/thumbnail-8b5f04bea9b10189fb013631cf66ed7d.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599817" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "59981711" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599817/ccdf83b269fe062f2348a79e63a0b9df.webp" "ClassName" => "Condo" "MediaSize" => 68246 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599817/thumbnail-ccdf83b269fe062f2348a79e63a0b9df.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599817" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('599817')" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3205 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "613399" +"ListingId": "613399" +"PropertyType": "Residential" +"PropertySubType": "Condo" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-09-07T06:42:17Z" +"RFModificationTimestamp": "2025-09-07T06:45:47Z" +"ListPrice": 40000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 2.0 +"LotSizeArea": 0.29 +"LivingArea": 674.0 +"BuildingAreaTotal": 674.0 +"City": "Columbia" +"PostalCode": "29210" +"UnparsedAddress": "1208 Bush River Road Unit R12, Columbia, SC 29210" +"Coordinates": array:2 [ 0 => -81.104901 1 => 34.026979 ] +"Latitude": 34.026979 +"Longitude": -81.104901 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Legasea Realty" +"ListAgentMlsId": "19735" +"ListOfficeMlsId": "1618" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Cash offers only! This is an investor opportunity that's ideal for developers. Discover the potential of 1208 Bush River Road, Unit R12 , a rare investment opportunity just 10 minutes from downtown Columbia. This property is being sold as-is and is only available to investors, preferably developers, due to repairs needed after a tenant fire.The purchase price includes a $40,000 HOA repair credit, offering a substantial head start for the right buyer to renovate and recoup a significant portion of their investment. With strong rental demand in the area and close proximity to city amenities, this unit offers great income-producing potential once updated.This is a deal you don’t want to miss. Priced to sell & full of upside. Schedule a viewing today or call and ask questions! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Vinyl" +"Cooling": "Central" +"CountyOrParish": "Richland" +"CreationDate": "2025-07-18T16:26:07.036859+00:00" +"Directions": "Interstate 26 to Exit 108A (East) Go over interstate, and through light. Turn right into Lexington Green. First right. Follow signs to Building H. Last building on the right." +"Heating": "Central" +"ListAgentEmail": "baxterjsmith@gmail.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OpenParkingSpaces": "2" +"OriginalEntryTimestamp": "2025-07-18" +"PhotosChangeTimestamp": "2025-09-07T06:42:17Z" +"PhotosCount": "1" +"RoadFrontageType": "Paved" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Bush River" +"StreetNumber": "1208" +"StreetSuffix": "Road" +"SubdivisionName": "LEXINGTON GREEN" +"UnitNumber": "r12" +"WaterSource": "Public" +"TMS": "05981-04-06" +"Baths": "2" +"Garage": "None" +"Address": "1208 Bush River Road r12" +"Assn Fee": "196" +"LVT Date": "2025-07-18" +"Baths Full": "1" +"New/Resale": "Resale" +"class_name": "RE_1" +"Baths Combo": "1 / 1" +"High School": "Irmo" +"IDX Include": "Yes" +"LA1User Code": "SMIBA" +"Garage Spaces": "0" +"Middle School": "Irmo" +"Status Detail": "0" +"Price Per SQFT": "59.35" +"Agent Hit Count": "116" +"Full Baths-Main": "1" +"Geo Subdivision": "SC" +"Half Baths-Main": "1" +"School District": "Lexington/Richland Five" +"Elementary School": "Seven Oaks" +"LO1Main Office ID": "1618" +"Other Heated SqFt": "0" +"LA1Agent Last Name": "Smith" +"Rollback Tax (Y/N)": "Unknown" +"Address Search Unit": "12" +"Assn/Regime Fee Per": "Monthly" +"LA1Agent First Name": "Baxter" +"List Price Tot SqFt": "59.35" +"Geo Update Timestamp": "2025-07-18T16:17:35.9" +"LO1Office Identifier": "1618" +"Level-Master Bedroom": "Main" +"Address Search Number": "1208" +"LO1Office Abbreviation": "LEGR01" +"Listing Type Agreement": "Exclusive Right to Sell" +"Publish to Internet Y/N": "Yes" +"Interior # of Fireplaces": "0" +"First Photo Add Timestamp": "2025-09-07T06:42:13.3" +"MlsAreaMajor": "Irmo/St Andrews/Ballentine" +"Media": array:1 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6133990" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/613399/a72a935c3eed2a820e489259cfdaa572.webp" "ClassName" => "Condo" "MediaSize" => 101557 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/613399/thumbnail-a72a935c3eed2a820e489259cfdaa572.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "613399" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('613399')" } ] +success: true +page_size: 10 +page_count: 2 +count: 12 +after_key: "" } ] ]