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=(Appliances eq 'Oven,Range,Refrigerator' OR ArchitecturalStyle eq 'Oven,Range,Refrigerator' OR CommunityFeatures eq 'Oven,Range,Refrigerator' OR Cooling eq 'Oven,Range,Refrigerator' OR CountyOrParish eq 'Oven,Range,Refrigerator' OR ElementarySchool eq 'Oven,Range,Refrigerator' OR ExteriorFeatures eq 'Oven,Range,Refrigerator' OR Flooring eq 'Oven,Range,Refrigerator' OR Heating eq 'Oven,Range,Refrigerator' OR HighSchool eq 'Oven,Range,Refrigerator' OR InteriorFeatures eq 'Oven,Range,Refrigerator' OR ListingTerms eq 'Oven,Range,Refrigerator' OR MiddleOrJuniorSchool eq 'Oven,Range,Refrigerator' OR ParkingFeatures eq 'Oven,Range,Refrigerator' OR PoolFeatures eq 'Oven,Range,Refrigerator' OR PropertyType eq 'Oven,Range,Refrigerator' OR Roof eq 'Oven,Range,Refrigerator' OR SchoolDistrict eq 'Oven,Range,Refrigerator' OR Sewer eq 'Oven,Range,Refrigerator' OR Utilities eq 'Oven,Range,Refrigerator' OR WaterfrontFeatures eq 'Oven,Range,Refrigerator') 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: "129967" +post_author: 1 +"ListingKey": "635037" +"ListingId": "635037" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-27T16:15:07Z" +"RFModificationTimestamp": "2026-06-09T06:02:35Z" +"ListPrice": 1000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0.18 +"LivingArea": 800.0 +"BuildingAreaTotal": 800.0 +"City": "Columbia" +"PostalCode": "29205" +"UnparsedAddress": "3626 Hydrangea Street, Columbia, SC 29205" +"Coordinates": array:2 [ 0 => -80.992173 1 => 33.971149 ] +"Latitude": 33.971149 +"Longitude": -80.992173 +"YearBuilt": "1954" +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Merrilyn Hall Realty Inc" +"ListAgentMlsId": "6317" +"ListOfficeMlsId": "162" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Welcome home to this adorable renovated stone bungalow in the beloved Rosewood area! Full of charm and set on a quiet dead-end street, this 2 bedroom home offers fresh updates throughout, including new flooring, fresh paint, an updated bathroom, refreshed fixtures, and a new range and refrigerator being installed. The living areas feel bright and comfortable, while the large fenced backyard provides a rare amount of outdoor space — perfect for relaxing, entertaining, or enjoying a pet-friendly yard.This home offers a peaceful residential setting while still being close to Rosewood, Shandon, Devine Street, USC, downtown Columbia, Owens Field, shopping, dining, and local conveniences.Property Disclosure: This property has experienced flooding in the past. The owner has completed significant work intended to help reduce the likelihood of future flooding, but no guarantee can be made that flooding will not occur again. In recognition of this history and potential risk, the home is being offered at a rental rate slightly below comparable market value. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Oven,Range,Refrigerator" +"ArchitecturalStyle": "Bungalow" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Stone" +"Cooling": "Central" +"CountyOrParish": "Richland" +"CreationDate": "2026-05-27T16:17:30.691166+00:00" +"Directions": "Rosewood to S. Ott. L on Hydrangea, home on right." +"ExteriorFeatures": "Patio" +"Heating": "Central,Heat Pump 1st Lvl" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Heated Space" +"LeaseTerm": "One Year" +"ListAgentEmail": "april@mhallrealty.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OriginalEntryTimestamp": "2026-05-27" +"PhotosChangeTimestamp": "2026-05-27T16:15:07Z" +"PhotosCount": "12" +"RoadFrontageType": "Paved" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "HYDRANGEA" +"StreetNumber": "3626" +"StreetSuffix": "Street" +"SubdivisionName": "ROSEWOOD" +"WaterSource": "Public" +"TMS": "13701-02-05" +"Garage": "None" +"PetFee": "300" +"Address": "3626 HYDRANGEA Street" +"LVTDate": "2026-05-27" +"LotSize": "63' x 131' x 58' 131'" +"Parking": "Off Street" +"OtherFee": "125" +"Security": "None" +"BathsFull": "1" +"GasPaidBy": "None" +"#ofStories": "1" +"BathsCombo": "1 / 0" +"HighSchool": "Dreher" +"LawnPaidBy": "Tenant" +"class_name": "RT_5" +"CablePaidBy": "Tenant" +"CreditCheck": "100" +"LA1UserCode": "ALSUPA" +"PestControl": "Tenant" +"PetsAllowed": "Yes" +"SewerPaidBy": "Tenant" +"TrashPaidBy": "Owner" +"WaterPaidBy": "Tenant" +"GarageSpaces": "0" +"MiddleSchool": "Hand" +"PricePerSQFT": "1.25" +"StatusDetail": "0" +"AvailableDate": "2026-06-01" +"CoolingPaidBy": "Tenant" +"HeatingPaidBy": "Tenant" +"InteriorRooms": "Ceiling Fan,Eat In Kitchen" +"Miscellaneous": "Cable Available" +"ElectricPaidBy": "Tenant" +"FullBaths-Main": "1" +"GeoSubdivision": "SC" +"HalfBaths-Main": "0" +"Levels-Kitchen": "Main" +"SchoolDistrict": "Richland One" +"LO1MainOfficeID": "162" +"Levels-Bedroom2": "Main" +"OtherHeatedSqFt": "0" +"SecurityDeposit": "1000" +"ElementarySchool": "Rosewood" +"LA1AgentLastName": "Alsup" +"ListPriceTotSqFt": "1.25" +"LA1AgentFirstName": "April" +"Levels-LivingRoom": "Main" +"GeoUpdateTimestamp": "2026-05-27T16:15:06.6" +"Levels-WasherDryer": "Main" +"AddressSearchNumber": "3626" +"LO1OfficeIdentifier": "162" +"Levels-MasterBedroom": "Main" +"PublishtoInternetY/N": "Yes" +"Interior#ofFireplaces": "0" +"LO1OfficeAbbreviation": "HALL01" +"FirstPhotoAddTimestamp": "2026-05-27T16:15:07.5" +"MlsAreaMajor": "Columbia - South" +"Media": array:12 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6350370" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/635037/15874a134bea4628c99ac7a1063c6fb5.webp" "ClassName" => "Single Family" "MediaSize" => 1164837 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/635037/thumbnail-15874a134bea4628c99ac7a1063c6fb5.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "635037" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6350371" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/635037/4b93edbd9cdf9875d62d4f810e660f26.webp" "ClassName" => "Single Family" "MediaSize" => 1110082 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/635037/thumbnail-4b93edbd9cdf9875d62d4f810e660f26.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "635037" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6350372" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/635037/5f336c8a9f0a94eff1763bcd66f51a51.webp" "ClassName" => "Single Family" "MediaSize" => 382473 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/635037/thumbnail-5f336c8a9f0a94eff1763bcd66f51a51.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "635037" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6350373" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/635037/6ea32c70f2a31fc41d9d7e1ca70e9f60.webp" "ClassName" => "Single Family" "MediaSize" => 374605 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/635037/thumbnail-6ea32c70f2a31fc41d9d7e1ca70e9f60.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "635037" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6350374" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/635037/23065c7a541c4dc8f4a2b46cdabea0e9.webp" "ClassName" => "Single Family" "MediaSize" => 292674 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/635037/thumbnail-23065c7a541c4dc8f4a2b46cdabea0e9.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "635037" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6350375" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/635037/62787baf8374a4e15c3f2473b0d066b5.webp" "ClassName" => "Single Family" "MediaSize" => 333687 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/635037/thumbnail-62787baf8374a4e15c3f2473b0d066b5.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "635037" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6350376" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/635037/a6bc60eb53d41227cc74c8475f3ee242.webp" "ClassName" => "Single Family" "MediaSize" => 325490 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/635037/thumbnail-a6bc60eb53d41227cc74c8475f3ee242.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "635037" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6350377" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/635037/c93df50b7367199fbf026744f27c7a33.webp" "ClassName" => "Single Family" "MediaSize" => 469670 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/635037/thumbnail-c93df50b7367199fbf026744f27c7a33.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "635037" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6350378" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/635037/002985c51ff42892dd788f58f3628eb4.webp" "ClassName" => "Single Family" "MediaSize" => 403743 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/635037/thumbnail-002985c51ff42892dd788f58f3628eb4.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "635037" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6350379" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/635037/1dcc917f3354bcbe0551341c65933e12.webp" "ClassName" => "Single Family" "MediaSize" => 342650 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/635037/thumbnail-1dcc917f3354bcbe0551341c65933e12.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "635037" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "63503710" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/635037/d76ba72ee91d89bde7b48fe02c6da235.webp" "ClassName" => "Single Family" "MediaSize" => 310022 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/635037/thumbnail-d76ba72ee91d89bde7b48fe02c6da235.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "635037" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "63503711" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/635037/585887b1e1807b2ca528784cdd503da2.webp" "ClassName" => "Single Family" "MediaSize" => 1079802 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/635037/thumbnail-585887b1e1807b2ca528784cdd503da2.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "635037" ] ] +"DaysOnMarket": 19 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('635037')" +"ID": "129967" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.2 seconds" ] "RF Cache Key: 7dfc647bfe0dac92afd9a2e37f43bc6164bc396920cd6b1e292f3a7210d220ad" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3422 +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: "" } ] ]
