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=3438&$filter=(StandardStatus eq 'Active') and (StandardStatus eq 'For Sale' OR RFTransactionType eq 'For Sale')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#6317 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6332 +post_id: "49346" +post_author: 1 +"ListingKey": "1104298135" +"ListingId": "202503343" +"PropertyType": "Commercial Sale" +"PropertySubType": "Industrial" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-18T09:18:11Z" +"RFModificationTimestamp": "2025-11-18T09:21:21Z" +"ListPrice": 1215000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 21050.0 +"LivingArea": 0 +"BuildingAreaTotal": 5992.0 +"City": "Hilo" +"PostalCode": "96720" +"UnparsedAddress": "750 Kanoelehua Avenue, Hilo, Hawaii 96720" +"Coordinates": array:2 [ 0 => -155.06405298303 1 => 19.706692815561 ] +"Latitude": 19.706692815561 +"Longitude": -155.06405298303 +"YearBuilt": 2017 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Steven H Lau" +"ListOfficeName": "Lau & Associates, LLC" +"ListAgentMlsId": "26862" +"ListOfficeMlsId": "SLAU" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "This is a leasehold property. Prime commercial property for sale (leasehold) on busy Kanoelehua Ave., just minutes to Hilo International Airport. The center is known as Lehua Center and includes four retail spaces totaling 5,992 sq. ft. of leasable area. Each space has it's own private restroom and is individually metered for electricity. There are 25 parking stalls. The land area is 21,050 sq. ft. and is zoned MCX-20. The original 60 year ground lease has approximately 44 years remaining with known ground rents until 8/31/29. The fee is not available, but there is a first right of refusal. The entire property is leased to a single tenant until September 30, 2027. That tenant in turn subleases the individual spaces. Lessor is responsible for building exterior repairs and common area maintenance. Lessee is responsible maintaining the interior spaces. Priced below 2023 appraisal. Please DO NOT disturb tenants. Offer subject to inspection." +"AttributionContact": "(808) 223-0074" +"BuildingFeatures": "Public Restrooms" +"BuildingName": "None" +"BusinessType": "Recreation, Retail" +"CLIP": 9745378044 +"ConstructionMaterials": "Wood Frame" +"Cooling": "Other" +"CountyOrParish": "Hawaii" +"CreationDate": "2025-04-07T18:17:14.329597+00:00" +"DaysOnMarket": 408 +"DaysOnMarketReplication": 265 +"DaysOnMarketReplicationDate": "2025-11-17" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "See Remarks" +"EntryLevel": 1 +"ExistingLeaseType": "Other" +"Flooring": "Concrete" +"HumanModifiedYN": true +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LeaseAmount": "2932.0" +"LeaseExpiration": "2069-08-31" +"Levels": "One" +"ListAgentDirectPhone": "(808) 223-0074" +"ListAgentEmail": "slau@lauassociatesllc.com" +"ListAgentKey": "10777624" +"ListAgentKeyNumeric": "10777624" +"ListAgentOfficePhone": "(808) 223-0074" +"ListAgentPreferredPhone": "(808) 223-0074" +"ListAgentStateLicense": "RB-20307" +"ListOfficeEmail": "slau@lauassociates.com" +"ListOfficeKey": "2585552" +"ListOfficeKeyNumeric": "2585552" +"ListOfficePhone": "(808) 223-0074" +"ListingContractDate": "2025-02-25" +"ListingKeyNumeric": 1104298135 +"ListingService": "Full Service" +"MLSAreaMajor": "S. Hilo" +"MajorChangeTimestamp": "2025-09-19T00:31:47Z" +"MlsStatus": "Active" +"NetOperatingIncome": 106157.0 +"NumberOfUnitsTotal": "4" +"OnMarketDate": "2025-02-25" +"OperatingExpense": "89285.0" +"OriginalListPrice": 1350000.0 +"OriginatingSystemKey": "18528651" +"ParcelNumber": "3-2-2-037-029-0000" +"ParkingFeatures": "On Site" +"PhotosChangeTimestamp": "2025-11-11T00:21:13Z" +"PhotosCount": 24 +"PostalCity": "Hilo" +"PropertyCondition": "Good Condition" +"RoadFrontageType": "City Street" +"SecurityFeatures": "Fire Sprinkler System" +"Sewer": "Septic Tank" +"SourceSystemKey": "1104298135" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Kanoelehua" +"StreetNumber": "750" +"StreetNumberNumeric": "750" +"StreetSuffix": "Avenue" +"SubdivisionName": "WAIAKEA HSELOTS" +"TaxAnnualAmount": "16020.0" +"TaxAssessedValue": 1496100 +"TenantPays": "Common Area Maintenance,Electricity,Gas,HVAC Maintenance,Insurance,Other Tax,Taxes,Trash Collection,Water" +"TotalActualRent": 16287.0 +"Utilities": "Electricity Available,Natural Gas Available" +"YearEstablished": 2017 +"ZoningDescription": "Neighbor Island - See Remarks" +"ListAOR": "HI Central" +"LandTenure": "Lease Hold" +"CustomFields": """ {\n "IncomeInformationSource": "Owner",\n "StreetViewParam": "1$19.707853$-155.064683$337.73$13.33$1.00$CAoSLEFGMVFpcFBOTUVNeTBNVGF0ZV9ZQ1o2Q0dIVzM4NjdpeVVfd2pVOHZEb0d2",\n "CompensationSubjectTo": "",\n "SQFTInterior": "5992",\n "TaxPaidBySellerYN": "",\n "LockBoxModDT": "2025-02-05T01:20:05.103",\n "SellingAgentRemarks": "",\n "LessorName": "Dale Steffens",\n "CommercialSpaceYN": "0",\n "FeeOptions": "None",\n "ExpensesInformationSource": "Owner",\n "Loading": "Loading Area",\n "CompensationMethod": "",\n "LandRecorded": "Regular System",\n "ListingKey": "1104298135",\n "LandlordPhone": "888-888-8888",\n "LandlordName": "Confidential",\n "LeaseFeeMonth": "2932.00",\n "LeaseExpirationYear": "2069",\n "TaxAssessedValueLand": "381400.00",\n "SQFTOther": "0",\n "TaxAssessedValueImprovements": "1116700.00",\n "LeaseRenegotiationDate": "2029-09-01",\n "Easements": "None",\n "TotalIncome": "195442.00",\n "OtherIncome": "0.00",\n "ShowingTimeFlagYN": "1"\n } """ +"TaxAssessedValueLand": "381400" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "1116700" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1104298135')" +"provider_name": "HICMLS" +"RecordSignature": 2036645844 +"UniversalParcelId": "urn:reso:upi:2.0:US:15001:3-2-2-037-029-0000" +"CountrySubdivision": "15001" +"OriginatingSystemListOfficeKey": "3487434" +"OriginatingSystemListAgentMemberKey": "3476508" +"Media": array:24 [ 0 => array:57 [ "Order" => 1 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742104" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/c5f1d657c765937e1f01caf55e77e83a.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 556012 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-c5f1d657c765937e1f01caf55e77e83a.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "QA7A5020.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742104 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574377" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 1 => array:57 [ "Order" => 2 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742105" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/ab5ab381b3b2270531d8f657a5eabcd5.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 442549 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-ab5ab381b3b2270531d8f657a5eabcd5.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "DJI_20250223115815_0163_D.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742105 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574378" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 2 => array:57 [ "Order" => 3 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742106" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/fdbda3234d77fc1b5156bdb0172d3b04.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 559109 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-fdbda3234d77fc1b5156bdb0172d3b04.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "QA7A4947.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742106 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574379" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 3 => array:57 [ "Order" => 4 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742107" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/b8f7032f219c9b6f406da5691afe61f0.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 499429 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-b8f7032f219c9b6f406da5691afe61f0.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "QA7A4957.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742107 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574380" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 4 => array:57 [ "Order" => 5 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742108" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/8fcdf67427c9628918e2b2c2da86f267.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 499307 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-8fcdf67427c9628918e2b2c2da86f267.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "QA7A4962.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742108 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574381" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 5 => array:57 [ "Order" => 6 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742109" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/7e88b55625cb55b3aa800130d45320c2.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 634560 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-7e88b55625cb55b3aa800130d45320c2.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "QA7A4987.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742109 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574382" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 6 => array:57 [ "Order" => 7 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742110" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/14cb24034095159d466d08e1536aafb3.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 679372 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-14cb24034095159d466d08e1536aafb3.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "QA7A4982.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742110 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574383" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 7 => array:57 [ "Order" => 8 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742111" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/4e12f30389d0661440212970bc00b894.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 534405 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-4e12f30389d0661440212970bc00b894.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "QA7A5027.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742111 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574384" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 8 => array:57 [ "Order" => 9 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742112" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/34ee7fddbcf5ab432480acac1d233d5f.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 546723 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-34ee7fddbcf5ab432480acac1d233d5f.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "QA7A5042.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742112 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574385" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 9 => array:57 [ "Order" => 10 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742113" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/1ca0d0983e663d6d1a3f7494b9cb570e.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 569592 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-1ca0d0983e663d6d1a3f7494b9cb570e.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "QA7A5047.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742113 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574386" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 10 => array:57 [ "Order" => 11 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742114" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/4d83376efc32a3b5d5d5f68d150068e1.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 519204 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-4d83376efc32a3b5d5d5f68d150068e1.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "QA7A5005.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742114 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574387" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 11 => array:57 [ "Order" => 12 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742115" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/538099737af948c170130a0909ff181e.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 523827 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-538099737af948c170130a0909ff181e.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "QA7A4997.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742115 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574388" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 12 => array:57 [ "Order" => 13 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742116" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/eb39877c6f4f13e250587838a217de05.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 616919 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-eb39877c6f4f13e250587838a217de05.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "QA7A4967.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742116 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574389" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 13 => array:57 [ "Order" => 14 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742117" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/5c20e2319641eadfc62ce4670911c453.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 576047 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-5c20e2319641eadfc62ce4670911c453.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "DJI_20250223120310_0283_D.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742117 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574390" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 14 => array:57 [ "Order" => 15 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742118" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/33de7413dc80c45094a0d65f53031fb6.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 591812 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-33de7413dc80c45094a0d65f53031fb6.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "DJI_20250223120235_0263_D.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742118 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574391" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 15 => array:57 [ "Order" => 16 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742119" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/a0cf115c2f94a6f5d8875e02810ee48b.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 610136 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-a0cf115c2f94a6f5d8875e02810ee48b.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "DJI_20250223120227_0258_D.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742119 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574392" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 16 => array:57 [ "Order" => 17 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742120" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/ede11e9706ed760c67603b8f995ce1f5.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 639298 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-ede11e9706ed760c67603b8f995ce1f5.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "DJI_20250223115918_0183_D.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742120 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574393" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 17 => array:57 [ "Order" => 18 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742121" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/d6cc5b457eb010e0918a00012ea3ed9e.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 633059 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-d6cc5b457eb010e0918a00012ea3ed9e.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "DJI_20250223115940_0193_D.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742121 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574394" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 18 => array:57 [ "Order" => 19 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742122" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/3fdf5f1c43ca4339b776bfd1d67d4a58.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 634888 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-3fdf5f1c43ca4339b776bfd1d67d4a58.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "DJI_20250223115855_0173_D.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742122 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574395" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 19 => array:57 [ "Order" => 20 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742602" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/6ccab45fca19bfa492dccdb9a19e1198.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 609785 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-6ccab45fca19bfa492dccdb9a19e1198.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "DJI_20250223120108_0223_D.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742602 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574396" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 20 => array:57 [ "Order" => 21 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742603" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/39f5d448ac34b2d11d5493fdbcc6eee8.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 562115 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-39f5d448ac34b2d11d5493fdbcc6eee8.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "DJI_20250223120012_0203_D.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742603 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574397" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 21 => array:57 [ "Order" => 22 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742604" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/30cff1176cc0beecca606abe7bbf1ec0.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 615986 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-30cff1176cc0beecca606abe7bbf1ec0.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "DJI_20250223120402_0303_D.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742604 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "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" => 1104298135 "ChangedByMemberKeyNumeric" => null "OriginatingSystemMediaKey" => "18574398" "PropertySubTypeAdditional" => "Industrial,Commercial" "MediaModificationTimestamp" => "2025-11-11T00:20:34.503-00:00" "SourceSystemResourceRecordKey" => null "InternetEntireListingDisplayYN" => true "OriginatingSystemResourceRecordId" => null "OriginatingSystemResourceRecordKey" => "18528651" ] 22 => array:57 [ "Order" => 23 "ImageOf" => null "ListAOR" => "HI Central" "MediaKey" => "2003816742605" "MediaURL" => "https://cdn.realtyfeed.com/cdn/130/1104298135/2d5a1ff78ed4914ea4611c4c2e4ff57d.webp" "ClassName" => null "MediaHTML" => null "MediaSize" => 626086 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/130/1104298135/thumbnail-2d5a1ff78ed4914ea4611c4c2e4ff57d.webp" "ImageWidth" => null "Permission" => "Public" "ImageHeight" => null "MediaStatus" => null "SyndicateTo" => null "ListAgentKey" => "10777624" "PropertyType" => "Commercial Sale" "ResourceName" => "Property" "ListOfficeKey" => "2585552" "MediaCategory" => null "MediaObjectID" => "DJI_20250223120147_0238_D.jpg" "OffMarketDate" => null "X_MediaStream" => null "SourceSystemID" => "TRESTLE" "StandardStatus" => "Active" "HumanModifiedYN" => false "ListOfficeMlsId" => "SLAU" "LongDescription" => null "MediaAlteration" => null "MediaKeyNumeric" => 2003816742605 "PropertySubType" => "Industrial" "RecordSignature" => 2085174983 "PreferredPhotoYN" => null "ResourceRecordID" => "202503343" "ShortDescription" => null "SourceSystemName" => null "ChangedByMemberID" => null "ListingPermission" => null "ResourceRecordKey" => "1104298135" "ChangedByMemberKey" => null "MediaClassification" => "PHOTO" "OriginatingSystemID" => null …15 ] 23 => array:57 [ …57] ] +"ID": "49346" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6330 +post_id: "59237" +post_author: 1 +"ListingKey": "1136100577" +"ListingId": "202520777" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-18T06:10:00Z" +"RFModificationTimestamp": "2025-11-18T06:14:57Z" +"ListPrice": 415000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 786.0 +"BuildingAreaTotal": 836.0 +"City": "Mililani" +"PostalCode": "96789" +"UnparsedAddress": "94-325 Hokuahiahi Street 331, Mililani, Hawaii 96789" +"Coordinates": array:2 [ 0 => -158.0095783 1 => 21.4508308 ] +"Latitude": 21.4508308 +"Longitude": -158.0095783 +"YearBuilt": 1977 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Derek Kamm" +"ListOfficeName": "Coldwell Banker Island Prop" +"ListAgentMlsId": "42967" +"ListOfficeMlsId": "CBIP04" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Pet Friendly top floor unit in the Hokuahiahi Apartments! Situated on the third floor, this unit offers ample amounts of trade winds and natural light. An efficient layout allows space for living, dining, & relaxation. Recent upgrades to the unit include laminate flooring and fresh paint. Enjoy access to 7 recreation centers, pools, tennis courts, and much more. Hokuahiahi is conveniently located minutes away from supermarkets, restaurants, and parks." +"ArchitecturalStyle": "Low Rise" +"AssociationFee": "55.0" +"AssociationFeeIncludes": "Common Areas,Sewer,Water" +"AssociationName": "MTA" +"BathroomsFull": 1 +"BuildingName": "Hokuahi Apts" +"CommunityFeatures": "None" +"ConstructionMaterials": "Double Wall,Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2025-09-19T20:17:50.976906+00:00" +"DaysOnMarket": 202 +"DaysOnMarketReplication": 59 +"DaysOnMarketReplicationDate": "2025-11-17" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 3 +"Flooring": "Ceramic Tile,Laminate" +"FoundationDetails": "Slab" +"HumanModifiedYN": true +"Inclusions": "Ceiling Fan,Dryer,Range Hood,Range/Oven,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 875-7000" +"ListAgentEmail": "kammtm@islandproperties.com" +"ListAgentKey": "10778304" +"ListAgentKeyNumeric": "10778304" +"ListAgentOfficePhone": "(808) 875-7000" +"ListAgentPreferredPhone": "(808) 875-7000" +"ListAgentStateLicense": "RB-22059" +"ListOfficeEmail": "steve.baker@islandproperties.com" +"ListOfficeKey": "5227261" +"ListOfficeKeyNumeric": "5227261" +"ListOfficePhone": "(808) 875-7000" +"ListingContractDate": "2025-09-19" +"ListingKeyNumeric": 1136100577 +"ListingService": "Full Service" +"MLSAreaMajor": "Central" +"MaintenanceExpense": 699.0 +"MajorChangeTimestamp": "2025-11-17T20:09:41Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-09-19" +"OpenParkingYN": true +"OriginalListPrice": 430000.0 +"OriginatingSystemKey": "18990607" +"ParcelNumber": "1-9-4-005-039-0103" +"ParkingFeatures": "Assigned,Guest,One Space,On Street" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 9 +"PostalCity": "Mililani" +"PropertyCondition": "Good Condition" +"SourceSystemKey": "1136100577" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Hokuahiahi" +"StreetNumber": "94-325" +"StreetSuffix": "Street" +"SubdivisionName": "MILILANI AREA" +"TaxAnnualAmount": "1356.0" +"TaxAssessedValue": 387200 +"UnitNumber": "331" +"View": "None" +"ZoningDescription": "11 - A-1 Low Density Apartment" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1136100577"\n } """ +"AssociationFeeTotal": 754.0 +"TaxAssessedValueLand": "191600" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "195600" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1136100577')" +"provider_name": "HICMLS" +"RecordSignature": 1548479800 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-4-005-039-0103" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "17472415" +"OriginatingSystemListAgentMemberKey": "3483255" +"Media": array:9 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] ] +"ID": "59237" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6333 +post_id: "62605" +post_author: 1 +"ListingKey": "1146440531" +"ListingId": "202525650" +"PropertyType": "Business Opportunity" +"PropertySubType": "Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-18T02:02:04Z" +"RFModificationTimestamp": "2025-11-18T02:03:04Z" +"ListPrice": 120000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 84463.0 +"LivingArea": 0 +"BuildingAreaTotal": 1014.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "1778 Ala Moana Boulevard Ul-07, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ 0 => -157.855676 1 => 21.304547 ] +"Latitude": 21.304547 +"Longitude": -157.855676 +"YearBuilt": 1977 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Huanbo Yu" +"ListOfficeName": "Transglobal Realty" +"ListAgentMlsId": "46993" +"ListOfficeMlsId": "TGRA" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "TURN-KEY SNACK STORE AT WAIKIKI FOR SALE.This particular location is perfectly positioned on the ground level of discovery bay with consistent foot traffic from both tourists and local shoppers. Base rent from 2026 is $2788.5 and CAM is $2636.4.It is a turn-key restaurant ready for its next owner. Do not disturb employees or owners. Showings by appointment only." +"AttributionContact": "(808) 999-9980" +"BuildingName": "Discovery Bay" +"BusinessName": "Waikiki Snack tore" +"BusinessType": "Deli/Catering,Fast Food" +"CommunityFeatures": "None, Shopping" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2025-11-18T02:03:00.262192+00:00" +"DaysOnMarketReplicationDate": "2025-11-17" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"EntryLevel": 1 +"HumanModifiedYN": true +"Inclusions": "Equipment/Fixtures, Lease" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 999-9980" +"ListAgentEmail": "tg.honolulu@gmail.com" +"ListAgentKey": "10774619" +"ListAgentKeyNumeric": "10774619" +"ListAgentOfficePhone": "(808) 999-9980" +"ListAgentPreferredPhone": "(808) 999-9980" +"ListAgentStateLicense": "RB-23070" +"ListOfficeEmail": "tg.honolulu@gmail.com" +"ListOfficeKey": "3984561" +"ListOfficeKeyNumeric": "3984561" +"ListOfficePhone": "(808) 999-9980" +"ListingContractDate": "2025-11-17" +"ListingKeyNumeric": 1146440531 +"ListingService": "Full Service" +"LotFeatures": "Residential Lot" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2025-11-17T16:01:53Z" +"MlsStatus": "Active" +"NetOperatingIncome": 1.0 +"OnMarketDate": "2025-11-17" +"OperatingExpense": "1.0" +"OriginalListPrice": 120000.0 +"OriginatingSystemKey": "19124672" +"ParcelNumber": "1-2-6-012-010-0001" +"ParkingFeatures": "Common" +"PhotosChangeTimestamp": "2025-11-18T01:57:00Z" +"PhotosCount": 10 +"PostalCity": "Honolulu" +"Sewer": "Connected" +"SourceSystemKey": "1146440531" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Ala Moana" +"StreetNumber": "1778" +"StreetNumberNumeric": "1778" +"StreetSuffix": "Boulevard" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "12.0" +"TaxAssessedValue": 8807200 +"TotalActualRent": 1.0 +"UnitNumber": "UL-07" +"Utilities": "Sewer Connected" +"YearEstablished": 2025 +"ZoningDescription": "X2 - Apartment Precinct" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1146440531"\n } """ +"TaxAssessedValueLand": "1327300" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "7479900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1146440531')" +"provider_name": "HICMLS" +"short_address": "Honolulu, Hawaii 96815, USA" +"RecordSignature": 2087292487 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-012-010-0001" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15617025" +"OriginatingSystemListAgentMemberKey": "10723681" +"Media": array:10 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] ] +"ID": "62605" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6329 +post_id: "62516" +post_author: 1 +"ListingKey": "1144959057" +"ListingId": "202524517" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-18T00:48:24Z" +"RFModificationTimestamp": "2025-11-18T00:56:26Z" +"ListPrice": 349000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 813.0 +"BuildingAreaTotal": 831.0 +"City": "Waianae" +"PostalCode": "96792" +"UnparsedAddress": "84-575 Kili Drive 199c, Waianae, Hawaii 96792" +"Coordinates": array:2 [ 0 => -158.185272 1 => 21.446678 ] +"Latitude": 21.446678 +"Longitude": -158.185272 +"YearBuilt": 1974 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Charlene Tongg" +"ListOfficeName": "Keller Williams Honolulu" +"ListAgentMlsId": "41096" +"ListOfficeMlsId": "KWPP" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Top-Floor Oasis with Ocean & Mountain Views in Makaha Valley\r\n Experience island living at its best in this beautifully updated top-floor unit, perfectly situated in a gated community in the serene Makaha Valley. Enjoy stunning ocean, sunset, and mountain views from your private retreat—just one mile from world-famous Makaha Beach and other pristine white-sand shores. With no shared walls on either side, this residence offers exceptional privacy and tranquility. The spacious living area features a large split AC system that keeps the home cool year-round, though you’ll often find the refreshing Makaha Valley breezes provide all the comfort you need.A rare find in an idyllic setting—embrace the beauty, peace, and natural charm of Makaha Valley living. """ +"AssociationFee2": "32.0" +"AssociationFeeIncludes": "Common Areas,Maintenance Grounds,Maintenance Structure,Sewer,Water" +"AttributionContact": "(808) 596-2888" +"BathroomsFull": 1 +"BuildingName": "Makaha Oceanview Estates" +"CommunityFeatures": "Deck/Porch, Patio, Gated" +"ConstructionMaterials": "Concrete,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-11-18T00:11:28.779254+00:00" +"DaysOnMarketReplicationDate": "2025-11-17" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 3 +"Flooring": "Laminate, Marble, Vinyl" +"FrontageType": "Other" +"HumanModifiedYN": true +"Inclusions": "AC Split,Cable TV,Ceiling Fan,Dishwasher,Dryer,Range/Oven,Refrigerator,Washer" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 429-0043" +"ListAgentEmail": "showings@tonggpartners.com" +"ListAgentKey": "10778174" +"ListAgentKeyNumeric": "10778174" +"ListAgentOfficePhone": "(808) 596-2888" +"ListAgentPreferredPhone": "(808) 429-0043" +"ListAgentStateLicense": "RS-65559" +"ListOfficeEmail": "frontdesk946@kw.com" +"ListOfficeKey": "2586166" +"ListOfficeKeyNumeric": "2586166" +"ListOfficePhone": "(808) 596-2888" +"ListingContractDate": "2025-11-17" +"ListingKeyNumeric": 1144959057 +"ListingService": "Full Service" +"MLSAreaMajor": "Leeward" +"MaintenanceExpense": 655.0 +"MajorChangeTimestamp": "2025-11-17T14:07:30Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-11-17" +"OpenParkingYN": true +"OriginalListPrice": 349000.0 +"OriginatingSystemKey": "19072262" +"ParcelNumber": "1-8-4-002-064-0017" +"ParkingFeatures": "Assigned,Guest,Two Spaces,Secured" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-11-18T00:52:00Z" +"PhotosCount": 13 +"PostalCity": "Waianae" +"PropertyCondition": "Excellent" +"SecurityFeatures": "Gated Community,Key Card Entry" +"SourceSystemKey": "1144959057" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Kili" +"StreetNumber": "84-575" +"StreetSuffix": "Drive" +"StructureType": "Townhouse" +"SubdivisionName": "Makaha Oceanview Estates" +"TaxAnnualAmount": "1188.0" +"TaxAssessedValue": 338300 +"UnitNumber": "199C" +"View": "Mountain(s), Ocean" +"ViewYN": true +"YearBuiltEffective": 2018 +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1144959057"\n } """ +"AssociationFeeTotal": 687.0 +"TaxAssessedValueLand": "36700" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "301600" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1144959057')" +"provider_name": "HICMLS" +"RecordSignature": 1336442049 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-8-4-002-064-0017" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "8991040" +"OriginatingSystemListAgentMemberKey": "3482527" +"Media": array:13 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] ] +"ID": "62516" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6331 +post_id: "52971" +post_author: 1 +"ListingKey": "1034046390" +"ListingId": "202303939" +"PropertyType": "For Sale" +"PropertySubType": "Industrial" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-17T21:23:39Z" +"RFModificationTimestamp": "2025-11-17T21:27:49Z" +"ListPrice": 650000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 43560.0 +"LivingArea": 0 +"BuildingAreaTotal": 1680.0 +"City": "Waipahu" +"PostalCode": "96797" +"UnparsedAddress": "94-1100 Kunia Road 56-i, Waipahu, Hawaii 96797" +"Coordinates": array:2 [ 0 => -158.008203 1 => 21.386914 ] +"Latitude": 21.386914 +"Longitude": -158.008203 +"YearBuilt": 2014 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Dee P Daily" +"ListOfficeName": "Marlene's Realty, Inc." +"ListAgentMlsId": "47525" +"ListOfficeMlsId": "MARL" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ SPECTALUAR MILLION DOLLAR VIEW OVER CITY TO FORD ISLAND TO DIAMOND AND OCEAN VIEW FROM YOUR LANI. TURN-KEY ONE ACRE FARM TOTALLY EQUIPED FOR OFF GRID W/ SOLAR ELECTRICTY POWER ACCOMPANIED W/ WATER ENCHATCEMENT W/ REVERSE OSOMOSIS FILTRATION SYSTEMS YOU CAN DRINK WATER.\r\n \r\n NEWER 1100 SQ FT STRUCTURE (THREE ROOMS). NEW KITCHEN W/ CABINETS, REF @ GRANTIE TOP. NEW COMFORD ROOM W/ SHOWER & FACE BOWL FINISHED. NEW LANDING 20X20 FOR RELAXING THAT VIEWS THE VIEW OF THE CITY LIGHTS. STRUCTURED ROOFED SOLAR ROOM TO POWER ABOUT 5 KV'S PER DAY. EXTRA 200 SQ FT STRUCTURE. \r\n \r\n THIS FARM PRODUCES INCOME FROM NATURE FRIUT TRES IE: MANGO, LEMON, ORANGE, JACKFRUIT, LYCHEE, SOUR SAP "CANCER", AVOCADOS, LONGBOY, MONTOY, AND BANANAS AND A FEW MORE TO HARVEST FOR INCOME!\r\n \r\n POSSIBLE 40 CONTAINER (FULL W/ GARDEN TOOL & EQUIPMENT & RIDING LAWN MOVER FOR WEATHER AND SECURITY) AND OPT W/ FULL OFFER.\r\n \r\n THE ACRE IS FULLY FENCED/ PREIMENTER ALARM SYSTEM/ AND A REMOTE CONTROLED BAMBO FENCE FOR CURB APPEAL AND EASY ACCESS /W FLOWER GARDEN ON EACH SIDE OF ENTRANCE.\r\n \r\n LOT IS PRIMARILY FLAT/SLOPE V.S OTHERS IN AREA HAVE ABOUT A VERTICAL "500 FT" DROP ABOUT 200 FEET FROM ROAD DOWN IN GULCH. """ +"AttributionContact": "(808) 293-2413" +"AvailabilityDate": "2023-04-01" +"BusinessName": "KLRF" +"BusinessType": "Mixed" +"CLIP": 2276538963 +"CommunityFeatures": "Business Center,Recreation Area" +"ConstructionMaterials": "Wood Frame" +"Cooling": "None" +"CountyOrParish": "Oahu" +"CreationDate": "2025-04-07T17:13:34.503032+00:00" +"CurrentUse": "Mixed Use" +"DaysOnMarket": 1104 +"DaysOnMarketReplication": 961 +"DaysOnMarketReplicationDate": "2025-11-17" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Lender Approval Required" +"EntryLevel": 1 +"ExistingLeaseType": "See Remarks" +"Flooring": "Concrete" +"HumanModifiedYN": true +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LeaseExpiration": "2025-01-01" +"Levels": "One" +"ListAgentDirectPhone": "(808) 293-2413" +"ListAgentEmail": "mrdrs111@gmail.com" +"ListAgentKey": "10775864" +"ListAgentKeyNumeric": "10775864" +"ListAgentOfficePhone": "(808) 293-2413" +"ListAgentPreferredPhone": "(808) 293-2413" +"ListAgentStateLicense": "RS-79637" +"ListOfficeEmail": "marlenesrealty@aol.com" +"ListOfficeKey": "2588212" +"ListOfficeKeyNumeric": "2588212" +"ListOfficePhone": "(808) 293-2413" +"ListingContractDate": "2023-04-01" +"ListingKeyNumeric": 1034046390 +"ListingService": "Full Service" +"MLSAreaMajor": "Makakilo" +"MajorChangeTimestamp": "2025-02-17T10:22:17Z" +"MlsStatus": "Active" +"OnMarketDate": "2023-04-01" +"OriginatingSystemKey": "17175180" +"ParcelNumber": "1-9-2-004-013-0056" +"ParkingFeatures": "On Site" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 6 +"PostalCity": "Waipahu" +"PropertyCondition": "Updated/Remodeled" +"RoadFrontageType": "City Street" +"SecurityFeatures": "Security Service" +"Sewer": "None" +"SourceSystemKey": "1034046390" +"StateOrProvince": "HI" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "KUNIA" +"StreetNumber": "94-1100" +"StreetSuffix": "Road" +"SubdivisionName": "AG/PRESERVE" +"TaxAnnualAmount": "360.0" +"TaxAssessedValue": 2247000 +"UnitNumber": "56-I" +"Utilities": "Electricity Available,Other,Sewer Not Available" +"YearEstablished": 2012 +"ZoningDescription": "51 - AG-1 Restricted Agricultur" +"ListAOR": "HI Central" +"LandTenure": "Lease Hold" +"Permission": "IDX" +"CustomFields": """ {\n "IncomeInformationSource": "Other",\n "FloorNumber": "1",\n "SQFTInterior": "1480",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "224700.00",\n "LockBoxModDT": "2023-03-08T21:33:35.080",\n "CommercialSpaceYN": "1",\n "ExpensesInformationSource": "Owner",\n "Loading": "None",\n "Easements": "None",\n "LandRecorded": "Regular System",\n "ListingKey": "1034046390",\n "AdvertiseDate": "2023-04-01",\n "TemporarilyWithdrawnDate": "2023-04-08",\n "SellingAgentRemarks": "",\n "CompensationMethod": "",\n "CompensationSubjectTo": "",\n "LeaseFeeMonth": "0.00",\n "LeaseExpirationYear": "2109",\n "SQFTOther": "200",\n "TaxAssessedValueImprovements": "0.00",\n "LessorName": "KLRF",\n "BackOnMarketDate": "2025-02-17",\n "ShowingTimeFlagYN": "1"\n } """ +"TaxAssessedValueLand": "224700" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1034046390')" +"provider_name": "HICMLS" +"RecordSignature": 1587045826 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-2-004-013-0056" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486594" +"OriginatingSystemListAgentMemberKey": "11050703" +"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": "52971" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6334 +post_id: "51196" +post_author: 1 +"ListingKey": "1109199302" +"ListingId": "202507563" +"PropertyType": "Land" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-17T21:22:31Z" +"RFModificationTimestamp": "2025-11-17T21:27:49Z" +"ListPrice": 550000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 43560.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waipahu" +"PostalCode": "96797" +"UnparsedAddress": "56-i Kunia Road 56-i, Waipahu, Hawaii 96797" +"Coordinates": array:2 [ 0 => -158.033408 1 => 21.3859331 ] +"Latitude": 21.3859331 +"Longitude": -158.033408 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Dee P Daily" +"ListOfficeName": "Marlene's Realty, Inc." +"ListAgentMlsId": "47525" +"ListOfficeMlsId": "MARL" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ OPULENT VIEW FROM YOUR LANAI OVERLOOKING COASTLINE..DIAMOND HEAD, KANEOHE, FORD ISLAND, WAIKIKI & MORE!\r\n DINE OUT ON A TENTED 20X20 DECK OVERLOOKING CITY NIGHT LIGHTS.\r\n \r\n PROPERTY IS ONE ACRE LOT LOCATED IN KUNIA LOA RIDGE FARMLANDS WHICH IS ZONED AGRICULTURE 1 LISTED AS LEASE-HOLD.\r\n \r\n THIS IS A TURN KEY FARM... HAS ABOUT 36 INCOME FRUIT BEARING TREES. IT HAS A STRUCTURE THAT IS PERMITTED & FINISHED INSIDE WITH THREE ROOMS. CABINETS,GRANITE SINK TOPS & REF. LOW VOLTAGE. HOT WATER & SHOWER TOO!\r\n \r\n UPGRADES ARE; SOLAR UNIT WITH 110 & 240 VOLTS SUPPLIED BY INVERTOR WITH 12 PANNELS AND 10 BATTERIES. WATER IS RAIN ENCATCHMENT TO TOTES THEN FILTRATION TWICE TO KITCHEN WITH DRINKABLE WATER THROUGHT REVERSE OSMOSIS SYSTEM.\r\n \r\n SECURED BY CHAINLINK FENCING COVERING THE ONE ARCE LOT AND HAS A 20FT SWING GATE W/ REMOTE SYSTEM. ALSO HAS A SECURTY SYSTEM WILL ALERT IF SOMEONE ENTERS LOT PERIMETER.\r\n \r\n THERE ARE TOOLS; FARM EQUIPMENT, RIDING MOWER, LANDSCAPING MACHINES PLUS A 40FT. CONTAINER FULL OF OF A "CONTRACTOR'S" DELIGHT TO SUSTAIN THE FARM. THIS IS AN OPTION TO THE SALE.\r\n \r\n TURNKEY ACCESS TO START RIGHT AWAY... VERSUS BUILDING AND MAKING THE FARM SUSTAINABLE TO BE TOTALLY OFF-GRID! """ +"AssociationName": "KLRF" +"AttributionContact": "(808) 293-2413" +"CommunityFeatures": "Gutter(s)" +"CountyOrParish": "Oahu" +"CreationDate": "2025-04-07T16:30:17.241649+00:00" +"CropsIncludedYN": true +"CurrentUse": "Agricultural, Other" +"DaysOnMarket": 381 +"DaysOnMarketReplication": 238 +"DaysOnMarketReplicationDate": "2025-11-17" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,Owner Is Listing Agent,Principal is Real Estate Licensed" +"ExteriorFeatures": "Sprinkler/Irrigation,Landscaping,Other,Rain Gutters" +"FrontageType": "Other" +"HighSchool": "Waipahu" +"HumanModifiedYN": true +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LeaseExpiration": "2025-12-01" +"ListAgentDirectPhone": "(808) 293-2413" +"ListAgentEmail": "mrdrs111@gmail.com" +"ListAgentKey": "10775864" +"ListAgentKeyNumeric": "10775864" +"ListAgentOfficePhone": "(808) 293-2413" +"ListAgentPreferredPhone": "(808) 293-2413" +"ListAgentStateLicense": "RS-79637" +"ListOfficeEmail": "marlenesrealty@aol.com" +"ListOfficeKey": "2588212" +"ListOfficeKeyNumeric": "2588212" +"ListOfficePhone": "(808) 293-2413" +"ListingContractDate": "2025-03-24" +"ListingKeyNumeric": 1109199302 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Cul-De-Sac,Dead End,Level" +"MLSAreaMajor": "Makakilo" +"MaintenanceExpense": 230.0 +"MajorChangeTimestamp": "2025-03-26T14:12:20Z" +"MiddleOrJuniorSchool": "Waipahu" +"MlsStatus": "Active" +"OnMarketDate": "2025-03-24" +"OriginalListPrice": 550000.0 +"OriginatingSystemKey": "18638617" +"ParcelNumber": "1-9-2-004-013-0056" +"PhotosChangeTimestamp": "2025-11-11T00:23:08Z" +"PhotosCount": 18 +"PossibleUse": "Commercial,Farm,Industrial,Other,Service Business" +"PostalCity": "Waipahu" +"RoadFrontageType": "Private Road,Easement" +"Sewer": "None" +"SourceSystemKey": "1109199302" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "KUNIA" +"StreetNumber": "56-I" +"StreetSuffix": "Road" +"SubdivisionName": "AG/PRESERVE" +"TaxAnnualAmount": "360.0" +"TaxAssessedValue": 224700 +"Topography": "Level, Sloping" +"UnitNumber": "56-I" +"Utilities": "Electricity Available,Water Available,Sewer Not Available" +"View": "Coastline, City, Garden, Mountain(s), Ocean, Sunset, Sunrise" +"ViewYN": true +"WaterSource": "Private" +"ZoningDescription": "51 - AG-1 Restricted Agricultur" +"ListAOR": "HI Central" +"LandTenure": "Lease Hold" +"Permission": "IDX" +"CustomFields": """ {\n "StreetViewParam": "1$21.416417$-158.047305$295.27$13.33$1.00$iZhclaIUlqgYpjly3VBtHA",\n "CompensationSubjectTo": "",\n "StructuresPresentYN": "1",\n "LeaseFeeMonth": "0.00",\n "UtilitiesMeters": "Water",\n "TaxPaidBySellerYN": "",\n "LeaseExpirationYear": "2109",\n "TaxAssessedValueLand": "224700.00",\n "LockBoxModDT": "2025-03-24T13:38:07.220",\n "SellingAgentRemarks": "",\n "TaxAssessedValueImprovements": "0.00",\n "LessorName": "KLRF",\n "FeeOptions": "None",\n "SetBacks": "None",\n "CompensationMethod": "",\n "Easements": "None",\n "LandRecorded": "Regular System",\n "ListingKey": "1109199302",\n "ShowingTimeFlagYN": "1"\n } """ +"Restrictions": "Restrictive Covenant" +"TaxAssessedValueLand": "224700" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1109199302')" +"provider_name": "HICMLS" +"RecordSignature": -258409944 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-2-004-013-0056" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486594" +"OriginatingSystemListAgentMemberKey": "11050703" +"Media": array:18 [ 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] ] +"ID": "51196" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6431 +post_id: "62405" +post_author: 1 +"ListingKey": "1146214749" +"ListingId": "202525387" +"PropertyType": "Land" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-17T20:29:55Z" +"RFModificationTimestamp": "2025-11-17T20:34:33Z" +"ListPrice": 535000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 5220.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Honolulu" +"PostalCode": "96819" +"UnparsedAddress": "1758-a Gulick Avenue, Honolulu, Hawaii 96819" +"Coordinates": array:2 [ 0 => -157.880475 1 => 21.3325456 ] +"Latitude": 21.3325456 +"Longitude": -157.880475 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Brett K Aka" +"ListOfficeName": "REMAX Hawaii" +"ListAgentMlsId": "44367" +"ListOfficeMlsId": "ADVG" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "IMAGINE YOUR DREAM HOME on this centrally located R-5 zoned vacant lot, offering 5,220 sqft of potential where convenience meets tranquility. The soothing sound of a nearby stream enhances the peaceful atmosphere, providing a calming backdrop to the lush surroundings and refreshing mauka breezes. The lot is mostly level, with a gentle slope, offering plenty of flexibility for your ideal home design. With no homes directly behind, you’ll enjoy ultimate privacy and scenic views of the green landscape. This property is part of a 9-unit CPR, with low $80/month association fees. Additionally, the sellers are offering a $10,000 concession to help with buying down your interest rate. Don’t miss the chance to create a home in this serene and sought-after location!" +"AssociationFee": "80.0" +"AttributionContact": "(808) 738-3600" +"CountyOrParish": "Oahu" +"CreationDate": "2025-11-14T21:09:05.119849+00:00" +"CurrentUse": "Residential,Single Family" +"DaysOnMarket": 146 +"DaysOnMarketReplication": 3 +"DaysOnMarketReplicationDate": "2025-11-17" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Principal is Real Estate Licensed" +"FrontageType": "Other" +"HumanModifiedYN": true +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 753-3923" +"ListAgentEmail": "Brett.Aka@remaxhawaii.com" +"ListAgentKey": "10768730" +"ListAgentKeyNumeric": "10768730" +"ListAgentOfficePhone": "(808) 738-3600" +"ListAgentPreferredPhone": "(808) 753-3923" +"ListAgentStateLicense": "RS-75473" +"ListOfficeEmail": "Francis.Van Rafelghem@remaxhawaii.com" +"ListOfficeKey": "2589107" +"ListOfficeKeyNumeric": "2589107" +"ListOfficePhone": "(808) 738-3600" +"ListingContractDate": "2025-11-14" +"ListingKeyNumeric": 1146214749 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Cul-De-Sac, Level" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2025-11-14T11:07:41Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-11-14" +"OriginalListPrice": 535000.0 +"OriginatingSystemKey": "19116626" +"ParcelNumber": "1-1-3-025-101-0009" +"PhotosChangeTimestamp": "2025-11-14T05:50:00Z" +"PhotosCount": 10 +"PostalCity": "Honolulu" +"RoadFrontageType": "Private Road,Easement" +"Sewer": "None" +"SourceSystemKey": "1146214749" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Gulick" +"StreetNumber": "1758-A" +"StreetSuffix": "Avenue" +"SubdivisionName": "KALIHI-LOWER" +"TaxAnnualAmount": "2733.84" +"TaxAssessedValue": 781100 +"Topography": "Level, Sloping" +"Utilities": "None,Sewer Not Available" +"View": "Other" +"ViewYN": true +"VirtualTourURLUnbranded": "https://listings.hetproductions.com/sites/mzgwkvk/unbranded" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1146214749"\n } """ +"Restrictions": "Other Restrictions" +"TaxAssessedValueLand": "771000" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "10100" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1146214749')" +"provider_name": "HICMLS" +"RecordSignature": -725705442 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-3-025-101-0009" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "9695164" +"OriginatingSystemListAgentMemberKey": "9057047" +"Media": array:10 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] ] +"ID": "62405" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6427 +post_id: "62427" +post_author: 1 +"ListingKey": "1146362304" +"ListingId": "202525519" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-17T20:15:22Z" +"RFModificationTimestamp": "2025-11-17T20:17:36Z" +"ListPrice": 24900000.0 +"BathroomsTotalInteger": 9.0 +"BathroomsHalf": 1 +"BedroomsTotal": 10.0 +"LotSizeArea": 40002.0 +"LivingArea": 7701.0 +"BuildingAreaTotal": 9535.0 +"City": "Waimanalo" +"PostalCode": "96795" +"UnparsedAddress": "41-471 Kalanianaole Highway, Waimanalo, Hawaii 96795" +"Coordinates": array:2 [ 0 => -157.7211 1 => 21.346304 ] +"Latitude": 21.346304 +"Longitude": -157.7211 +"YearBuilt": 2022 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Caron B Davis" +"ListOfficeName": "Caron B Realty" +"ListAgentMlsId": "16400" +"ListOfficeMlsId": "CARB" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Live among Hawaii's natural wonders & unsurpassed beauty at this extraordinary Pahonu Beach estate. Spanning\r\n nearly 1 acre, this oceanfront property includes 152 linear feet along the Pacific Ocean. Nestled in a private, gated location, the 2 lot compound offers over 8600 sq ft of living area in its main house, guest house, cottage, and studio. Expansive lawns provide mesmerizing views across the ocean to Manama (Rabbit) Island and stunning vistas of the Koolau Mountains. The main house completed in 2022, sets a new standard of quality craftsmanship. Exceptional design, flawlessly executed using premium materials, creates a luxurious, beautiful, and comfortable home. Floor to ceiling sliding glass doors span the oceanfront side, providing spectacular views of the lush landscaping and ocean. The gourmet kitchen includes top of the line appliances, custom walnut cabinetry, and a disappearing pantry consistent with its sleek, modern design. Next door includes a 3BR oceanfront guest house, 2BR cottage and studio. This irreplaceable compound offers its next owner an opportunity to enjoy a spectacular lifestyle with family and friends in a magnificent oceanfront setting. """ +"ArchitecturalStyle": "Cottage, Detached, Multiplex" +"AttributionContact": "(808) 593-9826" +"BathroomsFull": 8 +"CommunityFeatures": "Deck/Porch,Patio,Storage Facilities" +"ConstructionMaterials": "Double Wall,Masonry,Stone,Stucco,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-11-15T00:50:25.114610+00:00" +"DaysOnMarket": 146 +"DaysOnMarketReplication": 3 +"DaysOnMarketReplicationDate": "2025-11-17" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Principal is Real Estate Licensed,Pet on Property,Seller Disclosure" +"ElementarySchool": "Pope" +"ExteriorFeatures": "Landscaping" +"Fencing": "Fenced, Wall" +"Flooring": "Hardwood, Laminate, Vinyl" +"FrontageType": "Oceanfront, Waterfront" +"Furnished": "Unfurnished" +"GarageYN": true +"HighSchool": "Kailua" +"HumanModifiedYN": true +"Inclusions": "AC Central,AC Split,Auto Garage Door Opener,Book Shelves,Cable TV,Ceiling Fan,Convection Oven,Dishwasher,Disposal,Drapes,Dryer,Intercom,Lawn Sprinkler,Microwave,Photovoltaic - Owned,Range Hood,Range/Oven,Refrigerator,Security System,Smoke Detector,Solar Heater,Washer,Water Heater,Wine Refrigerator" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 286-5256" +"ListAgentEmail": "caron@caronb.com" +"ListAgentKey": "10778505" +"ListAgentKeyNumeric": "10778505" +"ListAgentOfficePhone": "(808) 593-9826" +"ListAgentPreferredPhone": "(808) 286-5256" +"ListAgentStateLicense": "RB-16594" +"ListOfficeEmail": "caron@caronb.com" +"ListOfficeKey": "2587957" +"ListOfficeKeyNumeric": "2587957" +"ListOfficePhone": "(808) 593-9826" +"ListingContractDate": "2025-11-14" +"ListingKeyNumeric": 1146362304 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Interior Lot,Level" +"MLSAreaMajor": "Kailua" +"MajorChangeTimestamp": "2025-11-14T14:44:23Z" +"MiddleOrJuniorSchool": "Waimanalo" +"MlsStatus": "Active" +"OnMarketDate": "2025-11-14" +"OriginalListPrice": 24900000.0 +"OriginatingSystemKey": "19120825" +"ParcelNumber": "1-4-1-001-009-0000" +"ParkingFeatures": "Driveway,Garage,Three or more Spaces" +"ParkingTotal": "8.0" +"PhotosChangeTimestamp": "2025-11-15T00:45:01Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Waimanalo" +"PropertyCondition": "Excellent, Updated/Remodeled" +"RoomType": "Entry/Foyer,Guest Quarters" +"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry" +"Sewer": "Septic Tank" +"SourceSystemKey": "1146362304" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Kalanianaole" +"StreetNumber": "41-471" +"StreetSuffix": "Highway" +"SubdivisionName": "WAIMANALO" +"TaxAnnualAmount": "26820.48" +"TaxAssessedValue": 8593200 +"Topography": "Level" +"Utilities": "Cable Available,Electricity Available,High Speed Internet Available,Septic Available,Underground Utilities,Water Available" +"View": "Coastline, Mountain(s), Ocean, Sunrise" +"ViewYN": true +"VirtualTourURLUnbranded": "https://player.vimeo.com/video/1025292189" +"WaterSource": "Public" +"YearBuiltEffective": 2022 +"ZoningDescription": "03 - R10 - Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1146362304"\n } """ +"TaxAssessedValueLand": "8250300" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "942900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1146362304')" +"provider_name": "HICMLS" +"RecordSignature": 1243689075 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-4-1-001-009-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486339" +"OriginatingSystemListAgentMemberKey": "8834382" +"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": "62427" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6322 +post_id: "62335" +post_author: 1 +"ListingKey": "1144842335" +"ListingId": "202524431" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-17T03:01:31Z" +"RFModificationTimestamp": "2025-11-17T18:38:27Z" +"ListPrice": 310000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 56105.0 +"LivingArea": 484.0 +"BuildingAreaTotal": 555.0 +"City": "Honolulu" +"PostalCode": "96814" +"UnparsedAddress": "1655 Makaloa Street 406, Honolulu, Hawaii 96814" +"Coordinates": array:2 [ 0 => -157.8378908 1 => 21.2922906 ] +"Latitude": 21.2922906 +"Longitude": -157.8378908 +"YearBuilt": 1970 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Joe Extra Ordinario" +"ListOfficeName": "eXp Realty" +"ListAgentMlsId": "50151" +"ListOfficeMlsId": "EXPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Beautifully remodeled, this Kapiolani Manor unit, will surprise you in the best of ways! With a true, enclosed bedroom, you've got the\r\n privacy you deserve, while still enjoying a layout fit for royalty. Wait! There's more! The open concept kitchen flows into the naturally lit living room which is perfect for any movie night or at home dinner event just for your liking. This home has cool floors to walk on,\r\n soft-closing cabinets, intentionally placed storage space, all renovated to leave you happy and complete. And if exploring outdoors is your style, enjoy the rooftop pool deck, with private cabanas and 360 degree views! Not far from Don Quixote, Ala Moana, 24 hour fitness, and so many more adventures to experience. And yes, your HOA covers: Electricity, Cable TV, Internet, Hot Water, Sewer and the lovely common expenses -and you have an assigned parking and storage! If you're looking for a great deal, then THIS HOME IS FOR YOU! """ +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Cable TV,Electricity,Hot Water,Internet,None,Sewer" +"AttributionContact": "(808) 725-2794" +"BathroomsFull": 1 +"BuildingName": "Kapiolani Manor" +"CommunityFeatures": "Community Pool,Deck/Porch,Laundry Facilities,Patio,Pool,Recreation Area,Trash Chute" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2025-11-13T19:25:36.015270+00:00" +"DaysOnMarket": 148 +"DaysOnMarketReplication": 4 +"DaysOnMarketReplicationDate": "2025-11-17" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"EntryLevel": 4 +"Flooring": "Vinyl" +"FrontageType": "Other" +"Furnished": "Unfurnished" +"HumanModifiedYN": false +"Inclusions": "Blinds, Dishwasher, Disposal, Microwave, Range/Oven, Refrigerator" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 990-3443" +"ListAgentEmail": "joe@oteamhawaii.com" +"ListAgentKey": "13403681" +"ListAgentKeyNumeric": "13403681" +"ListAgentOfficePhone": "(808) 725-2794" +"ListAgentPreferredPhone": "(808) 990-3443" +"ListAgentStateLicense": "RS-82651" +"ListOfficeEmail": "hi.broker@exprealty.net" +"ListOfficeKey": "2589160" +"ListOfficeKeyNumeric": "2589160" +"ListOfficePhone": "(808) 725-2794" +"ListingContractDate": "2025-11-13" +"ListingKeyNumeric": 1144842335 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 905.28 +"MajorChangeTimestamp": "2025-11-13T09:21:26Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-11-13" +"OpenParkingYN": true +"OriginalListPrice": 310000.0 +"OriginatingSystemKey": "19069850" +"ParcelNumber": "1-2-3-022-052-0006" +"ParkingFeatures": "Assigned,One Space" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-11-13T19:20:01Z" +"PhotosCount": 20 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Key Card Entry" +"SourceSystemKey": "1144842335" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Makaloa" +"StreetNumber": "1655" +"StreetNumberNumeric": "1655" +"StreetSuffix": "Street" +"SubdivisionName": "HOLIDAY MART" +"TaxAnnualAmount": "1223.64" +"TaxAssessedValue": 349600 +"UnitNumber": "406" +"View": "None" +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=JKsyFhuyz7v&mls=1" +"ZoningDescription": "32 - B-2 Community Business Dis" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1144842335"\n } """ +"AssociationFeeTotal": 905.0 +"TaxAssessedValueLand": "31600" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "318000" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1144842335')" +"provider_name": "HICMLS" +"RecordSignature": 1105117873 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-022-052-0006" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10013908" +"OriginatingSystemListAgentMemberKey": "14946221" +"Media": array:20 [ 0 => array:57 [ …57] 1 => array:57 [ …57] 2 => array:57 [ …57] 3 => array:57 [ …57] 4 => array:57 [ …57] 5 => array:57 [ …57] 6 => array:57 [ …57] 7 => array:57 [ …57] 8 => array:57 [ …57] 9 => array:57 [ …57] 10 => array:57 [ …57] 11 => array:57 [ …57] 12 => array:57 [ …57] 13 => array:57 [ …57] 14 => array:57 [ …57] 15 => array:57 [ …57] 16 => array:57 [ …57] 17 => array:57 [ …57] 18 => array:57 [ …57] 19 => array:57 [ …57] ] +"ID": "62335" } ] +success: true +page_size: 9 +page_count: 411 +count: 3692 +after_key: "" } "RF Response Time" => "0.17 seconds" ] ]
