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 Query: /Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=2817&$filter=(StandardStatus eq 'Active') and (StandardStatus eq 'For Sale' OR RFTransactionType eq 'For Sale')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#6347 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6358 +post_id: "78869" +post_author: 1 +"ListingKey": "1153241945" +"ListingId": "202604162" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-25T06:14:43Z" +"RFModificationTimestamp": "2026-02-25T06:18:08Z" +"ListPrice": 170000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 612759.0 +"LivingArea": 515.0 +"BuildingAreaTotal": 515.0 +"City": "Waianae" +"PostalCode": "96792" +"UnparsedAddress": "84-770 Kili Drive 432, Waianae, Hawaii 96792" +"Coordinates": array:2 [ 0 => -158.1989574 1 => 21.4851475 ] +"Latitude": 21.4851475 +"Longitude": -158.1989574 +"YearBuilt": 1970 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Deborah Castro" +"ListOfficeName": "West Oahu Realty, Inc." +"ListAgentMlsId": "24697" +"ListOfficeMlsId": "WORI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Enjoy Island Living, in this well maintained STUDIO, 1 bathroom bright open layout with beautiful ocean view.\r\n Corner End Unit with spacious lanai to enjoy the beauty of Hawaii living.\r\n Condo comes furnished. Seller hopes you love it as much as they did.\r\n Great location for outdoor activities. """ +"ArchitecturalStyle": "High Rise" +"AssociationFeeIncludes": "Cable TV,Electricity,HVAC,Hot Water,Internet,None,Sewer,Water" +"AttributionContact": "(808) 676-8858" +"BathroomsFull": 1 +"BuildingName": "Makaha Valley Towers" +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Community Pool,Conference/Meeting Room,Laundry Facilities,Pool,Storage Facilities,Trash Chute" +"ConstructionMaterials": "Concrete" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2026-02-19T20:46:13.194578+00:00" +"DaysOnMarket": 61 +"DaysOnMarketReplication": 5 +"DaysOnMarketReplicationDate": "2026-02-24" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "1031 Exchange" +"ElementarySchool": "Makaha" +"EntryLevel": 4 +"Flooring": "Ceramic Tile" +"FrontageType": "Other" +"Furnished": "Furnished" +"HighSchool": "Waianae" +"HumanModifiedYN": true +"Inclusions": "AC Central,Cable TV,Disposal,Drapes,Kitchenware,Linens,Microwave Hood,Refrigerator,Smoke Detector" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level,Storage" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 330-4375" +"ListAgentEmail": "debihawaii@hotmail.com" +"ListAgentKey": "10772433" +"ListAgentKeyNumeric": "10772433" +"ListAgentOfficePhone": "(808) 676-8858" +"ListAgentPreferredPhone": "(808) 330-4375" +"ListAgentStateLicense": "RB-18747" +"ListOfficeEmail": "worealty@westoahurealty.com" +"ListOfficeKey": "2587307" +"ListOfficeKeyNumeric": "2587307" +"ListOfficePhone": "(808) 676-8858" +"ListingContractDate": "2026-02-19" +"ListingKeyNumeric": 1153241945 +"ListingService": "Full Service" +"MLSAreaMajor": "Leeward" +"MaintenanceExpense": 958.0 +"MajorChangeTimestamp": "2026-02-19T10:43:53Z" +"MiddleOrJuniorSchool": "Waianae" +"MlsStatus": "Active" +"OnMarketDate": "2026-02-19" +"OpenParkingYN": true +"OriginalListPrice": 170000.0 +"OriginatingSystemKey": "19285251" +"ParcelNumber": "1-8-4-002-010-0062" +"ParkingFeatures": "Guest,Open,One Space,Secured,Unassigned" +"ParkingTotal": "1.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-02-19T20:50:02Z" +"PhotosCount": 13 +"PostalCity": "Waianae" +"PropertyCondition": "Excellent, Updated/Remodeled" +"SecurityFeatures": "Security Guard" +"SourceSystemKey": "1153241945" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kili" +"StreetNumber": "84-770" +"StreetSuffix": "Drive" +"SubdivisionName": "MAKAHA" +"TaxAnnualAmount": "504.0" +"TaxAssessedValue": 183900 +"UnitNumber": "432" +"View": "Coastline, Garden, Mountain(s), Ocean, Sunset" +"ViewYN": true +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1153241945"\n } """ +"AssociationFeeTotal": 958.0 +"TaxAssessedValueLand": "25100" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "158800" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1153241945')" +"provider_name": "HICMLS" +"RecordSignature": -1547522679 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-8-4-002-010-0062" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485689" +"OriginatingSystemListAgentMemberKey": "3474971" +"Media": array:13 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004880960563" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1153241945/46033baf3a9572ebbf9d917bbafe6984.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 299306 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1153241945/thumbnail-46033baf3a9572ebbf9d917bbafe6984.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772433" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587307" "MediaCategory" => null "MediaObjectID" => "thumbnail_IMG_6144.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "WORI" "LongDescription" => "Kitchen after remodel" "MediaAlteration" => null "MediaKeyNumeric" => 2004880960563 "PropertySubType" => "Condominium" "RecordSignature" => 1785477955 "PreferredPhotoYN" => null "ResourceRecordID" => "202604162" "ShortDescription" => "Kitchen after remodel" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1153241945" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1153241945 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19285298" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19285251" ] 1 => array:57 [ "Order" => 2 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004880960564" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1153241945/77e3762810841ef226e0ab5d9b63ab94.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 343507 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1153241945/thumbnail-77e3762810841ef226e0ab5d9b63ab94.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772433" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587307" "MediaCategory" => null "MediaObjectID" => "thumbnail_IMG_6145.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "WORI" "LongDescription" => "Bathroom shower" "MediaAlteration" => null "MediaKeyNumeric" => 2004880960564 "PropertySubType" => "Condominium" "RecordSignature" => 1785477955 "PreferredPhotoYN" => null "ResourceRecordID" => "202604162" "ShortDescription" => "Bathroom shower" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1153241945" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1153241945 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19285299" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19285251" ] 2 => array:57 [ "Order" => 3 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004880960565" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1153241945/8472d2925fa063836aa0c1b67db940d5.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 208797 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1153241945/thumbnail-8472d2925fa063836aa0c1b67db940d5.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772433" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587307" "MediaCategory" => null "MediaObjectID" => "thumbnail_IMG_6070.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "WORI" "LongDescription" => "Bathroom remodel vanity" "MediaAlteration" => null "MediaKeyNumeric" => 2004880960565 "PropertySubType" => "Condominium" "RecordSignature" => 1785477955 "PreferredPhotoYN" => null "ResourceRecordID" => "202604162" "ShortDescription" => "Bathroom remodel vanity" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1153241945" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1153241945 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19285300" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19285251" ] 3 => array:57 [ "Order" => 4 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004880960566" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1153241945/2994360056762b7812f90c874b67483f.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 367624 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1153241945/thumbnail-2994360056762b7812f90c874b67483f.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772433" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587307" "MediaCategory" => null "MediaObjectID" => "LR 1a.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "WORI" "LongDescription" => "TV, desk, bose, small refrigerator" "MediaAlteration" => null "MediaKeyNumeric" => 2004880960566 "PropertySubType" => "Condominium" "RecordSignature" => 1785477955 "PreferredPhotoYN" => null "ResourceRecordID" => "202604162" "ShortDescription" => "TV, desk, bose, small refrigerator" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1153241945" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1153241945 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19285301" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19285251" ] 4 => array:57 [ "Order" => 5 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004880960568" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1153241945/2e794f2849687673335c5a1f2a42f21d.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 471507 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1153241945/thumbnail-2e794f2849687673335c5a1f2a42f21d.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772433" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587307" "MediaCategory" => null "MediaObjectID" => "LR Chairs 2.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "WORI" "LongDescription" => "Living Room Chairs" "MediaAlteration" => null "MediaKeyNumeric" => 2004880960568 "PropertySubType" => "Condominium" "RecordSignature" => 1785477955 "PreferredPhotoYN" => null "ResourceRecordID" => "202604162" "ShortDescription" => "Living Room Chairs" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1153241945" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1153241945 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19285302" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19285251" ] 5 => array:57 [ "Order" => 6 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004880960570" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1153241945/c6ab796ef61452a2dbe0181dba0c7380.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 558010 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1153241945/thumbnail-c6ab796ef61452a2dbe0181dba0c7380.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772433" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587307" "MediaCategory" => null "MediaObjectID" => "Lanai 1.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "WORI" "LongDescription" => "Lanai" "MediaAlteration" => null "MediaKeyNumeric" => 2004880960570 "PropertySubType" => "Condominium" "RecordSignature" => 1785477955 "PreferredPhotoYN" => null "ResourceRecordID" => "202604162" "ShortDescription" => "Lanai" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1153241945" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1153241945 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19285303" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19285251" ] 6 => array:57 [ "Order" => 7 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004880960571" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1153241945/6eec8302900ef655cd41b1f23fa8c509.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 278575 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1153241945/thumbnail-6eec8302900ef655cd41b1f23fa8c509.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772433" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587307" "MediaCategory" => null "MediaObjectID" => "Bath 3 dresser n desk.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "WORI" "LongDescription" => "Dresser in Bathroom" "MediaAlteration" => null "MediaKeyNumeric" => 2004880960571 "PropertySubType" => "Condominium" "RecordSignature" => 1785477955 "PreferredPhotoYN" => null "ResourceRecordID" => "202604162" "ShortDescription" => "Dresser in Bathroom" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1153241945" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1153241945 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19285304" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19285251" ] 7 => array:57 [ "Order" => 8 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004880960572" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1153241945/00e7c8bf8c2c85e64cd0e95f70c862d6.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 450653 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1153241945/thumbnail-00e7c8bf8c2c85e64cd0e95f70c862d6.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772433" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587307" "MediaCategory" => null "MediaObjectID" => "Bath Wood Dresser in Closet.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "WORI" "LongDescription" => "Dresser in Closet" "MediaAlteration" => null "MediaKeyNumeric" => 2004880960572 "PropertySubType" => "Condominium" "RecordSignature" => 1785477955 "PreferredPhotoYN" => null "ResourceRecordID" => "202604162" "ShortDescription" => "Dresser in Closet" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1153241945" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1153241945 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19285305" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19285251" ] 8 => array:57 [ "Order" => 9 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004880960573" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1153241945/a87240e699e206411268e848a3603939.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 495261 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1153241945/thumbnail-a87240e699e206411268e848a3603939.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772433" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587307" "MediaCategory" => null "MediaObjectID" => "Bed 1.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "WORI" "LongDescription" => "Bed" "MediaAlteration" => null "MediaKeyNumeric" => 2004880960573 "PropertySubType" => "Condominium" "RecordSignature" => 1785477955 "PreferredPhotoYN" => null "ResourceRecordID" => "202604162" "ShortDescription" => "Bed" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1153241945" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1153241945 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19285306" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19285251" ] 9 => array:57 [ "Order" => 10 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004880960574" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1153241945/322569141b42be21f05fdc1a9b541dfa.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 483787 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1153241945/thumbnail-322569141b42be21f05fdc1a9b541dfa.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772433" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587307" "MediaCategory" => null "MediaObjectID" => "Bed 4.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "WORI" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004880960574 "PropertySubType" => "Condominium" "RecordSignature" => 1785477955 "PreferredPhotoYN" => null "ResourceRecordID" => "202604162" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1153241945" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1153241945 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19285307" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19285251" ] 10 => array:57 [ "Order" => 11 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004880960575" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1153241945/0afc22c5a3c2b6a9aedabe5e4f883cca.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 414469 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1153241945/thumbnail-0afc22c5a3c2b6a9aedabe5e4f883cca.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772433" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587307" "MediaCategory" => null "MediaObjectID" => "K 2.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "WORI" "LongDescription" => "Dining Table" "MediaAlteration" => null "MediaKeyNumeric" => 2004880960575 "PropertySubType" => "Condominium" "RecordSignature" => 1785477955 "PreferredPhotoYN" => null "ResourceRecordID" => "202604162" "ShortDescription" => "Dining Table" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1153241945" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1153241945 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19285308" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-02-19T20:38:38.357-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19285251" ] 11 => array:57 [ "Order" => 12 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004880960961" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1153241945/abd19ca955a80a9ecf0b8064bb271392.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 388221 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1153241945/thumbnail-abd19ca955a80a9ecf0b8064bb271392.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772433" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587307" "MediaCategory" => null "MediaObjectID" => "K 3.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "WORI" "LongDescription" => "Kitchen" "MediaAlteration" => null "MediaKeyNumeric" => 2004880960961 "PropertySubType" => "Condominium" "RecordSignature" => 1785477955 "PreferredPhotoYN" => null "ResourceRecordID" => "202604162" "ShortDescription" => "Kitchen" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1153241945" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-19T20:39:17.563-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1153241945 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19285309" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-02-19T20:39:17.563-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19285251" ] 12 => array:57 [ "Order" => 13 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004880993224" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1153241945/5c3264674e20bb377ad9b596ea6dd303.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 513579 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1153241945/thumbnail-5c3264674e20bb377ad9b596ea6dd303.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772433" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587307" "MediaCategory" => null "MediaObjectID" => "Entryway 3.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "WORI" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004880993224 "PropertySubType" => "Condominium" "RecordSignature" => 170439038 "PreferredPhotoYN" => null "ResourceRecordID" => "202604162" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1153241945" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-19T20:49:35.070-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1153241945 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19285341" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-02-19T20:49:35.070-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19285251" ] ] +"ID": "78869" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6356 +post_id: "54106" +post_author: 1 +"ListingKey": "1118535117" +"ListingId": "202514985" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-25T02:16:22Z" +"RFModificationTimestamp": "2026-02-25T02:21:15Z" +"ListPrice": 1020000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 765523.0 +"LivingArea": 658.0 +"BuildingAreaTotal": 658.0 +"City": "Kahuku" +"PostalCode": "96731" +"UnparsedAddress": "57-101 Kuilima Drive 189, Kahuku, Hawaii 96731" +"Coordinates": array:2 [ 0 => -157.9942753 1 => 21.7010774 ] +"Latitude": 21.7010774 +"Longitude": -157.9942753 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sophia L Miller" +"ListOfficeName": "Sterman Realty" +"ListAgentMlsId": "49227" +"ListOfficeMlsId": "STER" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Resort style living without the resort prices! This is a wonderful opportunity to own a one bedroom, one bathroom unit in the beautiful Kuilima Estates West project located at Turtle Bay. Great for investors, Kuilima Estates West is approved for short term rentals with proper registration. With three pools and two tennis courts on site, plus just a short distance to multiple stunning beaches, the resort golf courses, shops, spas, and restaurants, there is plenty to keep you busy at Turtle Bay. Come and see it today!" +"ArchitecturalStyle": "Low Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Maintenance Grounds,Maintenance Structure,Sewer,Water" +"AttributionContact": "(808) 637-6200" +"AvailabilityDate": "2025-11-03" +"BathroomsFull": 1 +"BuildingName": "Kuilima Ests West" +"CLIP": 4461649153 +"CoListAgentDirectPhone": "(808) 637-6200" +"CoListAgentEmail": "david@sterman.com" +"CoListAgentFullName": "David J Sterman" +"CoListAgentKey": "10774711" +"CoListAgentKeyNumeric": "10774711" +"CoListAgentMlsId": "47029" +"CoListAgentPreferredPhone": "(808) 371-4622" +"CoListOfficeEmail": "richard@sterman.com" +"CoListOfficeKey": "2586627" +"CoListOfficeKeyNumeric": "2586627" +"CoListOfficeMlsId": "STER" +"CoListOfficeName": "Sterman Realty" +"CoListOfficePhone": "(808) 637-6200" +"CommunityFeatures": "Barbecue,Deck/Porch,Patio,Pool,Tennis Court(s),Trails/Paths,Gated" +"ConstructionMaterials": "Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-06-28T02:32:21.139856+00:00" +"DaysOnMarket": 288 +"DaysOnMarketReplication": 232 +"DaysOnMarketReplicationDate": "2026-02-24" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "1031 Exchange" +"ElementarySchool": "Kahuku" +"EntryLevel": 1 +"Fencing": "Fenced, Wall" +"Flooring": "Ceramic Tile,Laminate" +"FoundationDetails": "Slab" +"FrontageType": "Other" +"Furnished": "Negotiable" +"HighSchool": "Kahuku" +"HumanModifiedYN": true +"Inclusions": "AC Window Unit,Cable TV,Ceiling Fan,Dishwasher,Disposal,Dryer,Microwave Hood,Range/Oven,Refrigerator,Washer,Water Heater" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 637-6200" +"ListAgentEmail": "sophia@sterman.com" +"ListAgentKey": "13402072" +"ListAgentKeyNumeric": "13402072" +"ListAgentOfficePhone": "(808) 637-6200" +"ListAgentPreferredPhone": "(808) 637-6200" +"ListAgentStateLicense": "RS-81639" +"ListOfficeEmail": "richard@sterman.com" +"ListOfficeKey": "2586627" +"ListOfficeKeyNumeric": "2586627" +"ListOfficePhone": "(808) 637-6200" +"ListingContractDate": "2025-06-25" +"ListingKeyNumeric": 1118535117 +"ListingService": "Full Service" +"MLSAreaMajor": "North Shore" +"MaintenanceExpense": 740.0 +"MajorChangeTimestamp": "2025-11-17T15:41:06Z" +"MiddleOrJuniorSchool": "Kahuku" +"MlsStatus": "Active" +"OnMarketDate": "2025-06-25" +"OpenParkingYN": true +"OriginalListPrice": 1070000.0 +"OriginatingSystemKey": "18834640" +"ParcelNumber": "1-5-7-001-029-0189" +"ParkingFeatures": "Assigned,Guest,One Space" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 24 +"PostalCity": "Kahuku" +"PropertyCondition": "Good Condition,Updated/Remodeled" +"SecurityFeatures": "Gated Community,Key Card Entry,Security Guard" +"SourceSystemKey": "1118535117" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Kuilima" +"StreetNumber": "57-101" +"StreetSuffix": "Drive" +"SubdivisionName": "KUILIMA" +"TaxAnnualAmount": "8995.92" +"TaxAssessedValue": 1032500 +"UnitNumber": "189" +"View": "Other" +"ViewYN": true +"ZoningDescription": "11 - A-1 Low Density Apartment" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1118535117"\n } """ +"AssociationFeeTotal": 740.0 +"TaxAssessedValueLand": "203000" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "829500" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1118535117')" +"provider_name": "HICMLS" +"RecordSignature": 1002697308 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-5-7-001-029-0189" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485009" +"OriginatingSystemCoListOfficeKey": "3485009" +"OriginatingSystemListAgentMemberKey": "14046662" +"OriginatingSystemCoListAgentMemberKey": "10754000" +"Media": array:24 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004082578900" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1118535117/de6e333a8727c41d3257e7663bd0adcc.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 951378 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1118535117/thumbnail-de6e333a8727c41d3257e7663bd0adcc.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13402072" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2586627" "MediaCategory" => null "MediaObjectID" => "2.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "STER" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004082578900 "PropertySubType" => "Condominium" "RecordSignature" => -509377696 "PreferredPhotoYN" => null "ResourceRecordID" => "202514985" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1118535117" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:16.540-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1118535117 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18835087" "PropertySubTypeAdditional" => "Condominium,Fractional" "MediaModificationTimestamp" => "2025-11-11T00:21:16.540-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18834640" ] 1 => array:57 [ "Order" => 2 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004082578901" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1118535117/5dca8b47433677753144bccd102564cc.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 926546 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1118535117/thumbnail-5dca8b47433677753144bccd102564cc.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13402072" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2586627" "MediaCategory" => null "MediaObjectID" => "DJI_0319.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "STER" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004082578901 "PropertySubType" => "Condominium" "RecordSignature" => -509377696 "PreferredPhotoYN" => null "ResourceRecordID" => "202514985" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1118535117" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:16.540-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1118535117 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18835088" "PropertySubTypeAdditional" => "Condominium,Fractional" "MediaModificationTimestamp" => "2025-11-11T00:21:16.540-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18834640" ] 2 => array:57 [ "Order" => 3 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004082578902" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1118535117/1662bd8311f253b02bd9c1188ef08998.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 878599 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1118535117/thumbnail-1662bd8311f253b02bd9c1188ef08998.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13402072" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2586627" "MediaCategory" => null "MediaObjectID" => "1.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "STER" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004082578902 "PropertySubType" => "Condominium" "RecordSignature" => -509377696 "PreferredPhotoYN" => null "ResourceRecordID" => "202514985" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1118535117" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:16.540-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1118535117 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18835089" "PropertySubTypeAdditional" => "Condominium,Fractional" "MediaModificationTimestamp" => "2025-11-11T00:21:16.540-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18834640" ] 3 => array:57 [ "Order" => 4 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004082578903" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1118535117/61c42fd8cf75504c895f3ed3964b15f4.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 485422 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1118535117/thumbnail-61c42fd8cf75504c895f3ed3964b15f4.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13402072" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2586627" "MediaCategory" => null "MediaObjectID" => "DSC00078.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "STER" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004082578903 "PropertySubType" => "Condominium" "RecordSignature" => -509377696 "PreferredPhotoYN" => null "ResourceRecordID" => "202514985" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1118535117" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:16.540-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1118535117 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18835090" "PropertySubTypeAdditional" => "Condominium,Fractional" "MediaModificationTimestamp" => "2025-11-11T00:21:16.540-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18834640" ] 4 => array:57 [ "Order" => 5 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004082578904" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1118535117/258d3d4517cd3fb4a2f4650bf25941f5.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 391201 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1118535117/thumbnail-258d3d4517cd3fb4a2f4650bf25941f5.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13402072" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2586627" "MediaCategory" => null "MediaObjectID" => "DSC00064.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "STER" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004082578904 "PropertySubType" => "Condominium" "RecordSignature" => -509377696 "PreferredPhotoYN" => null "ResourceRecordID" => "202514985" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1118535117" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:16.540-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1118535117 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18835091" "PropertySubTypeAdditional" => "Condominium,Fractional" "MediaModificationTimestamp" => "2025-11-11T00:21:16.540-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18834640" ] 5 => array:57 [ "Order" => 6 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004082578905" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1118535117/1f61dd41d2435ce3bd3d867d3cfc66ac.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 394414 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1118535117/thumbnail-1f61dd41d2435ce3bd3d867d3cfc66ac.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13402072" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2586627" "MediaCategory" => null "MediaObjectID" => "DSC00076.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "STER" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004082578905 "PropertySubType" => "Condominium" "RecordSignature" => -509377696 "PreferredPhotoYN" => null "ResourceRecordID" => "202514985" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1118535117" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:16.540-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1118535117 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18835092" "PropertySubTypeAdditional" => "Condominium,Fractional" "MediaModificationTimestamp" => "2025-11-11T00:21:16.540-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18834640" ] 6 => array:57 [ "Order" => 7 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004082578906" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1118535117/325e67fd5a44ece6bf168ecf545a3950.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 355174 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1118535117/thumbnail-325e67fd5a44ece6bf168ecf545a3950.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13402072" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2586627" "MediaCategory" => null "MediaObjectID" => "DSC00074.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "STER" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004082578906 "PropertySubType" => "Condominium" "RecordSignature" => -509377696 "PreferredPhotoYN" => null "ResourceRecordID" => "202514985" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1118535117" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:16.540-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1118535117 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18835093" "PropertySubTypeAdditional" => "Condominium,Fractional" "MediaModificationTimestamp" => "2025-11-11T00:21:16.540-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18834640" ] 7 => array:57 [ "Order" => 8 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004082578907" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1118535117/9361fb8a680626caeed29a80c4df0d1b.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 417619 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1118535117/thumbnail-9361fb8a680626caeed29a80c4df0d1b.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13402072" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2586627" "MediaCategory" => null "MediaObjectID" => "DSC00090.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "STER" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004082578907 "PropertySubType" => "Condominium" "RecordSignature" => -509377696 "PreferredPhotoYN" => null "ResourceRecordID" => "202514985" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1118535117" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:16.540-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1118535117 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18835094" "PropertySubTypeAdditional" => "Condominium,Fractional" "MediaModificationTimestamp" => "2025-11-11T00:21:16.540-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18834640" ] 8 => array:57 [ "Order" => 9 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004082578908" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1118535117/d0fa1a465384f17e2636d4925190f150.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 465547 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1118535117/thumbnail-d0fa1a465384f17e2636d4925190f150.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13402072" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2586627" "MediaCategory" => null "MediaObjectID" => "DSC00092.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "STER" "LongDescription" => null …29 ] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] 22 => array:57 [ …57] 23 => array:57 [ …57] ] +"ID": "54106" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6359 +post_id: "62837" +post_author: 1 +"ListingKey": "1147078826" +"ListingId": "202526012" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-25T01:01:42Z" +"RFModificationTimestamp": "2026-02-25T01:03:44Z" +"ListPrice": 645000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 45259.0 +"LivingArea": 1128.0 +"BuildingAreaTotal": 1199.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "2215 Aloha Drive Dh405, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ 0 => -157.855676 1 => 21.304547 ] +"Latitude": 21.304547 +"Longitude": -157.855676 +"YearBuilt": 1976 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Miki Kojima" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "52456" +"ListOfficeMlsId": "CBPP" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "A spacious corner-unit 2-bedroom residence in the heart of Waikiki. This home is partially remodeled in 2025 with new flooring throughout the entire unit and an open-concept kitchen, creating a bright and comfortable living space. The unit includes an in-unit washer and dryer and central AC. The maintenance fee covers central AC, electricity, cable, Wi-Fi, sewer, water, hot water and common area maintenance. Aloha Towers consist of two towers, and owners can enjoy the amenities in both, including a heated pool, whirlpool, sauna, barbecue areas, and recreation spaces, plus the convenience of guest parking in each building. The building is 100% insured, and on -site security provides added peace of mind. The location is convenient, just moments from shopping, dining, and the beach." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFee2": "500.0" +"AssociationFeeIncludes": "Common Areas,Cable TV,Electricity,Gas,HVAC,Hot Water,Internet,Sewer,Water" +"AttributionContact": "(808) 596-0456" +"BathroomsFull": 2 +"BuildingName": "Aloha Towers" +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Clubhouse,Deck/Porch,Patio,Pool,Recreation Area,Sauna,Trash Chute" +"ConstructionMaterials": "Concrete" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2025-11-24T21:19:18.204069+00:00" +"DaysOnMarket": 148 +"DaysOnMarketReplication": 92 +"DaysOnMarketReplicationDate": "2026-02-24" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Pet on Property,Seller Disclosure" +"ElementarySchool": "Jefferson" +"EntryLevel": 4 +"Flooring": "Vinyl" +"Furnished": "Negotiable" +"HighSchool": "Kaimuki" +"HumanModifiedYN": true +"Inclusions": "AC Central,Dishwasher,Disposal,Drapes,Dryer,Microwave Hood,Range/Oven,Smoke Detector,Washer" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More,One" +"ListAgentDirectPhone": "(808) 725-4687" +"ListAgentEmail": "miki.kojima@cbrealty.com" +"ListAgentKey": "21268166" +"ListAgentKeyNumeric": "21268166" +"ListAgentOfficePhone": "(808) 596-0456" +"ListAgentPreferredPhone": "(808) 725-4687" +"ListAgentStateLicense": "RS-85511" +"ListOfficeEmail": "mike.james@cbrealty.com" +"ListOfficeKey": "2586830" +"ListOfficeKeyNumeric": "2586830" +"ListOfficePhone": "(808) 596-0456" +"ListingContractDate": "2025-11-24" +"ListingKeyNumeric": 1147078826 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1643.0 +"MajorChangeTimestamp": "2025-11-24T11:14:43Z" +"MiddleOrJuniorSchool": "Washington" +"MlsStatus": "Active" +"OnMarketDate": "2025-11-24" +"OriginalListPrice": 645000.0 +"OriginatingSystemKey": "19134785" +"ParcelNumber": "1-2-6-017-005-0131" +"ParkingFeatures": "Covered,Guest,One Space" +"ParkingTotal": "1.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2025-11-24T20:34:01Z" +"PhotosCount": 20 +"PoolFeatures": "Heated" +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition,Updated/Remodeled" +"SecurityFeatures": "Elevator Secured,Key Card Entry,Security Guard" +"SourceSystemKey": "1147078826" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Aloha" +"StreetNumber": "2215" +"StreetNumberNumeric": "2215" +"StreetSuffix": "Drive" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "1731.0" +"TaxAssessedValue": 614500 +"UnitNumber": "DH405" +"View": "City" +"ViewYN": true +"YearBuiltEffective": 2025 +"ZoningDescription": "X2 - Apartment Precinct" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1147078826"\n } """ +"AssociationFeeTotal": 2143.0 +"TaxAssessedValueLand": "97900" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "516600" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1147078826')" +"provider_name": "HICMLS" +"RecordSignature": -941284924 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-017-005-0131" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485212" +"OriginatingSystemListAgentMemberKey": "16725366" +"Media": array:20 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] ] +"ID": "62837" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6355 +post_id: "79010" +post_author: 1 +"ListingKey": "1153328170" +"ListingId": "202604294" +"PropertyType": "For Sale" +"PropertySubType": "Multi Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-25T00:54:20Z" +"RFModificationTimestamp": "2026-02-25T00:59:14Z" +"ListPrice": 2200000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 4914.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Honolulu" +"PostalCode": "96826" +"UnparsedAddress": "2205 Fern Street, Honolulu, Hawaii 96826" +"Coordinates": array:2 [ 0 => -157.8292586 1 => 21.290095 ] +"Latitude": 21.290095 +"Longitude": -157.8292586 +"YearBuilt": 2002 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Darren T Wong" +"ListOfficeName": "Realty Experts Hawaii, Inc." +"ListAgentMlsId": "42132" +"ListOfficeMlsId": "EXPT" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Conveniently located within a mile of the famous Waikiki Beach, Ala Moana Beach Park, Ala Moana Shopping Center and Mccully Shopping Center. This versatile property is a great multifamily/multi-generational opportunity. Property features 2 side by side units that are separately metered for water/sewer and electricity. Each side can also be split between the upstairs and downstairs making a total of 4 units all with separate entrances. One side of the house built in 2002 features a 2 car enclosed garage with 3 bed/1 bath upstairs and 2 bed/1 bath downstairs. The other side built in 2008 features a carport for 2 cars with 3 bed/1.5 bath upstairs and 2 bed/1 bath downstairs. Close to an array of dining and shopping options, schools, bus lines and freeway access. This house has been well maintained and features a new roof! Sold "As Is". Tax records do not match. Do not go onto the property. Do Not disturb the tenants." +"Appliances": "Dryer, Washer" +"AttributionContact": "(808) 386-4486" +"CommunityFeatures": "None" +"ConstructionMaterials": "Double Wall,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-02-22T01:51:35.878285+00:00" +"DaysOnMarket": 59 +"DaysOnMarketReplication": 3 +"DaysOnMarketReplicationDate": "2026-02-24" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"FoundationDetails": "Slab" +"Furnished": "Partially" +"HumanModifiedYN": true +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 386-4792" +"ListAgentEmail": "darrenwongrealtor@gmail.com" +"ListAgentKey": "10778232" +"ListAgentKeyNumeric": "10778232" +"ListAgentOfficePhone": "(808) 386-4486" +"ListAgentPreferredPhone": "(808) 386-4792" +"ListAgentStateLicense": "RB-22385" +"ListOfficeEmail": "reidito@hotmail.com" +"ListOfficeKey": "2588767" +"ListOfficeKeyNumeric": "2588767" +"ListOfficePhone": "(808) 386-4486" +"ListingContractDate": "2026-02-21" +"ListingKeyNumeric": 1153328170 +"ListingService": "Full Service" +"LotFeatures": "Corner Lot,Other,Level" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2026-02-21T15:47:50Z" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "4" +"OnMarketDate": "2026-02-21" +"OpenParkingYN": true +"OperatingExpenseIncludes": "Real Estate Tax" +"OriginalListPrice": 2200000.0 +"OriginatingSystemKey": "19288880" +"ParcelNumber": "1-2-7-005-063-0000" +"ParkingFeatures": "Covered, Open" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2026-02-21T10:46:00Z" +"PhotosCount": 13 +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"Sewer": "Connected,Septic Tank" +"SourceSystemKey": "1153328170" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Fern" +"StreetNumber": "2205" +"StreetNumberNumeric": "2205" +"StreetSuffix": "Street" +"StructureType": "Duplex" +"SubdivisionName": "MOILIILI" +"TaxAnnualAmount": "6997.56" +"TaxAssessedValue": 1999300 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,High Speed Internet Available,Septic Available,Water Available,Sewer Connected" +"View": "Other" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltEffective": 2008 +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1153328170"\n } """ +"TaxAssessedValueLand": "1317000" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "682300" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1153328170')" +"provider_name": "HICMLS" +"RecordSignature": 1409282924 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-7-005-063-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3487149" +"OriginatingSystemListAgentMemberKey": "3482865" +"Media": array:13 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] ] +"ID": "79010" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6357 +post_id: "79142" +post_author: 1 +"ListingKey": "1151907439" +"ListingId": "202601961" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-25T00:06:28Z" +"RFModificationTimestamp": "2026-02-25T00:12:02Z" +"ListPrice": 89000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 62.0 +"BuildingAreaTotal": 62.0 +"City": "Honolulu" +"PostalCode": "96814" +"UnparsedAddress": "1108 Auahi Street M S07, Honolulu, Hawaii 96814" +"Coordinates": array:2 [ 0 => -157.855676 1 => 21.304547 ] +"Latitude": 21.304547 +"Longitude": -157.855676 +"YearBuilt": 2017 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Keahi D Pelayo" +"ListOfficeName": "NextHome KU Realty" +"ListAgentMlsId": "20348" +"ListOfficeMlsId": "KURE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Well priced Anaha storage unit. Enjoy a convenient location which is just inside the fobbed entry door to the storage area. Well lit and lots of space for your storage need. Must be purchased by owner of unit at Anaha. Submit all offers." +"ArchitecturalStyle": "High Rise" +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 838-9595" +"BuildingName": "1108 Auahi" +"CommunityFeatures": "None" +"ConstructionMaterials": "Hollow Tile" +"CountyOrParish": "Oahu" +"CreationDate": "2026-02-25T00:11:42.756068+00:00" +"DaysOnMarketReplicationDate": "2026-02-24" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"EntryLevel": 1 +"Flooring": "Other" +"FoundationDetails": "Slab" +"HumanModifiedYN": true +"Inclusions": "None" +"InteriorFeatures": "Storage" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 398-3220" +"ListAgentEmail": "keahi@keahipelayo.com" +"ListAgentKey": "10777308" +"ListAgentKeyNumeric": "10777308" +"ListAgentOfficePhone": "(808) 838-9595" +"ListAgentPreferredPhone": "(808) 398-3220" +"ListAgentStateLicense": "RB-16752" +"ListOfficeEmail": "keahi@keahipelayo.com" +"ListOfficeKey": "2585527" +"ListOfficeKeyNumeric": "2585527" +"ListOfficePhone": "(808) 838-9595" +"ListingContractDate": "2026-02-24" +"ListingKeyNumeric": 1151907439 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2026-02-24T14:05:54Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-02-24" +"OriginalListPrice": 89000.0 +"OriginatingSystemKey": "19240880" +"ParcelNumber": "1-2-3-005-028-0084" +"ParkingFeatures": "None" +"PhotosChangeTimestamp": "2026-02-02T21:01:01Z" +"PhotosCount": 5 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1151907439" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Auahi" +"StreetNumber": "1108" +"StreetNumberNumeric": "1108" +"StreetSuffix": "Street" +"SubdivisionName": "KAKAAKO" +"TaxAssessedValue": 1112900 +"UnitNumber": "M S07" +"View": "None" +"ZoningDescription": "Kak – Kakaako Community Development Project" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1151907439"\n } """ +"AssociationFeeTotal": 0.0 +"TaxAssessedValueLand": "41700" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "1071200" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1151907439')" +"provider_name": "HICMLS" +"short_address": "Honolulu, Hawaii 96814, USA" +"RecordSignature": 152521959 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-005-028-0084" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3487409" +"OriginatingSystemListAgentMemberKey": "3473737" +"Media": array:5 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] ] +"ID": "79142" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6457 +post_id: "79090" +post_author: 1 +"ListingKey": "1153258536" +"ListingId": "202604185" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-24T23:34:28Z" +"RFModificationTimestamp": "2026-02-24T23:38:16Z" +"ListPrice": 359000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 572.0 +"BuildingAreaTotal": 612.0 +"City": "Honolulu" +"PostalCode": "96822" +"UnparsedAddress": "1415 Liholiho Street 704, Honolulu, Hawaii 96822" +"Coordinates": array:2 [ 0 => -157.8391383 1 => 21.3054761 ] +"Latitude": 21.3054761 +"Longitude": -157.8391383 +"YearBuilt": 1979 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Aaron Lin" +"ListOfficeName": "Luxury Homes International" +"ListAgentMlsId": "44951" +"ListOfficeMlsId": "LXHM" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Welcome home to Lunaliho Towers - a secure and well-maintained building nestled in the heart of desirable Makiki neighborhood. This move-in ready + renovated 1 bedroom, 1 bath apartment with 1 secure standard parking stall offers comfort, convenience, and modern updates, which include NEW interior paint, vinyl flooring, updated kitchen with new appliances, range/oven, newly renovated bathroom w/ tiled walk-in shower. BONUS: Enjoy the added convenience of your own washer and dryer in the unit! This secure building provides peace of mind and is ideally located near freeway access, shopping, bus lines, and just minutes from the University of Hawaii at Manoa." +"ArchitecturalStyle": "High Rise" +"AssociationFeeIncludes": "Maintenance Grounds,Maintenance Structure,Sewer,Water" +"AttributionContact": "(808) 797-3344" +"BathroomsFull": 1 +"BuildingName": "Luna-Liho Towers" +"CoListAgentDirectPhone": "(808) 797-3344" +"CoListAgentEmail": "Robinsonkjeremy@gmail.com" +"CoListAgentFullName": "Jeremy Robinson" +"CoListAgentKey": "22616930" +"CoListAgentKeyNumeric": "22616930" +"CoListAgentMlsId": "53621" +"CoListAgentPreferredPhone": "(808) 388-5319" +"CoListOfficeEmail": "Patrick@Luxury Hm.com" +"CoListOfficeKey": "2589213" +"CoListOfficeKeyNumeric": "2589213" +"CoListOfficeMlsId": "LXHM" +"CoListOfficeName": "Luxury Homes International" +"CoListOfficePhone": "(808) 797-3344" +"CommunityFeatures": "Deck/Porch, Patio" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-02-23T23:18:12.985132+00:00" +"DaysOnMarket": 57 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2026-02-24" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Kaahumanu" +"EntryLevel": 7 +"Flooring": "Vinyl" +"FrontageType": "Other" +"Furnished": "Unfurnished" +"HighSchool": "Mckinley" +"HumanModifiedYN": true +"Inclusions": "AC Window Unit,Blinds,Dryer,Range Hood,Range/Oven,Refrigerator,Washer" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More,One" +"ListAgentDirectPhone": "(808) 392-8906" +"ListAgentEmail": "Aaron@Luxury Hm.com" +"ListAgentKey": "10774074" +"ListAgentKeyNumeric": "10774074" +"ListAgentOfficePhone": "(808) 797-3344" +"ListAgentPreferredPhone": "(808) 392-8906" +"ListAgentStateLicense": "RB-22954" +"ListOfficeEmail": "Patrick@Luxury Hm.com" +"ListOfficeKey": "2589213" +"ListOfficeKeyNumeric": "2589213" +"ListOfficePhone": "(808) 797-3344" +"ListingContractDate": "2026-02-23" +"ListingKeyNumeric": 1153258536 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 719.0 +"MajorChangeTimestamp": "2026-02-23T13:12:09Z" +"MiddleOrJuniorSchool": "Stevenson" +"MlsStatus": "Active" +"OnMarketDate": "2026-02-23" +"OriginalListPrice": 359000.0 +"OriginatingSystemKey": "19285780" +"ParcelNumber": "1-2-4-020-019-0049" +"ParkingFeatures": "Assigned,Covered,One Space" +"ParkingTotal": "1.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-02-23T23:38:00Z" +"PhotosCount": 17 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"SecurityFeatures": "Elevator Secured,Key Card Entry" +"SourceSystemKey": "1153258536" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Liholiho" +"StreetNumber": "1415" +"StreetNumberNumeric": "1415" +"StreetSuffix": "Street" +"SubdivisionName": "MAKIKI AREA" +"TaxAnnualAmount": "1200.0" +"TaxAssessedValue": 341800 +"UnitNumber": "704" +"View": "City, Mountain(s)" +"ViewYN": true +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1153258536"\n } """ +"AssociationFeeTotal": 719.0 +"TaxAssessedValueLand": "37100" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "304700" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1153258536')" +"provider_name": "HICMLS" +"RecordSignature": 219830881 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-4-020-019-0049" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10320561" +"OriginatingSystemCoListOfficeKey": "10320561" +"OriginatingSystemListAgentMemberKey": "9407917" +"OriginatingSystemCoListAgentMemberKey": "17659906" +"Media": array:17 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] ] +"ID": "79090" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6349 +post_id: "79134" +post_author: 1 +"ListingKey": "1153411644" +"ListingId": "202604418" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-24T22:15:06Z" +"RFModificationTimestamp": "2026-02-24T22:17:18Z" +"ListPrice": 347000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 667.0 +"BuildingAreaTotal": 667.0 +"City": "Honolulu" +"PostalCode": "96826" +"UnparsedAddress": "2018 Fern Street 304, Honolulu, Hawaii 96826" +"Coordinates": array:2 [ 0 => -157.831356 1 => 21.2910193 ] +"Latitude": 21.2910193 +"Longitude": -157.831356 +"YearBuilt": 1970 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "YuFan Yang" +"ListOfficeName": "New Homes Realty LLC" +"ListAgentMlsId": "43762" +"ListOfficeMlsId": "NHRE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Rarely available 2-bedroom, 2-bathroom condo with 1 covered parking stall in the highly desirable Moiliili. Conveniently located just minutes from world-famous Waikiki and the Ala Moana Shopping Center, this home offers the perfect blend of comfort and convenience.This thoughtfully designed unit features a unique layout with a separate entrance to the primary bedroom and en-suite bath — ideal for guests, or flexible living arrangements. Enjoy being close to shopping, dining, UH Manoa, bus lines, and everyday essentials. Whether you’re a first-time homebuyer, investor, or looking for a centrally located island home, this rarely available opportunity in Moiliili is not to be missed!" +"AssociationFeeIncludes": "Gas,Hot Water,Sewer,Water" +"AttributionContact": "(808) 741-0679" +"BathroomsFull": 2 +"BuildingName": "2018 Fern" +"CommunityFeatures": "Laundry Facilities" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-02-24T22:17:02.320501+00:00" +"DaysOnMarketReplicationDate": "2026-02-24" +"DaysOnMarketReplicationIncreasingYN": true +"EntryLevel": 3 +"Flooring": "Vinyl" +"HumanModifiedYN": true +"Inclusions": "Range/Oven, Refrigerator" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 741-0679" +"ListAgentEmail": "jerryyang808@gmail.com" +"ListAgentKey": "10778406" +"ListAgentKeyNumeric": "10778406" +"ListAgentOfficePhone": "(808) 741-0679" +"ListAgentPreferredPhone": "(808) 741-0679" +"ListAgentStateLicense": "RB-22511" +"ListOfficeEmail": "jerryyang808@gmail.com" +"ListOfficeKey": "2589393" +"ListOfficeKeyNumeric": "2589393" +"ListOfficePhone": "(808) 741-0679" +"ListingContractDate": "2026-02-24" +"ListingKeyNumeric": 1153411644 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 702.02 +"MajorChangeTimestamp": "2026-02-24T12:14:38Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-02-24" +"OriginalListPrice": 347000.0 +"OriginatingSystemKey": "19292204" +"ParcelNumber": "1-2-7-002-052-0009" +"ParkingFeatures": "Assigned,Covered,One Space" +"ParkingTotal": "1.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-02-24T08:17:00Z" +"PhotosCount": 2 +"PostalCity": "Honolulu" +"PropertyCondition": "Average Condition" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1153411644" +"StateOrProvince": "HI" +"StreetName": "Fern" +"StreetNumber": "2018" +"StreetNumberNumeric": "2018" +"StreetSuffix": "Street" +"SubdivisionName": "MOILIILI" +"TaxAnnualAmount": "1096.2" +"TaxAssessedValue": 433200 +"UnitNumber": "304" +"View": "None" +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1153411644"\n } """ +"AssociationFeeTotal": 702.0 +"TaxAssessedValueLand": "118100" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "315100" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1153411644')" +"provider_name": "HICMLS" +"short_address": "Honolulu, Hawaii 96826, USA" +"RecordSignature": 682586059 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-7-002-052-0009" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "12522166" +"OriginatingSystemListAgentMemberKey": "3483795" +"Media": array:2 [ 0 => array:57 [ …57] 1 => array:57 [ …57] ] +"ID": "79134" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6453 +post_id: "52495" +post_author: 1 +"ListingKey": "1108490703" +"ListingId": "202506642" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-24T21:32:05Z" +"RFModificationTimestamp": "2026-02-24T21:36:06Z" +"ListPrice": 1399000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 8386.0 +"LivingArea": 1792.0 +"BuildingAreaTotal": 2129.0 +"City": "Haleiwa" +"PostalCode": "96712" +"UnparsedAddress": "66-490 Kilioe Place, Haleiwa, Hawaii 96712" +"Coordinates": array:2 [ 0 => -158.1036502 1 => 21.5857737 ] +"Latitude": 21.5857737 +"Longitude": -158.1036502 +"YearBuilt": 1974 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sandy Xay" +"ListOfficeName": "Alii Hawaii Realty Inc" +"ListAgentMlsId": "25943" +"ListOfficeMlsId": "AHRC" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "SELLER MOTIVATED!!!! THE GREAT OPPORTUNITY TO OWN IN WORLD-FAMOUS HALEIWA TOWN—Right across Kamehameha Highway, NORTH SHORE MARKET PLACE, restaurants, shops & etc. Large lot, approximately 8,386 sqft., with additional room for expansion. It can be TWO POINTS of ENTRY. Newly painted lanai, floor, & etc., proximity to popular Matsumoto Shaved Ice and Alii's Beach Park, North Shore beaches, Waihiawa town, Schofield Barracks, etc. Note: Square footage may not match the information in the tax records. (Must see) Sold in As-Is Condition. EZ to show." +"ArchitecturalStyle": "Detached" +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 892-9156" +"BathroomsFull": 2 +"CLIP": 4496309877 +"ConstructionMaterials": "Double Wall,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-04-17T05:31:07.963680+00:00" +"DaysOnMarket": 406 +"DaysOnMarketReplication": 350 +"DaysOnMarketReplicationDate": "2026-02-24" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None,Seller Disclosure" +"ElementarySchool": "Haleiwa" +"Flooring": "Carpet,Ceramic Tile,Vinyl" +"FrontageType": "Other" +"Furnished": "Partially" +"GarageYN": true +"HighSchool": "Waialua" +"HumanModifiedYN": true +"Inclusions": "AC Window Unit,Ceiling Fan,Drapes,Refrigerator" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 892-9156" +"ListAgentEmail": "sandyxay@gmail.com" +"ListAgentKey": "10772531" +"ListAgentKeyNumeric": "10772531" +"ListAgentOfficePhone": "(808) 892-9156" +"ListAgentPreferredPhone": "(808) 892-9156" +"ListAgentStateLicense": "RB-21099" +"ListOfficeEmail": "Sandyxay@gmail.com" +"ListOfficeKey": "5038709" +"ListOfficeKeyNumeric": "5038709" +"ListOfficePhone": "(808) 892-9156" +"ListingContractDate": "2025-03-11" +"ListingKeyNumeric": 1108490703 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Cul-De-Sac,Flag Lot,Interior Lot,Level" +"MLSAreaMajor": "North Shore" +"MajorChangeTimestamp": "2025-12-16T18:36:46Z" +"MiddleOrJuniorSchool": "Waialua" +"MlsStatus": "Active" +"OnMarketDate": "2025-03-11" +"OriginalListPrice": 1475000.0 +"OriginatingSystemKey": "18612069" +"ParcelNumber": "1-6-6-010-019-0000" +"ParkingFeatures": "Driveway,Garage,Three or more Spaces,On Street" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-12-03T23:32:00Z" +"PhotosCount": 24 +"PoolFeatures": "None" +"PostalCity": "Haleiwa" +"PropertyCondition": "Good Condition,Updated/Remodeled" +"RoadFrontageType": "County Road" +"SecurityFeatures": "Key Card Entry" +"Sewer": "Cesspool" +"SourceSystemKey": "1108490703" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Kilioe" +"StreetNumber": "66-490" +"StreetSuffix": "Place" +"SubdivisionName": "HALEIWA" +"TaxAnnualAmount": "3324.0" +"TaxAssessedValue": 1070800 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Electricity Available,High Speed Internet Available,Water Available" +"View": "City, Mountain(s), Other" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltEffective": 2024 +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "FractionalOwnershipYN": "0",\n "CompensationSubjectTo": "",\n "SQFTRoofedOther": "337",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "755000.00",\n "LockBoxModDT": "2025-03-11T01:14:25.677",\n "SellingAgentRemarks": "",\n "TaxAssessedValueImprovements": "315800.00",\n "SQFTLanaiCovered": "176",\n "SQFTGarageCarport": "400",\n "SetBacks": "Of Record",\n "CompensationMethod": "",\n "Easements": "None",\n "LandRecorded": "Regular System",\n "ListingKey": "1108490703",\n "StreetViewParam": "1$21.586108$-158.103751$244.95$13.33$1.00$CAoSLEFGMVFpcE1hZUdfNHJQYVU0aXN3WFl0RFotM1UzbjhnSHdJNHpmdnFyVzBa",\n "SQFTLanaiOpen": "176",\n "CondoPropertyRegimeYN": "0",\n "TaxExcemptionOwnerOccupancy": "100000",\n "ShowingTimeFlagYN": "0"\n } """ +"TaxAssessedValueLand": "755000" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "315800" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1108490703')" +"provider_name": "HICMLS" +"RecordSignature": -2104581594 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-6-6-010-019-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "16688331" +"OriginatingSystemListAgentMemberKey": "3475709" +"Media": array:24 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] 22 => array:57 [ …57] 23 => array:57 [ …57] ] +"ID": "52495" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6346 +post_id: "76649" +post_author: 1 +"ListingKey": "1150551264" +"ListingId": "202600373" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-24T19:55:57Z" +"RFModificationTimestamp": "2026-02-24T19:59:18Z" +"ListPrice": 532000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 379.0 +"BuildingAreaTotal": 425.0 +"City": "Honolulu" +"PostalCode": "96814" +"UnparsedAddress": "987 Queen Street 510, Honolulu, Hawaii 96814" +"Coordinates": array:2 [ 0 => -157.8534649 1 => 21.2964369 ] +"Latitude": 21.2964369 +"Longitude": -157.8534649 +"YearBuilt": 2019 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jennifer C Freas" +"ListOfficeName": "eXp Realty" +"ListAgentMlsId": "46532" +"ListOfficeMlsId": "EXPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Be in the desirable and thriving Ward Village community with this well-priced, well-maintained studio in Aalii. The parking stall is on the same level as the unit, so no need to wait for an elevator. A 5th floor storage room is also included with the sale. Upgrades include new Washer/Dryer, USB outlets, and a home smart system. Digital blinds and fresh drapes for the lanai doors give multiple privacy options. This unit has high 9ft ceilings, which make the space feel more open. Aalii is known for its plethora of amenities and is next to Whole Foods in Kakaako. The WV community benefits from Assocation security patrol, and has wide sidewalks. Enjoy premium restaurant and retail offerings, all within a conveniently accessible area." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFee": "35.0" +"AssociationFeeIncludes": "Common Areas,Sewer,Water" +"AttributionContact": "(808) 725-2794" +"BathroomsFull": 1 +"BuildingName": "Aalii" +"CommunityFeatures": "Barbecue,Clubhouse,Conference/Meeting Room,Deck/Porch,Dog Park,Fitness,Playground,Patio,Pool,Recreation Area,Storage Facilities,Trash Chute" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-01-15T20:01:00.837013+00:00" +"DaysOnMarket": 74 +"DaysOnMarketReplication": 18 +"DaysOnMarketReplicationDate": "2026-02-24" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 5 +"Flooring": "Ceramic Tile,Vinyl" +"FrontageType": "Other" +"Furnished": "Partially" +"GarageYN": true +"HumanModifiedYN": true +"Inclusions": "AC Split,Auto Garage Door Opener,Blinds,Cable TV,Dishwasher,Disposal,Drapes,Dryer,Microwave Hood,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"InteriorFeatures": "Full Bath on Main Level,Storage" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 284-0808" +"ListAgentEmail": "jenfreas@gmail.com" +"ListAgentKey": "10779546" +"ListAgentKeyNumeric": "10779546" +"ListAgentOfficePhone": "(808) 725-2794" +"ListAgentPreferredPhone": "(808) 284-0808" +"ListAgentStateLicense": "RS-78856" +"ListOfficeEmail": "hi.broker@exprealty.net" +"ListOfficeKey": "2589160" +"ListOfficeKeyNumeric": "2589160" +"ListOfficePhone": "(808) 725-2794" +"ListingContractDate": "2026-01-15" +"ListingKeyNumeric": 1150551264 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 574.31 +"MajorChangeTimestamp": "2026-02-24T09:55:20Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-01-15" +"OriginalListPrice": 532000.0 +"OriginatingSystemKey": "19199500" +"ParcelNumber": "1-2-3-002-107-0086" +"ParkingFeatures": "Assigned,Covered,Garage,Guest,One Space,Secured" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-01-20T07:21:00Z" +"PhotosCount": 19 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Key Card Entry,Fire Sprinkler System,Security Guard" +"SourceSystemKey": "1150551264" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Queen" +"StreetNumber": "987" +"StreetNumberNumeric": "987" +"StreetSuffix": "Street" +"SubdivisionName": "KAKAAKO" +"TaxAnnualAmount": "2154.0" +"TaxAssessedValue": 549600 +"UnitNumber": "510" +"View": "None" +"ZoningDescription": "Kak – Kakaako Community Development Project" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1150551264"\n } """ +"AssociationFeeTotal": 609.0 +"TaxAssessedValueLand": "18500" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "531100" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1150551264')" +"provider_name": "HICMLS" +"RecordSignature": -997367329 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-002-107-0086" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10013908" +"OriginatingSystemListAgentMemberKey": "10334398" +"Media": array:19 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] ] +"ID": "76649" } ] +success: true +page_size: 9 +page_count: 417 +count: 3753 +after_key: "" } "RF Response Time" => "0.18 seconds" ] ]
