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=2925&$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 {#6320 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6335 +post_id: "78066" +post_author: 1 +"ListingKey": "1152374121" +"ListingId": "202602272" +"PropertyType": "Business Opportunity" +"PropertySubType": "Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-04T21:18:15Z" +"RFModificationTimestamp": "2026-02-04T21:33:25Z" +"ListPrice": 30000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 554.0 +"City": "Honolulu" +"PostalCode": "96817" +"UnparsedAddress": "1120 Maunakea Streets, Honolulu, Hawaii 96817" +"Coordinates": array:2 [ 0 => -157.855676 1 => 21.304547 ] +"Latitude": 21.304547 +"Longitude": -157.855676 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Trang Nadeau" +"ListOfficeName": "Five Star Realty, Inc." +"ListAgentMlsId": "54299" +"ListOfficeMlsId": "FIVE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "RETAIL STORE! Prime retail opportunity in the heart of Chinatown at the highly sought-after Maunakea Marketplace. This 554 sq. ft. retail store features excellent street frontage on Maunakea Street, located immediately next to the main entrance of Maunakea Marketplace, ensuring heavy foot traffic and strong visibility. Currently operating as a seafood and fresh fruit store, the space is well suited for similar use or other retail concepts. Exceptional location in one of Chinatown’s busiest commercial corridors." +"AttributionContact": "(808) 382-6871" +"BusinessName": "CHAU'S SEAFOOD" +"BusinessType": "Retail" +"Cooling": "1 Unit,Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2026-02-04T21:16:06.765016+00:00" +"DaysOnMarketReplicationDate": "2026-02-04" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,See Remarks" +"EntryLevel": 1 +"ExistingLeaseType": "See Remarks" +"HoursDaysOfOperation": "Open 8+ Hours/Day" +"HumanModifiedYN": true +"Inclusions": "Equipment/Fixtures, Lease, Name/Trademarks" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LeaseAmount": "5000.0" +"LeaseExpiration": "2026-03-31" +"Levels": "One" +"ListAgentDirectPhone": "(808) 850-3866" +"ListAgentEmail": "trang@realestatewithtrang.com" +"ListAgentKey": "25180809" +"ListAgentKeyNumeric": "25180809" +"ListAgentOfficePhone": "(808) 382-6871" +"ListAgentPreferredPhone": "(808) 850-3866" +"ListAgentStateLicense": "RS-87493" +"ListOfficeEmail": "vincent@fivestarrealty.org" +"ListOfficeKey": "2588170" +"ListOfficeKeyNumeric": "2588170" +"ListOfficePhone": "(808) 382-6871" +"ListingContractDate": "2026-02-04" +"ListingKeyNumeric": 1152374121 +"ListingService": "Full Service" +"LotFeatures": "City Lot" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2026-02-04T11:12:58Z" +"MlsStatus": "Active" +"NetOperatingIncome": 1.0 +"OnMarketDate": "2026-02-04" +"OperatingExpense": "1.0" +"OriginalListPrice": 30000.0 +"OriginatingSystemKey": "19249463" +"ParcelNumber": "1-1-7-003-096-0000" +"ParkingFeatures": "None" +"PhotosChangeTimestamp": "2026-02-04T21:28:01Z" +"PhotosCount": 13 +"PostalCity": "Honolulu" +"RoadFrontageType": "City Street" +"Sewer": "Connected" +"SourceSystemKey": "1152374121" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Maunakea" +"StreetNumber": "1120" +"StreetNumberNumeric": "1120" +"StreetSuffix": "Streets" +"SubdivisionName": "CHINATOWN" +"TaxAnnualAmount": "12.0" +"TaxAssessedValue": 1 +"TenantPays": "All Utilities,Insurance" +"TotalActualRent": 1.0 +"Utilities": "Sewer Connected" +"YearEstablished": 2021 +"ZoningDescription": "33 - BMX-3 Community Business M" +"ListAOR": "HI Central" +"LandTenure": "Lease Hold" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1152374121"\n } """ +"TaxAssessedValueLand": "1" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "1" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1152374121')" +"provider_name": "HICMLS" +"RecordSignature": 1914738690 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-7-003-096-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486552" +"OriginatingSystemListAgentMemberKey": "18328197" +"Media": array:13 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004845915814" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152374121/fcbf82d1b1e552122c5d413d140656f7.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 672480 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152374121/thumbnail-fcbf82d1b1e552122c5d413d140656f7.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "25180809" "PropertyType" => "Business Opportunity" "ResourceName" => "Property" "ListOfficeKey" => "2588170" "MediaCategory" => null "MediaObjectID" => "IMG_0789 2.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "FIVE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004845915814 "PropertySubType" => "Business" "RecordSignature" => -1286367185 "PreferredPhotoYN" => null "ResourceRecordID" => "202602272" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1152374121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-04T21:11:28.680-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152374121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19249753" "PropertySubTypeAdditional" => "Business" "MediaModificationTimestamp" => "2026-02-04T21:11:28.680-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19249463" ] 1 => array:57 [ "Order" => 2 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004845933094" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152374121/11c6988ce1beb3d7681c1a814dd7c1c5.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 544385 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152374121/thumbnail-11c6988ce1beb3d7681c1a814dd7c1c5.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "25180809" "PropertyType" => "Business Opportunity" "ResourceName" => "Property" "ListOfficeKey" => "2588170" "MediaCategory" => null "MediaObjectID" => "IMG_0802 2.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "FIVE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004845933094 "PropertySubType" => "Business" "RecordSignature" => -1771505227 "PreferredPhotoYN" => null "ResourceRecordID" => "202602272" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1152374121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-04T21:16:59.713-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152374121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19249834" "PropertySubTypeAdditional" => "Business" "MediaModificationTimestamp" => "2026-02-04T21:16:59.713-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19249463" ] 2 => array:57 [ "Order" => 3 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004845915817" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152374121/69630d6ae874a449121e4454b75957d0.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 602253 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152374121/thumbnail-69630d6ae874a449121e4454b75957d0.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "25180809" "PropertyType" => "Business Opportunity" "ResourceName" => "Property" "ListOfficeKey" => "2588170" "MediaCategory" => null "MediaObjectID" => "IMG_0767 2.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "FIVE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004845915817 "PropertySubType" => "Business" "RecordSignature" => 1336462649 "PreferredPhotoYN" => null "ResourceRecordID" => "202602272" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1152374121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152374121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19249756" "PropertySubTypeAdditional" => "Business" "MediaModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19249463" ] 3 => array:57 [ "Order" => 4 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004845915818" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152374121/1190185712721909ab0b0608a6ead5e2.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 510032 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152374121/thumbnail-1190185712721909ab0b0608a6ead5e2.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "25180809" "PropertyType" => "Business Opportunity" "ResourceName" => "Property" "ListOfficeKey" => "2588170" "MediaCategory" => null "MediaObjectID" => "IMG_0768 2.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "FIVE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004845915818 "PropertySubType" => "Business" "RecordSignature" => 1336462649 "PreferredPhotoYN" => null "ResourceRecordID" => "202602272" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1152374121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152374121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19249757" "PropertySubTypeAdditional" => "Business" "MediaModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19249463" ] 4 => array:57 [ "Order" => 5 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004845915819" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152374121/695075885fb346cc586443f92ccea4f4.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 602504 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152374121/thumbnail-695075885fb346cc586443f92ccea4f4.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "25180809" "PropertyType" => "Business Opportunity" "ResourceName" => "Property" "ListOfficeKey" => "2588170" "MediaCategory" => null "MediaObjectID" => "IMG_0778 2.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "FIVE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004845915819 "PropertySubType" => "Business" "RecordSignature" => 1336462649 "PreferredPhotoYN" => null "ResourceRecordID" => "202602272" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1152374121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152374121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19249758" "PropertySubTypeAdditional" => "Business" "MediaModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19249463" ] 5 => array:57 [ "Order" => 6 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004845915820" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152374121/4f6b91fd0d5203d4ecc57d8d2ee8d07e.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 631405 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152374121/thumbnail-4f6b91fd0d5203d4ecc57d8d2ee8d07e.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "25180809" "PropertyType" => "Business Opportunity" "ResourceName" => "Property" "ListOfficeKey" => "2588170" "MediaCategory" => null "MediaObjectID" => "IMG_0779 2.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "FIVE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004845915820 "PropertySubType" => "Business" "RecordSignature" => 1336462649 "PreferredPhotoYN" => null "ResourceRecordID" => "202602272" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1152374121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152374121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19249759" "PropertySubTypeAdditional" => "Business" "MediaModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19249463" ] 6 => array:57 [ "Order" => 7 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004845915821" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152374121/78142c367152d005e3855c01906f0a7f.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 631767 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152374121/thumbnail-78142c367152d005e3855c01906f0a7f.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "25180809" "PropertyType" => "Business Opportunity" "ResourceName" => "Property" "ListOfficeKey" => "2588170" "MediaCategory" => null "MediaObjectID" => "IMG_0780 2.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "FIVE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004845915821 "PropertySubType" => "Business" "RecordSignature" => 1336462649 "PreferredPhotoYN" => null "ResourceRecordID" => "202602272" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1152374121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152374121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19249760" "PropertySubTypeAdditional" => "Business" "MediaModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19249463" ] 7 => array:57 [ "Order" => 8 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004845915822" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152374121/fdb0e8bf9443f781c6e49f39b4fda4b6.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 582734 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152374121/thumbnail-fdb0e8bf9443f781c6e49f39b4fda4b6.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "25180809" "PropertyType" => "Business Opportunity" "ResourceName" => "Property" "ListOfficeKey" => "2588170" "MediaCategory" => null "MediaObjectID" => "IMG_0765 2.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "FIVE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004845915822 "PropertySubType" => "Business" "RecordSignature" => 1336462649 "PreferredPhotoYN" => null "ResourceRecordID" => "202602272" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1152374121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152374121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19249761" "PropertySubTypeAdditional" => "Business" "MediaModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19249463" ] 8 => array:57 [ "Order" => 9 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004845915823" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152374121/4305906b8c4b5b5c9f1f9542689c379a.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 642361 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152374121/thumbnail-4305906b8c4b5b5c9f1f9542689c379a.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "25180809" "PropertyType" => "Business Opportunity" "ResourceName" => "Property" "ListOfficeKey" => "2588170" "MediaCategory" => null "MediaObjectID" => "IMG_0782 2.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "FIVE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004845915823 "PropertySubType" => "Business" "RecordSignature" => 1336462649 "PreferredPhotoYN" => null "ResourceRecordID" => "202602272" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1152374121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152374121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19249762" "PropertySubTypeAdditional" => "Business" "MediaModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19249463" ] 9 => array:57 [ "Order" => 10 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004845915824" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152374121/2bb7e08e5a832be6aa9e312248c677f5.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 647934 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152374121/thumbnail-2bb7e08e5a832be6aa9e312248c677f5.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "25180809" "PropertyType" => "Business Opportunity" "ResourceName" => "Property" "ListOfficeKey" => "2588170" "MediaCategory" => null "MediaObjectID" => "IMG_0783 2.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "FIVE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004845915824 "PropertySubType" => "Business" "RecordSignature" => 1336462649 "PreferredPhotoYN" => null "ResourceRecordID" => "202602272" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1152374121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152374121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19249763" "PropertySubTypeAdditional" => "Business" "MediaModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19249463" ] 10 => array:57 [ "Order" => 11 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004845915825" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152374121/d6f329d16a50116ea8a0e45bac52b5c0.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 648689 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152374121/thumbnail-d6f329d16a50116ea8a0e45bac52b5c0.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "25180809" "PropertyType" => "Business Opportunity" "ResourceName" => "Property" "ListOfficeKey" => "2588170" "MediaCategory" => null "MediaObjectID" => "IMG_0785 2.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "FIVE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004845915825 "PropertySubType" => "Business" "RecordSignature" => 1336462649 "PreferredPhotoYN" => null "ResourceRecordID" => "202602272" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1152374121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152374121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19249764" "PropertySubTypeAdditional" => "Business" "MediaModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19249463" ] 11 => array:57 [ "Order" => 12 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004845915826" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152374121/140f8baea70948f55321715443b0d356.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 723332 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152374121/thumbnail-140f8baea70948f55321715443b0d356.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "25180809" "PropertyType" => "Business Opportunity" "ResourceName" => "Property" "ListOfficeKey" => "2588170" "MediaCategory" => null "MediaObjectID" => "IMG_0797 2.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "FIVE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004845915826 "PropertySubType" => "Business" "RecordSignature" => 1336462649 "PreferredPhotoYN" => null "ResourceRecordID" => "202602272" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1152374121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152374121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19249765" "PropertySubTypeAdditional" => "Business" "MediaModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19249463" ] 12 => array:57 [ "Order" => 13 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004845915827" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152374121/05da9b7cfacd1220158cee2dcef53ba8.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 710213 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152374121/thumbnail-05da9b7cfacd1220158cee2dcef53ba8.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "25180809" "PropertyType" => "Business Opportunity" "ResourceName" => "Property" "ListOfficeKey" => "2588170" "MediaCategory" => null "MediaObjectID" => "IMG_0788 2.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "FIVE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004845915827 "PropertySubType" => "Business" "RecordSignature" => 1336462649 "PreferredPhotoYN" => null "ResourceRecordID" => "202602272" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1152374121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152374121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19249766" "PropertySubTypeAdditional" => "Business" "MediaModificationTimestamp" => "2026-02-04T21:27:49.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19249463" ] ] +"ID": "78066" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6333 +post_id: "77298" +post_author: 1 +"ListingKey": "1151649573" +"ListingId": "202601604" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-04T21:25:39Z" +"RFModificationTimestamp": "2026-02-04T21:27:02Z" +"ListPrice": 440000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 321.0 +"BuildingAreaTotal": 363.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "1850 Ala Moana Boulevard 816, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ 0 => -157.8365927 1 => 21.2850066 ] +"Latitude": 21.2850066 +"Longitude": -157.8365927 +"YearBuilt": 1970 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jahsiah Sai Aldana" +"ListOfficeName": "BHGRE Refined" +"ListAgentMlsId": "44712" +"ListOfficeMlsId": "RREH" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Unit 816 at the Palms at Waikiki offers a rare opportunity to own a legal, turnkey short-term rental with strong income history and deeded parking. One of the larger studio layouts in the building, this fully renovated unit is ready for immediate use and can be self-managed or placed into the hotel rental pool. The southeast-facing orientation captures views of Diamond Head, ocean, city Skyline, which consistently appeals to guests and supports strong nightly rates. The unit has a proven performance record, generating approximately $63,000+ in annual gross income with a 4.96-star rating, over 80 reviews, and roughly 90% occupancy. Renovated in 2020 as part of the hotel refresh program, the unit features custom upgrades that set it apart from standard inventory. Owners and guests enjoy access to quaint hotel amenities including a pool, BBQ area, fitness center, laundry facilities, front desk services, bell service, and 24-hour security. Located at the gateway to Waikiki and just blocks from Kahanamoku Beach, shopping, dining, and world-class resorts, this property offers flexibility for continued rental income, personal use, or future resale of a high-demand condotel with parking." +"AssociationFeeIncludes": "Common Areas,Cable TV,Electricity,HVAC,Hot Water,Internet,Sewer,Water" +"AttributionContact": "(808) 260-9888" +"BathroomsFull": 1 +"BuildingName": "Palms At Waikiki" +"CoListAgentDirectPhone": "(808) 219-1989" +"CoListAgentEmail": "kamalani@refinedhawaii.com" +"CoListAgentFullName": "Kamalani Sullivan" +"CoListAgentKey": "21130573" +"CoListAgentKeyNumeric": "21130573" +"CoListAgentMlsId": "52352" +"CoListAgentPreferredPhone": "(808) 219-1989" +"CoListOfficeEmail": "admin@refinedhawaii.com" +"CoListOfficeKey": "4095114" +"CoListOfficeKeyNumeric": "4095114" +"CoListOfficeMlsId": "RREH" +"CoListOfficeName": "BHGRE Refined" +"CoListOfficePhone": "(808) 260-9888" +"CommunityFeatures": "Barbecue,Community Pool,Deck/Porch,Fitness,Patio,Condo Hotel Community" +"ConstructionMaterials": "Concrete" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2026-01-26T23:14:44.008948+00:00" +"DaysOnMarket": 77 +"DaysOnMarketReplication": 9 +"DaysOnMarketReplicationDate": "2026-02-04" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 8 +"Flooring": "Carpet,Ceramic Tile" +"Furnished": "Partially" +"HumanModifiedYN": true +"Inclusions": "AC Central,Blinds,Kitchenware,Linens,Refrigerator,Smoke Detector" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level,Handicap Access" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 561-0391" +"ListAgentEmail": "sai@refinedhawaii.com" +"ListAgentKey": "10774031" +"ListAgentKeyNumeric": "10774031" +"ListAgentOfficePhone": "(808) 260-9888" +"ListAgentPreferredPhone": "(808) 561-0391" +"ListAgentStateLicense": "RB-23598" +"ListOfficeEmail": "admin@refinedhawaii.com" +"ListOfficeKey": "4095114" +"ListOfficeKeyNumeric": "4095114" +"ListOfficePhone": "(808) 260-9888" +"ListingContractDate": "2026-01-26" +"ListingKeyNumeric": 1151649573 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 798.0 +"MajorChangeTimestamp": "2026-01-26T13:09:01Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-01-26" +"OriginalListPrice": 440000.0 +"OriginatingSystemKey": "19232097" +"ParcelNumber": "1-2-6-012-003-0170" +"ParkingFeatures": "Assigned,Covered,One Space,Secured" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-02-04T21:26:02Z" +"PhotosCount": 25 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition" +"SecurityFeatures": "Fire Sprinkler System" +"SourceSystemKey": "1151649573" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Ala Moana" +"StreetNumber": "1850" +"StreetNumberNumeric": "1850" +"StreetSuffix": "Boulevard" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "4764.0" +"TaxAssessedValue": 415300 +"UnitNumber": "816" +"View": "City, Mountain(s), Ocean" +"ViewYN": true +"YearBuiltEffective": 2020 +"ZoningDescription": "AM - Apartment Mixed Use" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1151649573"\n } """ +"AssociationFeeTotal": 798.0 +"TaxAssessedValueLand": "66900" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "348400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1151649573')" +"provider_name": "HICMLS" +"RecordSignature": 1700463492 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-012-003-0170" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15774025" +"OriginatingSystemCoListOfficeKey": "15774025" +"OriginatingSystemListAgentMemberKey": "9244075" +"OriginatingSystemCoListAgentMemberKey": "16653812" +"Media": array:25 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004825264425" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1151649573/5640804d6814293bcaa92ca3a1f64d2a.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 436492 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1151649573/thumbnail-5640804d6814293bcaa92ca3a1f64d2a.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10774031" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "4095114" "MediaCategory" => null "MediaObjectID" => "DSC07004.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "RREH" "LongDescription" => "Enhanced" "MediaAlteration" => null "MediaKeyNumeric" => 2004825264425 "PropertySubType" => "Condominium" "RecordSignature" => 660391375 "PreferredPhotoYN" => null "ResourceRecordID" => "202601604" "ShortDescription" => "Enhanced" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1151649573" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-01-26T23:50:44.583-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1151649573 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19232131" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-01-26T23:50:44.583-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19232097" ] 1 => array:57 [ "Order" => 2 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004825262918" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1151649573/75d7bc658967d2b1fa77e2be3e0b9c3e.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 397655 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1151649573/thumbnail-75d7bc658967d2b1fa77e2be3e0b9c3e.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10774031" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "4095114" "MediaCategory" => null "MediaObjectID" => "DSC06983.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "RREH" "LongDescription" => "Enhanced" "MediaAlteration" => null "MediaKeyNumeric" => 2004825262918 "PropertySubType" => "Condominium" "RecordSignature" => 987160607 "PreferredPhotoYN" => null "ResourceRecordID" => "202601604" "ShortDescription" => "Enhanced" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1151649573" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-01-26T22:49:21.010-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1151649573 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19232126" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-01-26T22:49:21.010-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19232097" ] 2 => array:57 [ "Order" => 3 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004825262916" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1151649573/3fee5d5740b0846f6e3cfd734b5cf319.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 228592 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1151649573/thumbnail-3fee5d5740b0846f6e3cfd734b5cf319.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10774031" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "4095114" "MediaCategory" => null "MediaObjectID" => "DSC06977 (1).jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "RREH" "LongDescription" => "Enhanced" "MediaAlteration" => null "MediaKeyNumeric" => 2004825262916 "PropertySubType" => "Condominium" "RecordSignature" => 660391375 "PreferredPhotoYN" => null "ResourceRecordID" => "202601604" "ShortDescription" => "Enhanced" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1151649573" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-01-26T23:50:44.583-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1151649573 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19232124" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-01-26T23:50:44.583-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19232097" ] 3 => array:57 [ "Order" => 4 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004825262904" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1151649573/db8bf7e2fa4b05c63bfcc9bf51d7845d.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 317754 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1151649573/thumbnail-db8bf7e2fa4b05c63bfcc9bf51d7845d.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10774031" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "4095114" "MediaCategory" => null "MediaObjectID" => "DSC06953.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "RREH" "LongDescription" => "Enhanced" "MediaAlteration" => null "MediaKeyNumeric" => 2004825262904 "PropertySubType" => "Condominium" "RecordSignature" => 660391375 "PreferredPhotoYN" => null "ResourceRecordID" => "202601604" "ShortDescription" => "Enhanced" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1151649573" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-01-26T23:50:44.583-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1151649573 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19232115" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-01-26T23:50:44.583-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19232097" ] 4 => array:57 [ "Order" => 5 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004825262899" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1151649573/198cd0301eeb6d2bb2064296a3810fd0.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 323731 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1151649573/thumbnail-198cd0301eeb6d2bb2064296a3810fd0.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10774031" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "4095114" "MediaCategory" => null "MediaObjectID" => "DSC06931.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "RREH" "LongDescription" => "Enhanced" "MediaAlteration" => null "MediaKeyNumeric" => 2004825262899 "PropertySubType" => "Condominium" "RecordSignature" => 660391375 "PreferredPhotoYN" => null "ResourceRecordID" => "202601604" "ShortDescription" => "Enhanced" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1151649573" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-01-26T23:50:44.583-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1151649573 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19232110" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-01-26T23:50:44.583-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19232097" ] 5 => array:57 [ "Order" => 6 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004825262900" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1151649573/0fecb08bad75e221a65824afd3354df4.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 313958 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1151649573/thumbnail-0fecb08bad75e221a65824afd3354df4.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10774031" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "4095114" "MediaCategory" => null "MediaObjectID" => "DSC06934.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "RREH" "LongDescription" => "Enhanced" "MediaAlteration" => null "MediaKeyNumeric" => 2004825262900 "PropertySubType" => "Condominium" "RecordSignature" => 660391375 "PreferredPhotoYN" => null "ResourceRecordID" => "202601604" "ShortDescription" => "Enhanced" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1151649573" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-01-26T23:50:44.583-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1151649573 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19232111" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-01-26T23:50:44.583-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19232097" ] 6 => array:57 [ "Order" => 7 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004825262902" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1151649573/ea5380c99cb934b0bb757991b0d228c2.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 367977 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1151649573/thumbnail-ea5380c99cb934b0bb757991b0d228c2.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10774031" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "4095114" "MediaCategory" => null "MediaObjectID" => "DSC06944.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "RREH" "LongDescription" => "Enhanced" "MediaAlteration" => null "MediaKeyNumeric" => 2004825262902 "PropertySubType" => "Condominium" "RecordSignature" => 660391375 "PreferredPhotoYN" => null "ResourceRecordID" => "202601604" "ShortDescription" => "Enhanced" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1151649573" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-01-26T23:50:44.583-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1151649573 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19232113" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-01-26T23:50:44.583-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19232097" ] 7 => array:57 [ "Order" => 8 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004825262906" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1151649573/2d37ee186ea1870ba9a821d2d63f1940.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 380478 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1151649573/thumbnail-2d37ee186ea1870ba9a821d2d63f1940.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10774031" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "4095114" "MediaCategory" => null "MediaObjectID" => "DSC06956.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "RREH" "LongDescription" => "Enhanced" "MediaAlteration" => null "MediaKeyNumeric" => 2004825262906 "PropertySubType" => "Condominium" "RecordSignature" => 660391375 "PreferredPhotoYN" => null "ResourceRecordID" => "202601604" "ShortDescription" => "Enhanced" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1151649573" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-01-26T23:50:44.583-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1151649573 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19232117" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-01-26T23:50:44.583-00:00" "SourceSystemResourceRecordKey" => null …3 ] 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] 24 => array:57 [ …57] ] +"ID": "77298" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6336 +post_id: "62275" +post_author: 1 +"ListingKey": "1146194947" +"ListingId": "202525356" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-04T21:17:08Z" +"RFModificationTimestamp": "2026-02-04T21:21:51Z" +"ListPrice": 85350.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 165.0 +"BuildingAreaTotal": 165.0 +"City": "Honolulu" +"PostalCode": "96814" +"UnparsedAddress": "1001 Queen Street S3-042, Honolulu, Hawaii 96814" +"Coordinates": array:2 [ 0 => -157.855676 1 => 21.304547 ] +"Latitude": 21.304547 +"Longitude": -157.855676 +"YearBuilt": 2018 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ryan Tooley" +"ListOfficeName": "Infinite Ocean LLC" +"ListAgentMlsId": "53184" +"ListOfficeMlsId": "IOHI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Storage room S5-16 at Ae'o for sale. 165 sq ft. (24' x 10' at widest). No maintenance fees on storage rooms and they rent quickly!" +"ArchitecturalStyle": "High Rise" +"AssociationFeeIncludes": "None" +"BuildingName": "Ae'o" +"CoListAgentDirectPhone": "(808) 744-0059" +"CoListAgentEmail": "bob.sage@iohawaii.com" +"CoListAgentFullName": "Bob Sage" +"CoListAgentKey": "26961355" +"CoListAgentKeyNumeric": "26961355" +"CoListAgentMlsId": "54805" +"CoListAgentPreferredPhone": "(808) 971-1138" +"CoListOfficeEmail": "rei.ryan@iohawaii.com" +"CoListOfficeKey": "5246501" +"CoListOfficeKeyNumeric": "5246501" +"CoListOfficeMlsId": "IOHI" +"CoListOfficeName": "Infinite Ocean LLC" +"CoListOfficePhone": "(808) 744-0059" +"CommunityFeatures": "None" +"ConstructionMaterials": "Concrete,Steel Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-11-12T20:25:35.603156+00:00" +"DaysOnMarket": 152 +"DaysOnMarketReplication": 84 +"DaysOnMarketReplicationDate": "2026-02-04" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"EntryLevel": 3 +"Flooring": "Other" +"FrontageType": "Other" +"HumanModifiedYN": true +"Inclusions": "None" +"InteriorFeatures": "Storage" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 744-0059" +"ListAgentEmail": "ryan.tooley@iohawaii.com" +"ListAgentKey": "22220438" +"ListAgentKeyNumeric": "22220438" +"ListAgentOfficePhone": "(808) 744-0059" +"ListAgentPreferredPhone": "(808) 744-0059" +"ListAgentStateLicense": "RS-86261" +"ListOfficeEmail": "rei.ryan@iohawaii.com" +"ListOfficeKey": "5246501" +"ListOfficeKeyNumeric": "5246501" +"ListOfficePhone": "(808) 744-0059" +"ListingContractDate": "2025-11-12" +"ListingKeyNumeric": 1146194947 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2025-11-12T10:37:48Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-11-12" +"OriginalListPrice": 24150.0 +"OriginatingSystemKey": "19115798" +"ParcelNumber": "1-2-3-002-106-0378" +"ParkingFeatures": "None" +"PhotosChangeTimestamp": "2025-11-12T20:41:00Z" +"PhotosCount": 2 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Key Card Entry" +"SourceSystemKey": "1146194947" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Queen" +"StreetNumber": "1001" +"StreetNumberNumeric": "1001" +"StreetSuffix": "Street" +"SubdivisionName": "KAKAAKO" +"UnitNumber": "S5-16" +"View": "None" +"ZoningDescription": "00 - Residential" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1146194947"\n } """ +"AssociationFeeTotal": 0.0 +"TaxAssessedValueLand": "0" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1146194947')" +"provider_name": "HICMLS" +"RecordSignature": -1724203094 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-002-106-0378" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "17662107" +"OriginatingSystemCoListOfficeKey": "17662107" +"OriginatingSystemListAgentMemberKey": "17297524" +"OriginatingSystemCoListAgentMemberKey": "18905812" +"Media": array:2 [ 0 => array:57 [ …57] 1 => array:57 [ …57] ] +"ID": "62275" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6332 +post_id: "78063" +post_author: 1 +"ListingKey": "1152374193" +"ListingId": "202602273" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-04T20:25:37Z" +"RFModificationTimestamp": "2026-02-04T20:31:37Z" +"ListPrice": 455000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 49833.0 +"LivingArea": 308.0 +"BuildingAreaTotal": 424.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "445 Seaside Avenue 3111, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ 0 => -157.8258437 1 => 21.2810357 ] +"Latitude": 21.2810357 +"Longitude": -157.8258437 +"YearBuilt": 1979 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Avery Jin-Wei Chern" +"ListOfficeName": "Central Pacific Properties Inc" +"ListAgentMlsId": "52715" +"ListOfficeMlsId": "CPPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Discover this exceptional Studio condo, completely transformed in 2024 with modern finishes, sleek designer touches, and upgraded throughout. Perched on a prime upper floor, enjoy breathtaking 180-degree vistas from the spacious lanai – sweeping ocean waves, iconic Diamond Head crater, lush Koolau mountains, sparkling Ala Wai Canal, and the serene Ala Wai Golf Course.\r\n Designed and optimized specifically for short-term vacation rentals, this unit is fully legal for STR in Honolulu, offering strong income potential in one of Waikiki's most sought-after locations. Recent renovation includes new flooring, updated kitchen with stainless appliances, contemporary bathroom, fresh paint, and smart lighting/AC – turnkey ready for immediate hosting or personal use.\r\n Prime Honolulu location: steps to world-class beaches, dining, shopping, and entertainment. Island colony offers 24/7 front desk for easy management of vacation rentals.\r\n \r\n Parking can be rented daily from Elite parking, or for long term, you can get on the waitlist to get a long term parking """ +"ArchitecturalStyle": "High Rise" +"AssociationFeeIncludes": "Common Areas,Cable TV,Hot Water,Internet,Sewer,Water" +"AssociationName": "AOAO Island Colony" +"AttributionContact": "(808) 521-3777" +"BathroomsFull": 1 +"BuildingName": "Island Colony" +"CommunityFeatures": "Barbecue,Conference/Meeting Room,Fitness,Laundry Facilities,Pool,Trash Chute,Condo Hotel Community" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-02-04T20:31:18.960488+00:00" +"DaysOnMarketReplicationDate": "2026-02-04" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"EntryLevel": 31 +"Flooring": "Laminate" +"Furnished": "Furnished" +"HumanModifiedYN": true +"Inclusions": "AC Split,Disposal,Drapes,Microwave,Refrigerator,Smoke Detector" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 721-8098" +"ListAgentEmail": "averychern@gmail.com" +"ListAgentKey": "21361443" +"ListAgentKeyNumeric": "21361443" +"ListAgentOfficePhone": "(808) 521-3777" +"ListAgentPreferredPhone": "(808) 721-8098" +"ListAgentStateLicense": "RS-85633" +"ListOfficeEmail": "joannie.jav@gmail.com" +"ListOfficeKey": "2587912" +"ListOfficeKeyNumeric": "2587912" +"ListOfficePhone": "(808) 521-3777" +"ListingContractDate": "2026-02-04" +"ListingKeyNumeric": 1152374193 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 586.77 +"MajorChangeTimestamp": "2026-02-04T10:25:06Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-02-04" +"OriginalListPrice": 455000.0 +"OriginatingSystemKey": "19249469" +"ParcelNumber": "1-2-6-021-026-0476" +"ParkingFeatures": "None" +"PhotosChangeTimestamp": "2026-02-04T20:17:01Z" +"PhotosCount": 24 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent, Updated/Remodeled" +"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry,Fire Sprinkler System,Security Guard" +"SourceSystemKey": "1152374193" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Seaside" +"StreetNumber": "445" +"StreetNumberNumeric": "445" +"StreetSuffix": "Avenue" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "5388.12" +"TaxAssessedValue": 382700 +"UnitNumber": "3111" +"View": "Canal, City, Mountain(s), Ocean" +"ViewYN": true +"YearBuiltEffective": 2024 +"ZoningDescription": "X2 - Apartment Precinct" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1152374193"\n } """ +"AssociationFeeTotal": 587.0 +"TaxAssessedValueLand": "53800" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "328900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1152374193')" +"provider_name": "HICMLS" +"short_address": "Honolulu, Hawaii 96815, USA" +"RecordSignature": -284465401 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-021-026-0476" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486294" +"OriginatingSystemListAgentMemberKey": "16879571" +"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": "78063" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6334 +post_id: "78257" +post_author: 1 +"ListingKey": "1151940070" +"ListingId": "202602018" +"PropertyType": "For Sale" +"PropertySubType": "Multi Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-04T20:17:42Z" +"RFModificationTimestamp": "2026-02-04T20:19:56Z" +"ListPrice": 3480000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 529690.0 +"LivingArea": 0 +"BuildingAreaTotal": 4039.0 +"City": "Waianae" +"PostalCode": "96792" +"UnparsedAddress": "87-1087 Apuupuu Road, Waianae, Hawaii 96792" +"Coordinates": array:2 [ 0 => -158.1583802 1 => 21.4090243 ] +"Latitude": 21.4090243 +"Longitude": -158.1583802 +"YearBuilt": 1974 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Myron N Kiriu" +"ListOfficeName": "REMAX Hawaii" +"ListAgentMlsId": "17960" +"ListOfficeMlsId": "ADVG" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "RARE OPPORTUNITY! Discover the endless possibilities with this over 12-acre level agricultural-zoned property featuring two well-built single-family homes, perfect for multi-generational living, rental income, farming, or creating your own private estate. The first residence offers 4 bdrms/2 baths with 1,875 sq. ft. of interior living space and a spacious open-concept kitchen—ready for your personal touches. The second home features 3 bdrms/3 baths with 2,164 sq. ft. of tastefully renovated int. living space. Enjoy its bright open floor plan, luxury vinyl plank flooring, and high vaulted ceilings that create an inviting and modern living experience. With AG zoning, you gain added flexibility—grow crops, raise livestock, expand agricultural operations, or explore other permitted uses that offer potential income generation. The expansive acreage provides privacy, open space, and the opportunity to design the lifestyle you’ve always dreamed of. Don’t miss this unique chance to own a truly exceptional property with room to live, grow, and thrive!" +"AttributionContact": "(808) 738-3600" +"ConstructionMaterials": "Brick" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2026-02-04T20:19:43.858965+00:00" +"DaysOnMarketReplicationDate": "2026-02-04" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Maili" +"FoundationDetails": "Slab" +"HighSchool": "Waianae" +"HumanModifiedYN": true +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 738-3633" +"ListAgentEmail": "Myron.Kiriu@remaxhawaii.com" +"ListAgentKey": "10767514" +"ListAgentKeyNumeric": "10767514" +"ListAgentOfficePhone": "(808) 738-3600" +"ListAgentPreferredPhone": "(808) 738-3633" +"ListAgentStateLicense": "RB-17242" +"ListOfficeEmail": "Francis.Van Rafelghem@remaxhawaii.com" +"ListOfficeKey": "2589107" +"ListOfficeKeyNumeric": "2589107" +"ListOfficePhone": "(808) 738-3600" +"ListingContractDate": "2026-02-04" +"ListingKeyNumeric": 1151940070 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Dead End,Level" +"MLSAreaMajor": "Leeward" +"MajorChangeTimestamp": "2026-02-04T10:17:35Z" +"MiddleOrJuniorSchool": "Waianae" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "2" +"OnMarketDate": "2026-02-04" +"OperatingExpenseIncludes": "Other" +"OriginalListPrice": 3480000.0 +"OriginatingSystemKey": "19242123" +"ParcelNumber": "1-8-7-018-004-0000" +"ParkingFeatures": "Covered" +"ParkingTotal": "8.0" +"PhotosChangeTimestamp": "2026-01-31T02:53:01Z" +"PhotosCount": 25 +"PostalCity": "Waianae" +"PropertyCondition": "Average Condition" +"Sewer": "Cesspool" +"SourceSystemKey": "1151940070" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Apuupuu" +"StreetNumber": "87-1087" +"StreetSuffix": "Road" +"StructureType": "Multi Family" +"SubdivisionName": "MAILI" +"TaxAnnualAmount": "4488.72" +"TaxAssessedValue": 788700 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,High Speed Internet Available,Phone Available,Water Available" +"View": "Mountain(s)" +"ViewYN": true +"VirtualTourURLUnbranded": "https://listings.hetproductions.com/sites/bpezgva/unbranded" +"WaterSource": "Public" +"ZoningDescription": "51 - AG-1 Restricted Agricultur" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1151940070"\n } """ +"TaxAssessedValueLand": "485400" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "303300" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1151940070')" +"provider_name": "HICMLS" +"short_address": "Waianae, Hawaii 96792, USA" +"RecordSignature": 942235556 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-8-7-018-004-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "9695164" +"OriginatingSystemListAgentMemberKey": "3473447" +"Media": array:25 [ 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] 24 => array:57 [ …57] ] +"ID": "78257" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6337 +post_id: "78258" +post_author: 1 +"ListingKey": "1151939857" +"ListingId": "202602015" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-04T20:13:46Z" +"RFModificationTimestamp": "2026-02-04T20:20:19Z" +"ListPrice": 3480000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 7.0 +"LotSizeArea": 529690.0 +"LivingArea": 4039.0 +"BuildingAreaTotal": 4039.0 +"City": "Waianae" +"PostalCode": "96792" +"UnparsedAddress": "87-1087 Apuupuu Road, Waianae, Hawaii 96792" +"Coordinates": array:2 [ 0 => -158.1583802 1 => 21.4090243 ] +"Latitude": 21.4090243 +"Longitude": -158.1583802 +"YearBuilt": 1974 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Myron N Kiriu" +"ListOfficeName": "REMAX Hawaii" +"ListAgentMlsId": "17960" +"ListOfficeMlsId": "ADVG" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "RARE OPPORTUNITY! Discover the endless possibilities with this over 12-acre level agricultural-zoned property featuring two well-built single-family homes, perfect for multi-generational living, rental income, farming, or creating your own private estate. The first residence offers 4 bdrms/2 baths with 1,875 sq. ft. of interior living space and a spacious open-concept kitchen—ready for your personal touches. The second home features 3 bdrms/3 baths with 2,164 sq. ft. of tastefully renovated int. living space. Enjoy its bright open floor plan, luxury vinyl plank flooring, and high vaulted ceilings that create an inviting and modern living experience. With AG zoning, you gain added flexibility—grow crops, raise livestock, expand agricultural operations, or explore other permitted uses that offer potential income generation. The expansive acreage provides privacy, open space, and the opportunity to design the lifestyle you’ve always dreamed of. Don’t miss this unique chance to own a truly exceptional property with room to live, grow, and thrive!" +"ArchitecturalStyle": "Detached, Multiplex" +"AttributionContact": "(808) 738-3600" +"BathroomsFull": 5 +"ConstructionMaterials": "Brick" +"CountyOrParish": "Oahu" +"CreationDate": "2026-02-04T20:19:57.573020+00:00" +"DaysOnMarketReplicationDate": "2026-02-04" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Maili" +"Flooring": "Vinyl" +"FoundationDetails": "Slab" +"HighSchool": "Waianae" +"HumanModifiedYN": true +"Inclusions": "AC Split,Cable TV,Ceiling Fan,Dishwasher,Dryer,Range Hood,Range/Oven,Refrigerator,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One, Multi/Split" +"ListAgentDirectPhone": "(808) 738-3633" +"ListAgentEmail": "Myron.Kiriu@remaxhawaii.com" +"ListAgentKey": "10767514" +"ListAgentKeyNumeric": "10767514" +"ListAgentOfficePhone": "(808) 738-3600" +"ListAgentPreferredPhone": "(808) 738-3633" +"ListAgentStateLicense": "RB-17242" +"ListOfficeEmail": "Francis.Van Rafelghem@remaxhawaii.com" +"ListOfficeKey": "2589107" +"ListOfficeKeyNumeric": "2589107" +"ListOfficePhone": "(808) 738-3600" +"ListingContractDate": "2026-02-04" +"ListingKeyNumeric": 1151939857 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Dead End,Level" +"MLSAreaMajor": "Leeward" +"MajorChangeTimestamp": "2026-02-04T10:13:26Z" +"MiddleOrJuniorSchool": "Waianae" +"MlsStatus": "Active" +"OnMarketDate": "2026-02-04" +"OriginalListPrice": 3480000.0 +"OriginatingSystemKey": "19242009" +"ParcelNumber": "1-8-7-018-004-0000" +"ParkingFeatures": "Three or more Spaces" +"ParkingTotal": "8.0" +"PhotosChangeTimestamp": "2026-01-31T02:42:00Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Waianae" +"PropertyCondition": "Average Condition" +"RoadFrontageType": "Private Road" +"SecurityFeatures": "Key Card Entry" +"Sewer": "Cesspool" +"SourceSystemKey": "1151939857" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Apuupuu" +"StreetNumber": "87-1087" +"StreetSuffix": "Road" +"SubdivisionName": "MAILI" +"TaxAnnualAmount": "4488.72" +"TaxAssessedValue": 788700 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,High Speed Internet Available,Water Available" +"View": "Mountain(s)" +"ViewYN": true +"VirtualTourURLUnbranded": "https://listings.hetproductions.com/sites/bpezgva/unbranded" +"WaterSource": "Public" +"ZoningDescription": "51 - AG-1 Restricted Agricultur" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1151939857"\n } """ +"TaxAssessedValueLand": "485400" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "303300" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1151939857')" +"provider_name": "HICMLS" +"short_address": "Waianae, Hawaii 96792, USA" +"RecordSignature": 524363902 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-8-7-018-004-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "9695164" +"OriginatingSystemListAgentMemberKey": "3473447" +"Media": array:25 [ 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] 24 => array:57 [ …57] ] +"ID": "78258" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6434 +post_id: "51091" +post_author: 1 +"ListingKey": "1112002403" +"ListingId": "202510433" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-04T20:12:08Z" +"RFModificationTimestamp": "2026-02-04T20:14:08Z" +"ListPrice": 1590000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1189.0 +"BuildingAreaTotal": 1384.0 +"City": "Honolulu" +"PostalCode": "96814" +"UnparsedAddress": "629 Keeaumoku Street 1601, Honolulu, Hawaii 96814" +"Coordinates": array:2 [ 0 => -157.8419117 1 => 21.2942012 ] +"Latitude": 21.2942012 +"Longitude": -157.8419117 +"YearBuilt": 2021 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kelly Wu" +"ListOfficeName": "Associated Real Estate Advisor" +"ListAgentMlsId": "47304" +"ListOfficeMlsId": "AREA" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Experience elevated island living in this stunning 2-bed, 2-bath corner unit offering sweeping views of the ocean, city, Magic Island, and harbor. As the largest 2-bedroom floor plan in the building, it features floor-to-ceiling windows and split AC throughout. The modern kitchen is equipped with glossy white cabinets, quartz countertops and premium Sub-Zero, Bosch and Wolf appliances. The side-by-side washer and dryer is located just off the kitchen. The primary suite offers ocean views, a walk-in closet and a deep soaking tub. Additional features include two covered side-by-side parking stalls and built-in pet food trays. Enjoy the inviting and convenient amenities: pool, spa, gym, BBQ cabanas, club lounge, theater, guest suites, dog park, EV charging stations, and 24/7 security—all in an unbeatable location near Ala Moana Beach, shopping, and dining! And for added peace of mind, Azure is fully covered with 100% hurricane insurance." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Concierge, Management" +"AssociationFee2": "53.0" +"AssociationFeeIncludes": "Common Areas,None,Sewer,Water" +"AttributionContact": "(808) 445-9199" +"BathroomsFull": 2 +"BuildingName": "Azure Ala Moana" +"CLIP": 1007265942 +"CoListAgentDirectPhone": "(808) 445-9199" +"CoListAgentEmail": "julie@associatedhawaii.com" +"CoListAgentFullName": "Julie H. Thompson" +"CoListAgentKey": "23284584" +"CoListAgentKeyNumeric": "23284584" +"CoListAgentMlsId": "53804" +"CoListAgentPreferredPhone": "(818) 325-7444" +"CoListOfficeEmail": "kelly@associatedhawaii.com" +"CoListOfficeKey": "3167562" +"CoListOfficeKeyNumeric": "3167562" +"CoListOfficeMlsId": "AREA" +"CoListOfficeName": "Associated Real Estate Advisor" +"CoListOfficePhone": "(808) 445-9199" +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Concierge,Conference/Meeting Room,Dog Park,Fitness,Pool,Recreation Area,Trash Chute" +"ConstructionMaterials": "Double Wall,Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2025-04-23T00:55:28.619599+00:00" +"DaysOnMarket": 359 +"DaysOnMarketReplication": 291 +"DaysOnMarketReplicationDate": "2026-02-04" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"EntryLevel": 16 +"Flooring": "Carpet,Ceramic Tile,Hardwood" +"Furnished": "Furnished" +"HumanModifiedYN": true +"Inclusions": "AC Split,Auto Garage Door Opener,Blinds,Convection Oven,Dishwasher,Disposal,Dryer,Microwave Hood,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 228-0511" +"ListAgentEmail": "kellywu@associatedhawaii.com" +"ListAgentKey": "10779870" +"ListAgentKeyNumeric": "10779870" +"ListAgentOfficePhone": "(808) 445-9199" +"ListAgentPreferredPhone": "(808) 228-0511" +"ListAgentStateLicense": "RB-24150" +"ListOfficeEmail": "kelly@associatedhawaii.com" +"ListOfficeKey": "3167562" +"ListOfficeKeyNumeric": "3167562" +"ListOfficePhone": "(808) 445-9199" +"ListingContractDate": "2025-04-19" +"ListingKeyNumeric": 1112002403 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1563.18 +"MajorChangeTimestamp": "2025-11-07T16:49:58Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-04-19" +"OriginalListPrice": 1680000.0 +"OriginatingSystemKey": "18701801" +"ParcelNumber": "1-2-3-021-046-0126" +"ParkingFeatures": "Assigned,Covered,Two Spaces,Secured" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-12-23T07:11:00Z" +"PhotosCount": 25 +"PoolFeatures": "Heated" +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Key Card Entry,Fire Sprinkler System,Security Guard" +"SourceSystemKey": "1112002403" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Keeaumoku" +"StreetNumber": "629" +"StreetNumberNumeric": "629" +"StreetSuffix": "Street" +"SubdivisionName": "HOLIDAY MART" +"TaxAnnualAmount": "10508.04" +"TaxAssessedValue": 1570900 +"UnitNumber": "1601" +"View": "City, Mountain(s), Ocean" +"ViewYN": true +"ZoningDescription": "33 - BMX-3 Community Business M" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "StreetViewParam": "1$21.294033$-157.84163$356.00$13.33$1.00$CAoSLEFGMVFpcE42MTVqZjlYU1JoX2pCZVFiZGM0V3p0TjNfQWJ4VzhnVnVPWC1I",\n "CompensationSubjectTo": "",\n "TaxPaidBySellerYN": "",\n "LockBoxModDT": "2025-04-21T17:03:43.610",\n "CompensationMethod": "",\n "SellingAgentRemarks": "",\n "ListingKey": "1112002403",\n "FractionalOwnershipYN": "0",\n "ManagementCompanyName": "Hawaiian Prop",\n "CondoParkingUnit": "5066, 5067",\n "SQFTLanaiOpen": "195",\n "TaxAssessedValueLand": "48700.00",\n "TaxAssessedValueImprovements": "1486600.00",\n "ManagementCompanyPhone": "(808) 539-9777",\n "OwnerOccupancyPercentage": "65",\n "LandRecorded": "Regular System",\n "ParkingAdditional": "0",\n "TaxExcemptionOwnerOccupancy": "0",\n "ShowingTimeFlagYN": "0"\n } """ +"AssociationFeeTotal": 1616.0 +"TaxAssessedValueLand": "50300" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "1520600" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1112002403')" +"provider_name": "HICMLS" +"RecordSignature": 456384286 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-021-046-0126" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15110879" +"OriginatingSystemCoListOfficeKey": "15110879" +"OriginatingSystemListAgentMemberKey": "10921220" +"OriginatingSystemCoListAgentMemberKey": "17815561" +"Media": array:25 [ 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] 24 => array:57 [ …57] ] +"ID": "51091" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6430 +post_id: "58588" +post_author: 1 +"ListingKey": "1132387668" +"ListingId": "202519592" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-04T08:21:02Z" +"RFModificationTimestamp": "2026-02-04T08:26:32Z" +"ListPrice": 439777.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 118919.0 +"LivingArea": 800.0 +"BuildingAreaTotal": 880.0 +"City": "Aiea" +"PostalCode": "96701" +"UnparsedAddress": "98-630 Moanalua Loop 128, Aiea, Hawaii 96701" +"Coordinates": array:2 [ 0 => -157.9336111 1 => 21.3822222 ] +"Latitude": 21.3822222 +"Longitude": -157.9336111 +"YearBuilt": 1985 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sandra Sagisi Moser" +"ListOfficeName": "Sandra Sagisi HI Realty Serv." +"ListAgentMlsId": "31935" +"ListOfficeMlsId": "SSHR" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Welcome home to Pearl Horizons 1, conveniently located near the Pearl Ridge Shopping Center and great restaurants in Aiea and Pearl City! Experience the best of coastal living at Pearl Horizon! This 2-bedroom, 1-bathroom unit offers a sliver of ocean and mountain views, perfect for relaxing after a long day. Enjoy the ease of ground-floor living with ADA accessibility, making it ideal for everyone. Right in front of your unit, discover one of two dedicated parking spaces, your postbox, and pool, ensuring hassle-free access. The inviting pool, spa, and sauna are complete with a barbecue area, perfect for entertaining friends and family on sunny days. Don't miss your chance to own this exceptional property in a sought-after location. This is a perfect unit to renovate into your dream house. Great bones and functional." +"ArchitecturalStyle": "Low Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,None,Sewer,Water" +"AttributionContact": "(808) 492-8187" +"BathroomsFull": 1 +"BuildingName": "Pearl Horizons 1" +"CLIP": 2410626712 +"CommunityFeatures": "Barbecue,Community Pool,Deck/Porch,Patio,Sauna" +"ConstructionMaterials": "Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-09-18T02:48:39.141538+00:00" +"DaysOnMarket": 208 +"DaysOnMarketReplication": 139 +"DaysOnMarketReplicationDate": "2026-02-03" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "1031 Exchange,Call Agent,Seller Disclosure" +"EntryLevel": 1 +"Fencing": "Fenced, Wall" +"Flooring": "Carpet,Ceramic Tile,Laminate" +"FrontageType": "Other" +"Furnished": "Partially" +"HumanModifiedYN": true +"Inclusions": "Disposal, Dryer, Range/Oven, Refrigerator, Washer" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level,Handicap Access" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More,One" +"ListAgentDirectPhone": "(808) 492-8187" +"ListAgentEmail": "sandrasagisimarketing@gmail.com" +"ListAgentKey": "10777851" +"ListAgentKeyNumeric": "10777851" +"ListAgentOfficePhone": "(808) 492-8187" +"ListAgentPreferredPhone": "(808) 492-8187" +"ListAgentStateLicense": "RB-22891" +"ListOfficeEmail": "Sandra Sagisi Marketing@gmail.com" +"ListOfficeKey": "4523010" +"ListOfficeKeyNumeric": "4523010" +"ListOfficePhone": "(808) 492-8187" +"ListingContractDate": "2025-09-08" +"ListingKeyNumeric": 1132387668 +"ListingService": "Full Service" +"MLSAreaMajor": "Pearl City" +"MaintenanceExpense": 882.0 +"MajorChangeTimestamp": "2025-09-17T16:43:36Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-09-08" +"OpenParkingYN": true +"OriginalListPrice": 439777.0 +"OriginatingSystemKey": "18964482" +"ParcelNumber": "1-9-8-013-025-0057" +"ParkingFeatures": "Assigned,Guest,Two Spaces" +"ParkingTotal": "2.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 13 +"PostalCity": "Aiea" +"PropertyCondition": "Good Condition,Updated/Remodeled" +"SecurityFeatures": "Key Card Entry,Security Guard" +"SourceSystemKey": "1132387668" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Moanalua" +"StreetNumber": "98-630" +"StreetSuffix": "Loop" +"StructureType": "Townhouse" +"SubdivisionName": "PEARLRIDGE" +"TaxAnnualAmount": "1752.0" +"TaxAssessedValue": 499500 +"UnitNumber": "128" +"View": "Mountain(s), Ocean, Sunset" +"ViewYN": true +"YearBuiltEffective": 2020 +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1132387668"\n } """ +"AssociationFeeTotal": 882.0 +"TaxAssessedValueLand": "175100" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "324400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1132387668')" +"provider_name": "HICMLS" +"RecordSignature": -1296096722 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-8-013-025-0057" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "16468554" +"OriginatingSystemListAgentMemberKey": "3479155" +"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": "58588" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6325 +post_id: "78023" +post_author: 1 +"ListingKey": "1152312447" +"ListingId": "202602245" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-04T03:40:14Z" +"RFModificationTimestamp": "2026-02-04T03:42:42Z" +"ListPrice": 328000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 15072.0 +"LivingArea": 1008.0 +"BuildingAreaTotal": 1008.0 +"City": "Pahoa" +"PostalCode": "96778" +"UnparsedAddress": "15-2677 Kumu Street, Pahoa, Hawaii 96778" +"Coordinates": array:2 [ 0 => -154.950072 1 => 19.4967518 ] +"Latitude": 19.4967518 +"Longitude": -154.950072 +"YearBuilt": 1976 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Chelsea Mack" +"ListOfficeName": "eXp Realty" +"ListAgentMlsId": "54548" +"ListOfficeMlsId": "EXPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Completely renovated 3-bedroom, 1.5-bathroom home, with attached 2-car carport in Hawaiian Beaches. From rags to riches, here is your chance to own this fully restored home, where is new:\r\n \r\n -New roof\r\n -New LVP flooring\r\n -New drywall & fresh interior/exterior paint\r\n -New windows\r\n -New moldings\r\n -New kitchen w/ granite countertops & stainless steel drop-in sink\r\n -New cabinets\r\n -New stainless steel appliances, including washer/dryer & water heater\r\n -New light fixtures & ceiling fans\r\n -New vanities & bathroom mirrors/medicine cabinets\r\n -New toilets\r\n \r\n Outside the home, the lot has been cleared. Several loads of coarse gravel were spread out to create a driveway leading to the spacious carport, which easily accommodates two large vehicles. \r\n \r\n Situated on a paved, dead-end road, this property is also quiet and peaceful. Not too far from shipping, food, entertainment, and boundless outdoor activities. With less than a 10-minute drive to your nearest grocery store, about 15 minutes from Kea'au, and only 30 minutes from Hilo, this home is part of a thriving community.\r\n \r\n Don't miss your chance to buy a home that feels like new construction, without the new construction price tag! """ +"ArchitecturalStyle": "Detached" +"AssociationFeeIncludes": "None" +"AssociationName": "Hawaiian Beaches" +"AttributionContact": "(808) 725-2794" +"BathroomsFull": 1 +"ConstructionMaterials": "Wood Frame" +"CountyOrParish": "Hawaii" +"CreationDate": "2026-02-04T03:42:27.015817+00:00" +"DaysOnMarketReplicationDate": "2026-02-03" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"Flooring": "Vinyl" +"Furnished": "Unfurnished" +"GarageSpaces": "2.0" +"GarageYN": true +"HumanModifiedYN": true +"Inclusions": "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) 437-3119" +"ListAgentEmail": "chelsea.mack@gmail.com" +"ListAgentKey": "26111025" +"ListAgentKeyNumeric": "26111025" +"ListAgentOfficePhone": "(808) 725-2794" +"ListAgentPreferredPhone": "(808) 437-3119" +"ListAgentStateLicense": "RS-82892" +"ListOfficeEmail": "hi.broker@exprealty.net" +"ListOfficeKey": "2589160" +"ListOfficeKeyNumeric": "2589160" +"ListOfficePhone": "(808) 725-2794" +"ListingContractDate": "2026-02-03" +"ListingKeyNumeric": 1152312447 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Dead End" +"MLSAreaMajor": "Puna" +"MajorChangeTimestamp": "2026-02-03T17:40:00Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-02-03" +"OriginalListPrice": 328000.0 +"OriginatingSystemKey": "19248738" +"ParcelNumber": "3-1-5-081-043-0000" +"ParkingFeatures": "Two Car Garage,Two Spaces" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-02-04T03:41:00Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Pahoa" +"PropertyCondition": "Excellent, Updated/Remodeled" +"RoomType": "Entry/Foyer" +"Sewer": "Cesspool" +"SourceSystemKey": "1152312447" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Kumu" +"StreetNumber": "15-2677" +"StreetSuffix": "Street" +"SubdivisionName": "HAWAIIAN BEACHES" +"TaxAnnualAmount": "1906.8" +"TaxAssessedValue": 170700 +"Topography": "Other, Sloping" +"Utilities": "Above Ground Utilities,Electricity Available,Water Available" +"View": "None" +"VirtualTourURLUnbranded": "https://show.tours/v/FmbdKY6" +"WaterSource": "Private" +"YearBuiltEffective": 2026 +"ZoningDescription": "50 - Agricultural" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1152312447"\n } """ +"AssociationFeeTotal": 0.0 +"TaxAssessedValueLand": "19100" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "151600" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1152312447')" +"provider_name": "HICMLS" +"short_address": "Pahoa, Hawaii 96778, USA" +"RecordSignature": -922445930 +"UniversalParcelId": "urn:reso:upi:2.0:US:15001:3-1-5-081-043-0000" +"CountrySubdivision": "15001" +"OriginatingSystemListOfficeKey": "10013908" +"OriginatingSystemListAgentMemberKey": "18625655" +"Media": array:25 [ 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] 24 => array:57 [ …57] ] +"ID": "78023" } ] +success: true +page_size: 9 +page_count: 409 +count: 3675 +after_key: "" } "RF Response Time" => "0.15 seconds" ] ]
