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=2628&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#6317 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6332 +post_id: "52356" +post_author: 1 +"ListingKey": "1114298333" +"ListingId": "202512414" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-11T00:09:46Z" +"RFModificationTimestamp": "2026-03-11T00:11:54Z" +"ListPrice": 395000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 84201.0 +"LivingArea": 616.0 +"BuildingAreaTotal": 616.0 +"City": "Waipahu" +"PostalCode": "96797" +"UnparsedAddress": "94-249 Waikele Road B214, Waipahu, Hawaii 96797" +"Coordinates": array:2 [ 0 => -158.009166 1 => 21.3866667 ] +"Latitude": 21.3866667 +"Longitude": -158.009166 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Joyce Anna Miller" +"ListOfficeName": "20 Degrees North Real Estate" +"ListAgentMlsId": "49927" +"ListOfficeMlsId": "DGRS" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Welcome home to Plantation View Hale! This lovely corner end, 2 bedroom 1 bath unit features, fresh paint, newer appliances, the popcorn ceiling has been removed throughout, updated bathroom, open kitchen layout, and freshly painted lanai. This unit has 1 dedicated parking stall, and 3 guest stalls with ample street parking. Conveniently located near bus stops, grocery stores, shopping, hwy." +"ArchitecturalStyle": "Low Rise" +"AssociationFee2": "75.0" +"AssociationFeeIncludes": "Common Areas,Electricity,Hot Water,Sewer,Water" +"AttributionContact": "(808) 388-5555" +"BathroomsFull": 1 +"BuildingName": "Plantation View Hale" +"CLIP": 3250824858 +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Community Pool,Pool" +"ConstructionMaterials": "Masonry, Stucco" +"CountyOrParish": "Oahu" +"CreationDate": "2025-05-20T02:56:40.626854+00:00" +"DaysOnMarket": 325 +"DaysOnMarketReplication": 295 +"DaysOnMarketReplicationDate": "2026-03-10" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,Pet on Property" +"EntryLevel": 2 +"Flooring": "Laminate" +"Furnished": "Negotiable" +"HumanModifiedYN": true +"Inclusions": "Ceiling Fan,Disposal,Drapes,Microwave,Range/Oven,Refrigerator,Smoke Detector,Water Heater" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 600-4255" +"ListAgentEmail": "joyceanna@20degreesn.com" +"ListAgentKey": "13403319" +"ListAgentKeyNumeric": "13403319" +"ListAgentOfficePhone": "(808) 388-5555" +"ListAgentPreferredPhone": "(808) 600-4255" +"ListAgentStateLicense": "RS-82536" +"ListOfficeEmail": "Chris@20Degrees N.com" +"ListOfficeKey": "2597471" +"ListOfficeKeyNumeric": "2597471" +"ListOfficePhone": "(808) 388-5555" +"ListingContractDate": "2025-05-19" +"ListingKeyNumeric": 1114298333 +"ListingService": "Full Service" +"MLSAreaMajor": "Waipahu" +"MaintenanceExpense": 665.0 +"MajorChangeTimestamp": "2025-12-04T11:31:36Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-05-19" +"OpenParkingYN": true +"OriginalListPrice": 398000.0 +"OriginatingSystemKey": "18758189" +"ParcelNumber": "1-9-4-010-038-0042" +"ParkingFeatures": "Assigned,Guest,One Space,On Street" +"ParkingTotal": "1.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2025-11-11T00:21:13Z" +"PhotosCount": 9 +"PostalCity": "Waipahu" +"PropertyCondition": "Good Condition,Updated/Remodeled" +"SourceSystemKey": "1114298333" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Waikele" +"StreetNumber": "94-249" +"StreetSuffix": "Road" +"SubdivisionName": "WAIPAHU-LOWER" +"TaxAnnualAmount": "900.0" +"TaxAssessedValue": 298000 +"UnitNumber": "B214" +"View": "Garden, Mountain(s)" +"ViewYN": true +"YearBuiltEffective": 2023 +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "CompensationSubjectTo": "",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "121600.00",\n "LockBoxModDT": "2025-05-19T16:23:15.020",\n "CompensationMethod": "",\n "SellingAgentRemarks": "",\n "ListingKey": "1114298333",\n "TaxAssessedValueImprovements": "176400.00",\n "LandRecorded": "Regular System",\n "FractionalOwnershipYN": "0",\n "ManagementCompanyName": "Hawaiiana",\n "StreetViewParam": "1$21.383398$-158.015719$84.70$13.33$1.00$0KstgMizxaoB9QLuQ8lPIA",\n "CondoParkingUnit": "38",\n "ElevatorsNumberOf": "0",\n "ManagementCompanyPhone": "808-593-9100",\n "ParkingAdditional": "3",\n "OwnerOccupancyPercentage": "61",\n "TaxExcemptionOwnerOccupancy": "No"\n } """ +"AssociationFeeTotal": 740.0 +"TaxAssessedValueLand": "121600" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "176400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1114298333')" +"provider_name": "HICMLS" +"RecordSignature": -2060760271 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-4-010-038-0042" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "12747418" +"OriginatingSystemListAgentMemberKey": "14804539" +"Media": array:9 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003992922274" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1114298333/8fa84aaf048d344d0ae7d8b3cd6c5939.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 32426 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1114298333/thumbnail-8fa84aaf048d344d0ae7d8b3cd6c5939.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13403319" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2597471" "MediaCategory" => null "MediaObjectID" => "hec.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "DGRS" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003992922274 "PropertySubType" => "Condominium" "RecordSignature" => 2022372373 "PreferredPhotoYN" => null "ResourceRecordID" => "202512414" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1114298333" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1114298333 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18758348" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18758189" ] 1 => array:57 [ "Order" => 2 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003992922275" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1114298333/8c7823b98e99323d6ea92e00eb675cb3.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 28569 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1114298333/thumbnail-8c7823b98e99323d6ea92e00eb675cb3.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13403319" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2597471" "MediaCategory" => null "MediaObjectID" => "hec1.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "DGRS" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003992922275 "PropertySubType" => "Condominium" "RecordSignature" => 2022372373 "PreferredPhotoYN" => null "ResourceRecordID" => "202512414" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1114298333" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1114298333 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18758349" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18758189" ] 2 => array:57 [ "Order" => 3 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003992922276" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1114298333/9dc60b51d6d00888f1901f804caab3fa.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 34878 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1114298333/thumbnail-9dc60b51d6d00888f1901f804caab3fa.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13403319" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2597471" "MediaCategory" => null "MediaObjectID" => "Hec2.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "DGRS" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003992922276 "PropertySubType" => "Condominium" "RecordSignature" => 2022372373 "PreferredPhotoYN" => null "ResourceRecordID" => "202512414" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1114298333" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1114298333 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18758350" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18758189" ] 3 => array:57 [ "Order" => 4 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003992922277" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1114298333/4812d389f179d33209e5302a6f8aab72.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 33172 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1114298333/thumbnail-4812d389f179d33209e5302a6f8aab72.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13403319" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2597471" "MediaCategory" => null "MediaObjectID" => "hec6.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "DGRS" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003992922277 "PropertySubType" => "Condominium" "RecordSignature" => 2022372373 "PreferredPhotoYN" => null "ResourceRecordID" => "202512414" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1114298333" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1114298333 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18758351" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18758189" ] 4 => array:57 [ "Order" => 5 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003992922278" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1114298333/a0b5ce54a5dcdcd0b3e3095ca802e2a3.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 23381 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1114298333/thumbnail-a0b5ce54a5dcdcd0b3e3095ca802e2a3.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13403319" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2597471" "MediaCategory" => null "MediaObjectID" => "hec5.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "DGRS" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003992922278 "PropertySubType" => "Condominium" "RecordSignature" => 2022372373 "PreferredPhotoYN" => null "ResourceRecordID" => "202512414" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1114298333" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1114298333 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18758352" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18758189" ] 5 => array:57 [ "Order" => 6 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003992922279" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1114298333/6f05bc1fed6d83c6f66b33cd9ae81a5f.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 28071 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1114298333/thumbnail-6f05bc1fed6d83c6f66b33cd9ae81a5f.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13403319" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2597471" "MediaCategory" => null "MediaObjectID" => "hec4.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "DGRS" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003992922279 "PropertySubType" => "Condominium" "RecordSignature" => 2022372373 "PreferredPhotoYN" => null "ResourceRecordID" => "202512414" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1114298333" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1114298333 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18758353" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18758189" ] 6 => array:57 [ "Order" => 7 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003992922280" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1114298333/532a594aac45140b038a3c3729646581.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 30691 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1114298333/thumbnail-532a594aac45140b038a3c3729646581.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13403319" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2597471" "MediaCategory" => null "MediaObjectID" => "hec3.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "DGRS" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003992922280 "PropertySubType" => "Condominium" "RecordSignature" => 2022372373 "PreferredPhotoYN" => null "ResourceRecordID" => "202512414" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1114298333" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1114298333 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18758354" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18758189" ] 7 => array:57 [ "Order" => 8 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003992922281" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1114298333/793eb7ba9a9907b973004832953042e8.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 52046 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1114298333/thumbnail-793eb7ba9a9907b973004832953042e8.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13403319" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2597471" "MediaCategory" => null "MediaObjectID" => "hec8.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "DGRS" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003992922281 "PropertySubType" => "Condominium" "RecordSignature" => 2022372373 "PreferredPhotoYN" => null "ResourceRecordID" => "202512414" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1114298333" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1114298333 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18758355" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18758189" ] 8 => array:57 [ "Order" => 9 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003992922282" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1114298333/82eb9d2a6b4359cfc956ede78fda25af.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 120157 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1114298333/thumbnail-82eb9d2a6b4359cfc956ede78fda25af.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13403319" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2597471" "MediaCategory" => null "MediaObjectID" => "hec7.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "DGRS" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003992922282 "PropertySubType" => "Condominium" "RecordSignature" => 2022372373 "PreferredPhotoYN" => null "ResourceRecordID" => "202512414" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1114298333" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1114298333 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18758356" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18758189" ] ] +"ID": "52356" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6330 +post_id: "61948" +post_author: 1 +"ListingKey": "1145805689" +"ListingId": "202525013" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-11T00:01:54Z" +"RFModificationTimestamp": "2026-03-11T00:06:49Z" +"ListPrice": 930000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 6554.0 +"LivingArea": 1080.0 +"BuildingAreaTotal": 1080.0 +"City": "Waipahu" +"PostalCode": "96797" +"UnparsedAddress": "94-341 Kahuanani Street, Waipahu, Hawaii 96797" +"Coordinates": array:2 [ 0 => -158.009166 1 => 21.3866667 ] +"Latitude": 21.3866667 +"Longitude": -158.009166 +"YearBuilt": 1967 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Geraldine C Supapo" +"ListOfficeName": "Pacific Realty Solutions LLC" +"ListAgentMlsId": "36075" +"ListOfficeMlsId": "PRSO" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "BACK ON MARKET! BUYERS FINANCING FAILED. Welcome to this charming single-level home nestled in the heart of Waipahu Triangle! This 3-bedroom, 2 bath residence offers comfort, functionality, and endless potential on a spacious 6,554 sq. ft. lot. This property features an open layout with natural light throughout, a large yard perfect for future expansion. This home is ideal for first-time buyers or investors looking to add value. Don’t miss this opportunity to make this home your own!" +"ArchitecturalStyle": "Detached" +"BathroomsFull": 2 +"CarportYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2025-11-06T09:14:44.033583+00:00" +"DaysOnMarket": 119 +"DaysOnMarketReplication": 89 +"DaysOnMarketReplicationDate": "2026-03-10" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "August Ahrens" +"Flooring": "Carpet" +"HighSchool": "Waipahu" +"HumanModifiedYN": true +"Inclusions": "AC Window Unit,Dryer,Microwave,Range Hood,Range/Oven,Washer" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 388-9434" +"ListAgentEmail": "gsupapo@gmail.com" +"ListAgentKey": "10777996" +"ListAgentKeyNumeric": "10777996" +"ListAgentOfficePhone": "(808) 342-4061" +"ListAgentPreferredPhone": "(808) 388-9434" +"ListAgentStateLicense": "RS-70747" +"ListOfficeEmail": "kaleo@prshawaii.com" +"ListOfficeKey": "5525635" +"ListOfficeKeyNumeric": "5525635" +"ListOfficePhone": "(808) 342-4061" +"ListingContractDate": "2025-11-05" +"ListingKeyNumeric": 1145805689 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Other, Wooded" +"MLSAreaMajor": "Waipahu" +"MajorChangeTimestamp": "2026-03-10T14:00:37Z" +"MiddleOrJuniorSchool": "Waipahu" +"MlsStatus": "Active" +"OnMarketDate": "2025-11-05" +"OriginalListPrice": 940000.0 +"OriginatingSystemKey": "19105857" +"ParcelNumber": "1-9-4-037-055-0000" +"ParkingFeatures": "Carport" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 24 +"PoolFeatures": "None" +"PostalCity": "Waipahu" +"PropertyCondition": "Average Condition" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1145805689" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Kahuanani" +"StreetNumber": "94-341" +"StreetSuffix": "Street" +"SubdivisionName": "WAIPAHU TRIANGLE" +"TaxAnnualAmount": "2604.0" +"TaxAssessedValue": 900800 +"Topography": "Other" +"Utilities": "Other,Sewer Available,Water Available" +"View": "None" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1145805689"\n } """ +"TaxAssessedValueLand": "808300" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "92500" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1145805689')" +"provider_name": "HICMLS" +"RecordSignature": -1737209607 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-4-037-055-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "18003648" +"OriginatingSystemListAgentMemberKey": "3480777" +"Media": array:24 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004602032845" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1145805689/25c0c283ff2e3e839400da26af4b8b20.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 644147 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1145805689/thumbnail-25c0c283ff2e3e839400da26af4b8b20.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777996" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5525635" "MediaCategory" => null "MediaObjectID" => "51_1-img_9009.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "PRSO" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004602032845 "PropertySubType" => "Single Family Residence" "RecordSignature" => -877402409 "PreferredPhotoYN" => null "ResourceRecordID" => "202525013" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1145805689" "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" => 1145805689 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19105858" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:21:45.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19105857" ] 1 => array:57 [ "Order" => 2 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004602032846" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1145805689/ca9552469708e9bd9adbc894ef2c4252.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 473229 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1145805689/thumbnail-ca9552469708e9bd9adbc894ef2c4252.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777996" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5525635" "MediaCategory" => null "MediaObjectID" => "3_21-img_8817.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "PRSO" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004602032846 "PropertySubType" => "Single Family Residence" "RecordSignature" => -877402409 "PreferredPhotoYN" => null "ResourceRecordID" => "202525013" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1145805689" "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" => 1145805689 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19105859" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:21:45.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19105857" ] 2 => array:57 [ "Order" => 3 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004602032847" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1145805689/c4cbe60dff47899fc89db69fc336cfc1.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 427891 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1145805689/thumbnail-c4cbe60dff47899fc89db69fc336cfc1.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777996" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5525635" "MediaCategory" => null "MediaObjectID" => "5_20-img_8829.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "PRSO" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004602032847 "PropertySubType" => "Single Family Residence" "RecordSignature" => -877402409 "PreferredPhotoYN" => null "ResourceRecordID" => "202525013" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1145805689" "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" => 1145805689 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19105860" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:21:45.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19105857" ] 3 => array:57 [ "Order" => 4 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004602032848" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1145805689/f7d417cf9affc27171e86c8d250bfec6.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 454642 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1145805689/thumbnail-f7d417cf9affc27171e86c8d250bfec6.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777996" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5525635" "MediaCategory" => null "MediaObjectID" => "9_18-img_8844.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "PRSO" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004602032848 "PropertySubType" => "Single Family Residence" "RecordSignature" => -877402409 "PreferredPhotoYN" => null "ResourceRecordID" => "202525013" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1145805689" "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" => 1145805689 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19105861" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:21:45.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19105857" ] 4 => array:57 [ "Order" => 5 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004602032849" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1145805689/094c1aab6120a053eb4a8c6e9ff84a42.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 331626 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1145805689/thumbnail-094c1aab6120a053eb4a8c6e9ff84a42.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777996" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5525635" "MediaCategory" => null "MediaObjectID" => "14_img_8859.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "PRSO" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004602032849 "PropertySubType" => "Single Family Residence" "RecordSignature" => 339158654 "PreferredPhotoYN" => null "ResourceRecordID" => "202525013" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1145805689" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:24:38.320-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1145805689 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19105862" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:24:38.320-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19105857" ] 5 => array:57 [ "Order" => 6 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004602032850" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1145805689/8b6e0ff1a3aac44fd0ebda7452b510e8.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 360904 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1145805689/thumbnail-8b6e0ff1a3aac44fd0ebda7452b510e8.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777996" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5525635" "MediaCategory" => null "MediaObjectID" => "13_16-img_8853.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "PRSO" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004602032850 "PropertySubType" => "Single Family Residence" "RecordSignature" => 339158654 "PreferredPhotoYN" => null "ResourceRecordID" => "202525013" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1145805689" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:24:38.320-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1145805689 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19105863" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:24:38.320-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19105857" ] 6 => array:57 [ "Order" => 7 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004602032851" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1145805689/073701381f9a1a5fe6c612138db8479a.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 389023 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1145805689/thumbnail-073701381f9a1a5fe6c612138db8479a.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777996" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5525635" "MediaCategory" => null "MediaObjectID" => "11_17-img_8847.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "PRSO" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004602032851 "PropertySubType" => "Single Family Residence" "RecordSignature" => 339158654 "PreferredPhotoYN" => null "ResourceRecordID" => "202525013" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1145805689" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2025-11-11T00:24:38.320-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1145805689 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19105864" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:24:38.320-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19105857" ] 7 => array:57 [ "Order" => 8 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004602032852" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1145805689/b645c1acedcd07695768e1137576a479.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 414893 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1145805689/thumbnail-b645c1acedcd07695768e1137576a479.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777996" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5525635" "MediaCategory" => null "MediaObjectID" => "34_img_8925.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "PRSO" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004602032852 "PropertySubType" => "Single Family Residence" "RecordSignature" => -877402409 "PreferredPhotoYN" => null "ResourceRecordID" => "202525013" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1145805689" "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" => 1145805689 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19105865" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:21:45.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19105857" ] 8 => array:57 [ "Order" => 9 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004602032853" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1145805689/9a97797d9a6d5c30e0b4687579d461b5.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 487055 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1145805689/thumbnail-9a97797d9a6d5c30e0b4687579d461b5.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777996" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5525635" "MediaCategory" => null "MediaObjectID" => "35_img_8940.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "PRSO" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004602032853 "PropertySubType" => "Single Family Residence" "RecordSignature" => -877402409 "PreferredPhotoYN" => null "ResourceRecordID" => "202525013" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1145805689" "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" => 1145805689 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19105866" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:21:45.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19105857" ] 9 => array:57 [ "Order" => 10 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004602032854" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1145805689/ee83d29006fe53a01f96e4b4ff178c7b.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 411796 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1145805689/thumbnail-ee83d29006fe53a01f96e4b4ff178c7b.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777996" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5525635" "MediaCategory" => null "MediaObjectID" => "37_7-img_8964-2.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "PRSO" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004602032854 "PropertySubType" => "Single Family Residence" "RecordSignature" => -877402409 "PreferredPhotoYN" => null "ResourceRecordID" => "202525013" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1145805689" "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" => 1145805689 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19105867" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:21:45.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19105857" ] 10 => array:57 [ "Order" => 11 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004602032855" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1145805689/6e30cfb200ac32a6d6e8838d76d3ad82.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 456619 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1145805689/thumbnail-6e30cfb200ac32a6d6e8838d76d3ad82.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777996" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5525635" "MediaCategory" => null "MediaObjectID" => "38_img_8970.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "PRSO" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004602032855 "PropertySubType" => "Single Family Residence" "RecordSignature" => -877402409 "PreferredPhotoYN" => null "ResourceRecordID" => "202525013" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1145805689" "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" => 1145805689 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19105868" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:21:45.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19105857" ] 11 => array:57 [ "Order" => 12 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004602032856" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1145805689/a20568ec114202c0c901d09fe8f7e993.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 410612 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1145805689/thumbnail-a20568ec114202c0c901d09fe8f7e993.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777996" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5525635" "MediaCategory" => null "MediaObjectID" => "33_8-img_8916.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "PRSO" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004602032856 "PropertySubType" => "Single Family Residence" "RecordSignature" => -877402409 "PreferredPhotoYN" => null "ResourceRecordID" => "202525013" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1145805689" "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" => 1145805689 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19105869" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:21:45.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19105857" ] 12 => array:57 [ "Order" => 13 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004602032857" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1145805689/60996d2c2692336cf5b89eb672fb380b.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 247287 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1145805689/thumbnail-60996d2c2692336cf5b89eb672fb380b.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777996" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "5525635" "MediaCategory" => null "MediaObjectID" => "31_9-img_8910.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "PRSO" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004602032857 "PropertySubType" => "Single Family Residence" "RecordSignature" => -877402409 "PreferredPhotoYN" => null "ResourceRecordID" => "202525013" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1145805689" "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" => 1145805689 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19105870" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:21:45.423-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19105857" ] 13 => array:57 [ "Order" => 14 "ImageOf" => null "ListAOR" => "HI Central" …54 ] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] 20 => array:57 [ …57] 21 => array:57 [ …57] 22 => array:57 [ …57] 23 => array:57 [ …57] ] +"ID": "61948" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6333 +post_id: "77068" +post_author: 1 +"ListingKey": "1151555829" +"ListingId": "202601448" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-11T00:01:54Z" +"RFModificationTimestamp": "2026-03-11T00:06:49Z" +"ListPrice": 1385000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 4951.0 +"LivingArea": 2072.0 +"BuildingAreaTotal": 2072.0 +"City": "Ewa Beach" +"PostalCode": "96706" +"UnparsedAddress": "91-1252 Kaikohola Street D53, Ewa Beach, Hawaii 96706" +"Coordinates": array:2 [ 0 => -158.008804 1 => 21.315603 ] +"Latitude": 21.315603 +"Longitude": -158.008804 +"YearBuilt": 2014 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Leslie Ann Wills" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "37758" +"ListOfficeMlsId": "CBPP04" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Price improvement! New price, new opportunity. Don’t miss out on the finest available value & location in Hoakalei. Experience refined island living at Kipuka at Hoakalei, a serene gated community located along the prestigious Ernie Els-designed Hoakalei Golf Course that is host to the LPGA Lotte Championship. Take in the sweeping fairway views that create a peaceful and scenic backdrop to unwind from your day. This thoughtfully designed home features an open floor plan with a kitchen ideal for entertaining with highlights that include granite counter tops, a convection oven, and brand-new dishwasher & refrigerator. Relax in your primary suite that has its own covered lanai, walk-in closet, and luxury bathtub with separate shower. Amenities include a pool exclusive to Kipuka residents and membership to the Wai Kai Hale Club. Enjoy the convenience of nearby restaurants, dining, Ka Makana Alii Shopping Center & the proximity of Kapolei that makes this the perfect place to call home." +"ArchitecturalStyle": "Detached" +"AssociationAmenities": "Pool" +"AssociationFee": "44.0" +"AssociationName": "Kipuka Community AOAO" +"AttributionContact": "(808) 262-3104" +"BathroomsFull": 2 +"CommunityFeatures": "Gated" +"ConstructionMaterials": "Double Wall,Steel Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-01-23T23:08:05.016973+00:00" +"DaysOnMarket": 75 +"DaysOnMarketReplication": 45 +"DaysOnMarketReplicationDate": "2026-03-10" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"Flooring": "Carpet,Ceramic Tile" +"FrontageType": "Golf Course" +"GarageYN": true +"HumanModifiedYN": true +"Inclusions": "AC Central,Auto Garage Door Opener,Blinds,Cable TV,Ceiling Fan,Chandelier,Convection Oven,Dishwasher,Disposal,Dryer,Lawn Sprinkler,Microwave,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Solar Heater,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 375-6626" +"ListAgentEmail": "leslie.wills@cbrealty.com" +"ListAgentKey": "10773110" +"ListAgentKeyNumeric": "10773110" +"ListAgentOfficePhone": "(808) 262-3104" +"ListAgentPreferredPhone": "(808) 375-6626" +"ListAgentStateLicense": "RB-22181" +"ListOfficeEmail": "mike.james@cbrealty.com" +"ListOfficeKey": "2586332" +"ListOfficeKeyNumeric": "2586332" +"ListOfficePhone": "(808) 262-3104" +"ListingContractDate": "2026-01-23" +"ListingKeyNumeric": 1151555829 +"ListingService": "Full Service" +"LotFeatures": "Other, Level" +"MLSAreaMajor": "Ewaplain" +"MaintenanceExpense": 550.0 +"MajorChangeTimestamp": "2026-03-10T14:01:32Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-01-23" +"OriginalListPrice": 1385000.0 +"OriginatingSystemKey": "19228382" +"ParcelNumber": "1-9-1-162-006-0008" +"ParkingFeatures": "Driveway,Garage,Three or more Spaces" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-01-27T23:40:00Z" +"PhotosCount": 25 +"PostalCity": "Ewa Beach" +"PropertyCondition": "Good Condition" +"RoadFrontageType": "Private Road" +"SecurityFeatures": "Gated Community" +"SourceSystemKey": "1151555829" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Kaikohola" +"StreetNumber": "91-1252" +"StreetSuffix": "Street" +"SubdivisionName": "HOAKALEI-KIPUKA" +"TaxAnnualAmount": "4416.0" +"TaxAssessedValue": 1489700 +"Topography": "Level" +"UnitNumber": "D53" +"Utilities": "Cable Available,Electricity Available,High Speed Internet Available,Phone Available,Underground Utilities,Water Available" +"View": "Golf Course,Garden,Mountain(s),Sunset" +"ViewYN": true +"VirtualTourURLUnbranded": "https://player.vimeo.com/video/1106795984" +"WaterSource": "Public" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1151555829"\n } """ +"AssociationFeeTotal": 594.0 +"TaxAssessedValueLand": "824200" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "665500" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1151555829')" +"provider_name": "HICMLS" +"RecordSignature": -2129652551 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-1-162-006-0008" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3484714" +"OriginatingSystemListAgentMemberKey": "3481411" +"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": "77068" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6329 +post_id: "80106" +post_author: 1 +"ListingKey": "1154868723" +"ListingId": "202605302" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-10T23:44:15Z" +"RFModificationTimestamp": "2026-03-16T10:09:44Z" +"ListPrice": 499000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 3811.0 +"LivingArea": 1152.0 +"BuildingAreaTotal": 1152.0 +"City": "Honolulu" +"PostalCode": "96819" +"UnparsedAddress": "2307 A N School Street A, Honolulu, Hawaii 96819" +"Coordinates": array:2 [ 0 => -157.8745836 1 => 21.3406961 ] +"Latitude": 21.3406961 +"Longitude": -157.8745836 +"YearBuilt": 1943 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Wendy W Lee" +"ListOfficeName": "Loyal Realty, LLC" +"ListAgentMlsId": "22173" +"ListOfficeMlsId": "LORE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Excellent development potential in Kahlihi - Located in town with access to Downtown, Airport & Freeway. Please do not enter the property- Listing is for land value only. To be sold "AS IS". Buyer/Buyer's agent to do due diligence in verifying material facts. The proposed sewer lateral plan was approved in July 2024 by the Wasterwater Branch." +"ArchitecturalStyle": "Detached" +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 739-2291" +"BathroomsFull": 1 +"CarportYN": true +"CoListAgentDirectPhone": "(808) 232-4261" +"CoListAgentEmail": "ivonnelee@loyalrealty.us" +"CoListAgentFullName": "Ivonne Lee" +"CoListAgentKey": "10776358" +"CoListAgentKeyNumeric": "10776358" +"CoListAgentMlsId": "47765" +"CoListAgentPreferredPhone": "(808) 232-4261" +"CoListOfficeEmail": "loyalreal@aol.com" +"CoListOfficeKey": "2585999" +"CoListOfficeKeyNumeric": "2585999" +"CoListOfficeMlsId": "LORE" +"CoListOfficeName": "Loyal Realty, LLC" +"CoListOfficePhone": "(808) 739-2291" +"CommunityFeatures": "None" +"ConstructionMaterials": "Other" +"CountyOrParish": "Oahu" +"CreationDate": "2026-03-10T23:47:57.201124+00:00" +"DaysOnMarket": 31 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2026-03-10" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None,Seller Disclosure" +"ElementarySchool": "Kalihi Waena" +"Flooring": "Other" +"FrontageType": "Other" +"Furnished": "Unfurnished" +"HighSchool": "Farrington" +"HumanModifiedYN": true +"Inclusions": "None" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 228-1808" +"ListAgentEmail": "loyalreal@aol.com" +"ListAgentKey": "10761711" +"ListAgentKeyNumeric": "10761711" +"ListAgentOfficePhone": "(808) 739-2291" +"ListAgentPreferredPhone": "(808) 228-1808" +"ListAgentStateLicense": "RB-16882" +"ListOfficeEmail": "loyalreal@aol.com" +"ListOfficeKey": "2585999" +"ListOfficeKeyNumeric": "2585999" +"ListOfficePhone": "(808) 739-2291" +"ListingContractDate": "2026-03-09" +"ListingKeyNumeric": 1154868723 +"ListingService": "Full Service" +"LotFeatures": "Flag Lot,Interior Lot,Level" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2026-03-10T13:43:50Z" +"MiddleOrJuniorSchool": "Dole" +"MlsStatus": "Active" +"OnMarketDate": "2026-03-09" +"OriginalListPrice": 499000.0 +"OriginatingSystemKey": "19326571" +"ParcelNumber": "1-1-3-014-046-0000" +"ParkingFeatures": "Carport" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-03-10T21:51:00Z" +"PhotosCount": 4 +"PoolFeatures": "None" +"PostalCity": "Honolulu" +"PropertyCondition": "Tear Down / Value in Land" +"RoadFrontageType": "Private Road" +"SourceSystemKey": "1154868723" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetDirPrefix": "N" +"StreetName": "School" +"StreetNumber": "2307 A" +"StreetSuffix": "Street" +"SubdivisionName": "KALIHI-LOWER" +"TaxAnnualAmount": "1488.0" +"TaxAssessedValue": 655900 +"Topography": "Level" +"UnitNumber": "A" +"Utilities": "Sewer Available" +"View": "None" +"ZoningDescription": "07 - R-3.5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1154868723"\n } """ +"TaxAssessedValueLand": "513500" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "142400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1154868723')" +"provider_name": "HICMLS" +"short_address": "Honolulu, Hawaii 96819, USA" +"RecordSignature": -111248443 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-3-014-046-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3487881" +"OriginatingSystemCoListOfficeKey": "3487881" +"OriginatingSystemListAgentMemberKey": "8843089" +"OriginatingSystemCoListAgentMemberKey": "12191582" +"Media": array:4 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] ] +"ID": "80106" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6331 +post_id: "79894" +post_author: 1 +"ListingKey": "1154920429" +"ListingId": "202605369" +"PropertyType": "For Rent" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-10T23:34:45Z" +"RFModificationTimestamp": "2026-03-10T23:37:56Z" +"ListPrice": 3000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 492.0 +"BuildingAreaTotal": 567.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "223 Saratoga Road 2220, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ 0 => -157.832077 1 => 21.2794259 ] +"Latitude": 21.2794259 +"Longitude": -157.832077 +"YearBuilt": 2009 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Casey I Enokawa" +"ListOfficeName": "Hawaiian Joy LLC" +"ListAgentMlsId": "50177" +"ListOfficeMlsId": "HAWA" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Fully furnished studio, 1 bathroom unit in KA LAI WAIKIKI hotel. ** Appointments only by email. Please NO PHONE CALLS. Email rental@hawaiianjoy.com for inquiries. Applicant must physically see unit. Monday to Fridays only. No virtual tours. ** [Long term lease - 12 MONTHS MINIMUM required by building]. Opportunity to live at the 5-star hotel for long term. Convenient location within walking distance of Waikiki Beach and shopping. Unit includes kitchen w/ cooktop, under counter mini refrigerator, 2 full-size beds, sofa bed, blackout curtains, carpet floor (tile in bathroom & kitchen), walk in shower, full tub, central ac, and a lanai with ocean views. No washer/dryer in unit. There is no laundry on-site. Utilities include Water/sewer, cable tv, hotel wifi internet, and tax included. Tenant responsible for electricity. Parking not included, but monthly valet parking available thru building. Building amenities include 24/7 security, on-site manager, concierge, exercise room, pool, meeting room, and restaurants. No pets, No smoking. No short term or sublease allowed. Renters insurance required by move in. Building undergoing renovations until early 2026." +"Appliances": "Microwave Hood Fan,Refrigerator" +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Concierge, Management" +"AttributionContact": "(808) 923-1888" +"AvailabilityDate": "2026-04-01" +"BathroomsFull": 1 +"BuildingName": "Trump Tower Waikiki" +"CommunityFeatures": "Concierge,Conference/Meeting Room,Deck/Porch,Fitness,Patio,Property Manager On-Site,Pool,Restaurant,Tennis Court(s),Trash Chute,Condo Hotel Community" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2026-03-10T23:37:41.674363+00:00" +"DaysOnMarketReplicationDate": "2026-03-10" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "No Smoking,Renters Insurance Required,See Remarks" +"Furnished": "Furnished" +"HumanModifiedYN": true +"InteriorFeatures": "Dual Sinks,Double Vanity,Cable TV,Window Treatments" +"RFTransactionType": "For Rent" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 923-1889" +"ListAgentEmail": "rental@hawaiianjoy.com" +"ListAgentKey": "13403889" +"ListAgentKeyNumeric": "13403889" +"ListAgentOfficePhone": "(808) 923-1888" +"ListAgentPreferredPhone": "(808) 923-1889" +"ListAgentStateLicense": "RS-82774" +"ListOfficeEmail": "info@hawaiianjoy.com" +"ListOfficeKey": "2587098" +"ListOfficeKeyNumeric": "2587098" +"ListOfficePhone": "(808) 923-1888" +"ListingContractDate": "2026-03-10" +"ListingKeyNumeric": 1154920429 +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2026-03-10T13:34:29Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-03-10" +"OriginalListPrice": 3000.0 +"OriginatingSystemKey": "19328796" +"ParcelNumber": "1-2-6-003-061-0309" +"ParkingFeatures": "None, Valet" +"PatioAndPorchFeatures": "Lanai" +"PetsAllowed": "No" +"PhotosChangeTimestamp": "2026-03-10T20:20:04Z" +"PhotosCount": 15 +"PoolFeatures": "Heated" +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition" +"RentIncludes": "Pool" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,24 Hour Security,Key Card Entry,Door Man,Smoke Detector(s),Security Guard" +"SourceSystemKey": "1154920429" +"SpaFeatures": "Community" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Saratoga" +"StreetNumber": "223" +"StreetNumberNumeric": "223" +"StreetSuffix": "Road" +"SubdivisionName": "WAIKIKI" +"TenantPays": "Application Fee,Other Tax" +"UnitNumber": "2220" +"Utilities": "Cable Available,High Speed Internet Available,Phone Available,Sewer Available,Trash Collection,Water Available" +"View": "City, Ocean" +"ViewYN": true +"WindowFeatures": "Drapes" +"ZoningDescription": "X6 - Resort Mixed Use Precinct" +"ListAOR": "HI Central" +"CustomFields": """ {\n "ListingKey": "1154920429"\n } """ +"Restrictions": "No Smoking" +"AvailabilityType": "Long Term" +"OriginatingSystemSubName": "HICMLS_HBR" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1154920429')" +"provider_name": "HICMLS" +"short_address": "Honolulu, Hawaii 96815, USA" +"RecordSignature": -619932322 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-003-061-0309" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485480" +"OriginatingSystemListAgentMemberKey": "14968871" +"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": "79894" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6334 +post_id: "79941" +post_author: 1 +"ListingKey": "1154942424" +"ListingId": "202605397" +"PropertyType": "Land" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-10T23:25:37Z" +"RFModificationTimestamp": "2026-03-10T23:27:33Z" +"ListPrice": 550000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 87120.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waipahu" +"PostalCode": "96797" +"UnparsedAddress": "94-1100 Kunia Road 99c-2, Waipahu, Hawaii 96797" +"Coordinates": array:2 [ 0 => -158.009166 1 => 21.3866667 ] +"Latitude": 21.3866667 +"Longitude": -158.009166 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Teresita T Garcia" +"ListOfficeName": "Garcia Properties Corporation" +"ListAgentMlsId": "09820" +"ListOfficeMlsId": "GAPC" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "DON'T MISS THIS INCREDIBLE OPPORTUNIY TO OWN A PRIME AG-1 ZONED FARM. LEVEL LOT WITH STUNNING VIEW AND ENDLESS POTENTIAL. START YOUR OWN MINI FARM ON THIS SPACIOUS, LEVEL LOT LOCATED IN A PEACEFUL SETTING AT THE END OF THE PROJECT IN THE MILILANI SIDE OF THE PROJECT. BUYER BECOMES A MEMBER OF THE COOP. 99 YRS LEASE FROM 2010. NO LEASE RENT. OWNER IS SELLING APPROXIMATELY 2 ACRES IN LOT 99. BUYER CAN BUY ONE ACRE AS IT HA BEEN PARTITIONED/SURVEY ALREADY AS ONE ACRE. NOTE CPR#0099 -C-2,C-3 WHICH ACTUAL TMK: 1-9-2-003-014,099." +"AssociationFee2": "40.0" +"AttributionContact": "(808) 783-7887" +"BusinessType": "Florist/Nursery" +"CountyOrParish": "Oahu" +"CreationDate": "2026-03-10T23:14:06.325241+00:00" +"CurrentUse": "Agricultural" +"DaysOnMarketReplicationDate": "2026-03-10" +"DaysOnMarketReplicationIncreasingYN": true +"ExteriorFeatures": "None" +"HumanModifiedYN": true +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LeaseExpiration": "2109-03-01" +"ListAgentDirectPhone": "(808) 783-7887" +"ListAgentEmail": "tgarcia778@gmail.com" +"ListAgentKey": "10778479" +"ListAgentKeyNumeric": "10778479" +"ListAgentOfficePhone": "(808) 783-7887" +"ListAgentPreferredPhone": "(808) 783-7887" +"ListAgentStateLicense": "RB-14940" +"ListOfficeEmail": "tgarcia778@gmail.com" +"ListOfficeKey": "2587509" +"ListOfficeKeyNumeric": "2587509" +"ListOfficePhone": "(808) 783-7887" +"ListingContractDate": "2026-03-10" +"ListingKeyNumeric": 1154942424 +"ListingService": "Full Service" +"LotFeatures": "Other, Level" +"MLSAreaMajor": "Makakilo" +"MaintenanceExpense": 220.0 +"MajorChangeTimestamp": "2026-03-10T13:07:35Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-03-10" +"OriginalListPrice": 550000.0 +"OriginatingSystemKey": "19329529" +"ParcelNumber": "1-9-2-004-013-9999" +"PhotosChangeTimestamp": "2026-03-10T23:08:00Z" +"PhotosCount": 6 +"PossibleUse": "Farm, Nursery" +"PostalCity": "Waipahu" +"RoadFrontageType": "Private Road" +"Sewer": "None" +"SourceSystemKey": "1154942424" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "KUNIA" +"StreetNumber": "94-1100" +"StreetSuffix": "Road" +"SubdivisionName": "AG/PRESERVE" +"TaxAnnualAmount": "336.0" +"TaxAssessedValue": 38100 +"Topography": "Level, Sloping" +"UnitNumber": "99C-2,3" +"Utilities": "Water Available,Sewer Not Available" +"View": "Coastline, City, Mountain(s), Ocean, Sunset, Sunrise" +"ViewYN": true +"WaterSource": "Private" +"ZoningDescription": "51 - AG-1 Restricted Agricultur" +"ListAOR": "HI Central" +"LandTenure": "Lease Hold" +"CustomFields": """ {\n "ListingKey": "1154942424"\n } """ +"Restrictions": "Restrictive Covenant" +"TaxAssessedValueLand": "38100" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1154942424')" +"provider_name": "HICMLS" +"RecordSignature": 1230263999 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-2-004-013-9999" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485891" +"OriginatingSystemListAgentMemberKey": "8829977" +"Media": array:6 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] ] +"ID": "79941" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6335 +post_id: "80266" +post_author: 1 +"ListingKey": "1154873197" +"ListingId": "202605314" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-10T23:18:28Z" +"RFModificationTimestamp": "2026-03-10T23:22:31Z" +"ListPrice": 1150000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 6358.0 +"LivingArea": 1008.0 +"BuildingAreaTotal": 1124.0 +"City": "Kaneohe" +"PostalCode": "96744" +"UnparsedAddress": "45-038 Waikalua Road, Kaneohe, Hawaii 96744" +"Coordinates": array:2 [ 0 => -157.7900922 1 => 21.4127521 ] +"Latitude": 21.4127521 +"Longitude": -157.7900922 +"YearBuilt": 1975 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Melvin M Yoshikawa" +"ListOfficeName": "Waikiki Realty LLC" +"ListAgentMlsId": "16715" +"ListOfficeMlsId": "WRII" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "First time on the market! This well maintained single family home has been kept in the family and is ready to meet its new owners! Located in the majestic Kaneohe area, enjoy the picturesque Koolau mountain range right in your backyard. Recently renovated to include new kitchen cabinets, countertops, drop-in range and hood, carpets, vinyl flooring throughout, paint, refinished tub and various light fixtures. Large terraced back yard and spacious front yard. Great location right down the street from Kaneohe Beach Park and near various shopping centers with eateries, grocery stores, banks, etc. Don't miss this opportunity!" +"ArchitecturalStyle": "Detached" +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 955-8282" +"BathroomsFull": 1 +"CountyOrParish": "Oahu" +"CreationDate": "2026-03-10T23:22:24.136089+00:00" +"DaysOnMarket": 31 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2026-03-10" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Familial Relation" +"Flooring": "Carpet" +"FrontageType": "Other" +"Furnished": "Partially" +"GarageSpaces": "2.0" +"GarageYN": true +"HumanModifiedYN": true +"Inclusions": "Range/Oven" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 955-8282" +"ListAgentEmail": "melyoshikawa@aol.com" +"ListAgentKey": "10778506" +"ListAgentKeyNumeric": "10778506" +"ListAgentOfficePhone": "(808) 955-8282" +"ListAgentPreferredPhone": "(808) 955-8282" +"ListAgentStateLicense": "RS-30083" +"ListOfficeEmail": "gwen@waikikirealty2.com" +"ListOfficeKey": "2587245" +"ListOfficeKeyNumeric": "2587245" +"ListOfficePhone": "(808) 955-8282" +"ListingContractDate": "2026-03-09" +"ListingKeyNumeric": 1154873197 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Other" +"MLSAreaMajor": "Kaneohe" +"MajorChangeTimestamp": "2026-03-10T13:18:00Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-03-09" +"OriginalListPrice": 1150000.0 +"OriginatingSystemKey": "19326955" +"ParcelNumber": "1-4-5-007-016-0000" +"ParkingFeatures": "Driveway,Two Car Garage,Two Spaces" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-03-10T23:19:00Z" +"PhotosCount": 16 +"PoolFeatures": "None" +"PostalCity": "Kaneohe" +"PropertyCondition": "Excellent, Updated/Remodeled" +"RoadFrontageType": "County Road" +"SourceSystemKey": "1154873197" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Waikalua" +"StreetNumber": "45-038" +"StreetSuffix": "Road" +"SubdivisionName": "WAIKALUA" +"TaxAnnualAmount": "2988.0" +"TaxAssessedValue": 853000 +"Topography": "Sloping" +"Utilities": "Other,Phone Available,Water Available" +"View": "Other" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltEffective": 2026 +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1154873197"\n } """ +"TaxAssessedValueLand": "803500" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "49500" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1154873197')" +"provider_name": "HICMLS" +"short_address": "Kaneohe, Hawaii 96744, USA" +"RecordSignature": 702968669 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-4-5-007-016-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485627" +"OriginatingSystemListAgentMemberKey": "8834383" +"Media": array:16 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] ] +"ID": "80266" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6427 +post_id: "79702" +post_author: 1 +"ListingKey": "1153633252" +"ListingId": "202604642" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-10T23:07:48Z" +"RFModificationTimestamp": "2026-03-10T23:14:52Z" +"ListPrice": 1850000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 5818.0 +"LivingArea": 1848.0 +"BuildingAreaTotal": 2376.0 +"City": "Kaneohe" +"PostalCode": "96744" +"UnparsedAddress": "49-545 Kamehameha Highway A, Kaneohe, Hawaii 96744" +"Coordinates": array:2 [ 0 => -157.804184 1 => 21.418555 ] +"Latitude": 21.418555 +"Longitude": -157.804184 +"YearBuilt": 1965 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lori K Kaizawa" +"ListOfficeName": "Demarked Realty Hawaii LLC" +"ListAgentMlsId": "27492" +"ListOfficeMlsId": "DMKD" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "AMAZING, UNIQUE, AND RARE OCEANFRONT PROPERTY WITH GORGEOUS PANORAMIC VIEWS!! Positioned on an oceanfront point with water frontage on two sides, this very special lot boasts expansive unobstructed views of legendary Chinaman's Hat island, Kaneohe Bay, the majestic Koolau Mountain Range, beautiful sandy Kualoa Regional (Beach) Park, and more! Enjoy exceptional natural privacy, direct ocean access, and a private boat ramp. On a private lane off Kamehameha Hwy. across from wonderful Kualoa Ranch. Move right in - freshly painted with a kitchen renovation in 2018. Enclosed downstairs lanai, upstairs beautiful deck, both perfect for entertaining. 1 bed/1 bath downstairs, 2 bed/1 bath upstairs. SPLIT A/C UNITS IN EACH ROOM! Within about half an hour drive to Kaneohe Marine Base, less to Kaneohe Town. Interior size and number of bedrooms differ from tax record. MUST SEE TODAY!" +"ArchitecturalStyle": "Detached" +"AssociationFeeIncludes": "None" +"BathroomsFull": 2 +"CommunityFeatures": "Deck/Porch, Other, Patio" +"ConstructionMaterials": "Concrete,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-03-07T04:38:10.390601+00:00" +"DaysOnMarket": 34 +"DaysOnMarketReplication": 4 +"DaysOnMarketReplicationDate": "2026-03-10" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "1031 Exchange,Seller Disclosure" +"Fencing": "Fenced, Wall" +"Flooring": "Other, Vinyl" +"FrontageType": "Oceanfront" +"Furnished": "Partially" +"HumanModifiedYN": true +"Inclusions": "AC Split,Blinds,Book Shelves,Dryer,Range Hood,Range/Oven,Refrigerator,Washer,Water Heater" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 352-1664" +"ListAgentEmail": "Lori@demarkedrealty.com" +"ListAgentKey": "10772692" +"ListAgentKeyNumeric": "10772692" +"ListAgentOfficePhone": "(808) 352-1664" +"ListAgentPreferredPhone": "(808) 352-1664" +"ListAgentStateLicense": "RB-21873" +"ListOfficeEmail": "lori@demarkedrealty.com" +"ListOfficeKey": "5153877" +"ListOfficeKeyNumeric": "5153877" +"ListOfficePhone": "(808) 352-1664" +"ListingContractDate": "2026-03-06" +"ListingKeyNumeric": 1153633252 +"ListingService": "Full Service" +"LotFeatures": "Flag Lot,Interior Lot,Level" +"MLSAreaMajor": "Kaneohe" +"MajorChangeTimestamp": "2026-03-06T18:35:40Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-03-06" +"OriginalListPrice": 1850000.0 +"OriginatingSystemKey": "19297536" +"ParcelNumber": "1-4-9-009-018-0000" +"ParkingFeatures": "Driveway,Three or more Spaces" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2026-03-10T23:09:00Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Kaneohe" +"PropertyCondition": "Average Condition,Good Condition,Updated/Remodeled" +"RoadFrontageType": "Highway" +"Sewer": "Cesspool" +"SourceSystemKey": "1153633252" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Kamehameha" +"StreetNumber": "49-545 A" +"StreetSuffix": "Highway" +"SubdivisionName": "KUALOA BEACH" +"TaxAnnualAmount": "11064.0" +"TaxAssessedValue": 1667700 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Electricity Available,High Speed Internet Available,Water Available" +"View": "Coastline, Mountain(s), Ocean, Sunrise" +"ViewYN": true +"YearBuiltEffective": 2018 +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1153633252"\n } """ +"TaxAssessedValueLand": "859800" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "807900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1153633252')" +"provider_name": "HICMLS" +"RecordSignature": 707990990 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-4-9-009-018-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "17135060" +"OriginatingSystemListAgentMemberKey": "3477131" +"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": "79702" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6322 +post_id: "79630" +post_author: 1 +"ListingKey": "1154231713" +"ListingId": "202604868" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-10T23:02:33Z" +"RFModificationTimestamp": "2026-03-10T23:06:41Z" +"ListPrice": 695000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 45259.0 +"LivingArea": 1117.0 +"BuildingAreaTotal": 1250.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "430 Lewers Street 2802, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ 0 => -157.8281232 1 => 21.2824894 ] +"Latitude": 21.2824894 +"Longitude": -157.8281232 +"YearBuilt": 1976 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Tito Castillo" +"ListOfficeName": "BLUE HAWAII PROPERTIES" +"ListAgentMlsId": "28627" +"ListOfficeMlsId": "PROPHAT" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "If you long for a place high in the sky above one of Earth's most coveted locations, look no further. You found it. Right here. Right Now. For you. This immaculate two-bedroom, two-bathroom unit on the 28th floor is finally available at the prestigious 430 Lewers. This is not "near" Waikiki, nor is it "a stone's throw away from Waikiki"; It is literally right in THE HEART of world-renowned Waikiki. You know, the place where everyone in the world dreams and saves their whole life just to come and visit. Except it can be a place you call home. The main bedroom includes a spacious walk-in closet. The HOA fees include most utilities, such as central A/C. Amenities include a heated pool, a jacuzzi, a sauna and welcoming BBQ areas. It's Pet Friendly! If Hawaii had an eagle, this is what the views would look like from its nest: panoramic and spectacular! - from The Royal Hawaiian Hotel at Waikiki Beach (aka, the "Pink Palace of the Pacific") to Diamond Head. To the Mauka side valleys of Manoa and Palolo, the sparkling, twinkling city lights and everything in between—the views will make you appreciate the phrase, "There is no place like home" every time you walk through the door." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Cable TV,Electricity,Gas,Hot Water,Internet,Maintenance Grounds,Maintenance Structure,None,Sewer" +"AttributionContact": "(808) 732-3000" +"BathroomsFull": 2 +"BuildingName": "Aloha Towers" +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Community Pool,Deck/Porch,Other,Patio,Pool,Recreation Area,Sauna,Trash Chute" +"ConstructionMaterials": "Masonry, Concrete, Stucco" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2026-03-05T23:20:47.790816+00:00" +"DaysOnMarket": 49 +"DaysOnMarketReplication": 19 +"DaysOnMarketReplicationDate": "2026-03-10" +"DaysOnMarketReplicationIncreasingYN": true +"EntryLevel": 28 +"Flooring": "Ceramic Tile,Laminate,Vinyl" +"FrontageType": "Other" +"Furnished": "Partially" +"HumanModifiedYN": true +"Inclusions": "AC Central,Cable TV,Convection Oven,Dishwasher,Disposal,Dryer,Kitchenware,Linens,Other,Range Hood,Refrigerator,Smoke Detector,Washer" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 635-1882" +"ListAgentEmail": "myhawaiibroker@gmail.com" +"ListAgentOfficePhone": "(808) 635-1882" +"ListAgentPreferredPhone": "(808) 635-1882" +"ListOfficeEmail": "My Hawaii Broker@gmail.com" +"ListOfficeKey": "5243095" +"ListOfficeKeyNumeric": "5243095" +"ListOfficePhone": "(808) 635-1882" +"ListingContractDate": "2026-02-19" +"ListingKeyNumeric": 1154231713 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1996.0 +"MajorChangeTimestamp": "2026-03-05T13:15:45Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-02-19" +"OriginalListPrice": 695000.0 +"OriginatingSystemKey": "19304198" +"ParcelNumber": "1-2-6-017-005-0112" +"ParkingFeatures": "Assigned,Covered,One Space" +"ParkingTotal": "1.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-03-04T19:28:01Z" +"PhotosCount": 25 +"PoolFeatures": "Heated" +"PostalCity": "Honolulu" +"PropertyCondition": "Average Condition,Good Condition" +"SecurityFeatures": "Key Card Entry,Security Guard" +"SourceSystemKey": "1154231713" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Lewers" +"StreetNumber": "430" +"StreetNumberNumeric": "430" +"StreetSuffix": "Street" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "2472.0" +"TaxAssessedValue": 695100 +"UnitNumber": "2802" +"View": "Canal, Coastline, City, Mountain(s), Ocean" +"ViewYN": true +"ZoningDescription": "X2 - Apartment Precinct" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1154231713"\n } """ +"AssociationFeeTotal": 1996.0 +"TaxAssessedValueLand": "91200" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "603900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1154231713')" +"provider_name": "HICMLS" +"RecordSignature": -1040263003 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-017-005-0112" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "17599117" +"OriginatingSystemListAgentMemberKey": "3477733" +"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": "79630" } ] +success: true +page_size: 9 +page_count: 477 +count: 4293 +after_key: "" } "RF Response Time" => "0.17 seconds" ] ]
