array:2 [
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#7110
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7106
+post_id: "85257"
+post_author: 1
+"ListingKey": "1177089502"
+"ListingId": "202613656"
+"PropertyType": "Residential"
+"PropertySubType": "Condominium"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-08-01T06:51:09Z"
+"RFModificationTimestamp": "2026-08-01T06:56:15Z"
+"ListPrice": 735000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 473.0
+"BuildingAreaTotal": 549.0
+"City": "Honolulu"
+"PostalCode": "96814"
+"UnparsedAddress": "987 Queen Street 2503, Honolulu, Hawaii 96814"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.2964369
+"Longitude": -157.8534649
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Edgar Y Wu"
+"ListOfficeName": "Waikiki Realty LLC"
+"ListAgentMlsId": "17621"
+"ListOfficeMlsId": "WRII"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": """
Experience luxury living at A'ali'i in the heart of Ward Village, Honolulu’s premier master-planned community. This one-bedroom, one-bath residence includes one assigned parking stall with overhead storage, as well as a private storage unit conveniently located on the same level as the parking stall. \r\n
Floor-to-ceiling glass doors open to a lanai overlooking Victoria Ward Park. Features include a modern kitchen with quartz countertops, custom cabinetry, and Bosch appliances. Enjoy resort-style amenities, including a pool, jacuzzi, spacious fitness center, yoga studio, BBQ cabanas, event rooms, a penthouse Sky Deck with panoramic views, guest parking, bicycle and surfboard storage, and a ground-floor dog park. Just steps from Whole Foods, award-winning dining, and shopping, and within walking distance of Ala Moana Beach Park and Ala Moana Center.
"""
+"ArchitecturalStyle": "High Rise"
+"AttributionContact": "(808) 955-8282"
+"BathroomsFull": 1
+"BuildingName": "Aalii"
+"CLIP": 3451859913
+"CommunityFeatures": "Barbecue,Clubhouse,Conference/Meeting Room,Deck/Porch,Dog Park,Fitness,Playground,Patio,Pool,Recreation Area,Restaurant,Sauna,Storage Facilities,Trash Chute"
+"ConstructionMaterials": "Double Wall,Concrete"
+"CountyOrParish": "Oahu"
+"CreationDate": "2026-07-15T18:27:32.553949+00:00"
+"DaysOnMarket": 16
+"DaysOnMarketReplication": 16
+"DaysOnMarketReplicationDate": "2026-07-31"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "Seller Disclosure"
+"EntryLevel": 25
+"Flooring": "Carpet,Ceramic Tile,Vinyl"
+"Furnished": "Partially"
+"HumanModifiedYN": true
+"Inclusions": "AC Split,Auto Garage Door Opener,Dishwasher,Disposal,Dryer,Microwave Hood,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater"
+"InteriorFeatures": "Storage,Single Living Level"
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"Levels": "One"
+"ListAgentDirectPhone": "(808) 282-9000"
+"ListAgentEmail": "ew808@aol.com"
+"ListAgentKey": "10778692"
+"ListAgentKeyNumeric": "10778692"
+"ListAgentOfficePhone": "(808) 955-8282"
+"ListAgentPreferredPhone": "(808) 282-9000"
+"ListAgentStateLicense": "RS-45825"
+"ListOfficeEmail": "gwen@waikikirealty2.com"
+"ListOfficeKey": "2587245"
+"ListOfficeKeyNumeric": "2587245"
+"ListOfficePhone": "(808) 955-8282"
+"ListingContractDate": "2026-07-15"
+"ListingKeyNumeric": 1177089502
+"ListingService": "Full Service"
+"MLSAreaMajor": "Metro"
+"MaintenanceExpense": 751.74
+"MajorChangeTimestamp": "2026-07-15T08:23:03Z"
+"MlsStatus": "Active"
+"OnMarketDate": "2026-07-15"
+"OriginalListPrice": 735000.0
+"OriginatingSystemKey": "19579157"
+"ParcelNumber": "1-2-3-002-107-0449"
+"ParkingFeatures": "Assigned,Covered,Guest,One Space,Secured"
+"ParkingTotal": "1.0"
+"PetsAllowed": "Call"
+"PhotosChangeTimestamp": "2026-07-15T18:22:01Z"
+"PhotosCount": 25
+"PostalCity": "Honolulu"
+"PropertyCondition": "Excellent"
+"SecurityFeatures": "Fire Sprinkler System,Security Guard"
+"SourceSystemKey": "1177089502"
+"SpaFeatures": "Community"
+"SpecialListingConditions": "None"
+"StateOrProvince": "HI"
+"StreetName": "Queen"
+"StreetNumber": "987"
+"StreetNumberNumeric": "987"
+"StreetSuffix": "Street"
+"SubdivisionName": "KAKAAKO"
+"TaxAnnualAmount": "2035.2"
+"TaxAssessedValue": 701500
+"UnitNumber": "2503"
+"View": "Coastline, City, Ocean"
+"ViewYN": true
+"ZoningDescription": "Kak – Kakaako Community Development Project"
+"ListAOR": "HI Central"
+"LandTenure": "Fee Simple"
+"Permission": "IDX"
+"CustomFields": """
{\n
"ListingKey": "1177089502"\n
}
"""
+"AssociationFeeTotal": 752.0
+"TaxAssessedValueLand": "23100"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"PropertySubTypeAdditional": "Condominium"
+"TaxAssessedValueImprovement": "678400"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1177089502')"
+"provider_name": "HICMLS"
+"RecordSignature": -156831846
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-002-107-0449"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "3485627"
+"OriginatingSystemListAgentMemberKey": "8842927"
+"Media": array:25 [ …25]
+"ID": "85257"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7108
+post_id: "85493"
+post_author: 1
+"ListingKey": "1178539757"
+"ListingId": "202614570"
+"PropertyType": "Residential"
+"PropertySubType": "Condominium"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-08-01T06:48:52Z"
+"RFModificationTimestamp": "2026-08-01T06:51:25Z"
+"ListPrice": 520000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 172628.0
+"LivingArea": 729.0
+"BuildingAreaTotal": 1096.0
+"City": "Kaneohe"
+"PostalCode": "96744"
+"UnparsedAddress": "46-160 Kiowai Street 2313, Kaneohe, Hawaii 96744"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.4225584
+"Longitude": -157.8015268
+"YearBuilt": 1981
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Ryan Adams"
+"ListOfficeName": "eXp Realty"
+"ListAgentMlsId": "51755"
+"ListOfficeMlsId": "EXPI"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": """
Welcome to Puu Alii, where resort-style living meets the natural beauty of Kaneohe with two exceptional private outdoor retreats.\r\n
\r\n
This well-maintained home offers a functional layout, abundant natural light, and cool tradewinds throughout. Step directly from the\r\n
primary bedroom into your newly turfed private courtyard, the perfect place to enjoy your morning coffee or unwind in peace. At the rear of the home, the covered lanai overlooks a secluded HOA koi pond and tranquil waterfall. While only lightly visible from one or two neighboring units, the lanai itself enjoys outstanding privacy, creating a peaceful setting filled with the soothing sounds of flowing water day and night.\r\n
\r\n
Puu Alii residents enjoy pools, tennis courts, walking paths, and beautifully maintained grounds. Conveniently located near Windward\r\n
Mall, Kaneohe Bay, H-3, Likelike Highway, shopping, dining, and outdoor recreation, this home offers the perfect blend of privacy,\r\n
tranquility, and convenience.
"""
+"AssociationAmenities": "Management"
+"AssociationFee": "686.0"
+"AssociationFeeIncludes": "Common Areas,None,Sewer,Water"
+"AssociationName": "Puu Alii Community Association"
+"AttributionContact": "(808) 725-2794"
+"BathroomsFull": 1
+"BuildingName": "Puu Alii 2-2"
+"CLIP": 3776696870
+"CommunityFeatures": "Barbecue,Conference/Meeting Room,Deck/Porch,Patio,Pool,Recreation Area,Sauna,Tennis Court(s),Trails/Paths"
+"ConstructionMaterials": "Double Wall,Masonry,Concrete,Stucco,Wood Frame"
+"CountyOrParish": "Oahu"
+"CreationDate": "2026-07-29T21:05:04.410307+00:00"
+"DaysOnMarket": 2
+"DaysOnMarketReplication": 2
+"DaysOnMarketReplicationDate": "2026-07-31"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "None,Seller Disclosure"
+"EntryLevel": 1
+"Flooring": "Carpet,Ceramic Tile"
+"FoundationDetails": "Slab"
+"FrontageType": "Canal"
+"Furnished": "Unfurnished"
+"HumanModifiedYN": true
+"Inclusions": "Dryer,Range/Oven,Refrigerator,Washer"
+"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level,Storage,Single Living Level"
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"Levels": "One"
+"ListAgentDirectPhone": "(856) 404-1524"
+"ListAgentEmail": "radamsrealestate@gmail.com"
+"ListAgentKey": "19927814"
+"ListAgentKeyNumeric": "19927814"
+"ListAgentOfficePhone": "(808) 725-2794"
+"ListAgentPreferredPhone": "(856) 404-1524"
+"ListAgentStateLicense": "RS-84757"
+"ListOfficeEmail": "hi.broker@exprealty.net"
+"ListOfficeKey": "2589160"
+"ListOfficeKeyNumeric": "2589160"
+"ListOfficePhone": "(808) 725-2794"
+"ListingContractDate": "2026-07-29"
+"ListingKeyNumeric": 1178539757
+"ListingService": "Full Service"
+"LotFeatures": "Yard"
+"MLSAreaMajor": "Kaneohe"
+"MaintenanceExpense": 509.31
+"MajorChangeTimestamp": "2026-07-29T10:59:45Z"
+"MlsStatus": "Active"
+"OnMarketDate": "2026-07-29"
+"OriginalListPrice": 520000.0
+"OriginatingSystemKey": "19605924"
+"ParcelNumber": "1-4-6-002-033-0029"
+"ParkingFeatures": "Assigned,Covered,Guest,One Space"
+"ParkingTotal": "1.0"
+"PetsAllowed": "Call"
+"PhotosChangeTimestamp": "2026-07-29T21:01:01Z"
+"PhotosCount": 16
+"PostalCity": "Kaneohe"
+"PropertyCondition": "Good Condition"
+"SecurityFeatures": "Security Guard"
+"SourceSystemKey": "1178539757"
+"SpaFeatures": "Community"
+"SpecialListingConditions": "None"
+"StateOrProvince": "HI"
+"Stories": "1"
+"StreetName": "Kiowai"
+"StreetNumber": "46-160"
+"StreetSuffix": "Street"
+"StructureType": "Townhouse"
+"SubdivisionName": "PUUALII"
+"TaxAnnualAmount": "1568.04"
+"TaxAssessedValue": 568000
+"UnitNumber": "2313"
+"View": "Garden"
+"ViewYN": true
+"ZoningDescription": "12 - A-2 Medium Density Apartme"
+"ListAOR": "HI Central"
+"LandTenure": "Fee Simple"
+"Permission": "IDX"
+"CustomFields": """
{\n
"ListingKey": "1178539757"\n
}
"""
+"AssociationFeeTotal": 1195.0
+"TaxAssessedValueLand": "138900"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"PropertySubTypeAdditional": "Condominium,Townhouse"
+"TaxAssessedValueImprovement": "429100"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178539757')"
+"provider_name": "HICMLS"
+"RecordSignature": -1438725041
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-4-6-002-033-0029"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "10013908"
+"OriginatingSystemListAgentMemberKey": "16195719"
+"Media": array:16 [ …16]
+"ID": "85493"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7105
+post_id: "85682"
+post_author: 1
+"ListingKey": "1178313168"
+"ListingId": "202614371"
+"PropertyType": "Residential"
+"PropertySubType": "Condominium"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-08-01T06:45:17Z"
+"RFModificationTimestamp": "2026-08-01T06:46:56Z"
+"ListPrice": 511000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 22041.0
+"LivingArea": 694.0
+"BuildingAreaTotal": 694.0
+"City": "Honolulu"
+"PostalCode": "96815"
+"UnparsedAddress": "2410 Cleghorn Street 2101, Honolulu, Hawaii 96815"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.2777813
+"Longitude": -157.8230666
+"YearBuilt": 1978
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Tiare Dutcher"
+"ListOfficeName": "DW Realty"
+"ListAgentMlsId": "29817"
+"ListOfficeMlsId": "DWRH"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": "Popular Waikiki Skytower high floor mountain view one bedroom, one bath corner unit (with ocean views from the enclosed lanai) has so much to offer. Well maintained building. The owners have made many unique touches to the unit that need to be seen. Built in table on the lanai for your dining enjoyment. Newish kitchen appliances (2023-2025). Washer and dryer in the kitchen. Split type AC keeps the condo cool. Special lighting and blinds. Fully furnished including linens, towels, kitchenware AND two surfboards. Gated, secured, covered parking stall on the fourth floor. Close to Wakiki Beach, International Marketplace, restaurants, and bus service. Repiping was completed in 2019-2020. Fire alarm speakers and smoke detectors finished in 2025-2026. Assessment for the speakers and smoke detectors ends 1/31/2027. To be sold As Is. Seller prefers Escrow with Kevin Batungbacal at First American Title, Aina Haina."
+"ArchitecturalStyle": "High Rise"
+"AssociationAmenities": "Management"
+"AssociationFee2": "485.0"
+"AssociationFeeIncludes": "Common Areas,Cable TV,Hot Water,Internet,Sewer,Water"
+"AttributionContact": "(808) 753-5327"
+"BathroomsFull": 1
+"BuildingName": "Waikiki Skytower"
+"CLIP": 9105292692
+"CommunityFeatures": "Barbecue,Community Pool,Pool,Sauna,Trash Chute"
+"ConstructionMaterials": "Concrete"
+"CountyOrParish": "Oahu"
+"CreationDate": "2026-08-01T06:27:55.097585+00:00"
+"DaysOnMarket": 7
+"DaysOnMarketReplication": 7
+"DaysOnMarketReplicationDate": "2026-07-31"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "Seller Disclosure"
+"ElementarySchool": "Jefferson"
+"EntryLevel": 21
+"Flooring": "Ceramic Tile,Laminate"
+"Furnished": "Furnished"
+"GarageYN": true
+"HighSchool": "Kaimuki"
+"Inclusions": "AC Split,Blinds,Book Shelves,Cable TV,Ceiling Fan,Dishwasher,Disposal,Drapes,Dryer,Kitchenware,Linens,Microwave,Range/Oven,Refrigerator,Smoke Detector,Washer"
+"InteriorFeatures": "Handicap Access,Single Living Level"
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"Levels": "One"
+"ListAgentDirectPhone": "(808) 753-5327"
+"ListAgentEmail": "tiaredutcher@yahoo.com"
+"ListAgentKey": "10777775"
+"ListAgentKeyNumeric": "10777775"
+"ListAgentOfficePhone": "(808) 753-5327"
+"ListAgentPreferredPhone": "(808) 753-5327"
+"ListAgentStateLicense": "RB-22030"
+"ListOfficeEmail": "tiare@dwrealtyhawaii.com"
+"ListOfficeKey": "2589415"
+"ListOfficeKeyNumeric": "2589415"
+"ListOfficePhone": "(808) 753-5327"
+"ListingContractDate": "2026-07-24"
+"ListingKeyNumeric": 1178313168
+"ListingService": "Full Service"
+"MLSAreaMajor": "Metro"
+"MaintenanceExpense": 1333.0
+"MajorChangeTimestamp": "2026-07-31T20:26:13Z"
+"MiddleOrJuniorSchool": "Washington"
+"MlsStatus": "Active"
+"OnMarketDate": "2026-07-24"
+"OriginalListPrice": 511000.0
+"OriginatingSystemKey": "19600354"
+"ParcelNumber": "1-2-6-024-053-0058"
+"ParkingFeatures": "Assigned,Covered,Garage,Guest,One Space,On Street"
+"ParkingTotal": "1.0"
+"PetsAllowed": "Call"
+"PhotosChangeTimestamp": "2026-08-01T06:27:01Z"
+"PhotosCount": 22
+"PoolFeatures": "Heated"
+"PostalCity": "Honolulu"
+"PropertyCondition": "Good Condition,Updated/Remodeled"
+"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Key Card Entry"
+"SourceSystemKey": "1178313168"
+"SpecialListingConditions": "None"
+"StateOrProvince": "HI"
+"StreetName": "Cleghorn"
+"StreetNumber": "2410"
+"StreetNumberNumeric": "2410"
+"StreetSuffix": "Street"
+"SubdivisionName": "WAIKIKI"
+"TaxAnnualAmount": "1128.96"
+"TaxAssessedValue": 433800
+"UnitNumber": "2101"
+"View": "Canal, City, Mountain(s), Sunset"
+"ViewYN": true
+"ZoningDescription": "X2 - Apartment Precinct"
+"ListAOR": "HI Central"
+"LandTenure": "Fee Simple"
+"Permission": "IDX"
+"CustomFields": """
{\n
"ListingKey": "1178313168"\n
}
"""
+"HumanModifiedYN": false
+"AssociationFeeTotal": 1818.0
+"TaxAssessedValueLand": "81400"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"PropertySubTypeAdditional": "Condominium"
+"TaxAssessedValueImprovement": "352400"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178313168')"
+"provider_name": "HICMLS"
+"RecordSignature": 906484530
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-024-053-0058"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "12690747"
+"OriginatingSystemListAgentMemberKey": "3478238"
+"Media": array:22 [ …22]
+"ID": "85682"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7109
+post_id: "85683"
+post_author: 1
+"ListingKey": "1178601046"
+"ListingId": "202614632"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-08-01T06:43:40Z"
+"RFModificationTimestamp": "2026-08-01T06:46:56Z"
+"ListPrice": 940000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 2857.0
+"LivingArea": 816.0
+"BuildingAreaTotal": 816.0
+"City": "Honolulu"
+"PostalCode": "96814"
+"UnparsedAddress": "1068 Kinau Street B, Honolulu, Hawaii 96814"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.3035555
+"Longitude": -157.8455339
+"YearBuilt": 1907
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Michael Garcia"
+"ListOfficeName": "Locations LLC"
+"ListAgentMlsId": "26689"
+"ListOfficeMlsId": "LOCA"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": "**1ST OPEN HOUSE, SUNDAY, AUGUST 9, 2-5PM** NEW LISTING!!! Beautifully Renovated 1907 Home offering the perfect blend of Island Charm and Modern Upgrades, adjacent to the desirable neighborhoods of Ala Moana and Kaka'ako. Thoughtfully upgraded & converted to Double-Wall Construction. Recent improvements include a New Roof, Upgraded Kitchen and Bathroom, Fresh Interior and Exterior Paint, Ceramic Tile Flooring, Vinyl Windows. This Spacious 2-Bedroom Floor Plan lives large, with a generous Living Room, Kitchen and Dining Area ideal for everyday living. Stay cool year-round with Window A/C and Ceiling Fans in the Living Room & Bedrooms, plus the convenience of an Instant Gas Water Heater. Carport that fits up to 3 Vehicles, a Fabulous Gazebo for gatherings and Spacious Front & Back Yards. Tucked on a quiet street, this home offers a rare sense of calm while still being just minutes from Ala Moana Beach Park, Ala Moana Shopping Center & Ward Village Kaka'ako...putting Shopping, Dining, the Beach and all the Conveniences of Town Living right at your fingertips. Don't miss this rare opportunity to own a piece of Honolulu history in an ideal location with all the modern upgrades!"
+"ArchitecturalStyle": "Detached"
+"AttributionContact": "(808) 735-4200"
+"BathroomsFull": 1
+"CLIP": 4281854486
+"CarportYN": true
+"ConstructionMaterials": "Double Wall,Wood Frame"
+"CountyOrParish": "Oahu"
+"CreationDate": "2026-08-01T06:46:49.196710+00:00"
+"DaysOnMarketReplicationDate": "2026-07-31"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "Pet on Property,Seller Disclosure"
+"Flooring": "Ceramic Tile"
+"Furnished": "Unfurnished"
+"HumanModifiedYN": true
+"Inclusions": "AC Window Unit,Ceiling Fan,Dryer,Microwave,Range/Oven,Refrigerator,Smoke Detector,Water Heater"
+"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level"
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"Levels": "One"
+"ListAgentDirectPhone": "(808) 221-4661"
+"ListAgentEmail": "michael.garcia@locationshawaii.com"
+"ListAgentKey": "10772600"
+"ListAgentKeyNumeric": "10772600"
+"ListAgentOfficePhone": "(808) 735-4200"
+"ListAgentPreferredPhone": "(808) 221-4661"
+"ListAgentStateLicense": "RS-60354"
+"ListOfficeEmail": "darryl.macha@locationshawaii.com"
+"ListOfficeKey": "2586923"
+"ListOfficeKeyNumeric": "2586923"
+"ListOfficePhone": "(808) 735-4200"
+"ListingContractDate": "2026-07-31"
+"ListingKeyNumeric": 1178601046
+"ListingService": "Full Service"
+"LotFeatures": "Interior Lot,Other,Level"
+"MLSAreaMajor": "Metro"
+"MajorChangeTimestamp": "2026-07-31T20:42:24Z"
+"MlsStatus": "Active"
+"OnMarketDate": "2026-07-31"
+"OriginalListPrice": 940000.0
+"OriginatingSystemKey": "19608291"
+"ParcelNumber": "1-2-4-013-058-0000"
+"ParkingFeatures": "Carport,Three or more Spaces"
+"ParkingTotal": "3.0"
+"PhotosChangeTimestamp": "2026-08-01T06:43:01Z"
+"PhotosCount": 24
+"PoolFeatures": "None"
+"PostalCity": "Honolulu"
+"PropertyCondition": "Excellent"
+"SecurityFeatures": "Key Card Entry"
+"SourceSystemKey": "1178601046"
+"SpecialListingConditions": "None"
+"StateOrProvince": "HI"
+"Stories": "1"
+"StreetName": "Kinau"
+"StreetNumber": "1068"
+"StreetNumberNumeric": "1068"
+"StreetSuffix": "Street"
+"SubdivisionName": "MAKIKI AREA"
+"TaxAnnualAmount": "3300.0"
+"TaxAssessedValue": 1061700
+"Topography": "Level"
+"UnitNumber": "B"
+"Utilities": "Cable Available,Natural Gas Available,High Speed Internet Available,Sewer Available,Water Available"
+"View": "None"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=Y47xSPJzkeU"
+"WaterSource": "Public"
+"YearBuiltEffective": 2022
+"ZoningDescription": "12 - A-2 Medium Density Apartme"
+"ListAOR": "HI Central"
+"LandTenure": "Fee Simple"
+"Permission": "IDX"
+"CustomFields": """
{\n
"ListingKey": "1178601046"\n
}
"""
+"TaxAssessedValueLand": "874100"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"PropertySubTypeAdditional": "Single Family Residence"
+"TaxAssessedValueImprovement": "187600"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178601046')"
+"provider_name": "HICMLS"
+"short_address": "Honolulu, Hawaii 96814, USA"
+"RecordSignature": -1505524019
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-4-013-058-0000"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "3485305"
+"OriginatingSystemListAgentMemberKey": "3476337"
+"Media": array:24 [ …24]
+"DaysOnMarket": 0
+"ID": "85683"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7107
+post_id: "78696"
+post_author: 1
+"ListingKey": "1153099476"
+"ListingId": "202603994"
+"PropertyType": "Residential"
+"PropertySubType": "Condominium"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-08-01T06:43:40Z"
+"RFModificationTimestamp": "2026-08-01T06:46:46Z"
+"ListPrice": 735000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 816.0
+"BuildingAreaTotal": 860.0
+"City": "Honolulu"
+"PostalCode": "96813"
+"UnparsedAddress": "801 South Street 2002, Honolulu, Hawaii 96813"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.304547
+"Longitude": -157.855676
+"YearBuilt": 2015
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Anna Achauer"
+"ListOfficeName": "Anna International Realty"
+"ListAgentMlsId": "32581"
+"ListOfficeMlsId": "ANNA"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": "Rarely available corner-end unit on a desirable mid-level high floor featuring 2 bedrooms, 2 full bathrooms, 2 parking, LOW MAINTENANCE FEE!!! This thoughtfully designed home captures beautiful mountain, city, ocean & unobstructed Downtown Honolulu views, all enjoyed from your private lanai. Upgraded kitchen features Wood Door Cabinetry, French Gold Countertops, Brand New Refrigerator. Additional highlights: an in-unit washer & dryer, 3 split A/C for. This secured, well-managed building offers 24-hour security, an on-site resident manager, guest parking, EV charging, a spacious lobby with meeting & recreation areas. Pet friendly. Ideally located on the border of Kaka'ako & Downtown Honolulu, just minutes from SALT, Ward Village, Ala Moana, dining, shopping, beaches, entertainment-placing you in the center of Honolulu’s most vibrant & convenient neighborhoods. Whether you are seeking a comfortable primary residence or a strong investment opportunity, this home combines location, views, convenience in one of Honolulu’s most dynamic & growing communities. Opportunities to own a corner-end unit with these features & value in this location are limited—this is one you won’t want to miss."
+"ArchitecturalStyle": "High Rise"
+"AssociationAmenities": "Management"
+"AssociationFee2": "21.0"
+"AssociationFeeIncludes": "Common Areas,Sewer,Water"
+"AttributionContact": "(808) 386-7556"
+"BathroomsFull": 2
+"BuildingName": "801 South St"
+"CLIP": 2287049505
+"CommonWalls": "End Unit"
+"CommunityFeatures": "Clubhouse,Conference/Meeting Room,Trash Chute"
+"ConstructionMaterials": "Concrete"
+"CountyOrParish": "Oahu"
+"CreationDate": "2026-02-17T09:35:25.546395+00:00"
+"DaysOnMarket": 155
+"DaysOnMarketReplication": 155
+"DaysOnMarketReplicationDate": "2026-07-31"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "Seller Disclosure"
+"ElementarySchool": "Royal"
+"EntryLevel": 20
+"Flooring": "Carpet, Laminate, Vinyl"
+"Furnished": "Partially"
+"HighSchool": "Mckinley"
+"HumanModifiedYN": true
+"Inclusions": "AC Split,Blinds,Book Shelves,Cable TV,Disposal,Dryer,Microwave,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater"
+"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level,Single Living Level"
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"Levels": "One"
+"ListAgentDirectPhone": "(808) 386-7556"
+"ListAgentEmail": "annarealtyusa@hotmail.com"
+"ListAgentKey": "10772923"
+"ListAgentKeyNumeric": "10772923"
+"ListAgentOfficePhone": "(808) 386-7556"
+"ListAgentPreferredPhone": "(808) 386-7556"
+"ListAgentStateLicense": "RB-20790"
+"ListOfficeEmail": "annarealtyusa@gmail.com"
+"ListOfficeKey": "2586129"
+"ListOfficeKeyNumeric": "2586129"
+"ListOfficePhone": "(808) 386-7556"
+"ListingContractDate": "2026-02-16"
+"ListingKeyNumeric": 1153099476
+"ListingService": "Full Service"
+"MLSAreaMajor": "Metro"
+"MaintenanceExpense": 541.0
+"MajorChangeTimestamp": "2026-07-22T13:59:47Z"
+"MiddleOrJuniorSchool": "Keelikolani"
+"MlsStatus": "Active"
+"OnMarketDate": "2026-02-16"
+"OriginalListPrice": 785000.0
+"OriginatingSystemKey": "19280429"
+"ParcelNumber": "1-2-1-047-003-0245"
+"ParkingFeatures": "Covered,Guest,Two Spaces,Unassigned"
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2026-02-17T09:32:00Z"
+"PhotosCount": 22
+"PostalCity": "Honolulu"
+"PropertyCondition": "Good Condition"
+"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Key Card Entry,Fire Sprinkler System,Security Guard"
+"SourceSystemKey": "1153099476"
+"SpecialListingConditions": "None"
+"StateOrProvince": "HI"
+"Stories": "1"
+"StreetName": "South"
+"StreetNumber": "801"
+"StreetNumberNumeric": "801"
+"StreetSuffix": "Street"
+"SubdivisionName": "KAKAAKO"
+"TaxAnnualAmount": "2652.0"
+"TaxAssessedValue": 781500
+"UnitNumber": "2002"
+"View": "Coastline, City, Mountain(s), Sunset"
+"ViewYN": true
+"ZoningDescription": "Kak – Kakaako Community Development Project"
+"ListAOR": "HI Central"
+"LandTenure": "Fee Simple"
+"CustomFields": """
{\n
"ListingKey": "1153099476"\n
}
"""
+"AssociationFeeTotal": 562.0
+"TaxAssessedValueLand": "46800"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"PropertySubTypeAdditional": "Condominium"
+"TaxAssessedValueImprovement": "734700"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1153099476')"
+"provider_name": "HICMLS"
+"RecordSignature": 1233559784
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-1-047-003-0245"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "8843542"
+"OriginatingSystemListAgentMemberKey": "3479434"
+"Media": array:22 [ …22]
+"ID": "78696"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7104
+post_id: "85684"
+post_author: 1
+"ListingKey": "1175360391"
+"ListingId": "202612004"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Townhouse"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-08-01T06:41:50Z"
+"RFModificationTimestamp": "2026-08-01T06:46:46Z"
+"ListPrice": 6500.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1715.0
+"BuildingAreaTotal": 2294.0
+"City": "Kapolei"
+"PostalCode": "96707"
+"UnparsedAddress": "92-1170 Olani Street 50-1, Kapolei, Hawaii 96707"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.3340079
+"Longitude": -158.077849
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Anna Achauer"
+"ListOfficeName": "Anna International Realty"
+"ListAgentMlsId": "32581"
+"ListOfficeMlsId": "ANNA"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": "Rarely available corner end unit by the swimming pool. This beautifully fully furnished (Move-in ready) 4-bedroom, 3-bath residence in the highly desirable Coconut Plantation at Ko Olina Resort. Tax records reflect a 3-bedroom; however, the home includes an additional spacious room currently used as a 4th bedroom, ideal for guests, home office, or extended family living. This bright island-style home features soaring ceilings, open-concept living, upgraded kitchen with abundant cabinetry, stainless steel appliances, a large breakfast bar perfect for entertaining. Expansive covered lanai offers seamless indoor-outdoor living surrounded by lush tropical landscaping & resort ambiance. Enjoy resort-style amenities including pools, spas, tropical walking paths, and beautifully maintained grounds. Conveniently located near Ko Olina lagoons, beaches, golf, dining, and shops. Rent includes water, sewer, trash, cable TV, and internet.Tenant responsible for electricity. Minimum 6-month lease required. Detached 2-car garage. No smoking. Please inquire about special rates for 30-day to 6-month stays. Experience luxury resort living on Oahu’s sunny west side. Near Four Seasons & Aulani Resort."
+"Appliances": "Dryer,Dishwasher,Electric Range,Disposal,Microwave Hood Fan,Microwave,Oven,Range,Refrigerator,Washer"
+"ArchitecturalStyle": "Multi-Level"
+"AttributionContact": "(808) 386-7556"
+"AvailabilityDate": "2026-09-01"
+"BathroomsFull": 3
+"BuildingName": "Coconut Plantation"
+"CLIP": 7864092756
+"CommonWalls": "End Unit"
+"CommunityFeatures": "Barbecue,Clubhouse,Conference/Meeting Room,Property Manager On-Site,Pool,Restaurant,Gated"
+"Cooling": "Central Air"
+"CoolingYN": true
+"CountyOrParish": "Oahu"
+"CreationDate": "2026-06-20T06:29:58.068282+00:00"
+"DaysOnMarket": 42
+"DaysOnMarketReplication": 42
+"DaysOnMarketReplicationDate": "2026-07-31"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "No Smoking,Renters Insurance Required,See Remarks"
+"Flooring": "Ceramic Tile,Hardwood"
+"Furnished": "Furnished"
+"GarageYN": true
+"HumanModifiedYN": true
+"InteriorFeatures": "Bedroom on Main Level,Ceiling Fan(s),Chandelier,Dual Sinks,Full Bath on Main Level,Intercom,Kitchen Island,Pantry,Stainless Steel Appliances,Storage,Cable TV,Walk-In Closet(s),Window Treatments"
+"RFTransactionType": "For Rent"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"Levels": "Two"
+"ListAgentDirectPhone": "(808) 386-7556"
+"ListAgentEmail": "annarealtyusa@hotmail.com"
+"ListAgentKey": "10772923"
+"ListAgentKeyNumeric": "10772923"
+"ListAgentOfficePhone": "(808) 386-7556"
+"ListAgentPreferredPhone": "(808) 386-7556"
+"ListAgentStateLicense": "RB-20790"
+"ListOfficeEmail": "annarealtyusa@gmail.com"
+"ListOfficeKey": "2586129"
+"ListOfficeKeyNumeric": "2586129"
+"ListOfficePhone": "(808) 386-7556"
+"ListingContractDate": "2026-06-19"
+"ListingKeyNumeric": 1175360391
+"MLSAreaMajor": "Ewaplain"
+"MajorChangeTimestamp": "2026-07-31T20:36:41Z"
+"MlsStatus": "Active"
+"OnMarketDate": "2026-06-19"
+"OriginalListPrice": 7800.0
+"OriginatingSystemKey": "19531301"
+"OtherEquipment": "Intercom"
+"ParcelNumber": "1-9-1-056-004-0147"
+"ParkingFeatures": "Covered,Garage,Guest,Two Spaces,Secured,Garage Door Opener,Parking Available"
+"ParkingTotal": "2.0"
+"PatioAndPorchFeatures": "Lanai"
+"PetsAllowed": "No"
+"PhotosChangeTimestamp": "2026-06-20T06:25:01Z"
+"PhotosCount": 25
+"PostalCity": "Kapolei"
+"PropertyCondition": "Excellent,Updated/Remodeled"
+"RentIncludes": "Parking, Pool"
+"SecurityFeatures": "Gated Community,Smoke Detector(s)"
+"SourceSystemKey": "1175360391"
+"SpaFeatures": "Community"
+"StateOrProvince": "HI"
+"Stories": "2"
+"StoriesTotal": "2"
+"StreetName": "Olani"
+"StreetNumber": "92-1170"
+"StreetSuffix": "Street"
+"StructureType": "Townhouse"
+"SubdivisionName": "KO OLINA"
+"TenantPays": "Application Fee,Other Tax"
+"UnitNumber": "50-1"
+"Utilities": "Cable Available,High Speed Internet Available,Sewer Available,Trash Collection,Water Available"
+"View": "Other"
+"ViewYN": true
+"WindowFeatures": "Blinds"
+"YearBuiltEffective": 2024
+"ZoningDescription": "11 - A-1 Low Density Apartment"
+"ListAOR": "HI Central"
+"CustomFields": """
{\n
"ListingKey": "1175360391"\n
}
"""
+"Restrictions": "No Smoking"
+"AvailabilityType": "Long Term"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"PropertySubTypeAdditional": "Townhouse"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1175360391')"
+"provider_name": "HICMLS"
+"RecordSignature": 691872640
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-1-056-004-0147"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "8843542"
+"OriginatingSystemListAgentMemberKey": "3479434"
+"Media": array:25 [ …25]
+"ID": "85684"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7103
+post_id: "84378"
+post_author: 1
+"ListingKey": "1170852402"
+"ListingId": "202610489"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-08-01T06:15:14Z"
+"RFModificationTimestamp": "2026-08-01T06:18:27Z"
+"ListPrice": 1240000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 5161.0
+"LivingArea": 1088.0
+"BuildingAreaTotal": 1088.0
+"City": "Haleiwa"
+"PostalCode": "96712"
+"UnparsedAddress": "66-82 Wana Place 3, Haleiwa, Hawaii 96712"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.5807645
+"Longitude": -158.1157863
+"YearBuilt": 1957
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Michelle Takushi"
+"ListOfficeName": "Hawaii Modern Realty"
+"ListAgentMlsId": "40040"
+"ListOfficeMlsId": "BHHR"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": "Enjoy North Shore living in Haleiwa Hale! This home is just a short distance from Kaiaka Bay Beach! This property features 3 bedrooms, 1 bathroom, a spacious two-car garage with a new garage door, and a fenced-in yard. The interior showcases beautiful travertine flooring throughout. The kitchen is huge, with abundant counter space and cabinets, plus marble countertops. Additional highlights include owned solar panels on the net metering program, a new insulated steel roof, and an energy-efficient heat pump water heater. The exterior of the home has been painted this year, and the property has a front yard with a lush lawn, a large, shady mango tree, and a driveway with parking for up to three cars, providing both curb appeal and added convenience. The $125 maintenance fee is for the Haleiwa Hale septic system and water. Flood insurance is transferable to the buyer. (Verify)"
+"ArchitecturalStyle": "Detached"
+"AssociationFee": "125.0"
+"AssociationName": "Haleiwa Hale"
+"AttributionContact": "(808) 792-3910"
+"BathroomsFull": 1
+"CLIP": 1562445522
+"ConstructionMaterials": "Masonry, Stucco"
+"CountyOrParish": "Oahu"
+"CreationDate": "2026-06-10T22:33:55.507063+00:00"
+"DaysOnMarket": 51
+"DaysOnMarketReplication": 51
+"DaysOnMarketReplicationDate": "2026-07-31"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "Pet on Property,Seller Disclosure"
+"ElementarySchool": "Haleiwa"
+"Flooring": "Other"
+"GarageYN": true
+"HighSchool": "Waialua"
+"Inclusions": "AC Window Unit,Auto Garage Door Opener,Cable TV,Ceiling Fan,Convection Oven,Dishwasher,Drapes,Dryer,Heat Pump,Microwave,Photovoltaic - Owned,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": "One"
+"ListAgentDirectPhone": "(808) 792-3910"
+"ListAgentEmail": "michelle.takushi@modernhawaii.com"
+"ListAgentKey": "10778131"
+"ListAgentKeyNumeric": "10778131"
+"ListAgentOfficePhone": "(808) 792-3910"
+"ListAgentPreferredPhone": "(808) 792-3910"
+"ListAgentStateLicense": "RS-71963"
+"ListOfficeEmail": "aloha@modernhawaii.com"
+"ListOfficeKey": "2589163"
+"ListOfficeKeyNumeric": "2589163"
+"ListOfficePhone": "(808) 792-3910"
+"ListingContractDate": "2026-06-10"
+"ListingKeyNumeric": 1170852402
+"ListingService": "Full Service"
+"LotFeatures": "Cleared,Dead End,Level"
+"MLSAreaMajor": "North Shore"
+"MajorChangeTimestamp": "2026-06-27T08:56:31Z"
+"MiddleOrJuniorSchool": "Waialua"
+"MlsStatus": "Active"
+"OnMarketDate": "2026-06-10"
+"OriginalListPrice": 1295000.0
+"OriginatingSystemKey": "19487928"
+"ParcelNumber": "1-6-6-014-012-0003"
+"ParkingFeatures": "Driveway,Garage,Three or more Spaces"
+"ParkingTotal": "5.0"
+"PhotosChangeTimestamp": "2026-07-18T02:35:00Z"
+"PhotosCount": 22
+"PoolFeatures": "None"
+"PostalCity": "Haleiwa"
+"PropertyCondition": "Excellent,Good Condition"
+"RoadFrontageType": "Private Road"
+"Sewer": "Septic Tank"
+"SourceSystemKey": "1170852402"
+"SpecialListingConditions": "None"
+"StateOrProvince": "HI"
+"Stories": "1"
+"StreetName": "Wana"
+"StreetNumber": "66-82"
+"StreetSuffix": "Place"
+"SubdivisionName": "WAIALUA"
+"TaxAnnualAmount": "3432.0"
+"TaxAssessedValue": 1340100
+"Topography": "Level"
+"UnitNumber": "3"
+"Utilities": "Cable Available,High Speed Internet Available,Septic Available,Water Available"
+"View": "None"
+"WaterSource": "Public"
+"YearBuiltEffective": 2012
+"ZoningDescription": "56 - Country District"
+"ListAOR": "HI Central"
+"LandTenure": "Fee Simple"
+"Permission": "IDX"
+"CustomFields": """
{\n
"ListingKey": "1170852402"\n
}
"""
+"HumanModifiedYN": false
+"AssociationFeeTotal": 125.0
+"TaxAssessedValueLand": "890600"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"PropertySubTypeAdditional": "Single Family Residence"
+"TaxAssessedValueImprovement": "449500"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1170852402')"
+"provider_name": "HICMLS"
+"RecordSignature": -709704379
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-6-6-014-012-0003"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "10036030"
+"OriginatingSystemListAgentMemberKey": "3482184"
+"Media": array:22 [ …22]
+"ID": "84378"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7095
+post_id: "85685"
+post_author: 1
+"ListingKey": "1177657147"
+"ListingId": "202614000"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Duplex"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-08-01T05:58:02Z"
+"RFModificationTimestamp": "2026-08-01T05:59:50Z"
+"ListPrice": 3300.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 10632.0
+"LivingArea": 1398.0
+"BuildingAreaTotal": 1398.0
+"City": "Kaneohe"
+"PostalCode": "96744"
+"UnparsedAddress": null
+"Coordinates": array:2 [ …2]
+"Latitude": null
+"Longitude": null
+"YearBuilt": 1961
+"InternetAddressDisplayYN": false
+"FeedTypes": "IDX"
+"ListAgentFullName": "Nancy R Yamachi"
+"ListOfficeName": "Hawaii Resource Realty"
+"ListAgentMlsId": "05590"
+"ListOfficeMlsId": "PARR"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": """
Professionally cleaned, cool and bright 3 bedroom/1 bath apt with a little ocean view. Partially covered tandem parking for 2 cars + 1 open stall. Appliances included are 2 large refrigerators, range oven, microwave oven hood, stacked washer/dryer, 3 Mitsubishi ACs for living room & 2 bedrooms, 2 window ACs, 4 ceiling fans. Yard service is included.\r\n
\r\n
Electricity and water are sub-metered. Tenant will receive an email notifying them of the amount due for the month and must pay owner who lives in the 1 apt at the rear by check each month. There is one other house on the property. Long time tenant is very nice.\r\n
\r\n
Renter's insurance is required. Tenant will be allowed occupancy only after proof is provided that it has been obtained. A completed rental application and credit report ($9) for every adult is also required. Rent is $3,300/mo and the Security Deposit is the same amount. NO PETS, SMOKERS OR VAPERS WILL BE ALLOWED.
"""
+"Appliances": "Dryer,Electric Range,Disposal,Refrigerator,Washer"
+"ArchitecturalStyle": "Multiplex, Duplex"
+"AttributionContact": "(808) 973-0830"
+"AvailabilityDate": "2026-08-08"
+"BathroomsFull": 1
+"CLIP": 2678804487
+"CommonWalls": "No One Above,No One Below"
+"CountyOrParish": "Oahu"
+"CreationDate": "2026-08-01T05:42:04.805268+00:00"
+"DaysOnMarketReplicationDate": "2026-07-31"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "Familial Relation,No Smoking,Renters Insurance Required,See Remarks"
+"Flooring": "Ceramic Tile,Hardwood,Other"
+"FrontageType": "Other"
+"Furnished": "Partially"
+"HumanModifiedYN": true
+"InteriorFeatures": "Built-in Features,Bedroom on Main Level,Ceiling Fan(s),Granite Counters,Kitchen Island,Single Living Level"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"Levels": "One, Two"
+"ListAgentDirectPhone": "(808) 973-0837"
+"ListAgentEmail": "nancyyamachi@aol.com"
+"ListAgentKey": "10768434"
+"ListAgentKeyNumeric": "10768434"
+"ListAgentOfficePhone": "(808) 973-0830"
+"ListAgentPreferredPhone": "(808) 973-0837"
+"ListAgentStateLicense": "RB-12737"
+"ListOfficeKey": "2587333"
+"ListOfficeKeyNumeric": "2587333"
+"ListOfficePhone": "(808) 973-0830"
+"ListingContractDate": "2026-07-31"
+"ListingKeyNumeric": 1177657147
+"LotFeatures": "Yard"
+"MLSAreaMajor": "Kaneohe"
+"MajorChangeTimestamp": "2026-07-31T19:38:40Z"
+"MlsStatus": "Active"
+"OnMarketDate": "2026-07-31"
+"OriginalListPrice": 3300.0
+"OriginatingSystemKey": "19589434"
+"ParcelNumber": "1-4-5-053-075-0000"
+"ParkingFeatures": "Assigned,On Street,Parking Available"
+"ParkingTotal": "2.0"
+"PetsAllowed": "No"
+"PhotosChangeTimestamp": "2026-08-01T05:58:02Z"
+"PhotosCount": 16
+"PostalCity": "Kaneohe"
+"PropertyCondition": "Good Condition,Updated/Remodeled"
+"RentIncludes": "Parking"
+"SecurityFeatures": "Key Card Entry,Smoke Detector(s)"
+"SourceSystemKey": "1177657147"
+"StateOrProvince": "HI"
+"Stories": "2"
+"StoriesTotal": "2"
+"StreetName": "Lolopua"
+"StreetNumber": "45-321"
+"StreetSuffix": "Street"
+"StructureType": "Duplex"
+"SubdivisionName": "MAHALANI"
+"Utilities": "Yard Maintenance"
+"View": "Ocean"
+"ViewYN": true
+"ZoningDescription": "05 - R-5 Residential District"
+"ListAOR": "HI Central"
+"CustomFields": """
{\n
"ListingKey": "1177657147"\n
}
"""
+"Restrictions": "No Smoking"
+"AvailabilityType": "Long Term"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"PropertySubTypeAdditional": "Duplex"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1177657147')"
+"provider_name": "HICMLS"
+"RecordSignature": -386749406
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-4-5-053-075-0000"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "3485715"
+"OriginatingSystemListAgentMemberKey": "8842676"
+"Media": array:16 [ …16]
+"DaysOnMarket": 0
+"ID": "85685"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7094
+post_id: "85622"
+post_author: 1
+"ListingKey": "1178496595"
+"ListingId": "202614525"
+"PropertyType": "Residential"
+"PropertySubType": "Condominium"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-08-01T05:51:05Z"
+"RFModificationTimestamp": "2026-08-01T05:55:19Z"
+"ListPrice": 445000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 611.0
+"BuildingAreaTotal": 611.0
+"City": "Honolulu"
+"PostalCode": "96814"
+"UnparsedAddress": "930 Kaheka Streets 3604, Honolulu, Hawaii 96814"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.304547
+"Longitude": -157.855676
+"YearBuilt": 1981
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Christine Kim"
+"ListOfficeName": "Locations LLC"
+"ListAgentMlsId": "54167"
+"ListOfficeMlsId": "LOCA"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": "Welcome to Hale Kaheka #3604: a high-floor 1BD/1BTH/1PK residence, showcasing breathtaking mtn views through dramatic floor-to-ceiling windows. Positioned on the cooler side of the bldg, this home enjoys refreshing trade winds & a peaceful living environment high above Honolulu. Thoughtfully upgraded w/an updated kitchen, laminate flooring, fresh interior paint, ceiling fans, a new stove, & a new AC, offering a truly move-in ready experience. Additional conveniences include an in-unit washer/dryer, a spacious closet, roll-down privacy shades in the bedroom, & a secured parking stall located on a lower floor. Adding value and peace of mind, Hale Kaheka has recently completed its waste & drain pipe replacement projects & is equipped w/a fire sprinkler system. Ideally located in the heart of Honolulu, residents enjoy convenience to Don Quijote, Sam’s Club, Walmart, Ala Moana, shopping, & everyday essentials. Rare opportunity to own a Honolulu residence at an exceptional value & location. Our asking price ($445,000) is less than the assessed tax value ($452,000) making this an attractive option for both owner-occupants & investors. 1st Broker 8/5 Wed 10am-1pm. 1st OH 8/9 Sun 2-5."
+"ArchitecturalStyle": "High Rise"
+"AssociationAmenities": "Management"
+"AssociationFee2": "49.0"
+"AssociationFeeIncludes": "Common Areas,Hot Water,Maintenance Grounds,Maintenance Structure,Sewer,Water"
+"AssociationName": "Hale Kaheka"
+"AttributionContact": "(808) 735-4200"
+"BathroomsFull": 1
+"BuildingName": "Hale Kaheka"
+"CLIP": 1040827408
+"CommunityFeatures": "Barbecue,Community Pool,Trash Chute"
+"ConstructionMaterials": "Concrete"
+"CountyOrParish": "Oahu"
+"CreationDate": "2026-07-31T05:06:39.659002+00:00"
+"DaysOnMarket": 1
+"DaysOnMarketReplication": 1
+"DaysOnMarketReplicationDate": "2026-07-31"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "Owner Is Listing Agent"
+"EntryLevel": 36
+"Fencing": "Fenced, Wall"
+"Flooring": "Laminate"
+"Furnished": "Unfurnished"
+"HumanModifiedYN": true
+"Inclusions": "AC Window Unit,Auto Garage Door Opener,Ceiling Fan,Disposal,Drapes,Dryer,Microwave Hood,Refrigerator,Washer"
+"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level"
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"ListAgentDirectPhone": "(734) 548-3784"
+"ListAgentEmail": "christine.kim@locationshawaii.com"
+"ListAgentKey": "24538776"
+"ListAgentKeyNumeric": "24538776"
+"ListAgentOfficePhone": "(808) 735-4200"
+"ListAgentPreferredPhone": "(734) 548-3784"
+"ListAgentStateLicense": "RS-87387"
+"ListOfficeEmail": "darryl.macha@locationshawaii.com"
+"ListOfficeKey": "2586923"
+"ListOfficeKeyNumeric": "2586923"
+"ListOfficePhone": "(808) 735-4200"
+"ListingContractDate": "2026-07-30"
+"ListingKeyNumeric": 1178496595
+"ListingService": "Full Service"
+"MLSAreaMajor": "Metro"
+"MaintenanceExpense": 831.04
+"MajorChangeTimestamp": "2026-07-30T19:00:10Z"
+"MlsStatus": "Active"
+"OnMarketDate": "2026-07-30"
+"OriginalListPrice": 445000.0
+"OriginatingSystemKey": "19604841"
+"ParcelNumber": "1-2-3-018-017-0164"
+"ParkingFeatures": "Assigned,Covered,One Space"
+"ParkingTotal": "1.0"
+"PhotosChangeTimestamp": "2026-07-31T06:24:01Z"
+"PhotosCount": 9
+"PostalCity": "Honolulu"
+"PropertyCondition": "Good Condition,Updated/Remodeled"
+"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Key Card Entry,Security Guard"
+"SourceSystemKey": "1178496595"
+"SpecialListingConditions": "None"
+"StateOrProvince": "HI"
+"StreetName": "Kaheka"
+"StreetNumber": "930"
+"StreetNumberNumeric": "930"
+"StreetSuffix": "Streets"
+"SubdivisionName": "PAWAA"
+"TaxAnnualAmount": "1583.4"
+"TaxAssessedValue": 452400
+"UnitNumber": "3604"
+"View": "Mountain(s)"
+"ViewYN": true
+"YearBuiltEffective": 2012
+"ZoningDescription": "13 - A-3 High Density Apartment"
+"ListAOR": "HI Central"
+"LandTenure": "Fee Simple"
+"Permission": "IDX"
+"CustomFields": """
{\n
"ListingKey": "1178496595"\n
}
"""
+"AssociationFeeTotal": 880.0
+"TaxAssessedValueLand": "57200"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"PropertySubTypeAdditional": "Condominium"
+"TaxAssessedValueImprovement": "395200"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178496595')"
+"provider_name": "HICMLS"
+"RecordSignature": -74940332
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-018-017-0164"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "3485305"
+"OriginatingSystemListAgentMemberKey": "18181788"
+"Media": array:9 [ …9]
+"ID": "85622"
}
]
+success: true
+page_size: 9
+page_count: 520
+count: 4679
+after_key: ""
}
"RF Response Time" => "0.33 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=ListPrice DESC&$top=12&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#6453
+items: array:12 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6438
+post_id: "60005"
+post_author: 1
+"ListingKey": "1135674420"
+"ListingId": "202520629"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T21:24:03Z"
+"RFModificationTimestamp": "2026-07-27T21:27:48Z"
+"ListPrice": 55000000.0
+"BathroomsTotalInteger": 11.0
+"BathroomsHalf": 1
+"BedroomsTotal": 11.0
+"LotSizeArea": 89125.0
+"LivingArea": 10047.0
+"BuildingAreaTotal": 10047.0
+"City": "Honolulu"
+"PostalCode": "96816"
+"UnparsedAddress": "3735 Diamond Head Road, Honolulu, Hawaii 96816"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.2579311
+"Longitude": -157.8005757
+"YearBuilt": 1967
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Noel Pietsch Shaw"
+"ListOfficeName": "Hawaii Life"
+"ListAgentMlsId": "45076"
+"ListOfficeMlsId": "HLRE"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": "Located on Diamond Head Road, Ho‘oluana Estate is one of Honolulu’s last remaining legacy estate-sized properties, spanning over two acres across two adjacent parcels. Zoned R-7.5 and encompassing nearly 89,120 square feet, the estate features two residences and an open lot, offering sweeping ocean views, beachfront access, and exceptional flexibility for development or preservation. Perfectly positioned between Kahala and Waikiki, this property combines luxury, tranquility, and proximity to world-class surfing, shopping, dining, golf, hiking, and more. Offered as a singular acquisition under TMKs 1-3-1-039-042-0000 and 1-3-1-039-005-0000, Ho‘oluana Estate presents a rare opportunity to establish a landmark estate in one of Honolulu’s most prestigious locations. Property details may not match tax records. Last four digits of the listing TMK do not exist, these are used only for MLS entry purposes."
+"ArchitecturalStyle": "Detached, Multiplex"
+"AttributionContact": "(800) 667-5028"
+"BathroomsFull": 10
+"CLIP": 3075635095
+"CommunityFeatures": "Deck/Porch,Patio,Storage Facilities"
+"ConstructionMaterials": "Double Wall,Concrete,Wood Frame"
+"CountyOrParish": "Oahu"
+"CreationDate": "2025-10-02T19:18:04.593357+00:00"
+"DaysOnMarket": 302
+"DaysOnMarketReplication": 298
+"DaysOnMarketReplicationDate": "2026-07-27"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "None"
+"ExteriorFeatures": "Landscaping"
+"Fencing": "Fenced, Wall"
+"Flooring": "Ceramic Tile,Hardwood,Other"
+"FrontageType": "Oceanfront, Waterfront"
+"Furnished": "Unfurnished"
+"GarageYN": true
+"HumanModifiedYN": true
+"Inclusions": "AC Split,Blinds,Book Shelves,Dishwasher,Drapes,Lawn Sprinkler,Range/Oven,Refrigerator,Security System,Smoke Detector,Washer,Water Heater"
+"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level"
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"Levels": "Two"
+"ListAgentDirectPhone": "(800) 667-5028"
+"ListAgentEmail": "noelshaw@hawaiilife.com"
+"ListAgentKey": "10779096"
+"ListAgentKeyNumeric": "10779096"
+"ListAgentOfficePhone": "(800) 667-5028"
+"ListAgentPreferredPhone": "(800) 667-5028"
+"ListAgentStateLicense": "RS-75888"
+"ListOfficeEmail": "paloluckett@hawaiilife.com"
+"ListOfficeKey": "2588754"
+"ListOfficeKeyNumeric": "2588754"
+"ListOfficePhone": "(800) 667-5028"
+"ListingContractDate": "2025-10-02"
+"ListingKeyNumeric": 1135674420
+"ListingService": "Full Service"
+"LotFeatures": "Other, Level"
+"MLSAreaMajor": "Diamond Hd"
+"MajorChangeTimestamp": "2025-10-02T09:17:14Z"
+"MlsStatus": "Active"
+"OnMarketDate": "2025-10-02"
+"OriginalListPrice": 55000000.0
+"OriginatingSystemKey": "18987311"
+"OtherStructures": "Workshop"
+"ParcelNumber": "1-3-1-039-005-9999"
+"ParkingFeatures": "Boat,Driveway,Garage,Three or more Spaces"
+"ParkingTotal": "10.0"
+"PhotosChangeTimestamp": "2025-11-11T00:22:05Z"
+"PhotosCount": 11
+"PoolFeatures": "In Ground"
+"PostalCity": "Honolulu"
+"PropertyCondition": "Average Condition,Updated/Remodeled"
+"RoadFrontageType": "Private Road"
+"RoomType": "Entry/Foyer,Guest Quarters"
+"SecurityFeatures": "Key Card Entry"
+"SourceSystemKey": "1135674420"
+"SpecialListingConditions": "None"
+"StateOrProvince": "HI"
+"Stories": "2"
+"StreetName": "Diamond Head"
+"StreetNumber": "3735"
+"StreetNumberNumeric": "3735"
+"StreetSuffix": "Road"
+"SubdivisionName": "DIAMOND HEAD"
+"TaxAnnualAmount": "79104.0"
+"TaxAssessedValue": 14687400
+"Topography": "Level, Sloping"
+"Utilities": "Above Ground Utilities,Electricity Available,Water Available"
+"View": "Coastline, Garden, Mountain(s), Ocean"
+"ViewYN": true
+"WaterfrontYN": true
+"ZoningDescription": "04 - R-7.5 Residential District"
+"ListAOR": "HI Central"
+"LandTenure": "Fee Simple"
+"Permission": "IDX"
+"CustomFields": """
{\n
"ListingKey": "1135674420"\n
}
"""
+"TaxAssessedValueLand": "13794300"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"PropertySubTypeAdditional": "Single Family Residence"
+"TaxAssessedValueImprovement": "893100"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1135674420')"
+"provider_name": "HICMLS"
+"RecordSignature": 1707427824
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-3-1-039-005-9999"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "3487136"
+"OriginatingSystemListAgentMemberKey": "9493566"
+"Media": array:11 [ …11]
+"ID": "60005"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6440
+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": 922
+"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"
+"OriginatingSystemListAgentMemberKey": "16055746"
+"Media": array:21 [ …21]
+"ID": "48697"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6435
+post_id: "60006"
+post_author: 1
+"ListingKey": "1135674628"
+"ListingId": "202520630"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-27T21:20:41Z"
+"RFModificationTimestamp": "2026-07-27T21:22:17Z"
+"ListPrice": 43000000.0
+"BathroomsTotalInteger": 7.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 80249.0
+"LivingArea": 6213.0
+"BuildingAreaTotal": 6213.0
+"City": "Honolulu"
+"PostalCode": "96816"
+"UnparsedAddress": "3735- Diamond Head Road, Honolulu, Hawaii 96816"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.2579311
+"Longitude": -157.8005757
+"YearBuilt": 1967
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Noel Pietsch Shaw"
+"ListOfficeName": "Hawaii Life"
+"ListAgentMlsId": "45076"
+"ListOfficeMlsId": "HLRE"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": "Located on Diamond Head Road, Ho‘oluana Estate is one of Honolulu’s last remaining legacy estate-sized properties. Zoned R-7.5 and encompassing nearly 80,000 square feet, the estate features an expansive residences and several open lots, offering sweeping ocean views, private/deeded beachfront access, and exceptional flexibility for development or preservation. Perfectly positioned between Kahala and Waikiki, this property combines luxury, tranquility, and proximity to world-class surfing, shopping, dining, golf, hiking, and more. Neighboring property located at 3735 Diamond Head Road A, is also available for sale, presenting a rare opportunity to establish a landmark estate in one of Honolulu’s most prestigious locations. Property details may not match tax records."
+"ArchitecturalStyle": "Detached"
+"AttributionContact": "(800) 667-5028"
+"BathroomsFull": 6
+"CLIP": 3075635095
+"CommunityFeatures": "Deck/Porch,Patio"
+"ConstructionMaterials": "Masonry,Stucco,Wood Frame"
+"CountyOrParish": "Oahu"
+"CreationDate": "2025-10-02T19:29:44.087057+00:00"
+"DaysOnMarket": 302
+"DaysOnMarketReplication": 298
+"DaysOnMarketReplicationDate": "2026-07-27"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "None"
+"ExteriorFeatures": "Landscaping"
+"Fencing": "Fenced, Wall"
+"Flooring": "Ceramic Tile,Other"
+"Furnished": "Unfurnished"
+"GarageYN": true
+"HumanModifiedYN": true
+"Inclusions": "AC Split,Auto Garage Door Opener,Blinds,Book Shelves,Cable TV,Ceiling Fan,Chandelier,Dishwasher,Disposal,Drapes,Dryer,Lawn Sprinkler,Microwave,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater,Wine Refrigerator"
+"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level"
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"Levels": "Multi/Split"
+"ListAgentDirectPhone": "(800) 667-5028"
+"ListAgentEmail": "noelshaw@hawaiilife.com"
+"ListAgentKey": "10779096"
+"ListAgentKeyNumeric": "10779096"
+"ListAgentOfficePhone": "(800) 667-5028"
+"ListAgentPreferredPhone": "(800) 667-5028"
+"ListAgentStateLicense": "RS-75888"
+"ListOfficeEmail": "paloluckett@hawaiilife.com"
+"ListOfficeKey": "2588754"
+"ListOfficeKeyNumeric": "2588754"
+"ListOfficePhone": "(800) 667-5028"
+"ListingContractDate": "2025-10-02"
+"ListingKeyNumeric": 1135674628
+"ListingService": "Full Service"
+"LotFeatures": "Dead End,Other,Level"
+"MLSAreaMajor": "Diamond Hd"
+"MajorChangeTimestamp": "2025-10-02T09:27:12Z"
+"MlsStatus": "Active"
+"OnMarketDate": "2025-10-02"
+"OriginalListPrice": 43000000.0
+"OriginatingSystemKey": "18987344"
+"OtherStructures": "Workshop"
+"ParcelNumber": "1-3-1-039-005-0000"
+"ParkingFeatures": "Boat,Driveway,Garage,Three or more Spaces"
+"ParkingTotal": "10.0"
+"PhotosChangeTimestamp": "2025-11-11T00:25:10Z"
+"PhotosCount": 10
+"PoolFeatures": "In Ground"
+"PostalCity": "Honolulu"
+"PropertyCondition": "Average Condition,Updated/Remodeled"
+"RoadFrontageType": "Private Road"
+"RoomType": "Entry/Foyer,Guest Quarters"
+"SourceSystemKey": "1135674628"
+"SpecialListingConditions": "None"
+"StateOrProvince": "HI"
+"StreetName": "Diamond Head"
+"StreetNumber": "3735-"
+"StreetSuffix": "Road"
+"SubdivisionName": "DIAMOND HEAD"
+"TaxAnnualAmount": "35856.84"
+"TaxAssessedValue": 10244800
+"Topography": "Level, Sloping"
+"Utilities": "Above Ground Utilities,Electricity Available,Water Available"
+"View": "Coastline, Garden, Mountain(s), Ocean"
+"ViewYN": true
+"ZoningDescription": "04 - R-7.5 Residential District"
+"ListAOR": "HI Central"
+"LandTenure": "Fee Simple"
+"Permission": "IDX"
+"CustomFields": """
{\n
"ListingKey": "1135674628"\n
}
"""
+"TaxAssessedValueLand": "9351700"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"PropertySubTypeAdditional": "Single Family Residence"
+"TaxAssessedValueImprovement": "893100"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1135674628')"
+"provider_name": "HICMLS"
+"RecordSignature": -1456080520
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-3-1-039-005-0000"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "3487136"
+"OriginatingSystemListAgentMemberKey": "9493566"
+"Media": array:10 [ …10]
+"ID": "60006"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6442
+post_id: "63904"
+post_author: 1
+"ListingKey": "1149585343"
+"ListingId": "202528159"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T21:30:17Z"
+"RFModificationTimestamp": "2026-06-19T21:33:39Z"
+"ListPrice": 37500000.0
+"BathroomsTotalInteger": 9.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 35870.0
+"LivingArea": 21266.0
+"BuildingAreaTotal": 25641.0
+"City": "Honolulu"
+"PostalCode": "96816"
+"UnparsedAddress": "4324 Kaikoo Place, Honolulu, Hawaii 96816"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.2559373
+"Longitude": -157.7924155
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Anne Hogan Perry"
+"ListOfficeName": "Compass"
+"ListAgentMlsId": "21474"
+"ListOfficeMlsId": "COHI"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": "The Hemmeter Estate is a rare, oceanfront estate located at the end of Kaikoo Place on Black Point. Featuring an extraordinary 339.45 linear feet of ocean frontage, this property offers one of the most expansive coastal settings in Hawaii, with exceptional frontage in the heart of Kaikoo. Blending Hawaiian natural elements with European Renaissance–inspired design, the residence showcases exceptional craftsmanship throughout. Set on 35,870 sq ft of land, the estate offers approximately 21,266 sq ft of interior living, complemented by extensive covered and open lanais ideal for entertaining. Highlights include cast-bronze entry doors, coffered Venetian-inspired ceilings, Italian perlato marble staircases and flooring, carved and finished on-site, a two-story oceanfront living room, and refined Art Deco bronze detailing. Amenities include a private theater, library, entertaining lounge, and grotto pool. The expansive primary suite spans nearly 5,000 sq ft and features dual dressing rooms, a fitness area, and sweeping coastline views. The Hemmeter Estate is an irreplaceable oceanfront estate distinguished by scale, privacy, and architectural significance."
+"ArchitecturalStyle": "Detached"
+"AssociationFeeIncludes": "None, Sewer"
+"AttributionContact": "(808) 825-4277"
+"BathroomsFull": 7
+"CLIP": 8433100540
+"CommunityFeatures": "Deck/Porch,Other,Patio,Storage Facilities"
+"ConstructionMaterials": "Double Wall,Masonry,Concrete,Stone,Stucco"
+"CountyOrParish": "Oahu"
+"CreationDate": "2025-12-20T00:49:27.189342+00:00"
+"DaysOnMarket": 224
+"DaysOnMarketReplication": 182
+"DaysOnMarketReplicationDate": "2026-06-19"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "Seller Disclosure"
+"ExteriorFeatures": "Landscaping"
+"Fencing": "Fenced, Wall"
+"Flooring": "Carpet, Hardwood, Marble, Vinyl"
+"FoundationDetails": "Slab"
+"FrontageType": "Oceanfront"
+"Furnished": "Partially"
+"GarageYN": true
+"HumanModifiedYN": true
+"Inclusions": "AC Central,Attic Fan,Auto Garage Door Opener,Blinds,Book Shelves,Cable TV,Chandelier,Compactor,Dishwasher,Disposal,Drapes,Dryer,Fireplace,Heat Pump,Lawn Sprinkler,Microwave,Other,Refrigerator,Security System,Smoke Detector,Washer,Water Heater"
+"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": "Three Or More"
+"ListAgentDirectPhone": "(808) 286-6474"
+"ListAgentEmail": "anneperry@compass.com"
+"ListAgentKey": "10772330"
+"ListAgentKeyNumeric": "10772330"
+"ListAgentOfficePhone": "(808) 825-4277"
+"ListAgentPreferredPhone": "(808) 286-6474"
+"ListAgentStateLicense": "RB-15815"
+"ListOfficeEmail": "julie.meier@compass.com"
+"ListOfficeKey": "3944102"
+"ListOfficeKeyNumeric": "3944102"
+"ListOfficePhone": "(808) 825-4277"
+"ListingContractDate": "2025-12-19"
+"ListingKeyNumeric": 1149585343
+"ListingService": "Full Service"
+"LotFeatures": "Cleared,Interior Lot,Irregular Lot,Rim Lot,Level,Steep Slope"
+"MLSAreaMajor": "Diamond Hd"
+"MajorChangeTimestamp": "2025-12-19T14:48:18Z"
+"MlsStatus": "Active"
+"OnMarketDate": "2025-12-19"
+"OriginalListPrice": 37500000.0
+"OriginatingSystemKey": "19177734"
+"ParcelNumber": "1-3-1-041-031-0000"
+"ParkingFeatures": "Driveway,Garage,Three or more Spaces"
+"ParkingTotal": "8.0"
+"PhotosChangeTimestamp": "2025-12-20T05:22:01Z"
+"PhotosCount": 19
+"PoolFeatures": "Heated,In Ground,Pool"
+"PostalCity": "Honolulu"
+"PropertyCondition": "Average Condition,Updated/Remodeled"
+"RoadFrontageType": "County Road"
+"RoomType": "Entry/Foyer,Guest Quarters"
+"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry"
+"SourceSystemKey": "1149585343"
+"SpecialListingConditions": "None"
+"StateOrProvince": "HI"
+"StreetName": "Kaikoo"
+"StreetNumber": "4324"
+"StreetNumberNumeric": "4324"
+"StreetSuffix": "Place"
+"SubdivisionName": "DIAMOND HEAD"
+"TaxAnnualAmount": "160642.8"
+"TaxAssessedValue": 14740600
+"Topography": "Level, Sloping, Terraced"
+"Utilities": "Cable Available,Electricity Available,Natural Gas Available,High Speed Internet Available,Other,Phone Available,Sewer Available,Underground Utilities,Water Available"
+"View": "Coastline, Garden, Mountain(s), Ocean, Other, Sunset, Sunrise"
+"ViewYN": true
+"WaterSource": "Public"
+"YearBuiltEffective": 2019
+"ZoningDescription": "04 - R-7.5 Residential District"
+"ListAOR": "HI Central"
+"LandTenure": "Fee Simple"
+"Permission": "IDX"
+"CustomFields": """
{\n
"ListingKey": "1149585343"\n
}
"""
+"TaxAssessedValueLand": "9057100"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"PropertySubTypeAdditional": "Single Family Residence"
+"TaxAssessedValueImprovement": "5683500"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1149585343')"
+"provider_name": "HICMLS"
+"RecordSignature": -1809821479
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-3-1-041-031-0000"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "15465233"
+"OriginatingSystemListAgentMemberKey": "3474025"
+"Media": array:19 [ …19]
+"ID": "63904"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6439
+post_id: "65552"
+post_author: 1
+"ListingKey": "1150115320"
+"ListingId": "202600075"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-15T00:16:46Z"
+"RFModificationTimestamp": "2026-01-15T00:22:02Z"
+"ListPrice": 31000000.0
+"BathroomsTotalInteger": 10.0
+"BathroomsHalf": 1
+"BedroomsTotal": 9.0
+"LotSizeArea": 35175.0
+"LivingArea": 10326.0
+"BuildingAreaTotal": 10326.0
+"City": "Kailua"
+"PostalCode": "96734"
+"UnparsedAddress": "1240 Mokulua Drive, Kailua, Hawaii 96734"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.3874094
+"Longitude": -157.7121311
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Drew S Read"
+"ListOfficeName": "List Sotheby's Int'l Realty"
+"ListAgentMlsId": "32546"
+"ListOfficeMlsId": "LIST"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": "The Mokulua Estate is a breathtaking oceanfront sanctuary set within the prestigious Lanikai neighborhood. This exceptional property offers unobstructed views of the Mokulua Islands from nearly every vantage point. With over 150 linear feet of ocean frontage and a private gated entrance, the estate provides an ideal blend of seclusion, security, and harmony with its natural surroundings. Encompassing more than 10,000 square feet of refined indoor/outdoor living space, this state-of-the-art residence, designed by award winning architect Jim Jennings showcases dramatic ocean and mountain vistas throughout. A guest house and caretaker’s quarters ensure ample accommodation for family and guests. Direct ocean access from the backyard invites an active island lifestyle, from swimming and snorkeling to kayaking, surfing, fishing, or simply relaxing by the pool in your own tropical paradise. This is a rare, Once-In-A-Lifetime offering you won’t want to miss!!"
+"ArchitecturalStyle": "Detached"
+"AttributionContact": "(808) 735-2411"
+"BathroomsFull": 9
+"CommunityFeatures": "Deck/Porch,Patio,Storage Facilities"
+"ConstructionMaterials": "Double Wall,Steel Frame"
+"CountyOrParish": "Oahu"
+"CreationDate": "2026-01-14T18:29:52.754900+00:00"
+"DaysOnMarketReplicationDate": "2026-01-14"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "Seller Disclosure"
+"ExteriorFeatures": "Landscaping"
+"Fencing": "Fenced, Wall"
+"Flooring": "Hardwood, Other"
+"FoundationDetails": "Slab"
+"FrontageType": "Oceanfront"
+"Furnished": "Negotiable"
+"GarageYN": true
+"HumanModifiedYN": true
+"Inclusions": "AC Central,Auto Garage Door Opener,Blinds,Cable TV,Ceiling Fan,Dishwasher,Disposal,Dryer,Gas Grill,Lawn Sprinkler,Microwave,Range Hood,Range/Oven,Refrigerator,Security System,Smoke Detector,Washer,Water Heater"
+"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": "Two"
+"ListAgentDirectPhone": "(808) 782-3636"
+"ListAgentEmail": "realestate@drewread.com"
+"ListAgentKey": "10777874"
+"ListAgentKeyNumeric": "10777874"
+"ListAgentOfficePhone": "(808) 735-2411"
+"ListAgentPreferredPhone": "(808) 782-3636"
+"ListAgentStateLicense": "RS-67769"
+"ListOfficeEmail": "info@listsir.com"
+"ListOfficeKey": "2586183"
+"ListOfficeKeyNumeric": "2586183"
+"ListOfficePhone": "(808) 735-2411"
+"ListingContractDate": "2026-01-14"
+"ListingKeyNumeric": 1150115320
+"ListingService": "Full Service"
+"LotFeatures": "Cleared, Other, Level"
+"MLSAreaMajor": "Kailua"
+"MajorChangeTimestamp": "2026-01-14T08:24:46Z"
+"MlsStatus": "Active"
+"OnMarketDate": "2026-01-14"
+"OriginalListPrice": 31000000.0
+"OriginatingSystemKey": "19192479"
+"ParcelNumber": "1-4-3-005-094-0000"
+"ParkingFeatures": "Boat,Driveway,Garage,Three or more Spaces"
+"ParkingTotal": "9.0"
+"PhotosChangeTimestamp": "2026-01-14T17:54:00Z"
+"PhotosCount": 25
+"PoolFeatures": "In Ground,Pool,Pool/Spa Combo,Tile"
+"PostalCity": "Kailua"
+"PropertyCondition": "Excellent"
+"RoomType": "Entry/Foyer,Guest Quarters"
+"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry"
+"SourceSystemKey": "1150115320"
+"SpecialListingConditions": "None"
+"StateOrProvince": "HI"
+"Stories": "2"
+"StreetName": "Mokulua"
+"StreetNumber": "1240"
+"StreetNumberNumeric": "1240"
+"StreetSuffix": "Drive"
+"SubdivisionName": "LANIKAI"
+"TaxAnnualAmount": "139456.2"
+"TaxAssessedValue": 13531300
+"Topography": "Level"
+"Utilities": "Cable Available,Natural Gas Available,High Speed Internet Available,Other,Phone Available,Water Available"
+"View": "Coastline, Garden, Mountain(s), Ocean, Sunrise"
+"ViewYN": true
+"VirtualTourURLUnbranded": "https://bcove.video/49SY8mO"
+"WaterSource": "Public"
+"ZoningDescription": "03 - R10 - Residential District"
+"ListAOR": "HI Central"
+"LandTenure": "Fee Simple"
+"CustomFields": """
{\n
"ListingKey": "1150115320"\n
}
"""
+"TaxAssessedValueLand": "9963900"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"TaxAssessedValueImprovement": "3567400"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1150115320')"
+"provider_name": "HICMLS"
+"RecordSignature": 380820386
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-4-3-005-094-0000"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "9066313"
+"OriginatingSystemListAgentMemberKey": "3479420"
+"Media": array:25 [ …25]
+"DaysOnMarket": 198
+"ID": "65552"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6437
+post_id: "83762"
+post_author: 1
+"ListingKey": "1168782694"
+"ListingId": "202609850"
+"PropertyType": "Residential"
+"PropertySubType": "Condominium"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T22:06:09Z"
+"RFModificationTimestamp": "2026-06-10T21:17:08Z"
+"ListPrice": 30000000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 5743.0
+"BuildingAreaTotal": 6806.0
+"City": "Honolulu"
+"PostalCode": "96814"
+"UnparsedAddress": "1388 Ala Moana Boulevard 6800, Honolulu, Hawaii 96814"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.2914727
+"Longitude": -157.8437734
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Tomoko Yamamoto"
+"ListOfficeName": "Shimizu Gateways Inc"
+"ListAgentMlsId": "25082"
+"ListOfficeMlsId": "ASKA"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": """
A Rare Grand Penthouse Residence—An Exclusive Privilege Reserved for the Select Few.\r\n
It is your own private sanctuary, undisturbed by the outside world. Here, a unique vista and living space unfold—a setting found nowhere else on earth.\r\n
The yacht harbor and Waikiki skyline, bathed in the glow of the morning sun.\r\n
Ahead lies the lush greenery of Ala Moana Beach Park, stretching toward an endless expanse of blue sky and ocean.\r\n
As day turns to dusk, the sea begins to shimmer, shifting to hues of crimson and gold—ushering in that magical, radiant moment just before the sun dips below the horizon. A breathtaking vista, framed as if it were your own personal work of art.\r\n
Spanning an expansive 5,700 sqft living space , this residence is a true masterpiece—a harmonious fusion of residential grandeur and cutting-edge luxury.\r\n
Situated in the heart of Honolulu, it offers absolute privacy, allowing you to savor the profound serenity and liberation typically found only in a private villa.
"""
+"ArchitecturalStyle": "High Rise"
+"AssociationAmenities": "Concierge, Management"
+"AssociationFeeIncludes": "Common Areas,Cable TV,Gas,Internet"
+"AttributionContact": "(808) 922-2992"
+"BathroomsFull": 5
+"BuildingName": "Park Lane"
+"CLIP": 2717718708
+"CommunityFeatures": "Barbecue,Concierge,Clubhouse,Conference/Meeting Room,Fitness,Recreation Area,Trash Chute"
+"ConstructionMaterials": "Other"
+"Cooling": "Central Air"
+"CoolingYN": true
+"CountyOrParish": "Oahu"
+"CreationDate": "2026-05-20T18:19:54.541953+00:00"
+"DaysOnMarket": 72
+"DaysOnMarketReplication": 20
+"DaysOnMarketReplicationDate": "2026-06-09"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "Seller Disclosure"
+"EntryLevel": 8
+"Flooring": "Hardwood, Other"
+"FrontageType": "Other"
+"Furnished": "Furnished"
+"GarageYN": true
+"HumanModifiedYN": true
+"Inclusions": "AC Central,Cable TV,Dishwasher,Disposal,Dryer,Microwave,Range Hood,Refrigerator,Smoke Detector,Washer,Wine Refrigerator"
+"InteriorFeatures": "Single Living Level"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": "One"
+"ListAgentDirectPhone": "(808) 381-6193"
+"ListAgentEmail": "tomoko@gatewayshawaii.com"
+"ListAgentKey": "10763058"
+"ListAgentKeyNumeric": "10763058"
+"ListAgentOfficePhone": "(808) 922-2992"
+"ListAgentPreferredPhone": "(808) 381-6193"
+"ListAgentStateLicense": "RS-59381"
+"ListOfficeEmail": "Ctomita@askagateway.com"
+"ListOfficeKey": "2589164"
+"ListOfficeKeyNumeric": "2589164"
+"ListOfficePhone": "(808) 922-2992"
+"ListingContractDate": "2026-05-20"
+"ListingKeyNumeric": 1168782694
+"ListingService": "Full Service"
+"MLSAreaMajor": "Metro"
+"MaintenanceExpense": 10031.98
+"MajorChangeTimestamp": "2026-05-20T08:13:04Z"
+"MlsStatus": "Active"
+"OnMarketDate": "2026-05-20"
+"OriginalListPrice": 30000000.0
+"OriginatingSystemKey": "19469369"
+"ParcelNumber": "1-2-3-038-013-0156"
+"ParkingFeatures": "Assigned,Covered,Garage,Two Spaces"
+"ParkingTotal": "4.0"
+"PetsAllowed": "Call"
+"PhotosChangeTimestamp": "2026-05-20T04:48:00Z"
+"PhotosCount": 25
+"PostalCity": "Honolulu"
+"PropertyCondition": "Excellent"
+"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Key Card Entry,Security Guard"
+"SourceSystemKey": "1168782694"
+"SpecialListingConditions": "None"
+"StateOrProvince": "HI"
+"Stories": "1"
+"StreetName": "Ala Moana"
+"StreetNumber": "1388"
+"StreetNumberNumeric": "1388"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "ALA MOANA"
+"TaxAnnualAmount": "69804.0"
+"TaxAssessedValue": 20228800
+"UnitNumber": "6800"
+"View": "Coastline, City, Ocean, Sunset"
+"ViewYN": true
+"VirtualTourURLUnbranded": "https://player.vimeo.com/video/1198626520"
+"ZoningDescription": "33 - BMX-3 Community Business M"
+"ListAOR": "HI Central"
+"LandTenure": "Fee Simple"
+"Permission": "IDX"
+"CustomFields": """
{\n
"ListingKey": "1168782694"\n
}
"""
+"AssociationFeeTotal": 10032.0
+"TaxAssessedValueLand": "1002700"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"PropertySubTypeAdditional": "Condominium"
+"TaxAssessedValueImprovement": "19226100"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1168782694')"
+"provider_name": "HICMLS"
+"RecordSignature": -688526208
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-038-013-0156"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "10043148"
+"OriginatingSystemListAgentMemberKey": "3475175"
+"Media": array:25 [ …25]
+"ID": "83762"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7247
+post_id: "78421"
+post_author: 1
+"ListingKey": "1152870939"
+"ListingId": "202603726"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-02-12T02:42:08Z"
+"RFModificationTimestamp": "2026-02-12T02:44:56Z"
+"ListPrice": 26500000.0
+"BathroomsTotalInteger": 8.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 14297.0
+"LivingArea": 7324.0
+"BuildingAreaTotal": 9528.0
+"City": "Honolulu"
+"PostalCode": "96816"
+"UnparsedAddress": "213 Kaalawai Place, Honolulu, Hawaii 96816"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.2578467
+"Longitude": -157.7981772
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Beth Chang"
+"ListOfficeName": "Coldwell Banker Realty"
+"ListAgentMlsId": "00564"
+"ListOfficeMlsId": "CBPP"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": "Experience unmatched sophistication in this one-of-a-kind, award-winning home by Nicholson Companies, now available at an exceptional value—priced below the 2024 appraisal! This modern masterpiece, nestled in the prestigious Cove Area of Diamond Head, offers over 7,465 square feet of living space that seamlessly blends cutting-edge design with island inspiration. From the expansive living areas that capture breathtaking views to the advanced whole-house automation and security systems, this home is a true technological marvel. The chef's kitchen, featuring professional-grade appliances and a spacious butler’s pantry, is a culinary dream. Every corner reveals something extraordinary, from the exquisite interior finishes to the stunning outdoor oasis. This beachfront home represents the pinnacle of island living, now available at an exceptional price that underscores its unmatched quality and prestige. Seize the opportunity to own this extraordinary residence and make it your own private paradise."
+"ArchitecturalStyle": "Detached"
+"AssociationFeeIncludes": "None"
+"AttributionContact": "(808) 596-0456"
+"BathroomsFull": 7
+"CommunityFeatures": "Deck/Porch,Patio,Storage Facilities"
+"ConstructionMaterials": "Double Wall,Masonry,Stone,Stucco,Wood Frame"
+"CountyOrParish": "Oahu"
+"CreationDate": "2026-02-12T02:44:46.447710+00:00"
+"DaysOnMarketReplicationDate": "2026-02-11"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "Seller Disclosure"
+"ElementarySchool": "Kahala"
+"ExteriorFeatures": "Landscaping"
+"Fencing": "Fenced, Wall"
+"Flooring": "Hardwood, Other"
+"FoundationDetails": "Slab"
+"FrontageType": "Oceanfront, Waterfront"
+"Furnished": "Furnished"
+"GarageYN": true
+"HighSchool": "Kalani"
+"HumanModifiedYN": true
+"Inclusions": "AC Central,Auto Garage Door Opener,Blinds,Book Shelves,Cable TV,Ceiling Fan,Chandelier,Convection Oven,Dishwasher,Disposal,Drapes,Dryer,Gas Grill,Home Warranty,Lawn Sprinkler,Microwave,Photovoltaic - Owned,Range Hood,Range/Oven,Refrigerator,Security System,Smoke Detector,Washer,Water Heater,Wine Refrigerator"
+"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level"
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"Levels": "Two"
+"ListAgentDirectPhone": "(808) 478-7800"
+"ListAgentEmail": "Beth@Beth Chang.com"
+"ListAgentKey": "10773617"
+"ListAgentKeyNumeric": "10773617"
+"ListAgentOfficePhone": "(808) 596-0456"
+"ListAgentPreferredPhone": "(808) 478-7800"
+"ListAgentStateLicense": "RB-14022"
+"ListOfficeEmail": "mike.james@cbrealty.com"
+"ListOfficeKey": "2586830"
+"ListOfficeKeyNumeric": "2586830"
+"ListOfficePhone": "(808) 596-0456"
+"ListingContractDate": "2026-02-11"
+"ListingKeyNumeric": 1152870939
+"ListingService": "Full Service"
+"LotFeatures": "Dead End,Other,Level"
+"MLSAreaMajor": "Diamond Hd"
+"MajorChangeTimestamp": "2026-02-11T16:41:41Z"
+"MiddleOrJuniorSchool": "Kaimuki"
+"MlsStatus": "Active"
+"NewConstructionYN": true
+"OnMarketDate": "2026-02-11"
+"OriginalListPrice": 26500000.0
+"OriginatingSystemKey": "19272122"
+"ParcelNumber": "1-3-1-039-006-0000"
+"ParkingFeatures": "Driveway,Garage,Three or more Spaces,On Street"
+"ParkingTotal": "7.0"
+"PhotosChangeTimestamp": "2026-02-12T02:30:00Z"
+"PhotosCount": 22
+"PoolFeatures": "Heated,In Ground,Pool,Pool/Spa Combo,Tile"
+"PostalCity": "Honolulu"
+"PropertyCondition": "Excellent"
+"RoadFrontageType": "County Road"
+"RoomType": "Entry/Foyer"
+"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry"
+"Sewer": "Septic Tank"
+"SourceSystemKey": "1152870939"
+"SpecialListingConditions": "None"
+"StateOrProvince": "HI"
+"Stories": "2"
+"StreetName": "Kaalawai"
+"StreetNumber": "213"
+"StreetNumberNumeric": "213"
+"StreetSuffix": "Place"
+"SubdivisionName": "DIAMOND HEAD"
+"TaxAnnualAmount": "136257.12"
+"TaxAssessedValue": 12601500
+"Topography": "Level, Sloping"
+"Utilities": "Cable Available,Electricity Available,Natural Gas Available,High Speed Internet Available,Phone Available,Septic Available,Underground Utilities,Water Available"
+"View": "Garden, Mountain(s), Ocean, Sunset"
+"ViewYN": true
+"VirtualTourURLUnbranded": "http://player.vimeo.com/video/776731890"
+"WaterSource": "Public"
+"ZoningDescription": "04 - R-7.5 Residential District"
+"ListAOR": "HI Central"
+"LandTenure": "Fee Simple"
+"Permission": "IDX"
+"CustomFields": """
{\n
"ListingKey": "1152870939"\n
}
"""
+"TaxAssessedValueLand": "5872000"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"TaxAssessedValueImprovement": "6729500"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1152870939')"
+"provider_name": "HICMLS"
+"short_address": "Honolulu, Hawaii 96816, USA"
+"RecordSignature": 833412719
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-3-1-039-006-0000"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "3485212"
+"OriginatingSystemListAgentMemberKey": "8842402"
+"Media": array:22 [ …22]
+"DaysOnMarket": 170
+"ID": "78421"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6447
+post_id: "62427"
+post_author: 1
+"ListingKey": "1146362304"
+"ListingId": "202525519"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-17T20:15:22Z"
+"RFModificationTimestamp": "2025-11-17T20:17:36Z"
+"ListPrice": 24900000.0
+"BathroomsTotalInteger": 9.0
+"BathroomsHalf": 1
+"BedroomsTotal": 10.0
+"LotSizeArea": 40002.0
+"LivingArea": 7701.0
+"BuildingAreaTotal": 9535.0
+"City": "Waimanalo"
+"PostalCode": "96795"
+"UnparsedAddress": "41-471 Kalanianaole Highway, Waimanalo, Hawaii 96795"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.346304
+"Longitude": -157.7211
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Caron B Davis"
+"ListOfficeName": "Caron B Realty"
+"ListAgentMlsId": "16400"
+"ListOfficeMlsId": "CARB"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": """
Live among Hawaii's natural wonders & unsurpassed beauty at this extraordinary Pahonu Beach estate. Spanning\r\n
nearly 1 acre, this oceanfront property includes 152 linear feet along the Pacific Ocean. Nestled in a private, gated location, the 2 lot compound offers over 8600 sq ft of living area in its main house, guest house, cottage, and studio. Expansive lawns provide mesmerizing views across the ocean to Manama (Rabbit) Island and stunning vistas of the Koolau Mountains. The main house completed in 2022, sets a new standard of quality craftsmanship. Exceptional design, flawlessly executed using premium materials, creates a luxurious, beautiful, and comfortable home. Floor to ceiling sliding glass doors span the oceanfront side, providing spectacular views of the lush landscaping and ocean. The gourmet kitchen includes top of the line appliances, custom walnut cabinetry, and a disappearing pantry consistent with its sleek, modern design. Next door includes a 3BR oceanfront guest house, 2BR cottage and studio. This irreplaceable compound offers its next owner an opportunity to enjoy a spectacular lifestyle with family and friends in a magnificent oceanfront setting.
"""
+"ArchitecturalStyle": "Cottage, Detached, Multiplex"
+"AttributionContact": "(808) 593-9826"
+"BathroomsFull": 8
+"CommunityFeatures": "Deck/Porch,Patio,Storage Facilities"
+"ConstructionMaterials": "Double Wall,Masonry,Stone,Stucco,Wood Frame"
+"CountyOrParish": "Oahu"
+"CreationDate": "2025-11-15T00:50:25.114610+00:00"
+"DaysOnMarket": 259
+"DaysOnMarketReplication": 3
+"DaysOnMarketReplicationDate": "2025-11-17"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "Principal is Real Estate Licensed,Pet on Property,Seller Disclosure"
+"ElementarySchool": "Pope"
+"ExteriorFeatures": "Landscaping"
+"Fencing": "Fenced, Wall"
+"Flooring": "Hardwood, Laminate, Vinyl"
+"FrontageType": "Oceanfront, Waterfront"
+"Furnished": "Unfurnished"
+"GarageYN": true
+"HighSchool": "Kailua"
+"HumanModifiedYN": true
+"Inclusions": "AC Central,AC Split,Auto Garage Door Opener,Book Shelves,Cable TV,Ceiling Fan,Convection Oven,Dishwasher,Disposal,Drapes,Dryer,Intercom,Lawn Sprinkler,Microwave,Photovoltaic - Owned,Range Hood,Range/Oven,Refrigerator,Security System,Smoke Detector,Solar Heater,Washer,Water Heater,Wine Refrigerator"
+"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": "Two"
+"ListAgentDirectPhone": "(808) 286-5256"
+"ListAgentEmail": "caron@caronb.com"
+"ListAgentKey": "10778505"
+"ListAgentKeyNumeric": "10778505"
+"ListAgentOfficePhone": "(808) 593-9826"
+"ListAgentPreferredPhone": "(808) 286-5256"
+"ListAgentStateLicense": "RB-16594"
+"ListOfficeEmail": "caron@caronb.com"
+"ListOfficeKey": "2587957"
+"ListOfficeKeyNumeric": "2587957"
+"ListOfficePhone": "(808) 593-9826"
+"ListingContractDate": "2025-11-14"
+"ListingKeyNumeric": 1146362304
+"ListingService": "Full Service"
+"LotFeatures": "Cleared,Interior Lot,Level"
+"MLSAreaMajor": "Kailua"
+"MajorChangeTimestamp": "2025-11-14T14:44:23Z"
+"MiddleOrJuniorSchool": "Waimanalo"
+"MlsStatus": "Active"
+"OnMarketDate": "2025-11-14"
+"OriginalListPrice": 24900000.0
+"OriginatingSystemKey": "19120825"
+"ParcelNumber": "1-4-1-001-009-0000"
+"ParkingFeatures": "Driveway,Garage,Three or more Spaces"
+"ParkingTotal": "8.0"
+"PhotosChangeTimestamp": "2025-11-15T00:45:01Z"
+"PhotosCount": 25
+"PoolFeatures": "None"
+"PostalCity": "Waimanalo"
+"PropertyCondition": "Excellent, Updated/Remodeled"
+"RoomType": "Entry/Foyer,Guest Quarters"
+"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry"
+"Sewer": "Septic Tank"
+"SourceSystemKey": "1146362304"
+"SpecialListingConditions": "None"
+"StateOrProvince": "HI"
+"Stories": "2"
+"StreetName": "Kalanianaole"
+"StreetNumber": "41-471"
+"StreetSuffix": "Highway"
+"SubdivisionName": "WAIMANALO"
+"TaxAnnualAmount": "26820.48"
+"TaxAssessedValue": 8593200
+"Topography": "Level"
+"Utilities": "Cable Available,Electricity Available,High Speed Internet Available,Septic Available,Underground Utilities,Water Available"
+"View": "Coastline, Mountain(s), Ocean, Sunrise"
+"ViewYN": true
+"VirtualTourURLUnbranded": "https://player.vimeo.com/video/1025292189"
+"WaterSource": "Public"
+"YearBuiltEffective": 2022
+"ZoningDescription": "03 - R10 - Residential District"
+"ListAOR": "HI Central"
+"LandTenure": "Fee Simple"
+"CustomFields": """
{\n
"ListingKey": "1146362304"\n
}
"""
+"TaxAssessedValueLand": "8250300"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"TaxAssessedValueImprovement": "942900"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1146362304')"
+"provider_name": "HICMLS"
+"RecordSignature": 1243689075
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-4-1-001-009-0000"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "3486339"
+"OriginatingSystemListAgentMemberKey": "8834382"
+"Media": array:25 [ …25]
+"ID": "62427"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6448
+post_id: "81302"
+post_author: 1
+"ListingKey": "1156417565"
+"ListingId": "202606611"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T00:00:34Z"
+"RFModificationTimestamp": "2026-07-18T00:06:00Z"
+"ListPrice": 22000000.0
+"BathroomsTotalInteger": 10.0
+"BathroomsHalf": 2
+"BedroomsTotal": 6.0
+"LotSizeArea": 78776.0
+"LivingArea": 24899.0
+"BuildingAreaTotal": 24899.0
+"City": "Honolulu"
+"PostalCode": "96817"
+"UnparsedAddress": "51 Kepola Place, Honolulu, Hawaii 96817"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.3410646
+"Longitude": -157.8324384
+"YearBuilt": 1929
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Jovanna Giannasio-Fern"
+"ListOfficeName": "Hawaii Life"
+"ListAgentMlsId": "50415"
+"ListOfficeMlsId": "HLRE"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": """
When a residence transcends architecture, it becomes a work of art. Set across 1.81 acres in the misted beauty of Nuuanu, LIHIWAI is one of Hawaii’s most iconic historic estates, a rare convergence of land, design, and legacy in a truly cinematic setting.\r\n
\r\n
Originally built between 1927 and 1929 for Territorial Governor George R. Carter and designed by Bertram Grosvenor Goodhue, the home has been completely restored and is offered following a meticulous renovation by Welch & Weeks, a museum-quality restoration for modern living.\r\n
\r\n
Gracious volumes, natural light, and a refined material palette, including ohia hardwood, old-growth redwood, plaster, bronze windows, and limestone, create spaces that feel both expansive yet intimate.\r\n
\r\n
The four-bedroom, seven-bathroom main residence is complemented by two guest homes. The grounds unfold as a private sanctuary with a natural auwai, flowing stream, dramatic waterfall, and heated saltwater pool and spa.\r\n
\r\n
Set within Nuuanu Valley, this is a composition of historic pedigree, quiet luxury, and natural beauty. A legacy estate, now coming to market.
"""
+"ArchitecturalStyle": "Detached"
+"AttributionContact": "(800) 667-5028"
+"BathroomsFull": 8
+"CLIP": 2214049454
+"CarportYN": true
+"CommunityFeatures": "Deck/Porch,Patio,Storage Facilities,Gated"
+"CountyOrParish": "Oahu"
+"CreationDate": "2026-04-07T22:31:02.627924+00:00"
+"DaysOnMarket": 115
+"DaysOnMarketReplication": 101
+"DaysOnMarketReplicationDate": "2026-07-17"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "Seller Disclosure"
+"ExteriorFeatures": "Landscaping"
+"Fencing": "Fenced, Wall"
+"Flooring": "Hardwood, Marble"
+"FrontageType": "Canal"
+"Furnished": "Unfurnished"
+"Inclusions": "AC Central,Blinds,Book Shelves,Chandelier,Dishwasher,Disposal,Drapes,Dryer,Fireplace,Range Hood,Range/Oven,Refrigerator,Washer,Water Heater"
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"Levels": "Two"
+"ListAgentDirectPhone": "(808) 469-2289"
+"ListAgentEmail": "jovannagiannasiofern@hawaiilife.com"
+"ListAgentKey": "14992924"
+"ListAgentKeyNumeric": "14992924"
+"ListAgentOfficePhone": "(800) 667-5028"
+"ListAgentPreferredPhone": "(808) 469-2289"
+"ListAgentStateLicense": "RS-83081"
+"ListOfficeEmail": "paloluckett@hawaiilife.com"
+"ListOfficeKey": "2588754"
+"ListOfficeKeyNumeric": "2588754"
+"ListOfficePhone": "(800) 667-5028"
+"ListingContractDate": "2026-04-07"
+"ListingKeyNumeric": 1156417565
+"ListingService": "Full Service"
+"LotFeatures": "Other, Level"
+"MLSAreaMajor": "Metro"
+"MajorChangeTimestamp": "2026-04-07T10:39:25Z"
+"MlsStatus": "Active"
+"OnMarketDate": "2026-04-07"
+"OriginalListPrice": 22000000.0
+"OriginatingSystemKey": "19363551"
+"ParcelNumber": "1-2-2-050-012-0000"
+"ParkingFeatures": "Boat,Carport,Driveway,Three or more Spaces"
+"ParkingTotal": "10.0"
+"PhotosChangeTimestamp": "2026-06-28T01:28:01Z"
+"PhotosCount": 25
+"PoolFeatures": "Heated,In Ground,Pool"
+"PostalCity": "Honolulu"
+"PropertyCondition": "Excellent,Updated/Remodeled"
+"RoadFrontageType": "Private Road"
+"RoomType": "Entry/Foyer,Guest Quarters"
+"SecurityFeatures": "Closed Circuit Camera(s),Gated Community,Key Card Entry"
+"SourceSystemKey": "1156417565"
+"SpecialListingConditions": "None"
+"StateOrProvince": "HI"
+"Stories": "2"
+"StreetName": "Kepola"
+"StreetNumber": "51"
+"StreetNumberNumeric": "51"
+"StreetSuffix": "Place"
+"SubdivisionName": "DOWSETT"
+"TaxAnnualAmount": "9168.0"
+"TaxAssessedValue": 7230000
+"Topography": "Level"
+"Utilities": "Natural Gas Available,Water Available"
+"View": "City, Garden, Mountain(s), Ocean"
+"ViewYN": true
+"VirtualTourURLUnbranded": "https://player.vimeo.com/video/1161541588"
+"WaterSource": "Public"
+"YearBuiltEffective": 2012
+"ZoningDescription": "03 - R10 - Residential District"
+"ListAOR": "HI Central"
+"LandTenure": "Fee Simple"
+"Permission": "IDX"
+"CustomFields": """
{\n
"ListingKey": "1156417565"\n
}
"""
+"HumanModifiedYN": false
+"TaxAssessedValueLand": "6354500"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"PropertySubTypeAdditional": "Single Family Residence"
+"TaxAssessedValueImprovement": "2894600"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1156417565')"
+"provider_name": "HICMLS"
+"RecordSignature": 1814851695
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-2-050-012-0000"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "3487136"
+"OriginatingSystemListAgentMemberKey": "15200768"
+"Media": array:25 [ …25]
+"ID": "81302"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6446
+post_id: "77329"
+post_author: 1
+"ListingKey": "1150822839"
+"ListingId": "202600680"
+"PropertyType": "Residential"
+"PropertySubType": "Condominium"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-05T19:52:42Z"
+"RFModificationTimestamp": "2026-05-05T19:55:30Z"
+"ListPrice": 20000000.0
+"BathroomsTotalInteger": 7.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 6029.0
+"BuildingAreaTotal": 7792.0
+"City": "Kahuku"
+"PostalCode": "96731"
+"UnparsedAddress": "57-275 Kamehameha Highway 3/15, Kahuku, Hawaii 96731"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.679124
+"Longitude": -157.94838
+"YearBuilt": 2027
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Jason M Carey"
+"ListOfficeName": "Compass"
+"ListAgentMlsId": "45105"
+"ListOfficeMlsId": "COHI"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": """
North Shore Club | Penthouse Residence | Now Previewing. \r\n
The final direct beachfront Penthouse in Phase I offers a rare opportunity to acquire a signature legacy residence at the North Shore Club. This premier 6 bedroom, 6.5 bath residence offers over 7,820 livable square feet with 6,029 interior and 1,791 panoramic lanai space, a private pool, and sweeping ocean views. Designed for effortless island living, the residence showcases a grand-scale great room, bespoke finishes, and a seamless indoor-outdoor flow. Floor-to-ceiling openings frame uninterrupted Pacific vistas, while curated materials and architectural detailing create a timeless modern coastal aesthetic. Pre-construction design selections remain available, allowing for personalized interior finishes. Members enjoy world-class amenities including championship golf, resort pools, spa and wellness experiences, state-of-the-art fitness facilities, and curated dining. A truly irreplaceable beachfront legacy offering in one of Hawaii’s most coveted coastal settings, located walking distance to the Ritz-Carlton, O'ahu Turtle Bay Resort.
"""
+"ArchitecturalStyle": "Low Rise,Penthouse"
+"AssociationAmenities": "Concierge"
+"AssociationFeeIncludes": "Common Areas,Maintenance Grounds,Maintenance Structure,Sewer"
+"AttributionContact": "(808) 825-4277"
+"BathroomsFull": 6
+"BuildingName": "North Shore Club Residences"
+"CLIP": 8410501018
+"CommunityFeatures": "Concierge,Clubhouse,Community Pool,Fitness,Pool,Putting Green,Recreation Area,Restaurant,Storage Facilities,Tennis Court(s),Trails/Paths,Gated"
+"ConstructionMaterials": "Concrete,Steel Frame"
+"Cooling": "Central Air"
+"CoolingYN": true
+"CountyOrParish": "Oahu"
+"CreationDate": "2026-01-15T22:37:44.955039+00:00"
+"DaysOnMarket": 197
+"DaysOnMarketReplication": 110
+"DaysOnMarketReplicationDate": "2026-05-05"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "See Remarks"
+"EntryLevel": 3
+"Flooring": "Hardwood"
+"FrontageType": "Golf Course,Oceanfront,Preservation,Waterfront"
+"HumanModifiedYN": true
+"Inclusions": "AC Central,Chandelier,Convection Oven,Dishwasher,Disposal,Dryer,Range/Oven,Refrigerator,Security System,Smoke Detector,Washer"
+"InteriorFeatures": "Handicap Access,SingleLivingLevel"
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"Levels": "Three Or More,One"
+"ListAgentDirectPhone": "(808) 679-1698"
+"ListAgentEmail": "jason.carey@compass.com"
+"ListAgentKey": "10774113"
+"ListAgentKeyNumeric": "10774113"
+"ListAgentOfficePhone": "(808) 825-4277"
+"ListAgentPreferredPhone": "(808) 679-1698"
+"ListAgentStateLicense": "RS-76292"
+"ListOfficeEmail": "julie.meier@compass.com"
+"ListOfficeKey": "3944102"
+"ListOfficeKeyNumeric": "3944102"
+"ListOfficePhone": "(808) 825-4277"
+"ListingContractDate": "2026-01-15"
+"ListingKeyNumeric": 1150822839
+"ListingService": "Full Service"
+"MLSAreaMajor": "North Shore"
+"MaintenanceExpense": 6412.54
+"MajorChangeTimestamp": "2026-01-15T12:32:07Z"
+"MlsStatus": "Active"
+"NewConstructionYN": true
+"OnMarketDate": "2026-01-15"
+"OriginalListPrice": 20000000.0
+"OriginatingSystemKey": "19207865"
+"ParcelNumber": "1-5-7-001-050-0015"
+"ParkingFeatures": "Covered,Two Spaces,Secured"
+"ParkingTotal": "2.0"
+"PhotosChangeTimestamp": "2026-01-14T02:53:00Z"
+"PhotosCount": 14
+"PoolFeatures": "Heated"
+"PostalCity": "Kahuku"
+"PropertyCondition": "Excellent"
+"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Gated Community,Key Card Entry,Fire Sprinkler System,Security Guard"
+"SourceSystemKey": "1150822839"
+"SpaFeatures": "Community"
+"SpecialListingConditions": "None"
+"StateOrProvince": "HI"
+"StreetName": "Kamehameha"
+"StreetNumber": "57-275"
+"StreetSuffix": "Highway"
+"SubdivisionName": "KUILIMA"
+"TaxAnnualAmount": "22594.44"
+"TaxAssessedValue": 1625500
+"UnitNumber": "3/15"
+"View": "Coastline,Golf Course,Mountain(s),Ocean,Sunset,Sunrise"
+"ViewYN": true
+"ZoningDescription": "21 - Resort District"
+"ListAOR": "HI Central"
+"LandTenure": "Fee Simple"
+"Permission": "IDX"
+"CustomFields": """
{\n
"ListingKey": "1150822839"\n
}
"""
+"AssociationFeeTotal": 6413.0
+"TaxAssessedValueLand": "1625500"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"PropertySubTypeAdditional": "Condominium"
+"TaxAssessedValueImprovement": "0"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1150822839')"
+"provider_name": "HICMLS"
+"RecordSignature": -1615821810
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-5-7-001-050-0015"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "15465233"
+"OriginatingSystemListAgentMemberKey": "9512016"
+"Media": array:14 [ …14]
+"ID": "77329"
}
10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6444
+post_id: "85024"
+post_author: 1
+"ListingKey": "1178025606"
+"ListingId": "202614230"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Industrial"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T00:35:48Z"
+"RFModificationTimestamp": "2026-07-24T00:40:25Z"
+"ListPrice": 20000000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 57281.0
+"LivingArea": 0
+"BuildingAreaTotal": 68360.0
+"City": "Kapolei"
+"PostalCode": "96707"
+"UnparsedAddress": "2254 Lauwiliwili Street, Kapolei, Hawaii 96707"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.3187793
+"Longitude": -158.0916106
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Mark D Bratton"
+"ListOfficeName": "Bratton Realty Advisors Ltd"
+"ListAgentMlsId": "07998"
+"ListOfficeMlsId": "BRAT"
+"OriginatingSystemName": "HICMLS"
+"PublicRemarks": """
Presenting a prime opportunity for an owner/user in Kapolei, HI! 2254 Lauwiliwili Street, a beautiful, state-of-the-art office and industrial facility on 1.31 acres of I-2 zoned property in Kapolei Business Park Phase II — one of Oahu’s most supply-constrained submarkets. \r\n
\r\n
Built to institutional standards with no deferred maintenance, this modern facility features 30-foot clear heights, eight grade-level rollup doors, a concrete yard, ample parking, an executive-level office build-out, and an owned solar system that meaningfully reduces operating costs in Hawaii’s high-priced energy market.
"""
+"AttributionContact": "(808) 523-9708"
+"BuildingFeatures": "Private Restrooms,Public Restrooms"
+"BuildingName": "Na"
+"BusinessType": "Industrial"
+"CLIP": 3154029101
+"CommunityFeatures": "Business Center,Other"
+"ConstructionMaterials": "Block, Concrete"
+"Cooling": "Central Air"
+"CoolingYN": true
+"CountyOrParish": "Oahu"
+"CreationDate": "2026-07-24T00:40:21.276422+00:00"
+"DaysOnMarketReplicationDate": "2026-07-23"
+"DaysOnMarketReplicationIncreasingYN": true
+"Disclosures": "Call Agent"
+"ExistingLeaseType": "NNN"
+"Flooring": "Concrete"
+"HumanModifiedYN": true
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"ListAgentDirectPhone": "(808) 523-9708"
+"ListAgentEmail": "mark.bratton@colliers.com"
+"ListAgentKey": "10767452"
+"ListAgentKeyNumeric": "10767452"
+"ListAgentOfficePhone": "(808) 523-9708"
+"ListAgentPreferredPhone": "(808) 523-9708"
+"ListAgentStateLicense": "RB-14000"
+"ListOfficeEmail": "mark.bratton@colliers.com"
+"ListOfficeKey": "2587822"
+"ListOfficeKeyNumeric": "2587822"
+"ListOfficePhone": "(808) 523-9708"
+"ListingContractDate": "2026-07-23"
+"ListingKeyNumeric": 1178025606
+"ListingService": "Full Service"
+"MLSAreaMajor": "Ewaplain"
+"MajorChangeTimestamp": "2026-07-23T14:35:37Z"
+"MlsStatus": "Active"
+"OnMarketDate": "2026-07-23"
+"OriginalListPrice": 20000000.0
+"OriginatingSystemKey": "19596143"
+"ParcelNumber": "1-9-1-075-064-0000"
+"ParkingFeatures": "On Site"
+"PhotosChangeTimestamp": "2026-07-24T00:29:02Z"
+"PhotosCount": 13
+"PostalCity": "Kapolei"
+"PropertyCondition": "Excellent"
+"RoadFrontageType": "City Street"
+"SecurityFeatures": "Fire Sprinkler System"
+"Sewer": "Connected"
+"SourceSystemKey": "1178025606"
+"SpecialListingConditions": "None"
+"StateOrProvince": "HI"
+"StreetName": "Lauwiliwili"
+"StreetNumber": "2254"
+"StreetNumberNumeric": "2254"
+"StreetSuffix": "Street"
+"SubdivisionName": "KAPOLEI"
+"TaxAnnualAmount": "9308799.96"
+"TaxAssessedValue": 9308800
+"Utilities": "Electricity Available,Sewer Connected"
+"ZoningDescription": "42 - I-2 General Industrial Dis"
+"ListAOR": "HI Central"
+"LandTenure": "Fee Simple"
+"Permission": "IDX"
+"CustomFields": """
{\n
"ListingKey": "1178025606"\n
}
"""
+"TaxAssessedValueLand": "2577700"
+"OriginatingSystemSubName": "HICMLS_HBR"
+"PropertySubTypeAdditional": "Industrial,Commercial"
+"TaxAssessedValueImprovement": "6731100"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178025606')"
+"provider_name": "HICMLS"
+"short_address": "Kapolei, Hawaii 96707, USA"
+"RecordSignature": -273984813
+"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-1-075-064-0000"
+"CountrySubdivision": "15003"
+"OriginatingSystemListOfficeKey": "3486204"
+"OriginatingSystemListAgentMemberKey": "3472658"
+"Media": array:13 [ …13]
+"DaysOnMarket": 8
+"ID": "85024"
}
11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6450
+post_id: "79238"
+post_author: 1
+"ListingKey": "1153248272"
+"ListingId": "202604171"
+"PropertyType": "Land"
+"PropertySubType": "Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T23:02:19Z"
+"RFModificationTimestamp": "2026-07-07T23:05:12Z"
+"ListPrice": 19800000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 45271.0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Honolulu"
+"PostalCode": "96816"
+"UnparsedAddress": "4767 Kahala Avenue B&d, Honolulu, Hawaii 96816"
+"Coordinates": array:2 [ …2]
+"Latitude": 21.304547
+"Longitude": -157.855676
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Cedric Choi"
+"ListOfficeName": "Hawaii Life"
…94
}
]
+success: true
+page_size: 12
+page_count: 390
+count: 4679
+after_key: ""
}
"RF Response Time" => "0.28 seconds"
]
]