Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=18&$skip=4122&$filter=(StandardStatus eq 'Active') and (StandardStatus eq 'Active' OR RFTransactionType eq 'Active')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4382 +items: array:18 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4367 +post_id: "56779" +post_author: 1 +"ListingKey": "1125629562" +"ListingId": "202517483" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-09-27T22:45:12Z" +"RFModificationTimestamp": "2025-11-11T04:54:33Z" +"ListPrice": 340000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 8581.0 +"LivingArea": 510.0 +"BuildingAreaTotal": 510.0 +"City": "Honolulu" +"PostalCode": "96822" +"UnparsedAddress": "1145 Davenport Street 206, Honolulu, Hawaii 96822" +"Coordinates": array:2 [ …2] +"Latitude": 21.305346 +"Longitude": -157.8413793 +"YearBuilt": 1969 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Shalay K Hokoana" +"ListOfficeName": "Keller Williams Honolulu" +"ListAgentMlsId": "51537" +"ListOfficeMlsId": "KWPP02" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Welcome to urban paradise in Makiki! Discover prime city living in this charming 1 bedroom, 1 bathroom corner unit nestled in a low-rise building with low association and maintenance fees.\r\n Step inside to find newly completed flooring that adds a touch of elegance to the modern interior. The kitchen features a convenient gas range, perfect for culinary enthusiasts. Adjacent, an in-unit washer and dryer offer ultimate convenience.\r\n Located in the heart of Makiki, this condominium boasts close proximity to everything you need.\r\n Additional perks include covered parking for added convenience. Whether you're a first-time homebuyer or looking to downsize without compromising on location and amenities, this condominium offers the perfect blend of comfort, convenience, and city living.\r\n Don't miss out on this rare opportunity to own a piece of Makiki urban oasis. Schedule your showing today and experience the best of Honolulu living! """ +"ArchitecturalStyle": "Low Rise" +"AssociationFeeIncludes": "Hot Water,Maintenance Grounds,Maintenance Structure,Sewer,Water" +"AttributionContact": "(808) 596-2888" +"BathroomsFull": 1 +"BuildingName": "1145 Davenport" +"CLIP": 9413620108 +"CoListAgentDirectPhone": "(808) 476-3668" +"CoListAgentEmail": "jonnahlashay@kw.com" +"CoListAgentFullName": "Jonnah Lashay Respicio" +"CoListAgentKey": "20837435" +"CoListAgentKeyNumeric": "20837435" +"CoListAgentMlsId": "52257" +"CoListAgentPreferredPhone": "(808) 476-3668" +"CoListOfficeEmail": "frontdesk946@kw.com" +"CoListOfficeKey": "2589257" +"CoListOfficeKeyNumeric": "2589257" +"CoListOfficeMlsId": "KWPP02" +"CoListOfficeName": "Keller Williams Honolulu" +"CoListOfficePhone": "(808) 596-2888" +"CommonWalls": "End Unit" +"CommunityFeatures": "None" +"ConstructionMaterials": "Hollow Tile" +"CountyOrParish": "Oahu" +"CreationDate": "2025-08-06T01:20:40.251772+00:00" +"DaysOnMarket": 257 +"DaysOnMarketReplication": 55 +"DaysOnMarketReplicationDate": "2025-09-27" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 2 +"Flooring": "Vinyl" +"Furnished": "Unfurnished" +"Inclusions": "Ceiling Fan,Disposal,Dryer,Range Hood,Refrigerator,Washer" +"RFTransactionType": "For Sale" +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 670-9069" +"ListAgentEmail": "shalayhokoana@kw.com" +"ListAgentKey": "18891957" +"ListAgentKeyNumeric": "18891957" +"ListAgentOfficePhone": "(808) 596-2888" +"ListAgentPreferredPhone": "(808) 670-9069" +"ListAgentStateLicense": "RS-84334" +"ListOfficeEmail": "frontdesk946@kw.com" +"ListOfficeKey": "2589257" +"ListOfficeKeyNumeric": "2589257" +"ListOfficePhone": "(808) 596-2888" +"ListingContractDate": "2025-08-03" +"ListingKeyNumeric": 1125629562 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 368.0 +"MajorChangeTimestamp": "2025-08-05T15:15:08Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-08-03" +"OriginalListPrice": 340000.0 +"OriginatingSystemKey": "18907889" +"ParcelNumber": "1-2-4-019-032-0009" +"ParkingFeatures": "Covered,One Space" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 17 +"PostalCity": "Honolulu" +"PropertyCondition": "Average Condition" +"SourceSystemKey": "1125629562" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Davenport" +"StreetNumber": "1145" +"StreetNumberNumeric": "1145" +"StreetSuffix": "Street" +"SubdivisionName": "MAKIKI AREA" +"TaxAnnualAmount": "684.0" +"TaxAssessedValue": 338700 +"UnitNumber": "206" +"View": "City" +"ViewYN": true +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1125629562"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 368.0 +"TaxAssessedValueLand": "115500" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "223200" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1125629562')" +"provider_name": "HICMLS" +"RecordSignature": -830644126 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-4-019-032-0009" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10703442" +"OriginatingSystemCoListOfficeKey": "10703442" +"OriginatingSystemListAgentMemberKey": "16041257" +"OriginatingSystemCoListAgentMemberKey": "16563937" +"Media": array:17 [ …17] +"ID": "56779" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4369 +post_id: "60222" +post_author: 1 +"ListingKey": "1137653192" +"ListingId": "202521717" +"PropertyType": "For Sale" +"PropertySubType": "Multi Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-11T06:22:01Z" +"RFModificationTimestamp": "2025-11-11T10:56:22Z" +"ListPrice": 1980000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 8314.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Wahiawa" +"PostalCode": "96786" +"UnparsedAddress": "142 Lakeview Circle, Wahiawa, Hawaii 96786" +"Coordinates": array:2 [ …2] +"Latitude": 21.4913463 +"Longitude": -158.0350444 +"YearBuilt": 1974 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Vincent Lao" +"ListOfficeName": "Five Star Realty, Inc." +"ListAgentMlsId": "22205" +"ListOfficeMlsId": "FIVE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Discover a rare opportunity to own an 11-unit apartment building in the highly desirable Wilikina area. Perfectly designed for income generation, this property features eleven 1-bedroom units, each with a dedicated parking stall, offering convenience and appeal to tenants. Recent upgrades in 2023, including a new roof and fresh exterior paint, enhance the building's curb appeal and long-term durability. A coin-operated community laundry area on the ground floor provides an additional revenue stream. Conveniently located near schools, shopping centers, restaurants, and highways, this property ensures ease of access for residents while maintaining strong rental demand. Whether you're starting your investment journey or expanding an existing portfolio, this property is a must-see! Net income about $130,000 with CAP rate about 7%. Schedule a viewing today and take the first step toward securing your future income!" +"AttributionContact": "(808) 382-6871" +"CoListAgentDirectPhone": "(808) 220-3093" +"CoListAgentEmail": "Michael@Five Star Realty.org" +"CoListAgentFullName": "Michael L Vuong" +"CoListAgentKey": "13403057" +"CoListAgentKeyNumeric": "13403057" +"CoListAgentMlsId": "49774" +"CoListAgentPreferredPhone": "(808) 220-3093" +"CoListOfficeEmail": "vincent@fivestarrealty.org" +"CoListOfficeKey": "2588170" +"CoListOfficeKeyNumeric": "2588170" +"CoListOfficeMlsId": "FIVE" +"CoListOfficeName": "Five Star Realty, Inc." +"CoListOfficePhone": "(808) 382-6871" +"CommunityFeatures": "None" +"ConstructionMaterials": "Masonry,Stucco,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-10-06T20:55:21.787639+00:00" +"DaysOnMarket": 193 +"DaysOnMarketReplication": 4 +"DaysOnMarketReplicationDate": "2025-10-10" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 382-6871" +"ListAgentEmail": "Vincent@Five Star Realty.org" +"ListAgentKey": "10772352" +"ListAgentKeyNumeric": "10772352" +"ListAgentOfficePhone": "(808) 382-6871" +"ListAgentPreferredPhone": "(808) 382-6871" +"ListAgentStateLicense": "RB-18181" +"ListOfficeEmail": "vincent@fivestarrealty.org" +"ListOfficeKey": "2588170" +"ListOfficeKeyNumeric": "2588170" +"ListOfficePhone": "(808) 382-6871" +"ListingContractDate": "2025-10-06" +"ListingKeyNumeric": 1137653192 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Level" +"MLSAreaMajor": "Central" +"MajorChangeTimestamp": "2025-10-06T10:51:49Z" +"MlsStatus": "Active" +"NetOperatingIncome": 137328.0 +"NumberOfUnitsTotal": "11" +"OnMarketDate": "2025-10-06" +"OpenParkingYN": true +"OperatingExpense": "33072.0" +"OperatingExpenseIncludes": "Insurance,Real Estate Tax,New Tax,Water/Sewer" +"OriginalListPrice": 1980000.0 +"OriginatingSystemKey": "19015360" +"ParcelNumber": "1-7-3-008-041-0000" +"ParkingFeatures": "Assigned, Open" +"ParkingTotal": "11.0" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 10 +"PostalCity": "Wahiawa" +"PropertyCondition": "Average Condition,Good Condition" +"Sewer": "Connected" +"SourceSystemKey": "1137653192" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Lakeview" +"StreetNumber": "142" +"StreetNumberNumeric": "142" +"StreetSuffix": "Circle" +"StructureType": "Apartment" +"SubdivisionName": "WILIKINA" +"TaxAnnualAmount": "4020.36" +"TaxAssessedValue": 1148700 +"Topography": "Level" +"TotalActualRent": 13800.0 +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,High Speed Internet Available,Phone Available,Water Available,Sewer Connected" +"View": "None" +"WaterSource": "Public" +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1137653192"\n } """ +"HumanModifiedYN": false +"TaxAssessedValueLand": "811100" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "337600" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1137653192')" +"provider_name": "HICMLS" +"RecordSignature": 1595604450 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-7-3-008-041-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486552" +"OriginatingSystemCoListOfficeKey": "3486552" +"OriginatingSystemListAgentMemberKey": "3474247" +"OriginatingSystemCoListAgentMemberKey": "14702055" +"Media": array:10 [ …10] +"ID": "60222" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4366 +post_id: "51342" +post_author: 1 +"ListingKey": "1117053612" +"ListingId": "202513998" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-13T00:35:24Z" +"RFModificationTimestamp": "2025-11-11T07:12:00Z" +"ListPrice": 369000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 313.0 +"BuildingAreaTotal": 347.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "2045 Kalakaua Avenue 402, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.2846839 +"Longitude": -157.8322843 +"YearBuilt": 1971 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Angela Hiroko Brenna" +"ListOfficeName": "Locations LLC" +"ListAgentMlsId": "29722" +"ListOfficeMlsId": "LOCA" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Luana Waikiki is conveniently located on the Kalakaua Ave in Resort Mixed Zoning which allow the short term rentals. Well\r\n maintained, clean unit, especially Lanai renovation was done includes removal and installation of lanai sliding door, lanai railings and\r\n the lanai divider. There is No popcorn ceiling. Four guests can stay with sofa bed. Very resort-like feel by Hawaiian furniture and\r\n decoration. There are fitness center, pool, cabana, BBQ and community laundry. The sprinkler & smoke detector are also in the unit. """ +"AssociationFeeIncludes": "Cable TV,Electricity,Hot Water,Internet,Sewer,Water" +"AttributionContact": "(808) 735-4200" +"BathroomsFull": 1 +"BuildingName": "Luana Waikiki" +"CLIP": 5848084337 +"CommunityFeatures": "Barbecue,Community Pool,Conference/Meeting Room,Fitness,Laundry Facilities,Restaurant,Condo Hotel Community" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2025-06-12T21:56:56.958949+00:00" +"DaysOnMarketReplicationDate": "2025-06-13" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 4 +"Flooring": "Ceramic Tile" +"Furnished": "Furnished" +"Inclusions": "AC Split,Cable TV,Drapes,Refrigerator" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 735-4200" +"ListAgentEmail": "angela.brenna@locationshawaii.com" +"ListAgentKey": "10777771" +"ListAgentKeyNumeric": "10777771" +"ListAgentOfficePhone": "(808) 735-4200" +"ListAgentPreferredPhone": "(808) 735-4200" +"ListAgentStateLicense": "RB-19999" +"ListOfficeEmail": "darryl.macha@locationshawaii.com" +"ListOfficeKey": "2586923" +"ListOfficeKeyNumeric": "2586923" +"ListOfficePhone": "(808) 735-4200" +"ListingContractDate": "2025-06-12" +"ListingKeyNumeric": 1117053612 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 963.0 +"MajorChangeTimestamp": "2025-06-12T11:52:19Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-06-12" +"OriginalListPrice": 369000.0 +"OriginatingSystemKey": "18804741" +"ParcelNumber": "1-2-6-006-002-0052" +"ParkingFeatures": "None" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 25 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent" +"SecurityFeatures": "Key Card Entry,Fire Sprinkler System" +"SourceSystemKey": "1117053612" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kalakaua" +"StreetNumber": "2045" +"StreetNumberNumeric": "2045" +"StreetSuffix": "Avenue" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "5832.0" +"TaxAssessedValue": 418200 +"UnitNumber": "402" +"View": "City" +"ViewYN": true +"ZoningDescription": "X6 - Resort Mixed Use Precinct" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "FractionalOwnershipYN": "0",\n "ManagementCompanyName": "Springboard Hospitality",\n "StreetViewParam": "1$21.283635$-157.832232$264.73$13.33$1.00$CAoSFkNJSE0wb2dLRUlDQWdJQ3NtTTdJRXc.",\n "CompensationSubjectTo": "",\n "CondoParkingUnit": "na",\n "SQFTLanaiOpen": "34",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "86900.00",\n "LockBoxModDT": "2025-06-12T09:44:29.920",\n "SellingAgentRemarks": "",\n "TaxAssessedValueImprovements": "331300.00",\n "ManagementCompanyPhone": "808-951-2100",\n "ParkingAdditional": "0",\n "OwnerOccupancyPercentage": "2",\n "TaxExcemptionOwnerOccupancy": "0",\n "CompensationMethod": "",\n "LandRecorded": "Land Court",\n "ListingKey": "1117053612",\n "ShowingTimeFlagYN": "0"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 963.0 +"TaxAssessedValueLand": "86900" +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "331300" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1117053612')" +"provider_name": "HICMLS" +"RecordSignature": -449897160 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-006-002-0052" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485305" +"OriginatingSystemListAgentMemberKey": "3478204" +"Media": array:25 [ …25] +"ID": "51342" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4370 +post_id: "56018" +post_author: 1 +"ListingKey": "1119484530" +"ListingId": "202516253" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-26T02:46:32Z" +"RFModificationTimestamp": "2025-11-11T06:18:40Z" +"ListPrice": 8300000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 162217.0 +"LivingArea": 610.0 +"BuildingAreaTotal": 610.0 +"City": "Honolulu" +"PostalCode": "96817" +"UnparsedAddress": "187 Dowsett Avenue, Honolulu, Hawaii 96817" +"Coordinates": array:2 [ …2] +"Latitude": 21.338255 +"Longitude": -157.8327613 +"YearBuilt": 1925 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Alden K Yamane" +"ListOfficeName": "List Sotheby's Int'l Realty" +"ListAgentMlsId": "05623" +"ListOfficeMlsId": "LIST" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "A rare and remarkable opportunity awaits at this expansive 3.7-acre estate lot (162,217 sq ft) in one of Honolulu’s most beloved and historic neighborhoods. Tucked away in lush, tropical surroundings, this property offers unmatched privacy, mature trees, and a serene stream that winds through the landscape, all just minutes from downtown Honolulu. The existing structure on the property is a shell, leaving a blank slate for a visionary builder, developer, or anyone seeking to design a one-of-a-kind retreat. Whether you choose to restore the current footprint, reimagine the home entirely, or develop a new estate, the potential here is extraordinary." +"ArchitecturalStyle": "Cottage, Detached" +"AttributionContact": "(808) 735-2411" +"BathroomsFull": 1 +"CLIP": 9183528684 +"CoListAgentDirectPhone": "(808) 348-1782" +"CoListAgentEmail": "aileen@chizers.com" +"CoListAgentFullName": "Aileen S Rodriguez-Chizer" +"CoListAgentKey": "10778767" +"CoListAgentKeyNumeric": "10778767" +"CoListAgentMlsId": "23573" +"CoListAgentPreferredPhone": "(808) 348-1782" +"CoListOfficeEmail": "info@listsir.com" +"CoListOfficeKey": "2586183" +"CoListOfficeKeyNumeric": "2586183" +"CoListOfficeMlsId": "LIST" +"CoListOfficeName": "List Sotheby's Int'l Realty" +"CoListOfficePhone": "(808) 735-2411" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2025-07-23T00:06:01.316164+00:00" +"DaysOnMarket": 269 +"DaysOnMarketReplication": 3 +"DaysOnMarketReplicationDate": "2025-07-26" +"DaysOnMarketReplicationIncreasingYN": true +"Flooring": "Other" +"Inclusions": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 223-7537" +"ListAgentEmail": "aldenyamane@outlook.com" +"ListAgentKey": "10778618" +"ListAgentKeyNumeric": "10778618" +"ListAgentOfficePhone": "(808) 735-2411" +"ListAgentPreferredPhone": "(808) 223-7537" +"ListAgentStateLicense": "RB-14697" +"ListOfficeEmail": "info@listsir.com" +"ListOfficeKey": "2586183" +"ListOfficeKeyNumeric": "2586183" +"ListOfficePhone": "(808) 735-2411" +"ListingContractDate": "2025-07-22" +"ListingKeyNumeric": 1119484530 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Interior Lot,Other,Wooded,Level" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2025-07-22T14:04:44Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-07-22" +"OriginalListPrice": 8300000.0 +"OriginatingSystemKey": "18872001" +"ParcelNumber": "1-2-2-046-021-0000" +"ParkingFeatures": "Driveway,Three or more Spaces" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 11 +"PoolFeatures": "None" +"PostalCity": "Honolulu" +"PropertyCondition": "Repairs Major,Tear Down / Value in Land" +"SourceSystemKey": "1119484530" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Dowsett" +"StreetNumber": "187" +"StreetNumberNumeric": "187" +"StreetSuffix": "Avenue" +"SubdivisionName": "DOWSETT" +"TaxAnnualAmount": "105408.0" +"TaxAssessedValue": 9895500 +"Topography": "Level, Rolling, Sloping" +"Utilities": "Other,Sewer Available,Water Available" +"View": "Garden, Sunset, Sunrise" +"ViewYN": true +"WaterSource": "Public" +"ZoningDescription": "03 - R10 - Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1119484530"\n } """ +"HumanModifiedYN": true +"TaxAssessedValueLand": "8708100" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "1187400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1119484530')" +"provider_name": "HICMLS" +"RecordSignature": -448785582 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-2-046-021-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "9066313" +"OriginatingSystemCoListOfficeKey": "9066313" +"OriginatingSystemListAgentMemberKey": "8842679" +"OriginatingSystemCoListAgentMemberKey": "8843172" +"Media": array:11 [ …11] +"ID": "56018" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4368 +post_id: "52424" +post_author: 1 +"ListingKey": "1113182333" +"ListingId": "202511989" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-18T01:30:41Z" +"RFModificationTimestamp": "2025-11-11T03:07:00Z" +"ListPrice": 888000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1105.0 +"BuildingAreaTotal": 1149.0 +"City": "Honolulu" +"PostalCode": "96814" +"UnparsedAddress": "1296 Kapiolani Boulevard 3805, Honolulu, Hawaii 96814" +"Coordinates": array:2 [ …2] +"Latitude": 21.2959834 +"Longitude": -157.8467393 +"YearBuilt": 2007 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Marc T Kumai" +"ListOfficeName": "Ivy K Realty, LLC" +"ListAgentMlsId": "24997" +"ListOfficeMlsId": "IVYK02" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Welcome to the Moana Pacific, a luxury condominium located right where Ala Moana meets Kakaako. This is the hottest area to be in when it comes to the night life, best restaurants Oahu has to offer, and the largest open air shopping mall in the world. The 05 stacks are the most popular because of their panoramic ocean view. Enjoy scenic views during the day and the Honolulu city lights at night. This unit has 2 bedroom suites separated by the living room which offers privacy and a spacious kitchen with an island large enough to dine on. The 05 floor plan includes a den that could be converted to a 3rd bedroom because of the built in closet. If you are a fan of the fastest growing sport "Pickelball" then you will appreciate the 2 recently redone courts. This has got to be one of the best valued units on the market today! Moana Paciifc now meets the insurance requirement being 100% covered and can obtain financing from all lenders. MP is no longer on the "do not lend" list!" +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Cable TV,Sewer,Water" +"AttributionContact": "(808) 591-5660" +"BathroomsFull": 2 +"BuildingName": "Moana Pacific" +"CLIP": 3424897635 +"CommunityFeatures": "Barbecue,Fitness,Pool,Recreation Area,Tennis Court(s),Trash Chute" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2025-05-13T20:11:16.336887+00:00" +"DaysOnMarket": 340 +"DaysOnMarketReplication": 36 +"DaysOnMarketReplicationDate": "2025-06-18" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 38 +"Flooring": "Vinyl" +"Furnished": "Partially" +"Inclusions": "AC Central,Cable TV,Dishwasher,Disposal,Dryer,Range/Oven,Refrigerator,Washer" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 591-5660" +"ListAgentEmail": "marckumai@ivykrealty.com" +"ListAgentKey": "10767646" +"ListAgentKeyNumeric": "10767646" +"ListAgentOfficePhone": "(808) 591-5660" +"ListAgentPreferredPhone": "(808) 591-5660" +"ListAgentStateLicense": "RB-18403" +"ListOfficeKey": "2588825" +"ListOfficeKeyNumeric": "2588825" +"ListOfficePhone": "(808) 591-5660" +"ListingContractDate": "2025-05-12" +"ListingKeyNumeric": 1113182333 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1409.15 +"MajorChangeTimestamp": "2025-06-17T15:30:12Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-05-12" +"OriginalListPrice": 945000.0 +"OriginatingSystemKey": "18745889" +"ParcelNumber": "1-2-3-010-028-0628" +"ParkingFeatures": "Covered,Two Spaces" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 25 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1113182333" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kapiolani" +"StreetNumber": "1296" +"StreetNumberNumeric": "1296" +"StreetSuffix": "Boulevard" +"SubdivisionName": "KAKAAKO" +"TaxAnnualAmount": "3297.0" +"TaxAssessedValue": 1102000 +"UnitNumber": "3805" +"View": "Ocean" +"ViewYN": true +"ZoningDescription": "Kak – Kakaako Community Development Project" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "FractionalOwnershipYN": "0",\n "ManagementCompanyName": "Hawaiian Properties",\n "StreetViewParam": "1$21.296009$-157.846692$27.41$13.33$1.00$CAoSLEFGMVFpcFA3M0NiWThPMXg4aEdzYmQ2OFY2a1FBUU1NY2t6WjVISlJBSVFv",\n "CompensationSubjectTo": "",\n "CondoParkingUnit": "C2100, C2101",\n "SQFTLanaiOpen": "44",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "68200.00",\n "LockBoxModDT": "2025-05-13T10:00:23.037",\n "SellingAgentRemarks": "",\n "TaxAssessedValueImprovements": "1033800.00",\n "ManagementCompanyPhone": "808-539-9777",\n "ParkingAdditional": "0",\n "OwnerOccupancyPercentage": "43",\n "CompensationMethod": "",\n "LandRecorded": "Land Court",\n "ListingKey": "1113182333",\n "TaxExcemptionOwnerOccupancy": "160000"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 1409.0 +"TaxAssessedValueLand": "68200" +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "1033800" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1113182333')" +"provider_name": "HICMLS" +"RecordSignature": 1376356722 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-010-028-0628" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3487207" +"OriginatingSystemListAgentMemberKey": "3475124" +"Media": array:25 [ …25] +"ID": "52424" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4365 +post_id: "60366" +post_author: 1 +"ListingKey": "1138902229" +"ListingId": "202522111" +"PropertyType": "Land" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-08T23:03:00Z" +"RFModificationTimestamp": "2025-11-11T03:32:25Z" +"ListPrice": 74900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 43560.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Mountain View" +"PostalCode": "96771" +"UnparsedAddress": "Lot 89 Huina Road, Mountain View, Hawaii 96771" +"Coordinates": array:2 [ …2] +"Latitude": 19.5803412 +"Longitude": -155.1100523 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Dylan Fujimoto" +"ListOfficeName": "Engel & Volkers Honolulu" +"ListAgentMlsId": "53806" +"ListOfficeMlsId": "PPRO02" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Build your future on this one-acre parcel in the Maunalani Lots subdivision of Mountain View. Offering privacy and natural surroundings, this property provides a blank canvas for your vision. Located along Huina Road with overhead electricity nearby (buyer to verify SSPP with HELCO). Great opportunity to create your own space on Hawai‘i Island. Buyer and agent to perform their own due diligence regarding utilities, access, and improvements." +"AttributionContact": "(808) 487-3855" +"CountyOrParish": "Hawaii" +"CreationDate": "2025-10-08T23:06:25.863866+00:00" +"CurrentUse": "Agricultural" +"DaysOnMarketReplicationDate": "2025-10-08" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "1031 Exchange,Seller Disclosure" +"ExteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 239-0000" +"ListAgentEmail": "Dylan.Fujimoto@evrealestate.com" +"ListAgentKey": "23284748" +"ListAgentKeyNumeric": "23284748" +"ListAgentOfficePhone": "(808) 487-3855" +"ListAgentPreferredPhone": "(808) 239-0000" +"ListAgentStateLicense": "RS-86710" +"ListOfficeEmail": "Kay.Mukaigawa@evrealestate.com" +"ListOfficeKey": "2585844" +"ListOfficeKeyNumeric": "2585844" +"ListOfficePhone": "(808) 487-3855" +"ListingContractDate": "2025-10-08" +"ListingKeyNumeric": 1138902229 +"ListingService": "Full Service" +"MLSAreaMajor": "Puna" +"MajorChangeTimestamp": "2025-10-08T13:02:20Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-10-08" +"OriginalListPrice": 74900.0 +"OriginatingSystemKey": "19024882" +"ParcelNumber": "3-1-7-025-022-0000" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 17 +"PostalCity": "Mountain View" +"Sewer": "None" +"SourceSystemKey": "1138902229" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Huina" +"StreetNumber": "Lot 89" +"StreetSuffix": "Road" +"SubdivisionName": "MAUNALANI TRACT" +"TaxAnnualAmount": "399.24" +"TaxAssessedValue": 42700 +"Topography": "Sloping" +"Utilities": "None,Sewer Not Available" +"View": "None" +"ZoningDescription": "50 - Agricultural" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1138902229"\n } """ +"Restrictions": "No Restrictions" +"HumanModifiedYN": true +"TaxAssessedValueLand": "42700" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1138902229')" +"provider_name": "HICMLS" +"RecordSignature": -1570786935 +"UniversalParcelId": "urn:reso:upi:2.0:US:15001:3-1-7-025-022-0000" +"CountrySubdivision": "15001" +"OriginatingSystemListOfficeKey": "3487726" +"OriginatingSystemListAgentMemberKey": "17815676" +"Media": array:17 [ …17] +"ID": "60366" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4360 +post_id: "50433" +post_author: 1 +"ListingKey": "1113048639" +"ListingId": "202511793" +"PropertyType": "Land" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-24T21:33:30Z" +"RFModificationTimestamp": "2025-11-11T04:01:29Z" +"ListPrice": 125000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 43560.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Keaau" +"PostalCode": "96749" +"UnparsedAddress": "15-1653 8th Avenue, Keaau, Hawaii 96749" +"Coordinates": array:2 [ …2] +"Latitude": 19.6225209 +"Longitude": -155.039043 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ciro E Ochoa" +"ListOfficeName": "eXp Realty" +"ListAgentMlsId": "54550" +"ListOfficeMlsId": "EXPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Prime lot on 8th Ave. 1-acre lot in the highly desirable Hawaiian Paradise Park Subdivision. Lightly wooded, gentle slope, in the sunbelt section located between Paradise Dr. and Kaloli , 18 parcels in from Paradise Dr., this property is just a short drive to shopping, dining, and recreational activities.\r\n \r\n Discover the perfect blend of tranquility and opportunity. Just minutes from the ocean and 30 minutes from Hilo. Whether you're looking to build your dream home, a modern tiny house rental, or invest in one of Puna’s most desirable growing communities, this flat,lot offers endless potential.\r\n Zoned for up to 4 dwellings under updated county rules\r\n Gravel driveway and paved road access \r\n Power available at the street\r\n Lush natural landscaping for privacy and tropical beauty\r\n Surrounded by new homes and quality developments\r\n No SSPP fees (buyer to confirm with HELCO)\r\n \r\n Enjoy nearby amenities like shopping, schools, parks, and beaches while living in a peaceful residential setting. Hawaiian Paradise Park is known for its sense of community, large lots, and growing property values.\r\n Priced to sell fast! """ +"AttributionContact": "(808) 725-2794" +"CountyOrParish": "Hawaii" +"CreationDate": "2025-05-12T19:57:35.422026+00:00" +"CurrentUse": "Agricultural" +"DaysOnMarket": 340 +"DaysOnMarketReplication": 73 +"DaysOnMarketReplicationDate": "2025-07-24" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent" +"ExteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 320-1722" +"ListAgentEmail": "ciroochoa69@gmail.com" +"ListAgentKey": "26122897" +"ListAgentKeyNumeric": "26122897" +"ListAgentOfficePhone": "(808) 725-2794" +"ListAgentPreferredPhone": "(808) 320-1722" +"ListAgentStateLicense": "RS-87819" +"ListOfficeEmail": "hi.broker@exprealty.net" +"ListOfficeKey": "2589160" +"ListOfficeKeyNumeric": "2589160" +"ListOfficePhone": "(808) 725-2794" +"ListingContractDate": "2025-05-12" +"ListingKeyNumeric": 1113048639 +"ListingService": "Entry Only" +"MLSAreaMajor": "Puna" +"MajorChangeTimestamp": "2025-05-27T18:17:06Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-05-12" +"OriginalListPrice": 135000.0 +"OriginatingSystemKey": "18740054" +"ParcelNumber": "3-1-5-051-153-0000" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 2 +"PostalCity": "Keaau" +"Sewer": "None" +"SourceSystemKey": "1113048639" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "8th" +"StreetNumber": "15-1653" +"StreetSuffix": "Avenue" +"SubdivisionName": "HWN PARADISE PK" +"TaxAnnualAmount": "432.0" +"TaxAssessedValue": 79000 +"Topography": "Sloping" +"Utilities": "Electricity Available,Sewer Not Available" +"View": "None" +"ZoningDescription": "51 - AG-1 Restricted Agricultur" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "CompensationSubjectTo": "",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "79000.00",\n "LockBoxModDT": "2025-05-09T13:11:25.330",\n "CompensationMethod": "",\n "SellingAgentRemarks": "",\n "ListingKey": "1113048639",\n "SetBacks": "C\u0026C",\n "Easements": "None",\n "LandRecorded": "Dual Systems",\n "TaxAssessedValueImprovements": "0.00",\n "ShowingTimeFlagYN": "1"\n } """ +"Restrictions": "Other Restrictions" +"HumanModifiedYN": true +"TaxAssessedValueLand": "79000" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1113048639')" +"provider_name": "HICMLS" +"RecordSignature": -1635723457 +"UniversalParcelId": "urn:reso:upi:2.0:US:15001:3-1-5-051-153-0000" +"CountrySubdivision": "15001" +"OriginatingSystemListOfficeKey": "10013908" +"OriginatingSystemListAgentMemberKey": "18630328" +"Media": array:2 [ …2] +"ID": "50433" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4371 +post_id: "60060" +post_author: 1 +"ListingKey": "1130549013" +"ListingId": "202519180" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-03T10:29:30Z" +"RFModificationTimestamp": "2025-11-11T05:28:24Z" +"ListPrice": 205000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 217800.0 +"LivingArea": 666.0 +"BuildingAreaTotal": 666.0 +"City": "Waianae" +"PostalCode": "96792" +"UnparsedAddress": "87-134 Helelua Street A202, Waianae, Hawaii 96792" +"Coordinates": array:2 [ …2] +"Latitude": 21.446678 +"Longitude": -158.185272 +"YearBuilt": 1975 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Katherine Kelii" +"ListOfficeName": "West Beach Realty, Inc." +"ListAgentMlsId": "37707" +"ListOfficeMlsId": "WEBR" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Kake kai 2 bedroom, 1 bath unit with 1 parking stall. Great opportunity for investors or first-time homebuyers! Conveniently located just minutes from beaches, shopping, restaurants, and schools. Recently painted with newer flooring." +"ArchitecturalStyle": "Low Rise" +"AssociationFee": "26.0" +"AssociationFeeIncludes": "Gas,Hot Water,Maintenance Grounds,Maintenance Structure,Sewer,Water" +"AttributionContact": "(808) 696-4774" +"BathroomsFull": 1 +"BuildingName": "Kahe Kai" +"CLIP": 2714329385 +"CommunityFeatures": "Other" +"ConstructionMaterials": "Steel Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-10-03T10:02:58.275490+00:00" +"DaysOnMarket": 227 +"DaysOnMarketReplication": 31 +"DaysOnMarketReplicationDate": "2025-10-03" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 2 +"Flooring": "Vinyl" +"FrontageType": "Other" +"Furnished": "Partially" +"Inclusions": "Range Hood,Range/Oven,Refrigerator" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 723-9653" +"ListAgentEmail": "katkelii77@gmail.com" +"ListAgentKey": "10763322" +"ListAgentKeyNumeric": "10763322" +"ListAgentOfficePhone": "(808) 696-4774" +"ListAgentPreferredPhone": "(808) 723-9653" +"ListAgentStateLicense": "RS-70712" +"ListOfficeKey": "2586877" +"ListOfficeKeyNumeric": "2586877" +"ListOfficePhone": "(808) 696-4774" +"ListingContractDate": "2025-09-02" +"ListingKeyNumeric": 1130549013 +"ListingService": "Full Service" +"MLSAreaMajor": "Leeward" +"MaintenanceExpense": 835.0 +"MajorChangeTimestamp": "2025-09-02T20:27:21Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-09-02" +"OriginalListPrice": 205000.0 +"OriginatingSystemKey": "18954066" +"ParcelNumber": "1-8-7-008-010-0008" +"ParkingFeatures": "Assigned" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 24 +"PostalCity": "Waianae" +"PropertyCondition": "Average Condition,Updated/Remodeled" +"SourceSystemKey": "1130549013" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Helelua" +"StreetNumber": "87-134" +"StreetSuffix": "Street" +"SubdivisionName": "MAILI" +"TaxAnnualAmount": "624.0" +"TaxAssessedValue": 174600 +"UnitNumber": "A202" +"View": "Mountain(s)" +"ViewYN": true +"YearBuiltEffective": 2025 +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1130549013"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 861.0 +"TaxAssessedValueLand": "21700" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "152900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1130549013')" +"provider_name": "HICMLS" +"RecordSignature": 792433833 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-8-7-008-010-0008" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485259" +"OriginatingSystemListAgentMemberKey": "3481391" +"Media": array:24 [ …24] +"ID": "60060" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4372 +post_id: "50493" +post_author: 1 +"ListingKey": "1044689330" +"ListingId": "202320196" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-25T19:59:13Z" +"RFModificationTimestamp": "2025-11-11T06:09:48Z" +"ListPrice": 7950000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 2557.0 +"BuildingAreaTotal": 3390.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "2139 Kuhio Avenue 2806, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.282264240353 +"Longitude": -157.82950802427 +"YearBuilt": 2018 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Tomoko M Stanyon" +"ListOfficeName": "Tomoko Realty" +"ListAgentMlsId": "05463" +"ListOfficeMlsId": "TOMO" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "High Floor split-level condominium at The Ritz-Carlton Residences, Waikiki Beach on the 28th and 29th floors. This unit features 2,557 square feet on interior, large lanai and is one of the few non-penthouse units with a private pool and lounge deck. Exceptional west-facing, sunset and Friday-night fireworks views from all three bedrooms! All bedrooms feature an en-Suite bathroom. 28th floor features Pool deck, Kitchen with Míele appliances, wet-bar, Bedroom #1 with en-suite Bathroom and living area. A staircase joins the two floors in the middle. The 29th floor has own entrance to unit and half bath as you enter the apartment, living area and Owner's and Guest bedrooms & bath split on each side for privacy. Views from every room in this spectacular condominium! Ritz-Carlton Residence Owners have exclusive access to unprecedented amenities of Ritz-Carlton which include: full service spa, fitness program and dining in the world famous La Vie and Sushi Sho restaurants! Feels like a single-family home with privacy of and hospitality of world-class Ritz-Carlton guest services, make this unique property a one of a kind!" +"ArchitecturalStyle": "High Rise,Multi-Level" +"AssociationAmenities": "Concierge" +"AssociationFeeIncludes": "Common Areas,Cable TV,Internet,Sewer,Water" +"AttributionContact": "(808) 395-2395" +"BathroomsFull": 4 +"BuildingName": "The Ritz-Carlton Residences Twr 2 - 383 Kalaimoku" +"CLIP": 3739024187 +"CommunityFeatures": "Concierge,Deck/Porch,Fitness,Patio,Pool,Restaurant,Trash Chute" +"ConstructionMaterials": "Concrete" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2025-04-08T01:46:43.922192+00:00" +"DaysOnMarket": 959 +"DaysOnMarketReplication": 724 +"DaysOnMarketReplicationDate": "2025-08-25" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None,Seller Disclosure" +"ElementarySchool": "Jefferson" +"EntryLevel": 28 +"Flooring": "Hardwood, Marble" +"Furnished": "Unfurnished" +"HighSchool": "Kaimuki" +"Inclusions": "AC Central,Ceiling Fan,Chandelier,Dryer,Microwave,Range/Oven,Refrigerator,Smoke Detector,Washer" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 271-4885" +"ListAgentEmail": "stanyontomoko@gmail.com" +"ListAgentKey": "10768430" +"ListAgentKeyNumeric": "10768430" +"ListAgentOfficePhone": "(808) 395-2395" +"ListAgentPreferredPhone": "(808) 271-4885" +"ListAgentStateLicense": "RB-14652" +"ListOfficeEmail": "Stanyon T0001@hawaii.rr.com" +"ListOfficeKey": "2586687" +"ListOfficeKeyNumeric": "2586687" +"ListOfficePhone": "(808) 395-2395" +"ListingContractDate": "2023-09-01" +"ListingKeyNumeric": 1044689330 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 6600.0 +"MajorChangeTimestamp": "2023-09-01T10:42:16Z" +"MiddleOrJuniorSchool": "Washington" +"MlsStatus": "Active" +"OnMarketDate": "2023-09-01" +"OriginalListPrice": 7950000.0 +"OriginatingSystemKey": "17527495" +"ParcelNumber": "1-2-6-018-043-0187" +"ParkingFeatures": "None, Valet" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 21 +"PoolFeatures": "Heated" +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent" +"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry,Security Guard" +"SourceSystemKey": "1044689330" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Kuhio" +"StreetNumber": "2139" +"StreetNumberNumeric": "2139" +"StreetSuffix": "Avenue" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "52347.0" +"TaxAssessedValue": 4850400 +"UnitNumber": "2806" +"View": "Coastline, City, Mountain(s), Ocean, Sunset" +"ViewYN": true +"ZoningDescription": "X6 - Resort Mixed Use Precinct" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "505800.00",\n "LockBoxModDT": "2023-08-29T16:03:05.917",\n "LandRecorded": "Regular System",\n "ListingKey": "1044689330",\n "TaxAssessedValueImprovements": "5391800.00",\n "ManagementCompanyPhone": "8087297982",\n "FloorNumber": "28",\n "FractionalOwnershipYN": "0",\n "ManagementCompanyName": "AOUO 383 Kalaimoku",\n "StreetViewParam": "1$21.281825$-157.829571$101.28$13.33$1.00$CAoSLEFGMVFpcE1PWWU1UHM3NFhGZHpmMmFxUkpDWXlFM21pdzBZVEVReWQ4dHRJ",\n "AssociationFee2Includes": "Other Common Expenses",\n "CondoParkingUnit": "valet",\n "ParkingAdditional": "0",\n "OwnerOccupancyPercentage": "43",\n "TaxExcemptionOwnerOccupancy": "0",\n "SQFTLanaiOpen": "833",\n "ShowingTimeFlagYN": "1",\n "CompensationSubjectTo": "",\n "SellingAgentRemarks": "",\n "CompensationMethod": ""\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 6600.0 +"TaxAssessedValueLand": "505800" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "4344600" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1044689330')" +"provider_name": "HICMLS" +"RecordSignature": -32537161 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-018-043-0187" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485069" +"OriginatingSystemListAgentMemberKey": "8842665" +"Media": array:21 [ …21] +"ID": "50493" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4373 +post_id: "56899" +post_author: 1 +"ListingKey": "1119147372" +"ListingId": "202516038" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-14T22:58:21Z" +"RFModificationTimestamp": "2025-11-11T10:55:41Z" +"ListPrice": 375000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 20343.0 +"LivingArea": 576.0 +"BuildingAreaTotal": 674.0 +"City": "Honolulu" +"PostalCode": "96819" +"UnparsedAddress": "828 Puuhale Road 209, Honolulu, Hawaii 96819" +"Coordinates": array:2 [ …2] +"Latitude": 21.3314226 +"Longitude": -157.8794794 +"YearBuilt": 1961 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rose C Galanto" +"ListOfficeName": "Granventure Realty" +"ListAgentMlsId": "01035" +"ListOfficeMlsId": "JCPR" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ WELL KEPT UNIT * 2 BEDROOM, 1 BATH WITH LANAI * RENOVATED 2020 * GRANITE COUNTER TOP * KITCHEN CABINTES * \r\n CERAMIC TILES * ASSIGNED PARKING #28 * GAS RANGE * REFRIGERATOR * WASHER * WATER HEATER * CEILING FANS * WINDOW A/C * RECENTLY PAINTED * \r\n CLOSE TO BUSINESS CENTER: AMERICAN SAVINGS, FIRST HAWAIIAN BANKS, CENTRAL PACOFIC BANK * RESTAURANTS: ZIPPYZ,\r\n GOLDEN COIN, HONG NIEN, SUBWAY, BBQ & LITTLE CAESAR PIZZA * SCHOOLS: KALIHI KAI ELEM, KALAKAUA MIDDLE, FARRINGTON HIGH & MORE * DOCTORS CLINICS. CLOSE TO BUSLINE & UPCOMING RAIL LINE. SUBJECT TO REPLACEMENT * """ +"AssociationFeeIncludes": "None, Sewer, Water" +"AttributionContact": "(808) 845-5918" +"BathroomsFull": 1 +"BuildingName": "K KAYA APTS" +"CLIP": 8639316262 +"CommunityFeatures": "Deck/Porch, Patio" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2025-08-09T07:18:45.039646+00:00" +"DaysOnMarket": 253 +"DaysOnMarketReplication": 7 +"DaysOnMarketReplicationDate": "2025-08-14" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"EntryLevel": 2 +"Flooring": "Ceramic Tile" +"Furnished": "Partially" +"Inclusions": "AC Window Unit,Ceiling Fan,Range/Oven,Refrigerator,Water Heater" +"InteriorFeatures": "Storage" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 688-4458" +"ListAgentEmail": "hills@hawaii.rr.com" +"ListAgentKey": "10777090" +"ListAgentKeyNumeric": "10777090" +"ListAgentOfficePhone": "(808) 845-5918" +"ListAgentPreferredPhone": "(808) 688-4458" +"ListAgentStateLicense": "RS-25443" +"ListOfficeEmail": "granventure@hawaii.rr.com" +"ListOfficeKey": "2585958" +"ListOfficeKeyNumeric": "2585958" +"ListOfficePhone": "(808) 845-5918" +"ListingContractDate": "2025-08-07" +"ListingKeyNumeric": 1119147372 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 420.0 +"MajorChangeTimestamp": "2025-08-08T21:17:08Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-08-07" +"OriginalListPrice": 375000.0 +"OriginatingSystemKey": "18864647" +"ParcelNumber": "1-1-2-001-053-0019" +"ParkingFeatures": "Assigned" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 22 +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition,Updated/Remodeled" +"SourceSystemKey": "1119147372" +"StateOrProvince": "HI" +"StreetName": "Puuhale" +"StreetNumber": "828" +"StreetNumberNumeric": "828" +"StreetSuffix": "Road" +"SubdivisionName": "KAPALAMA" +"TaxAnnualAmount": "732.0" +"TaxAssessedValue": 345800 +"UnitNumber": "209" +"View": "None" +"YearBuiltEffective": 2020 +"ZoningDescription": "46 - IMX-1 Industrial-Commercia" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1119147372"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 420.0 +"TaxAssessedValueLand": "126100" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "219700" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1119147372')" +"provider_name": "HICMLS" +"RecordSignature": 1364016597 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-2-001-053-0019" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3487840" +"OriginatingSystemListAgentMemberKey": "3471957" +"Media": array:22 [ …22] +"ID": "56899" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4374 +post_id: "51898" +post_author: 1 +"ListingKey": "1114779957" +"ListingId": "202513208" +"PropertyType": "Land" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-21T18:35:09Z" +"RFModificationTimestamp": "2025-11-11T03:52:19Z" +"ListPrice": 2450000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 8190.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Honolulu" +"PostalCode": "96821" +"UnparsedAddress": "240 Paiko Drive, Honolulu, Hawaii 96821" +"Coordinates": array:2 [ …2] +"Latitude": 21.2811581 +"Longitude": -157.7261056 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kainoa Lee" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "25217" +"ListOfficeMlsId": "CBPP" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "MASSIVE $200K PRICE REDUCTION. The only BEACH FRONT VACANT LAND, in EAST HONOLULU, OAHU with more than 65 linear feet of sandy beach fronting famous surfing spots Toes and Secrets currently available UNDER $15,000,000. Paiko Beach consists of only 22 residences that are beach front. Priced $772,000 BELOW TAX ASSESSED VALUE! Endless water activities are made possible by the barrier reef creating a calm and protected sandy beach front. Seller has obtained APPROVED SHORELINE CERTIFICATION (see listing supplements) 21 feet forward (towards the ocean) of the property line. With all setbacks considered, this property still has a buildable footprint area of more than 4,290 square feet for a single level home! More if you build a second story. Seller has attached and completed the K2 Standard Survey, Shoreline Certification Survey and Topo Map. No Easements or Encroachments. Also listed in MLS under Residential Listing MLS #202513207." +"AttributionContact": "(808) 596-0456" +"CLIP": 3155126390 +"CountyOrParish": "Oahu" +"CreationDate": "2025-09-13T03:23:03.298919+00:00" +"CurrentUse": "Residential,Single Family" +"DaysOnMarket": 321 +"DaysOnMarketReplication": 143 +"DaysOnMarketReplicationDate": "2025-10-21" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "1031 Exchange,Seller Disclosure" +"ExteriorFeatures": "None" +"FrontageType": "Oceanfront, Waterfront" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 596-0456" +"ListAgentEmail": "kainoa@kainoalee.com" +"ListAgentKey": "10772471" +"ListAgentKeyNumeric": "10772471" +"ListAgentOfficePhone": "(808) 596-0456" +"ListAgentPreferredPhone": "(808) 596-0456" +"ListAgentStateLicense": "RS-59781" +"ListOfficeEmail": "mike.james@cbrealty.com" +"ListOfficeKey": "2586830" +"ListOfficeKeyNumeric": "2586830" +"ListOfficePhone": "(808) 596-0456" +"ListingContractDate": "2025-05-31" +"ListingKeyNumeric": 1114779957 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Interior Lot,Level" +"MLSAreaMajor": "Diamond Hd" +"MajorChangeTimestamp": "2025-09-12T17:17:23Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-05-31" +"OriginalListPrice": 2650000.0 +"OriginatingSystemKey": "18782303" +"ParcelNumber": "1-3-8-001-007-0000" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 14 +"PossibleUse": "Single Family" +"PostalCity": "Honolulu" +"RoadFrontageType": "County Road" +"Sewer": "None" +"SourceSystemKey": "1114779957" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Paiko" +"StreetNumber": "240" +"StreetNumberNumeric": "240" +"StreetSuffix": "Drive" +"SubdivisionName": "PAIKO LAGOON" +"TaxAnnualAmount": "27442.56" +"TaxAssessedValue": 3222500 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,Phone Available,Sewer Available,Water Available,Sewer Not Available" +"View": "Coastline, Garden, Mountain(s), Ocean, Other, Sunset, Sunrise" +"ViewYN": true +"WaterSource": "Public" +"WaterfrontYN": true +"ZoningDescription": "04 - R-7.5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "SetBacks": "C\u0026C,Of Record,Special",\n "CompensationSubjectTo": "",\n "UtilitiesMeters": "None",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "3222500.00",\n "LockBoxModDT": "2025-06-01T18:00:34.613",\n "CompensationMethod": "",\n "SellingAgentRemarks": "",\n "Easements": "None",\n "LandRecorded": "Land Court",\n "ListingKey": "1114779957",\n "TaxAssessedValueImprovements": "0.00",\n "ShowingTimeFlagYN": "0"\n } """ +"Restrictions": "Building Restrictions" +"HumanModifiedYN": true +"TaxAssessedValueLand": "3222500" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1114779957')" +"provider_name": "HICMLS" +"RecordSignature": -1669975310 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-3-8-001-007-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485212" +"OriginatingSystemListAgentMemberKey": "3475247" +"Media": array:14 [ …14] +"ID": "51898" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4375 +post_id: "49223" +post_author: 1 +"ListingKey": "1112110285" +"ListingId": "202510689" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-15T02:44:07Z" +"RFModificationTimestamp": "2025-11-11T07:12:24Z" +"ListPrice": 2497000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 40166.0 +"LivingArea": 1410.0 +"BuildingAreaTotal": 1764.0 +"City": "Honolulu" +"PostalCode": "96814" +"UnparsedAddress": "1538 Kapiolani Boulevard 1502, Honolulu, Hawaii 96814" +"Coordinates": array:2 [ …2] +"Latitude": 21.2925614 +"Longitude": -157.8407881 +"YearBuilt": 2028 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Laurie Kay Oh" +"ListOfficeName": "Associated Real Estate Advisor" +"ListAgentMlsId": "41080" +"ListOfficeMlsId": "AREA" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Introducing Muse Honolulu, Ala Moana’s newest luxury development featuring a dynamic collection of 315 thoughtfully designed residences, offering three distinct home types; two-story Townhomes, Urban Lofts, and Tower Residences. Tower Residence 1502 offers a spacious layout, approximately 9' ceiling height, a generous 352 SF outdoor space, and finely curated kitchen with top-of-the-line appliances, European cabinetry & countertops. Enjoy true refined urban living with three levels of resort like amenities with the convenience of abundant shopping, dining, & more! \r\n *Photos on this listing are renderings and/or enhanced.*\r\n Disclaimer: Property tax information is not yet available as Muse Honolulu \r\n is a new development. Future tax assessments will be determined by the \r\n City & County of Honolulu.\r\n CPR number has not yet been determined. The CPR number is not a valid CPR number and was used strictly for MLS input purposes """ +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Sewer,Water" +"AttributionContact": "(808) 445-9199" +"BathroomsFull": 3 +"BuildingName": "Muse Honolulu" +"CoListAgentDirectPhone": "(808) 386-7489" +"CoListAgentEmail": "rosie@associatedhawaii.com" +"CoListAgentFullName": "Rosalei T Rankin" +"CoListAgentKey": "10778979" +"CoListAgentKeyNumeric": "10778979" +"CoListAgentMlsId": "44649" +"CoListAgentPreferredPhone": "(808) 386-7489" +"CoListOfficeEmail": "kelly@associatedhawaii.com" +"CoListOfficeKey": "3167562" +"CoListOfficeKeyNumeric": "3167562" +"CoListOfficeMlsId": "AREA" +"CoListOfficeName": "Associated Real Estate Advisor" +"CoListOfficePhone": "(808) 445-9199" +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Clubhouse,Community Pool,Dog Park,Fitness,Other,Playground,Pool,Putting Green,Recreation Area,Sauna,Storage Facilities,Trash Chute" +"ConstructionMaterials": "Other,Concrete,Steel Frame" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2025-04-24T22:55:17.061920+00:00" +"DaysOnMarket": 358 +"DaysOnMarketReplication": 173 +"DaysOnMarketReplicationDate": "2025-10-14" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "See Remarks" +"EntryLevel": 15 +"Flooring": "Carpet,Ceramic Tile,Other" +"Furnished": "Unfurnished" +"Inclusions": "AC Central,Auto Garage Door Opener,Dishwasher,Disposal,Dryer,Microwave,Other,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater,Wine Refrigerator" +"InteriorFeatures": "Storage" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 722-6615" +"ListAgentEmail": "Laurie@associatedhawaii.com" +"ListAgentKey": "10763389" +"ListAgentKeyNumeric": "10763389" +"ListAgentOfficePhone": "(808) 445-9199" +"ListAgentPreferredPhone": "(808) 722-6615" +"ListAgentStateLicense": "RS-72521" +"ListOfficeEmail": "kelly@associatedhawaii.com" +"ListOfficeKey": "3167562" +"ListOfficeKeyNumeric": "3167562" +"ListOfficePhone": "(808) 445-9199" +"ListingContractDate": "2025-04-24" +"ListingKeyNumeric": 1112110285 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1862.0 +"MajorChangeTimestamp": "2025-04-24T12:52:09Z" +"MlsStatus": "Active" +"NewConstructionYN": true +"OnMarketDate": "2025-04-24" +"OriginalListPrice": 2497000.0 +"OriginatingSystemKey": "18708435" +"ParcelNumber": "1-2-3-021-006-0000" +"ParkingFeatures": "Assigned,Covered,Guest,Two Spaces,Secured" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 9 +"PoolFeatures": "Heated" +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Key Card Entry,Fire Sprinkler System" +"SourceSystemKey": "1112110285" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kapiolani" +"StreetNumber": "1538" +"StreetNumberNumeric": "1538" +"StreetSuffix": "Boulevard" +"SubdivisionName": "HOLIDAY MART" +"UnitNumber": "1502" +"View": "City, Ocean" +"ViewYN": true +"ZoningDescription": "33 - BMX-3 Community Business M" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "FractionalOwnershipYN": "0",\n "ManagementCompanyName": "Hawaiian",\n "StreetViewParam": "1$21.292859$-157.840877$350.28$13.33$1.00$CAoSLEFGMVFpcE1RUXA3aS1qNXVNWlRJbG9YR3NFTWNQZng0V0pyOXpDNUVtbXBi",\n "CompensationSubjectTo": "",\n "CondoParkingUnit": "406, 407",\n "SQFTLanaiOpen": "354",\n "TaxPaidBySellerYN": "",\n "ElevatorsNumberOf": "4",\n "TaxAssessedValueLand": "0.00",\n "LockBoxModDT": "2025-04-23T16:54:03.310",\n "SellingAgentRemarks": "",\n "PublicReportNumber": "9212",\n "TaxAssessedValueImprovements": "0.00",\n "ManagementCompanyPhone": "808-539-9777",\n "ModelSiteContactPhone": "808-900-8597",\n "OwnerOccupancyPercentage": "0",\n "ModelSiteOpenHours": "M-F /10am-6pm",\n "CompensationMethod": "",\n "LandRecorded": "Regular System",\n "ListingKey": "1112110285",\n "ParkingAdditional": "0",\n "TaxExcemptionOwnerOccupancy": "0",\n "ShowingTimeFlagYN": "0"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 1862.0 +"TaxAssessedValueLand": "0" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1112110285')" +"provider_name": "HICMLS" +"RecordSignature": 926664612 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-021-006-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15110879" +"OriginatingSystemCoListOfficeKey": "15110879" +"OriginatingSystemListAgentMemberKey": "3482522" +"OriginatingSystemCoListAgentMemberKey": "9202594" +"Media": array:9 [ …9] +"ID": "49223" } 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4376 +post_id: "57060" +post_author: 1 +"ListingKey": "1126654111" +"ListingId": "202517888" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-09-06T03:01:55Z" +"RFModificationTimestamp": "2025-11-11T07:46:00Z" +"ListPrice": 699000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 5893.0 +"LivingArea": 1105.0 +"BuildingAreaTotal": 1162.0 +"City": "Ewa Beach" +"PostalCode": "96706" +"UnparsedAddress": "91-1033 Kaipalaoa Street 1402, Ewa Beach, Hawaii 96706" +"Coordinates": array:2 [ …2] +"Latitude": 21.315603 +"Longitude": -158.008804 +"YearBuilt": 2005 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Belinda M Miranda" +"ListOfficeName": "Nakamoto Realty LLC" +"ListAgentMlsId": "38101" +"ListOfficeMlsId": "NREA" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Move in ready to this well maintained 3 bedroom townhome in Spinnaker! You will enter the front of the courtyard area of this home facing a wide open green space. A spacious garage offers convenience to enter the kitchen area after you've parked the car. There is a half bath downstairs with 2 baths upstairs. Primary bedroom has its own private bathroom. Save on Electricity with the PV Panels. Walk within minutes to the pool and enjoy an afternoon with your family. Evening strolls on the sidewalk can be enjoyed this community." +"AssociationFeeIncludes": "Common Areas,Sewer,Water" +"AttributionContact": "(808) 688-9878" +"BathroomsFull": 2 +"BuildingName": "Spinnaker" +"CLIP": 4699807850 +"CommunityFeatures": "Barbecue, Clubhouse, Pool" +"ConstructionMaterials": "Double Wall" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2025-08-12T14:19:43.761870+00:00" +"DaysOnMarket": 252 +"DaysOnMarketReplication": 28 +"DaysOnMarketReplicationDate": "2025-09-06" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Keoneula" +"EntryLevel": 1 +"Flooring": "Laminate" +"FoundationDetails": "Slab" +"Furnished": "Unfurnished" +"GarageYN": true +"HighSchool": "Campbell" +"Inclusions": "AC Central,Ceiling Fan,Dishwasher,Microwave,Photovoltaic – Leased,Range/Oven" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 561-4342" +"ListAgentEmail": "alohabelinda@gmail.com" +"ListAgentKey": "10778069" +"ListAgentKeyNumeric": "10778069" +"ListAgentOfficePhone": "(808) 688-9878" +"ListAgentPreferredPhone": "(808) 561-4342" +"ListAgentStateLicense": "RS-70920" +"ListOfficeEmail": "nakamotorealty1@gmail.com" +"ListOfficeKey": "2588070" +"ListOfficeKeyNumeric": "2588070" +"ListOfficePhone": "(808) 688-9878" +"ListingContractDate": "2025-08-08" +"ListingKeyNumeric": 1126654111 +"ListingService": "Full Service" +"MLSAreaMajor": "Ewaplain" +"MaintenanceExpense": 631.0 +"MajorChangeTimestamp": "2025-08-12T04:16:00Z" +"MiddleOrJuniorSchool": "Ewa Makai" +"MlsStatus": "Active" +"OnMarketDate": "2025-08-08" +"OriginalListPrice": 699000.0 +"OriginatingSystemKey": "18920041" +"ParcelNumber": "1-9-1-012-040-0059" +"ParkingFeatures": "Garage" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 20 +"PostalCity": "Ewa Beach" +"PropertyCondition": "Average Condition" +"SourceSystemKey": "1126654111" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Kaipalaoa" +"StreetNumber": "91-1033" +"StreetSuffix": "Street" +"StructureType": "Townhouse" +"SubdivisionName": "OCEAN POINTE" +"TaxAnnualAmount": "1817.88" +"TaxAssessedValue": 688000 +"UnitNumber": "1402" +"View": "Other" +"ViewYN": true +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1126654111"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 631.0 +"TaxAssessedValueLand": "347400" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "340600" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1126654111')" +"provider_name": "HICMLS" +"RecordSignature": 978564984 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-1-012-040-0059" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486452" +"OriginatingSystemListAgentMemberKey": "3481525" +"Media": array:20 [ …20] +"ID": "57060" } 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4377 +post_id: "60006" +post_author: 1 +"ListingKey": "1135674628" +"ListingId": "202520630" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-18T02:25:13Z" +"RFModificationTimestamp": "2025-11-11T04:11:42Z" +"ListPrice": 43000000.0 +"BathroomsTotalInteger": 7.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 80150.0 +"LivingArea": 6213.0 +"BuildingAreaTotal": 7157.0 +"City": "Honolulu" +"PostalCode": "96816" +"UnparsedAddress": "3735- Diamond Head Road, Honolulu, Hawaii 96816" +"Coordinates": array:2 [ …2] +"Latitude": 21.2579311 +"Longitude": -157.8005757 +"YearBuilt": 1967 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Noel Pietsch Shaw" +"ListOfficeName": "Hawaii Life" +"ListAgentMlsId": "45076" +"ListOfficeMlsId": "HLRE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Located on Diamond Head Road, Ho‘oluana Estate is one of Honolulu’s last remaining legacy estate-sized properties. Zoned R-7.5 and encompassing nearly 80,000 square feet, the estate features an expansive residences and several open lots, offering sweeping ocean views, private/deeded beachfront access, and exceptional flexibility for development or preservation. Perfectly positioned between Kahala and Waikiki, this property combines luxury, tranquility, and proximity to world-class surfing, shopping, dining, golf, hiking, and more. Neighboring property located at 3735 Diamond Head Road A, is also available for sale, presenting a rare opportunity to establish a landmark estate in one of Honolulu’s most prestigious locations. Property details may not match tax records." +"ArchitecturalStyle": "Detached" +"AttributionContact": "(800) 667-5028" +"BathroomsFull": 6 +"CommunityFeatures": "Deck/Porch, Patio" +"ConstructionMaterials": "Masonry,Stucco,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-10-02T19:29:44.087057+00:00" +"DaysOnMarket": 197 +"DaysOnMarketReplication": 15 +"DaysOnMarketReplicationDate": "2025-10-17" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"ExteriorFeatures": "Landscaping" +"Fencing": "Fenced, Wall" +"Flooring": "Ceramic Tile,Other" +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "AC Split,Auto Garage Door Opener,Blinds,Book Shelves,Cable TV,Ceiling Fan,Chandelier,Dishwasher,Disposal,Drapes,Dryer,Lawn Sprinkler,Microwave,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater,Wine Refrigerator" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Multi/Split" +"ListAgentDirectPhone": "(808) 221-8889" +"ListAgentEmail": "noelshaw@hawaiilife.com" +"ListAgentKey": "10779096" +"ListAgentKeyNumeric": "10779096" +"ListAgentOfficePhone": "(800) 667-5028" +"ListAgentPreferredPhone": "(808) 221-8889" +"ListAgentStateLicense": "RS-75888" +"ListOfficeEmail": "Admin@hawaiilife.com" +"ListOfficeKey": "2588754" +"ListOfficeKeyNumeric": "2588754" +"ListOfficePhone": "(800) 667-5028" +"ListingContractDate": "2025-10-02" +"ListingKeyNumeric": 1135674628 +"ListingService": "Full Service" +"LotFeatures": "Dead End,Other,Level" +"MLSAreaMajor": "Diamond Hd" +"MajorChangeTimestamp": "2025-10-02T09:27:12Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-10-02" +"OriginalListPrice": 43000000.0 +"OriginatingSystemKey": "18987344" +"OtherStructures": "Workshop" +"ParcelNumber": "1-3-1-039-005-0000" +"ParkingFeatures": "Boat,Driveway,Garage,Three or more Spaces" +"ParkingTotal": "10.0" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 10 +"PoolFeatures": "In Ground" +"PostalCity": "Honolulu" +"PropertyCondition": "Average Condition,Updated/Remodeled" +"RoadFrontageType": "Private Road" +"RoomType": "Entry/Foyer,Guest Quarters" +"SourceSystemKey": "1135674628" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Diamond Head" +"StreetNumber": "3735-" +"StreetSuffix": "Road" +"SubdivisionName": "DIAMOND HEAD" +"TaxAnnualAmount": "36840.0" +"TaxAssessedValue": 10525800 +"Topography": "Level, Sloping" +"Utilities": "Above Ground Utilities,Electricity Available,Water Available" +"View": "Coastline, Garden, Mountain(s), Ocean" +"ViewYN": true +"ZoningDescription": "04 - R-7.5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1135674628"\n } """ +"HumanModifiedYN": false +"TaxAssessedValueLand": "9351700" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "1174100" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1135674628')" +"provider_name": "HICMLS" +"RecordSignature": 467678181 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-3-1-039-005-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3487136" +"OriginatingSystemListAgentMemberKey": "9493566" +"Media": array:10 [ …10] +"ID": "60006" } 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4378 +post_id: "49330" +post_author: 1 +"ListingKey": "1076493833" +"ListingId": "202414294" +"PropertyType": "Land" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-09T22:28:29Z" +"RFModificationTimestamp": "2025-11-11T07:16:05Z" +"ListPrice": 450000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 5250.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waianae" +"PostalCode": "96792" +"UnparsedAddress": "86-896 Iniki Place Iniki Place, Waianae, Hawaii 96792" +"Coordinates": array:2 [ …2] +"Latitude": 21.4411487 +"Longitude": -158.1770412 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Susan Weinik" +"ListOfficeName": "Hawaii Homes International" +"ListAgentMlsId": "27650" +"ListOfficeMlsId": "REEW" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ 5250 sf of vacanat land with partial foundation structure and available hook ups for water, electric and cable. Located in the\r\n neighborhood of Pokay Bay Estates.\r\n LOCATION LOCATION Country and Convenience. 10 minutes ot Waianae Comprehensive Care and just a few minutes to \r\n sparkling lifeguarded Pokay Bay beach.\r\n \r\n The property backs up to beautiful mountain scenery with out roads buildings or lights. \r\n \r\n The owner originally planned on turning this into a care home. Only a certificate from the health dept and not a license is needed.\r\n as long as there are only 8 or less occupants and a full time caregiver.\r\n The proximity to the Hospital and the peaceful surroundings make this possible.\r\n \r\n Originally there was a four bedroom home located on the property but it was torn down some time ago.\r\n \r\n From the second story you would see the ocean view.\r\n \r\n Tamaras grocery and the post office and some restaurants are also on the street near the beach. """ +"AttributionContact": "(808) 949-0020" +"CLIP": 5209569185 +"CommunityFeatures": "Street Lights" +"CountyOrParish": "Oahu" +"CreationDate": "2025-04-08T01:47:28.687365+00:00" +"CurrentUse": "Residential,Single Family" +"DaysOnMarket": 672 +"DaysOnMarketReplication": 360 +"DaysOnMarketReplicationDate": "2025-06-09" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "1031 Exchange,Call Agent,Seller Disclosure,See Remarks" +"ElementarySchool": "Leihoku" +"HighSchool": "Waianae" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 382-1162" +"ListAgentEmail": "susanweinik@aol.com" +"ListAgentKey": "10777688" +"ListAgentKeyNumeric": "10777688" +"ListAgentOfficePhone": "(808) 949-0020" +"ListAgentPreferredPhone": "(808) 382-1162" +"ListAgentStateLicense": "RS-64037" +"ListOfficeEmail": "hihomesintl@gmail.com" +"ListOfficeKey": "2587968" +"ListOfficeKeyNumeric": "2587968" +"ListOfficePhone": "(808) 949-0020" +"ListingContractDate": "2024-06-14" +"ListingKeyNumeric": 1076493833 +"ListingService": "Full Service" +"LotFeatures": "Cleared" +"MLSAreaMajor": "Leeward" +"MajorChangeTimestamp": "2025-06-09T12:28:12Z" +"MiddleOrJuniorSchool": "Waianae" +"MlsStatus": "Active" +"OnMarketDate": "2024-06-14" +"OriginalListPrice": 450000.0 +"OriginatingSystemKey": "18072404" +"ParcelNumber": "1-8-6-021-069-0000" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 16 +"PossibleUse": "Multi-Family,Other,Single Family" +"PostalCity": "Waianae" +"RoadFrontageType": "Private Road" +"Sewer": "Not Connected" +"SourceSystemKey": "1076493833" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Iniki" +"StreetNumber": "86-896 Iniki Place" +"StreetSuffix": "Place" +"SubdivisionName": "LUALUALEI" +"TaxAnnualAmount": "1548.0" +"TaxAssessedValue": 430300 +"Topography": "Other" +"Utilities": "Cable Available,Electricity Available,Sewer Available,Water Available" +"View": "City, Mountain(s), Ocean" +"ViewYN": true +"WaterSource": "Public" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "SetBacks": "Of Record",\n "StreetViewParam": "1$21.441542$-158.177051$61.31$13.33$1.00$wKU8KD3Mh4TKzxNUq_tIZg",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "430300.00",\n "LockBoxModDT": "2024-06-14T13:26:06.427",\n "Easements": "None",\n "LandRecorded": "Land Court",\n "ListingKey": "1076493833",\n "TaxAssessedValueImprovements": "430300.00",\n "ShowingTimeFlagYN": "0",\n "CompensationMethod": "",\n "SellingAgentRemarks": "",\n "CompensationSubjectTo": ""\n } """ +"Restrictions": "No Restrictions" +"HumanModifiedYN": true +"TaxAssessedValueLand": "430300" +"LeaseAmountPerAreaUnit": "Dollars Per Square Foot" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "430300" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1076493833')" +"provider_name": "HICMLS" +"RecordSignature": 31215864 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-8-6-021-069-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486350" +"OriginatingSystemListAgentMemberKey": "3477285" +"Media": array:16 [ …16] +"ID": "49330" } 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4379 +post_id: "50669" +post_author: 1 +"ListingKey": "1075450525" +"ListingId": "202411370" +"PropertyType": "For Sale" +"PropertySubType": "Industrial" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-17T18:49:30Z" +"RFModificationTimestamp": "2025-11-11T04:43:47Z" +"ListPrice": 3750000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 92670.0 +"LivingArea": 0 +"BuildingAreaTotal": 11748.0 +"City": "Wailuku" +"PostalCode": "96793" +"UnparsedAddress": "1005 Lower Main Street, Wailuku, Hawaii 96793" +"Coordinates": array:2 [ …2] +"Latitude": 20.893960270122 +"Longitude": -156.4941341418 +"YearBuilt": 1982 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Shane H Fuke" +"ListOfficeName": "Five Star Realty, Inc." +"ListAgentMlsId": "52769" +"ListOfficeMlsId": "FIVE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ 4.8 CAP - Currently leased at a One year term, with an option to renew for an additional year. Home to Maui’s own Home Maid Bakery for over 35+ years. Rarely available 10,564 sq ft metal frame building with 23 feet ceilings siting on 0.721 acres (31,428 sq ft) (TMK 049) of land in Wailuku which includes the adjacent vacant land of 2.127 acres (61,242 sq ft) (TMK 048), zoned B-2 Business - Community & A-2 Apartment. Originally used and operated as a full-service bakery with industrial size walk in freezers, refrigerators, mixers ovens and commercial stainless-steel kitchen. Building consists of approximately 1,200 sq ft of existing retail space on the bottom floor with office space mezzanine directly above.\r\n HIGHLIGHTS\r\n • 200 solar panels 345 W (owned) producing 57.6 kw (AC) installed in 2017 reducing the existing electric bills.\r\n • Lower Main Street frontage (approximately 625 linear ft)\r\n • 15 paved parking stalls with additional parking on the adjacent vacant land\r\n SUMMARY\r\n • Offering Price: (2 parcels) $4,399,000\r\n • 1005 Lower Main Street (SF): 10,564 (building) / 31,428 (land) TMK#'s (2)3-8-037-049 (B-2)\r\n • 955 Lower Main Street (SF): 61,242 (land) TMK#'s (2)3-8-037-048 (A-2) """ +"AttributionContact": "(808) 382-6871" +"BuildingFeatures": "Private Restrooms" +"BuildingName": "N/A" +"BusinessName": "Home Maid Bakery" +"BusinessType": "Convenience Store,Industrial,Mixed,Professional/Office,Other,Warehouse" +"CLIP": 2190170745 +"ConstructionMaterials": "Metal Frame" +"Cooling": "None" +"CountyOrParish": "Maui" +"CreationDate": "2025-04-07T22:20:09.896179+00:00" +"CurrentUse": "Mixed Use" +"DaysOnMarket": 624 +"DaysOnMarketReplication": 289 +"DaysOnMarketReplicationDate": "2025-05-17" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Familial Relation,None" +"EntryLevel": 2 +"ExistingLeaseType": "Other" +"Flooring": "Concrete, Wood" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 223-9919" +"ListAgentEmail": "shane@fivestarrealty.org" +"ListAgentKey": "21403045" +"ListAgentKeyNumeric": "21403045" +"ListAgentOfficePhone": "(808) 382-6871" +"ListAgentPreferredPhone": "(808) 223-9919" +"ListAgentStateLicense": "RS-85663" +"ListOfficeEmail": "vincent@fivestarrealty.org" +"ListOfficeKey": "2588170" +"ListOfficeKeyNumeric": "2588170" +"ListOfficePhone": "(808) 382-6871" +"ListingContractDate": "2024-08-01" +"ListingKeyNumeric": 1075450525 +"ListingService": "Full Service" +"MLSAreaMajor": "Maui" +"MajorChangeTimestamp": "2025-02-27T09:22:25Z" +"MlsStatus": "Active" +"NetOperatingIncome": 170000.0 +"OnMarketDate": "2024-08-01" +"OperatingExpense": "10000.0" +"OriginalListPrice": 4399000.0 +"OriginatingSystemKey": "18009095" +"ParcelNumber": "2-3-8-037-049-0000" +"ParkingFeatures": "On Site" +"ParkingTotal": "15.0" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 8 +"PostalCity": "Wailuku" +"PropertyCondition": "Average Condition" +"RoadFrontageType": "City Street" +"SecurityFeatures": "Security Service" +"Sewer": "Connected" +"SourceSystemKey": "1075450525" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "Lower Main" +"StreetNumber": "1005" +"StreetNumberNumeric": "1005" +"StreetSuffix": "Street" +"SubdivisionName": "KIHEI/WLUKU/KAHA" +"TaxAnnualAmount": "5880.0" +"TaxAssessedValue": 972100 +"TenantPays": "None" +"TotalActualRent": 15000.0 +"Utilities": "Electricity Available,Natural Gas Available,Sewer Connected" +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=w9dA9sqpweg" +"ZoningDescription": "32 - B-2 Community Business Dis" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "IncomeInformationSource": "Owner",\n "CommercialSpaceYN": "0",\n "SQFTInterior": "11748",\n "Loading": "Container Doors,Loading Area",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "554400.00",\n "LockBoxModDT": "2024-12-07T07:32:09.570",\n "LandRecorded": "Land Court",\n "ListingKey": "1075450525",\n "TaxAssessedValueImprovements": "417700.00",\n "StreetViewParam": "1$20.899729623499052$-156.4889303092559$126.04$13.33$1.00$N5b_gTpjFeqN8n0VjnHyag",\n "Easements": "Water",\n "LandlordPhone": "8082444150",\n "LandlordName": "Home Maid Bakery",\n "SQFTOther": "0",\n "ExpensesInformationSource": "Owner",\n "ShowingTimeFlagYN": "0",\n "SellingAgentRemarks": "",\n "CompensationMethod": "",\n "CompensationSubjectTo": "",\n "TotalIncome": "180000.00"\n } """ +"HumanModifiedYN": false +"TaxAssessedValueLand": "554400" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "417700" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1075450525')" +"provider_name": "HICMLS" +"RecordSignature": 1822456912 +"UniversalParcelId": "urn:reso:upi:2.0:US:15009:2-3-8-037-049-0000" +"CountrySubdivision": "15009" +"OriginatingSystemListOfficeKey": "3486552" +"OriginatingSystemListAgentMemberKey": "16925792" +"Media": array:8 [ …8] +"ID": "50669" } 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4380 +post_id: "54022" +post_author: 1 +"ListingKey": "1115112185" +"ListingId": "202513770" +"PropertyType": "Land" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-24T23:08:01Z" +"RFModificationTimestamp": "2025-11-11T05:34:47Z" +"ListPrice": 675000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 94960.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waialua" +"PostalCode": "96791" +"UnparsedAddress": "68-670 Farrington Highway 10, Waialua, Hawaii 96791" +"Coordinates": array:2 [ …2] +"Latitude": 21.575719 +"Longitude": -158.124847 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kyle Bernhardt" +"ListOfficeName": "Hawaii Life" +"ListAgentMlsId": "46408" +"ListOfficeMlsId": "HLRE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Nestled between the majestic green mountains and sparkling blue ocean of Mokule'ia, this 2 acre agricultural unit offers an extraordinary blend of natural beauty and food-growing potential. The land lies within a lush, tropical micro-climate where warm trade winds and rain showers and rich soil come together to create ideal conditions for abundant, year-round cultivation. Clean Ag water comes from wells within the development. Ag structures less than 1000 square feet may be exempt from permitting and only require a DPP approved Ag structure exemption form. Call for an appointment and come check it out!" +"AssociationFee": "60.0" +"AttributionContact": "(800) 667-5028" +"BusinessType": "Florist/Nursery" +"CLIP": 5778846671 +"CoListAgentDirectPhone": "(808) 286-7550" +"CoListAgentEmail": "julia@hawaiilife.com" +"CoListAgentFullName": "Julia Napua Fetzer" +"CoListAgentKey": "10777582" +"CoListAgentKeyNumeric": "10777582" +"CoListAgentMlsId": "26358" +"CoListAgentPreferredPhone": "(808) 286-7550" +"CoListOfficeEmail": "Admin@hawaiilife.com" +"CoListOfficeKey": "2588754" +"CoListOfficeKeyNumeric": "2588754" +"CoListOfficeMlsId": "HLRE" +"CoListOfficeName": "Hawaii Life" +"CoListOfficePhone": "(800) 667-5028" +"CountyOrParish": "Oahu" +"CreationDate": "2025-06-24T23:11:50.621005+00:00" +"CurrentUse": "Agricultural" +"DaysOnMarketReplicationDate": "2025-06-24" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ExteriorFeatures": "None" +"FrontageType": "Other" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 391-5969" +"ListAgentEmail": "kylebernhardt@hawaiilife.com" +"ListAgentKey": "10774402" +"ListAgentKeyNumeric": "10774402" +"ListAgentOfficePhone": "(800) 667-5028" +"ListAgentPreferredPhone": "(808) 391-5969" +"ListAgentStateLicense": "RS-78073" +"ListOfficeEmail": "Admin@hawaiilife.com" +"ListOfficeKey": "2588754" +"ListOfficeKeyNumeric": "2588754" +"ListOfficePhone": "(800) 667-5028" +"ListingContractDate": "2025-06-24" +"ListingKeyNumeric": 1115112185 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Interior Lot,Level" +"MLSAreaMajor": "North Shore" +"MajorChangeTimestamp": "2025-06-24T13:07:28Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-06-24" +"OriginalListPrice": 675000.0 +"OriginatingSystemKey": "18798427" +"ParcelNumber": "1-6-8-003-009-0011" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 11 +"PossibleUse": "Farm, Nursery" +"PostalCity": "Waialua" +"RoadFrontageType": "Private Road" +"Sewer": "None" +"SourceSystemKey": "1115112185" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Farrington" +"StreetNumber": "68-670" +"StreetSuffix": "Highway" +"SubdivisionName": "MOKULEIA" +"TaxAnnualAmount": "3252.0" +"TaxAssessedValue": 569900 +"Topography": "Level" +"UnitNumber": "10" +"Utilities": "Water Available,Sewer Not Available" +"View": "Mountain(s)" +"ViewYN": true +"WaterSource": "Private" +"ZoningDescription": "52 - AG-2 General Agricultural" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "SetBacks": "Of Record",\n "CompensationSubjectTo": "",\n "UtilitiesMeters": "Water",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "569900.00",\n "LockBoxModDT": "2025-06-09T13:22:35.213",\n "CompensationMethod": "",\n "SellingAgentRemarks": "",\n "Easements": "Drainage",\n "LandRecorded": "Dual Systems",\n "ListingKey": "1115112185"\n } """ +"Restrictions": "Restrictive Covenant" +"HumanModifiedYN": false +"TaxAssessedValueLand": "569900" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1115112185')" +"provider_name": "HICMLS" +"RecordSignature": 100337381 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-6-8-003-009-0011" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3487136" +"OriginatingSystemCoListOfficeKey": "3487136" +"OriginatingSystemListAgentMemberKey": "10235678" +"OriginatingSystemCoListAgentMemberKey": "3476047" +"Media": array:11 [ …11] +"ID": "54022" } 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4381 +post_id: "51854" +post_author: 1 +"ListingKey": "1082221219" +"ListingId": "202419248" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-27T03:26:49Z" +"RFModificationTimestamp": "2025-11-11T07:46:21Z" +"ListPrice": 2498000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1272.0 +"BuildingAreaTotal": 1464.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "2139 Kuhio Avenue 3602, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.282264240353 +"Longitude": -157.82950802427 +"YearBuilt": 2018 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sanshiro Kiyose" +"ListOfficeName": "Associated Real Estate Advisor" +"ListAgentMlsId": "50071" +"ListOfficeMlsId": "AREA" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Experience the luxury living at Ritz-Carlton Residences Waikiki Beach.! This modern feel unit located at Tower 2 is fully furnished and includes bedding, kitchenware, a gourmet kitchen with Miele appliances, hardwood flooring, marble bathroom walls and countertops, and in-room laundry. Enjoy the stunning ocean view from the lanai!" +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Concierge" +"AssociationFee2": "416.0" +"AssociationFeeIncludes": "Common Areas,Cable TV,HVAC,Hot Water,Internet,Maintenance Grounds,Maintenance Structure,Sewer,Water" +"AttributionContact": "(808) 445-9199" +"BathroomsFull": 3 +"BuildingName": "The Ritz-Carlton Residences Twr 2 - 383 Kalaimoku" +"CLIP": 2279596042 +"CommunityFeatures": "Concierge,Community Pool,Conference/Meeting Room,Fitness,Pool,Restaurant,Sauna,Trash Chute,Condo Hotel Community" +"ConstructionMaterials": "Concrete" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2025-04-08T01:32:45.834435+00:00" +"DaysOnMarket": 589 +"DaysOnMarketReplication": 355 +"DaysOnMarketReplicationDate": "2025-08-27" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 36 +"Flooring": "Hardwood, Marble" +"Furnished": "Furnished" +"Inclusions": "AC Central,Blinds,Cable TV,Dishwasher,Drapes,Dryer,Kitchenware,Linens,Microwave,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Washer" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 445-9199" +"ListAgentEmail": "sanshiro@associatedhawaii.com" +"ListAgentKey": "13403557" +"ListAgentKeyNumeric": "13403557" +"ListAgentOfficePhone": "(808) 445-9199" +"ListAgentPreferredPhone": "(808) 445-9199" +"ListAgentStateLicense": "RB-24325" +"ListOfficeEmail": "kelly@associatedhawaii.com" +"ListOfficeKey": "3167562" +"ListOfficeKeyNumeric": "3167562" +"ListOfficePhone": "(808) 445-9199" +"ListingContractDate": "2024-09-05" +"ListingKeyNumeric": 1082221219 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 2707.51 +"MajorChangeTimestamp": "2025-08-26T17:26:46Z" +"MlsStatus": "Active" +"OnMarketDate": "2024-09-05" +"OriginalListPrice": 3100000.0 +"OriginatingSystemKey": "18229320" +"ParcelNumber": "1-2-6-018-043-0237" +"ParkingFeatures": "None, Valet" +"PhotosChangeTimestamp": "2025-11-11T00:25:10Z" +"PhotosCount": 15 +"PoolFeatures": "Heated" +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Key Card Entry,Fire Sprinkler System" +"SourceSystemKey": "1082221219" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kuhio" +"StreetNumber": "2139" +"StreetNumberNumeric": "2139" +"StreetSuffix": "Avenue" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "32056.08" +"TaxAssessedValue": 2232500 +"UnitNumber": "3602" +"View": "Ocean, Sunset" +"ViewYN": true +"ZoningDescription": "X6 - Resort Mixed Use Precinct" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "CompensationSubjectTo": "",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "251600.00",\n "LockBoxModDT": "2024-09-02T16:45:59.423",\n "CompensationMethod": "",\n "SellingAgentRemarks": "",\n "ListingKey": "1082221219",\n "TaxAssessedValueImprovements": "1980900.00",\n "FractionalOwnershipYN": "0",\n "ManagementCompanyName": "AOUO 383 Kalaimoku",\n "StreetViewParam": "1$21.281836$-157.829554$98.91$13.33$1.00$CAoSLEFGMVFpcE1PWWU1UHM3NFhGZHpmMmFxUkpDWXlFM21pdzBZVEVReWQ4dHRJ",\n "SQFTLanaiOpen": "192",\n "ManagementCompanyPhone": "808-729-9781",\n "LandRecorded": "Dual Systems",\n "ParkingAdditional": "0",\n "OwnerOccupancyPercentage": "5",\n "TaxExcemptionOwnerOccupancy": "0",\n "CondoParkingUnit": "N/A",\n "ShowingTimeFlagYN": "0"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 3124.0 +"TaxAssessedValueLand": "251600" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "1980900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1082221219')" +"provider_name": "HICMLS" +"RecordSignature": -91691158 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-018-043-0237" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15110879" +"OriginatingSystemListAgentMemberKey": "14912685" +"Media": array:15 [ …15] +"ID": "51854" } ] +success: true +page_size: 18 +page_count: 241 +count: 4323 +after_key: "" } "RF Response Time" => "0.45 seconds" ] "RF Query: /Property?$select=ALL&$orderby=meta_value date DESC&$top=18&$skip=4122&$filter=(StandardStatus eq 'Active') and (StandardStatus eq 'Active' OR RFTransactionType eq 'Active')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#6937 +items: array:18 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6985 +post_id: "81689" +post_author: 1 +"ListingKey": "1156495161" +"ListingId": "202606678" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-17T09:35:08Z" +"RFModificationTimestamp": "2026-04-17T09:39:57Z" +"ListPrice": 2400000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 853.0 +"BuildingAreaTotal": 853.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "2895 Kalakaua Avenue 1402, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.2622746 +"Longitude": -157.8213588 +"YearBuilt": 1959 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Tracy Allen" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "18139" +"ListOfficeMlsId": "CBPP" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "REFINED ISLAND LIVING WITH FRONT ROW OCEAN VIEWS. Perched on a high floor within the iconic Colony Surf, this beautifully renovated one bedroom residence offers a rare opportunity along one of Oahu’s most coveted sandy beachfronts. Positioned in a premier center front orientation, the residence captures sweeping views of the Pacific Ocean, coastline, and Waikiki skyline. The open floor plan is filled with natural light and framed by mesmerizing ocean vistas. Light coastal wood flooring, custom ceiling details, and a clean modern aesthetic create a relaxed elegance throughout. The kitchen features stainless appliances, ample storage, and a generous island with dine in seating. The bedroom enjoys ocean views and privacy plantation shutters for flexible separation. The bath includes a custom dual sink vanity with coastal white shutter cabinetry, walk in shower, and integrated washer and dryer. Custom built in seating along the oceanfront window is ideal for taking in breathtaking sunsets. Moments from Kapiolani Park, Waikiki shopping and dining, and nearby favorites including Michel’s, Hau Tree, and Arden restaurants, this is an exceptional oceanfront residence." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Cable TV,Electricity,Gas,Hot Water,Internet,Maintenance Grounds,Maintenance Structure,Sewer,Water" +"AttributionContact": "(808) 596-0456" +"BathroomsFull": 1 +"BuildingName": "Colony Surf Ltd" +"CommunityFeatures": "Restaurant,Trash Chute" +"ConstructionMaterials": "Masonry, Concrete, Stucco" +"CountyOrParish": "Oahu" +"CreationDate": "2026-04-15T06:43:32.484639+00:00" +"DaysOnMarket": 2 +"DaysOnMarketReplication": 2 +"DaysOnMarketReplicationDate": "2026-04-16" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Waikiki" +"EntryLevel": 13 +"Flooring": "Ceramic Tile,Hardwood" +"FoundationDetails": "Slab" +"FrontageType": "Oceanfront, Waterfront" +"HighSchool": "Kalani" +"HumanModifiedYN": true +"Inclusions": "Book Shelves,Cable TV,Ceiling Fan,Dishwasher,Disposal,Dryer,Microwave Hood,Range/Oven,Refrigerator,Smoke Detector,Washer" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 927-6415" +"ListAgentEmail": "Tracy@Tracy Allen Hawaii.com" +"ListAgentKey": "10773583" +"ListAgentKeyNumeric": "10773583" +"ListAgentOfficePhone": "(808) 596-0456" +"ListAgentPreferredPhone": "(808) 927-6415" +"ListAgentStateLicense": "RS-46610" +"ListOfficeEmail": "mike.james@cbrealty.com" +"ListOfficeKey": "2586830" +"ListOfficeKeyNumeric": "2586830" +"ListOfficePhone": "(808) 596-0456" +"ListingContractDate": "2026-04-14" +"ListingKeyNumeric": 1156495161 +"ListingService": "Full Service" +"MLSAreaMajor": "Diamond Hd" +"MaintenanceExpense": 1664.0 +"MajorChangeTimestamp": "2026-04-14T20:40:42Z" +"MiddleOrJuniorSchool": "Kaimuki" +"MlsStatus": "Active" +"OnMarketDate": "2026-04-14" +"OriginalListPrice": 2400000.0 +"OriginatingSystemKey": "19365741" +"ParcelNumber": "1-3-1-032-010-0110" +"ParkingFeatures": "Guest,On Street" +"PhotosChangeTimestamp": "2026-04-02T19:56:11Z" +"PhotosCount": 21 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Security Guard" +"SourceSystemKey": "1156495161" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kalakaua" +"StreetNumber": "2895" +"StreetNumberNumeric": "2895" +"StreetSuffix": "Avenue" +"SubdivisionName": "DIAMOND HEAD" +"TaxAnnualAmount": "7236.0" +"TaxAssessedValue": 1781000 +"UnitNumber": "1402" +"View": "Coastline, City, Mountain(s), Ocean, Sunrise" +"ViewYN": true +"VirtualTourURLUnbranded": "https://player.vimeo.com/video/1177867477?h=44dcc244ae" +"WaterfrontYN": true +"YearBuiltEffective": 2019 +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1156495161"\n } """ +"AssociationFeeTotal": 1664.0 +"TaxAssessedValueLand": "92200" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "1688800" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1156495161')" +"provider_name": "HICMLS" +"RecordSignature": -1437765977 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-3-1-032-010-0110" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485212" +"OriginatingSystemListAgentMemberKey": "8834388" +"Media": array:21 [ …21] +"ID": "81689" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6983 +post_id: "81690" +post_author: 1 +"ListingKey": "1155302449" +"ListingId": "202605688" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-16T21:45:19Z" +"RFModificationTimestamp": "2026-04-16T21:50:58Z" +"ListPrice": 699900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 1143.0 +"LivingArea": 1136.0 +"BuildingAreaTotal": 1136.0 +"City": "Ewa Beach" +"PostalCode": "96706" +"UnparsedAddress": "91-2142 Kanela Street M98, Ewa Beach, Hawaii 96706" +"Coordinates": array:2 [ …2] +"Latitude": 21.315603 +"Longitude": -158.008804 +"YearBuilt": 2006 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lisa Jack" +"ListOfficeName": "Keller Williams Honolulu" +"ListAgentMlsId": "47463" +"ListOfficeMlsId": "KWPP" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Priced below tax assessed value — this is the opportunity savvy buyers have been waiting for.\r\n Tucked into a well-established community, this end-unit townhome checks the boxes that matter: 3 bedrooms | 2 bathrooms | 2-car garage + bonus parking space. A first-floor bedroom adds flexibility for multi-generational living or a dedicated home office.\r\n Location delivers without compromise. Two shopping centers within easy reach offer dining, groceries, hardware, pharmacy, and banking — everything you need, close to home. Multiple parks nearby support the outdoor lifestyle Hawaii is known for.\r\n Community amenities include a pool and well-maintained common areas — the kind of neighborhood where pride of ownership shows.\r\n Don't sleep on this one. Book your showing today. """ +"ArchitecturalStyle": "Detached" +"AssociationFee": "56.0" +"AssociationName": "Ewa By Gentry" +"AttributionContact": "(808) 596-2888" +"BathroomsFull": 2 +"CoListAgentDirectPhone": "(808) 596-2888" +"CoListAgentEmail": "dominique.unrein@gmail.com" +"CoListAgentFullName": "Dominique Unrein" +"CoListAgentKey": "25922635" +"CoListAgentKeyNumeric": "25922635" +"CoListAgentMlsId": "54455" +"CoListAgentPreferredPhone": "(808) 265-8999" +"CoListOfficeEmail": "frontdesk946@kw.com" +"CoListOfficeKey": "2586166" +"CoListOfficeKeyNumeric": "2586166" +"CoListOfficeMlsId": "KWPP" +"CoListOfficeName": "Keller Williams Honolulu" +"CoListOfficePhone": "(808) 596-2888" +"CountyOrParish": "Oahu" +"CreationDate": "2026-04-15T07:13:53.468975+00:00" +"DaysOnMarket": 3 +"DaysOnMarketReplication": 2 +"DaysOnMarketReplicationDate": "2026-04-16" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Pohakea" +"Flooring": "Laminate, Vinyl" +"GarageYN": true +"HighSchool": "Campbell" +"Inclusions": "AC Central,Auto Garage Door Opener,Blinds,Cable TV,Ceiling Fan,Dishwasher,Disposal,Microwave Hood,Range/Oven,Refrigerator,Smoke Detector,Water Heater" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 783-5138" +"ListAgentEmail": "lisajack RA@gmail.com" +"ListAgentKey": "10779937" +"ListAgentKeyNumeric": "10779937" +"ListAgentOfficePhone": "(808) 596-2888" +"ListAgentPreferredPhone": "(808) 783-5138" +"ListAgentStateLicense": "RS-79542" +"ListOfficeEmail": "frontdesk946@kw.com" +"ListOfficeKey": "2586166" +"ListOfficeKeyNumeric": "2586166" +"ListOfficePhone": "(808) 596-2888" +"ListingContractDate": "2026-04-14" +"ListingKeyNumeric": 1155302449 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Corner Lot,Level" +"MLSAreaMajor": "Ewaplain" +"MaintenanceExpense": 945.0 +"MajorChangeTimestamp": "2026-04-14T21:08:43Z" +"MiddleOrJuniorSchool": "Ilima" +"MlsStatus": "Active" +"OnMarketDate": "2026-04-14" +"OriginalListPrice": 699900.0 +"OriginatingSystemKey": "19338055" +"ParcelNumber": "1-9-1-132-010-0080" +"ParkingFeatures": "Garage,Three or more Spaces" +"ParkingTotal": "3.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-04-15T06:33:01Z" +"PhotosCount": 16 +"PoolFeatures": "Community" +"PostalCity": "Ewa Beach" +"PropertyCondition": "Good Condition,Updated/Remodeled" +"SourceSystemKey": "1155302449" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Kanela" +"StreetNumber": "91-2142" +"StreetSuffix": "Street" +"SubdivisionName": "EWA GEN MONTECITO/TUSCANY" +"TaxAnnualAmount": "2112.0" +"TaxAssessedValue": 720800 +"Topography": "Level" +"UnitNumber": "M98" +"Utilities": "Cable Available,Electricity Available,High Speed Internet Available,Underground Utilities,Water Available" +"View": "None" +"WaterSource": "Public" +"YearBuiltEffective": 2022 +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1155302449"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1001.0 +"TaxAssessedValueLand": "473300" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "247500" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1155302449')" +"provider_name": "HICMLS" +"RecordSignature": -118835954 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-1-132-010-0080" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "8991040" +"OriginatingSystemCoListOfficeKey": "8991040" +"OriginatingSystemListAgentMemberKey": "11008473" +"OriginatingSystemCoListAgentMemberKey": "18524640" +"Media": array:16 [ …16] +"ID": "81690" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6988 +post_id: "81691" +post_author: 1 +"ListingKey": "1157589888" +"ListingId": "202607491" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-15T19:52:20Z" +"RFModificationTimestamp": "2026-04-15T19:54:12Z" +"ListPrice": 1250000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 505.0 +"BuildingAreaTotal": 505.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "2895 Kalakaua Avenue 1403, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.2622746 +"Longitude": -157.8213588 +"YearBuilt": 1959 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Tracy Allen" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "18139" +"ListOfficeMlsId": "CBPP" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "TIMELESS BEACHFRONT LIVING WITH FRONT ROW VIEWS. Perched in a prime front row setting within the iconic Colony Surf, this beautifully renovated studio residence offers an exceptional opportunity to enjoy oceanfront living along one of Oahu’s most coveted sandy beachfronts. The residence captures stunning views of the Pacific Ocean and is filled with natural light, creating a warm and inviting island-inspired interior. Rich acacia wood flooring brings warmth and a relaxed island style. The thoughtfully designed kitchen features custom mahogany cabinetry, granite countertops, open display shelving for china, and a built in cooktop, blending style and functionality. The full bath is beautifully appointed with custom mahogany cabinetry, granite counters, and a walk in shower. A built in washer and dryer adds everyday convenience. Designed for effortless island living, the residence is complemented by the soothing sound of the surf and gentle trade winds. Enjoy immediate beach access and close proximity to Kapiolani Park and Waikiki’s vibrant lifestyle, with acclaimed dining just moments away including Michel’s, Hau Tree, and Arden, making this front row oceanfront residence a true gem." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Cable TV,Electricity,Gas,Hot Water,Internet,Maintenance Grounds,Maintenance Structure,Sewer,Water" +"AttributionContact": "(808) 596-0456" +"BathroomsFull": 1 +"BuildingName": "Colony Surf Ltd" +"CommunityFeatures": "Restaurant,Trash Chute" +"ConstructionMaterials": "Masonry, Concrete, Stucco" +"CountyOrParish": "Oahu" +"CreationDate": "2026-04-15T07:56:08.800130+00:00" +"DaysOnMarket": 3 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2026-04-15" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Waikiki" +"EntryLevel": 13 +"Flooring": "Ceramic Tile,Hardwood" +"FoundationDetails": "Slab" +"FrontageType": "Oceanfront, Waterfront" +"HighSchool": "Kalani" +"HumanModifiedYN": true +"Inclusions": "Blinds,Cable TV,Disposal,Dryer,Refrigerator,Washer" +"InteriorFeatures": "Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 927-6415" +"ListAgentEmail": "Tracy@Tracy Allen Hawaii.com" +"ListAgentKey": "10773583" +"ListAgentKeyNumeric": "10773583" +"ListAgentOfficePhone": "(808) 596-0456" +"ListAgentPreferredPhone": "(808) 927-6415" +"ListAgentStateLicense": "RS-46610" +"ListOfficeEmail": "mike.james@cbrealty.com" +"ListOfficeKey": "2586830" +"ListOfficeKeyNumeric": "2586830" +"ListOfficePhone": "(808) 596-0456" +"ListingContractDate": "2026-04-14" +"ListingKeyNumeric": 1157589888 +"ListingService": "Full Service" +"MLSAreaMajor": "Diamond Hd" +"MaintenanceExpense": 1278.0 …47 } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6966 …135} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6984 …110} 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6989 …123} 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6990 …143} 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6967 …136} 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6964 …140} 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6953 …131} 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6960 …113} 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6968 …123} 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7040 …108} 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6991 …114} 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6933 …113} 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6934 …117} 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6935 …120} 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6936 …119} ] +success: true +page_size: 18 +page_count: 241 +count: 4323 +after_key: "" } "RF Response Time" => "0.24 seconds" ] ]
