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 'Bungalow,Craftsman' OR ArchitecturalStyle eq 'Bungalow,Craftsman' OR CommunityFeatures eq 'Bungalow,Craftsman' OR Cooling eq 'Bungalow,Craftsman' OR CountyOrParish eq 'Bungalow,Craftsman' OR ElementarySchool eq 'Bungalow,Craftsman' OR ExteriorFeatures eq 'Bungalow,Craftsman' OR Flooring eq 'Bungalow,Craftsman' OR Heating eq 'Bungalow,Craftsman' OR HighSchool eq 'Bungalow,Craftsman' OR InteriorFeatures eq 'Bungalow,Craftsman' OR ListingTerms eq 'Bungalow,Craftsman' OR MiddleOrJuniorSchool eq 'Bungalow,Craftsman' OR ParkingFeatures eq 'Bungalow,Craftsman' OR PoolFeatures eq 'Bungalow,Craftsman' OR PropertyType eq 'Bungalow,Craftsman' OR Roof eq 'Bungalow,Craftsman' OR SchoolDistrict eq 'Bungalow,Craftsman' OR Sewer eq 'Bungalow,Craftsman' OR Utilities eq 'Bungalow,Craftsman' OR WaterfrontFeatures eq 'Bungalow,Craftsman') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3430 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3428 +post_id: "134301" +post_author: 1 +"ListingKey": "639594" +"ListingId": "639594" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-28T20:23:24Z" +"RFModificationTimestamp": "2026-07-28T20:28:12Z" +"ListPrice": 180000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0.22 +"LivingArea": 650.0 +"BuildingAreaTotal": 650.0 +"City": "Columbia" +"PostalCode": "29205" +"UnparsedAddress": "2217 Kingswood Drive, Columbia, SC 29205" +"Coordinates": array:2 [ 0 => -81.00796 1 => 33.980487 ] +"Latitude": 33.980487 +"Longitude": -81.00796 +"YearBuilt": 1950 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Yip Premier Real Estate LLC" +"ListAgentMlsId": "17672" +"ListOfficeMlsId": "922" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Enjoy updated living in the heart of Rosewood, one of Columbia's most convenient downtown neighborhoods. A welcoming covered front porch creates the perfect spot to relax and enjoy the surroundings. The home is within walking distance of Hunter-Gatherer Brewery and Owens Field Park, while also being just minutes from Williams-Brice Stadium. Numerous improvements provide added confidence and lasting value, including durable Hardy Plank siding and freshly painted exterior, updated major home systems, HVAC system, new electrical system, windows, new insulation in the walls and crawlspace, new drywall throughout home and a metal roof. Inside, hardwood flooring flows throughout the home, complemented by an updated kitchen with new cabinets, butcher block countertops and new appliances and a remodeled bathroom featuring designer tile flooring, oversize tub, and new vanity. The property also offers an exceptionally spacious 0.22 lot downtown, providing plenty of room for outdoor living, gardening, entertaining, or future possibilities. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Refrigerator" +"ArchitecturalStyle": "Bungalow,Craftsman" +"AssociationYN": false +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Fiber Cement-Hardy Plank" +"Cooling": "Central" +"CountyOrParish": "Richland" +"CreationDate": "2026-07-28T20:28:02.660190+00:00" +"Directions": "From Rosewood Drive, Turn right onto Superior St, Turn left onto Superior St, Continue straight onto Holt Dr, Turn right onto Kingswood Dr, and Home will be on the left." +"ExteriorFeatures": "Front Porch - Covered" +"Fencing": "Rear Only-Chain Link" +"Heating": "Central" +"InternetEntireListingDisplayYN": true +"ListAgentEmail": "natalie@yiprealestate.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OriginalEntryTimestamp": "2026-07-28" +"PhotosChangeTimestamp": "2026-07-28T20:23:24Z" +"PhotosCount": "19" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Counter Tops - Other,Cabinets-Painted,Floors-Luxury Vinyl Plank" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Kingswood" +"StreetNumber": "2217" +"StreetSuffix": "Drive" +"SubdivisionName": "ROSEWOOD" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/2217_kingswood_dr_columbia_sc/" +"WaterSource": "Public" +"TMS": "11216-23-13" +"Baths": "1" +"Range": "Free-standing" +"Garage": "None" +"Address": "2217 Kingswood Drive" +"LVTDate": "2026-07-28" +"PowerOn": "Yes" +"BathsFull": "1" +"#ofStories": "1" +"2ndBedroom": "Bath-Shared,Tub-Shower,Ceiling Fan,Closet-Private,Floors-Hardwood" +"BathsCombo": "1 / 0" +"HighSchool": "Dreher" +"IDXInclude": "Yes" +"LivingRoom": "Floors-Hardwood,Ceiling Fan" +"New/Resale": "Resale" +"class_name": "RE_1" +"LA1UserCode": "FIELDSN" +"GarageSpaces": "0" +"MiddleSchool": "Hand" +"PricePerSQFT": "276.92" +"ShortSaleY/N": "No" +"StatusDetail": "0" +"Level-Kitchen": "Main" +"LockboxNumber": "2468248" +"MasterBedroom": "Tub-Shower,Bath-Shared,Ceiling Fan,Closet-Private,Floors-Hardwood" +"AvailFinancing": "Cash,Conventional,FHA,VA" +"FullBaths-Main": "1" +"GeoSubdivision": "SC" +"HalfBaths-Main": "0" +"Level-Bedroom2": "Main" +"SchoolDistrict": "Richland One" +"LO1MainOfficeID": "922" +"OtherHeatedSqFt": "0" +"ElementarySchool": "Rosewood" +"LA1AgentLastName": "Robinson" +"Level-LivingRoom": "Main" +"ListPriceTotSqFt": "276.92" +"RollbackTax(Y/N)": "Unknown" +"LA1AgentFirstName": "Natalie" +"ForeclosedProperty": "No" +"GeoUpdateTimestamp": "2026-07-28T20:23:23.8" +"AddressSearchNumber": "2217" +"LO1OfficeIdentifier": "922" +"Level-MasterBedroom": "Main" +"ListingTypeAgreement": "Exclusive Right to Sell" +"PublishtoInternetY/N": "Yes" +"Interior#ofFireplaces": "0" +"LO1OfficeAbbreviation": "YIPP01" +"FirstPhotoAddTimestamp": "2026-07-28T20:23:24.8" +"MlsAreaMajor": "Columbia - South" +"Media": array:19 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6395940" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/98653afe41921a3deb27af500064cc89.webp" "ClassName" => "Single Family" "MediaSize" => 1073471 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-98653afe41921a3deb27af500064cc89.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6395941" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/426f7f1bfbb5060b2db33297e183a7ef.webp" "ClassName" => "Single Family" "MediaSize" => 751187 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-426f7f1bfbb5060b2db33297e183a7ef.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6395942" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/9dc0b8abe6934f64968b49067c28d98c.webp" "ClassName" => "Single Family" "MediaSize" => 295831 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-9dc0b8abe6934f64968b49067c28d98c.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6395943" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/d5259fae19b2bc03a1c92b84c3d39570.webp" "ClassName" => "Single Family" "MediaSize" => 315381 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-d5259fae19b2bc03a1c92b84c3d39570.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6395944" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/76ca102b5403d3b8668fb23b3cefcf52.webp" "ClassName" => "Single Family" "MediaSize" => 266419 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-76ca102b5403d3b8668fb23b3cefcf52.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6395945" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/e6da97e7da6bdc3faee6919c19f5c0a8.webp" "ClassName" => "Single Family" "MediaSize" => 265037 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-e6da97e7da6bdc3faee6919c19f5c0a8.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6395946" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/5d494d4c79c8a2c3f1498268054d5ee0.webp" "ClassName" => "Single Family" "MediaSize" => 248248 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-5d494d4c79c8a2c3f1498268054d5ee0.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6395947" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/0ff5b1f88cab523675984ae39ddde4ac.webp" "ClassName" => "Single Family" "MediaSize" => 232275 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-0ff5b1f88cab523675984ae39ddde4ac.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6395948" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/58f22d518247fe03e7b0600399ad283e.webp" "ClassName" => "Single Family" "MediaSize" => 167594 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-58f22d518247fe03e7b0600399ad283e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6395949" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/0872f27f05951224d2cbb62637ca3f3e.webp" "ClassName" => "Single Family" "MediaSize" => 245459 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-0872f27f05951224d2cbb62637ca3f3e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "63959410" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/5d8846ccee7066f0d2bf4735030a407a.webp" "ClassName" => "Single Family" "MediaSize" => 920828 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-5d8846ccee7066f0d2bf4735030a407a.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "63959411" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/20be2cb36c4b16875b0a38edae2c21f5.webp" "ClassName" => "Single Family" "MediaSize" => 986815 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-20be2cb36c4b16875b0a38edae2c21f5.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "63959412" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/b87fbc929c498ac3466da077e844ce7c.webp" "ClassName" => "Single Family" "MediaSize" => 733940 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-b87fbc929c498ac3466da077e844ce7c.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "63959413" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/54ea7746c3864f8159738b5f2e325e0b.webp" "ClassName" => "Single Family" "MediaSize" => 642819 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-54ea7746c3864f8159738b5f2e325e0b.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "63959414" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/b8c1ba5dc3e51fb7181977bf4a0eb7c5.webp" "ClassName" => "Single Family" "MediaSize" => 710689 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-b8c1ba5dc3e51fb7181977bf4a0eb7c5.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "63959415" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/32063e4332df56299922eb535be07994.webp" "ClassName" => "Single Family" "MediaSize" => 623758 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-32063e4332df56299922eb535be07994.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "63959416" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/cec7815d5bec7d26f5915be93c2eafe5.webp" "ClassName" => "Single Family" "MediaSize" => 481291 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-cec7815d5bec7d26f5915be93c2eafe5.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "63959417" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/2555993aa25db71bbce585bc9cd30f89.webp" "ClassName" => "Single Family" "MediaSize" => 1004601 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-2555993aa25db71bbce585bc9cd30f89.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "63959418" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/639594/76e7e805271e8d49e2c8008c21602be5.webp" "ClassName" => "Single Family" "MediaSize" => 967834 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/639594/thumbnail-76e7e805271e8d49e2c8008c21602be5.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "639594" ] ] +"DaysOnMarket": 1 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('639594')" +"ID": "134301" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.2 seconds" ] "RF Cache Key: 355e3afc486fdff1f6f76f2d532399a6282d222c99ce4105016c40e7e25b6acf" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3423 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3428} ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } ] ]
