Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(ExteriorFeatures eq 'Freezer' OR InteriorFeatures eq 'Freezer' OR Appliances eq 'Freezer')/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(ExteriorFeatures eq 'Freezer' OR InteriorFeatures eq 'Freezer' OR Appliances eq 'Freezer')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(ExteriorFeatures eq 'Freezer' OR InteriorFeatures eq 'Freezer' OR Appliances eq 'Freezer')/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(ExteriorFeatures eq 'Freezer' OR InteriorFeatures eq 'Freezer' OR Appliances eq 'Freezer')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3220 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3218 +post_id: "111625" +post_author: 1 +"ListingKey": "615578" +"ListingId": "615578" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-19T02:32:40Z" +"RFModificationTimestamp": "2025-08-19T02:37:57Z" +"ListPrice": 1800.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.3 +"LivingArea": 3019.0 +"BuildingAreaTotal": 3019.0 +"City": "Columbia" +"PostalCode": "29203" +"UnparsedAddress": "3715 Palmetto Avenue, Columbia, SC 29203" +"Coordinates": array:2 [ 0 => -81.046103 1 => 34.035564 ] +"Latitude": 34.035564 +"Longitude": -81.046103 +"YearBuilt": 1907 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Realty One Group Reside" +"ListAgentMlsId": "17945" +"ListOfficeMlsId": "1508" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Welcome to 3715 Palmetto Avenue — a fully renovated home located just minutes from the heart of downtown Columbia. This spacious property blends upgraded finishes with convenience, making it a standout for homeowners or investors seeking long-term value in a growing Columbia neighborhood.The home features modern systems, stylish design elements, and functional layout ideal for those relocating, purchasing their second home, or expanding a rental portfolio. Situated in the desirable 29203 area, this property is surrounded by revitalization and sits close to major employers, healthcare hubs, dining, and retail corridors.With no HOA, updated interiors, and proximity to Prisma Health, I-20, and the BullStreet District, this home provides a strong lifestyle and location package. Perfect for long-term occupancy, rental income potential, or those looking to establish roots in one of Columbia's emerging submarkets.Schedule your private showing today and explore the opportunity to own a newly renovated home close to the city center Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Freezer" +"ArchitecturalStyle": "Traditional" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Vinyl" +"Cooling": "Central" +"CountyOrParish": "Richland" +"CreationDate": "2025-08-19T02:37:40.059384+00:00" +"Directions": "From downtown Columbia, head north on Main Street (US-321). Turn left onto Miller Avenue, which becomes Ridgewood Avenue. Continue straight, then turn left onto Byrd Avenue. Turn right onto Palmetto Avenue, and the home at 3715 Palmetto Avenue will be on the right." +"ExteriorFeatures": "Front Porch - Covered" +"Fencing": "Rear Only-Chain Link" +"FireplaceFeatures": "Wood Burning" +"Heating": "Central" +"LaundryFeatures": "None,Utility Room" +"LeaseTerm": "One Year" +"ListAgentEmail": "Taquoia@sellingcarolinasgroup.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OpenParkingSpaces": "2" +"OriginalEntryTimestamp": "2025-08-17" +"PhotosChangeTimestamp": "2025-08-19T02:32:40Z" +"PhotosCount": "21" +"RoadFrontageType": "Paved" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Palmetto" +"StreetNumber": "3715" +"StreetSuffix": "Avenue" +"SubdivisionName": "KEENAN TERRACE" +"WaterSource": "Public" +"TMS": "09209-13-01" +"Garage": "Carport Attached" +"Address": "3715 Palmetto Avenue" +"Parking": "Carport,Garage" +"Pet Fee": "0" +"Handicap": "Ramp" +"LVT Date": "2025-08-18" +"Lot Size": "0" +"Security": "Tenant" +"Baths Full": "1" +"Year Built": "1907" +"class_name": "RT_5" +"Baths Combo": "1 / 1" +"Gas Paid By": "Tenant" +"High School": "Eau Claire" +"# of Stories": "2" +"Credit Check": "50" +"Garage Level": "Main" +"LA1User Code": "BEALSTA" +"Lawn Paid By": "Tenant" +"Pest Control": "Tenant" +"Pets Allowed": "No" +"Cable Paid By": "Tenant" +"Garage Spaces": "1" +"Middle School": "Gibbes" +"Sewer Paid By": "Tenant" +"Status Detail": "0" +"Trash Paid By": "Owner" +"Water Paid By": "Tenant" +"Available Date": "2025-08-18" +"Levels-Kitchen": "Main" +"Price Per SQFT": "0.6" +"Public Remarks": "Welcome to 3715 Palmetto Avenue — a fully renovated home located just minutes from the heart of downtown Columbia. This spacious property blends upgraded finishes with convenience, making it a standout for homeowners or investors seeking long-term value in a growing Columbia neighborhood.The home features modern systems, stylish design elements, and functional layout ideal for those relocating, purchasing their second home, or expanding a rental portfolio. Situated in the desirable 29203 area, this property is surrounded by revitalization and sits close to major employers, healthcare hubs, dining, and retail corridors.With no HOA, updated interiors, and proximity to Prisma Health, I-20, and the BullStreet District, this home provides a strong lifestyle and location package. Perfect for long-term occupancy, rental income potential, or those looking to establish roots in one of Columbia's emerging submarkets.Schedule your private showing today and explore the opportunity to own a newly renovated home close to the city center Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Cooling Paid By": "Tenant" +"Full Baths-Main": "1" +"Geo Subdivision": "SC" +"Half Baths-Main": "1" +"Heating Paid By": "Tenant" +"School District": "Richland One" +"Electric Paid By": "Tenant" +"Levels-Bedroom 2": "Second" +"Levels-Bedroom 3": "Second" +"Levels-Bedroom 4": "Second" +"Levels-Bedroom 5": "Main" +"Security Deposit": "1800" +"Elementary School": "Taylor" +"LO1Main Office ID": "1508" +"Levels-Great Room": "Main" +"Other Heated SqFt": "0" +"LA1Agent Last Name": "Beals" +"Levels-Living Room": "Main" +"LA1Agent First Name": "Taquoia" +"Levels-Washer Dryer": "Main" +"List Price Tot SqFt": "0.6" +"Geo Update Timestamp": "2025-08-19T02:32:39.8" +"LO1Office Identifier": "1508" +"Address Search Number": "3715" +"Levels-Master Bedroom": "Second" +"LO1Office Abbreviation": "RESI01" +"Publish to Internet Y/N": "Yes" +"Interior # of Fireplaces": "2" +"First Photo Add Timestamp": "2025-08-19T02:32:40.9" +"Levels-Formal Dining Room": "Main" +"Levels-Formal Living Room": "Main" +"MlsAreaMajor": "City of Columbia, Denny terrace, Lake Elizabeth" +"PrivatePoolYN": "No" +"Media": array:21 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6155780" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/7b3be56b0c1323d7467358b371da9071.webp" "ClassName" => "Single Family" "MediaSize" => 845271 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-7b3be56b0c1323d7467358b371da9071.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6155781" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/5299d59c10e554186430c77cb1df6f57.webp" "ClassName" => "Single Family" "MediaSize" => 236189 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-5299d59c10e554186430c77cb1df6f57.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6155782" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/6a9a2591a554e24f457362e5d86a946e.webp" "ClassName" => "Single Family" "MediaSize" => 256358 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-6a9a2591a554e24f457362e5d86a946e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6155783" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/3764e1b6f5b56e05495e603e26e18f7c.webp" "ClassName" => "Single Family" "MediaSize" => 397347 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-3764e1b6f5b56e05495e603e26e18f7c.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6155784" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/177b46911ab337d31c50be50c1bc3c7d.webp" "ClassName" => "Single Family" "MediaSize" => 191690 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-177b46911ab337d31c50be50c1bc3c7d.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6155785" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/fa14dcf15f0731cc9bd063c342c13541.webp" "ClassName" => "Single Family" "MediaSize" => 178326 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-fa14dcf15f0731cc9bd063c342c13541.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6155786" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/18812b5db0c9b0529d9541efcd97b2a3.webp" "ClassName" => "Single Family" "MediaSize" => 193379 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-18812b5db0c9b0529d9541efcd97b2a3.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6155787" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/930f17f9fd751b459c0e703b563418e2.webp" "ClassName" => "Single Family" "MediaSize" => 224516 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-930f17f9fd751b459c0e703b563418e2.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6155788" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/65d6441b8650fbb31651dc43efec3764.webp" "ClassName" => "Single Family" "MediaSize" => 222160 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-65d6441b8650fbb31651dc43efec3764.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6155789" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/eb7f1c571dc2c08819f09356554f2b5f.webp" "ClassName" => "Single Family" "MediaSize" => 293024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-eb7f1c571dc2c08819f09356554f2b5f.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "61557810" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/243e655c5929e8b18a02cfc82227de7a.webp" "ClassName" => "Single Family" "MediaSize" => 208247 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-243e655c5929e8b18a02cfc82227de7a.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "61557811" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/0e37e5238bfce6f667e4db6aa477c749.webp" "ClassName" => "Single Family" "MediaSize" => 209948 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-0e37e5238bfce6f667e4db6aa477c749.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "61557812" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/f7803d377a8dec0fdc2e02c796ecf445.webp" "ClassName" => "Single Family" "MediaSize" => 211545 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-f7803d377a8dec0fdc2e02c796ecf445.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "61557813" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/508c0327d270b25713757c145fcd3729.webp" "ClassName" => "Single Family" "MediaSize" => 202740 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-508c0327d270b25713757c145fcd3729.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "61557814" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/1dc55ca700d159352f5a51d7cf00d260.webp" "ClassName" => "Single Family" "MediaSize" => 193833 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-1dc55ca700d159352f5a51d7cf00d260.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "61557815" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/8d24da75b4b60c6770dbf9dd78a2153a.webp" "ClassName" => "Single Family" "MediaSize" => 209311 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-8d24da75b4b60c6770dbf9dd78a2153a.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "61557816" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/47598bd8b00e7f1a0cc15a6229b05269.webp" "ClassName" => "Single Family" "MediaSize" => 244618 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-47598bd8b00e7f1a0cc15a6229b05269.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "61557817" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/10c7d747a515853f0f9b25d74c9911e4.webp" "ClassName" => "Single Family" "MediaSize" => 1016742 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-10c7d747a515853f0f9b25d74c9911e4.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "61557818" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/36482adf1bd136260cf8bfc45e399240.webp" "ClassName" => "Single Family" "MediaSize" => 700851 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-36482adf1bd136260cf8bfc45e399240.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "61557819" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/5fa2bf099071d71b1248e498b2b8e09d.webp" "ClassName" => "Single Family" "MediaSize" => 861187 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-5fa2bf099071d71b1248e498b2b8e09d.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "61557820" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/615578/0679d183d9c38680773a492a9f64db9d.webp" "ClassName" => "Single Family" "MediaSize" => 846306 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/615578/thumbnail-0679d183d9c38680773a492a9f64db9d.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "615578" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('615578')" +"ID": "111625" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.27 seconds" ] "RF Cache Key: ddf612151e892408da1b9cc29f7e8479faa1629623612d1c78db8eb32489dab2" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3215 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3218} ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } ] ]
