DUNSTON HILLS
2 Properties
Sort by:
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: 9461120a1cd68dd9aa56ce7481c0d56d42a80f4d41accd2251310ba8fa2beba3" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3766 +items: array:2 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3210 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "618659" +"ListingId": "618659" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-07T21:48:09Z" +"RFModificationTimestamp": "2025-10-07T21:57:14Z" +"ListPrice": 1450.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.01 +"LivingArea": 1138.0 +"BuildingAreaTotal": 1138.0 +"City": "Columbia" +"PostalCode": "29203" +"UnparsedAddress": "2019 Haverford Circle, Columbia, SC 29203" +"Coordinates": array:2 [ 0 => -81.071587 1 => 34.067762 ] +"Latitude": 34.067762 +"Longitude": -81.071587 +"YearBuilt": "1972" +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Yip Premier Real Estate LLC" +"ListAgentMlsId": "10212" +"ListOfficeMlsId": "922" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Recently Renovated Brick home in NW Columbia. This home has a Brand NEW Kitchen with New Cabinets, LVP Flooring, and Appliances. The Bathrooms have New TILE flooring, Vanities, and Fixtures. Fresh Paint throughout. New roof. Minimum One year lease. Tenant is responsible for all utilities. No pets please. Rent with us and build your credit! Visit RentingColumbiaSC.com for 3D tour and online application. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Refrigerator,Range,Oven" +"ArchitecturalStyle": "Tri-Level" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Brick-All Sides-AbvFound" +"Cooling": "Central" +"CountyOrParish": "Richland" +"CreationDate": "2025-10-01T22:32:01.863196+00:00" +"Directions": "From Main St heading North, turn on to Monticello Rd, turn Left on Frost Ave, turn Right on Haverford Cir, Home is on the Right." +"Fencing": "Rear Only-Chain Link" +"Heating": "Central" +"LaundryFeatures": "Heated Space" +"LeaseTerm": "One Year,Two Year" +"ListAgentEmail": "yippms@gmail.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OriginalEntryTimestamp": "2025-10-01" +"PhotosChangeTimestamp": "2025-10-01T22:21:53Z" +"PhotosCount": "21" +"RoadFrontageType": "Paved" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Haverford" +"StreetNumber": "2019" +"StreetSuffix": "Circle" +"SubdivisionName": "DUNSTON HILLS" +"VirtualTourURLUnbranded": "https://youriguide.com/112_haverford_dr_columbia_sc" +"WaterSource": "Public" +"TMS": "07613-01-03" +"Garage": "Carport Attached" +"PetFee": "0" +"Address": "2019 Haverford Circle" +"LVTDate": "2025-10-01" +"Parking": "Carport" +"OtherFee": "5" +"Security": "Tenant" +"BathsFull": "2" +"GasPaidBy": "Tenant" +"#ofStories": "1" +"BathsCombo": "2 / 0" +"HighSchool": "Eau Claire" +"LawnPaidBy": "Tenant" +"class_name": "RT_5" +"CablePaidBy": "Tenant" +"CreditCheck": "60" +"LA1UserCode": "HINRICHSR" +"PestControl": "Tenant" +"PetsAllowed": "No" +"SewerPaidBy": "Tenant" +"TrashPaidBy": "Tenant" +"WaterPaidBy": "Tenant" +"GarageSpaces": "0" +"MiddleSchool": "Gibbes" +"PricePerSQFT": "1.27" +"StatusDetail": "0" +"AgentHitCount": "8" +"AvailableDate": "2025-10-01" +"CoolingPaidBy": "Tenant" +"HeatingPaidBy": "Tenant" +"InteriorRooms": "Ceiling Fan,Eat In Kitchen,Living Room,Floors Hardwood,Kitchen,Master Bedroom,2nd Bedroom,3rd Bedroom,Floors-Luxury Vinyl Plank" +"Miscellaneous": "Cable Available" +"ElectricPaidBy": "Tenant" +"FullBaths-Main": "2" +"GeoSubdivision": "SC" +"HalfBaths-Main": "0" +"Levels-Kitchen": "Main" +"SchoolDistrict": "Richland One" +"LO1MainOfficeID": "922" +"Levels-Bedroom2": "Main" +"Levels-Bedroom3": "Main" +"OtherHeatedSqFt": "0" +"SecurityDeposit": "1450" +"ElementarySchool": "Forest Heights" +"LA1AgentLastName": "Hinrichs" +"ListPriceTotSqFt": "1.27" +"LA1AgentFirstName": "Robbie" +"Levels-LivingRoom": "Main" +"GeoUpdateTimestamp": "2025-10-01T22:21:52.5" +"Levels-WasherDryer": "Main" +"AddressSearchNumber": "2019" +"LO1OfficeIdentifier": "922" +"Levels-MasterBedroom": "Main" +"PublishtoInternetY/N": "Yes" +"Interior#ofFireplaces": "0" +"LO1OfficeAbbreviation": "YIPP01" +"FirstPhotoAddTimestamp": "2025-10-01T22:21:53.3" +"MlsAreaMajor": "City of Columbia, Denny terrace, Lake Elizabeth" +"Media": array:21 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6186590" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/09dc1eaae078b755984e49515b4e33a0.webp" "ClassName" => "Single Family" "MediaSize" => 1222736 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-09dc1eaae078b755984e49515b4e33a0.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6186591" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/0a1a23478109858e2b4417ebf9073d2b.webp" "ClassName" => "Single Family" "MediaSize" => 1449135 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-0a1a23478109858e2b4417ebf9073d2b.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6186592" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/3ed87862b7537855e9cc74bf2919e324.webp" "ClassName" => "Single Family" "MediaSize" => 1426288 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-3ed87862b7537855e9cc74bf2919e324.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6186593" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/9f3bf1181c51d5a65ec6eaa1917f0d46.webp" "ClassName" => "Single Family" "MediaSize" => 1463597 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-9f3bf1181c51d5a65ec6eaa1917f0d46.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6186594" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/f159f2f4d012a8078b598d755ae266da.webp" "ClassName" => "Single Family" "MediaSize" => 405486 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-f159f2f4d012a8078b598d755ae266da.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6186595" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/50d2c3a23095b85535f1d26c02d63783.webp" "ClassName" => "Single Family" "MediaSize" => 332058 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-50d2c3a23095b85535f1d26c02d63783.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6186596" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/97da057cf7a4e7b3d707882a0ede6ae2.webp" "ClassName" => "Single Family" "MediaSize" => 321027 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-97da057cf7a4e7b3d707882a0ede6ae2.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6186597" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/15f61d5c71b02242064a3f16ccfa52db.webp" "ClassName" => "Single Family" "MediaSize" => 374331 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-15f61d5c71b02242064a3f16ccfa52db.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6186598" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/6197ff9d0f86058646443517e1435ae7.webp" "ClassName" => "Single Family" "MediaSize" => 382273 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-6197ff9d0f86058646443517e1435ae7.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6186599" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/0e9352c35cbc30997c21313c3fc80c3a.webp" "ClassName" => "Single Family" "MediaSize" => 326919 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-0e9352c35cbc30997c21313c3fc80c3a.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "61865910" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/b65dfe7ec54d27415fb5d1e42c34b6e0.webp" "ClassName" => "Single Family" "MediaSize" => 407103 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-b65dfe7ec54d27415fb5d1e42c34b6e0.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "61865911" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/4463b785d6f0121df478e44f7ff3f506.webp" "ClassName" => "Single Family" "MediaSize" => 344123 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-4463b785d6f0121df478e44f7ff3f506.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "61865912" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/750e4c5bbd83a6290e0809f35b7c4353.webp" "ClassName" => "Single Family" "MediaSize" => 329833 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-750e4c5bbd83a6290e0809f35b7c4353.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "61865913" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/ec5fb13aa1f0636087d760a46c93d2ac.webp" "ClassName" => "Single Family" "MediaSize" => 299507 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-ec5fb13aa1f0636087d760a46c93d2ac.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "61865914" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/dcfbf23c0fc23cb3c7b68a328f44411f.webp" "ClassName" => "Single Family" "MediaSize" => 329923 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-dcfbf23c0fc23cb3c7b68a328f44411f.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "61865915" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/2022425df044dbb942ef3009bbb1b864.webp" "ClassName" => "Single Family" "MediaSize" => 289826 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-2022425df044dbb942ef3009bbb1b864.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "61865916" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/7d4df073dec183a350b9a4719ef7672c.webp" "ClassName" => "Single Family" "MediaSize" => 315636 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-7d4df073dec183a350b9a4719ef7672c.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "61865917" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/7c84e765138fae02347d626258654cdb.webp" "ClassName" => "Single Family" "MediaSize" => 255561 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-7c84e765138fae02347d626258654cdb.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "61865918" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/f56c1fe1d0c7bc4e3b38f6db7d92a5b2.webp" "ClassName" => "Single Family" "MediaSize" => 303926 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-f56c1fe1d0c7bc4e3b38f6db7d92a5b2.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "61865919" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/5dfe816e620b690aeb906656edcc2587.webp" "ClassName" => "Single Family" "MediaSize" => 1470840 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-5dfe816e620b690aeb906656edcc2587.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "61865920" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/618659/852e58e979f9cba1d019973a18ae1f37.webp" "ClassName" => "Single Family" "MediaSize" => 1470673 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/618659/thumbnail-852e58e979f9cba1d019973a18ae1f37.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "618659" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('618659')" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3209 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "617547" +"ListingId": "617547" +"PropertyType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-09-15T23:28:13Z" +"RFModificationTimestamp": "2025-09-15T23:30:50Z" +"ListPrice": 6250.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.18 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Columbia" +"PostalCode": "29203" +"UnparsedAddress": "167 Waterford Drive, Columbia, SC 29203" +"Coordinates": array:2 [ 0 => -81.066634 1 => 34.063389 ] +"Latitude": 34.063389 +"Longitude": -81.066634 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Century 21 803 Realty" +"ListAgentMlsId": "14787" +"ListOfficeMlsId": "1073" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Residential lot with public utilities available. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"AssociationYN": false +"BuildingAreaUnits": "Sqft" +"CountyOrParish": "Richland" +"CreationDate": "2025-09-15T23:30:45.839333+00:00" +"Directions": "I-20 exit 68 make a L toward Columbia International University; R onto Denny Rd.; R on Winyah Rd; L on Frost Ave; R on Waterford Dr, lot is located at the bottom of the hill on the right." +"ListAgentEmail": "homesbybrantley@gmail.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OriginalEntryTimestamp": "2025-09-15" +"PhotosChangeTimestamp": "2025-09-15T23:28:13Z" +"PhotosCount": "1" +"RoadFrontageType": "County" +"RoadSurfaceType": "Paved" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Waterford" +"StreetNumber": "167" +"StreetSuffix": "Drive" +"SubdivisionName": "DUNSTON HILLS" +"WaterSource": "Public" +"TMS": "07516-04-11" +"Address": "167 Waterford Drive" +"LVT Date": "2025-09-15" +"class_name": "LD_2" +"High School": "Eau Claire" +"LA1User Code": "BRANTLEK" +"Middle School": "Gibbes" +"Geo Subdivision": "SC" +"School District": "Richland One" +"Elementary School": "Forest Heights" +"LO1Main Office ID": "1073" +"LA1Agent Last Name": "Brantley" +"Rollback Tax (Y/N)": "No" +"LA1Agent First Name": "Kimberly" +"Geo Update Timestamp": "2025-09-15T23:28:12.9" +"LO1Office Identifier": "1073" +"Address Search Number": "167" +"LO1Office Abbreviation": "WIHS01" +"Listing Type Agreement": "Exclusive Right to Sell" +"Publish to Internet Y/N": "Yes" +"First Photo Add Timestamp": "2025-09-15T23:28:13.5" +"Media": array:1 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6175470" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/617547/91ee715ca80e7aa72d68ba41499ac025.webp" "ClassName" => null "MediaSize" => 17290 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/617547/thumbnail-91ee715ca80e7aa72d68ba41499ac025.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "617547" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('617547')" } ] +success: true +page_size: 2 +page_count: 1 +count: 2 +after_key: "" } ] ]
