3 Properties
Sort by:
5 months ago
2 months ago
2 weeks ago
Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:3 [ "RF Cache Key: ec353f34c003769d44f619ecb77baeb54a502eda69e5d1264b960aa579dd4685" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5716 +items: array:3 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5715 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1152486278" +"ListingId": "202603378" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T03:01:06Z" +"RFModificationTimestamp": "2026-03-30T03:04:40Z" +"ListPrice": 1050000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 5103.0 +"LivingArea": 960.0 +"BuildingAreaTotal": 960.0 +"City": "Honolulu" +"PostalCode": "96817" +"UnparsedAddress": "2014 B Nu Place, Honolulu, Hawaii 96817" +"Coordinates": array:2 [ 0 => -157.8562031 1 => 21.3277579 ] +"Latitude": 21.3277579 +"Longitude": -157.8562031 +"YearBuilt": 1957 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Todd T Murata" +"ListOfficeName": "Heyer & Associates LLC" +"ListAgentMlsId": "16957" +"ListOfficeMlsId": "HEYE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Location Location Location... Conveniently just off Judd Street in Liliha. This cozy 3 bedroom 1 bath home approximately 960 sq. ft. living and approximately 5103 sq.ft. of land, with attached 2 car carport. Home was built in the 50's. Needs TLC, please bring your creativity and contractors. Easy access on and off freeway both east and west. FIRST OPEN HOUSE 3/15 2-5pm." +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 692-0060" +"BathroomsFull": 1 +"ConstructionMaterials": "Concrete,Single Wall" +"CountyOrParish": "Oahu" +"CreationDate": "2026-03-10T07:17:20.780881+00:00" +"DaysOnMarket": 26 +"DaysOnMarketReplication": 15 +"DaysOnMarketReplicationDate": "2026-03-29" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,Seller Disclosure" +"ElementarySchool": "Lanakila" +"Flooring": "Laminate, Other" +"Furnished": "Unfurnished" +"GarageSpaces": "2.0" +"GarageYN": true +"HighSchool": "Mckinley" +"Inclusions": "Cable TV,Disposal,Range/Oven" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 222-3145" +"ListAgentEmail": "todd@heyer-associates.com" +"ListAgentKey": "10772252" +"ListAgentKeyNumeric": "10772252" +"ListAgentOfficePhone": "(808) 692-0060" +"ListAgentPreferredPhone": "(808) 222-3145" +"ListAgentStateLicense": "RB-20349" +"ListOfficeEmail": "jeanne@heyer-associates.com" +"ListOfficeKey": "2587830" +"ListOfficeKeyNumeric": "2587830" +"ListOfficePhone": "(808) 692-0060" +"ListingContractDate": "2026-03-09" +"ListingKeyNumeric": 1152486278 +"ListingService": "Full Service" +"LotFeatures": "Dead End,Flag Lot,Level" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2026-03-18T10:27:10Z" +"MiddleOrJuniorSchool": "Kawananakoa" +"MlsStatus": "Active" +"OnMarketDate": "2026-03-09" +"OriginalListPrice": 1050000.0 +"OriginatingSystemKey": "19262468" +"ParcelNumber": "1-1-7-039-044-0000" +"ParkingFeatures": "Two Car Garage,Two Spaces" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-03-09T23:00:01Z" +"PhotosCount": 14 +"PoolFeatures": "None" +"PostalCity": "Honolulu" +"PropertyCondition": "Updated/Remodeled,Repairs Major" +"RoadFrontageType": "County Road" +"SourceSystemKey": "1152486278" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Nu" +"StreetNumber": "2014 B" +"StreetSuffix": "Place" +"SubdivisionName": "LILIHA" +"TaxAnnualAmount": "3480.0" +"TaxAssessedValue": 1024000 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,High Speed Internet Available,Other,Sewer Available,Water Available" +"View": "None" +"WaterSource": "Public" +"YearBuiltEffective": 2020 +"ZoningDescription": "07 - R-3.5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1152486278"\n } """ +"HumanModifiedYN": false +"TaxAssessedValueLand": "870800" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "153200" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1152486278')" +"provider_name": "HICMLS" +"RecordSignature": 1297433445 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-7-039-044-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486212" +"OriginatingSystemListAgentMemberKey": "3473340" +"Media": array:14 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004928210252" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152486278/e36511e1e2942992a713843800a85915.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 534431 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152486278/thumbnail-e36511e1e2942992a713843800a85915.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772252" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587830" "MediaCategory" => null "MediaObjectID" => "DSC00529.JPG" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "HEYE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004928210252 "PropertySubType" => "Single Family Residence" "RecordSignature" => -1393768950 "PreferredPhotoYN" => null "ResourceRecordID" => "202603378" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1152486278" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-03-09T21:31:12.817-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152486278 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19326303" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2026-03-09T21:31:12.817-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19262468" ] 1 => array:57 [ "Order" => 2 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004928402714" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152486278/388ada3ab29e314ce4ab1f9e0dd97bc6.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 591816 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152486278/thumbnail-388ada3ab29e314ce4ab1f9e0dd97bc6.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772252" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587830" "MediaCategory" => null "MediaObjectID" => "DSC00530.JPG" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "HEYE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004928402714 "PropertySubType" => "Single Family Residence" "RecordSignature" => -1393768950 "PreferredPhotoYN" => null "ResourceRecordID" => "202603378" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1152486278" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-03-09T22:16:22.007-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152486278 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19326515" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2026-03-09T22:16:22.007-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19262468" ] 2 => array:57 [ "Order" => 3 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004928402715" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152486278/f57abb43e3afa3df3a57d42cfa6c0dca.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 853194 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152486278/thumbnail-f57abb43e3afa3df3a57d42cfa6c0dca.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772252" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587830" "MediaCategory" => null "MediaObjectID" => "DSC00535.JPG" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "HEYE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004928402715 "PropertySubType" => "Single Family Residence" "RecordSignature" => -1393768950 "PreferredPhotoYN" => null "ResourceRecordID" => "202603378" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1152486278" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-03-09T22:16:22.007-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152486278 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19326516" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2026-03-09T22:16:22.007-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19262468" ] 3 => array:57 [ "Order" => 4 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004928402716" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152486278/567f926619b4cad840a4fe3887d58caf.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 664533 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152486278/thumbnail-567f926619b4cad840a4fe3887d58caf.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772252" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587830" "MediaCategory" => null "MediaObjectID" => "DSC00536.JPG" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "HEYE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004928402716 "PropertySubType" => "Single Family Residence" "RecordSignature" => -1393768950 "PreferredPhotoYN" => null "ResourceRecordID" => "202603378" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1152486278" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-03-09T22:16:22.007-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152486278 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19326517" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2026-03-09T22:16:22.007-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19262468" ] 4 => array:57 [ "Order" => 5 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004928210261" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152486278/8a9d9a0ce59fd63bda99c016f6e28c16.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 565387 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152486278/thumbnail-8a9d9a0ce59fd63bda99c016f6e28c16.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772252" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587830" "MediaCategory" => null "MediaObjectID" => "DSC00552.JPG" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "HEYE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004928210261 "PropertySubType" => "Single Family Residence" "RecordSignature" => -1393768950 "PreferredPhotoYN" => null "ResourceRecordID" => "202603378" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1152486278" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-03-09T22:59:25.620-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152486278 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19326312" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2026-03-09T22:59:25.620-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19262468" ] 5 => array:57 [ "Order" => 6 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004928402717" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152486278/6ce50ece78c71f37f5b12ec208619925.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 527545 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152486278/thumbnail-6ce50ece78c71f37f5b12ec208619925.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772252" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587830" "MediaCategory" => null "MediaObjectID" => "DSC00532.JPG" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "HEYE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004928402717 "PropertySubType" => "Single Family Residence" "RecordSignature" => -1393768950 "PreferredPhotoYN" => null "ResourceRecordID" => "202603378" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1152486278" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-03-09T22:16:22.007-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152486278 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19326518" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2026-03-09T22:16:22.007-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19262468" ] 6 => array:57 [ "Order" => 7 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004928402718" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152486278/c00ac8a535d5ffe0f86b090cf0b36640.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 258320 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152486278/thumbnail-c00ac8a535d5ffe0f86b090cf0b36640.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772252" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587830" "MediaCategory" => null "MediaObjectID" => "DSC00543.JPG" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => true "ListOfficeMlsId" => "HEYE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004928402718 "PropertySubType" => "Single Family Residence" "RecordSignature" => -1393768950 "PreferredPhotoYN" => null "ResourceRecordID" => "202603378" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1152486278" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-03-09T22:16:22.007-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152486278 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19326519" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2026-03-09T22:16:22.007-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19262468" ] 7 => array:57 [ "Order" => 8 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004928210253" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152486278/77c0a314c7cdf8f9c39ea1737dddf96c.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 304365 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152486278/thumbnail-77c0a314c7cdf8f9c39ea1737dddf96c.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772252" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587830" "MediaCategory" => null "MediaObjectID" => "DSC00547.JPG" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "HEYE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004928210253 "PropertySubType" => "Single Family Residence" "RecordSignature" => -1393768950 "PreferredPhotoYN" => null "ResourceRecordID" => "202603378" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1152486278" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-03-09T22:59:25.620-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152486278 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19326304" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2026-03-09T22:59:25.620-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19262468" ] 8 => array:57 [ "Order" => 9 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004928210254" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152486278/79e7156fe139d64b1033520f8da1a094.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 301151 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152486278/thumbnail-79e7156fe139d64b1033520f8da1a094.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772252" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587830" "MediaCategory" => null "MediaObjectID" => "DSC00548.JPG" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "HEYE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004928210254 "PropertySubType" => "Single Family Residence" "RecordSignature" => -1393768950 "PreferredPhotoYN" => null "ResourceRecordID" => "202603378" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1152486278" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-03-09T22:59:25.620-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152486278 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19326305" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2026-03-09T22:59:25.620-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19262468" ] 9 => array:57 [ "Order" => 10 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004928210255" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152486278/b5b771d0ffd3525f67b1b275e893fd6a.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 280589 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152486278/thumbnail-b5b771d0ffd3525f67b1b275e893fd6a.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772252" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587830" "MediaCategory" => null "MediaObjectID" => "DSC00549.JPG" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "HEYE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004928210255 "PropertySubType" => "Single Family Residence" "RecordSignature" => -1393768950 "PreferredPhotoYN" => null "ResourceRecordID" => "202603378" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1152486278" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-03-09T22:59:25.620-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152486278 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19326306" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2026-03-09T22:59:25.620-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19262468" ] 10 => array:57 [ "Order" => 11 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004928210256" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152486278/da2d3baabfba9fb437f8afa08e587621.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 259065 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152486278/thumbnail-da2d3baabfba9fb437f8afa08e587621.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772252" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587830" "MediaCategory" => null "MediaObjectID" => "DSC00557.JPG" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "HEYE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004928210256 "PropertySubType" => "Single Family Residence" "RecordSignature" => -1393768950 "PreferredPhotoYN" => null "ResourceRecordID" => "202603378" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1152486278" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-03-09T22:59:25.620-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152486278 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19326307" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2026-03-09T22:59:25.620-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19262468" ] 11 => array:57 [ "Order" => 12 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004928210258" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152486278/d424ce46b8ba49ca0a57cb58ff5f26b0.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 289785 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152486278/thumbnail-d424ce46b8ba49ca0a57cb58ff5f26b0.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772252" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587830" "MediaCategory" => null "MediaObjectID" => "DSC00556.JPG" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "HEYE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004928210258 "PropertySubType" => "Single Family Residence" "RecordSignature" => -1393768950 "PreferredPhotoYN" => null "ResourceRecordID" => "202603378" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1152486278" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-03-09T22:59:25.620-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152486278 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19326309" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2026-03-09T22:59:25.620-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19262468" ] 12 => array:57 [ "Order" => 13 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004928210259" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152486278/31ddda4edc8f2b6bcbec371d89dac573.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 282533 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152486278/thumbnail-31ddda4edc8f2b6bcbec371d89dac573.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772252" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587830" "MediaCategory" => null "MediaObjectID" => "DSC00555.JPG" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "HEYE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004928210259 "PropertySubType" => "Single Family Residence" "RecordSignature" => -1393768950 "PreferredPhotoYN" => null "ResourceRecordID" => "202603378" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1152486278" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-03-09T22:59:25.620-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152486278 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19326310" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2026-03-09T22:59:25.620-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19262468" ] 13 => array:57 [ "Order" => 14 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004928210260" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1152486278/65c7fe82f03805fcfb30db35f236cac9.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 260023 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1152486278/thumbnail-65c7fe82f03805fcfb30db35f236cac9.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10772252" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587830" "MediaCategory" => null "MediaObjectID" => "DSC00553.JPG" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "HEYE" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004928210260 "PropertySubType" => "Single Family Residence" "RecordSignature" => -1393768950 "PreferredPhotoYN" => null "ResourceRecordID" => "202603378" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1152486278" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-03-09T22:59:25.620-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1152486278 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19326311" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2026-03-09T22:59:25.620-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19262468" ] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5709 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1149794058" +"ListingId": "202528312" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-10T22:18:11Z" +"RFModificationTimestamp": "2026-02-10T22:24:04Z" +"ListPrice": 310000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 182124.0 +"LivingArea": 799.0 +"BuildingAreaTotal": 896.0 +"City": "Mililani" +"PostalCode": "96789" +"UnparsedAddress": "95-020 Waihonu Street C202, Mililani, Hawaii 96789" +"Coordinates": array:2 [ 0 => -158.0095783 1 => 21.4508308 ] +"Latitude": 21.4508308 +"Longitude": -158.0095783 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kelsea C Cass" +"ListOfficeName": "Compass" +"ListAgentMlsId": "46879" +"ListOfficeMlsId": "COHI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Two-bedroom, one-bath Mililani condo with a functional floor plan and well-maintained interior, except for the bathroom, which requires completion. Sold As Is; property does not qualify for financing. Buyer to perform due diligence. Conveniently located near shopping, dining, parks, and freeway access, with easy access to the parking area. Short sale subject to lender approval." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AttributionContact": "(808) 825-4277" +"BathroomsFull": 1 +"BuildingName": "Cathedral Pt-Melemanu" +"CommunityFeatures": "Community Pool" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-01-08T05:42:49.385089+00:00" +"DaysOnMarket": 60 +"DaysOnMarketReplication": 2 +"DaysOnMarketReplicationDate": "2026-02-10" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Lender Approval Required" +"EntryLevel": 2 +"Flooring": "Laminate" +"Furnished": "Partially" +"HumanModifiedYN": true +"Inclusions": "Ceiling Fan,Disposal,Dryer,Microwave,Range/Oven,Refrigerator,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 351-4152" +"ListAgentEmail": "kelsea.cass@compass.com" +"ListAgentKey": "10779698" +"ListAgentKeyNumeric": "10779698" +"ListAgentOfficePhone": "(808) 825-4277" +"ListAgentPreferredPhone": "(808) 351-4152" +"ListAgentStateLicense": "RS-78751" +"ListOfficeEmail": "julie.meier@compass.com" +"ListOfficeKey": "3944102" +"ListOfficeKeyNumeric": "3944102" +"ListOfficePhone": "(808) 825-4277" +"ListingContractDate": "2026-01-05" +"ListingKeyNumeric": 1149794058 +"ListingService": "Full Service" +"MLSAreaMajor": "Central" +"MaintenanceExpense": 767.0 +"MajorChangeTimestamp": "2026-02-10T12:17:52Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-01-05" +"OpenParkingYN": true +"OriginalListPrice": 310000.0 +"OriginatingSystemKey": "19182064" +"ParcelNumber": "1-9-5-012-017-0008" +"ParkingFeatures": "One Space" +"ParkingTotal": "1.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-01-06T20:18:00Z" +"PhotosCount": 8 +"PostalCity": "Mililani" +"PropertyCondition": "Updated/Remodeled,Repairs Major" +"SourceSystemKey": "1149794058" +"SpecialListingConditions": "Short Sale" +"StateOrProvince": "HI" +"StreetName": "Waihonu" +"StreetNumber": "95-020" +"StreetSuffix": "Street" +"SubdivisionName": "WAIPIO ACRES/WAIKALANI WOODLANDS" +"TaxAnnualAmount": "1620.0" +"TaxAssessedValue": 360700 +"UnitNumber": "C202" +"View": "None" +"ZoningDescription": "11 - A-1 Low Density Apartment" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1149794058"\n } """ +"AssociationFeeTotal": 767.0 +"TaxAssessedValueLand": "111800" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "248900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1149794058')" +"provider_name": "HICMLS" +"RecordSignature": 623748775 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-5-012-017-0008" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15465233" +"OriginatingSystemListAgentMemberKey": "10650819" +"Media": array:8 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004762629713" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1149794058/8367428c288765db2de231f785244610.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 413307 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1149794058/thumbnail-8367428c288765db2de231f785244610.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10779698" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "3944102" "MediaCategory" => null "MediaObjectID" => "95-020 Waihonu-1.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active Under Contract" "HumanModifiedYN" => false "ListOfficeMlsId" => "COHI" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004762629713 "PropertySubType" => "Condominium" "RecordSignature" => -331055391 "PreferredPhotoYN" => null "ResourceRecordID" => "202528312" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1149794058" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-01-06T20:17:50.463-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1149794058 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19197030" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-01-06T20:17:50.463-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19182064" ] 1 => array:57 [ "Order" => 2 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004762629714" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1149794058/07da53871c27ce23b18760b791b98af3.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 375267 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1149794058/thumbnail-07da53871c27ce23b18760b791b98af3.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10779698" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "3944102" "MediaCategory" => null "MediaObjectID" => "95-020 Waihonu-2.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active Under Contract" "HumanModifiedYN" => false "ListOfficeMlsId" => "COHI" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004762629714 "PropertySubType" => "Condominium" "RecordSignature" => -331055391 "PreferredPhotoYN" => null "ResourceRecordID" => "202528312" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1149794058" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-01-06T20:17:50.463-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1149794058 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19197031" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-01-06T20:17:50.463-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19182064" ] 2 => array:57 [ "Order" => 3 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004762629715" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1149794058/f791ec57b37af0cf3d305cfcf3d6dda2.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 344777 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1149794058/thumbnail-f791ec57b37af0cf3d305cfcf3d6dda2.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10779698" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "3944102" "MediaCategory" => null "MediaObjectID" => "95-020 Waihonu-3.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active Under Contract" "HumanModifiedYN" => false "ListOfficeMlsId" => "COHI" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004762629715 "PropertySubType" => "Condominium" "RecordSignature" => -331055391 "PreferredPhotoYN" => null "ResourceRecordID" => "202528312" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1149794058" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-01-06T20:17:50.463-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1149794058 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19197032" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-01-06T20:17:50.463-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19182064" ] 3 => array:57 [ "Order" => 4 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004762629716" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1149794058/629fe6738b8510d82b6fbefa4f2933f5.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 379498 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1149794058/thumbnail-629fe6738b8510d82b6fbefa4f2933f5.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10779698" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "3944102" "MediaCategory" => null "MediaObjectID" => "95-020 Waihonu-4.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active Under Contract" "HumanModifiedYN" => false "ListOfficeMlsId" => "COHI" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004762629716 "PropertySubType" => "Condominium" "RecordSignature" => -331055391 "PreferredPhotoYN" => null "ResourceRecordID" => "202528312" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1149794058" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-01-06T20:17:50.463-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1149794058 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19197033" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-01-06T20:17:50.463-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19182064" ] 4 => array:57 [ "Order" => 5 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004762629717" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1149794058/9ca2407a99dd8bf4afcf5ad24aa6b06d.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 323328 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1149794058/thumbnail-9ca2407a99dd8bf4afcf5ad24aa6b06d.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10779698" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "3944102" "MediaCategory" => null "MediaObjectID" => "95-020 Waihonu-7.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active Under Contract" "HumanModifiedYN" => false "ListOfficeMlsId" => "COHI" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004762629717 "PropertySubType" => "Condominium" "RecordSignature" => -331055391 "PreferredPhotoYN" => null "ResourceRecordID" => "202528312" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1149794058" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-01-06T20:17:50.463-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1149794058 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19197034" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-01-06T20:17:50.463-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19182064" ] 5 => array:57 [ "Order" => 6 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004762629718" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1149794058/9e2e3b14dd76336bb6c64f32b9085e60.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 459389 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1149794058/thumbnail-9e2e3b14dd76336bb6c64f32b9085e60.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10779698" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "3944102" "MediaCategory" => null "MediaObjectID" => "95-020 Waihonu-8.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active Under Contract" "HumanModifiedYN" => false "ListOfficeMlsId" => "COHI" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004762629718 "PropertySubType" => "Condominium" "RecordSignature" => -331055391 "PreferredPhotoYN" => null "ResourceRecordID" => "202528312" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1149794058" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-01-06T20:17:50.463-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1149794058 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19197035" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-01-06T20:17:50.463-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19182064" ] 6 => array:57 [ "Order" => 7 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004762629719" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1149794058/cc9a370e82e40a20ab85ac8a6b344f90.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 603649 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1149794058/thumbnail-cc9a370e82e40a20ab85ac8a6b344f90.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10779698" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "3944102" "MediaCategory" => null "MediaObjectID" => "95-020 Waihonu-5.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active Under Contract" "HumanModifiedYN" => false "ListOfficeMlsId" => "COHI" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004762629719 "PropertySubType" => "Condominium" "RecordSignature" => -331055391 "PreferredPhotoYN" => null "ResourceRecordID" => "202528312" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1149794058" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-01-06T20:17:50.463-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1149794058 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19197036" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-01-06T20:17:50.463-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19182064" ] 7 => array:57 [ "Order" => 8 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004762629720" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1149794058/eee3f364092a4a0e7d4f619cc9f05218.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 688381 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1149794058/thumbnail-eee3f364092a4a0e7d4f619cc9f05218.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10779698" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "3944102" "MediaCategory" => null "MediaObjectID" => "95-020 Waihonu-6.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active Under Contract" "HumanModifiedYN" => false "ListOfficeMlsId" => "COHI" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004762629720 "PropertySubType" => "Condominium" "RecordSignature" => -331055391 "PreferredPhotoYN" => null "ResourceRecordID" => "202528312" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => "IDX" "ResourceRecordKey" => "1149794058" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null "ImageSizeDescription" => null "SourceSystemMediaKey" => null "ModificationTimestamp" => "2026-01-06T20:17:50.463-00:00" "OriginatingSystemName" => "HICMLS" "MediaStatusDescription" => null "OriginatingSystemSubName" => "HICMLS_HBR" "ResourceRecordKeyNumeric" => 1149794058 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19197037" "PropertySubTypeAdditional" => "Condominium" "MediaModificationTimestamp" => "2026-01-06T20:17:50.463-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19182064" ] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5712 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "1145440848" +"ListingId": "202524702" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-01T21:18:46Z" +"RFModificationTimestamp": "2025-11-11T14:11:12Z" +"ListPrice": 590000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 6600.0 +"LivingArea": 976.0 +"BuildingAreaTotal": 976.0 +"City": "Wahiawa" +"PostalCode": "96786" +"UnparsedAddress": "216 Walker Avenue, Wahiawa, Hawaii 96786" +"Coordinates": array:2 [ 0 => -158.0273433 1 => 21.4935478 ] +"Latitude": 21.4935478 +"Longitude": -158.0273433 +"YearBuilt": 1958 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Felix He" +"ListOfficeName": "Central Pacific Properties Inc" +"ListAgentMlsId": "49313" +"ListOfficeMlsId": "CPPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "BRING YOUR CONTRACTOR! This prime 6,600 sq. ft. lot in the heart of Wahiawa offers incredible potential for development or renovation. Perfect for builders or investors, this property is priced to sell and presents a fantastic opportunity in a vibrant, convenient community. Enjoy proximity to local dining, shopping, and essential services, as well as nearby parks and recreation. The actual number of bedrooms, bathrooms, and living area may differ from tax office records. As-is Sale." +"ArchitecturalStyle": "Detached" +"AttributionContact": "(808) 521-3777" +"BathroomsFull": 1 +"CommunityFeatures": "None" +"ConstructionMaterials": "Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-11-01T21:22:41.357078+00:00" +"DaysOnMarketReplicationDate": "2025-11-01" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,Seller Disclosure" +"Flooring": "Other" +"FoundationDetails": "Slab" +"FrontageType": "Other" +"Furnished": "Unfurnished" +"Inclusions": "None" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 258-7631" +"ListAgentEmail": "zhihe808@gmail.com" +"ListAgentKey": "13402223" +"ListAgentKeyNumeric": "13402223" +"ListAgentOfficePhone": "(808) 521-3777" +"ListAgentPreferredPhone": "(808) 258-7631" +"ListAgentStateLicense": "RS-81644" +"ListOfficeEmail": "joannie.jav@gmail.com" +"ListOfficeKey": "2587912" +"ListOfficeKeyNumeric": "2587912" +"ListOfficePhone": "(808) 521-3777" +"ListingContractDate": "2025-11-01" +"ListingKeyNumeric": 1145440848 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Other, Level" +"MLSAreaMajor": "Central" +"MajorChangeTimestamp": "2025-11-01T11:16:32Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-11-01" +"OriginalListPrice": 590000.0 +"OriginatingSystemKey": "19077487" +"ParcelNumber": "1-7-4-002-017-0000" +"ParkingFeatures": "Three or more Spaces" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 3 +"PoolFeatures": "None" +"PostalCity": "Wahiawa" +"PropertyCondition": "Updated/Remodeled,Repairs Major" +"SourceSystemKey": "1145440848" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Walker" +"StreetNumber": "216" +"StreetNumberNumeric": "216" +"StreetSuffix": "Avenue" +"SubdivisionName": "WAHIAWA AREA" +"TaxAnnualAmount": "2687.64" +"TaxAssessedValue": 767900 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Electricity Available,Phone Available,Sewer Available,Water Available" +"View": "None" +"WaterSource": "Public" +"YearBuiltEffective": 2024 +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1145440848"\n } """ +"HumanModifiedYN": true +"TaxAssessedValueLand": "604800" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "163100" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1145440848')" +"provider_name": "HICMLS" +"RecordSignature": -1608978604 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-7-4-002-017-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486294" +"OriginatingSystemListAgentMemberKey": "14108909" +"Media": array:3 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004584197324" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1145440848/7edbad0536586f8efa134b6b3df3424c.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 510740 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1145440848/thumbnail-7edbad0536586f8efa134b6b3df3424c.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13402223" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587912" "MediaCategory" => null "MediaObjectID" => "GetMedia.jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "CPPI" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004584197324 "PropertySubType" => "Single Family Residence" "RecordSignature" => -689647800 "PreferredPhotoYN" => null "ResourceRecordID" => "202524702" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1145440848" "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" => 1145440848 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "19077491" "PropertySubTypeAdditional" => "Single Family Residence" "MediaModificationTimestamp" => "2025-11-11T00:21:56.957-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "19077487" ] 1 => array:57 [ "Order" => 2 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2004584197325" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1145440848/5368eb789ad2790754f90a1cc66293c0.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 539418 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1145440848/thumbnail-5368eb789ad2790754f90a1cc66293c0.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "13402223" "PropertyType" => "Residential" "ResourceName" => "Property" "ListOfficeKey" => "2587912" "MediaCategory" => null "MediaObjectID" => "GetMedia (1).jpeg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "CPPI" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2004584197325 "PropertySubType" => "Single Family Residence" "RecordSignature" => -689647800 "PreferredPhotoYN" => null "ResourceRecordID" => "202524702" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null …19 ] 2 => array:57 [ …57] ] } ] +success: true +page_size: 3 +page_count: 1 +count: 3 +after_key: "" } ] "RF Query: /Property?$select=ALL&$orderby=meta_value date DESC&$top=18&$filter=(StandardStatus eq 'Active') and PropertyCondition eq 'Updated/Remodeled,Repairs Major'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#6339 +items: array:3 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6358 +post_id: "61674" +post_author: 1 +"ListingKey": "1145440848" +"ListingId": "202524702" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-01T21:18:46Z" +"RFModificationTimestamp": "2025-11-11T14:11:12Z" +"ListPrice": 590000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 6600.0 +"LivingArea": 976.0 +"BuildingAreaTotal": 976.0 +"City": "Wahiawa" +"PostalCode": "96786" +"UnparsedAddress": "216 Walker Avenue, Wahiawa, Hawaii 96786" +"Coordinates": array:2 [ 0 => -158.0273433 1 => 21.4935478 ] +"Latitude": 21.4935478 +"Longitude": -158.0273433 +"YearBuilt": 1958 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Felix He" +"ListOfficeName": "Central Pacific Properties Inc" +"ListAgentMlsId": "49313" +"ListOfficeMlsId": "CPPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "BRING YOUR CONTRACTOR! This prime 6,600 sq. ft. lot in the heart of Wahiawa offers incredible potential for development or renovation. Perfect for builders or investors, this property is priced to sell and presents a fantastic opportunity in a vibrant, convenient community. Enjoy proximity to local dining, shopping, and essential services, as well as nearby parks and recreation. The actual number of bedrooms, bathrooms, and living area may differ from tax office records. As-is Sale." +"ArchitecturalStyle": "Detached" +"AttributionContact": "(808) 521-3777" +"BathroomsFull": 1 +"CommunityFeatures": "None" +"ConstructionMaterials": "Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-11-01T21:22:41.357078+00:00" +"DaysOnMarketReplicationDate": "2025-11-01" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,Seller Disclosure" +"Flooring": "Other" +"FoundationDetails": "Slab" +"FrontageType": "Other" +"Furnished": "Unfurnished" +"Inclusions": "None" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 258-7631" +"ListAgentEmail": "zhihe808@gmail.com" +"ListAgentKey": "13402223" +"ListAgentKeyNumeric": "13402223" +"ListAgentOfficePhone": "(808) 521-3777" +"ListAgentPreferredPhone": "(808) 258-7631" +"ListAgentStateLicense": "RS-81644" +"ListOfficeEmail": "joannie.jav@gmail.com" +"ListOfficeKey": "2587912" +"ListOfficeKeyNumeric": "2587912" +"ListOfficePhone": "(808) 521-3777" +"ListingContractDate": "2025-11-01" +"ListingKeyNumeric": 1145440848 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Other, Level" +"MLSAreaMajor": "Central" +"MajorChangeTimestamp": "2025-11-01T11:16:32Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-11-01" +"OriginalListPrice": 590000.0 +"OriginatingSystemKey": "19077487" +"ParcelNumber": "1-7-4-002-017-0000" +"ParkingFeatures": "Three or more Spaces" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 3 +"PoolFeatures": "None" +"PostalCity": "Wahiawa" +"PropertyCondition": "Updated/Remodeled,Repairs Major" +"SourceSystemKey": "1145440848" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Walker" +"StreetNumber": "216" +"StreetNumberNumeric": "216" +"StreetSuffix": "Avenue" +"SubdivisionName": "WAHIAWA AREA" +"TaxAnnualAmount": "2687.64" +"TaxAssessedValue": 767900 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Electricity Available,Phone Available,Sewer Available,Water Available" +"View": "None" +"WaterSource": "Public" +"YearBuiltEffective": 2024 +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1145440848"\n } """ +"HumanModifiedYN": true +"TaxAssessedValueLand": "604800" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "163100" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1145440848')" +"provider_name": "HICMLS" +"RecordSignature": -1608978604 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-7-4-002-017-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486294" +"OriginatingSystemListAgentMemberKey": "14108909" +"Media": array:3 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] ] +"ID": "61674" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6356 +post_id: "78372" +post_author: 1 +"ListingKey": "1149794058" +"ListingId": "202528312" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-10T22:18:11Z" +"RFModificationTimestamp": "2026-02-10T22:24:04Z" +"ListPrice": 310000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 182124.0 +"LivingArea": 799.0 +"BuildingAreaTotal": 896.0 +"City": "Mililani" +"PostalCode": "96789" +"UnparsedAddress": "95-020 Waihonu Street C202, Mililani, Hawaii 96789" +"Coordinates": array:2 [ 0 => -158.0095783 1 => 21.4508308 ] +"Latitude": 21.4508308 +"Longitude": -158.0095783 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kelsea C Cass" +"ListOfficeName": "Compass" +"ListAgentMlsId": "46879" +"ListOfficeMlsId": "COHI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Two-bedroom, one-bath Mililani condo with a functional floor plan and well-maintained interior, except for the bathroom, which requires completion. Sold As Is; property does not qualify for financing. Buyer to perform due diligence. Conveniently located near shopping, dining, parks, and freeway access, with easy access to the parking area. Short sale subject to lender approval." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AttributionContact": "(808) 825-4277" +"BathroomsFull": 1 +"BuildingName": "Cathedral Pt-Melemanu" +"CommunityFeatures": "Community Pool" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-01-08T05:42:49.385089+00:00" +"DaysOnMarket": 60 +"DaysOnMarketReplication": 2 +"DaysOnMarketReplicationDate": "2026-02-10" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Lender Approval Required" +"EntryLevel": 2 +"Flooring": "Laminate" +"Furnished": "Partially" +"HumanModifiedYN": true +"Inclusions": "Ceiling Fan,Disposal,Dryer,Microwave,Range/Oven,Refrigerator,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 351-4152" +"ListAgentEmail": "kelsea.cass@compass.com" +"ListAgentKey": "10779698" +"ListAgentKeyNumeric": "10779698" +"ListAgentOfficePhone": "(808) 825-4277" +"ListAgentPreferredPhone": "(808) 351-4152" +"ListAgentStateLicense": "RS-78751" +"ListOfficeEmail": "julie.meier@compass.com" +"ListOfficeKey": "3944102" +"ListOfficeKeyNumeric": "3944102" +"ListOfficePhone": "(808) 825-4277" +"ListingContractDate": "2026-01-05" +"ListingKeyNumeric": 1149794058 +"ListingService": "Full Service" +"MLSAreaMajor": "Central" +"MaintenanceExpense": 767.0 +"MajorChangeTimestamp": "2026-02-10T12:17:52Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-01-05" +"OpenParkingYN": true +"OriginalListPrice": 310000.0 +"OriginatingSystemKey": "19182064" +"ParcelNumber": "1-9-5-012-017-0008" +"ParkingFeatures": "One Space" +"ParkingTotal": "1.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-01-06T20:18:00Z" +"PhotosCount": 8 +"PostalCity": "Mililani" +"PropertyCondition": "Updated/Remodeled,Repairs Major" +"SourceSystemKey": "1149794058" +"SpecialListingConditions": "Short Sale" +"StateOrProvince": "HI" +"StreetName": "Waihonu" +"StreetNumber": "95-020" +"StreetSuffix": "Street" +"SubdivisionName": "WAIPIO ACRES/WAIKALANI WOODLANDS" +"TaxAnnualAmount": "1620.0" +"TaxAssessedValue": 360700 +"UnitNumber": "C202" +"View": "None" +"ZoningDescription": "11 - A-1 Low Density Apartment" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1149794058"\n } """ +"AssociationFeeTotal": 767.0 +"TaxAssessedValueLand": "111800" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "248900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1149794058')" +"provider_name": "HICMLS" +"RecordSignature": 623748775 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-5-012-017-0008" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15465233" +"OriginatingSystemListAgentMemberKey": "10650819" +"Media": array:8 [ 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] ] +"ID": "78372" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6361 +post_id: "79874" +post_author: 1 +"ListingKey": "1152486278" +"ListingId": "202603378" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T03:01:06Z" +"RFModificationTimestamp": "2026-03-30T03:04:40Z" +"ListPrice": 1050000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 5103.0 +"LivingArea": 960.0 +"BuildingAreaTotal": 960.0 +"City": "Honolulu" +"PostalCode": "96817" +"UnparsedAddress": "2014 B Nu Place, Honolulu, Hawaii 96817" +"Coordinates": array:2 [ 0 => -157.8562031 1 => 21.3277579 ] +"Latitude": 21.3277579 +"Longitude": -157.8562031 +"YearBuilt": 1957 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Todd T Murata" +"ListOfficeName": "Heyer & Associates LLC" +"ListAgentMlsId": "16957" +"ListOfficeMlsId": "HEYE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Location Location Location... Conveniently just off Judd Street in Liliha. This cozy 3 bedroom 1 bath home approximately 960 sq. ft. living and approximately 5103 sq.ft. of land, with attached 2 car carport. Home was built in the 50's. Needs TLC, please bring your creativity and contractors. Easy access on and off freeway both east and west. FIRST OPEN HOUSE 3/15 2-5pm." +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 692-0060" +"BathroomsFull": 1 +"ConstructionMaterials": "Concrete,Single Wall" +"CountyOrParish": "Oahu" +"CreationDate": "2026-03-10T07:17:20.780881+00:00" +"DaysOnMarket": 26 +"DaysOnMarketReplication": 15 +"DaysOnMarketReplicationDate": "2026-03-29" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,Seller Disclosure" +"ElementarySchool": "Lanakila" +"Flooring": "Laminate, Other" +"Furnished": "Unfurnished" +"GarageSpaces": "2.0" +"GarageYN": true +"HighSchool": "Mckinley" +"Inclusions": "Cable TV,Disposal,Range/Oven" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 222-3145" +"ListAgentEmail": "todd@heyer-associates.com" +"ListAgentKey": "10772252" +"ListAgentKeyNumeric": "10772252" +"ListAgentOfficePhone": "(808) 692-0060" +"ListAgentPreferredPhone": "(808) 222-3145" +"ListAgentStateLicense": "RB-20349" +"ListOfficeEmail": "jeanne@heyer-associates.com" +"ListOfficeKey": "2587830" +"ListOfficeKeyNumeric": "2587830" +"ListOfficePhone": "(808) 692-0060" +"ListingContractDate": "2026-03-09" +"ListingKeyNumeric": 1152486278 +"ListingService": "Full Service" +"LotFeatures": "Dead End,Flag Lot,Level" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2026-03-18T10:27:10Z" +"MiddleOrJuniorSchool": "Kawananakoa" +"MlsStatus": "Active" +"OnMarketDate": "2026-03-09" +"OriginalListPrice": 1050000.0 +"OriginatingSystemKey": "19262468" +"ParcelNumber": "1-1-7-039-044-0000" +"ParkingFeatures": "Two Car Garage,Two Spaces" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-03-09T23:00:01Z" +"PhotosCount": 14 +"PoolFeatures": "None" +"PostalCity": "Honolulu" +"PropertyCondition": "Updated/Remodeled,Repairs Major" +"RoadFrontageType": "County Road" +"SourceSystemKey": "1152486278" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Nu" +"StreetNumber": "2014 B" +"StreetSuffix": "Place" +"SubdivisionName": "LILIHA" +"TaxAnnualAmount": "3480.0" +"TaxAssessedValue": 1024000 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,High Speed Internet Available,Other,Sewer Available,Water Available" +"View": "None" +"WaterSource": "Public" +"YearBuiltEffective": 2020 +"ZoningDescription": "07 - R-3.5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1152486278"\n } """ +"HumanModifiedYN": false +"TaxAssessedValueLand": "870800" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "153200" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1152486278')" +"provider_name": "HICMLS" +"RecordSignature": 1297433445 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-7-039-044-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486212" +"OriginatingSystemListAgentMemberKey": "3473340" +"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": "79874" } ] +success: true +page_size: 3 +page_count: 1 +count: 3 +after_key: "" } "RF Response Time" => "0.14 seconds" ] "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(StandardStatus eq 'Active') and PropertyCondition eq 'Updated/Remodeled,Repairs Major'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#6307 +items: array:3 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6310 +post_id: "79874" +post_author: 1 +"ListingKey": "1152486278" +"ListingId": "202603378" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-30T03:01:06Z" +"RFModificationTimestamp": "2026-03-30T03:04:40Z" +"ListPrice": 1050000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 5103.0 +"LivingArea": 960.0 +"BuildingAreaTotal": 960.0 +"City": "Honolulu" +"PostalCode": "96817" +"UnparsedAddress": "2014 B Nu Place, Honolulu, Hawaii 96817" +"Coordinates": array:2 [ 0 => -157.8562031 1 => 21.3277579 ] +"Latitude": 21.3277579 +"Longitude": -157.8562031 +"YearBuilt": 1957 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Todd T Murata" +"ListOfficeName": "Heyer & Associates LLC" +"ListAgentMlsId": "16957" +"ListOfficeMlsId": "HEYE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Location Location Location... Conveniently just off Judd Street in Liliha. This cozy 3 bedroom 1 bath home approximately 960 sq. ft. living and approximately 5103 sq.ft. of land, with attached 2 car carport. Home was built in the 50's. Needs TLC, please bring your creativity and contractors. Easy access on and off freeway both east and west. FIRST OPEN HOUSE 3/15 2-5pm." +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 692-0060" +"BathroomsFull": 1 +"ConstructionMaterials": "Concrete,Single Wall" +"CountyOrParish": "Oahu" +"CreationDate": "2026-03-10T07:17:20.780881+00:00" +"DaysOnMarket": 26 +"DaysOnMarketReplication": 15 +"DaysOnMarketReplicationDate": "2026-03-29" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,Seller Disclosure" +"ElementarySchool": "Lanakila" +"Flooring": "Laminate, Other" +"Furnished": "Unfurnished" +"GarageSpaces": "2.0" +"GarageYN": true +"HighSchool": "Mckinley" +"Inclusions": "Cable TV,Disposal,Range/Oven" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 222-3145" +"ListAgentEmail": "todd@heyer-associates.com" +"ListAgentKey": "10772252" +"ListAgentKeyNumeric": "10772252" +"ListAgentOfficePhone": "(808) 692-0060" +"ListAgentPreferredPhone": "(808) 222-3145" +"ListAgentStateLicense": "RB-20349" +"ListOfficeEmail": "jeanne@heyer-associates.com" +"ListOfficeKey": "2587830" +"ListOfficeKeyNumeric": "2587830" +"ListOfficePhone": "(808) 692-0060" +"ListingContractDate": "2026-03-09" +"ListingKeyNumeric": 1152486278 +"ListingService": "Full Service" +"LotFeatures": "Dead End,Flag Lot,Level" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2026-03-18T10:27:10Z" +"MiddleOrJuniorSchool": "Kawananakoa" +"MlsStatus": "Active" +"OnMarketDate": "2026-03-09" +"OriginalListPrice": 1050000.0 +"OriginatingSystemKey": "19262468" +"ParcelNumber": "1-1-7-039-044-0000" +"ParkingFeatures": "Two Car Garage,Two Spaces" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-03-09T23:00:01Z" +"PhotosCount": 14 +"PoolFeatures": "None" +"PostalCity": "Honolulu" +"PropertyCondition": "Updated/Remodeled,Repairs Major" +"RoadFrontageType": "County Road" +"SourceSystemKey": "1152486278" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Nu" +"StreetNumber": "2014 B" +"StreetSuffix": "Place" +"SubdivisionName": "LILIHA" +"TaxAnnualAmount": "3480.0" +"TaxAssessedValue": 1024000 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,High Speed Internet Available,Other,Sewer Available,Water Available" +"View": "None" +"WaterSource": "Public" +"YearBuiltEffective": 2020 +"ZoningDescription": "07 - R-3.5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1152486278"\n } """ +"HumanModifiedYN": false +"TaxAssessedValueLand": "870800" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "153200" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1152486278')" +"provider_name": "HICMLS" +"RecordSignature": 1297433445 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-7-039-044-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486212" +"OriginatingSystemListAgentMemberKey": "3473340" +"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": "79874" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6308 +post_id: "78372" +post_author: 1 +"ListingKey": "1149794058" +"ListingId": "202528312" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-02-10T22:18:11Z" +"RFModificationTimestamp": "2026-02-10T22:24:04Z" +"ListPrice": 310000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 182124.0 +"LivingArea": 799.0 +"BuildingAreaTotal": 896.0 +"City": "Mililani" +"PostalCode": "96789" +"UnparsedAddress": "95-020 Waihonu Street C202, Mililani, Hawaii 96789" +"Coordinates": array:2 [ 0 => -158.0095783 1 => 21.4508308 ] +"Latitude": 21.4508308 +"Longitude": -158.0095783 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kelsea C Cass" +"ListOfficeName": "Compass" +"ListAgentMlsId": "46879" +"ListOfficeMlsId": "COHI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Two-bedroom, one-bath Mililani condo with a functional floor plan and well-maintained interior, except for the bathroom, which requires completion. Sold As Is; property does not qualify for financing. Buyer to perform due diligence. Conveniently located near shopping, dining, parks, and freeway access, with easy access to the parking area. Short sale subject to lender approval." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AttributionContact": "(808) 825-4277" +"BathroomsFull": 1 +"BuildingName": "Cathedral Pt-Melemanu" +"CommunityFeatures": "Community Pool" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-01-08T05:42:49.385089+00:00" +"DaysOnMarket": 60 +"DaysOnMarketReplication": 2 +"DaysOnMarketReplicationDate": "2026-02-10" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Lender Approval Required" +"EntryLevel": 2 +"Flooring": "Laminate" +"Furnished": "Partially" +"HumanModifiedYN": true +"Inclusions": "Ceiling Fan,Disposal,Dryer,Microwave,Range/Oven,Refrigerator,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 351-4152" +"ListAgentEmail": "kelsea.cass@compass.com" +"ListAgentKey": "10779698" +"ListAgentKeyNumeric": "10779698" +"ListAgentOfficePhone": "(808) 825-4277" +"ListAgentPreferredPhone": "(808) 351-4152" +"ListAgentStateLicense": "RS-78751" +"ListOfficeEmail": "julie.meier@compass.com" +"ListOfficeKey": "3944102" +"ListOfficeKeyNumeric": "3944102" +"ListOfficePhone": "(808) 825-4277" +"ListingContractDate": "2026-01-05" +"ListingKeyNumeric": 1149794058 +"ListingService": "Full Service" +"MLSAreaMajor": "Central" +"MaintenanceExpense": 767.0 +"MajorChangeTimestamp": "2026-02-10T12:17:52Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-01-05" +"OpenParkingYN": true +"OriginalListPrice": 310000.0 +"OriginatingSystemKey": "19182064" +"ParcelNumber": "1-9-5-012-017-0008" +"ParkingFeatures": "One Space" +"ParkingTotal": "1.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-01-06T20:18:00Z" +"PhotosCount": 8 +"PostalCity": "Mililani" +"PropertyCondition": "Updated/Remodeled,Repairs Major" +"SourceSystemKey": "1149794058" +"SpecialListingConditions": "Short Sale" +"StateOrProvince": "HI" +"StreetName": "Waihonu" +"StreetNumber": "95-020" +"StreetSuffix": "Street" +"SubdivisionName": "WAIPIO ACRES/WAIKALANI WOODLANDS" +"TaxAnnualAmount": "1620.0" +"TaxAssessedValue": 360700 +"UnitNumber": "C202" +"View": "None" +"ZoningDescription": "11 - A-1 Low Density Apartment" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1149794058"\n } """ +"AssociationFeeTotal": 767.0 +"TaxAssessedValueLand": "111800" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "248900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1149794058')" +"provider_name": "HICMLS" +"RecordSignature": 623748775 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-5-012-017-0008" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15465233" +"OriginatingSystemListAgentMemberKey": "10650819" +"Media": array:8 [ 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] ] +"ID": "78372" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6311 +post_id: "61674" +post_author: 1 +"ListingKey": "1145440848" +"ListingId": "202524702" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-01T21:18:46Z" +"RFModificationTimestamp": "2025-11-11T14:11:12Z" +"ListPrice": 590000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 6600.0 +"LivingArea": 976.0 +"BuildingAreaTotal": 976.0 +"City": "Wahiawa" +"PostalCode": "96786" +"UnparsedAddress": "216 Walker Avenue, Wahiawa, Hawaii 96786" +"Coordinates": array:2 [ 0 => -158.0273433 1 => 21.4935478 ] +"Latitude": 21.4935478 +"Longitude": -158.0273433 +"YearBuilt": 1958 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Felix He" +"ListOfficeName": "Central Pacific Properties Inc" +"ListAgentMlsId": "49313" +"ListOfficeMlsId": "CPPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "BRING YOUR CONTRACTOR! This prime 6,600 sq. ft. lot in the heart of Wahiawa offers incredible potential for development or renovation. Perfect for builders or investors, this property is priced to sell and presents a fantastic opportunity in a vibrant, convenient community. Enjoy proximity to local dining, shopping, and essential services, as well as nearby parks and recreation. The actual number of bedrooms, bathrooms, and living area may differ from tax office records. As-is Sale." +"ArchitecturalStyle": "Detached" +"AttributionContact": "(808) 521-3777" +"BathroomsFull": 1 +"CommunityFeatures": "None" +"ConstructionMaterials": "Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-11-01T21:22:41.357078+00:00" +"DaysOnMarketReplicationDate": "2025-11-01" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,Seller Disclosure" +"Flooring": "Other" +"FoundationDetails": "Slab" +"FrontageType": "Other" +"Furnished": "Unfurnished" +"Inclusions": "None" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 258-7631" +"ListAgentEmail": "zhihe808@gmail.com" +"ListAgentKey": "13402223" +"ListAgentKeyNumeric": "13402223" +"ListAgentOfficePhone": "(808) 521-3777" +"ListAgentPreferredPhone": "(808) 258-7631" +"ListAgentStateLicense": "RS-81644" +"ListOfficeEmail": "joannie.jav@gmail.com" +"ListOfficeKey": "2587912" +"ListOfficeKeyNumeric": "2587912" +"ListOfficePhone": "(808) 521-3777" +"ListingContractDate": "2025-11-01" +"ListingKeyNumeric": 1145440848 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Other, Level" +"MLSAreaMajor": "Central" +"MajorChangeTimestamp": "2025-11-01T11:16:32Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-11-01" +"OriginalListPrice": 590000.0 +"OriginatingSystemKey": "19077487" +"ParcelNumber": "1-7-4-002-017-0000" +"ParkingFeatures": "Three or more Spaces" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 3 +"PoolFeatures": "None" +"PostalCity": "Wahiawa" +"PropertyCondition": "Updated/Remodeled,Repairs Major" +"SourceSystemKey": "1145440848" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Walker" +"StreetNumber": "216" +"StreetNumberNumeric": "216" +"StreetSuffix": "Avenue" +"SubdivisionName": "WAHIAWA AREA" +"TaxAnnualAmount": "2687.64" +"TaxAssessedValue": 767900 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Electricity Available,Phone Available,Sewer Available,Water Available" +"View": "None" +"WaterSource": "Public" +"YearBuiltEffective": 2024 +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1145440848"\n } """ +"HumanModifiedYN": true +"TaxAssessedValueLand": "604800" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "163100" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1145440848')" +"provider_name": "HICMLS" +"RecordSignature": -1608978604 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-7-4-002-017-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486294" +"OriginatingSystemListAgentMemberKey": "14108909" +"Media": array:3 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] ] +"ID": "61674" } ] +success: true +page_size: 3 +page_count: 1 +count: 3 +after_key: "" } "RF Response Time" => "0.15 seconds" ] ]