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&$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 {#5267 +items: array:18 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5252 +post_id: "85770" +post_author: 1 +"ListingKey": "1176094303" +"ListingId": "202612403" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-02T13:58:01Z" +"RFModificationTimestamp": "2026-08-02T13:59:58Z" +"ListPrice": 465000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 93785.0 +"LivingArea": 720.0 +"BuildingAreaTotal": 864.0 +"City": "Aiea" +"PostalCode": "96701" +"UnparsedAddress": "98-99 Uao Place 2108, Aiea, Hawaii 96701" +"Coordinates": array:2 [ …2] +"Latitude": 21.3874404 +"Longitude": -157.941883 +"YearBuilt": 1976 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Mercie Ann G Nahaku" +"ListOfficeName": "Sakuma Realty Inc." +"ListAgentMlsId": "20833" +"ListOfficeMlsId": "SAKU" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "BREATH TAKING VIEW FROM DIAMOND HEAD EAST THROUGH WEST SIDE / MUST SEE ON THE 21ST FLOOR / (2) BEDROOMS & (1) BATHROOM & HUGE BALCONY (LANAI) WITH A SPECTACULAR OCEAN VIEW / WALKING DISTANT TO SHOPPING MALL & RESTAURANTS / EASY ACCESS TO THE FREEWAY (H1/H2/H3) / NEWLY PAINTED UNIT / NEW DISHWASHER & GLASS RANGE/OVEN / BUILDING WELL MAINTAINED AND SECURED & MOBILE ENTRY FOR CONVENIENCE / FIRST TIME BUYERS & CENTRAL LOCATED / COVERED PARKING & STORAGE & SECURED ENTRY INTO COMPLEX & 24-7 SECURITY PATROL / GREAT AMENITIES (POOL, BBQ, CAR WASH & RECREATION AREA) SOLD AS\u{200B}\u{200B}\u{200C}\u{200B}\u{200B}\u{200B}\u{200B}\u{200C}\u{200B}\u{200B}\u{200C}\u{200C}\u{200B}\u{200C}\u{200C}\u{200B}\u{200B}\u{200B}\u{200C}\u{200C}\u{200B}\u{200C}\u{200B}\u{200C}\u{200B}\u{200C}\u{200B}\u{200B}\u{200B}\u{200C}\u{200B}\u{200B} IS" +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Electricity,None,Sewer,Water" +"AttributionContact": "(808) 943-2725" +"BathroomsFull": 1 +"BuildingName": "Lele Pono" +"CLIP": 8471135309 +"CoListAgentDirectPhone": "(808) 286-9470" +"CoListAgentEmail": "alexnahaku@outlook.com" +"CoListAgentFullName": "Alexander K Nahaku" +"CoListAgentKey": "10771539" +"CoListAgentKeyNumeric": "10771539" +"CoListAgentMlsId": "46790" +"CoListAgentPreferredPhone": "(808) 286-9470" +"CoListOfficeEmail": "saku747@aol.com" +"CoListOfficeKey": "2586972" +"CoListOfficeKeyNumeric": "2586972" +"CoListOfficeMlsId": "SAKU" +"CoListOfficeName": "Sakuma Realty Inc." +"CoListOfficePhone": "(808) 943-2725" +"CommunityFeatures": "Barbecue,Deck/Porch,Patio,Pool,Recreation Area,Storage Facilities,Trash Chute,Gated" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-06-26T17:56:00.421121+00:00" +"DaysOnMarket": 37 +"DaysOnMarketReplication": 37 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Pearl Ridge" +"EntryLevel": 21 +"Flooring": "Ceramic Tile,Hardwood,Vinyl" +"FrontageType": "Other" +"Furnished": "Unfurnished" +"GarageYN": true +"HighSchool": "Aiea" +"HumanModifiedYN": true +"Inclusions": "AC Window Unit,Blinds,Ceiling Fan,Dishwasher,Disposal,Drapes,Dryer,Range/Oven,Refrigerator,Smoke Detector,Washer" +"InteriorFeatures": "Storage" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 286-1939" +"ListAgentEmail": "mnahaku@gmail.com" +"ListAgentKey": "10767547" +"ListAgentKeyNumeric": "10767547" +"ListAgentOfficePhone": "(808) 943-2725" +"ListAgentPreferredPhone": "(808) 286-1939" +"ListAgentStateLicense": "RS-51229" +"ListOfficeEmail": "saku747@aol.com" +"ListOfficeKey": "2586972" +"ListOfficeKeyNumeric": "2586972" +"ListOfficePhone": "(808) 943-2725" +"ListingContractDate": "2026-06-26" +"ListingKeyNumeric": 1176094303 +"ListingService": "Full Service" +"MLSAreaMajor": "Pearl City" +"MaintenanceExpense": 903.17 +"MajorChangeTimestamp": "2026-06-26T07:54:52Z" +"MiddleOrJuniorSchool": "Aiea" +"MlsStatus": "Active" +"OnMarketDate": "2026-06-26" +"OriginalListPrice": 465000.0 +"OriginatingSystemKey": "19543278" +"ParcelNumber": "1-9-8-039-009-0168" +"ParkingFeatures": "Assigned,Covered,Garage,Guest,One Space,Secured" +"ParkingTotal": "1.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-08-02T13:58:01Z" +"PhotosCount": 14 +"PostalCity": "Aiea" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Closed Circuit Camera(s),Gated Community,Security Guard" +"SourceSystemKey": "1176094303" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Uao" +"StreetNumber": "98-99" +"StreetSuffix": "Place" +"SubdivisionName": "PEARLRIDGE" +"TaxAnnualAmount": "1656.0" +"TaxAssessedValue": 440600 +"UnitNumber": "2108" +"View": "Ocean" +"ViewYN": true +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1176094303"\n } """ +"AssociationFeeTotal": 903.0 +"TaxAssessedValueLand": "46600" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "394000" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1176094303')" +"provider_name": "HICMLS" +"RecordSignature": -686967078 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-8-039-009-0168" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485354" +"OriginatingSystemCoListOfficeKey": "3485354" +"OriginatingSystemListAgentMemberKey": "3473851" +"OriginatingSystemCoListAgentMemberKey": "10576885" +"Media": array:14 [ …14] +"ID": "85770" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5254 +post_id: "83834" +post_author: 1 +"ListingKey": "1176129137" +"ListingId": "202612439" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-02T13:30:30Z" +"RFModificationTimestamp": "2026-08-02T13:36:00Z" +"ListPrice": 760000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 3047.0 +"LivingArea": 1320.0 +"BuildingAreaTotal": 1457.0 +"City": "Ewa Beach" +"PostalCode": "96706" +"UnparsedAddress": "91-370 Makalea Street 68, Ewa Beach, Hawaii 96706" +"Coordinates": array:2 [ …2] +"Latitude": 21.315603 +"Longitude": -158.008804 +"YearBuilt": 2003 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lorraine E Golden" +"ListOfficeName": "eXp Realty" +"ListAgentMlsId": "46690" +"ListOfficeMlsId": "EXPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ RARE FIND: 2.375% Assumable VA Loan PITI Just $2,498/mo!\r\n Imagine locking in a rate almost impossible to find today. This beautifully maintained 3-bed, 2.5-bath home sits on a quiet cul-de-sac in the highly sought-after Las Brisas community and it’s ready to impress from the moment you walk in.\r\n Sunlight pours through both levels, highlighting brand new living room flooring and a freshly reglazed second bath. The kitchen shines with stainless steel appliances and stylish cabinetry, perfect for everyday living and entertaining alike.\r\n Upstairs, a charming custom built-in desk nook offers the ideal work-from-home setup. The oversized primary suite is a true retreat, boasting a spacious en suite bath and a generous walk-in closet.\r\n Energy savings? Covered .. enjoy 35 leased solar panels, 2 inverters, and 3 batteries. Add a two-car garage, guest parking pass, and fully fenced yard, and you’ve got comfort, security, and efficiency all in one package.\r\n Residents love exclusive access to the Las Brisas pool plus the expansive Ewa by Gentry community pools all just minutes from golf courses, parks, top schools, beaches, and shops. Schedule your showing today this one truly is a MUST SEE! """ +"ArchitecturalStyle": "Detached" +"AssociationAmenities": "Pool" +"AssociationFee": "59.0" +"AssociationFeeIncludes": "Maintenance Grounds,Maintenance Structure" +"AssociationName": "Ewa By Gentry" +"AttributionContact": "(808) 725-2794" +"BathroomsFull": 2 +"CLIP": 3923300886 +"CommunityFeatures": "Deck/Porch,Patio" +"ConstructionMaterials": "Double Wall,Concrete,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-06-30T21:07:23.479140+00:00" +"DaysOnMarket": 33 +"DaysOnMarketReplication": 33 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"Fencing": "Fenced, Wall" +"Flooring": "Ceramic Tile,Laminate,Vinyl" +"FrontageType": "Other" +"Furnished": "Unfurnished" +"GarageSpaces": "2.0" +"GarageYN": true +"Inclusions": "AC Central,Auto Garage Door Opener,Ceiling Fan,Dishwasher,Dryer,Microwave,Photovoltaic – Leased,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 745-4711" +"ListAgentEmail": "Logoldrealty@gmail.com" +"ListAgentKey": "10774487" +"ListAgentKeyNumeric": "10774487" +"ListAgentOfficePhone": "(808) 725-2794" +"ListAgentPreferredPhone": "(808) 745-4711" +"ListAgentStateLicense": "RS-78364" +"ListOfficeEmail": "hi.broker@exprealty.net" +"ListOfficeKey": "2589160" +"ListOfficeKeyNumeric": "2589160" +"ListOfficePhone": "(808) 725-2794" +"ListingContractDate": "2026-06-30" +"ListingKeyNumeric": 1176129137 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Cul-De-Sac, Level" +"MLSAreaMajor": "Ewaplain" +"MaintenanceExpense": 666.9 +"MajorChangeTimestamp": "2026-07-14T16:14:20Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-06-30" +"OriginalListPrice": 780000.0 +"OriginatingSystemKey": "19544199" +"ParcelNumber": "1-9-1-010-103-0068" +"ParkingFeatures": "Garage,Two Car Garage,Two Spaces" +"ParkingTotal": "2.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-07-02T23:48:01Z" +"PhotosCount": 25 +"PoolFeatures": "Community" +"PostalCity": "Ewa Beach" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"RoadFrontageType": "Private Road" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1176129137" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Makalea" +"StreetNumber": "91-370" +"StreetSuffix": "Street" +"SubdivisionName": "EWA GEN LAS BRISAS" +"TaxAnnualAmount": "3144.0" +"TaxAssessedValue": 786600 +"Topography": "Level" +"UnitNumber": "68" +"Utilities": "Cable Available,Electricity Available,High Speed Internet Available,Underground Utilities,Water Available" +"View": "None" +"WaterSource": "Public" +"YearBuiltEffective": 2026 +"ZoningDescription": "11 - A-1 Low Density Apartment" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1176129137"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 726.0 +"TaxAssessedValueLand": "500900" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "285700" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1176129137')" +"provider_name": "HICMLS" +"RecordSignature": -1327363425 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-1-010-103-0068" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10013908" +"OriginatingSystemListAgentMemberKey": "10519467" +"Media": array:25 [ …25] +"ID": "83834" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5251 +post_id: "85769" +post_author: 1 +"ListingKey": "1178740394" +"ListingId": "202614786" +"PropertyType": "Residential Lease" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-02T13:04:01Z" +"RFModificationTimestamp": "2026-08-02T13:07:36Z" +"ListPrice": 6500.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 7.0 +"LotSizeArea": 5488.0 +"LivingArea": 2400.0 +"BuildingAreaTotal": 2820.0 +"City": "Kapolei" +"PostalCode": "96707" +"UnparsedAddress": "92-1239 Hauone Street, Kapolei, Hawaii 96707" +"Coordinates": array:2 [ …2] +"Latitude": 21.3340079 +"Longitude": -158.077849 +"YearBuilt": 1979 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Helen YN Bench" +"ListOfficeName": "Bench Mark Realty" +"ListAgentMlsId": "00629" +"ListOfficeMlsId": "BENC" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Located in the desired neighborhood of upper Makakilo. Cool nights, large floor plan, this unit will make a wonderful home. Newly remodeled, floors, new appliances, much of the home is new. 5 minute drive up the hill from City Kapolei which features all manner of shopping. Owner to provide 4 months of yard service while the yard grows in from the remodel. Pets negotiable. Must See." +"Appliances": "Dryer,Dishwasher,Electric Range,Disposal,Microwave,Refrigerator,Washer" +"ArchitecturalStyle": "Detached" +"AttributionContact": "(808) 488-7776" +"AvailabilityDate": "2026-08-03" +"BathroomsFull": 4 +"CLIP": 9109801619 +"CountyOrParish": "Oahu" +"CreationDate": "2026-08-02T13:07:19.164772+00:00" +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Principal is Real Estate Licensed" +"ExteriorFeatures": "Fully Fenced" +"Fencing": "Fenced" +"Flooring": "Carpet,Ceramic Tile,Hardwood" +"FrontageType": "Other" +"Furnished": "Partially" +"GarageYN": true +"HumanModifiedYN": true +"InteriorFeatures": "Ceiling Fan(s),Double Vanity,Storage,Window Treatments" +"RFTransactionType": "For Rent" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 780-1908" +"ListAgentEmail": "cbench@hawaii.rr.com" +"ListAgentKey": "10773619" +"ListAgentKeyNumeric": "10773619" +"ListAgentOfficePhone": "(808) 488-7776" +"ListAgentPreferredPhone": "(808) 780-1908" +"ListAgentStateLicense": "RB-09594" +"ListOfficeEmail": "cbench@hawaii.rr.com" +"ListOfficeKey": "2586533" +"ListOfficeKeyNumeric": "2586533" +"ListOfficePhone": "(808) 488-7776" +"ListingContractDate": "2026-08-02" +"ListingKeyNumeric": 1178740394 +"LotFeatures": "Yard" +"MLSAreaMajor": "Makakilo" +"MajorChangeTimestamp": "2026-08-02T03:03:21Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-08-02" +"OriginalListPrice": 6500.0 +"OriginatingSystemKey": "19613345" +"ParcelNumber": "1-9-2-023-005-0000" +"ParkingFeatures": "Garage,Garage Door Opener" +"ParkingTotal": "2.0" +"PatioAndPorchFeatures": "Lanai" +"PetsAllowed": "No, Negotiable" +"PhotosChangeTimestamp": "2026-08-02T13:04:01Z" +"PhotosCount": 25 +"PostalCity": "Kapolei" +"PropertyCondition": "Excellent,Updated/Remodeled" +"SecurityFeatures": "Smoke Detector(s)" +"SourceSystemKey": "1178740394" +"StateOrProvince": "HI" +"Stories": "2" +"StoriesTotal": "2" +"StreetName": "HAUONE" +"StreetNumber": "92-1239" +"StreetSuffix": "Street" +"SubdivisionName": "MAKAKILO-PALEHUA HGTS" +"Utilities": "Cable Available,High Speed Internet Available,Phone Available" +"View": "Other" +"ViewYN": true +"WindowFeatures": "Blinds" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"CustomFields": """ {\n "ListingKey": "1178740394"\n } """ +"AvailabilityType": "Long Term" +"OriginatingSystemSubName": "HICMLS_HBR" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178740394')" +"provider_name": "HICMLS" +"short_address": "Kapolei, Hawaii 96707, USA" +"RecordSignature": 2137810431 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-2-023-005-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3484915" +"OriginatingSystemListAgentMemberKey": "8842408" +"Media": array:25 [ …25] +"DaysOnMarket": 0 +"ID": "85769" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5255 +post_id: "85768" +post_author: 1 +"ListingKey": "1174469940" +"ListingId": "202611515" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-02T12:25:43Z" +"RFModificationTimestamp": "2026-08-02T12:29:21Z" +"ListPrice": 339000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 501.0 +"BuildingAreaTotal": 586.0 +"City": "Honolulu" +"PostalCode": "96822" +"UnparsedAddress": "1504 Liholiho Street 401, Honolulu, Hawaii 96822" +"Coordinates": array:2 [ …2] +"Latitude": 21.3047181 +"Longitude": -157.8399928 +"YearBuilt": 1970 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Diana Woo" +"ListOfficeName": "Vonlin Hawaii Real Estate" +"ListAgentMlsId": "36418" +"ListOfficeMlsId": "VLIN" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Move-in ready and exceptionally well-maintained, this 1-bedroom, 1-bath corner unit offers a rare combination of features and affordability in the heart of Makiki. Enjoy the convenience of a full-size washer and dryer, assigned parking stall, and split AC units in both the living room and bedroom. The low $417 monthly maintenance fee includes water, sewer, cable TV, and internet—helping keep monthly ownership costs lower than many comparable properties.\r\n This 4th-floor corner unit enjoys cool tradewind breezes and a private balcony. Double French doors open from the bedroom to the lanai, creating an inviting indoor-outdoor feel. The home features a fresh, clean interior with updated finishes, granite countertops, stainless steel appliances, ceramic tile flooring in the kitchen and bathroom, and koa laminate flooring in the living room and bedroom.\r\n Conveniently located near shopping, dining, schools, bus lines, and freeway access, this fee simple residence offers an excellent opportunity for first-time buyers, investors, or anyone seeking value and convenience in town. A must-see for buyers looking for assigned parking, in-unit laundry, and low monthly maintenance fees. """ +"ArchitecturalStyle": "Low Rise" +"AssociationFeeIncludes": "Common Areas,Cable TV,Internet,Sewer,Water" +"AttributionContact": "(808) 625-8915" +"BathroomsFull": 1 +"BuildingName": "1510 Liholiho" +"CLIP": 1060971019 +"CoListAgentDirectPhone": "(808) 625-8915" +"CoListAgentEmail": "cterada@hawaii.rr.com" +"CoListAgentFullName": "Claire Terada" +"CoListAgentKey": "29263957" +"CoListAgentKeyNumeric": "29263957" +"CoListAgentMlsId": "55035" +"CoListAgentPreferredPhone": "(808) 206-6458" +"CoListOfficeEmail": "realestate@lynnwilkinson.com" +"CoListOfficeKey": "2589013" +"CoListOfficeKeyNumeric": "2589013" +"CoListOfficeMlsId": "VLIN" +"CoListOfficeName": "Vonlin Hawaii Real Estate" +"CoListOfficePhone": "(808) 625-8915" +"CommonWalls": "End Unit" +"CommunityFeatures": "None" +"ConstructionMaterials": "Hollow Tile,Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-06-14T02:10:14.186577+00:00" +"DaysOnMarket": 50 +"DaysOnMarketReplication": 50 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Familial Relation,Seller Disclosure" +"ElementarySchool": "Kaahumanu" +"EntryLevel": 4 +"Flooring": "Ceramic Tile,Laminate" +"Furnished": "Unfurnished" +"HighSchool": "Roosevelt" +"HumanModifiedYN": true +"Inclusions": "AC Split,Blinds,Cable TV,Ceiling Fan,Disposal,Drapes,Dryer,Microwave Hood,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 781-1946" +"ListAgentEmail": "diana.woo@vl-hire.com" +"ListAgentKey": "10778007" +"ListAgentKeyNumeric": "10778007" +"ListAgentOfficePhone": "(808) 625-8915" +"ListAgentPreferredPhone": "(808) 781-1946" +"ListAgentStateLicense": "RB-23443" +"ListOfficeEmail": "realestate@lynnwilkinson.com" +"ListOfficeKey": "2589013" +"ListOfficeKeyNumeric": "2589013" +"ListOfficePhone": "(808) 625-8915" +"ListingContractDate": "2026-06-13" +"ListingKeyNumeric": 1174469940 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 417.0 +"MajorChangeTimestamp": "2026-08-02T02:25:40Z" +"MiddleOrJuniorSchool": "Stevenson" +"MlsStatus": "Active" +"OnMarketDate": "2026-06-13" +"OriginalListPrice": 349000.0 +"OriginatingSystemKey": "19517998" +"ParcelNumber": "1-2-4-020-044-0022" +"ParkingFeatures": "Assigned" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-06-14T02:47:01Z" +"PhotosCount": 17 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1174469940" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Liholiho" +"StreetNumber": "1504" +"StreetNumberNumeric": "1504" +"StreetSuffix": "Street" +"SubdivisionName": "MAKIKI AREA" +"TaxAnnualAmount": "1080.0" +"TaxAssessedValue": 298400 +"TotalActualRent": 1850.0 +"UnitNumber": "401" +"View": "None" +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1174469940"\n } """ +"AssociationFeeTotal": 417.0 +"TaxAssessedValueLand": "182500" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "115900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1174469940')" +"provider_name": "HICMLS" +"RecordSignature": 863361890 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-4-020-044-0022" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "9295785" +"OriginatingSystemCoListOfficeKey": "9295785" +"OriginatingSystemListAgentMemberKey": "3480925" +"OriginatingSystemCoListAgentMemberKey": "19123492" +"Media": array:17 [ …17] +"ID": "85768" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5253 +post_id: "83789" +post_author: 1 +"ListingKey": "1176290228" +"ListingId": "202612695" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-02T12:11:46Z" +"RFModificationTimestamp": "2026-08-02T12:15:58Z" +"ListPrice": 314000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 171278.0 +"LivingArea": 930.0 +"BuildingAreaTotal": 1140.0 +"City": "Honolulu" +"PostalCode": "96826" +"UnparsedAddress": "2333 Kapiolani Boulevard 1008a, Honolulu, Hawaii 96826" +"Coordinates": array:2 [ …2] +"Latitude": 21.304547 +"Longitude": -157.855676 +"YearBuilt": 1971 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ted Kawabata" +"ListOfficeName": "Keller Williams Honolulu" +"ListAgentMlsId": "47185" +"ListOfficeMlsId": "KWPP" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "HUGE $104,000 PRICE DROP... + RENOVATED!!! Rare corner unit in award-winning MARCO POLO with breathtaking sunrise, sunset, fireworks, ocean, Diamond Head, mountain, and city views, refreshing tradewinds, and a 210 sq. ft. wraparound covered lanai. Newly painted with updated plumbing in both showers, newer electrical subpanel, 2 full baths with triple-shower spa, whirlpool tub, 2 window A/C units, in-unit washer/dryer, custom finishes, 2 covered parking stalls (est. value $50K-$80K each), and 3 storage lockers. VA Approved. Resort-style amenities include pool, saunas, tennis, pickleball, basketball, volleyball, 6 BBQs, recreation deck, library, convenience store, car wash, surfboard/bike room, and 24-hour front desk & security. Major upgrades include new piping, fire sprinklers, and fire alarm systems. Near Waikiki, UH, hospitals, shopping, dining, parks, elementary school, military bases, and bus line. LH property, Fee available: $331,595 (included in list price) through 8/31, then $343,294. See also MLS #202612639" +"ArchitecturalStyle": "High Rise" +"AssociationFeeIncludes": "Common Areas,Sewer,Water" +"AssociationName": "Marco Polo AOAO" +"AttributionContact": "(808) 596-2888" +"BathroomsFull": 2 +"BuildingName": "Marco Polo Apts" +"CLIP": 4338784236 +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Deck/Porch,Patio,Pool,Recreation Area,Sauna,Storage Facilities,Tennis Court(s),Trails/Paths,Trash Chute" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-07-02T04:27:45.951246+00:00" +"DaysOnMarket": 33 +"DaysOnMarketReplication": 33 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 10 +"Fencing": "Fenced, Wall" +"Flooring": "Ceramic Tile,Laminate,Other" +"FrontageType": "Canal" +"Furnished": "Negotiable" +"GarageYN": true +"HumanModifiedYN": true +"Inclusions": "AC Window Unit,Auto Garage Door Opener,Blinds,Ceiling Fan,Disposal,Dryer,Microwave,Range/Oven,Refrigerator,Washer,Water Heater" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level,Storage,Single Living Level" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LeaseAmount": "419.0" +"LeaseExpiration": "2041-01-01" +"Levels": "One" +"ListAgentDirectPhone": "(808) 388-1393" +"ListAgentEmail": "ted@islandfamilyhomes.com" +"ListAgentKey": "10779825" +"ListAgentKeyNumeric": "10779825" +"ListAgentOfficePhone": "(808) 596-2888" +"ListAgentPreferredPhone": "(808) 388-1393" +"ListAgentStateLicense": "RS-79205" +"ListOfficeEmail": "frontdesk946@kw.com" +"ListOfficeKey": "2586166" +"ListOfficeKeyNumeric": "2586166" +"ListOfficePhone": "(808) 596-2888" +"ListingContractDate": "2026-06-30" +"ListingKeyNumeric": 1176290228 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1279.0 +"MajorChangeTimestamp": "2026-08-01T19:45:30Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-06-30" +"OriginalListPrice": 418000.0 +"OriginatingSystemKey": "19551883" +"ParcelNumber": "1-2-7-004-001-9981" +"ParkingFeatures": "Assigned,Covered,Garage,Guest,Two Spaces,On Street,Secured" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-08-02T06:30:01Z" +"PhotosCount": 25 +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry,Door Man,Fire Sprinkler System,Security Guard" +"SourceSystemKey": "1176290228" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kapiolani" +"StreetNumber": "2333" +"StreetNumberNumeric": "2333" +"StreetSuffix": "Boulevard" +"SubdivisionName": "KAPIOLANI" +"TaxAnnualAmount": "1680.0" +"TaxAssessedValue": 641500 +"TotalActualRent": 3000.0 +"UnitNumber": "1008-LH" +"View": "Canal, Mountain(s), Ocean, Sunset, Sunrise" +"ViewYN": true +"VirtualTourURLUnbranded": "https://grape-grouse-c76s.squarespace.com/2333-kapiolani-1008" +"ZoningDescription": "13 - A-3 High Density Apartment" +"ListAOR": "HI Central" +"LandTenure": "Lease Hold" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1176290228"\n } """ +"AssociationFeeTotal": 1279.0 +"TaxAssessedValueLand": "79600" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "561900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1176290228')" +"provider_name": "HICMLS" +"RecordSignature": -1330748783 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-7-004-001-9981" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "8991040" +"OriginatingSystemListAgentMemberKey": "10841541" +"Media": array:25 [ …25] +"ID": "83789" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5250 +post_id: "85068" +post_author: 1 +"ListingKey": "1178016551" +"ListingId": "202614218" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-02T12:01:23Z" +"RFModificationTimestamp": "2026-08-02T12:02:28Z" +"ListPrice": 1210000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 3742.0 +"LivingArea": 2298.0 +"BuildingAreaTotal": 2451.0 +"City": "Ewa Beach" +"PostalCode": "96706" +"UnparsedAddress": "91-837 Moneha Place, Ewa Beach, Hawaii 96706" +"Coordinates": array:2 [ …2] +"Latitude": 21.315603 +"Longitude": -158.008804 +"YearBuilt": 2019 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Marie CL Valenzuela" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "24913" +"ListOfficeMlsId": "CBPP15" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Built in 2019, this beautifully maintained home offers modern design, flexible living spaces, and energy-efficient features. The upper level features 3 bedrooms and 2 bathrooms, including a spacious primary suite with a walk-in closet. Enjoy an open-concept living area, covered lanai, and a well-appointed kitchen with dark cherry cabinetry, quartz countertops,& stainless-steel appliances. Central A/C serves the upper level for year-round comfort.\r\n The lower level includes 2 bedrooms, 1 bathroom, a living area, wet bar, stainless-steel appliances, & split A/C units. With separate entrances, the layout is ideal for multi-generational living or rental. \r\n Energy-saving features include a fully owned & FULLY PAID $98,000 Tesla photovoltaic (PV) system with 48 panels & solar water heater helps reduce monthly electricity costs. Additional highlights include laminate wood & ceramic tile flooring, rain gutters throughout. Conveniently located near beaches, shopping, dining, and everyday conveniences. First Open House August 2 from 2:00 - 5:00 pm """ +"AttributionContact": "(808) 676-7200" +"BathroomsFull": 3 +"CLIP": 6695349868 +"CommunityFeatures": "Deck/Porch,Patio,Storage Facilities" +"ConstructionMaterials": "Double Wall,Masonry,Stucco" +"CountyOrParish": "Oahu" +"CreationDate": "2026-07-24T21:34:30.753796+00:00" +"DaysOnMarket": 9 +"DaysOnMarketReplication": 9 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"Fencing": "Fenced, Wall" +"Flooring": "Ceramic Tile,Laminate" +"GarageYN": true +"HumanModifiedYN": true +"Inclusions": "AC Central,AC Split,Auto Garage Door Opener,Ceiling Fan,Chandelier,Dishwasher,Disposal,Drapes,Dryer,Microwave Hood,Photovoltaic - Owned,Range/Oven,Refrigerator,Smoke Detector,Solar Heater,Washer" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 676-7200" +"ListAgentEmail": "marie.valenzuela@cbrealty.com" +"ListAgentKey": "10767636" +"ListAgentKeyNumeric": "10767636" +"ListAgentOfficePhone": "(808) 676-7200" +"ListAgentPreferredPhone": "(808) 676-7200" +"ListAgentStateLicense": "RS-58879" +"ListOfficeEmail": "mike.james@cbrealty.com" +"ListOfficeKey": "2589359" +"ListOfficeKeyNumeric": "2589359" +"ListOfficePhone": "(808) 676-7200" +"ListingContractDate": "2026-07-24" +"ListingKeyNumeric": 1178016551 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Cul-De-Sac, Level" +"MLSAreaMajor": "Ewaplain" +"MajorChangeTimestamp": "2026-07-24T11:29:08Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-07-24" +"OriginalListPrice": 1210000.0 +"OriginatingSystemKey": "19595786" +"ParcelNumber": "1-9-1-008-013-0001" +"ParkingFeatures": "Driveway,Garage,Three or more Spaces,On Street" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-07-24T21:45:01Z" +"PhotosCount": 24 +"PoolFeatures": "None" +"PostalCity": "Ewa Beach" +"PropertyCondition": "Excellent,Good Condition" +"SourceSystemKey": "1178016551" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Moneha" +"StreetNumber": "91-837" +"StreetSuffix": "Place" +"SubdivisionName": "EWA BEACH" +"TaxAnnualAmount": "4908.0" +"TaxAssessedValue": 1038200 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,High Speed Internet Available,Other,Phone Available,Sewer Available,Water Available" +"View": "Garden" +"ViewYN": true +"WaterSource": "Public" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1178016551"\n } """ +"TaxAssessedValueLand": "585700" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "452500" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178016551')" +"provider_name": "HICMLS" +"RecordSignature": 1412140367 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-1-008-013-0001" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "12345774" +"OriginatingSystemListAgentMemberKey": "3475077" +"Media": array:24 [ …24] +"ID": "85068" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5245 +post_id: "80997" +post_author: 1 +"ListingKey": "1156405028" +"ListingId": "202606577" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-02T11:54:59Z" +"RFModificationTimestamp": "2026-08-02T11:57:51Z" +"ListPrice": 1563000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 3738.0 +"LivingArea": 2624.0 +"BuildingAreaTotal": 2793.0 +"City": "Honolulu" +"PostalCode": "96816" +"UnparsedAddress": "928 9th Avenue C, Honolulu, Hawaii 96816" +"Coordinates": array:2 [ …2] +"Latitude": 21.2802235 +"Longitude": -157.8048272 +"YearBuilt": 2022 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ellie Zeng" +"ListOfficeName": "HomeSmart Island Homes" +"ListAgentMlsId": "36324" +"ListOfficeMlsId": "HSIH" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Welcome to this beautiful designed home located in highly desirable Kaimuki with city and sunset view, very convenient to school, shops and eatery places. This 5/3 home have 3/2 upstairs with central AC and 2/1 downstairs, open floor plan which allows for Muti-generational living. Unit B with same exactly lay out (Mls no. 202605213) is also on the market for sale." +"AssociationFeeIncludes": "Common Areas,Sewer" +"AttributionContact": "(808) 729-7643" +"BathroomsFull": 3 +"CLIP": 1093131813 +"CommunityFeatures": "Other" +"ConstructionMaterials": "Double Wall,Masonry,Stucco,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-05-19T13:28:29.059767+00:00" +"DaysOnMarket": 84 +"DaysOnMarketReplication": 84 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,Familial Relation" +"ElementarySchool": "Liholiho" +"Flooring": "Ceramic Tile,Laminate" +"FrontageType": "Other" +"Furnished": "Partially" +"HighSchool": "Kalani" +"HumanModifiedYN": true +"Inclusions": "AC Central,Auto Garage Door Opener,Dishwasher,Disposal,Dryer,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Solar Heater,Washer" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 223-1442" +"ListAgentEmail": "zengellie@gmail.com" +"ListAgentKey": "10767991" +"ListAgentKeyNumeric": "10767991" +"ListAgentOfficePhone": "(808) 729-7643" +"ListAgentPreferredPhone": "(808) 223-1442" +"ListAgentStateLicense": "RS-69877" +"ListOfficeEmail": "tiffanysellshawaii@gmail.com" +"ListOfficeKey": "2974462" +"ListOfficeKeyNumeric": "2974462" +"ListOfficePhone": "(808) 729-7643" +"ListingContractDate": "2026-04-01" +"ListingKeyNumeric": 1156405028 +"ListingService": "Full Service" +"LotFeatures": "Corner Lot,Dead End,Interior Lot,Other" +"MLSAreaMajor": "Diamond Hd" +"MajorChangeTimestamp": "2026-08-02T01:54:23Z" +"MiddleOrJuniorSchool": "Kaimuki" +"MlsStatus": "Active" +"OnMarketDate": "2026-04-01" +"OriginalListPrice": 1598000.0 +"OriginatingSystemKey": "19362872" +"ParcelNumber": "1-3-2-017-021-0004" +"ParkingFeatures": "Three or more Spaces,On Street" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2026-05-19T13:24:00Z" +"PhotosCount": 17 +"PoolFeatures": "None" +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1156405028" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "9th" +"StreetNumber": "928" +"StreetNumberNumeric": "928" +"StreetSuffix": "Avenue" +"SubdivisionName": "KAIMUKI" +"TaxAnnualAmount": "11064.0" +"TaxAssessedValue": 1620200 +"Topography": "Other, Sloping" +"UnitNumber": "C" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,High Speed Internet Available,Sewer Available,Water Available" +"View": "City, Mountain(s), Sunset" +"ViewYN": true +"WaterSource": "Public" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1156405028"\n } """ +"TaxAssessedValueLand": "844100" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "776100" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1156405028')" +"provider_name": "HICMLS" +"RecordSignature": 1589546752 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-3-2-017-021-0004" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "13236725" +"OriginatingSystemListAgentMemberKey": "3480886" +"Media": array:17 [ …17] +"ID": "80997" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5256 +post_id: "85627" +post_author: 1 +"ListingKey": "1178559026" +"ListingId": "202614612" +"PropertyType": "Residential Lease" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-02T11:32:02Z" +"RFModificationTimestamp": "2026-08-02T11:35:53Z" +"ListPrice": 2800.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 70611.0 +"LivingArea": 540.0 +"BuildingAreaTotal": 600.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "411 Hobron Lane 2409, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.2864993 +"Longitude": -157.8365351 +"YearBuilt": 1974 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Brad K Hironaka" +"ListOfficeName": "HM Management LLC" +"ListAgentMlsId": "22756" +"ListOfficeMlsId": "HMPM" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Renovated Chateau Waikiki 1/1 INCLUDES ELECTRICITY, CENTRAL A/C, WATER, SEWER! Features newer cabinets and counters, flooring, and interior paint. Appliances include a range, microwave hood, refrigerator, disposal, and an in-unit washer/dryer and 1 reserved parking stall. Amazing skyline views, with Diamond Head and ocean views. Resident amenities include a large and renovated recreation deck with a swimming pool, gym, cardio machines, party room, cabanas with barbeque stations, and a community library. Renter's insurance is required, and no pets/smoking is allowed." +"Appliances": "Dryer,Electric Range,Disposal,Microwave Hood Fan,Oven,Range,Refrigerator,Washer" +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AvailabilityDate": "2026-08-03" +"BathroomsFull": 1 +"BuildingName": "Chateau Waikiki" +"CLIP": 2127004469 +"CommunityFeatures": "Barbecue,Conference/Meeting Room,Deck/Porch,Fitness,Patio,Property Manager On-Site,Pool,Recreation Area,Trash Chute" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2026-07-31T06:04:46.277207+00:00" +"DaysOnMarket": 3 +"DaysOnMarketReplication": 3 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "No Smoking,Renters Insurance Required" +"Flooring": "Carpet, Vinyl" +"FrontageType": "Other" +"Furnished": "Partially" +"HumanModifiedYN": true +"InteriorFeatures": "Bedroom on Main Level,Quartz Counters,Stainless Steel Appliances,Single Living Level" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 375-1752" +"ListAgentEmail": "brad@hmmanagement.net" +"ListAgentKey": "10772367" +"ListAgentKeyNumeric": "10772367" +"ListAgentOfficePhone": "(808) 200-0730" +"ListAgentPreferredPhone": "(808) 375-1752" +"ListAgentStateLicense": "RB-18914" +"ListOfficeEmail": "cristyn@hmmanagement.net" +"ListOfficeKey": "5145062" +"ListOfficeKeyNumeric": "5145062" +"ListOfficePhone": "(808) 200-0730" +"ListingContractDate": "2026-07-30" +"ListingKeyNumeric": 1178559026 +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2026-07-30T19:59:21Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-07-30" +"OpenParkingYN": true +"OriginalListPrice": 2800.0 +"OriginatingSystemKey": "19607520" +"ParcelNumber": "1-2-6-012-029-0246" +"ParkingFeatures": "Assigned,Guest,One Space,On Street" +"ParkingTotal": "1.0" +"PatioAndPorchFeatures": "Lanai" +"PetsAllowed": "No" +"PhotosChangeTimestamp": "2026-08-02T11:32:02Z" +"PhotosCount": 24 +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition,Updated/Remodeled" +"SecurityFeatures": "Elevator Secured,24 Hour Security,Smoke Detector(s),Security Guard" +"SourceSystemKey": "1178559026" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Hobron" +"StreetNumber": "411" +"StreetNumberNumeric": "411" +"StreetSuffix": "Lane" +"SubdivisionName": "WAIKIKI" +"TenantPays": "Application Fee" +"UnitNumber": "2409" +"Utilities": "Electricity Available,Sewer Available,Water Available" +"View": "City, Mountain(s), Ocean" +"ViewYN": true +"YearBuiltEffective": 2022 +"ListAOR": "HI Central" +"CustomFields": """ {\n "ListingKey": "1178559026"\n } """ +"Restrictions": "No Smoking" +"AvailabilityType": "Long Term" +"OriginatingSystemSubName": "HICMLS_HBR" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178559026')" +"provider_name": "HICMLS" +"RecordSignature": -955938728 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-012-029-0246" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "17065926" +"OriginatingSystemListAgentMemberKey": "3474456" +"Media": array:24 [ …24] +"ID": "85627" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5257 +post_id: "83790" +post_author: 1 +"ListingKey": "1176270666" +"ListingId": "202612639" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-02T11:32:02Z" +"RFModificationTimestamp": "2026-08-02T11:36:03Z" +"ListPrice": 631500.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 171278.0 +"LivingArea": 930.0 +"BuildingAreaTotal": 1140.0 +"City": "Honolulu" +"PostalCode": "96826" +"UnparsedAddress": "2333 Kapiolani Boulevard 1008, Honolulu, Hawaii 96826" +"Coordinates": array:2 [ …2] +"Latitude": 21.2873098 +"Longitude": -157.8278561 +"YearBuilt": 1971 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ted Kawabata" +"ListOfficeName": "Keller Williams Honolulu" +"ListAgentMlsId": "47185" +"ListOfficeMlsId": "KWPP" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "HUGE $119,000 PRICE DROP... + RENOVATED!!! Rare corner unit in award-winning MARCO POLO with breathtaking sunrise, sunset, fireworks, ocean, Diamond Head, mountain, and city views, refreshing tradewinds, and a 210 sq. ft. wraparound covered lanai. Newly painted with updated plumbing in both showers, newer electrical subpanel, 2 full baths with triple-shower spa, whirlpool tub, 2 window A/C units, in-unit washer/dryer, custom finishes, 2 covered parking stalls (est. value $50K-$80K each), and 3 storage lockers. VA Approved. Resort-style amenities include pool, saunas, tennis, pickleball, basketball, volleyball, 6 BBQs, recreation deck, library, convenience store, car wash, surfboard/bike room, and 24-hour front desk & security. Major upgrades include new piping, fire sprinklers, and fire alarm systems. Near Waikiki, UH, hospitals, shopping, dining, parks, elementary school, military bases, and bus line. LH property, Fee available: $331,595 (included in list price) through 8/31, then $343,294. See also MLS #202612695." +"ArchitecturalStyle": "High Rise" +"AssociationFeeIncludes": "Common Areas,Sewer,Water" +"AssociationName": "Marco Polo AOAO" +"AttributionContact": "(808) 596-2888" +"BathroomsFull": 2 +"BuildingName": "Marco Polo Apts" +"CLIP": 4338784236 +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Deck/Porch,Patio,Pool,Recreation Area,Sauna,Storage Facilities,Tennis Court(s),Trails/Paths,Trash Chute" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-07-01T07:31:08.597230+00:00" +"DaysOnMarket": 32 +"DaysOnMarketReplication": 32 +"DaysOnMarketReplicationDate": "2026-08-01" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 10 +"Fencing": "Fenced, Wall" +"Flooring": "Ceramic Tile,Laminate,Other" +"Furnished": "Negotiable" +"GarageYN": true +"HumanModifiedYN": true +"Inclusions": "AC Window Unit,Auto Garage Door Opener,Blinds,Ceiling Fan,Disposal,Dryer,Microwave,Range/Oven,Refrigerator,Washer,Water Heater" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level,Storage,Single Living Level" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 388-1393" +"ListAgentEmail": "ted@islandfamilyhomes.com" +"ListAgentKey": "10779825" +"ListAgentKeyNumeric": "10779825" +"ListAgentOfficePhone": "(808) 596-2888" +"ListAgentPreferredPhone": "(808) 388-1393" +"ListAgentStateLicense": "RS-79205" +"ListOfficeEmail": "frontdesk946@kw.com" +"ListOfficeKey": "2586166" +"ListOfficeKeyNumeric": "2586166" +"ListOfficePhone": "(808) 596-2888" +"ListingContractDate": "2026-06-30" +"ListingKeyNumeric": 1176270666 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1279.0 +"MajorChangeTimestamp": "2026-08-01T19:56:46Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-06-30" +"OriginalListPrice": 750000.0 +"OriginatingSystemKey": "19550254" +"ParcelNumber": "1-2-7-004-001-9980" +"ParkingFeatures": "Assigned,Covered,Garage,Guest,Two Spaces,On Street,Secured" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-08-02T11:32:02Z" +"PhotosCount": 18 +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry,Door Man,Fire Sprinkler System,Security Guard" +"SourceSystemKey": "1176270666" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kapiolani" +"StreetNumber": "2333" +"StreetNumberNumeric": "2333" +"StreetSuffix": "Boulevard" +"SubdivisionName": "KAPIOLANI" +"TaxAnnualAmount": "1680.0" +"TaxAssessedValue": 641500 +"TotalActualRent": 3000.0 +"UnitNumber": "1008-FS" +"View": "Canal, Mountain(s), Ocean, Sunset, Sunrise" +"ViewYN": true +"VirtualTourURLUnbranded": "https://grape-grouse-c76s.squarespace.com/2333-kapiolani-1008" +"ZoningDescription": "13 - A-3 High Density Apartment" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1176270666"\n } """ +"AssociationFeeTotal": 1279.0 +"TaxAssessedValueLand": "79600" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "561900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1176270666')" +"provider_name": "HICMLS" +"RecordSignature": 137473659 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-7-004-001-9980" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "8991040" +"OriginatingSystemListAgentMemberKey": "10841541" +"Media": array:18 [ …18] +"ID": "83790" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5258 +post_id: "83827" +post_author: 1 +"ListingKey": "1158535422" +"ListingId": "202608242" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-02T11:32:02Z" +"RFModificationTimestamp": "2026-08-02T11:35:43Z" +"ListPrice": 588000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 367.0 +"BuildingAreaTotal": 419.0 +"City": "Honolulu" +"PostalCode": "96814" +"UnparsedAddress": "987 Queen Street 3006, Honolulu, Hawaii 96814" +"Coordinates": array:2 [ …2] +"Latitude": 21.2964369 +"Longitude": -157.8534649 +"YearBuilt": 2019 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lindsey Itamoto" +"ListOfficeName": "Locations LLC" +"ListAgentMlsId": "42889" +"ListOfficeMlsId": "LOCA" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Start your day with golden sunrises and 30th floor ocean views from your Aalii smart home. Imagine being the first one to check the surf, from your bed! this preferred, rarely available "06 stack" is the closest tower studio to the ocean. this preferred Diamond Head/East facing apartment allows for natural, cool temperatures all day long! Come home to your thoughtfully decorated, Fully Furnished hotel-like suite complete with Bosch appliances. You're just a short elevator ride away from luxurious amenities such as 42nd floor Penthouse Sunset & Ocean facing Lounge Areas, Penthouse world class Gym, theatre/movie room, yoga Room, infinity Pool, Jacuzzi, Keiki Pool, Keiki Grassy Area & Playground, Dog run(Pet Friendly!), BBQ entertaining areas, & so much more! Aalii is located in the heart of Ward Village allowing close access to Whole Foods Market, Dining, Ward Village Community Park, Ala Moana Beach Park, Kewalo Basin/Harbor, Longs Drugstore and not far from Ala Moana Mall, Honolulu Airport and Foodland Farms. **Note: Maintenance fee includes master association (Ward Village) dues. **Note: unit is sub-metered, billed separately. Based on usage." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFee": "35.0" +"AssociationFeeIncludes": "Common Areas,Internet,Sewer,Water" +"AttributionContact": "(808) 735-4200" +"BathroomsFull": 1 +"BuildingName": "Aalii" +"CLIP": 2528026873 +"CommunityFeatures": "Barbecue,Clubhouse,Community Pool,Conference/Meeting Room,Deck/Porch,Fitness,Patio,Pool,Recreation Area,Restaurant,Trails/Paths,Trash Chute" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-06-25T00:35:25.723869+00:00" +"DaysOnMarket": 7 +"DaysOnMarketReplication": 7 +"DaysOnMarketReplicationDate": "2026-07-01" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Owner Is Listing Agent,Principal is Real Estate Licensed,Seller Disclosure,See Remarks" +"EntryLevel": 30 +"Flooring": "Ceramic Tile,Vinyl" +"Furnished": "Negotiable" +"GarageYN": true +"Inclusions": "AC Split,Auto Garage Door Opener,Book Shelves,Dishwasher,Disposal,Dryer,Kitchenware,Linens,Microwave Hood,Range/Oven,Refrigerator,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 927-0148" +"ListAgentEmail": "lindsey.itamoto@locationshawaii.com" +"ListAgentKey": "10773330" +"ListAgentKeyNumeric": "10773330" +"ListAgentOfficePhone": "(808) 735-4200" +"ListAgentPreferredPhone": "(808) 927-0148" +"ListAgentStateLicense": "RB-22332" +"ListOfficeEmail": "darryl.macha@locationshawaii.com" +"ListOfficeKey": "2586923" +"ListOfficeKeyNumeric": "2586923" +"ListOfficePhone": "(808) 735-4200" +"ListingContractDate": "2026-06-24" +"ListingKeyNumeric": 1158535422 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 556.0 +"MajorChangeTimestamp": "2026-06-24T14:33:06Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-06-24" +"OpenParkingYN": true +"OriginalListPrice": 588000.0 +"OriginatingSystemKey": "19413161" +"ParcelNumber": "1-2-3-002-107-0542" +"ParkingFeatures": "Assigned,Garage,Guest,One Space,Secured" +"ParkingTotal": "1.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-08-02T11:32:02Z" +"PhotosCount": 12 +"PoolFeatures": "Heated" +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Fire Sprinkler System,Security Guard" +"SourceSystemKey": "1158535422" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Queen" +"StreetNumber": "987" +"StreetNumberNumeric": "987" +"StreetSuffix": "Street" +"SubdivisionName": "KAKAAKO" +"TaxAnnualAmount": "1692.0" +"TaxAssessedValue": 560600 +"TotalActualRent": 2800.0 +"UnitNumber": "3006" +"View": "Coastline,City,Golf Course,Garden,Mountain(s),Ocean,Sunrise" +"ViewYN": true +"ZoningDescription": "Kak – Kakaako Community Development Project" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1158535422"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 591.0 +"TaxAssessedValueLand": "17900" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "542700" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1158535422')" +"provider_name": "HICMLS" +"RecordSignature": 646461758 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-002-107-0542" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485305" +"OriginatingSystemListAgentMemberKey": "3483194" +"Media": array:12 [ …12] +"ID": "83827" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5259 +post_id: "85767" +post_author: 1 +"ListingKey": "1174566353" +"ListingId": "202611538" +"PropertyType": "Residential Lease" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-02T10:51:01Z" +"RFModificationTimestamp": "2026-08-02T10:52:40Z" +"ListPrice": 3650.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 42123.0 +"LivingArea": 1000.0 +"BuildingAreaTotal": 1120.0 +"City": "Haleiwa" +"PostalCode": "96712" +"UnparsedAddress": "66-081 Wana Place, Haleiwa, Hawaii 96712" +"Coordinates": array:2 [ …2] +"Latitude": 21.5876272 +"Longitude": -158.1035648 +"YearBuilt": 1947 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Harris T Zane" +"ListOfficeName": "Urban Real Estate Co." +"ListAgentMlsId": "21448" +"ListOfficeMlsId": "URBA" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Beautiful 2/1 house with 2 open parking stalls. Covered lanai with laundry and space for small dining set. New kitchen, bath, window ac units in all rooms. Good credit history a must (no delinquent accounts and make monthly payments). Yard service included. Renters insurance required. Call or text Harris to see (808)351-2731." +"Appliances": "Oven, Range, Refrigerator" +"ArchitecturalStyle": "Multiplex" +"AttributionContact": "(808) 524-2731" +"AvailabilityDate": "2026-07-01" +"BathroomsFull": 1 +"CLIP": 1040950850 +"CarportYN": true +"Cooling": "Window Unit(s)" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2026-08-02T10:52:33.464444+00:00" +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "No Smoking,Principal is Real Estate Licensed,Pet on Property" +"Flooring": "Vinyl" +"FrontageType": "Other" +"Furnished": "Partially" +"HumanModifiedYN": true +"InteriorFeatures": "Ceiling Fan(s),Kitchen Exhaust Fan" +"RFTransactionType": "For Rent" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 524-2731" +"ListAgentEmail": "hzane@urban-hi.com" +"ListAgentKey": "10761647" +"ListAgentKeyNumeric": "10761647" +"ListAgentOfficePhone": "(808) 524-2731" +"ListAgentPreferredPhone": "(808) 524-2731" +"ListAgentStateLicense": "RB-17695" +"ListOfficeKey": "2586714" +"ListOfficeKeyNumeric": "2586714" +"ListOfficePhone": "(808) 524-2731" +"ListingContractDate": "2026-08-02" +"ListingKeyNumeric": 1174566353 +"MLSAreaMajor": "North Shore" +"MajorChangeTimestamp": "2026-08-02T00:49:45Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-08-02" +"OriginalListPrice": 3650.0 +"OriginatingSystemKey": "19518543" +"ParcelNumber": "1-6-6-014-019-0000" +"ParkingFeatures": "Covered,Carport,Two Spaces" +"ParkingTotal": "2.0" +"PetsAllowed": "Birds OK,Cats OK,Dogs OK,Negotiable,Size Limit,Yes" +"PhotosChangeTimestamp": "2026-08-02T10:51:01Z" +"PhotosCount": 11 +"PostalCity": "Haleiwa" +"PropertyCondition": "Excellent" +"SourceSystemKey": "1174566353" +"StateOrProvince": "HI" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Wana" +"StreetNumber": "66-081" +"StreetSuffix": "Place" +"SubdivisionName": "WAIALUA" +"TenantPays": "Application Fee" +"Utilities": "Water Available,Yard Maintenance" +"View": "Other" +"ViewYN": true +"ZoningDescription": "56 - Country District" +"ListAOR": "HI Central" +"CustomFields": """ {\n "ListingKey": "1174566353"\n } """ +"Restrictions": "No Smoking" +"AvailabilityType": "Long Term" +"OriginatingSystemSubName": "HICMLS_HBR" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1174566353')" +"provider_name": "HICMLS" +"short_address": "Haleiwa, Hawaii 96712, USA" +"RecordSignature": -1909207001 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-6-6-014-019-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485096" +"OriginatingSystemListAgentMemberKey": "8834406" +"Media": array:11 [ …11] +"DaysOnMarket": 0 +"ID": "85767" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5260 +post_id: "84166" +post_author: 1 +"ListingKey": "1173438556" +"ListingId": "202611068" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-02T10:30:22Z" +"RFModificationTimestamp": "2026-08-02T10:35:17Z" +"ListPrice": 309000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 484.0 +"BuildingAreaTotal": 484.0 +"City": "Honolulu" +"PostalCode": "96814" +"UnparsedAddress": "1655 Makaloa Street 903, Honolulu, Hawaii 96814" +"Coordinates": array:2 [ …2] +"Latitude": 21.2922906 +"Longitude": -157.8378897 +"YearBuilt": 1970 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Taehee Lee" +"ListOfficeName": "INCUBE ASSET LLC" +"ListAgentMlsId": "52727" +"ListOfficeMlsId": "CHUS" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "PRICE REDUCED!! Renovated in 2022 with updated kitchen cabinets and countertops, laminate flooring, two ceiling fans, bathroom vanity and countertops, glass shower enclosure, fresh paint, and plumbing upgrades. This move-in ready unit offers a functional layout with abundant natural light and cool tradewind breezes. Conveniently located in the heart of Honolulu, just minutes from Ala Moana, Waikiki, shopping, dining, beaches, and major bus routes. Kapiolani Manor is a secured building with resident manager, community laundry, and covered parking. An excellent opportunity for first-time homebuyers, investors, or those seeking the convenience of urban island living." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Cable TV,Electricity,Internet,Sewer,Water" +"AttributionContact": "(808) 687-1074" +"BathroomsFull": 1 +"BuildingName": "Kapiolani Manor" +"CLIP": 2966936184 +"CommunityFeatures": "Community Pool,Deck/Porch,Laundry Facilities,Patio,Storage Facilities,Trash Chute" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-06-17T07:03:13.283085+00:00" +"DaysOnMarket": 55 +"DaysOnMarketReplication": 55 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"EntryLevel": 9 +"Flooring": "Laminate" +"Furnished": "Unfurnished" +"Inclusions": "Auto Garage Door Opener,Cable TV,Ceiling Fan,Dishwasher,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Water Heater" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 859-5116" +"ListAgentEmail": "taeheelee93@gmail.com" +"ListAgentKey": "21385582" +"ListAgentKeyNumeric": "21385582" +"ListAgentOfficePhone": "(808) 687-1074" +"ListAgentPreferredPhone": "(808) 859-5116" +"ListAgentStateLicense": "RS-85641" +"ListOfficeEmail": "incubeasset@gmail.com" +"ListOfficeKey": "4107643" +"ListOfficeKeyNumeric": "4107643" +"ListOfficePhone": "(808) 687-1074" +"ListingContractDate": "2026-06-08" +"ListingKeyNumeric": 1173438556 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 905.0 +"MajorChangeTimestamp": "2026-07-19T17:32:43Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-06-08" +"OriginalListPrice": 330000.0 +"OriginatingSystemKey": "19504568" +"ParcelNumber": "1-2-3-022-052-0093" +"ParkingFeatures": "Assigned,Covered,One Space" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-06-15T03:39:01Z" +"PhotosCount": 9 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Security Guard" +"SourceSystemKey": "1173438556" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Makaloa" +"StreetNumber": "1655" +"StreetNumberNumeric": "1655" +"StreetSuffix": "Street" +"SubdivisionName": "ALA MOANA" +"TaxAnnualAmount": "804.0" +"TaxAssessedValue": 313800 +"UnitNumber": "903" +"View": "City, Mountain(s)" +"ViewYN": true +"ZoningDescription": "33 - BMX-3 Community Business M" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1173438556"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 905.0 +"TaxAssessedValueLand": "31600" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "282200" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1173438556')" +"provider_name": "HICMLS" +"RecordSignature": 454859270 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-022-052-0093" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15793246" +"OriginatingSystemListAgentMemberKey": "16892417" +"Media": array:9 [ …9] +"ID": "84166" } 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5261 +post_id: "82220" +post_author: 1 +"ListingKey": "1157811904" +"ListingId": "202607695" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-02T10:30:22Z" +"RFModificationTimestamp": "2026-08-02T10:35:07Z" +"ListPrice": 380000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 69522.0 +"LivingArea": 677.0 +"BuildingAreaTotal": 677.0 +"City": "Honolulu" +"PostalCode": "96818" +"UnparsedAddress": "5180 Likini Street 703, Honolulu, Hawaii 96818" +"Coordinates": array:2 [ …2] +"Latitude": 21.3458813 +"Longitude": -157.9096227 +"YearBuilt": 1972 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Taehee Lee" +"ListOfficeName": "INCUBE ASSET LLC" +"ListAgentMlsId": "52727" +"ListOfficeMlsId": "CHUS" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ HUGE PRICE REDUCTION! Don’t miss this incredible opportunity to own a spacious and thoughtfully updated 2-bedroom, 1-bathroom condo in the highly sought-after Royal Towers. This well-maintained unit offers a peaceful and inviting living environment. For added comfort and convenience, the unit includes a window AC unit and a dedicated in-unit water shut-off valve, providing easy control and peace of mind. Exceptionally well cared for, this home is clean and move-in ready. The low maintenance fee covers electricity, hot water, water, sewer, and other common expenses, making it a practical and cost-efficient choice.\r\n \r\n Royal Towers offers excellent amenities, including a swimming pool, recreation room, BBQ area, guest parking, and an on-site resident manager. Ideally located near Salt Lake Shopping Center, the airport, and freeway access, this property offers both comfort and convenience. A great opportunity for homeowners and investors alike! """ +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Electricity,Hot Water,Maintenance Grounds,Maintenance Structure,Sewer,Water" +"AttributionContact": "(808) 687-1074" +"BathroomsFull": 1 +"BuildingName": "Royal Towers" +"CLIP": 2727221197 +"CommunityFeatures": "Barbecue,Community Pool,Laundry Facilities,Recreation Area,Trash Chute" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-04-17T21:01:18.585672+00:00" +"DaysOnMarket": 93 +"DaysOnMarketReplication": 93 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"EntryLevel": 7 +"Flooring": "Vinyl" +"Inclusions": "AC Window Unit,Ceiling Fan,Disposal,Microwave Hood,Range/Oven,Refrigerator,Smoke Detector" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 859-5116" +"ListAgentEmail": "taeheelee93@gmail.com" +"ListAgentKey": "21385582" +"ListAgentKeyNumeric": "21385582" +"ListAgentOfficePhone": "(808) 687-1074" +"ListAgentPreferredPhone": "(808) 859-5116" +"ListAgentStateLicense": "RS-85641" +"ListOfficeEmail": "incubeasset@gmail.com" +"ListOfficeKey": "4107643" +"ListOfficeKeyNumeric": "4107643" +"ListOfficePhone": "(808) 687-1074" +"ListingContractDate": "2026-04-17" +"ListingKeyNumeric": 1157811904 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 818.61 +"MajorChangeTimestamp": "2026-07-13T00:52:17Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-04-17" +"OpenParkingYN": true +"OriginalListPrice": 400000.0 +"OriginatingSystemKey": "19393593" +"ParcelNumber": "1-1-1-058-009-0037" +"ParkingFeatures": "Assigned,Guest,One Space,Secured" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-04-25T18:08:06Z" +"PhotosCount": 8 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent" +"SourceSystemKey": "1157811904" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Likini" +"StreetNumber": "5180" +"StreetNumberNumeric": "5180" +"StreetSuffix": "Street" +"SubdivisionName": "SALT LAKE" +"TaxAnnualAmount": "1552.92" +"TaxAssessedValue": 346500 +"UnitNumber": "703" +"View": "Mountain(s)" +"ViewYN": true +"ZoningDescription": "11 - A-1 Low Density Apartment" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1157811904"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 819.0 +"TaxAssessedValueLand": "76300" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "270200" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1157811904')" +"provider_name": "HICMLS" +"RecordSignature": -164722316 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-1-058-009-0037" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15793246" +"OriginatingSystemListAgentMemberKey": "16892417" +"Media": array:8 [ …8] +"ID": "82220" } 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5262 +post_id: "85763" +post_author: 1 +"ListingKey": "1178309436" +"ListingId": "202614369" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-02T10:16:01Z" +"RFModificationTimestamp": "2026-08-02T10:18:29Z" +"ListPrice": 1088888.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 3271.0 +"LivingArea": 1430.0 +"BuildingAreaTotal": 1430.0 +"City": "Waipahu" +"PostalCode": "96797" +"UnparsedAddress": "94-202 Loku Place 114, Waipahu, Hawaii 96797" +"Coordinates": array:2 [ …2] +"Latitude": 21.3866667 +"Longitude": -158.009166 +"YearBuilt": 1998 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sofi Virabyan" +"ListOfficeName": "List Sotheby's Int'l Realty" +"ListAgentMlsId": "50489" +"ListOfficeMlsId": "LIST03" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Positioned on a cul-de-sac within the Tropics at Waikele, this extensively upgraded 4-bedroom, 2.5-bath detached residence offers a refined blend of modern design, energy efficiency, and everyday functionality. Since 2023, the sellers have invested more than $80,000 in improvements, including a renovated kitchen with updated cabinetry, finishes, and smart appliances; renovated bathrooms; a custom media wall; and expansive concrete hardscaping for a streamlined, low-maintenance exterior. Smart features have been thoughtfully incorporated throughout the home, creating a connected and convenient living experience. Energy-conscious enhancements include an additional Tesla Powerwall, owned photovoltaic panels, battery storage, and a 240V electric-vehicle charger. Additional features include a newer roof, multiple air-conditioning systems, a heat-pump water heater, attic solar fan, Google Nest smoke and carbon-monoxide detectors, and a fully fenced yard. Conveniently located near shopping, dining, Waikele Premium Outlets, and H-1 access." +"ArchitecturalStyle": "Detached" +"AssociationFee": "65.0" +"AssociationName": "Tropics Waikele AOAO" +"AttributionContact": "(808) 439-8510" +"BathroomsFull": 2 +"CLIP": 2133540116 +"CommunityFeatures": "Deck/Porch,Patio" +"ConstructionMaterials": "Double Wall" +"CountyOrParish": "Oahu" +"CreationDate": "2026-08-02T08:51:05.746586+00:00" +"DaysOnMarketReplicationDate": "2026-08-01" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Pet on Property,Seller Disclosure" +"ExteriorFeatures": "Landscaping" +"Fencing": "Fenced, Wall" +"Flooring": "Carpet,Ceramic Tile,Other,Vinyl" +"Furnished": "Unfurnished" +"GarageYN": true +"HumanModifiedYN": true +"Inclusions": "AC Split,Auto Garage Door Opener,Blinds,Ceiling Fan,Chandelier,Dishwasher,Disposal,Dryer,Microwave,Photovoltaic - Owned,Range/Oven,Refrigerator,Smoke Detector,Solar Heater,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 253-9175" +"ListAgentEmail": "sofivhawaiirealtor@gmail.com" +"ListAgentKey": "16556092" +"ListAgentKeyNumeric": "16556092" +"ListAgentOfficePhone": "(808) 439-8510" +"ListAgentPreferredPhone": "(808) 253-9175" +"ListAgentStateLicense": "RS-82835" +"ListOfficeEmail": "info@listsir.com" +"ListOfficeKey": "2589197" +"ListOfficeKeyNumeric": "2589197" +"ListOfficePhone": "(808) 439-8510" +"ListingContractDate": "2026-08-01" +"ListingKeyNumeric": 1178309436 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Cul-De-Sac, Level" +"MLSAreaMajor": "Waipahu" +"MaintenanceExpense": 320.0 +"MajorChangeTimestamp": "2026-08-01T22:50:19Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-08-01" +"OriginalListPrice": 1088888.0 +"OriginatingSystemKey": "19600293" +"ParcelNumber": "1-9-4-007-088-0008" +"ParkingFeatures": "Garage,On Street" +"ParkingTotal": "2.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-08-02T10:16:01Z" +"PhotosCount": 21 +"PoolFeatures": "None" +"PostalCity": "Waipahu" +"PropertyCondition": "Excellent,Good Condition" +"RoadFrontageType": "Private Road" +"SourceSystemKey": "1178309436" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Loku" +"StreetNumber": "94-202" +"StreetSuffix": "Place" +"SubdivisionName": "WAIKELE" +"TaxAnnualAmount": "300.0" +"TaxAssessedValue": 892500 +"Topography": "Level" +"UnitNumber": "114" +"Utilities": "Cable Available,High Speed Internet Available" +"View": "Sunset, Sunrise" +"ViewYN": true +"YearBuiltEffective": 2025 +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1178309436"\n } """ +"AssociationFeeTotal": 385.0 +"TaxAssessedValueLand": "619700" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "272800" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178309436')" +"provider_name": "HICMLS" +"RecordSignature": 1812047089 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-4-007-088-0008" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10234197" +"OriginatingSystemListAgentMemberKey": "15264314" +"Media": array:21 [ …21] +"DaysOnMarket": 0 +"ID": "85763" } 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5263 +post_id: "85764" +post_author: 1 +"ListingKey": "1174072663" +"ListingId": "202611314" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-02T08:45:26Z" +"RFModificationTimestamp": "2026-08-02T08:46:32Z" +"ListPrice": 194900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 7492.0 +"LivingArea": 185.0 +"BuildingAreaTotal": 236.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "2509 Ala Wai Boulevard 902, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.2767163 +"Longitude": -157.8205126 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Chad Snater" +"ListOfficeName": "Talk Realty LLC" +"ListAgentMlsId": "48486" +"ListOfficeMlsId": "TALK" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ One of the best values in Waikiki! This completely remodeled Fee Simple studio offers an affordable opportunity to own a move-in ready property in the heart of paradise. Enjoy views of the Ala Wai Canal, Ala Wai Golf Course, mountains, and city lights from your private 51 sqft lanai. The renovated interior features modern finishes and an efficient layout that maximizes every square foot.\r\n \r\n Low monthly maintenance fee of just $496.43 includes electricity, water, hot water, and sewer. Pacific International features an updated community laundry room, resident manager, bicycle storage, waitlisted storage units, and waitlisted parking available through building management.\r\n \r\n Ideally located in the heart of Waikiki just blocks from Kuhio Beach, the Duke Kahanamoku Statue, Honolulu Zoo, Waikiki Aquarium, International Market Place, Target, and Waikiki Market. Enjoy shopping, dining, nightlife, beaches, and entertainment right outside your front door. Perfect as a primary residence, island getaway, or investment property. Don’t miss this opportunity to own one of Waikiki’s most affordable fully renovated Fee Simple condos. """ +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Electricity,Hot Water,None,Sewer,Water" +"BathroomsFull": 1 +"BuildingName": "Pacific International" +"CLIP": 8167057310 +"CommunityFeatures": "Laundry Facilities,Gated" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-06-10T21:48:29.096303+00:00" +"DaysOnMarket": 53 +"DaysOnMarketReplication": 53 +"DaysOnMarketReplicationDate": "2026-08-01" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Jefferson" +"EntryLevel": 9 +"Flooring": "Laminate" +"FrontageType": "Other" +"Furnished": "Unfurnished" +"HighSchool": "Kaimuki" +"Inclusions": "AC Window Unit,Cable TV,Ceiling Fan,Disposal,Drapes,Microwave Hood,Other,Refrigerator,Smoke Detector" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 892-9011" +"ListAgentEmail": "chad@talkrealty.co" +"ListAgentKey": "10780878" +"ListAgentKeyNumeric": "10780878" +"ListAgentOfficePhone": "(808) 427-4356" +"ListAgentPreferredPhone": "(808) 892-9011" +"ListAgentStateLicense": "RB-23947" +"ListOfficeEmail": "hi.broker@talkrealty.co" +"ListOfficeKey": "5806831" +"ListOfficeKeyNumeric": "5806831" +"ListOfficePhone": "(808) 427-4356" +"ListingContractDate": "2026-06-09" +"ListingKeyNumeric": 1174072663 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 496.43 +"MajorChangeTimestamp": "2026-06-10T11:27:12Z" +"MiddleOrJuniorSchool": "Washington" +"MlsStatus": "Active" +"OnMarketDate": "2026-06-09" +"OriginalListPrice": 194900.0 +"OriginatingSystemKey": "19511310" +"ParcelNumber": "1-2-6-025-040-0044" +"ParkingFeatures": "Assigned" +"PhotosChangeTimestamp": "2026-06-10T22:08:01Z" +"PhotosCount": 23 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Updated/Remodeled" +"SecurityFeatures": "Closed Circuit Camera(s),Gated Community,Key Card Entry" +"SourceSystemKey": "1174072663" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Ala Wai" +"StreetNumber": "2509" +"StreetNumberNumeric": "2509" +"StreetSuffix": "Boulevard" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "630.36" +"TaxAssessedValue": 160300 +"UnitNumber": "902" +"View": "Canal,City,Golf Course,Mountain(s),Ocean,Sunrise" +"ViewYN": true +"YearBuiltEffective": 2026 +"ZoningDescription": "X2 - Apartment Precinct" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1174072663"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 496.0 +"TaxAssessedValueLand": "32000" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "128300" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1174072663')" +"provider_name": "HICMLS" +"RecordSignature": 1992295784 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-025-040-0044" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "18556936" +"OriginatingSystemListAgentMemberKey": "12678350" +"Media": array:23 [ …23] +"ID": "85764" } 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5264 +post_id: "85754" +post_author: 1 +"ListingKey": "1178620688" +"ListingId": "202614673" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-02T08:45:26Z" +"RFModificationTimestamp": "2026-08-02T08:46:32Z" +"ListPrice": 945000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 5700.0 +"LivingArea": 960.0 +"BuildingAreaTotal": 960.0 +"City": "Aiea" +"PostalCode": "96701" +"UnparsedAddress": "99-1170 Halawa Hts Road, Aiea, Hawaii 96701" +"Coordinates": array:2 [ …2] +"Latitude": 21.3822222 +"Longitude": -157.9336111 +"YearBuilt": 1955 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sean K Kurashige" +"ListOfficeName": "HI Roots Realty LLC" +"ListAgentMlsId": "53716" +"ListOfficeMlsId": "ROOT" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Positioned in one of O'ahu’s most connected locations, this move-in-ready three-bedroom detached home pairs an efficient single-level interior with a 5,700-square-foot lot, fenced yard, and garage parking. Large windows fill the open living, dining, and kitchen areas with natural light, helping the home feel larger than its 960-square-foot footprint.\r\n \r\n Improvements include a new roof installed in June 2026, Hardie Plank siding, laminate flooring, granite countertops, updated bath finishes, vinyl windows, recessed lighting, ceiling fans, window air conditioning, and fresh interior paint.\r\n \r\n Outside, lawn areas offer room to garden, entertain, or relax, while the covered utility area adds everyday function. Tucked along a residential lane just off Halawa Heights Road, the home offers convenient access to H-1, H-3, and Moanalua Freeway, connecting Honolulu, Windward, Central, and West O'ahu. Camp Smith, Joint Base Pearl Harbor-Hickam, Tripler, the airport, Pearlridge, Pali Momi, and the operational Halawa/Aloha Stadium Skyline station are within easy reach.\r\n \r\n A compelling opportunity to own an updated detached home with land in a truly central O'ahu location. """ +"ArchitecturalStyle": "Detached" +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 292-8071" +"BathroomsFull": 1 +"CLIP": 6384042019 +"CoListAgentDirectPhone": "(808) 292-8071" +"CoListAgentEmail": "peter@hirootsrealty.com" +"CoListAgentFullName": "Peter Enomoto-Hahn" +"CoListAgentKey": "10773186" +"CoListAgentKeyNumeric": "10773186" +"CoListAgentMlsId": "40273" +"CoListAgentPreferredPhone": "(808) 292-8071" +"CoListOfficeEmail": "petereh@hirootsrealty.com" +"CoListOfficeKey": "2589322" +"CoListOfficeKeyNumeric": "2589322" +"CoListOfficeMlsId": "ROOT" +"CoListOfficeName": "HI Roots Realty LLC" +"CoListOfficePhone": "(808) 292-8071" +"CommunityFeatures": "None" +"ConstructionMaterials": "Single Wall" +"CountyOrParish": "Oahu" +"CreationDate": "2026-08-02T00:53:23.173820+00:00" +"DaysOnMarketReplicationDate": "2026-08-01" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Aiea" +"Flooring": "Laminate" +"FrontageType": "Other" +"Furnished": "Partially" +"GarageYN": true +"HighSchool": "Aiea" +"Inclusions": "AC Window Unit,Auto Garage Door Opener,Ceiling Fan,Disposal,Dryer,Microwave,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 292-8071" +"ListAgentEmail": "seank@hirootsrealty.com" +"ListAgentKey": "22874535" +"ListAgentKeyNumeric": "22874535" +"ListAgentOfficePhone": "(808) 292-8071" +"ListAgentPreferredPhone": "(808) 292-8071" +"ListAgentStateLicense": "RS-86877" +"ListOfficeEmail": "petereh@hirootsrealty.com" +"ListOfficeKey": "2589322" +"ListOfficeKeyNumeric": "2589322" +"ListOfficePhone": "(808) 292-8071" +"ListingContractDate": "2026-08-01" +"ListingKeyNumeric": 1178620688 +"ListingService": "Full Service" +"LotFeatures": "Dead End,Other,Level" +"MLSAreaMajor": "Pearl City" +"MajorChangeTimestamp": "2026-08-01T14:48:56Z" +"MiddleOrJuniorSchool": "Aiea" +"MlsStatus": "Active" +"OnMarketDate": "2026-08-01" +"OriginalListPrice": 945000.0 +"OriginatingSystemKey": "19609532" +"ParcelNumber": "1-9-9-009-086-0000" +"ParkingFeatures": "Driveway, Garage" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-08-02T01:16:06Z" +"PhotosCount": 14 +"PoolFeatures": "None" +"PostalCity": "Aiea" +"PropertyCondition": "Average Condition,Good Condition,Updated/Remodeled" +"RoadFrontageType": "Private Road" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1178620688" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Halawa Hts" +"StreetNumber": "99-1170" +"StreetSuffix": "Road" +"SubdivisionName": "HALAWA HEIGHTS" +"TaxAnnualAmount": "2736.0" +"TaxAssessedValue": 779500 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,High Speed Internet Available,Phone Available,Sewer Available,Water Available" +"View": "Mountain(s)" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltEffective": 2016 +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1178620688"\n } """ +"HumanModifiedYN": false +"TaxAssessedValueLand": "762000" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "17500" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178620688')" +"provider_name": "HICMLS" +"RecordSignature": -582680713 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-9-009-086-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "11042945" +"OriginatingSystemCoListOfficeKey": "11042945" +"OriginatingSystemListAgentMemberKey": "17743755" +"OriginatingSystemCoListAgentMemberKey": "3482267" +"Media": array:14 [ …14] +"DaysOnMarket": 0 +"ID": "85754" } 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5265 +post_id: "85765" +post_author: 1 +"ListingKey": "1178739122" +"ListingId": "202614780" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-02T08:43:48Z" +"RFModificationTimestamp": "2026-08-02T08:46:32Z" +"ListPrice": 950000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 3425.0 +"LivingArea": 1086.0 +"BuildingAreaTotal": 1086.0 +"City": "Honolulu" +"PostalCode": "96816" +"UnparsedAddress": "729-a 6th Avenue A, Honolulu, Hawaii 96816" +"Coordinates": array:2 [ …2] +"Latitude": 21.2873038 +"Longitude": -157.8051437 +"YearBuilt": 1963 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Elaine F Iwamasa" +"ListOfficeName": "All Realty Company" +"ListAgentMlsId": "12527" +"ListOfficeMlsId": "ARCO" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Highly coveted location. Near bus stops, schools, UH, Waikiki, zoo, aquarium, shopping centers & other areas. Fenced for privacy. Selling "As Is"; please include As Is Addendum. House is in tear-down condition, value is in land.Appliances not part of this sale, too old.Delete J-7 (existing warranties), M-1 (no condo docs available), N-2 (not a rental)." +"ArchitecturalStyle": "Detached" +"AssociationFeeIncludes": "Sewer" +"AttributionContact": "(808) 247-0049" +"BathroomsFull": 1 +"CLIP": 2712664308 +"CarportYN": true +"CoListAgentDirectPhone": "(808) 348-1840" +"CoListAgentEmail": "alvink8@gmail.com" +"CoListAgentFullName": "Alvin A Kazunaga" +"CoListAgentKey": "10777100" +"CoListAgentKeyNumeric": "10777100" +"CoListAgentMlsId": "01496" +"CoListAgentPreferredPhone": "(808) 348-1840" +"CoListOfficeEmail": "arco86el@gmail.com" +"CoListOfficeKey": "2587244" +"CoListOfficeKeyNumeric": "2587244" +"CoListOfficeMlsId": "ARCO" +"CoListOfficeName": "All Realty Company" +"CoListOfficePhone": "(808) 247-0049" +"CommunityFeatures": "Deck/Porch,Patio" +"ConstructionMaterials": "Single Wall,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-08-02T08:28:25.233290+00:00" +"DaysOnMarketReplicationDate": "2026-08-01" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,Familial Relation,Seller Disclosure" +"ElementarySchool": "Liholiho" +"Flooring": "Hardwood" +"FrontageType": "Other" +"GarageSpaces": "2.0" +"GarageYN": true +"HighSchool": "Kaimuki" +"HumanModifiedYN": true +"Inclusions": "None" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 554-8714" +"ListAgentEmail": "allrealtyco@gmail.com" +"ListAgentKey": "10778655" +"ListAgentKeyNumeric": "10778655" +"ListAgentOfficePhone": "(808) 247-0049" +"ListAgentPreferredPhone": "(808) 554-8714" +"ListAgentStateLicense": "RB-15618" +"ListOfficeEmail": "arco86el@gmail.com" +"ListOfficeKey": "2587244" +"ListOfficeKeyNumeric": "2587244" +"ListOfficePhone": "(808) 247-0049" +"ListingContractDate": "2026-08-01" +"ListingKeyNumeric": 1178739122 +"ListingService": "Full Service" +"LotFeatures": "Flag Lot,Other" +"MLSAreaMajor": "Diamond Hd" +"MajorChangeTimestamp": "2026-08-01T22:27:00Z" +"MiddleOrJuniorSchool": "Kaimuki" +"MlsStatus": "Active" +"OnMarketDate": "2026-08-01" +"OriginalListPrice": 950000.0 +"OriginatingSystemKey": "19613146" +"ParcelNumber": "1-3-2-023-036-0002" +"ParkingFeatures": "Carport,Driveway,Two Car Garage,Two Spaces" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-08-02T08:20:01Z" +"PhotosCount": 1 +"PoolFeatures": "None" +"PostalCity": "Honolulu" +"PropertyCondition": "Tear Down / Value in Land" +"RoadFrontageType": "County Road" +"SourceSystemKey": "1178739122" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "6th" +"StreetNumber": "729-A" +"StreetSuffix": "Avenue" +"SubdivisionName": "KAIMUKI" +"TaxAnnualAmount": "10068.0" +"TaxAssessedValue": 1046900 +"Topography": "Sloping" +"UnitNumber": "A" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,High Speed Internet Available,Phone Available,Water Available" +"View": "None" +"WaterSource": "Public" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1178739122"\n } """ +"TaxAssessedValueLand": "758300" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "288600" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178739122')" +"provider_name": "HICMLS" +"RecordSignature": 6497623 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-3-2-023-036-0002" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485626" +"OriginatingSystemCoListOfficeKey": "3485626" +"OriginatingSystemListAgentMemberKey": "8842801" +"OriginatingSystemCoListAgentMemberKey": "3472032" +"Media": array:1 [ …1] +"DaysOnMarket": 0 +"ID": "85765" } 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5266 +post_id: "80900" +post_author: 1 +"ListingKey": "1156406655" +"ListingId": "202606584" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-02T08:22:31Z" +"RFModificationTimestamp": "2026-08-02T08:24:05Z" +"ListPrice": 399000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 23435.0 +"LivingArea": 630.0 +"BuildingAreaTotal": 630.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "440 Seaside Avenue 605, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.2814186 +"Longitude": -157.8263336 +"YearBuilt": 1980 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Toan D Doran" +"ListOfficeName": "Hi RE Cnslt Toan Doran LLC" +"ListAgentMlsId": "25774" +"ListOfficeMlsId": "TDHI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "PRICED TO SELL! Waikiki's most affordable fee simple 2BD/1BA/1PK condo. Strong income producer. Rare corner end unit with extra side window, open mountain and golf course views, and a tranquil park view from the living area. Maintenance fee covers all utilities: electricity, central A/C, internet, cable TV with 7 streaming apps, hot water, water, and sewer. Laundry room across the hallway and an EV charging station. Spacious grounds with front and back parks and fruit trees (mango, soursop, avocado, lychee). One block to major bus lines. Minutes to Waikiki beaches, shopping, and dining. 4 guest parking stalls." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Cable TV,Electricity,HVAC,Hot Water,Internet,Sewer,Water" +"BathroomsFull": 1 +"BuildingName": "Seaside Suites" +"CLIP": 2729232989 +"CommonWalls": "End Unit" +"CommunityFeatures": "Deck/Porch,Laundry Facilities,Other,Patio,Storage Facilities,Trash Chute" +"ConstructionMaterials": "Concrete" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2026-04-01T04:59:31.291428+00:00" +"DaysOnMarket": 123 +"DaysOnMarketReplication": 123 +"DaysOnMarketReplicationDate": "2026-08-01" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"ElementarySchool": "Jefferson" +"EntryLevel": 6 +"Flooring": "Ceramic Tile,Vinyl" +"Furnished": "Partially" +"HighSchool": "Mckinley" +"HumanModifiedYN": true +"Inclusions": "Range/Oven,Refrigerator" +"InteriorFeatures": "Single Living Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More,One" +"ListAgentDirectPhone": "(808) 721-6975" +"ListAgentEmail": "toandoran99@gmail.com" +"ListAgentKey": "10768363" +"ListAgentKeyNumeric": "10768363" +"ListAgentOfficePhone": "(808) 721-6975" +"ListAgentPreferredPhone": "(808) 721-6975" +"ListAgentStateLicense": "RB-19897" +"ListOfficeEmail": "toandoran99@gmail.com" +"ListOfficeKey": "6558895" +"ListOfficeKeyNumeric": "6558895" +"ListOfficePhone": "(808) 721-6975" +"ListingContractDate": "2026-03-31" +"ListingKeyNumeric": 1156406655 +"ListingService": "Full Service" +"LotFeatures": "Private" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1093.0 +"MajorChangeTimestamp": "2026-06-22T13:34:21Z" +"MiddleOrJuniorSchool": "Washington" +"MlsStatus": "Active" +"OnMarketDate": "2026-03-31" +"OriginalListPrice": 429000.0 +"OriginatingSystemKey": "19363026" +"ParcelNumber": "1-2-6-020-001-0035" +"ParkingFeatures": "Assigned,Covered,Guest,One Space" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-07-05T20:11:01Z" +"PhotosCount": 21 +"PostalCity": "Honolulu" +"PropertyCondition": "Average Condition,Good Condition" +"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry" +"SourceSystemKey": "1156406655" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Seaside" +"StreetNumber": "440" +"StreetNumberNumeric": "440" +"StreetSuffix": "Avenue" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "1270.8" +"TaxAssessedValue": 363100 +"UnitNumber": "605" +"View": "Golf Course,Mountain(s)" +"ViewYN": true +"ZoningDescription": "X2 - Apartment Precinct" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1156406655"\n } """ +"AssociationFeeTotal": 1093.0 +"TaxAssessedValueLand": "148000" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "215100" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1156406655')" +"provider_name": "HICMLS" +"RecordSignature": -1558677283 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-020-001-0035" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "19339623" +"OriginatingSystemListAgentMemberKey": "8834437" +"Media": array:21 [ …21] +"ID": "80900" } ] +success: true +page_size: 18 +page_count: 259 +count: 4645 +after_key: "" } "RF Response Time" => "0.18 seconds" ] "RF Query: /Property?$select=ALL&$orderby=meta_value date DESC&$top=18&$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 {#7830 +items: array:18 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7886 +post_id: "49866" +post_author: 1 +"ListingKey": "1111207828" +"ListingId": "202509284" +"PropertyType": "Land" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-17T15:59:01Z" +"RFModificationTimestamp": "2026-07-17T16:04:15Z" +"ListPrice": 800000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 5000.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Honolulu" +"PostalCode": "96819" +"UnparsedAddress": "1581 Murphy Street, Honolulu, Hawaii 96819" +"Coordinates": array:2 [ …2] +"Latitude": 21.34791781373 +"Longitude": -157.85920837381 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Choon H James" +"ListOfficeName": "Hawaii Real Estate Ohana LLC" +"ListAgentMlsId": "02588" +"ListOfficeMlsId": "CJRE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ UPDATE! UPDATE! : Probate took some time to set up but property is now ready to sell to new buyers! Bring your offers! This is a great opportunity to build a single family and ADU. Property is on public sewer and public water. ~~~ No record of flooding. \r\n \r\n Prime location - close to downtown Honolulu but green enough that you can still enjoy the birds and nice fresh air. Murphy Road is located in Kalihi Heights near the base of the forest. Convenient location to everything! -- schools, beach parks, shopping, Airport, hospital and downtown Honolulu. ~~~ Minutes to Bishop Museum, other facilities and amenities too.\r\n \r\n This vacant lot is clear for you and your architect to design and landscape. ~~~ Contact us for information. We'll be happy to direct you to possible financing options and the County's Department of Planning and Permitting (DPP) for development possibilities. """ +"AttributionContact": "(808) 293-9111" +"CLIP": 8472478545 +"CountyOrParish": "Oahu" +"CreationDate": "2025-04-07T11:51:38.403739+00:00" +"CurrentUse": "Residential,Single Family" +"DaysOnMarket": 485 +"DaysOnMarketReplication": 470 +"DaysOnMarketReplicationDate": "2026-07-17" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,Seller Disclosure,See Remarks" +"ElementarySchool": "Kalihi Uka" +"HighSchool": "Farrington" +"HumanModifiedYN": true +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 293-9111" +"ListAgentEmail": "ChoonJamesHawaii@gmail.com" +"ListAgentKey": "10773646" +"ListAgentKeyNumeric": "10773646" +"ListAgentOfficePhone": "(808) 293-9111" +"ListAgentPreferredPhone": "(808) 293-9111" +"ListAgentStateLicense": "RB-14344" +"ListOfficeEmail": "choonjameshawaii@gmail.com" +"ListOfficeKey": "2586901" +"ListOfficeKeyNumeric": "2586901" +"ListOfficePhone": "(808) 293-9111" +"ListingContractDate": "2025-04-03" +"ListingKeyNumeric": 1111207828 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Dead End,Interior Lot,Level" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2025-05-28T11:24:25Z" +"MiddleOrJuniorSchool": "Dole" +"MlsStatus": "Active" +"NumberOfLots": "1" +"OnMarketDate": "2025-04-03" +"OriginalListPrice": 900000.0 +"OriginatingSystemKey": "18668642" +"ParcelNumber": "1-1-4-001-032-0000" +"PhotosChangeTimestamp": "2026-07-17T15:59:01Z" +"PhotosCount": 13 +"PossibleUse": "Multi-Family,Other,Residential,Single Family" +"PostalCity": "Honolulu" +"RoadFrontageType": "County Road" +"Sewer": "Not Connected" +"SourceSystemKey": "1111207828" +"SpecialListingConditions": "Probate Listing" +"StateOrProvince": "HI" +"StreetName": "Murphy" +"StreetNumber": "1581" +"StreetNumberNumeric": "1581" +"StreetSuffix": "Street" +"SubdivisionName": "KALIHI UKA" +"TaxAnnualAmount": "2919.96" +"TaxAssessedValue": 780000 +"Topography": "Level, Sloping" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,Phone Available,Sewer Available,Water Available" +"View": "Mountain(s)" +"ViewYN": true +"WaterSource": "Public" +"ZoningDescription": "07 - R-3.5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1111207828"\n } """ +"TaxAssessedValueLand": "780000" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Land" +"TaxAssessedValueImprovement": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1111207828')" +"provider_name": "HICMLS" +"RecordSignature": -1604287557 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-4-001-032-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485283" +"OriginatingSystemListAgentMemberKey": "8842512" +"Media": array:13 [ …13] +"ID": "49866" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7884 +post_id: "48697" +post_author: 1 +"ListingKey": "1052387834" +"ListingId": "202327941" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-30T21:08:03Z" +"RFModificationTimestamp": "2026-05-30T21:13:48Z" +"ListPrice": 50000000.0 +"BathroomsTotalInteger": 15.0 +"BathroomsHalf": 2 +"BedroomsTotal": 12.0 +"LotSizeArea": 95859.0 +"LivingArea": 12005.0 +"BuildingAreaTotal": 17707.0 +"City": "Kailua" +"PostalCode": "96734" +"UnparsedAddress": "508 N Kalaheo Avenue, Kailua, Hawaii 96734" +"Coordinates": array:2 [ …2] +"Latitude": 21.409301842105 +"Longitude": -157.74381852632 +"YearBuilt": 2014 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Stephanie Rae Band" +"ListOfficeName": "Compass" +"ListAgentMlsId": "51562" +"ListOfficeMlsId": "COHI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Unparalleled, the Mele Komo Beachfront Estate located on the pristine shores of Kailua Beach, offers the most discerning connoisseur the ultimate in coastal living. With an impressive 12 beds and 13 baths, this 12,005 square-foot architectural marvel was meticulously designed prioritizing enjoyment with 9 ocean facing bedrooms and 11 private lanais. At 2.2-acres it's the largest residential lot on the Kailua Beachfront. The Primary Hale, boasting 6 beds and 6.5 baths within 5,835 sqft, and the Guest Hale, a companion masterpiece with 6 beds and 6.5 baths spanning 6,170 sqft, offer unparalleled living spaces designed with the perfect combination of luxury comforts and Hawaiian detail. Indulge in resort-style living with a 96,000 gallon pool showcasing a waterfall, slide, jacuzzi, and a private grotto. The 2,000 sqft Pool Cabana with a full kitchen, full bath, spacious loft, and laundry facilities adds an extra touch of convenience and comfort. Mele Komo provides the utmost in privacy and efficiency, featuring 94 photovoltaic panels, privately owned beach access, and stunning views of the famed Mokulua Islands. A unique opportunity to own a true jewel of the Hawaiian coastline." +"ArchitecturalStyle": "Detached, Multi-Family, Multiplex" +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 825-4277" +"BathroomsFull": 13 +"CLIP": 2887325313 +"CommunityFeatures": "Other" +"ConstructionMaterials": "Double Wall,Other,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-04-07T13:31:37.909714+00:00" +"DaysOnMarket": 923 +"DaysOnMarketReplication": 860 +"DaysOnMarketReplicationDate": "2026-05-30" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,Seller Disclosure" +"ExteriorFeatures": "Landscaping" +"Flooring": "Other" +"FrontageType": "Oceanfront, Waterfront" +"Furnished": "Negotiable" +"GarageYN": true +"HumanModifiedYN": true +"Inclusions": "AC Central,Auto Garage Door Opener,Blinds,Book Shelves,Cable TV,Ceiling Fan,Chandelier,Convection Oven,Dishwasher,Disposal,Dryer,Gas Grill,Lawn Sprinkler,Microwave,Photovoltaic - Owned,Range Hood,Range/Oven,Refrigerator,Security System,Smoke Detector,Solar Heater,Washer,Water Heater,Wine Refrigerator" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 825-4277" +"ListAgentEmail": "stephanie@hawaiidreamhomes.com" +"ListAgentKey": "19179745" +"ListAgentKeyNumeric": "19179745" +"ListAgentOfficePhone": "(808) 825-4277" +"ListAgentPreferredPhone": "(808) 825-4277" +"ListAgentStateLicense": "RS-84381" +"ListOfficeEmail": "julie.meier@compass.com" +"ListOfficeKey": "3944102" +"ListOfficeKeyNumeric": "3944102" +"ListOfficePhone": "(808) 825-4277" +"ListingContractDate": "2023-12-15" +"ListingKeyNumeric": 1052387834 +"ListingService": "Full Service" +"LotFeatures": "Dead End,Other,Level" +"MLSAreaMajor": "Kailua" +"MajorChangeTimestamp": "2025-03-10T10:07:31Z" +"MlsStatus": "Active" +"OnMarketDate": "2023-12-15" +"OriginalListPrice": 50000000.0 +"OriginatingSystemKey": "17727198" +"ParcelNumber": "1-4-3-018-067-0000" +"ParkingFeatures": "Driveway,Garage,Three or more Spaces" +"ParkingTotal": "20.0" +"PhotosChangeTimestamp": "2026-05-30T21:08:03Z" +"PhotosCount": 21 +"PoolFeatures": "Heated,In Ground,Pool,Pool/Spa Combo" +"PostalCity": "Kailua" +"PropertyCondition": "Excellent" +"RoadFrontageType": "Private Road" +"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry" +"SourceSystemKey": "1052387834" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetDirPrefix": "N" +"StreetName": "Kalaheo" +"StreetNumber": "508" +"StreetNumberNumeric": "508" +"StreetSuffix": "Avenue" +"SubdivisionName": "BEACHSIDE" +"TaxAnnualAmount": "189697.92" +"TaxAssessedValue": 17289300 +"Topography": "Level" +"Utilities": "Cable Available,Electricity Available,Natural Gas Available,High Speed Internet Available,Other,Phone Available,Underground Utilities,Water Available" +"View": "Coastline, Garden, Mountain(s), Ocean, Sunset, Sunrise" +"ViewYN": true +"WaterSource": "Public" +"ZoningDescription": "03 - R10 - Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1052387834"\n } """ +"TaxAssessedValueLand": "10796700" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "6492600" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1052387834')" +"provider_name": "HICMLS" +"RecordSignature": -2031864557 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-4-3-018-067-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15465233" …3 } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7889 …113} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7866 …123} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7885 …123} 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7890 …117} 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7891 …111} 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7867 …115} 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7864 …122} 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7862 …115} 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7861 …121} 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7868 …122} 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7893 …120} 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7892 …122} 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7826 …122} 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7827 …118} 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7828 …120} 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7829 …132} ] +success: true +page_size: 18 +page_count: 259 +count: 4645 +after_key: "" } "RF Response Time" => "0.16 seconds" ] ]
