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=4275&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#6339 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6354 +post_id: "61043" +post_author: 1 +"ListingKey": "1144237121" +"ListingId": "202524044" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-22T01:26:31Z" +"RFModificationTimestamp": "2025-11-11T15:52:10Z" +"ListPrice": 1228000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 706.0 +"BuildingAreaTotal": 744.0 +"City": "Honolulu" +"PostalCode": "96813" +"UnparsedAddress": "1538 Kapiolani Boulevard 3303, Honolulu, Hawaii 96813" +"Coordinates": array:2 [ 0 => -157.8407881 1 => 21.2925614 ] +"Latitude": 21.2925614 +"Longitude": -157.8407881 +"YearBuilt": 2028 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kelly Wu" +"ListOfficeName": "Associated Real Estate Advisor" +"ListAgentMlsId": "47304" +"ListOfficeMlsId": "AREA" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Introducing Muse Honolulu, Ala Moana’s newest luxury development featuring a dynamic collection of 315 thoughtfully designed residences, including two-story Townhomes, Urban Lofts, and Tower Residences. \r\n \r\n Tower Residence 3303 is an ideal one-bedroom plus den floor plan with 706 sqft of interior living and a 38 sqft lanai. This residence is thoughtfully appointed with floor-to-ceiling glass, premium Studio Becker cabinetry, and engineered wood flooring throughout the kitchen and living area. The gourmet kitchen is equipped with top-of-the-line Sub-Zero, Wolf, and Cove appliances. Enjoy approximately 9’3” ceiling heights and an elevated urban lifestyle enhanced by three levels of resort-style amenities. All this, just moments from world-class shopping, dining, and entertainment at Ala Moana. *Photos are renderings and/or enhanced images. Property tax information is not yet available as Muse Honolulu is a new development. Future tax assessments will be determined by the City & County of Honolulu upon project completion.\r\n CPR number has not yet been determined. The CPR number is not a valid CPR number and was used strictly for MLS input purposes. """ +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Sewer,Water" +"AttributionContact": "(808) 445-9199" +"BathroomsFull": 1 +"BuildingName": "Muse Honolulu" +"CoListAgentDirectPhone": "(808) 445-9199" +"CoListAgentEmail": "Laurie@associatedhawaii.com" +"CoListAgentFullName": "Laurie Kay Oh" +"CoListAgentKey": "10763389" +"CoListAgentKeyNumeric": "10763389" +"CoListAgentMlsId": "41080" +"CoListAgentPreferredPhone": "(808) 722-6615" +"CoListOfficeEmail": "kelly@associatedhawaii.com" +"CoListOfficeKey": "3167562" +"CoListOfficeKeyNumeric": "3167562" +"CoListOfficeMlsId": "AREA" +"CoListOfficeName": "Associated Real Estate Advisor" +"CoListOfficePhone": "(808) 445-9199" +"CommunityFeatures": "Barbecue,Clubhouse,Deck/Porch,Dog Park,Fitness,Other,Playground,Patio,Pool,Putting Green,Recreation Area,Sauna,Storage Facilities,Trash Chute" +"ConstructionMaterials": "Double Wall,Other,Concrete,Steel Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-10-22T01:26:46.204519+00:00" +"DaysOnMarketReplicationDate": "2025-10-21" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,See Remarks" +"EntryLevel": 33 +"Flooring": "Carpet, Hardwood, Other" +"Furnished": "Unfurnished" +"Inclusions": "AC Central,Auto Garage Door Opener,Dishwasher,Disposal,Dryer,Heat Pump,Microwave,Other,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater,Wine Refrigerator" +"InteriorFeatures": "Storage" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 228-0511" +"ListAgentEmail": "kellywu@associatedhawaii.com" +"ListAgentKey": "10779870" +"ListAgentKeyNumeric": "10779870" +"ListAgentOfficePhone": "(808) 445-9199" +"ListAgentPreferredPhone": "(808) 228-0511" +"ListAgentStateLicense": "RB-24150" +"ListOfficeEmail": "kelly@associatedhawaii.com" +"ListOfficeKey": "3167562" +"ListOfficeKeyNumeric": "3167562" +"ListOfficePhone": "(808) 445-9199" +"ListingContractDate": "2025-10-21" +"ListingKeyNumeric": 1144237121 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 931.92 +"MajorChangeTimestamp": "2025-10-21T15:25:16Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-10-21" +"OriginalListPrice": 1228000.0 +"OriginatingSystemKey": "19058826" +"ParcelNumber": "1-2-3-021-006-3303" +"ParkingFeatures": "Assigned,Covered,One Space,Secured" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 7 +"PoolFeatures": "Heated" +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Key Card Entry,Fire Sprinkler System" +"SourceSystemKey": "1144237121" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kapiolani" +"StreetNumber": "1538" +"StreetNumberNumeric": "1538" +"StreetSuffix": "Boulevard" +"SubdivisionName": "HOLIDAY MART" +"UnitNumber": "3303" +"View": "City, Mountain(s), Ocean" +"ViewYN": true +"ZoningDescription": "33 - BMX-3 Community Business M" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1144237121"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 932.0 +"TaxAssessedValueLand": "0" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1144237121')" +"provider_name": "HICMLS" +"RecordSignature": -43835166 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-021-006-3303" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15110879" +"OriginatingSystemCoListOfficeKey": "15110879" +"OriginatingSystemListAgentMemberKey": "10921220" +"OriginatingSystemCoListAgentMemberKey": "3482522" +"Media": array:7 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004538904837" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1144237121/f3da577124dda9e22a50e4f437e5450d.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 351312 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1144237121/thumbnail-f3da577124dda9e22a50e4f437e5450d.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10779870" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "3167562" "MediaCategory" => null "MediaObjectID" => "2.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "AREA" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004538904837 "PropertySubType" => "Condominium" "RecordSignature" => -2121974018 "PreferredPhotoYN" => null "ResourceRecordID" => "202524044" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1144237121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:56.957-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1144237121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19058839" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:21:56.957-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19058826" ] 1 => array:57 [ "Order" => 2 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004538904838" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1144237121/16905b594e4fd5a5543653aa6275cb82.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 248438 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1144237121/thumbnail-16905b594e4fd5a5543653aa6275cb82.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10779870" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "3167562" "MediaCategory" => null "MediaObjectID" => "1 plus den.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "AREA" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004538904838 "PropertySubType" => "Condominium" "RecordSignature" => -2121974018 "PreferredPhotoYN" => null "ResourceRecordID" => "202524044" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1144237121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:56.957-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1144237121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19058840" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:21:56.957-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19058826" ] 2 => array:57 [ "Order" => 3 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004538904839" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1144237121/67e0c87c52752dc9e7e5df6208c72c3a.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 430745 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1144237121/thumbnail-67e0c87c52752dc9e7e5df6208c72c3a.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10779870" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "3167562" "MediaCategory" => null "MediaObjectID" => "3.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "AREA" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004538904839 "PropertySubType" => "Condominium" "RecordSignature" => -2121974018 "PreferredPhotoYN" => null "ResourceRecordID" => "202524044" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1144237121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:56.957-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1144237121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19058841" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:21:56.957-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19058826" ] 3 => array:57 [ "Order" => 4 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004538904840" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1144237121/a59ff9e436332fbad732620d19966f8e.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 299578 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1144237121/thumbnail-a59ff9e436332fbad732620d19966f8e.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10779870" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "3167562" "MediaCategory" => null "MediaObjectID" => "4.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "AREA" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004538904840 "PropertySubType" => "Condominium" "RecordSignature" => -2121974018 "PreferredPhotoYN" => null "ResourceRecordID" => "202524044" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1144237121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:56.957-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1144237121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19058842" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:21:56.957-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19058826" ] 4 => array:57 [ "Order" => 5 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004538904841" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1144237121/d75218130603a2f707991cbb26700969.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 394477 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1144237121/thumbnail-d75218130603a2f707991cbb26700969.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10779870" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "3167562" "MediaCategory" => null "MediaObjectID" => "7.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "AREA" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004538904841 "PropertySubType" => "Condominium" "RecordSignature" => -2121974018 "PreferredPhotoYN" => null "ResourceRecordID" => "202524044" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1144237121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:56.957-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1144237121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19058843" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:21:56.957-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19058826" ] 5 => array:57 [ "Order" => 6 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004538904842" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1144237121/dcfc127adda4bf8bd1644a3837ef0d4e.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 278351 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1144237121/thumbnail-dcfc127adda4bf8bd1644a3837ef0d4e.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10779870" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "3167562" "MediaCategory" => null "MediaObjectID" => "8.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "AREA" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004538904842 "PropertySubType" => "Condominium" "RecordSignature" => -2121974018 "PreferredPhotoYN" => null "ResourceRecordID" => "202524044" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1144237121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:56.957-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1144237121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19058844" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:21:56.957-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19058826" ] 6 => array:57 [ "Order" => 7 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004538904843" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1144237121/9d0804748a297e1f8fca705e19653bd4.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 393956 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1144237121/thumbnail-9d0804748a297e1f8fca705e19653bd4.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10779870" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "3167562" "MediaCategory" => null "MediaObjectID" => "amenities-128.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "AREA" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004538904843 "PropertySubType" => "Condominium" "RecordSignature" => -2121974018 "PreferredPhotoYN" => null "ResourceRecordID" => "202524044" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1144237121" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:56.957-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1144237121 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19058845" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:21:56.957-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19058826" ] ] +"ID": "61043" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6352 +post_id: "57893" +post_author: 1 +"ListingKey": "1129840947" +"ListingId": "202518881" +"PropertyType": "Business Opportunity" +"PropertySubType": "Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-27T04:06:58Z" +"RFModificationTimestamp": "2025-11-11T18:33:53Z" +"ListPrice": 89000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 8173.0 +"LivingArea": 0 +"BuildingAreaTotal": 510.0 +"City": "Honolulu" +"PostalCode": "96819" +"UnparsedAddress": "2021 N King Street 2, Honolulu, Hawaii 96819" +"Coordinates": array:2 [ 0 => -157.878791 1 => 21.3326454 ] +"Latitude": 21.3326454 +"Longitude": -157.878791 +"YearBuilt": 1966 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kwang Suk Tabbal" +"ListOfficeName": "Kwang Suk Tabbal" +"ListAgentMlsId": "09141" +"ListOfficeMlsId": "MAHA" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Well known convenient store in this location. Right on main street with street parking. Call listing agent for more information." +"AttributionContact": "(808) 330-2557" +"BuildingFeatures": "Private Restrooms" +"BusinessName": "Happy Snack Shop" +"BusinessType": "Retail" +"ConstructionMaterials": "Double Wall" +"CountyOrParish": "Oahu" +"CreationDate": "2025-08-27T04:11:26.547918+00:00" +"CurrentUse": "Commercial" +"DaysOnMarket": 235 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2025-08-27" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent" +"EntryLevel": 1 +"ExistingLeaseType": "Gross" +"HoursDaysOfOperation": "Open 8 Hours/Day" +"Inclusions": "Lease" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LeaseAmount": "2136.0" +"LeaseExpiration": "2030-03-31" +"Levels": "One" +"ListAgentDirectPhone": "(808) 330-2557" +"ListAgentEmail": "kwangmhrealty@gmail.com" +"ListAgentKey": "10767458" +"ListAgentKeyNumeric": "10767458" +"ListAgentOfficePhone": "(808) 330-2557" +"ListAgentPreferredPhone": "(808) 330-2557" +"ListAgentStateLicense": "RB-14443" +"ListOfficeEmail": "kwangmhrealty@gmail.com" +"ListOfficeKey": "2586269" +"ListOfficeKeyNumeric": "2586269" +"ListOfficePhone": "(808) 330-2557" +"ListingContractDate": "2025-08-25" +"ListingKeyNumeric": 1129840947 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2025-08-26T18:06:37Z" +"MlsStatus": "Active" +"NetOperatingIncome": 1.0 +"NumberOfUnitsTotal": "5" +"OnMarketDate": "2025-08-25" +"OperatingExpense": "1.0" +"OriginalListPrice": 89000.0 +"OriginatingSystemKey": "18947666" +"ParcelNumber": "1-1-2-011-046-0000" +"ParkingFeatures": "Off Site" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 5 +"PostalCity": "Honolulu" +"RoadFrontageType": "City Street" +"Sewer": "Connected" +"SourceSystemKey": "1129840947" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StoriesTotal": "1" +"StreetDirPrefix": "N" +"StreetName": "King" +"StreetNumber": "2021" +"StreetNumberNumeric": "2021" +"StreetSuffix": "Street" +"SubdivisionName": "KAPALAMA" +"TaxAnnualAmount": "12.0" +"TaxAssessedValue": 2581800 +"TenantPays": "All Utilities,Common Area Maintenance,Insurance,Taxes" +"TotalActualRent": 1.0 +"UnitNumber": "2" +"Utilities": "Sewer Connected" +"ZoningDescription": "33 - BMX-3 Community Business M" +"ListAOR": "HI Central" +"LandTenure": "Lease Hold" +"CustomFields": """ {\n "ListingKey": "1129840947"\n } """ +"HumanModifiedYN": true +"TaxAssessedValueLand": "1961500" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "620300" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1129840947')" +"provider_name": "HICMLS" +"RecordSignature": 579476905 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-2-011-046-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3484651" +"OriginatingSystemListAgentMemberKey": "3472689" +"Media": array:5 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004255019363" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1129840947/30ceadb7d792d2b858d7e6e3e6209396.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 540835 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1129840947/thumbnail-30ceadb7d792d2b858d7e6e3e6209396.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10767458" "PropertyType" => "Business Opportunity" "ResourceName" => "Property" "ListOfficeKey" => "2586269" "MediaCategory" => null "MediaObjectID" => "1000008527.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "MAHA" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004255019363 "PropertySubType" => "Business" "RecordSignature" => 301433783 "PreferredPhotoYN" => null "ResourceRecordID" => "202518881" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1129840947" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:53.517-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1129840947 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18947673" "PropertySubTypeAdditional" => "Business" "MediaModificationTimestamp" => "2025-11-11T00:21:53.517-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18947666" ] 1 => array:57 [ "Order" => 2 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004255019364" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1129840947/fffb6dce7d53a65c4ebb13b49b562cf0.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 642946 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1129840947/thumbnail-fffb6dce7d53a65c4ebb13b49b562cf0.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10767458" "PropertyType" => "Business Opportunity" "ResourceName" => "Property" "ListOfficeKey" => "2586269" "MediaCategory" => null "MediaObjectID" => "1000008528.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "MAHA" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004255019364 "PropertySubType" => "Business" "RecordSignature" => 301433783 "PreferredPhotoYN" => null "ResourceRecordID" => "202518881" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1129840947" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:53.517-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1129840947 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18947674" "PropertySubTypeAdditional" => "Business" "MediaModificationTimestamp" => "2025-11-11T00:21:53.517-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18947666" ] 2 => array:57 [ "Order" => 3 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004255019365" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1129840947/133b9af005853c23ab8cd1116073371b.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 607712 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1129840947/thumbnail-133b9af005853c23ab8cd1116073371b.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10767458" "PropertyType" => "Business Opportunity" "ResourceName" => "Property" "ListOfficeKey" => "2586269" "MediaCategory" => null "MediaObjectID" => "1000008530.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "MAHA" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004255019365 "PropertySubType" => "Business" "RecordSignature" => 301433783 "PreferredPhotoYN" => null "ResourceRecordID" => "202518881" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1129840947" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:53.517-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1129840947 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18947675" "PropertySubTypeAdditional" => "Business" "MediaModificationTimestamp" => "2025-11-11T00:21:53.517-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18947666" ] 3 => array:57 [ "Order" => 4 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004255019366" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1129840947/c4085da6de8c6522bef696e19897d317.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 695527 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1129840947/thumbnail-c4085da6de8c6522bef696e19897d317.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10767458" "PropertyType" => "Business Opportunity" "ResourceName" => "Property" "ListOfficeKey" => "2586269" "MediaCategory" => null "MediaObjectID" => "1000008531.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "MAHA" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004255019366 "PropertySubType" => "Business" "RecordSignature" => 301433783 "PreferredPhotoYN" => null "ResourceRecordID" => "202518881" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1129840947" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:53.517-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1129840947 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18947676" "PropertySubTypeAdditional" => "Business" "MediaModificationTimestamp" => "2025-11-11T00:21:53.517-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18947666" ] 4 => array:57 [ "Order" => 5 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004255019367" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1129840947/3a65c182a007cbe1492b69f785e43b48.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 715903 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1129840947/thumbnail-3a65c182a007cbe1492b69f785e43b48.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10767458" "PropertyType" => "Business Opportunity" "ResourceName" => "Property" "ListOfficeKey" => "2586269" "MediaCategory" => null "MediaObjectID" => "1000008532.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "MAHA" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004255019367 "PropertySubType" => "Business" "RecordSignature" => 301433783 "PreferredPhotoYN" => null "ResourceRecordID" => "202518881" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1129840947" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:53.517-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1129840947 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18947677" "PropertySubTypeAdditional" => "Business" "MediaModificationTimestamp" => "2025-11-11T00:21:53.517-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18947666" ] ] +"ID": "57893" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6355 +post_id: "60082" +post_author: 1 +"ListingKey": "1137629465" +"ListingId": "202521657" +"PropertyType": "Land" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-04T22:19:07Z" +"RFModificationTimestamp": "2025-11-11T14:11:11Z" +"ListPrice": 985000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 173369.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Honolulu" +"PostalCode": "96816" +"UnparsedAddress": "2755 Lai Road, Honolulu, Hawaii 96816" +"Coordinates": array:2 [ 0 => -157.7855812 1 => 21.3123617 ] +"Latitude": 21.3123617 +"Longitude": -157.7855812 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Anne Hogan Perry" +"ListOfficeName": "Compass" +"ListAgentMlsId": "21474" +"ListOfficeMlsId": "COHI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Rarely available 3.98-acre parcel on La'i road in Palolo, minutes from the freeway, Kahala Mall, beaches, restaurants, schools, and more. Featuring panoramic ocean and mountain views, this special property provides the opportunity to build your dream home (Zoned P-1 with an allowable 5,000 square foot home). This parcel offers the convenience of town living while affording privacy and the quiet of the country. Located on a private lane in the back of Palolo Valley" +"AttributionContact": "(808) 825-4277" +"BusinessType": "Florist/Nursery" +"CountyOrParish": "Oahu" +"CreationDate": "2025-10-03T21:07:58.096780+00:00" +"CurrentUse": "Agricultural, Other" +"DaysOnMarket": 198 +"DaysOnMarketReplication": 34 +"DaysOnMarketReplicationDate": "2025-11-04" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "1031 Exchange,Seller Disclosure" +"FrontageType": "Preservation" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 825-4277" +"ListAgentEmail": "anneperry@compass.com" +"ListAgentKey": "10772330" +"ListAgentKeyNumeric": "10772330" +"ListAgentOfficePhone": "(808) 825-4277" +"ListAgentPreferredPhone": "(808) 825-4277" +"ListAgentStateLicense": "RB-15815" +"ListOfficeEmail": "julie.meier@compass.com" +"ListOfficeKey": "3944102" +"ListOfficeKeyNumeric": "3944102" +"ListOfficePhone": "(808) 825-4277" +"ListingContractDate": "2025-10-01" +"ListingKeyNumeric": 1137629465 +"ListingService": "Full Service" +"LotFeatures": "Interior Lot,Irregular Lot,Wooded,Level" +"MLSAreaMajor": "Diamond Hd" +"MajorChangeTimestamp": "2025-10-03T11:04:38Z" +"MlsStatus": "Active" +"NumberOfLots": "1" +"OnMarketDate": "2025-10-01" +"OriginalListPrice": 985000.0 +"OriginatingSystemKey": "19014213" +"ParcelNumber": "1-3-4-021-002-0000" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 2 +"PossibleUse": "Farm,Nursery,Single Family" +"PostalCity": "Honolulu" +"RoadFrontageType": "Private Road,Easement" +"Sewer": "None" +"SourceSystemKey": "1137629465" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Lai" +"StreetNumber": "2755" +"StreetNumberNumeric": "2755" +"StreetSuffix": "Road" +"SubdivisionName": "PALOLO" +"TaxAnnualAmount": "2472.0" +"TaxAssessedValue": 423800 +"Topography": "Level, Other, Sloping" +"Utilities": "Above Ground Utilities,Electricity Available,Water Available,Sewer Not Available" +"View": "City, Garden, Mountain(s), Ocean" +"ViewYN": true +"WaterSource": "Public" +"ZoningDescription": "61 - P-1 Restricted Preservatio" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1137629465"\n } """ +"Restrictions": "Other Restrictions" +"HumanModifiedYN": true +"TaxAssessedValueLand": "432800" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1137629465')" +"provider_name": "HICMLS" +"RecordSignature": -2104460943 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-3-4-021-002-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15465233" +"OriginatingSystemListAgentMemberKey": "3474025" +"Media": array:2 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004454120587" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1137629465/0375f462bd01b7166f78bba91bfa3931.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 38147 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1137629465/thumbnail-0375f462bd01b7166f78bba91bfa3931.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772330" "PropertyType" => "Land" "ResourceName" => "Property" "ListOfficeKey" => "3944102" "MediaCategory" => null "MediaObjectID" => "1 (1).jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "COHI" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004454120587 "PropertySubType" => "Land" "RecordSignature" => 1273849700 "PreferredPhotoYN" => null "ResourceRecordID" => "202521657" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1137629465" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:45.423-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1137629465 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19015053" "PropertySubTypeAdditional" => "Land" "MediaModificationTimestamp" => "2025-11-11T00:21:45.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19014213" ] 1 => array:57 [ "Order" => 2 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004461255158" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1137629465/b71d9483646cc6fe17cafcc1e194adac.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 55434 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1137629465/thumbnail-b71d9483646cc6fe17cafcc1e194adac.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772330" "PropertyType" => "Land" "ResourceName" => "Property" "ListOfficeKey" => "3944102" "MediaCategory" => null "MediaObjectID" => "2.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "COHI" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004461255158 "PropertySubType" => "Land" "RecordSignature" => 1823378508 "PreferredPhotoYN" => null "ResourceRecordID" => "202521657" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1137629465" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:04.287-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1137629465 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19016892" "PropertySubTypeAdditional" => "Land" "MediaModificationTimestamp" => "2025-11-11T00:21:04.287-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19014213" ] ] +"ID": "60082" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6351 +post_id: "49503" +post_author: 1 +"ListingKey": "1062077754" +"ListingId": "202404884" +"PropertyType": "For Sale" +"PropertySubType": "Multi Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-05T23:11:17Z" +"RFModificationTimestamp": "2025-11-11T19:44:16Z" +"ListPrice": 5000000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 6925.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Honolulu" +"PostalCode": "96822" +"UnparsedAddress": "1254 Lunalilo Street, Honolulu, Hawaii 96822" +"Coordinates": array:2 [ 0 => -157.84103738408 1 => 21.303310804026 ] +"Latitude": 21.303310804026 +"Longitude": -157.84103738408 +"YearBuilt": 1969 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Derek C Lau" +"ListOfficeName": "Real Estate Specialists" +"ListAgentMlsId": "27536" +"ListOfficeMlsId": "HRES" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Do you desire to expand your growing investment portfolio with a centrally-located multiunit property? Check out the possibilities of 1254 Lunalilo Street! Tucked away in an extremely convenient area is this 15-unit concrete multiunit building featuring a desirable 1:1 parking ratio, separate electric meters, and a secured laundry area with two washers, two dryers, and a utility sink. Boasting 12-one bedroom units and 3-two bedroom units, the property allows for maximum resident comfort. Each unit features an open layout, neutral interior paint, a spacious living/dining area, storage closets, and a fully-equipped kitchen with a gas stove, pantry, and ample cabinets. Bedrooms are well-sized with generous closet space, while each full bathroom includes a shower/tub combo, medicine cabinet, and a storage vanity. Outdoor relaxation is a breeze with all units featuring a cozy balcony. Tenants will enjoy easy access to transportation, shopping, restaurants, entertainment, and Makiki Park. NOI is actual. Please contact Listor with additional questions. Interior showings will be subjected to accepted offer. Please submit offers using the Commercial PSA. DO NOT DISTURB tenants." +"Appliances": "Dryer, Washer" +"AssociationAmenities": "Management" +"AttributionContact": "(808) 791-3709" +"CLIP": 8434243511 +"ConstructionMaterials": "Hollow Tile,Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2025-04-07T23:57:32.584035+00:00" +"DaysOnMarket": 772 +"DaysOnMarketReplication": 336 +"DaysOnMarketReplicationDate": "2025-02-05" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent" +"Furnished": "Partially" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Coin-operated" +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 347-8005" +"ListAgentEmail": "derek.lau@reshawaii.com" +"ListAgentKey": "10772698" +"ListAgentKeyNumeric": "10772698" +"ListAgentOfficePhone": "(808) 791-3709" +"ListAgentPreferredPhone": "(808) 347-8005" +"ListAgentStateLicense": "RB-19796" +"ListOfficeEmail": "info@hrespecialists.com" +"ListOfficeKey": "2585530" +"ListOfficeKeyNumeric": "2585530" +"ListOfficePhone": "(808) 791-3709" +"ListingContractDate": "2024-03-06" +"ListingKeyNumeric": 1062077754 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Level" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2024-03-06T16:44:46Z" +"MlsStatus": "Active" +"NetOperatingIncome": 126218.0 +"NumberOfUnitsTotal": "15" +"OnMarketDate": "2024-03-06" +"OperatingExpense": "68044.0" +"OperatingExpenseIncludes": "Insurance,Manager,Maintenance,Real Estate Tax,New Tax,Water/Sewer" +"OriginalListPrice": 5000000.0 +"OriginatingSystemKey": "17863946" +"ParcelNumber": "1-2-4-020-017-0000" +"ParkingFeatures": "Assigned" +"ParkingTotal": "15.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 13 +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"Sewer": "Connected" +"SourceSystemKey": "1062077754" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Lunalilo" +"StreetNumber": "1254" +"StreetNumberNumeric": "1254" +"StreetSuffix": "Street" +"StructureType": "Apartment" +"SubdivisionName": "MAKIKI AREA" +"TaxAnnualAmount": "7176.0" +"TaxAssessedValue": 2047300 +"TenantPays": "Cable TV,Electricity" +"Topography": "Level" +"TotalActualRent": 16150.0 +"Utilities": "Cable Available,Electricity Available,Natural Gas Available,High Speed Internet Available,Phone Available,Underground Utilities,Water Available,Sewer Connected" +"View": "City" +"ViewYN": true +"VirtualTourURLUnbranded": "https://listings.hetproductions.com/videos/e1ea917a-a3e7-4c1b-aefe-57b9e9dc3b09" +"WaterSource": "Public" +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "UnitThreeBedNumberOf": "0",\n "StudioUnitsNumberOf": "0",\n "UnitOneBedNumberOf": "12",\n "UtilitiesMeters": "Electric,Individual",\n "OtherIncome": "38.50",\n "TotalIncome": "194262.00",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "1246900.00",\n "LockBoxModDT": "2024-03-06T16:07:30.250",\n "UnitTwoBedNumberOf": "3",\n "TaxAssessedValueImprovements": "800400.00",\n "SetBacks": "Of Record",\n "Easements": "None",\n "ListingKey": "1062077754",\n "StreetViewParam": "1$21.303263$-157.84058$285.69$13.33$1.00$IxVEBXja-77_mUQ4qzw6vA",\n "LandRecorded": "Regular System",\n "CompensationSubjectTo": "",\n "SellingAgentRemarks": "",\n "CompensationMethod": "",\n "ShowingTimeFlagYN": "1"\n } """ +"HumanModifiedYN": true +"TaxAssessedValueLand": "1246900" +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "800400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1062077754')" +"provider_name": "HICMLS" +"RecordSignature": 888570919 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-4-020-017-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3487412" +"OriginatingSystemListAgentMemberKey": "3477175" +"Media": array:13 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003102366286" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1062077754/47a9105c6c7838ffa912ae6745c55cbe.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 553850 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1062077754/thumbnail-47a9105c6c7838ffa912ae6745c55cbe.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772698" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2585530" "MediaCategory" => null "MediaObjectID" => "1 Street View.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "HRES" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003102366286 "PropertySubType" => "Multi Family" "RecordSignature" => -410530000 "PreferredPhotoYN" => null "ResourceRecordID" => "202404884" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1062077754" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:41.497-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1062077754 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "17864016" "PropertySubTypeAdditional" => "Multi Family" "MediaModificationTimestamp" => "2025-11-11T00:21:41.497-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "17863946" ] 1 => array:57 [ "Order" => 2 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003102366287" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1062077754/2fb5c28e387463b7fb18a9f15f47d46d.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 598334 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1062077754/thumbnail-2fb5c28e387463b7fb18a9f15f47d46d.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772698" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2585530" "MediaCategory" => null "MediaObjectID" => "2 Aerial 3.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "HRES" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003102366287 "PropertySubType" => "Multi Family" "RecordSignature" => -410530000 "PreferredPhotoYN" => null "ResourceRecordID" => "202404884" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1062077754" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:41.497-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1062077754 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "17864017" "PropertySubTypeAdditional" => "Multi Family" "MediaModificationTimestamp" => "2025-11-11T00:21:41.497-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "17863946" ] 2 => array:57 [ "Order" => 3 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003102366288" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1062077754/f1c71d9ad6fe3ddf3503e97f189a7062.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 643580 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1062077754/thumbnail-f1c71d9ad6fe3ddf3503e97f189a7062.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772698" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2585530" "MediaCategory" => null "MediaObjectID" => "3 Aerial 1.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "HRES" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003102366288 "PropertySubType" => "Multi Family" "RecordSignature" => -410530000 "PreferredPhotoYN" => null "ResourceRecordID" => "202404884" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1062077754" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:41.497-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1062077754 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "17864018" "PropertySubTypeAdditional" => "Multi Family" "MediaModificationTimestamp" => "2025-11-11T00:21:41.497-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "17863946" ] 3 => array:57 [ "Order" => 4 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003102366289" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1062077754/c8dd2fac4e1e9df2b9139b11fe8bf0dc.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 372840 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1062077754/thumbnail-c8dd2fac4e1e9df2b9139b11fe8bf0dc.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772698" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2585530" "MediaCategory" => null "MediaObjectID" => "4 Living Room.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "HRES" "LongDescription" => "1-Bedroom Unit Living Room Enhanced (Virtually\u{200B}\u{200B}\u{200C}\u{200B}\u{200B}\u{200B}\u{200B}\u{200C}\u{200B}\u{200B}\u{200C}\u{200C}\u{200B}\u{200C}\u{200C}\u{200B}\u{200B}\u{200B}\u{200C}\u{200C}\u{200B}\u{200C}\u{200B}\u{200C}\u{200B}\u{200C}\u{200B}\u{200B}\u{200B}\u{200C}\u{200B}\u{200B} Staged)" "MediaAlteration" => null "MediaKeyNumeric" => 2003102366289 "PropertySubType" => "Multi Family" "RecordSignature" => -410530000 "PreferredPhotoYN" => null "ResourceRecordID" => "202404884" "ShortDescription" => "1-Bedroom Unit Living Room Enhanced (Virtually Sta" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1062077754" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:41.497-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1062077754 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "17864019" "PropertySubTypeAdditional" => "Multi Family" "MediaModificationTimestamp" => "2025-11-11T00:21:41.497-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "17863946" ] 4 => array:57 [ "Order" => 5 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003102366290" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1062077754/118ecbac438e79126316c22af51dba48.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 312384 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1062077754/thumbnail-118ecbac438e79126316c22af51dba48.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772698" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2585530" "MediaCategory" => null "MediaObjectID" => "5 Kitchen.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "HRES" "LongDescription" => "1-Bedroom Unit Kitchen" "MediaAlteration" => null "MediaKeyNumeric" => 2003102366290 "PropertySubType" => "Multi Family" "RecordSignature" => -410530000 "PreferredPhotoYN" => null "ResourceRecordID" => "202404884" "ShortDescription" => "1-Bedroom Unit Kitchen" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1062077754" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:41.497-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1062077754 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "17864020" "PropertySubTypeAdditional" => "Multi Family" "MediaModificationTimestamp" => "2025-11-11T00:21:41.497-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "17863946" ] 5 => array:57 [ "Order" => 6 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003102366291" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1062077754/7642353a51cc03a4cd5231cef4c8513e.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 413019 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1062077754/thumbnail-7642353a51cc03a4cd5231cef4c8513e.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772698" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2585530" "MediaCategory" => null "MediaObjectID" => "6 Bedroom.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "HRES" "LongDescription" => "1-Bedroom Unit Enhanced (Virtually Staged)" "MediaAlteration" => null "MediaKeyNumeric" => 2003102366291 "PropertySubType" => "Multi Family" "RecordSignature" => -410530000 "PreferredPhotoYN" => null "ResourceRecordID" => "202404884" "ShortDescription" => "1-Bedroom Unit Enhanced (Virtually Staged)" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1062077754" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:41.497-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1062077754 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "17864021" "PropertySubTypeAdditional" => "Multi Family" "MediaModificationTimestamp" => "2025-11-11T00:21:41.497-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "17863946" ] 6 => array:57 [ "Order" => 7 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003102366292" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1062077754/39be6b2cad1be3316fb5e1cef96c48bd.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 278360 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1062077754/thumbnail-39be6b2cad1be3316fb5e1cef96c48bd.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772698" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2585530" "MediaCategory" => null "MediaObjectID" => "7 Bedroom 2.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "HRES" "LongDescription" => "1-Bedroom" "MediaAlteration" => null "MediaKeyNumeric" => 2003102366292 "PropertySubType" => "Multi Family" "RecordSignature" => -410530000 "PreferredPhotoYN" => null "ResourceRecordID" => "202404884" "ShortDescription" => "1-Bedroom" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1062077754" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:41.497-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1062077754 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "17864022" "PropertySubTypeAdditional" => "Multi Family" "MediaModificationTimestamp" => "2025-11-11T00:21:41.497-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "17863946" ] 7 => array:57 [ "Order" => 8 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003102366293" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1062077754/b918419b0513f342b158e38534e8226c.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 241644 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1062077754/thumbnail-b918419b0513f342b158e38534e8226c.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772698" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2585530" "MediaCategory" => null "MediaObjectID" => "8 Closet.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "HRES" "LongDescription" => "1-Bedroom Closet" "MediaAlteration" => null "MediaKeyNumeric" => 2003102366293 "PropertySubType" => "Multi Family" "RecordSignature" => -410530000 "PreferredPhotoYN" => null "ResourceRecordID" => "202404884" "ShortDescription" => "1-Bedroom Closet" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1062077754" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:21:41.497-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1062077754 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "17864023" "PropertySubTypeAdditional" => "Multi Family" "MediaModificationTimestamp" => "2025-11-11T00:21:41.497-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "17863946" ] 8 => array:57 [ "Order" => 9 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003102366294" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1062077754/f8482d4a501d6b322889b43f365db919.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 236475 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1062077754/thumbnail-f8482d4a501d6b322889b43f365db919.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772698" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2585530" "MediaCategory" => null "MediaObjectID" => "9 Bathroom.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "HRES" "LongDescription" => "1-Bedroom Bathroom" "MediaAlteration" => null "MediaKeyNumeric" => 2003102366294 "PropertySubType" => "Multi Family" "RecordSignature" => -410530000 "PreferredPhotoYN" => null "ResourceRecordID" => "202404884" "ShortDescription" => "1-Bedroom Bathroom" "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1062077754" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null …14 ] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] ] +"ID": "49503" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6353 +post_id: "60178" +post_author: 1 +"ListingKey": "1134754485" +"ListingId": "202520538" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-05T01:35:29Z" +"RFModificationTimestamp": "2025-11-11T16:18:55Z" +"ListPrice": 2700000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 7.0 +"LotSizeArea": 11325.0 +"LivingArea": 3879.0 +"BuildingAreaTotal": 4239.0 +"City": "Laie" +"PostalCode": "96762" +"UnparsedAddress": "55-123 Naupaka Street, Laie, Hawaii 96762" +"Coordinates": array:2 [ 0 => -157.91806 1 => 21.6481609 ] +"Latitude": 21.6481609 +"Longitude": -157.91806 +"YearBuilt": 1980 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Paul M Javier" +"ListOfficeName": "HomeSmart Island Homes" +"ListAgentMlsId": "34149" +"ListOfficeMlsId": "HSIH" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Breathtaking and stunning panoramic ocean views! Enjoy the soothings sound of the ocean, beautiful sunset, and stargazing from this quiet, private oceanfront home on Laie Point. This 3,879 square foot 7 bedroom 4 1/2 bathroom home could either be lived in as one large home, or as two separate units: a 5 bedroom 2 1/2 bathroom home upstairs and a 2 bedroom 1 bathroom Ohana with full wet bar. Very close to a long white sandy beach, this beautiful home features an open floor plan with high vaulted ceilings, and spacious lanais. Very close to the Ritz Carlton Turtle Bay Resort, BYUH, the Polynesian Cultural Center, world class golf and surfing, restaurants, and shopping. Very easy to view on short notice. Welcome home to paradise!" +"ArchitecturalStyle": "Detached" +"AttributionContact": "(808) 729-7643" +"BathroomsFull": 4 +"CommunityFeatures": "Deck/Porch,Patio,Storage Facilities" +"ConstructionMaterials": "Double Wall,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-10-05T01:39:20.421191+00:00" +"DaysOnMarketReplicationDate": "2025-10-04" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Laie" +"Fencing": "Fenced, Wall" +"Flooring": "Ceramic Tile" +"FrontageType": "Oceanfront, Waterfront" +"Furnished": "Negotiable" +"GarageYN": true +"HighSchool": "Kahuku" +"Inclusions": "Attic Fan,Auto Garage Door Opener,Blinds,Cable TV,Ceiling Fan,Dishwasher,Disposal,Dryer,Range/Oven,Refrigerator,Washer,Water Heater" +"InteriorFeatures": "Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 232-1233" +"ListAgentEmail": "pmjavier@gmail.com" +"ListAgentKey": "10777925" +"ListAgentKeyNumeric": "10777925" +"ListAgentOfficePhone": "(808) 729-7643" +"ListAgentPreferredPhone": "(808) 232-1233" +"ListAgentStateLicense": "RB-20364" +"ListOfficeEmail": "tiffanysellshawaii@gmail.com" +"ListOfficeKey": "2974462" +"ListOfficeKeyNumeric": "2974462" +"ListOfficePhone": "(808) 729-7643" +"ListingContractDate": "2025-10-04" +"ListingKeyNumeric": 1134754485 +"ListingService": "Full Service" +"LotFeatures": "Flag Lot,Interior Lot,Level" +"MLSAreaMajor": "North Shore" +"MajorChangeTimestamp": "2025-10-04T15:35:12Z" +"MiddleOrJuniorSchool": "Kahuku" +"MlsStatus": "Active" +"OnMarketDate": "2025-10-04" +"OriginalListPrice": 2700000.0 +"OriginatingSystemKey": "18985611" +"ParcelNumber": "1-5-5-011-062-0000" +"ParkingFeatures": "Driveway,Garage,Three or more Spaces,On Street" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Laie" +"PropertyCondition": "Good Condition,Updated/Remodeled" +"RoadFrontageType": "County Road" +"RoomType": "Entry/Foyer" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1134754485" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Naupaka" +"StreetNumber": "55-123" +"StreetSuffix": "Street" +"SubdivisionName": "LAIE" +"TaxAnnualAmount": "15780.0" +"TaxAssessedValue": 2033500 +"Topography": "Level, Terraced" +"Utilities": "Cable Available,High Speed Internet Available,Phone Available,Sewer Available,Water Available" +"View": "Coastline, Mountain(s), Ocean, Sunset" +"ViewYN": true +"WaterSource": "Public" +"WaterfrontYN": true +"YearBuiltEffective": 2005 +"ZoningDescription": "04 - R-7.5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1134754485"\n } """ +"HumanModifiedYN": true +"TaxAssessedValueLand": "942900" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "1090600" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1134754485')" +"provider_name": "HICMLS" +"RecordSignature": 1722184528 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-5-5-011-062-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "13236725" +"OriginatingSystemListAgentMemberKey": "3480062" +"Media": array:25 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] 22 => array:57 [ …57] 23 => array:57 [ …57] 24 => array:57 [ …57] ] +"ID": "60178" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6356 +post_id: "61149" +post_author: 1 +"ListingKey": "1144559677" +"ListingId": "202524159" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-24T08:01:14Z" +"RFModificationTimestamp": "2025-11-11T13:38:24Z" +"ListPrice": 1100000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 674.0 +"BuildingAreaTotal": 776.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "2139 Kuhio Avenue 2401, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ 0 => -157.829508 1 => 21.2822642 ] +"Latitude": 21.2822642 +"Longitude": -157.829508 +"YearBuilt": 2018 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Miki Kojima" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "52456" +"ListOfficeMlsId": "CBPP" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Experience the ultimate luxury lifestyle at The Ritz-Carlton Residences Waikiki Beach. This stunning high-floor corner unit offers\r\n breathtaking panoramic views of the Pacific Ocean, Waikiki skyline, and lush mountains. Fully furnished with elegant designer pieces and equipped with high-end kitchen appliances, this residence features floor-to-ceiling windows and spacious living areas that blend indoor and outdoor living. Enjoy five-star amenities including infinity pools, a full-service spa, concierge, valet, and fine dining—all just steps away from world-famous beaches and shopping. Plus, enjoy a front-row seat to Waikiki’s spectacular Friday night fireworks from your residence """ +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Concierge" +"AssociationFee2": "229.0" +"AssociationFeeIncludes": "Common Areas,Cable TV,Hot Water,Internet,Sewer,Water" +"AttributionContact": "(808) 596-0456" +"BathroomsFull": 1 +"BuildingName": "The Ritz-Carlton Residences Twr 2 - 383 Kalaimoku" +"CommunityFeatures": "Concierge,Community Pool,Conference/Meeting Room,Fitness,Pool,Restaurant,Trash Chute" +"ConstructionMaterials": "Concrete" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2025-10-23T19:18:45.253815+00:00" +"DaysOnMarketReplicationDate": "2025-10-23" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"ElementarySchool": "Jefferson" +"EntryLevel": 24 +"Flooring": "Hardwood, Marble" +"FrontageType": "Other" +"Furnished": "Furnished" +"HighSchool": "Kaimuki" +"Inclusions": "AC Central,Cable TV,Dishwasher,Disposal,Drapes,Dryer,Kitchenware,Linens,Microwave,Range/Oven,Refrigerator,Washer,Wine Refrigerator" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 596-0456" +"ListAgentEmail": "miki.kojima@cbrealty.com" +"ListAgentKey": "21268166" +"ListAgentKeyNumeric": "21268166" +"ListAgentOfficePhone": "(808) 596-0456" +"ListAgentPreferredPhone": "(808) 596-0456" +"ListAgentStateLicense": "RS-85511" +"ListOfficeEmail": "mike.james@cbrealty.com" +"ListOfficeKey": "2586830" +"ListOfficeKeyNumeric": "2586830" +"ListOfficePhone": "(808) 596-0456" +"ListingContractDate": "2025-10-23" +"ListingKeyNumeric": 1144559677 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1495.81 +"MajorChangeTimestamp": "2025-10-23T09:13:23Z" +"MiddleOrJuniorSchool": "Washington" +"MlsStatus": "Active" +"OnMarketDate": "2025-10-23" +"OriginalListPrice": 1100000.0 +"OriginatingSystemKey": "19062230" +"ParcelNumber": "1-2-6-018-043-0144" +"ParkingFeatures": "Other, Valet" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 20 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent" +"SecurityFeatures": "Elevator Secured,Key Card Entry,Fire Sprinkler System" +"SourceSystemKey": "1144559677" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kuhio" +"StreetNumber": "2139" +"StreetNumberNumeric": "2139" +"StreetSuffix": "Avenue" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "12564.0" +"TaxAssessedValue": 873700 +"UnitNumber": "2401" +"View": "Coastline, Ocean, Sunset" +"ViewYN": true +"ZoningDescription": "X6 - Resort Mixed Use Precinct" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1144559677"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 1725.0 +"TaxAssessedValueLand": "133300" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "740400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1144559677')" +"provider_name": "HICMLS" +"RecordSignature": -189893710 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-018-043-0144" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485212" +"OriginatingSystemListAgentMemberKey": "16725366" +"Media": array:20 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] ] +"ID": "61149" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6357 +post_id: "61861" +post_author: 1 +"ListingKey": "1145736953" +"ListingId": "202524929" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-10T21:09:38Z" +"RFModificationTimestamp": "2025-11-11T13:55:58Z" +"ListPrice": 412000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 555.0 +"BuildingAreaTotal": 582.0 +"City": "Waipahu" +"PostalCode": "96797" +"UnparsedAddress": "94-302 Paiwa Street 202, Waipahu, Hawaii 96797" +"Coordinates": array:2 [ 0 => -158.0011874 1 => 21.38887 ] +"Latitude": 21.38887 +"Longitude": -158.0011874 +"YearBuilt": 2007 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Cathy M Peavy" +"ListOfficeName": "HomeSmart Island Homes" +"ListAgentMlsId": "42736" +"ListOfficeMlsId": "HSIH" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "SINGLE LEVEL 2 bedroom/1 bath/1 parking (open) corner unit. Nestled at the entrance of Waipahu and conveniently located near eateries, grocery stores, a pet hospital, the rail station and the bus route. Enjoy the breeze that comes through this second floor, single level unit. Perfect for first time home buyers, seniors or an investor, and VA loan approved. There are ceiling fans in the living area and in both bedrooms. The living area features an A/C window unit and laminate flooring. The first bedroom has vinyl plank flooring and brand new white blinds still in the box, that the Sellers will leave. The bathroom features vinyl flooring and the vanity was installed in 2025. The brand new stackable washer/dryer in the unit is just a few months old. There are tvs mounted to the wall in the living area and also in each bedroom that the Sellers are willing to leave for the Buyers. There is also an extra freezer in the unit that the Sellers are willing to leave for the Buyers. Pet friendly complex (verify). This unit is ready for you to make it your own and is being sold strictly as-is with no repairs." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Maintenance Grounds,Maintenance Structure,Sewer,Water" +"AttributionContact": "(808) 729-7643" +"BathroomsFull": 1 +"BuildingName": "Plantation Town Apartments" +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Clubhouse,Dog Park,Recreation Area,Trash Chute" +"ConstructionMaterials": "Double Wall,Other,Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2025-11-05T06:18:01.553236+00:00" +"DaysOnMarket": 164 +"DaysOnMarketReplication": 6 +"DaysOnMarketReplicationDate": "2025-11-10" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 2 +"Fencing": "Fenced, Wall" +"Flooring": "Carpet, Laminate, Vinyl" +"FrontageType": "Other" +"Furnished": "Unfurnished" +"HumanModifiedYN": true +"Inclusions": "AC Window Unit,Blinds,Ceiling Fan,Disposal,Drapes,Dryer,Microwave Hood,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More,One" +"ListAgentDirectPhone": "(808) 341-4177" +"ListAgentEmail": "cathy.homesmarthawaii@gmail.com" +"ListAgentKey": "10778264" +"ListAgentKeyNumeric": "10778264" +"ListAgentOfficePhone": "(808) 729-7643" +"ListAgentPreferredPhone": "(808) 341-4177" +"ListAgentStateLicense": "RB-21530" +"ListOfficeEmail": "tiffanysellshawaii@gmail.com" +"ListOfficeKey": "2974462" +"ListOfficeKeyNumeric": "2974462" +"ListOfficePhone": "(808) 729-7643" +"ListingContractDate": "2025-11-04" +"ListingKeyNumeric": 1145736953 +"ListingService": "Full Service" +"MLSAreaMajor": "Waipahu" +"MaintenanceExpense": 561.66 +"MajorChangeTimestamp": "2025-11-04T20:15:25Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-11-04" +"OpenParkingYN": true +"OriginalListPrice": 412000.0 +"OriginatingSystemKey": "19083481" +"ParcelNumber": "1-9-4-017-058-0178" +"ParkingFeatures": "Assigned,Guest,One Space,On Street,Secured" +"ParkingTotal": "1.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 12 +"PostalCity": "Waipahu" +"PropertyCondition": "Average Condition" +"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry,Fire Sprinkler System,Security Guard" +"SourceSystemKey": "1145736953" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Paiwa" +"StreetNumber": "94-302" +"StreetSuffix": "Street" +"SubdivisionName": "WAIPAHU-LOWER" +"TaxAnnualAmount": "882.36" +"TaxAssessedValue": 374300 +"UnitNumber": "202" +"View": "None" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1145736953"\n } """ +"AssociationFeeTotal": 562.0 +"TaxAssessedValueLand": "44700" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "329600" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1145736953')" +"provider_name": "HICMLS" +"RecordSignature": 1600183496 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-4-017-058-0178" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "13236725" +"OriginatingSystemListAgentMemberKey": "3483076" +"Media": array:12 [ 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] ] +"ID": "61861" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6449 +post_id: "59737" +post_author: 1 +"ListingKey": "1137028977" +"ListingId": "202521225" +"PropertyType": "Land" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-09-27T21:46:12Z" +"RFModificationTimestamp": "2025-11-11T19:58:11Z" +"ListPrice": 700000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 10500.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waianae" +"PostalCode": "96792" +"UnparsedAddress": "84-733 Fricke Street, Waianae, Hawaii 96792" +"Coordinates": array:2 [ 0 => -158.185272 1 => 21.446678 ] +"Latitude": 21.446678 +"Longitude": -158.185272 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lucy Liu Shen" +"ListOfficeName": "eXp Realty" +"ListAgentMlsId": "45737" +"ListOfficeMlsId": "EXPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Build your dream home in this desirable beach-loop location! This spacious 10,500 square foot lot is fully cleared and just footsteps away from a gorgeous beach, offering stunning sunsets and lovely mountain views. Nestled in a quiet neighborhood, it’s perfect for multi-generational living, with plans and permits in progress for two separate dwellings. With the water meter already installed and overhead electrical available, you’re ready to start building your ideal family retreat." +"AttributionContact": "(808) 725-2794" +"CountyOrParish": "Oahu" +"CreationDate": "2025-09-27T21:48:28.653448+00:00" +"CurrentUse": "Residential,Single Family" +"DaysOnMarketReplicationDate": "2025-09-27" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ExteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 358-2021" +"ListAgentEmail": "lucyliushen@gmail.com" +"ListAgentKey": "10779264" +"ListAgentKeyNumeric": "10779264" +"ListAgentOfficePhone": "(808) 725-2794" +"ListAgentPreferredPhone": "(808) 358-2021" +"ListAgentStateLicense": "RS-77203" +"ListOfficeEmail": "hi.broker@exprealty.net" +"ListOfficeKey": "2589160" +"ListOfficeKeyNumeric": "2589160" +"ListOfficePhone": "(808) 725-2794" +"ListingContractDate": "2025-09-27" +"ListingKeyNumeric": 1137028977 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Other, Level" +"MLSAreaMajor": "Leeward" +"MajorChangeTimestamp": "2025-09-27T11:46:02Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-09-27" +"OriginalListPrice": 700000.0 +"OriginatingSystemKey": "19003486" +"ParcelNumber": "1-8-4-006-044-0000" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 15 +"PossibleUse": "Multi-Family,Single Family" +"PostalCity": "Waianae" +"Sewer": "Other" +"SourceSystemKey": "1137028977" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Fricke" +"StreetNumber": "84-733" +"StreetSuffix": "Street" +"SubdivisionName": "MAKAHA" +"TaxAnnualAmount": "2064.0" +"TaxAssessedValue": 587300 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Electricity Available" +"View": "Mountain(s)" +"ViewYN": true +"ZoningDescription": "03 - R10 - Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1137028977"\n } """ +"Restrictions": "No Restrictions" +"HumanModifiedYN": true +"TaxAssessedValueLand": "587300" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1137028977')" +"provider_name": "HICMLS" +"RecordSignature": 1529599186 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-8-4-006-044-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10013908" +"OriginatingSystemListAgentMemberKey": "9802532" +"Media": array:15 [ 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] ] +"ID": "59737" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6344 +post_id: "58857" +post_author: 1 +"ListingKey": "1133725077" +"ListingId": "202520109" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-03T03:00:27Z" +"RFModificationTimestamp": "2025-11-11T20:17:43Z" +"ListPrice": 640000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 805.0 +"BuildingAreaTotal": 865.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "2233 Ala Wai Boulevard 12-c, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ 0 => -157.855676 1 => 21.304547 ] +"Latitude": 21.304547 +"Longitude": -157.855676 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Stanley Matecny" +"ListOfficeName": "REAL ESTATE AGENCY LLC" +"ListAgentMlsId": "34742" +"ListOfficeMlsId": "REAH" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "This well maintained, thoughtfully upgraded 1-BR and 1.5-bath unit has on option to convert the office space into a 2nd BR/guest room is located in a boutique Waikiki building with only three units per floor, offering added privacy and convenience. The pet-friendly building is ideally located near the International Market Place, Waikiki Beach, shopping, restaurants and entertainment putting the best of Honolulu at your doorstep. Enjoy beautiful mountains and Ala Wai Canal views from this bright and breezy unit. The unit includes 1 covered parking stall and additional storage. The interior highlights include bamboo flooring in the bedroom, tile flooring throughout the rest of the unit, custom kitchen cabinets for additional storage, new food disposal, new dishwasher, 30 cu. ft French door refrigerator, electric range with convection oven. The smaller of two remodeled bathrooms comes with a multifunctional stylish deep sink perfect for bathing pets. The building replaced all waste plumbing and installed new elevators. Don't miss your chance to live in one of Waikiki’s most desirable and well-kept and secured buildings with heated swimming pool, bike racks and secured surfboard room." +"ArchitecturalStyle": "High Rise" +"AssociationFeeIncludes": "Common Areas,Hot Water,None,Sewer,Water" +"AttributionContact": "(808) 923-7653" +"BathroomsFull": 1 +"BuildingName": "2233 Ala Wai" +"CommunityFeatures": "Pool" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2025-09-12T22:54:19.487536+00:00" +"DaysOnMarket": 218 +"DaysOnMarketReplication": 52 +"DaysOnMarketReplicationDate": "2025-11-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Jefferson" +"EntryLevel": 12 +"Flooring": "Ceramic Tile,Hardwood" +"FrontageType": "Canal,Golf Course" +"HighSchool": "Kaimuki" +"Inclusions": "Ceiling Fan,Dryer,Range Hood,Range/Oven,Refrigerator,Washer" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 232-9622" +"ListAgentEmail": "matecny@hotmail.com" +"ListAgentKey": "10777943" +"ListAgentKeyNumeric": "10777943" +"ListAgentOfficePhone": "(808) 923-7653" +"ListAgentPreferredPhone": "(808) 232-9622" +"ListAgentStateLicense": "RS-68973" +"ListOfficeEmail": "realestateagencyllc@gmail.com" +"ListOfficeKey": "2589183" +"ListOfficeKeyNumeric": "2589183" +"ListOfficePhone": "(808) 923-7653" +"ListingContractDate": "2025-09-11" +"ListingKeyNumeric": 1133725077 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1242.53 +"MajorChangeTimestamp": "2025-09-12T12:52:35Z" +"MiddleOrJuniorSchool": "Washington" +"MlsStatus": "Active" +"OnMarketDate": "2025-09-11" +"OriginalListPrice": 640000.0 +"OriginatingSystemKey": "18976336" +"ParcelNumber": "1-2-6-020-053-0032" +"ParkingFeatures": "Covered,One Space" +"ParkingTotal": "1.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 14 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent, Updated/Remodeled" +"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry" +"SourceSystemKey": "1133725077" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Ala Wai" +"StreetNumber": "2233" +"StreetNumberNumeric": "2233" +"StreetSuffix": "Boulevard" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "1488.0" +"TaxAssessedValue": 548000 +"UnitNumber": "12-C" +"View": "Canal,Golf Course,Mountain(s)" +"ViewYN": true +"YearBuiltEffective": 2017 +"ZoningDescription": "X2 - Apartment Precinct" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1133725077"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1243.0 +"TaxAssessedValueLand": "89500" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "458500" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1133725077')" +"provider_name": "HICMLS" +"RecordSignature": 1127590424 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-020-053-0032" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10154708" +"OriginatingSystemListAgentMemberKey": "3480270" +"Media": array:14 [ 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] ] +"ID": "58857" } ] +success: true +page_size: 9 +page_count: 481 +count: 4323 +after_key: "" } "RF Response Time" => "0.36 seconds" ] ]
