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=3681&$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 {#6318 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6333 +post_id: "57632" +post_author: 1 +"ListingKey": "1128554937" +"ListingId": "202518634" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-09-27T00:36:52Z" +"RFModificationTimestamp": "2025-11-11T21:20:00Z" +"ListPrice": 500000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 58370.0 +"LivingArea": 798.0 +"BuildingAreaTotal": 798.0 +"City": "Honolulu" +"PostalCode": "96813" +"UnparsedAddress": "1088 Bishop Street 2206, Honolulu, Hawaii 96813" +"Coordinates": array:2 [ 0 => -157.8610923 1 => 21.3092412 ] +"Latitude": 21.3092412 +"Longitude": -157.8610923 +"YearBuilt": 1984 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "David Eng Ng" +"ListOfficeName": "Ohana Intl Premier Realty" +"ListAgentMlsId": "22834" +"ListOfficeMlsId": "OIPR" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Drastically price reduction!! Experience nearly 5-star living in this fully renovated and professionally designed 1-bedroom + den unit — perfect for a home office. Enjoy breathtaking sunsets with panoramic views of the ocean and harbor, all from the comfort of your own space.\r\n This turnkey, move-in-ready unit is ideal as a second home in paradise or an income-generating investment. When you’re away, let the Executive Centre’s professional hotel management handle your unit and create seamless cash flow.\r\n Located in vibrant downtown Honolulu, you’re just minutes from easy freeway access, the world-famous Waikiki Beach, Chinatown, and Honolulu’s top dining spots. The building is short-term rental friendly, making it a rare find for investors.\r\n Don’t miss this opportunity! Additional units are available for bulk purchase to maximize income potential.\r\n Must see to appreciate! """ +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFee2": "311.0" +"AssociationFeeIncludes": "Common Areas,Cable TV,HVAC,Hot Water,Internet,Sewer,Water" +"AttributionContact": "(808) 351-1888" +"BathroomsFull": 1 +"BuildingName": "Executive Centre" +"CLIP": 4547716768 +"CommunityFeatures": "Community Pool,Conference/Meeting Room,Laundry Facilities,Pool,Restaurant,Condo Hotel Community" +"ConstructionMaterials": "Masonry,Concrete,Steel Frame,Stucco" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2025-08-23T03:18:50.406085+00:00" +"DaysOnMarket": 236 +"DaysOnMarketReplication": 35 +"DaysOnMarketReplicationDate": "2025-09-26" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,Seller Disclosure,See Remarks" +"ElementarySchool": "Royal" +"EntryLevel": 22 +"Flooring": "Carpet,Ceramic Tile,Laminate" +"FrontageType": "Other" +"Furnished": "Furnished" +"GarageYN": true +"HighSchool": "Mckinley" +"Inclusions": "AC Central,Cable TV,Disposal,Drapes,Dryer,Microwave,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Washer" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 351-1888" +"ListAgentEmail": "davidng.realtor@gmail.com" +"ListAgentKey": "10777368" +"ListAgentKeyNumeric": "10777368" +"ListAgentOfficePhone": "(808) 351-1888" +"ListAgentPreferredPhone": "(808) 351-1888" +"ListAgentStateLicense": "RB-18624" +"ListOfficeEmail": "davidng.realtor@gmail.com" +"ListOfficeKey": "5050746" +"ListOfficeKeyNumeric": "5050746" +"ListOfficePhone": "(808) 351-1888" +"ListingContractDate": "2025-08-22" +"ListingKeyNumeric": 1128554937 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1245.22 +"MajorChangeTimestamp": "2025-09-20T08:56:06Z" +"MiddleOrJuniorSchool": "Keelikolani" +"MlsStatus": "Active" +"OnMarketDate": "2025-08-22" +"OriginalListPrice": 550000.0 +"OriginatingSystemKey": "18941278" +"ParcelNumber": "1-2-1-012-004-0253" +"ParkingFeatures": "Assigned,Covered,Garage,Guest,One Space,Secured" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-11-11T00:21:13Z" +"PhotosCount": 14 +"PoolFeatures": "Heated" +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent, Updated/Remodeled" +"SecurityFeatures": "Elevator Secured,Security Guard" +"SourceSystemKey": "1128554937" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Bishop" +"StreetNumber": "1088" +"StreetNumberNumeric": "1088" +"StreetSuffix": "Street" +"SubdivisionName": "DOWNTOWN" +"TaxAnnualAmount": "5114.04" +"TaxAssessedValue": 431900 +"TotalActualRent": 4360.0 +"UnitNumber": "2206" +"View": "Coastline, City, Ocean, Sunset" +"ViewYN": true +"ZoningDescription": "34 - BMX-4 Central Business Mix" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1128554937"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 1556.0 +"TaxAssessedValueLand": "46500" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "385400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1128554937')" +"provider_name": "HICMLS" +"RecordSignature": -771714080 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-1-012-004-0253" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "16870586" +"OriginatingSystemListAgentMemberKey": "3474485" +"Media": array:14 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004237153322" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1128554937/0b38c1754defaf1a73192ed424bfd2fe.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 254812 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1128554937/thumbnail-0b38c1754defaf1a73192ed424bfd2fe.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777368" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5050746" "MediaCategory" => null "MediaObjectID" => "IMG_8953.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "OIPR" "LongDescription" => "Aqua Aston Hospitality Hotel Front Desk" "MediaAlteration" => null "MediaKeyNumeric" => 2004237153322 "PropertySubType" => "Condominium" "RecordSignature" => -1911940866 "PreferredPhotoYN" => null "ResourceRecordID" => "202518634" "ShortDescription" => "Aqua Aston Hospitality Hotel Front Desk" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1128554937" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1128554937 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18941498" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18941278" ] 1 => array:57 [ "Order" => 2 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004237153310" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1128554937/7fcf0eb6f5bd4c9db55274049d2632ef.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 335394 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1128554937/thumbnail-7fcf0eb6f5bd4c9db55274049d2632ef.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777368" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5050746" "MediaCategory" => null "MediaObjectID" => "IMG_8899.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "OIPR" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004237153310 "PropertySubType" => "Condominium" "RecordSignature" => -1911940866 "PreferredPhotoYN" => null "ResourceRecordID" => "202518634" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1128554937" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1128554937 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18941486" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18941278" ] 2 => array:57 [ "Order" => 3 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004237153309" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1128554937/72112295fa3b164e7459f26757d4461a.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 257587 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1128554937/thumbnail-72112295fa3b164e7459f26757d4461a.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777368" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5050746" "MediaCategory" => null "MediaObjectID" => "IMG_8895.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "OIPR" "LongDescription" => "New Digital Door entry for security purposes" "MediaAlteration" => null "MediaKeyNumeric" => 2004237153309 "PropertySubType" => "Condominium" "RecordSignature" => -1911940866 "PreferredPhotoYN" => null "ResourceRecordID" => "202518634" "ShortDescription" => "New Digital Door entry for security purposes" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1128554937" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1128554937 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18941485" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18941278" ] 3 => array:57 [ "Order" => 4 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004237153311" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1128554937/cf859075bf7be3a0f6ee972d43aaba3a.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 292729 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1128554937/thumbnail-cf859075bf7be3a0f6ee972d43aaba3a.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777368" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5050746" "MediaCategory" => null "MediaObjectID" => "IMG_8900.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "OIPR" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004237153311 "PropertySubType" => "Condominium" "RecordSignature" => -1911940866 "PreferredPhotoYN" => null "ResourceRecordID" => "202518634" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1128554937" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1128554937 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18941487" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18941278" ] 4 => array:57 [ "Order" => 5 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004237153312" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1128554937/d49c45a16a989f975f0852859641d19e.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 279867 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1128554937/thumbnail-d49c45a16a989f975f0852859641d19e.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777368" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5050746" "MediaCategory" => null "MediaObjectID" => "IMG_8897.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "OIPR" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004237153312 "PropertySubType" => "Condominium" "RecordSignature" => -1911940866 "PreferredPhotoYN" => null "ResourceRecordID" => "202518634" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1128554937" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1128554937 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18941488" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18941278" ] 5 => array:57 [ "Order" => 6 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004237153313" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1128554937/0c6da573ce54877fa541254625c18aed.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 374564 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1128554937/thumbnail-0c6da573ce54877fa541254625c18aed.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777368" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5050746" "MediaCategory" => null "MediaObjectID" => "IMG_8902.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "OIPR" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004237153313 "PropertySubType" => "Condominium" "RecordSignature" => -1911940866 "PreferredPhotoYN" => null "ResourceRecordID" => "202518634" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1128554937" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1128554937 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18941489" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18941278" ] 6 => array:57 [ "Order" => 7 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004237153314" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1128554937/28e6ed012e7d72c5d2debdf576556ede.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 371949 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1128554937/thumbnail-28e6ed012e7d72c5d2debdf576556ede.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777368" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5050746" "MediaCategory" => null "MediaObjectID" => "IMG_8904.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "OIPR" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004237153314 "PropertySubType" => "Condominium" "RecordSignature" => -1911940866 "PreferredPhotoYN" => null "ResourceRecordID" => "202518634" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1128554937" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1128554937 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18941490" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18941278" ] 7 => array:57 [ "Order" => 8 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004237153315" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1128554937/c8e4f03f056d4ad46413e88ed5552342.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 294253 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1128554937/thumbnail-c8e4f03f056d4ad46413e88ed5552342.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777368" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5050746" "MediaCategory" => null "MediaObjectID" => "IMG_8905.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "OIPR" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004237153315 "PropertySubType" => "Condominium" "RecordSignature" => -1911940866 "PreferredPhotoYN" => null "ResourceRecordID" => "202518634" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1128554937" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1128554937 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18941491" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18941278" ] 8 => array:57 [ "Order" => 9 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004237153886" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1128554937/ada9261a76c33be7a3e4766d7c60e7d2.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 499053 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1128554937/thumbnail-ada9261a76c33be7a3e4766d7c60e7d2.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777368" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5050746" "MediaCategory" => null "MediaObjectID" => "IMG_8954.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "OIPR" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004237153886 "PropertySubType" => "Condominium" "RecordSignature" => -1911940866 "PreferredPhotoYN" => null "ResourceRecordID" => "202518634" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1128554937" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1128554937 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18941499" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18941278" ] 9 => array:57 [ "Order" => 10 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004237153889" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1128554937/d50dde2df419db61ca88ed3c85715d83.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 387493 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1128554937/thumbnail-d50dde2df419db61ca88ed3c85715d83.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777368" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5050746" "MediaCategory" => null "MediaObjectID" => "IMG_8952.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "OIPR" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004237153889 "PropertySubType" => "Condominium" "RecordSignature" => -1911940866 "PreferredPhotoYN" => null "ResourceRecordID" => "202518634" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1128554937" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1128554937 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18941500" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18941278" ] 10 => array:57 [ "Order" => 11 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004237153891" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1128554937/04f5f4cc5d0d632309bc70decd7defb5.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 564921 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1128554937/thumbnail-04f5f4cc5d0d632309bc70decd7defb5.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777368" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5050746" "MediaCategory" => null "MediaObjectID" => "IMG_8955.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "OIPR" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004237153891 "PropertySubType" => "Condominium" "RecordSignature" => -1911940866 "PreferredPhotoYN" => null "ResourceRecordID" => "202518634" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1128554937" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1128554937 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18941501" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18941278" ] 11 => array:57 [ "Order" => 12 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004237157720" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1128554937/3e896527cd76e2aef621815ab298b1dc.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 461592 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1128554937/thumbnail-3e896527cd76e2aef621815ab298b1dc.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777368" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5050746" "MediaCategory" => null "MediaObjectID" => "IMG_8961.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "OIPR" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004237157720 "PropertySubType" => "Condominium" "RecordSignature" => -1911940866 "PreferredPhotoYN" => null "ResourceRecordID" => "202518634" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1128554937" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1128554937 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18941502" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18941278" ] 12 => array:57 [ "Order" => 13 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004237157721" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1128554937/05b6a9028e829c3f9cd5880c3895103e.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 329580 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1128554937/thumbnail-05b6a9028e829c3f9cd5880c3895103e.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777368" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5050746" "MediaCategory" => null "MediaObjectID" => "IMG_8965.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "OIPR" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004237157721 "PropertySubType" => "Condominium" "RecordSignature" => -1911940866 "PreferredPhotoYN" => null "ResourceRecordID" => "202518634" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1128554937" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1128554937 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18941503" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18941278" ] 13 => array:57 [ "Order" => 14 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004237157722" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1128554937/c16cf427126e209cb20be3e13d2b2d58.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 452604 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1128554937/thumbnail-c16cf427126e209cb20be3e13d2b2d58.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777368" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5050746" "MediaCategory" => null "MediaObjectID" => "IMG_8966.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "OIPR" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004237157722 "PropertySubType" => "Condominium" "RecordSignature" => -1911940866 "PreferredPhotoYN" => null "ResourceRecordID" => "202518634" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1128554937" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1128554937 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18941504" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:58.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18941278" ] ] +"ID": "57632" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6331 +post_id: "50859" +post_author: 1 +"ListingKey": "1113875208" +"ListingId": "202512111" +"PropertyType": "For Sale" +"PropertySubType": "Multi Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-15T01:01:38Z" +"RFModificationTimestamp": "2025-11-11T21:21:34Z" +"ListPrice": 1000000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 5953.0 +"LivingArea": 0 +"BuildingAreaTotal": 2228.0 +"City": "Honolulu" +"PostalCode": "96817" +"UnparsedAddress": "1207 Palama Street, Honolulu, Hawaii 96817" +"Coordinates": array:2 [ 0 => -157.8656863 1 => 21.3226951 ] +"Latitude": 21.3226951 +"Longitude": -157.8656863 +"YearBuilt": 1921 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ginelle E Nagamine" +"ListOfficeName": "Waikiki Realty LLC" +"ListAgentMlsId": "46032" +"ListOfficeMlsId": "WRII" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ This listing is for 1207(parcel 32) & 1213C Palama (parcel 35). Must be sold together. Contains 3 structures. Back house is a 4 bdrm, 1 bath w/880 sf. Middle structure is a 2 story rooming house with 12 rooms, 2 showers, 4 toilets. Front structure is a 2 story with 4 bdrm, 1 bath downstairs and 3 bdrm, 1 bath upstairs.\r\n \r\n There is a 23 foot road widening setback on Palama street. \r\n \r\n Very conveniently located just 2 lots away from the Texaco Service station on Palama & Vineyard. \r\n \r\n This property needs a lot of work. But its a great location! Inactive and active real estate agent owners.\r\n \r\n Please drive by. Please don't bother tenants. We would prefer offers, subject to inspection.\r\n \r\n Assessed valued at: $1,494,0000! Open to offers. """ +"AttributionContact": "(808) 955-8282" +"CLIP": 7368319283 +"CoListAgentDirectPhone": "(808) 955-8282" +"CoListAgentEmail": "gwen@waikikirealtyllc.com" +"CoListAgentFullName": "Gwen Tanno" +"CoListAgentKey": "10778620" +"CoListAgentKeyNumeric": "10778620" +"CoListAgentMlsId": "05633" +"CoListAgentPreferredPhone": "(808) 955-8282" +"CoListOfficeEmail": "gwen@waikikirealty2.com" +"CoListOfficeKey": "2587245" +"CoListOfficeKeyNumeric": "2587245" +"CoListOfficeMlsId": "WRII" +"CoListOfficeName": "Waikiki Realty LLC" +"CoListOfficePhone": "(808) 955-8282" +"CommunityFeatures": "None" +"ConstructionMaterials": "Single Wall" +"CountyOrParish": "Oahu" +"CreationDate": "2025-05-15T01:05:08.621311+00:00" +"DaysOnMarket": 337 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2025-05-15" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "1031 Exchange,Principal is Real Estate Licensed" +"FrontageType": "Other" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "None" +"Levels": "One, Two" +"ListAgentDirectPhone": "(808) 955-8282" +"ListAgentEmail": "gtanno@gmail.com" +"ListAgentKey": "10779358" +"ListAgentKeyNumeric": "10779358" +"ListAgentOfficePhone": "(808) 955-8282" +"ListAgentPreferredPhone": "(808) 955-8282" +"ListAgentStateLicense": "RS-77289" +"ListOfficeEmail": "gwen@waikikirealty2.com" +"ListOfficeKey": "2587245" +"ListOfficeKeyNumeric": "2587245" +"ListOfficePhone": "(808) 955-8282" +"ListingContractDate": "2025-05-13" +"ListingKeyNumeric": 1113875208 +"ListingService": "Full Service" +"LotFeatures": "Other, Level" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2025-05-14T15:01:27Z" +"MlsStatus": "Active" +"NetOperatingIncome": 1.0 +"NumberOfUnitsTotal": "4" +"OnMarketDate": "2025-05-13" +"OperatingExpense": "1.0" +"OperatingExpenseIncludes": "Other" +"OriginalListPrice": 1000000.0 +"OriginatingSystemKey": "18749384" +"ParcelNumber": "1-1-7-031-032-0000" +"ParkingFeatures": "None" +"PhotosChangeTimestamp": "2025-11-11T00:21:13Z" +"PhotosCount": 1 +"PostalCity": "Honolulu" +"PropertyCondition": "Repairs Major,Tear Down / Value in Land" +"Sewer": "Other" +"SourceSystemKey": "1113875208" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Palama" +"StreetNumber": "1207" +"StreetNumberNumeric": "1207" +"StreetSuffix": "Street" +"StructureType": "Other" +"SubdivisionName": "PALAMA" +"TaxAnnualAmount": "12.0" +"TaxAssessedValue": 1637700 +"TenantPays": "Cable TV,Electricity,Gas,Water" +"Topography": "Level" +"TotalActualRent": 1.0 +"Utilities": "Above Ground Utilities,Electricity Available,Natural Gas Available,High Speed Internet Available,Phone Available,Sewer Available,Water Available" +"View": "None" +"WaterSource": "Public" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "StreetViewParam": "1$21.322684$-157.865576$85.85$13.33$1.00$phDzbjw6yM-u1Ph6D2IG_Q",\n "CompensationSubjectTo": "",\n "UnitThreeBedNumberOf": "4",\n "UtilitiesMeters": "None",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "149400.00",\n "LockBoxModDT": "2025-05-14T15:01:27.737",\n "SellingAgentRemarks": "",\n "TaxAssessedValueImprovements": "143700.00",\n "SetBacks": "C\u0026C,Of Record",\n "SQFTBuilding": "2228",\n "CompensationMethod": "",\n "Easements": "Other",\n "LandRecorded": "Dual Systems",\n "ListingKey": "1113875208",\n "StudioUnitsNumberOf": "0",\n "UnitOneBedNumberOf": "0",\n "CommercialSpacesNumberOf": "0",\n "OtherIncome": "1.00",\n "TotalIncome": "1.00",\n "UnitTwoBedNumberOf": "0"\n } """ +"HumanModifiedYN": true +"TaxAssessedValueLand": "149400" +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "143700" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1113875208')" +"provider_name": "HICMLS" +"RecordSignature": 192500807 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-7-031-032-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485627" +"OriginatingSystemCoListOfficeKey": "3485627" +"OriginatingSystemListAgentMemberKey": "9945807" +"OriginatingSystemCoListAgentMemberKey": "8842681" +"Media": array:1 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003983940827" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1113875208/b52155175df05ff1a54e073abc1f370c.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 568152 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1113875208/thumbnail-b52155175df05ff1a54e073abc1f370c.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10779358" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587245" "MediaCategory" => null "MediaObjectID" => "1207 front house.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "WRII" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003983940827 "PropertySubType" => "Multi Family" "RecordSignature" => 952549547 "PreferredPhotoYN" => null "ResourceRecordID" => "202512111" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1113875208" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1113875208 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18749461" "PropertySubTypeAdditional" => "Multi Family" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18749384" ] ] +"ID": "50859" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6334 +post_id: "54830" +post_author: 1 +"ListingKey": "1117717815" +"ListingId": "202514460" +"PropertyType": "For Sale" +"PropertySubType": "Industrial" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-19T05:51:28Z" +"RFModificationTimestamp": "2025-11-11T20:45:49Z" +"ListPrice": 2750000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 20436.0 +"LivingArea": 0 +"BuildingAreaTotal": 10103.0 +"City": "Honolulu" +"PostalCode": "96819" +"UnparsedAddress": "2110 Auiki Street, Honolulu, Hawaii 96819" +"Coordinates": array:2 [ 0 => -157.8898948 1 => 21.3223658 ] +"Latitude": 21.3223658 +"Longitude": -157.8898948 +"YearBuilt": 2006 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Camellia Young" +"ListOfficeName": "Hawaii Homes International" +"ListAgentMlsId": "25435" +"ListOfficeMlsId": "REEW" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "PRIME location in Kalihi, corner lot total= 20436sf with warehouse area of 9653sf. Mezzanine office and potential to build out the rest of the 2nd floor area. Fenced yard with security camera system. Easy access to Honolulu shipping docks. Near city central and 5-minuted to airport. Location is ideal for any logistics, materials handling, warehouse business. Long lease for sale til 2048. Confidential Inquiry, must tour site with Listing Agent." +"AttributionContact": "(808) 949-0020" +"BuildingFeatures": "Private Restrooms" +"BuildingName": "none" +"BusinessName": "NA" +"BusinessType": "Industrial, Warehouse" +"CLIP": 9745188858 +"ConstructionMaterials": "Metal Frame" +"Cooling": "1 Unit" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2025-06-19T05:49:16.317449+00:00" +"DaysOnMarketReplicationDate": "2025-06-19" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Familial Relation,See Remarks" +"EntryLevel": 1 +"ExistingLeaseType": "Other" +"Flooring": "Asphalt, Concrete, Other" +"FrontageType": "Other" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetEntireListingDisplayYN": true +"LeaseAmount": "14000.0" +"LeaseExpiration": "2048-12-31" +"Levels": "One" +"ListAgentDirectPhone": "(808) 228-2628" +"ListAgentEmail": "realtyhawaii808@yahoo.com" +"ListAgentKey": "10767670" +"ListAgentKeyNumeric": "10767670" +"ListAgentOfficePhone": "(808) 949-0020" +"ListAgentPreferredPhone": "(808) 228-2628" +"ListAgentStateLicense": "RS-60206" +"ListOfficeEmail": "hihomesintl@gmail.com" +"ListOfficeKey": "2587968" +"ListOfficeKeyNumeric": "2587968" +"ListOfficePhone": "(808) 949-0020" +"ListingContractDate": "2025-06-18" +"ListingKeyNumeric": 1117717815 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2025-06-18T19:47:14Z" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OnMarketDate": "2025-06-18" +"OriginalListPrice": 2750000.0 +"OriginatingSystemKey": "18818090" +"ParcelNumber": "1-1-2-024-019-9999" +"ParkingFeatures": "On Site,On Street" +"ParkingTotal": "8.0" +"PhotosChangeTimestamp": "2025-11-11T00:21:13Z" +"PhotosCount": 1 +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"RoadFrontageType": "City Street" +"Sewer": "Connected" +"SourceSystemKey": "1117717815" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Auiki" +"StreetNumber": "2110" +"StreetNumberNumeric": "2110" +"StreetSuffix": "Street" +"SubdivisionName": "KAPALAMA" +"TaxAnnualAmount": "54660.0" +"TaxAssessedValue": 4637800 +"TenantPays": "Electricity,Insurance,Taxes,Trash Collection,Water" +"Utilities": "Electricity Available,Other,Sewer Connected" +"ZoningDescription": "42 - I-2 General Industrial Dis" +"ListAOR": "HI Central" +"LandTenure": "Lease Hold" +"CustomFields": """ {\n "ListingKey": "1117717815"\n } """ +"HumanModifiedYN": true +"TaxAssessedValueLand": "4065400" +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "572400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1117717815')" +"provider_name": "HICMLS" +"RecordSignature": 30726770 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-2-024-019-9999" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486350" +"OriginatingSystemListAgentMemberKey": "3475374" +"Media": array:1 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004063790912" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1117717815/c48092b2d01f5fd61b8cfeec37e57e63.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 429275 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1117717815/thumbnail-c48092b2d01f5fd61b8cfeec37e57e63.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10767670" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2587968" "MediaCategory" => null "MediaObjectID" => "Ace-Interior-1.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "REEW" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004063790912 "PropertySubType" => "Industrial" "RecordSignature" => 589647518 "PreferredPhotoYN" => null "ResourceRecordID" => "202514460" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1117717815" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1117717815 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18818178" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18818090" ] ] +"ID": "54830" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6330 +post_id: "55966" +post_author: 1 +"ListingKey": "1119821197" +"ListingId": "202516689" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-24T01:15:37Z" +"RFModificationTimestamp": "2025-11-11T21:14:43Z" +"ListPrice": 2988000.0 +"BathroomsTotalInteger": 12.0 +"BathroomsHalf": 0 +"BedroomsTotal": 12.0 +"LotSizeArea": 5757.0 +"LivingArea": 5808.0 +"BuildingAreaTotal": 5808.0 +"City": "Honolulu" +"PostalCode": "96817" +"UnparsedAddress": "815 Lopez Lane, Honolulu, Hawaii 96817" +"Coordinates": array:2 [ 0 => -157.8660361 1 => 21.3227376 ] +"Latitude": 21.3227376 +"Longitude": -157.8660361 +"YearBuilt": 1916 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Christina L Dwight" +"ListOfficeName": "Commercial Inv. Strategies" +"ListAgentMlsId": "26009" +"ListOfficeMlsId": "CISC" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Completely renovated inside and out, this 3-structure legal, non-conforming gem earns better than a 7.8% return (actual). Off-the-ground construction means repairs are simple! All 12 two-bedrooms are permitted & renovated with new electric, plumbing, kitchens, and bathrooms, windows, doors, new roofs, paint, and more. Separately metered for water, electric, and gas (not hooked up) mean recurring utility expenses for this excellent opportunity are close to zero. Private lane access runs with the property & includes 3 parking spaces that are rented out for add’l income." +"ArchitecturalStyle": "Multiplex" +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 429-1098" +"BathroomsFull": 12 +"CLIP": 4068112547 +"CommunityFeatures": "None" +"ConstructionMaterials": "Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-07-24T01:19:25.442059+00:00" +"DaysOnMarket": 313 +"DaysOnMarketReplication": 47 +"DaysOnMarketReplicationDate": "2025-07-24" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None,Principal is Real Estate Licensed" +"Flooring": "Other" +"FrontageType": "Other" +"Furnished": "Partially" +"Inclusions": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 429-1098" +"ListAgentEmail": "cis@christinadwight.com" +"ListAgentKey": "10772536" +"ListAgentKeyNumeric": "10772536" +"ListAgentOfficePhone": "(808) 429-1098" +"ListAgentPreferredPhone": "(808) 429-1098" +"ListAgentStateLicense": "RB-20978" +"ListOfficeEmail": "christinalow@mac.com" +"ListOfficeKey": "2585856" +"ListOfficeKeyNumeric": "2585856" +"ListOfficePhone": "(808) 429-1098" +"ListingContractDate": "2025-06-06" +"ListingKeyNumeric": 1119821197 +"ListingService": "Full Service" +"LotFeatures": "Cul-De-Sac,Flag Lot,Interior Lot,Level" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2025-07-23T15:15:05Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-06-06" +"OriginalListPrice": 2988000.0 +"OriginatingSystemKey": "18884568" +"ParcelNumber": "1-1-6-001-058-0000" +"ParkingFeatures": "Three or more Spaces" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-11-11T00:21:13Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent, Updated/Remodeled" +"SourceSystemKey": "1119821197" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Lopez" +"StreetNumber": "815" +"StreetNumberNumeric": "815" +"StreetSuffix": "Lane" +"SubdivisionName": "KAPALAMA" +"TaxAnnualAmount": "3576.0" +"TaxAssessedValue": 1032900 +"Topography": "Level" +"TotalActualRent": 21621.0 +"Utilities": "Above Ground Utilities,Electricity Available,Water Available" +"View": "None" +"YearBuiltEffective": 2024 +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1119821197"\n } """ +"HumanModifiedYN": true +"TaxAssessedValueLand": "767000" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "265900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1119821197')" +"provider_name": "HICMLS" +"RecordSignature": -457069553 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-6-001-058-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3487738" +"OriginatingSystemListAgentMemberKey": "3475750" +"Media": array:25 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004114210703" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1119821197/51152596f7100a7ffa7e21bf9fd86986.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 697145 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1119821197/thumbnail-51152596f7100a7ffa7e21bf9fd86986.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772536" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2585856" "MediaCategory" => null "MediaObjectID" => "LopezLane-01.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "CISC" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004114210703 "PropertySubType" => "Single Family Residence" "RecordSignature" => 1786201881 "PreferredPhotoYN" => null "ResourceRecordID" => "202516689" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1119821197" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:41.950-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1119821197 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18884574" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:20:41.950-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18884568" ] 1 => array:57 [ "Order" => 2 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004114210704" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1119821197/03c847b8ca51a612b622168bc6b152df.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 740088 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1119821197/thumbnail-03c847b8ca51a612b622168bc6b152df.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772536" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2585856" "MediaCategory" => null "MediaObjectID" => "LopezLane-02.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "CISC" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004114210704 "PropertySubType" => "Single Family Residence" "RecordSignature" => 1786201881 "PreferredPhotoYN" => null "ResourceRecordID" => "202516689" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1119821197" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:41.950-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1119821197 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18884575" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:20:41.950-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18884568" ] 2 => array:57 [ "Order" => 3 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004114210705" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1119821197/a60c6fd974f502b58f192fc42647fe05.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 600751 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1119821197/thumbnail-a60c6fd974f502b58f192fc42647fe05.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772536" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2585856" "MediaCategory" => null "MediaObjectID" => "LopezLane-03.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "CISC" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004114210705 "PropertySubType" => "Single Family Residence" "RecordSignature" => 1786201881 "PreferredPhotoYN" => null "ResourceRecordID" => "202516689" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1119821197" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:41.950-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1119821197 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18884576" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:20:41.950-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18884568" ] 3 => array:57 [ "Order" => 4 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004114210706" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1119821197/65fa860e8556d9971ba297f2006a1972.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 562444 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1119821197/thumbnail-65fa860e8556d9971ba297f2006a1972.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772536" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2585856" "MediaCategory" => null "MediaObjectID" => "LopezLane-04.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "CISC" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004114210706 "PropertySubType" => "Single Family Residence" "RecordSignature" => 1786201881 "PreferredPhotoYN" => null "ResourceRecordID" => "202516689" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1119821197" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:41.950-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1119821197 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18884577" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:20:41.950-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18884568" ] 4 => array:57 [ "Order" => 5 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004114210707" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1119821197/6d84a0be6dea71971113af77da184005.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 523374 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1119821197/thumbnail-6d84a0be6dea71971113af77da184005.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772536" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2585856" "MediaCategory" => null "MediaObjectID" => "LopezLane-05.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "CISC" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004114210707 "PropertySubType" => "Single Family Residence" "RecordSignature" => 1786201881 "PreferredPhotoYN" => null "ResourceRecordID" => "202516689" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1119821197" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:41.950-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1119821197 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18884578" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:20:41.950-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18884568" ] 5 => array:57 [ "Order" => 6 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004114210708" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1119821197/72b1ae92f36c095e4a4d292fad219f95.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 417641 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1119821197/thumbnail-72b1ae92f36c095e4a4d292fad219f95.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772536" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2585856" "MediaCategory" => null "MediaObjectID" => "LopezLane-06.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "CISC" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004114210708 "PropertySubType" => "Single Family Residence" "RecordSignature" => 1786201881 "PreferredPhotoYN" => null …24 ] 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": "55966" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6332 +post_id: "53172" +post_author: 1 +"ListingKey": "1103106837" +"ListingId": "202502303" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-22T00:36:51Z" +"RFModificationTimestamp": "2025-11-11T02:05:05Z" +"ListPrice": 499000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 56672.0 +"LivingArea": 1165.0 +"BuildingAreaTotal": 1165.0 +"City": "Honolulu" +"PostalCode": "96826" +"UnparsedAddress": "1750 Kalakaua Avenue 115, Honolulu, Hawaii 96826" +"Coordinates": array:2 [ 0 => -157.8358083 1 => 21.2914221 ] +"Latitude": 21.2914221 +"Longitude": -157.8358083 +"YearBuilt": 1978 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jerome Liu" +"ListOfficeName": "Fortune Properties LLC" +"ListAgentMlsId": "45168" +"ListOfficeMlsId": "FPRO" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Location and Window Appeal mixed use condo unit. Spacious ground floor unit perfect for self-employed business owners or investors, or can be just a residential unit with walking distance to the world famous Waikiki, and Ala Moana Shopping Center. This well kept unit has a large reception area, wet bar kitchen, with glossy finished cabinets. Features 2 assigned parking stalls for your customers or personal use. Highly secured building with license plate recognition camera system. 24/7 lobby desk security. Amenities galore including recreation room, pool, multiple gym rooms, shower, sauna, tennis court, basketball court. $49 Other Monthly Fees are for Cable/Television." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Concierge" +"AssociationFee2": "49.0" +"AssociationFeeIncludes": "Common Areas,Sewer,Water" +"AttributionContact": "(808) 636-1367" +"BathroomsFull": 1 +"BuildingName": "Century Center" +"CLIP": 2671149602 +"CoListAgentDirectPhone": "(808) 636-1367" +"CoListAgentEmail": "jingarywang@gmail.com" +"CoListAgentFullName": "Jin Wang" +"CoListAgentKey": "11408660" +"CoListAgentKeyNumeric": "11408660" +"CoListAgentMlsId": "48595" +"CoListAgentPreferredPhone": "(808) 227-8221" +"CoListOfficeEmail": "van.ko@outlook.com" +"CoListOfficeKey": "2589233" +"CoListOfficeKeyNumeric": "2589233" +"CoListOfficeMlsId": "FPRO" +"CoListOfficeName": "Fortune Properties LLC" +"CoListOfficePhone": "(808) 636-1367" +"CommunityFeatures": "Barbecue,Concierge,Clubhouse,Community Pool,Fitness,Laundry Facilities,Pool,Sauna,Tennis Court(s),Trails/Paths" +"ConstructionMaterials": "Masonry,Concrete,Steel Frame,Stucco" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2025-04-08T00:33:57.730587+00:00" +"DaysOnMarketReplicationDate": "2025-01-22" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 1 +"Flooring": "Ceramic Tile,Vinyl" +"FrontageType": "Other" +"Furnished": "Unfurnished" +"Inclusions": "AC Central,Blinds,Disposal,Dryer,Smoke Detector,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) 398-8225" +"ListAgentEmail": "Liujerome7@gmail.com" +"ListAgentKey": "10774127" +"ListAgentKeyNumeric": "10774127" +"ListAgentOfficePhone": "(808) 636-1367" +"ListAgentPreferredPhone": "(808) 398-8225" +"ListAgentStateLicense": "RS-76496" +"ListOfficeEmail": "van.ko@outlook.com" +"ListOfficeKey": "2589233" +"ListOfficeKeyNumeric": "2589233" +"ListOfficePhone": "(808) 636-1367" +"ListingContractDate": "2025-01-21" +"ListingKeyNumeric": 1103106837 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1680.87 +"MajorChangeTimestamp": "2025-01-21T14:36:39Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-01-21" +"OriginalListPrice": 499000.0 +"OriginatingSystemKey": "18501141" +"ParcelNumber": "1-2-3-032-007-0015" +"ParkingFeatures": "Covered,Guest,Two Spaces" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-11-11T00:21:13Z" +"PhotosCount": 16 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent" +"SecurityFeatures": "Elevator Secured,Key Card Entry,Security Guard" +"SourceSystemKey": "1103106837" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kalakaua" +"StreetNumber": "1750" +"StreetNumberNumeric": "1750" +"StreetSuffix": "Avenue" +"SubdivisionName": "MCCULLY" +"TaxAnnualAmount": "6060.0" +"TaxAssessedValue": 488700 +"UnitNumber": "115" +"View": "City, Other" +"ViewYN": true +"ZoningDescription": "33 - BMX-3 Community Business M" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "FractionalOwnershipYN": "0",\n "ManagementCompanyName": "Hawaiiana",\n "CompensationSubjectTo": "",\n "TaxPaidBySellerYN": "",\n "ElevatorsNumberOf": "5",\n "TaxAssessedValueLand": "107400.00",\n "LockBoxModDT": "2025-01-20T16:15:36.280",\n "SellingAgentRemarks": "",\n "TaxAssessedValueImprovements": "381300.00",\n "ManagementCompanyPhone": "8085939100",\n "CompensationMethod": "",\n "LandRecorded": "Land Court",\n "ListingKey": "1103106837",\n "StreetViewParam": "1$21.29134$-157.835555$71.59$13.33$1.00$CHVbZ0Q1gbM6YFSFmrzPMw",\n "CondoParkingUnit": "2nd Floor",\n "ParkingAdditional": "0",\n "OwnerOccupancyPercentage": "66",\n "TaxExcemptionOwnerOccupancy": "0"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 1730.0 +"TaxAssessedValueLand": "107400" +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "381300" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1103106837')" +"provider_name": "HICMLS" +"RecordSignature": 1985151243 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-032-007-0015" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10496092" +"OriginatingSystemCoListOfficeKey": "10496092" +"OriginatingSystemListAgentMemberKey": "9539889" +"OriginatingSystemCoListAgentMemberKey": "12781149" +"Media": array:16 [ 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] ] +"ID": "53172" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6335 +post_id: "59955" +post_author: 1 +"ListingKey": "1137568888" +"ListingId": "202521562" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-01T21:18:48Z" +"RFModificationTimestamp": "2025-11-11T01:50:31Z" +"ListPrice": 1350000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 132422.0 +"LivingArea": 2295.0 +"BuildingAreaTotal": 2710.0 +"City": "Waianae" +"PostalCode": "96792" +"UnparsedAddress": "87-250 Kulaaupuni Street, Waianae, Hawaii 96792" +"Coordinates": array:2 [ 0 => -158.1746838 1 => 21.4220926 ] +"Latitude": 21.4220926 +"Longitude": -158.1746838 +"YearBuilt": 1950 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Aaron M Tsuchitori" +"ListOfficeName": "Newtown Realty, Inc." +"ListAgentMlsId": "50655" +"ListOfficeMlsId": "NEWT" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "3 acres of flat and clear land in Maili! Zoned AG2 and ready to be made your own. This property features a large house with two bedrooms, two bathrooms, and two additional office rooms. The living room features an indoor koi pond! The lot features a grove of about 30 Kou trees and 20 Milo trees. There are three navel oranges, three tangerines, three varieties of mango, lemon, calamansi, pomegranate, and tamarind trees on the property, too." +"ArchitecturalStyle": "Detached" +"AttributionContact": "(808) 593-0709" +"BathroomsFull": 2 +"CarportYN": true +"CoListAgentDirectPhone": "(808) 593-0709" +"CoListAgentEmail": "david.tsuchitori@hawaiiantel.net" +"CoListAgentFullName": "David K Tsuchitori" +"CoListAgentKey": "10768304" +"CoListAgentKeyNumeric": "10768304" +"CoListAgentMlsId": "21920" +"CoListAgentPreferredPhone": "(808) 255-5946" +"CoListOfficeKey": "2586376" +"CoListOfficeKeyNumeric": "2586376" +"CoListOfficeMlsId": "NEWT" +"CoListOfficeName": "Newtown Realty, Inc." +"CoListOfficePhone": "(808) 593-0709" +"ConstructionMaterials": "Single Wall" +"CountyOrParish": "Oahu" +"CreationDate": "2025-10-01T21:23:55.381718+00:00" +"DaysOnMarketReplicationDate": "2025-10-01" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Maili" +"Flooring": "Hardwood" +"Furnished": "Partially" +"GarageSpaces": "2.0" +"GarageYN": true +"HighSchool": "Waianae" +"Inclusions": "Blinds,Ceiling Fan,Range/Oven,Refrigerator,Security System,Smoke Detector" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 597-7086" +"ListAgentEmail": "amtsuchitori@gmail.com" +"ListAgentKey": "17767109" +"ListAgentKeyNumeric": "17767109" +"ListAgentOfficePhone": "(808) 593-0709" +"ListAgentPreferredPhone": "(808) 597-7086" +"ListAgentStateLicense": "RS-83281" +"ListOfficeKey": "2586376" +"ListOfficeKeyNumeric": "2586376" +"ListOfficePhone": "(808) 593-0709" +"ListingContractDate": "2025-10-01" +"ListingKeyNumeric": 1137568888 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Interior Lot,Level" +"MLSAreaMajor": "Leeward" +"MajorChangeTimestamp": "2025-10-01T11:18:27Z" +"MiddleOrJuniorSchool": "Waianae" +"MlsStatus": "Active" +"OnMarketDate": "2025-10-01" +"OriginalListPrice": 1350000.0 +"OriginatingSystemKey": "19012168" +"ParcelNumber": "1-8-7-003-058-0000" +"ParkingFeatures": "Carport,Two Car Garage,Two Spaces" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-11-11T00:21:13Z" +"PhotosCount": 9 +"PoolFeatures": "None" +"PostalCity": "Waianae" +"PropertyCondition": "Average Condition" +"SourceSystemKey": "1137568888" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Kulaaupuni" +"StreetNumber": "87-250" +"StreetSuffix": "Street" +"SubdivisionName": "MAILI" +"TaxAnnualAmount": "2940.0" +"TaxAssessedValue": 641000 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Electricity Available,Natural Gas Available,High Speed Internet Available,Water Available" +"View": "None" +"YearBuiltEffective": 1982 +"ZoningDescription": "52 - AG-2 General Agricultural" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1137568888"\n } """ +"HumanModifiedYN": true +"TaxAssessedValueLand": "487400" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "153600" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1137568888')" +"provider_name": "HICMLS" +"RecordSignature": -1472795571 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-8-7-003-058-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3484758" +"OriginatingSystemCoListOfficeKey": "3484758" +"OriginatingSystemListAgentMemberKey": "15367560" +"OriginatingSystemCoListAgentMemberKey": "8808108" +"Media": array:9 [ 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] ] +"ID": "59955" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6432 +post_id: "49607" +post_author: 1 +"ListingKey": "1114339975" +"ListingId": "202512491" +"PropertyType": "For Sale" +"PropertySubType": "Industrial" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-21T02:01:19Z" +"RFModificationTimestamp": "2025-11-11T21:12:32Z" +"ListPrice": 159000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 56672.0 +"LivingArea": 0 +"BuildingAreaTotal": 1325.0 +"City": "Honolulu" +"PostalCode": "96826" +"UnparsedAddress": "1750 Kalakaua Avenue 112, Honolulu, Hawaii 96826" +"Coordinates": array:2 [ 0 => -157.8353525 1 => 21.2913051 ] +"Latitude": 21.2913051 +"Longitude": -157.8353525 +"YearBuilt": 1978 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Pomaikai S Shishido" +"ListOfficeName": "Quality Properties" +"ListAgentMlsId": "47412" +"ListOfficeMlsId": "QUAP" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Prime Commercial Space in Honolulu! Unlock the potential of you business in the heart of Honolulu with this rare ground-floor commercial unit in Century Center. Priced to sell at $159,000, this unit also includes a $5,000 credit to buyer at closing, a perfect opportunity to customize the space to fit your vision. Ground floor access with excellent visibility and foot traffic. Ideal for office, salon, boutique, consulting, or private practice with 2 assigned parking stalls. Unit and building features; Central AC, 24/7 building security, and front desk reception. Minutes from Waikiki, Ala Moana, and the Convention Center with easy access to H-1, public transportation, and major hotels. Take advantage of this affordable entry point into Honolulu's commercial real estate market with built-in buyer incentives. Whether you're launching a new venture or expanding your brand, this unit offers the perfect blend of location, flexibility, and value. Schedule your private showing today!" +"AttributionContact": "(808) 591-2224" +"BuildingFeatures": "Private Restrooms,Public Restrooms" +"BuildingName": "Century Center" +"BusinessName": "Quality Properties" +"BusinessType": "Mixed" +"CLIP": 8038156570 +"CoListAgentDirectPhone": "(808) 591-2224" +"CoListAgentEmail": "spencer.shishido@gmail.com" +"CoListAgentFullName": "Spencer Shishido" +"CoListAgentKey": "10775116" +"CoListAgentKeyNumeric": "10775116" +"CoListAgentMlsId": "47195" +"CoListAgentPreferredPhone": "(808) 371-5480" +"CoListOfficeKey": "2586500" +"CoListOfficeKeyNumeric": "2586500" +"CoListOfficeMlsId": "QUAP" +"CoListOfficeName": "Quality Properties" +"CoListOfficePhone": "(808) 591-2224" +"CommunityFeatures": "Business Center,Recreation Area" +"ConstructionMaterials": "Concrete" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2025-05-21T02:05:17.879938+00:00" +"CurrentUse": "Mixed Use" +"DaysOnMarketReplicationDate": "2025-05-21" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 1 +"ExistingLeaseType": "Other" +"Flooring": "Other" +"InteriorFeatures": "Handicap Access" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LeaseAmount": "856.36" +"LeaseExpiration": "2043-01-01" +"ListAgentDirectPhone": "(808) 384-5727" +"ListAgentEmail": "pomaikaishishido@gmail.com" +"ListAgentKey": "10775614" +"ListAgentKeyNumeric": "10775614" +"ListAgentOfficePhone": "(808) 591-2224" +"ListAgentPreferredPhone": "(808) 384-5727" +"ListAgentStateLicense": "RS-79476" +"ListOfficeKey": "2586500" +"ListOfficeKeyNumeric": "2586500" +"ListOfficePhone": "(808) 591-2224" +"ListingContractDate": "2025-05-20" +"ListingKeyNumeric": 1114339975 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2025-05-20T16:01:00Z" +"MlsStatus": "Active" +"NumberOfUnitsTotal": "1" +"OnMarketDate": "2025-05-20" +"OriginalListPrice": 159000.0 +"OriginatingSystemKey": "18760544" +"ParcelNumber": "1-2-3-032-007-0012" +"ParkingFeatures": "Assigned, Public" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-11-11T00:21:13Z" +"PhotosCount": 10 +"PostalCity": "Honolulu" +"PropertyCondition": "Average Condition" +"RoadFrontageType": "City Street" +"SecurityFeatures": "Fire Sprinkler System,Security Service" +"Sewer": "Connected" +"SourceSystemKey": "1114339975" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kalakaua" +"StreetNumber": "1750" +"StreetNumberNumeric": "1750" +"StreetSuffix": "Avenue" +"SubdivisionName": "MCCULLY" +"TaxAnnualAmount": "6776.52" +"TaxAssessedValue": 564800 +"TenantPays": "Common Area Maintenance,Electricity,HVAC Maintenance,Taxes" +"UnitNumber": "112" +"Utilities": "Electricity Available,Sewer Connected" +"ZoningDescription": "33 - BMX-3 Community Business M" +"ListAOR": "HI Central" +"LandTenure": "Lease Hold" +"CustomFields": """ {\n "CompensationSubjectTo": "",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "126400.00",\n "LockBoxModDT": "2025-05-20T15:33:25.360",\n "CompensationMethod": "",\n "SellingAgentRemarks": "",\n "ListingKey": "1114339975",\n "TaxAssessedValueImprovements": "438400.00",\n "IncomeInformationSource": "Owner",\n "ManagementCompanyName": "Hawaiiana",\n "StreetViewParam": "1$21.29134$-157.835555$255.96$13.33$1.00$44oMq7XLsgEZwQX0zA4GgQ",\n "SQFTInterior": "1325",\n "LeaseFeeMonth": "856.36",\n "LeaseExpirationYear": "2043",\n "LessorName": "Armanda Nakaya Real Property Trust",\n "ManagementCompanyPhone": "8084405530",\n "ExpensesInformationSource": "Owner",\n "Loading": "Loading Area",\n "Easements": "None",\n "LandRecorded": "Land Court",\n "LandlordPhone": "8083845727",\n "LandlordName": "Quality Properties",\n "SQFTOther": "0",\n "FeeOptions": "None"\n } """ +"HumanModifiedYN": true +"TaxAssessedValueLand": "126400" +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "438400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1114339975')" +"provider_name": "HICMLS" +"RecordSignature": 1643440101 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-032-007-0012" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3484882" +"OriginatingSystemCoListOfficeKey": "3484882" +"OriginatingSystemListAgentMemberKey": "10974755" +"OriginatingSystemCoListAgentMemberKey": "10846934" +"Media": array:10 [ 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] ] +"ID": "49607" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6428 +post_id: "54207" +post_author: 1 +"ListingKey": "1118609572" +"ListingId": "202515167" +"PropertyType": "For Sale" +"PropertySubType": "Industrial" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-09T06:59:04Z" +"RFModificationTimestamp": "2025-11-11T21:18:22Z" +"ListPrice": 5590000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 33774.0 +"LivingArea": 0 +"BuildingAreaTotal": 42702.0 +"City": "Honolulu" +"PostalCode": "96819" +"UnparsedAddress": "3075 Kalihi Street, Honolulu, Hawaii 96819" +"Coordinates": array:2 [ 0 => -157.8540672 1 => 21.3586691 ] +"Latitude": 21.3586691 +"Longitude": -157.8540672 +"YearBuilt": 1966 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Grace PA Lee" +"ListOfficeName": "Green Tree Realty" +"ListAgentMlsId": "32454" +"ListOfficeMlsId": "GREE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "33,774 Sq ft of B-1 zoning lot in upper Kalihi Valley with 2 story concrete building. First floor has fully occupied 4 commercial tenants ( can be used as 6 units ) and a coin laundromat with 9 commercial washers and 9 dryers generating income for the owner. Second floor has 8 one bedroom and one bath residential units fully occupied. 35 of parking. Sale includes 3059 Kalihi Street - TMK : 1-1-4-014-028 consisting of 5,000 sq ft. assessed value $ 568,800. The Building renovated in 2023-2024." +"AttributionContact": "(808) 946-2980" +"BuildingFeatures": "Private Restrooms" +"BuildingName": "N/A" +"BusinessType": "Condominium, Industrial, Professional/Office, Other, Residential" +"CLIP": 8437731958 +"CommunityFeatures": "Business Center,Other" +"ConstructionMaterials": "Block, Concrete" +"Cooling": "Other" +"CountyOrParish": "Oahu" +"CreationDate": "2025-07-01T10:30:27.069680+00:00" +"DaysOnMarket": 289 +"DaysOnMarketReplication": 8 +"DaysOnMarketReplicationDate": "2025-07-09" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent" +"ExistingLeaseType": "See Remarks" +"Flooring": "Concrete" +"FrontageType": "Other" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 228-6810" +"ListAgentEmail": "gracepalee@yahoo.com" +"ListAgentKey": "10767902" +"ListAgentKeyNumeric": "10767902" +"ListAgentOfficePhone": "(808) 946-2980" +"ListAgentPreferredPhone": "(808) 228-6810" +"ListAgentStateLicense": "RB-20460" +"ListOfficeEmail": "gracepalee@yahoo.com" +"ListOfficeKey": "2589101" +"ListOfficeKeyNumeric": "2589101" +"ListOfficePhone": "(808) 946-2980" +"ListingContractDate": "2025-06-30" +"ListingKeyNumeric": 1118609572 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2025-07-01T00:27:38Z" +"MlsStatus": "Active" +"NetOperatingIncome": 132444.0 +"NumberOfUnitsTotal": "13" +"OnMarketDate": "2025-06-30" +"OperatingExpense": "179712.0" +"OriginalListPrice": 5590000.0 +"OriginatingSystemKey": "18839611" +"ParcelNumber": "1-1-4-014-025-0000" +"ParkingFeatures": "Assigned,On Site,Unassigned" +"ParkingTotal": "35.0" +"PhotosChangeTimestamp": "2025-11-11T00:21:13Z" +"PhotosCount": 20 +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"Sewer": "Connected" +"SourceSystemKey": "1118609572" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Kalihi" +"StreetNumber": "3075" +"StreetNumberNumeric": "3075" +"StreetSuffix": "Street" +"SubdivisionName": "KALIHI VALLEY" +"TaxAnnualAmount": "20088.0" +"TaxAssessedValue": 3288300 +"TotalActualRent": 22513.0 +"Utilities": "Electricity Available,Natural Gas Available,Sewer Connected" +"ZoningDescription": "31 - B-1 Neighborhood Business" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1118609572"\n } """ +"HumanModifiedYN": true +"TaxAssessedValueLand": "2832200" +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "456100" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1118609572')" +"provider_name": "HICMLS" +"RecordSignature": 575300110 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-4-014-025-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "9676855" +"OriginatingSystemListAgentMemberKey": "3479379" +"Media": array:20 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] ] +"ID": "54207" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6323 +post_id: "55058" +post_author: 1 +"ListingKey": "1119105537" +"ListingId": "202515970" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-12T09:47:39Z" +"RFModificationTimestamp": "2025-11-11T21:10:07Z" +"ListPrice": 99999.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 15594.0 +"LivingArea": 468.0 +"BuildingAreaTotal": 558.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "417 Nohonani Street 405, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ 0 => -157.8258935 1 => 21.2798699 ] +"Latitude": 21.2798699 +"Longitude": -157.8258935 +"YearBuilt": 1959 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Theresa Harden" +"ListOfficeName": "Hawaii Dream Realty LLC" +"ListAgentMlsId": "25685" +"ListOfficeMlsId": "HDRL" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ LEGAL SHORT-TERM RENTAL (NONCONFORMING HOTEL EXEMPTED FROM STR PERMIT) - Hawaiian King with it's 1950's\r\n art deco style offers a great opportunity to have a short-term rental property with a renovated, full kitchen, nice pool and\r\n on site laundry making a great investment property or place to call home. Property sold with furnishings. Located in the\r\n heart of Waikiki with shopping, dining & beaches all within walking distance and easy access to public transportation (no\r\n parking on property). MF includes water, sewer, cable, on-site manager, and common area maintenance; other fee is the\r\n electric (monthly average) which varies with usage and billed quarterly. Lease Rent through 2036; Lessor approval /\r\n consent required; buyer will need to submit application packet with $500 fee and buyer's financials to Queen Emma within\r\n 10 days of acceptance in order to receive Lessor approval and consent prior to closing; additionally Queen Emma requires\r\n 6 months of Lease Rent reserves upfront to be paid by buyer with escrow closing. """ +"ArchitecturalStyle": "Low Rise" +"AssociationAmenities": "Management" +"AssociationFee2": "175.0" +"AssociationFeeIncludes": "Common Areas,Cable TV,Internet,Sewer,Water" +"AttributionContact": "(808) 735-2221" +"BathroomsFull": 1 +"BuildingName": "Hawaiian King" +"CLIP": 9663532558 +"CommunityFeatures": "Barbecue,Deck/Porch,Laundry Facilities,Patio,Pool,Condo Hotel Community" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2025-07-12T09:48:38.617518+00:00" +"DaysOnMarketReplicationDate": "2025-07-12" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 4 +"Flooring": "Ceramic Tile,Laminate" +"Furnished": "Furnished" +"Inclusions": "AC Window Unit,Drapes,Kitchenware,Linens,Microwave,Range/Oven,Refrigerator,Smoke Detector,Water Heater" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LeaseAmount": "359.46" +"LeaseExpiration": "2036-02-28" +"Levels": "One" +"ListAgentDirectPhone": "(808) 223-0429" +"ListAgentEmail": "TH@Invest808.com" +"ListAgentKey": "10763078" +"ListAgentKeyNumeric": "10763078" +"ListAgentOfficePhone": "(808) 735-2221" +"ListAgentPreferredPhone": "(808) 223-0429" +"ListAgentStateLicense": "RB-19372" +"ListOfficeEmail": "email@invest808.com" +"ListOfficeKey": "2588692" +"ListOfficeKeyNumeric": "2588692" +"ListOfficePhone": "(808) 735-2221" +"ListingContractDate": "2025-07-11" +"ListingKeyNumeric": 1119105537 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 623.28 +"MajorChangeTimestamp": "2025-07-11T23:47:26Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-07-11" +"OriginalListPrice": 99999.0 +"OriginatingSystemKey": "18862577" +"ParcelNumber": "1-2-6-021-102-0043" +"ParkingFeatures": "None" +"PhotosChangeTimestamp": "2025-11-11T00:21:13Z" +"PhotosCount": 19 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Key Card Entry,Fire Sprinkler System" +"SourceSystemKey": "1119105537" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Nohonani" +"StreetNumber": "417" +"StreetNumberNumeric": "417" +"StreetSuffix": "Street" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "5425.2" +"TaxAssessedValue": 309900 +"UnitNumber": "405" +"View": "City, Mountain(s)" +"ViewYN": true +"YearBuiltEffective": 2018 +"ZoningDescription": "X2 - Apartment Precinct" +"ListAOR": "HI Central" +"LandTenure": "Lease Hold" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1119105537"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 798.0 +"TaxAssessedValueLand": "210400" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "99500" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1119105537')" +"provider_name": "HICMLS" +"RecordSignature": -2104568448 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-021-102-0043" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3487074" +"OriginatingSystemListAgentMemberKey": "3475531" +"Media": array:19 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] ] +"ID": "55058" } ] +success: true +page_size: 9 +page_count: 411 +count: 3698 +after_key: "" } "RF Response Time" => "0.23 seconds" ] ]
