919 Properties
Sort by:
Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=18&$filter=(StandardStatus eq 'Active') and PropertyCondition eq 'Good Condition'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4687 +items: array:18 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4672 +post_id: "80012" +post_author: 1 +"ListingKey": "1155099026" +"ListingId": "202605522" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T03:01:20Z" +"RFModificationTimestamp": "2026-06-08T03:04:28Z" +"ListPrice": 310000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 574.0 +"BuildingAreaTotal": 574.0 +"City": "Honolulu" +"PostalCode": "96817" +"UnparsedAddress": "1515 Nuuanu Avenue 2155, Honolulu, Hawaii 96817" +"Coordinates": array:2 [ …2] +"Latitude": 21.3149171 +"Longitude": -157.8565805 +"YearBuilt": 1963 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Barry D Kaplan" +"ListOfficeName": "Savio Realty Ltd." +"ListAgentMlsId": "01917" +"ListOfficeMlsId": "HIHL" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "100% Hurricane Insurance Covered! Nicely renovated high floor in desirable Queen Tower, breathtaking DH and partial ocean view. Spacious 1/1 with 1 covered parking. Pet friendly (verify). Enjoy secured 8-acres well maintained garden with 8 BBQ areas, jogging/walking path, dog walking with dog waste bins, 2 pools including kiddie pool, 2 Tea Houses area available for social occasions, with bathrooms, full kitchen, tables and chairs. Nice Koi Pond, birds gathering peacefully. Super convenient location, walking distance to Downtown Business District, nice upscale restaurants and enjoy First Friday art district, Chinatown for shopping, Safeway/Longs Drugs are just across, Starbucks, Poke store, Modern Vietnamese Cuisine, Local restaurants are also across. Queens Medical Center, Kuakini Hospital are only a couple blocks away. Close to H-1 Freeway entrance both East and West bound. You will enjoy the sophisticated property. Don't miss this Gem-like life." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Gas,Hot Water,Sewer,Water" +"AttributionContact": "(808) 955-6672" +"BathroomsFull": 1 +"BuildingName": "Queen Emma Gardens" +"CLIP": 4602354600 +"CoListAgentDirectPhone": "(808) 728-0556" +"CoListAgentEmail": "yukah@savio.com" +"CoListAgentFullName": "Yuka Hayama" +"CoListAgentKey": "10778333" +"CoListAgentKeyNumeric": "10778333" +"CoListAgentMlsId": "43200" +"CoListAgentPreferredPhone": "(808) 728-0556" +"CoListOfficeEmail": "info@savio.com" +"CoListOfficeKey": "2587931" +"CoListOfficeKeyNumeric": "2587931" +"CoListOfficeMlsId": "HIHL" +"CoListOfficeName": "Savio Realty Ltd." +"CoListOfficePhone": "(808) 955-6672" +"CommunityFeatures": "Barbecue,Clubhouse,Conference/Meeting Room,Laundry Facilities,Playground,Pool,Recreation Area,Trails/Paths,Trash Chute" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-03-12T19:51:00.508425+00:00" +"DaysOnMarket": 88 +"DaysOnMarketReplication": 87 +"DaysOnMarketReplicationDate": "2026-06-07" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "See Remarks" +"ElementarySchool": "Royal" +"EntryLevel": 21 +"Flooring": "Vinyl" +"HighSchool": "Mckinley" +"Inclusions": "Range/Oven,Refrigerator,Smoke Detector" +"InteriorFeatures": "Single Living Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 864-1500" +"ListAgentEmail": "barryk@savio.com" +"ListAgentKey": "10777110" +"ListAgentKeyNumeric": "10777110" +"ListAgentOfficePhone": "(808) 955-6672" +"ListAgentPreferredPhone": "(808) 864-1500" +"ListAgentStateLicense": "RB-13675" +"ListOfficeEmail": "info@savio.com" +"ListOfficeKey": "2587931" +"ListOfficeKeyNumeric": "2587931" +"ListOfficePhone": "(808) 955-6672" +"ListingContractDate": "2026-03-12" +"ListingKeyNumeric": 1155099026 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1067.48 +"MajorChangeTimestamp": "2026-03-12T09:44:58Z" +"MiddleOrJuniorSchool": "Keelikolani" +"MlsStatus": "Active" +"OnMarketDate": "2026-03-12" +"OriginalListPrice": 310000.0 +"OriginatingSystemKey": "19333335" +"ParcelNumber": "1-2-1-005-004-0336" +"ParkingFeatures": "Assigned,Covered,Guest,One Space" +"ParkingTotal": "1.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-03-12T19:45:00Z" +"PhotosCount": 15 +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Key Card Entry,Security Guard" +"SourceSystemKey": "1155099026" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Nuuanu" +"StreetNumber": "1515" +"StreetNumberNumeric": "1515" +"StreetSuffix": "Avenue" +"SubdivisionName": "DOWNTOWN" +"TaxAnnualAmount": "1173.24" +"TaxAssessedValue": 329600 +"UnitNumber": "2155" +"View": "City, Mountain(s)" +"ViewYN": true +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1155099026"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1067.0 +"TaxAssessedValueLand": "94900" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "234700" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1155099026')" +"provider_name": "HICMLS" +"RecordSignature": -98113578 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-1-005-004-0336" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486313" +"OriginatingSystemCoListOfficeKey": "3486313" +"OriginatingSystemListAgentMemberKey": "3472099" +"OriginatingSystemCoListAgentMemberKey": "3483421" +"Media": array:15 [ …15] +"ID": "80012" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4674 +post_id: "83731" +post_author: 1 +"ListingKey": "1153080599" +"ListingId": "202603951" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T03:01:20Z" +"RFModificationTimestamp": "2026-06-08T03:04:30Z" +"ListPrice": 420000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 14767.0 +"LivingArea": 569.0 +"BuildingAreaTotal": 569.0 +"City": "Honolulu" +"PostalCode": "96813" +"UnparsedAddress": "255 Huali Street 204, Honolulu, Hawaii 96813" +"Coordinates": array:2 [ …2] +"Latitude": 21.312853 +"Longitude": -157.8510287 +"YearBuilt": 1986 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Bobby Okuda" +"ListOfficeName": "Corcoran Pacific Properties" +"ListAgentMlsId": "54235" +"ListOfficeMlsId": "ELIT" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Exceptional two-bedroom, one-bath unit in the deslrable Punchbowl Place condominium, with a versatile second bedroom ideal for use as a den, home office, or guest space. A perfect opportunity for first-time homebuyers or Investors. Convenlently located near Downtown Honolulu, Queen's Medical Center, and freeway access, this secure and pet-friendly building features a reasonable monthly maintenance fee. The bright and open unit offers in-unit washer/dryer, window A/C, and a secured covered parking stall. Enjoy the convenience of In-town living in a quiet, serene setting, just minutes from shopping, dining, and all that Honolulu has to offer." +"ArchitecturalStyle": "Low Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Sewer, Water" +"AttributionContact": "(808) 589-2040" +"BathroomsFull": 1 +"BuildingName": "Punchbowl Place" +"CLIP": 4417250200 +"CommunityFeatures": "Barbecue" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-05-18T19:38:27.976850+00:00" +"DaysOnMarket": 21 +"DaysOnMarketReplication": 20 +"DaysOnMarketReplicationDate": "2026-06-07" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"EntryLevel": 2 +"Flooring": "Laminate" +"Inclusions": "AC Window Unit,Blinds,Disposal,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"InteriorFeatures": "Handicap Access" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 258-1777" +"ListAgentEmail": "bobby.okuda@corcoranpacific.com" +"ListAgentKey": "24885461" +"ListAgentKeyNumeric": "24885461" +"ListAgentOfficePhone": "(808) 589-2040" +"ListAgentPreferredPhone": "(808) 258-1777" +"ListAgentStateLicense": "RS-87460" +"ListOfficeEmail": "ADMIN@corcoranpacific.com" +"ListOfficeKey": "2588385" +"ListOfficeKeyNumeric": "2588385" +"ListOfficePhone": "(808) 589-2040" +"ListingContractDate": "2026-05-18" +"ListingKeyNumeric": 1153080599 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 644.07 +"MajorChangeTimestamp": "2026-05-18T09:35:32Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-05-18" +"OriginalListPrice": 420000.0 +"OriginatingSystemKey": "19279132" +"ParcelNumber": "1-2-2-003-011-0011" +"ParkingFeatures": "Assigned,Covered,One Space" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-05-18T17:53:01Z" +"PhotosCount": 13 +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1153080599" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Huali" +"StreetNumber": "255" +"StreetNumberNumeric": "255" +"StreetSuffix": "Street" +"SubdivisionName": "PUNCHBOWL AREA" +"TaxAnnualAmount": "1512.0" +"TaxAssessedValue": 407400 +"UnitNumber": "204" +"View": "None" +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1153080599"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 644.0 +"TaxAssessedValueLand": "89600" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "317800" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1153080599')" +"provider_name": "HICMLS" +"RecordSignature": -1598886866 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-2-003-011-0011" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486767" +"OriginatingSystemListAgentMemberKey": "18248034" +"Media": array:13 [ …13] +"ID": "83731" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4671 +post_id: "84837" +post_author: 1 +"ListingKey": "1169934369" +"ListingId": "202610264" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T03:01:20Z" +"RFModificationTimestamp": "2026-06-08T04:13:38Z" +"ListPrice": 520000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 31886.0 +"LivingArea": 661.0 +"BuildingAreaTotal": 661.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "3017 Pualei Circle 216, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.2666832 +"Longitude": -157.8154699 +"YearBuilt": 1961 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Joelle A Foti" +"ListOfficeName": "Hawaii Modern Realty" +"ListAgentMlsId": "50707" +"ListOfficeMlsId": "BHHR02" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ This charming one-bedroom, one-bath condo at Diamond Head Ali‘i offers effortless island living in one of Honolulu’s most sought-after\r\n neighborhoods. Bright and breezy, this second-floor residence includes deeded parking and is ideally situated just moments from\r\n Kapiolani Park, sandy beaches, dining, shopping, and the vibrant energy of Waikiki. A perfect place to enjoy the best of coastal living. This\r\n is a well maintained and move-in ready with the convenience of a washer/dryer in the unit. Don't miss this opportunity to own in\r\n prestigious Pualei Circle, ideal for investment, a weekend retreat, or everyday island living. """ +"ArchitecturalStyle": "Low Rise" +"AssociationFeeIncludes": "Common Areas,Gas,Hot Water,Sewer,Water" +"AttributionContact": "(808) 792-3910" +"BathroomsFull": 1 +"BuildingName": "Diamond Head Alii" +"CLIP": 2962200721 +"CommunityFeatures": "Barbecue,Deck/Porch,Other,Patio,Pool" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-06-04T23:04:53.183168+00:00" +"DaysOnMarket": 4 +"DaysOnMarketReplication": 3 +"DaysOnMarketReplicationDate": "2026-06-07" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Waikiki" +"EntryLevel": 2 +"Flooring": "Vinyl" +"HighSchool": "Kalani" +"Inclusions": "Cable TV,Ceiling Fan,Dishwasher,Disposal,Dryer,Range/Oven,Refrigerator,Smoke Detector,Washer" +"InteriorFeatures": "Storage" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 792-3910" +"ListAgentEmail": "Joey.Foti@modernhawaii.com" +"ListAgentKey": "17824887" +"ListAgentKeyNumeric": "17824887" +"ListAgentOfficePhone": "(808) 792-3910" +"ListAgentPreferredPhone": "(808) 792-3910" +"ListAgentStateLicense": "RS-83344" +"ListOfficeEmail": "aloha@modernhawaii.com" +"ListOfficeKey": "2589176" +"ListOfficeKeyNumeric": "2589176" +"ListOfficePhone": "(808) 792-3910" +"ListingContractDate": "2026-06-04" +"ListingKeyNumeric": 1169934369 +"ListingService": "Full Service" +"MLSAreaMajor": "Diamond Hd" +"MaintenanceExpense": 714.49 +"MajorChangeTimestamp": "2026-06-04T12:58:20Z" +"MiddleOrJuniorSchool": "Kaimuki" +"MlsStatus": "Active" +"OnMarketDate": "2026-06-04" +"OpenParkingYN": true +"OriginalListPrice": 520000.0 +"OriginatingSystemKey": "19481121" +"ParcelNumber": "1-3-1-026-031-0046" +"ParkingFeatures": "Assigned,One Space" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-06-04T22:55:01Z" +"PhotosCount": 21 +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"SourceSystemKey": "1169934369" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Pualei" +"StreetNumber": "3017" +"StreetNumberNumeric": "3017" +"StreetSuffix": "Circle" +"SubdivisionName": "DIAMOND HEAD" +"TaxAnnualAmount": "1852.56" +"TaxAssessedValue": 529300 +"UnitNumber": "216" +"View": "None" +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1169934369"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 714.0 +"TaxAssessedValueLand": "131500" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "397800" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1169934369')" +"provider_name": "HICMLS" +"RecordSignature": 7543830 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-3-1-026-031-0046" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10102444" +"OriginatingSystemListAgentMemberKey": "15419177" +"Media": array:21 [ …21] +"ID": "84837" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4675 +post_id: "63745" +post_author: 1 +"ListingKey": "1145828522" +"ListingId": "202525018" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T03:01:20Z" +"RFModificationTimestamp": "2026-06-08T03:04:03Z" +"ListPrice": 459000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 95048.0 +"LivingArea": 1081.0 +"BuildingAreaTotal": 1081.0 +"City": "Honolulu" +"PostalCode": "96826" +"UnparsedAddress": "2499 Kapiolani Boulevard 3804, Honolulu, Hawaii 96826" +"Coordinates": array:2 [ …2] +"Latitude": 21.2869504 +"Longitude": -157.8238947 +"YearBuilt": 1979 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jennifer C Freas" +"ListOfficeName": "eXp Realty" +"ListAgentMlsId": "46532" +"ListOfficeMlsId": "EXPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Own this one-of-a-kind PH unit in Iolani Court Plaza! This unique and spacious 1081sf 1bedroom/1 bath unit comes with TWO full-size, side-by-side parking stalls. The PH floors have high 9’ ceilings, and a gorgeous glass line spans the length of this unit to offer beautiful mountain-to-ocean views. A 163sf enclosed glass den can be used as a second bedroom, office or craft studio - or, perhaps open the space to enlarge the entire unit. Upgrades include brand new carpet, new stainless steel kitchen appliances, and fresh paint. Central AC keeps the unit nice and cool, and electricity and cable/wifi are included with the fee. The building has sprinklers to comply with fire safety regulations. Iolani Court Plaza has a variety of amenities - pool, jacuzzi, BBQ grills, recreation room, grassy lounge area, tennis courts, pickleball court and a putting green. The building is conveniently near restaurants and shopping at Moiliili, McCully and UH Manoa. It is also close to the freeway on and off ramps, and by Iolani School." +"ArchitecturalStyle": "High Rise,Penthouse" +"AssociationFeeIncludes": "Common Areas,Cable TV,Electricity,HVAC,Hot Water,Internet,Sewer,Water" +"AttributionContact": "(808) 725-2794" +"BathroomsFull": 1 +"BuildingName": "Iolani Court Plaza" +"CLIP": 8388508282 +"CommunityFeatures": "Barbecue,Clubhouse,Community Pool,Deck/Porch,Patio,Putting Green,Recreation Area,Tennis Court(s),Trash Chute" +"ConstructionMaterials": "Masonry, Concrete, Stucco" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2025-12-15T20:29:09.822465+00:00" +"DaysOnMarket": 137 +"DaysOnMarketReplication": 136 +"DaysOnMarketReplicationDate": "2026-06-07" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 38 +"Flooring": "Carpet,Ceramic Tile" +"FrontageType": "Other" +"GarageYN": true +"Inclusions": "AC Central,Auto Garage Door Opener,Cable TV,Chandelier,Dishwasher,Disposal,Drapes,Dryer,Microwave Hood,Range/Oven,Refrigerator,Smoke Detector,Washer" +"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) 284-0808" +"ListAgentEmail": "jenfreas@gmail.com" +"ListAgentKey": "10779546" +"ListAgentKeyNumeric": "10779546" +"ListAgentOfficePhone": "(808) 725-2794" +"ListAgentPreferredPhone": "(808) 284-0808" +"ListAgentStateLicense": "RS-78856" +"ListOfficeEmail": "hi.broker@exprealty.net" +"ListOfficeKey": "2589160" +"ListOfficeKeyNumeric": "2589160" +"ListOfficePhone": "(808) 725-2794" +"ListingContractDate": "2025-12-15" +"ListingKeyNumeric": 1145828522 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1863.0 +"MajorChangeTimestamp": "2026-05-28T11:46:42Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-12-15" +"OriginalListPrice": 595000.0 +"OriginatingSystemKey": "19106103" +"ParcelNumber": "1-2-7-019-014-0336" +"ParkingFeatures": "Assigned,Covered,Garage,Guest,Two Spaces,Secured" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-01-20T08:08:00Z" +"PhotosCount": 23 +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry,Security Guard" +"SourceSystemKey": "1145828522" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kapiolani" +"StreetNumber": "2499" +"StreetNumberNumeric": "2499" +"StreetSuffix": "Boulevard" +"SubdivisionName": "KAPIOLANI" +"TaxAnnualAmount": "1548.0" +"TaxAssessedValue": 603600 +"UnitNumber": "3804" +"View": "City, Mountain(s), Ocean, Sunset" +"ViewYN": true +"ZoningDescription": "13 - A-3 High Density Apartment" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1145828522"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1863.0 +"TaxAssessedValueLand": "75200" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "528400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1145828522')" +"provider_name": "HICMLS" +"RecordSignature": -1760734239 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-7-019-014-0336" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10013908" +"OriginatingSystemListAgentMemberKey": "10334398" +"Media": array:23 [ …23] +"ID": "63745" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4673 +post_id: "83905" +post_author: 1 +"ListingKey": "1159207111" +"ListingId": "202608689" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T03:01:20Z" +"RFModificationTimestamp": "2026-06-08T03:04:03Z" +"ListPrice": 280000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 477.0 +"BuildingAreaTotal": 567.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "445 Kaiolu Street 212, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.2824894 +"Longitude": -157.8281232 +"YearBuilt": 1955 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Myron N Kiriu" +"ListOfficeName": "REMAX Hawaii" +"ListAgentMlsId": "17960" +"ListOfficeMlsId": "ADVG" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Rare Waikiki Gem with Parking! Experience the best of island living at Rosalei in the heart of Waikiki! This beautifully laid-out 1 bdrm/1 bath unit features a much sought-after open kitchen and a covered lanai perfect for breezy afternoons and entertaining. Location is everything—you are just minutes away from premier shopping/dining and world-famous Waikiki Beach. This unit includes 1 assigned covered parking space, a true luxury in the heart of Waikiki. A few photos have been virtually staged/enhanced." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Cable TV,Electricity,Hot Water,Internet,Sewer,Water" +"AttributionContact": "(808) 738-3600" +"BathroomsFull": 1 +"BuildingName": "Rosalei Ltd" +"CLIP": 2341191421 +"CommunityFeatures": "Community Pool,Deck/Porch,Laundry Facilities,Patio,Pool,Trash Chute" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-05-02T00:04:13.180103+00:00" +"DaysOnMarket": 38 +"DaysOnMarketReplication": 37 +"DaysOnMarketReplicationDate": "2026-06-07" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Jefferson" +"EntryLevel": 2 +"Flooring": "Carpet,Ceramic Tile,Vinyl" +"HighSchool": "Kaimuki" +"Inclusions": "Cable TV,Drapes,Range/Oven,Refrigerator" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level,Single Living Level" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 738-3633" +"ListAgentEmail": "Myron.Kiriu@remaxhawaii.com" +"ListAgentKey": "10767514" +"ListAgentKeyNumeric": "10767514" +"ListAgentOfficePhone": "(808) 738-3600" +"ListAgentPreferredPhone": "(808) 738-3633" +"ListAgentStateLicense": "RB-17242" +"ListOfficeEmail": "Francis.VanRafelghem@remaxhawaii.com" +"ListOfficeKey": "2589107" +"ListOfficeKeyNumeric": "2589107" +"ListOfficePhone": "(808) 738-3600" +"ListingContractDate": "2026-05-01" +"ListingKeyNumeric": 1159207111 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1313.91 +"MajorChangeTimestamp": "2026-05-01T13:58:04Z" +"MiddleOrJuniorSchool": "Washington" +"MlsStatus": "Active" +"OnMarketDate": "2026-05-01" +"OriginalListPrice": 280000.0 +"OriginatingSystemKey": "19426013" +"ParcelNumber": "1-2-6-017-004-0018" +"ParkingFeatures": "Assigned,Covered,One Space,On Street,Secured" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-05-01T22:49:02Z" +"PhotosCount": 20 +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1159207111" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kaiolu" +"StreetNumber": "445" +"StreetNumberNumeric": "445" +"StreetSuffix": "Street" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "1086.36" +"TaxAssessedValue": 281400 +"UnitNumber": "212" +"View": "Garden" +"ViewYN": true +"VirtualTourURLUnbranded": "https://www.youtube.com/embed/EE_dMpZtLKo?si=us0VYQsDFEfqu897" +"ZoningDescription": "X2 - Apartment Precinct" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1159207111"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1314.0 +"TaxAssessedValueLand": "52500" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "228900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1159207111')" +"provider_name": "HICMLS" +"RecordSignature": 1875195367 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-017-004-0018" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "9695164" +"OriginatingSystemListAgentMemberKey": "3473447" +"Media": array:20 [ …20] +"ID": "83905" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4670 +post_id: "84282" +post_author: 1 +"ListingKey": "1170114657" +"ListingId": "202610303" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T03:01:20Z" +"RFModificationTimestamp": "2026-06-08T03:04:14Z" +"ListPrice": 1250000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 3760.0 +"LivingArea": 1980.0 +"BuildingAreaTotal": 2116.0 +"City": "Waipahu" +"PostalCode": "96797" +"UnparsedAddress": "94-1037 Mauele Street, Waipahu, Hawaii 96797" +"Coordinates": array:2 [ …2] +"Latitude": 21.3953827 +"Longitude": -158.0343924 +"YearBuilt": 2002 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Adrienne W Lally" +"ListOfficeName": "Team Lally" +"ListAgentMlsId": "27165" +"ListOfficeMlsId": "LALY" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Open House on SUNDAY, 6/7 from 2-5pm. ***VA ASSUMABLE LOAN WITH A VERY LOW GAP!*** Welcome to your private retreat on the hillside of Waipahu. This spacious 4BR/3BA home offers nearly 2,000 sq. ft. of comfortable living area and is perfectly positioned on a rim lot with no back neighbors, ensuring a peaceful and private backyard experience. Energy efficiency is built-in with a fully owned, 16-panel PV system on the original NEM program, providing incredible utility savings for the new owner. Enjoy the perks of the Royal Kunia community, including neighborhood parks and close proximity to the Royal Kunia Shopping Center’s dining and retail hubs. With a functional layout and a prime location for commuting to military bases or downtown, this home checks every box. View 3D tours, video, and high-res photos via the virtual tour link (chain link icon)." +"ArchitecturalStyle": "Detached" +"AssociationFee": "67.0" +"AssociationName": "Royal Kunia" +"BathroomsFull": 3 +"CLIP": 2511495710 +"CoListAgentDirectPhone": "(808) 212-9188" +"CoListAgentEmail": "attilio@teamlally.com" +"CoListAgentFullName": "Attilio K Leonardi" +"CoListAgentKey": "10773033" +"CoListAgentKeyNumeric": "10773033" +"CoListAgentMlsId": "35469" +"CoListAgentPreferredPhone": "(808) 388-5466" +"CoListOfficeEmail": "info@teamlally.com" +"CoListOfficeKey": "6599790" +"CoListOfficeKeyNumeric": "6599790" +"CoListOfficeMlsId": "LALY" +"CoListOfficeName": "Team Lally" +"CoListOfficePhone": "(808) 212-9188" +"CommunityFeatures": "Deck/Porch,Patio" +"ConstructionMaterials": "Double Wall,Steel Frame,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-05-28T03:39:17.480885+00:00" +"DaysOnMarket": 12 +"DaysOnMarketReplication": 11 +"DaysOnMarketReplicationDate": "2026-06-07" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"Fencing": "Fenced, Wall" +"Flooring": "Carpet,Ceramic Tile,Hardwood" +"FoundationDetails": "Slab" +"GarageYN": true +"Inclusions": "AC Split,Auto Garage Door Opener,Blinds,Cable TV,Ceiling Fan,Dishwasher,Disposal,Drapes,Dryer,Lawn Sprinkler,Microwave Hood,Photovoltaic - Owned,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Solar Heater,Washer" +"InteriorFeatures": "Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 212-9188" +"ListAgentEmail": "adrienne@teamlally.com" +"ListAgentKey": "10777646" +"ListAgentKeyNumeric": "10777646" +"ListAgentOfficePhone": "(808) 212-9188" +"ListAgentPreferredPhone": "(808) 212-9188" +"ListAgentStateLicense": "RB-20068" +"ListOfficeEmail": "info@teamlally.com" +"ListOfficeKey": "6599790" +"ListOfficeKeyNumeric": "6599790" +"ListOfficePhone": "(808) 212-9188" +"ListingContractDate": "2026-05-27" +"ListingKeyNumeric": 1170114657 +"ListingService": "Full Service" +"LotFeatures": "Interior Lot,Rim Lot,Level,Zero Lot Line" +"MLSAreaMajor": "Waipahu" +"MajorChangeTimestamp": "2026-05-27T17:35:36Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-05-27" +"OriginalListPrice": 1250000.0 +"OriginatingSystemKey": "19482566" +"ParcelNumber": "1-9-4-164-004-0000" +"ParkingFeatures": "Driveway,Garage,Three or more Spaces,On Street" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-06-06T00:09:01Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Waipahu" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1170114657" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Mauele" +"StreetNumber": "94-1037" +"StreetSuffix": "Street" +"SubdivisionName": "ROYAL KUNIA" +"TaxAnnualAmount": "3264.96" +"TaxAssessedValue": 1052900 +"Topography": "Level, Sloping" +"Utilities": "Cable Available,Electricity Available,High Speed Internet Available,Other,Underground Utilities,Water Available" +"View": "Mountain(s)" +"ViewYN": true +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=c9ZWfNoHbLt&mls=1" +"WaterSource": "Public" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1170114657"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 67.0 +"TaxAssessedValueLand": "666600" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "386300" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1170114657')" +"provider_name": "HICMLS" +"RecordSignature": -629342305 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-4-164-004-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "19420368" +"OriginatingSystemCoListOfficeKey": "19420368" +"OriginatingSystemListAgentMemberKey": "3476808" +"OriginatingSystemCoListAgentMemberKey": "3480560" +"Media": array:25 [ …25] +"ID": "84282" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4665 +post_id: "80472" +post_author: 1 +"ListingKey": "1155402064" +"ListingId": "202605807" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T03:01:20Z" +"RFModificationTimestamp": "2026-06-08T03:04:16Z" +"ListPrice": 530000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1403.0 +"BuildingAreaTotal": 1477.0 +"City": "Honolulu" +"PostalCode": "96817" +"UnparsedAddress": "60 N Beretania Street 1202, Honolulu, Hawaii 96817" +"Coordinates": array:2 [ …2] +"Latitude": 21.3133027 +"Longitude": -157.8605353 +"YearBuilt": 1982 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Dean D Nguyen" +"ListOfficeName": "eXp Realty" +"ListAgentMlsId": "53529" +"ListOfficeMlsId": "EXPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "HUGE PRICE REDUCTION! Downtown Honolulu awaits! This spacious 3-bedroom, 2-bathroom has over 1400 sq. ft. of living space, featuring floor-to-ceiling windows with stunning ocean, mountain, and city views. Enjoy easy access to Chinatown's dining and shops, and the Financial District. This building is pet-friendly and VA-approved. The building offers amenities such as pool, jacuzzi,, and a picnic area with gas grills. It comes with two covered side-by-side parking stalls and 24/7 security. This home is move-in ready or for you to customize or upgrade. Monthly fees: $1,294.15 plus $998.07 reserves. Don't miss this rare opportunity for urban island living. Schedule your showing today!" +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Cable TV,Internet,Sewer,Water" +"AttributionContact": "(808) 725-2794" +"BathroomsFull": 2 +"BuildingName": "Honolulu Tower" +"CLIP": 8318649753 +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Community Pool,Trash Chute" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-03-23T16:31:43.940575+00:00" +"DaysOnMarket": 77 +"DaysOnMarketReplication": 76 +"DaysOnMarketReplicationDate": "2026-06-07" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Kauluwela" +"EntryLevel": 12 +"Flooring": "Carpet" +"Furnished": "Unfurnished" +"HighSchool": "Mckinley" +"Inclusions": "AC Window Unit,Blinds,Cable TV,Ceiling Fan,Dishwasher,Disposal,Dryer,Range Hood,Range/Oven,Refrigerator,Washer" +"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) 304-6697" +"ListAgentEmail": "deanhicalrealty@gmail.com" +"ListAgentKey": "22562578" +"ListAgentKeyNumeric": "22562578" +"ListAgentOfficePhone": "(808) 725-2794" +"ListAgentPreferredPhone": "(808) 304-6697" +"ListAgentStateLicense": "RS-86681" +"ListOfficeEmail": "hi.broker@exprealty.net" +"ListOfficeKey": "2589160" +"ListOfficeKeyNumeric": "2589160" +"ListOfficePhone": "(808) 725-2794" +"ListingContractDate": "2026-03-23" +"ListingKeyNumeric": 1155402064 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 2292.22 +"MajorChangeTimestamp": "2026-05-18T16:17:34Z" +"MiddleOrJuniorSchool": "Keelikolani" +"MlsStatus": "Active" +"OnMarketDate": "2026-03-23" +"OriginalListPrice": 585000.0 +"OriginatingSystemKey": "19341073" +"ParcelNumber": "1-1-7-005-011-0107" +"ParkingFeatures": "Covered,Two Spaces" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-03-18T00:12:00Z" +"PhotosCount": 25 +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry,Door Man,Fire Sprinkler System,Security Guard" +"SourceSystemKey": "1155402064" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetDirPrefix": "N" +"StreetName": "Beretania" +"StreetNumber": "60" +"StreetNumberNumeric": "60" +"StreetSuffix": "Street" +"SubdivisionName": "CHINATOWN" +"TaxAnnualAmount": "1913.76" +"TaxAssessedValue": 546800 +"UnitNumber": "1202" +"View": "City, Mountain(s), Ocean" +"ViewYN": true +"ZoningDescription": "34 - BMX-4 Central Business Mix" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1155402064"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 2292.0 +"TaxAssessedValueLand": "83400" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "463400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1155402064')" +"provider_name": "HICMLS" +"RecordSignature": 861898737 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-7-005-011-0107" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10013908" +"OriginatingSystemListAgentMemberKey": "17590309" +"Media": array:25 [ …25] +"ID": "80472" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4676 +post_id: "83388" +post_author: 1 +"ListingKey": "1159871621" +"ListingId": "202609331" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T03:01:20Z" +"RFModificationTimestamp": "2026-06-08T03:04:17Z" +"ListPrice": 499000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 30274.0 +"LivingArea": 662.0 +"BuildingAreaTotal": 776.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "2121 Ala Wai Boulevard 2506, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.2834158 +"Longitude": -157.8283023 +"YearBuilt": 1979 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Matthew Ball" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "50973" +"ListOfficeMlsId": "CBPP04" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "GORGEOUS panoramic VIEWS! RARE & highly desirable end unit on 06 stack! Enjoy sweeping mauka views of beautiful Manoa Valley with its iconic rainbow studded misty mornings & cool breezes. Evening views offer twinkling evening lights of charming St Louis Heights. Savor the rhythm of afternoon Ala Wai outrigger paddlers as they head to the ocean for sunset practice. This well-appointed 2 bedroom, 1 bath end unit with a spacious lanai has extra windows bringing\u{A0}\u{A0}beautiful island views into your home. Step inside. Serenity. Peace. Beauty. Stunning island views you’ll treasure. Enjoy resort-style island amenities including a beautiful pool area, BBQ, sauna, 24/7 security, and a gated parking garage with visitor parking. Whether you’re a busy professional seeking a peaceful escape, or looking to downsize into low-maintenance island living, is a perfect fit." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Cable TV,Electricity,Hot Water,Internet,None,Sewer,Water" +"AttributionContact": "(808) 262-3104" +"BathroomsFull": 1 +"BuildingName": "2121 Ala Wai" +"CLIP": 8628564373 +"CoListAgentDirectPhone": "(808) 262-3104" +"CoListAgentEmail": "atsuko.barth@cbrealty.com" +"CoListAgentFullName": "Atsuko Barth" +"CoListAgentKey": "10779809" +"CoListAgentKeyNumeric": "10779809" +"CoListAgentMlsId": "47141" +"CoListAgentPreferredPhone": "(808) 640-8286" +"CoListOfficeEmail": "mike.james@cbrealty.com" +"CoListOfficeKey": "2586332" +"CoListOfficeKeyNumeric": "2586332" +"CoListOfficeMlsId": "CBPP04" +"CoListOfficeName": "Coldwell Banker Realty" +"CoListOfficePhone": "(808) 262-3104" +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Clubhouse,Community Pool,Conference/Meeting Room,Deck/Porch,Patio,Recreation Area,Sauna,Trash Chute" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-05-12T23:13:08.800100+00:00" +"DaysOnMarket": 27 +"DaysOnMarketReplication": 26 +"DaysOnMarketReplicationDate": "2026-06-07" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 25 +"Flooring": "Ceramic Tile,Vinyl" +"GarageYN": true +"Inclusions": "AC Window Unit,Ceiling Fan,Disposal,Dryer,Microwave,Range Hood,Range/Oven,Refrigerator,Washer" +"InteriorFeatures": "Single Living Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 262-3104" +"ListAgentEmail": "matthew.ball@cbrealty.com" +"ListAgentKey": "18132561" +"ListAgentKeyNumeric": "18132561" +"ListAgentOfficePhone": "(808) 262-3104" +"ListAgentPreferredPhone": "(808) 262-3104" +"ListAgentStateLicense": "RS-83609" +"ListOfficeEmail": "mike.james@cbrealty.com" +"ListOfficeKey": "2586332" +"ListOfficeKeyNumeric": "2586332" +"ListOfficePhone": "(808) 262-3104" +"ListingContractDate": "2026-05-12" +"ListingKeyNumeric": 1159871621 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1159.0 +"MajorChangeTimestamp": "2026-06-01T13:12:50Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-05-12" +"OriginalListPrice": 520000.0 +"OriginatingSystemKey": "19454380" +"ParcelNumber": "1-2-6-017-003-0109" +"ParkingFeatures": "Assigned,Covered,Garage,Guest,One Space,Secured" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-05-12T07:09:00Z" +"PhotosCount": 20 +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry,Security Guard" +"SourceSystemKey": "1159871621" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Ala Wai" +"StreetNumber": "2121" +"StreetNumberNumeric": "2121" +"StreetSuffix": "Boulevard" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "1500.0" +"TaxAssessedValue": 547400 +"UnitNumber": "2506" +"View": "City, Mountain(s), Sunset" +"ViewYN": true +"YearBuiltEffective": 2020 +"ZoningDescription": "X2 - Apartment Precinct" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1159871621"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1159.0 +"TaxAssessedValueLand": "52400" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "495000" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1159871621')" +"provider_name": "HICMLS" +"RecordSignature": 288421979 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-017-003-0109" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3484714" +"OriginatingSystemCoListOfficeKey": "3484714" +"OriginatingSystemListAgentMemberKey": "15655242" +"OriginatingSystemCoListAgentMemberKey": "10826434" +"Media": array:20 [ …20] +"ID": "83388" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4677 +post_id: "77287" +post_author: 1 +"ListingKey": "1150562640" +"ListingId": "202600407" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T03:01:20Z" +"RFModificationTimestamp": "2026-06-08T03:04:30Z" +"ListPrice": 565000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 1211.0 +"BuildingAreaTotal": 1211.0 +"City": "Honolulu" +"PostalCode": "96825" +"UnparsedAddress": "501 Hahaione Street 1/7h, Honolulu, Hawaii 96825" +"Coordinates": array:2 [ …2] +"Latitude": 21.304547 +"Longitude": -157.855676 +"YearBuilt": 1975 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Chris Lee" +"ListOfficeName": "REMAX Hawaii" +"ListAgentMlsId": "46919" +"ListOfficeMlsId": "ADVG" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "This updated 2-bedroom, 1.5-bath condo with 2 parking spaces and storage, in the highly desirable Mauna Luan, offers over 1,200 sq. ft. of modern living space, featuring an open floor plan, an upgraded kitchen with stainless steel appliances, and hard surface flooring throughout. Enjoy stunning ocean and marina views, along with resort-style amenities, including two swimming pools (one heated), whirlpools, an exercise room, putting green, BBQ areas, recreation spaces, sauna, security, and more!" +"ArchitecturalStyle": "High Rise" +"AssociationFee2": "71.0" +"AssociationFeeIncludes": "Common Areas,Cable TV,Hot Water,Internet,Sewer,Water" +"AttributionContact": "(808) 738-3600" +"BathroomsFull": 1 +"BuildingName": "Mauna Luan" +"CLIP": 7643770550 +"CommunityFeatures": "Barbecue,Clubhouse,Community Pool,Conference/Meeting Room,Fitness,Pool,Putting Green,Recreation Area,Sauna,Storage Facilities,Trails/Paths,Trash Chute" +"ConstructionMaterials": "Double Wall,Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-01-09T19:35:31.655312+00:00" +"DaysOnMarket": 143 +"DaysOnMarketReplication": 142 +"DaysOnMarketReplicationDate": "2026-06-07" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Hahaione" +"EntryLevel": 7 +"Flooring": "Ceramic Tile,Vinyl" +"FoundationDetails": "Slab" +"HighSchool": "Kaiser" +"Inclusions": "Ceiling Fan,Chandelier,Dishwasher,Disposal,Drapes,Dryer,Microwave Hood,Range/Oven,Refrigerator,Washer" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level,Storage" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 223-9803" +"ListAgentEmail": "Chris.Lee@remaxhawaii.com" +"ListAgentKey": "10771891" +"ListAgentKeyNumeric": "10771891" +"ListAgentOfficePhone": "(808) 738-3600" +"ListAgentPreferredPhone": "(808) 223-9803" +"ListAgentStateLicense": "RS-78895" +"ListOfficeEmail": "Francis.VanRafelghem@remaxhawaii.com" +"ListOfficeKey": "2589107" +"ListOfficeKeyNumeric": "2589107" +"ListOfficePhone": "(808) 738-3600" +"ListingContractDate": "2026-01-09" +"ListingKeyNumeric": 1150562640 +"ListingService": "Full Service" +"MLSAreaMajor": "Hawaii Kai" +"MaintenanceExpense": 1410.85 +"MajorChangeTimestamp": "2026-05-04T08:58:40Z" +"MiddleOrJuniorSchool": "Niu Valley" +"MlsStatus": "Active" +"OnMarketDate": "2026-01-09" +"OriginalListPrice": 575000.0 +"OriginatingSystemKey": "19200235" +"ParcelNumber": "1-3-9-070-004-0070" +"ParkingFeatures": "Covered,Guest,Two Spaces" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-01-09T08:42:00Z" +"PhotosCount": 23 +"PoolFeatures": "Heated" +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Key Card Entry,Security Guard" +"SourceSystemKey": "1150562640" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Hahaione" +"StreetNumber": "501" +"StreetNumberNumeric": "501" +"StreetSuffix": "Street" +"SubdivisionName": "HAHAIONE-LOWER" +"TaxAnnualAmount": "1817.88" +"TaxAssessedValue": 620500 +"UnitNumber": "1/7H" +"View": "Canal, Garden, Mountain(s), Ocean" +"ViewYN": true +"VirtualTourURLUnbranded": "https://listings.hetproductions.com/sites/eeeabnk/unbranded" +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1150562640"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1482.0 +"TaxAssessedValueLand": "170200" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "450300" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1150562640')" +"provider_name": "HICMLS" +"RecordSignature": -2003222643 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-3-9-070-004-0070" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "9695164" +"OriginatingSystemListAgentMemberKey": "10679966" +"Media": array:23 [ …23] +"ID": "77287" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4678 +post_id: "84005" +post_author: 1 +"ListingKey": "1160008261" +"ListingId": "202609476" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T03:01:20Z" +"RFModificationTimestamp": "2026-06-08T03:04:16Z" +"ListPrice": 975000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 4503.0 +"LivingArea": 1727.0 +"BuildingAreaTotal": 1791.0 +"City": "Kapolei" +"PostalCode": "96707" +"UnparsedAddress": "91-1037 Lanakoi Street, Kapolei, Hawaii 96707" +"Coordinates": array:2 [ …2] +"Latitude": 21.3340079 +"Longitude": -158.077849 +"YearBuilt": 2000 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Adrienne W Lally" +"ListOfficeName": "Team Lally" +"ListAgentMlsId": "27165" +"ListOfficeMlsId": "LALY" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Open House on SUNDAY, 6/7 from 2-5pm\r\n \r\n *VA Loan Assumable with an interest rate of 3.625%*Rarely available CORNER LOT home in the Villages of Kapolei! This well-maintained 4-bed, 2.5-bath fee simple single-family home offers a two-story layout features high vaulted ceilings, a separate family room, and natural light throughout. Split ACs in every bedroom and living room — all 4 upstairs units professionally maintained and deep cleaned in April 2026, plus a brand new downstairs AC system installed in April 2026. A new water heater was also installed in December 2025, giving buyers peace of mind on major systems. Fully fenced backyard, 2-car enclosed garage plus driveway parking for 3+ vehicles. Built 2000 with concrete foundation, stucco exterior, double-wall construction, and concrete tile roof- all in good condition. Ceramic tile, laminate, and carpet flooring. Modern conveniences include dishwasher, range/oven, refrigerator, washer, dryer, microwave hood, security system, and ceiling fans. Prime central Kapolei location minutes from Kapolei Elementary, Middle & High School, Ka Makana Ali'i Mall, Villages of Kapolei Community Center/Pool, freeway access, restaurants, and shopping """ +"ArchitecturalStyle": "Detached" +"AssociationFee": "65.0" +"AssociationName": "Villages of Kapolei" +"BathroomsFull": 2 +"CLIP": 4061165268 +"CoListAgentDirectPhone": "(808) 212-9188" +"CoListAgentEmail": "alesia@teamlally.com" +"CoListAgentFullName": "Alesia J Borja" +"CoListAgentKey": "13402242" +"CoListAgentKeyNumeric": "13402242" +"CoListAgentMlsId": "49324" +"CoListAgentPreferredPhone": "(808) 687-1600" +"CoListOfficeEmail": "info@teamlally.com" +"CoListOfficeKey": "6599790" +"CoListOfficeKeyNumeric": "6599790" +"CoListOfficeMlsId": "LALY" +"CoListOfficeName": "Team Lally" +"CoListOfficePhone": "(808) 212-9188" +"ConstructionMaterials": "Double Wall,Masonry,Concrete,Stucco" +"CountyOrParish": "Oahu" +"CreationDate": "2026-05-22T18:19:22.807967+00:00" +"DaysOnMarket": 17 +"DaysOnMarketReplication": 16 +"DaysOnMarketReplicationDate": "2026-06-07" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"Fencing": "Fenced, Wall" +"Flooring": "Ceramic Tile,Laminate" +"FoundationDetails": "Slab" +"GarageYN": true +"Inclusions": "AC Split,Auto Garage Door Opener,Blinds,Ceiling Fan,Disposal,Dryer,Microwave Hood,Range/Oven,Refrigerator,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 212-9188" +"ListAgentEmail": "adrienne@teamlally.com" +"ListAgentKey": "10777646" +"ListAgentKeyNumeric": "10777646" +"ListAgentOfficePhone": "(808) 212-9188" +"ListAgentPreferredPhone": "(808) 212-9188" +"ListAgentStateLicense": "RB-20068" +"ListOfficeEmail": "info@teamlally.com" +"ListOfficeKey": "6599790" +"ListOfficeKeyNumeric": "6599790" +"ListOfficePhone": "(808) 212-9188" +"ListingContractDate": "2026-05-22" +"ListingKeyNumeric": 1160008261 +"ListingService": "Full Service" +"LotFeatures": "Corner Lot,Other,Level" +"MLSAreaMajor": "Ewaplain" +"MajorChangeTimestamp": "2026-05-22T08:17:06Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-05-22" +"OriginalListPrice": 975000.0 +"OriginatingSystemKey": "19458430" +"ParcelNumber": "1-9-1-091-124-0000" +"ParkingFeatures": "Driveway,Garage,Three or more Spaces" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-05-22T20:33:02Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Kapolei" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1160008261" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Lanakoi" +"StreetNumber": "91-1037" +"StreetSuffix": "Street" +"SubdivisionName": "KAPOLEI-IWALANI" +"TaxAnnualAmount": "300.0" +"TaxAssessedValue": 960000 +"Topography": "Level" +"Utilities": "Cable Available,Electricity Available,High Speed Internet Available,Other,Phone Available,Underground Utilities,Water Available" +"View": "None" +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=pYt1RxPS6ct&mls=1" +"WaterSource": "Public" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1160008261"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 65.0 +"TaxAssessedValueLand": "557000" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "403000" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1160008261')" +"provider_name": "HICMLS" +"RecordSignature": -1604774708 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-1-091-124-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "19420368" +"OriginatingSystemCoListOfficeKey": "19420368" +"OriginatingSystemListAgentMemberKey": "3476808" +"OriginatingSystemCoListAgentMemberKey": "14114104" +"Media": array:25 [ …25] +"ID": "84005" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4679 +post_id: "83863" +post_author: 1 +"ListingKey": "1159987896" +"ListingId": "202609445" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T03:01:20Z" +"RFModificationTimestamp": "2026-06-08T22:36:01Z" +"ListPrice": 830000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 1427635.0 +"LivingArea": 1489.0 +"BuildingAreaTotal": 1489.0 +"City": "Kaneohe" +"PostalCode": "96744" +"UnparsedAddress": "44-170 Laha Street 1804, Kaneohe, Hawaii 96744" +"Coordinates": array:2 [ …2] +"Latitude": 21.4177816 +"Longitude": -157.7629769 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Erin Ellis" +"ListOfficeName": "LUVA Real Estate" +"ListAgentMlsId": "48906" +"ListOfficeMlsId": "LUVA" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Welcome home to this beautifully maintained 3 bedroom, 2 bath condo in the heart of Kaneohe. Ideally situated on Oahu’s lush Windward side, this residence offers the perfect blend of comfort, convenience, and tasteful upgrades throughout. New doors and windows invite abundant natural light and cooling trade winds, creating a bright and welcoming island retreat. Enjoy close proximity to beaches, hiking trails, shopping, dining, and easy commuter access, all while experiencing the relaxed charm of Kaneohe living. This is a wonderful opportunity to own a move-in-ready home in one of Oahu’s most desirable communities. VA assumable mortgage an option for qualified buyers." +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Sewer,Water" +"AttributionContact": "(808) 262-5882" +"BathroomsFull": 2 +"BuildingName": "Yacht Club Terrace" +"CLIP": 2881535031 +"CoListAgentDirectPhone": "(808) 262-5882" +"CoListAgentEmail": "caroline@luvarealestate.com" +"CoListAgentFullName": "Caroline Randle" +"CoListAgentKey": "26621600" +"CoListAgentKeyNumeric": "26621600" +"CoListAgentMlsId": "54715" +"CoListAgentPreferredPhone": "(808) 379-5727" +"CoListOfficeEmail": "info@luvarealestate.com" +"CoListOfficeKey": "2589290" +"CoListOfficeKeyNumeric": "2589290" +"CoListOfficeMlsId": "LUVA" +"CoListOfficeName": "LUVA Real Estate" +"CoListOfficePhone": "(808) 262-5882" +"CommunityFeatures": "Barbecue,Clubhouse,Community Pool,Conference/Meeting Room,Deck/Porch,Patio,Pool,Trails/Paths" +"ConstructionMaterials": "Masonry,Concrete,Stucco,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-05-20T17:49:09.264347+00:00" +"DaysOnMarket": 19 +"DaysOnMarketReplication": 18 +"DaysOnMarketReplicationDate": "2026-06-07" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 1 +"Fencing": "Fenced, Wall" +"Flooring": "Ceramic Tile,Vinyl" +"Furnished": "Unfurnished" +"Inclusions": "AC Window Unit,Ceiling Fan,Dishwasher,Disposal,Drapes,Dryer,Range/Oven,Refrigerator,Smoke Detector,Solar Heater,Washer" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level,Storage" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Multi/Split" +"ListAgentDirectPhone": "(808) 772-0520" +"ListAgentEmail": "Erin@LuvaRealEstate.com" +"ListAgentKey": "13401443" +"ListAgentKeyNumeric": "13401443" +"ListAgentOfficePhone": "(808) 262-5882" +"ListAgentPreferredPhone": "(808) 772-0520" +"ListAgentStateLicense": "RB-24418" +"ListOfficeEmail": "info@luvarealestate.com" +"ListOfficeKey": "2589290" +"ListOfficeKeyNumeric": "2589290" +"ListOfficePhone": "(808) 262-5882" +"ListingContractDate": "2026-05-20" +"ListingKeyNumeric": 1159987896 +"ListingService": "Full Service" +"MLSAreaMajor": "Kaneohe" +"MaintenanceExpense": 1146.0 +"MajorChangeTimestamp": "2026-05-20T07:42:54Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-05-20" +"OpenParkingYN": true +"OriginalListPrice": 830000.0 +"OriginatingSystemKey": "19457598" +"ParcelNumber": "1-4-4-012-064-0110" +"ParkingFeatures": "Assigned,Guest,Two Spaces" +"ParkingTotal": "2.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-05-26T21:56:02Z" +"PhotosCount": 22 +"PoolFeatures": "Heated" +"PostalCity": "Kaneohe" +"PropertyCondition": "Good Condition" +"SourceSystemKey": "1159987896" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Laha" +"StreetNumber": "44-170" +"StreetSuffix": "Street" +"StructureType": "Townhouse" +"SubdivisionName": "COUNTRY CLUB" +"TaxAnnualAmount": "3034.56" +"TaxAssessedValue": 975000 +"UnitNumber": "1804" +"View": "Canal, Mountain(s), Ocean, Sunset" +"ViewYN": true +"ZoningDescription": "03 - R10 - Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1159987896"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1146.0 +"TaxAssessedValueLand": "309500" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium,Townhouse" +"TaxAssessedValueImprovement": "665500" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1159987896')" +"provider_name": "HICMLS" +"RecordSignature": -760675022 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-4-4-012-064-0110" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10833559" +"OriginatingSystemCoListOfficeKey": "10833559" +"OriginatingSystemListAgentMemberKey": "13011935" +"OriginatingSystemCoListAgentMemberKey": "18813706" +"Media": array:22 [ …22] +"ID": "83863" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4680 +post_id: "62525" +post_author: 1 +"ListingKey": "1146271652" +"ListingId": "202525458" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T03:01:20Z" +"RFModificationTimestamp": "2026-06-09T19:44:04Z" +"ListPrice": 399000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 799.0 +"BuildingAreaTotal": 896.0 +"City": "Mililani" +"PostalCode": "96789" +"UnparsedAddress": "95-2035 Waikalani Place B302, Mililani, Hawaii 96789" +"Coordinates": array:2 [ …2] +"Latitude": 21.4508308 +"Longitude": -158.0095783 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Cameron Chan" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "51490" +"ListOfficeMlsId": "CBPP02" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Welcome to Northbrook Melemanu in Waikalani! This spacious 2-bedroom, 1-bath condo offers 896 sqft of total living space and includes 2 parking stalls for added convenience. Remodeled in 2020, the unit features modern updates and a functional layout. Enjoy direct access from the parking garage, making loading and unloading a breeze, especially with no stairs from the 2nd-level garage to the front door. While stairs are present from the parking stall, the layout is ideal for easy drop-offs.\r\n One of the standout features of this home is its serene, unobstructed view of lush greenery and a peaceful stream—no buildings in front, just nature at your doorstep. Perfect for those who value privacy and a tranquil setting. Conveniently located near Schofield Barracks and Wheeler Army Airfield, in a quiet, forested valley between Mililani and Wahiawa. Home warranty included for added peace of mind! """ +"ArchitecturalStyle": "Low Rise,Multi-Level" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Cable TV,Sewer,Water" +"AssociationName": "8086271599" +"AttributionContact": "(808) 738-3904" +"BathroomsFull": 1 +"BuildingName": "Northbrook-Melemanu" +"CLIP": 4547138807 +"CommunityFeatures": "Barbecue,Community Pool,Deck/Porch,Patio,Pool,Trash Chute" +"ConstructionMaterials": "Hollow Tile,Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2025-11-14T18:25:08.304996+00:00" +"DaysOnMarket": 206 +"DaysOnMarketReplication": 205 +"DaysOnMarketReplicationDate": "2026-06-07" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure,See Remarks" +"EntryLevel": 3 +"Flooring": "Ceramic Tile" +"FrontageType": "Canal" +"Inclusions": "AC Window Unit,Cable TV,Ceiling Fan,Disposal,Dryer,Home Warranty,Other,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Washer" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 561-0642" +"ListAgentEmail": "cameron.chan@cbrealty.com" +"ListAgentKey": "18840541" +"ListAgentKeyNumeric": "18840541" +"ListAgentOfficePhone": "(808) 738-3904" +"ListAgentPreferredPhone": "(808) 561-0642" +"ListAgentStateLicense": "RS-84371" +"ListOfficeEmail": "mike.james@cbrealty.com" +"ListOfficeKey": "2586856" +"ListOfficeKeyNumeric": "2586856" +"ListOfficePhone": "(808) 738-3904" +"ListingContractDate": "2025-11-14" +"ListingKeyNumeric": 1146271652 +"ListingService": "Full Service" +"MLSAreaMajor": "Central" +"MaintenanceExpense": 1018.0 +"MajorChangeTimestamp": "2025-11-14T08:23:18Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-11-14" +"OpenParkingYN": true +"OriginalListPrice": 399000.0 +"OriginatingSystemKey": "19118536" +"ParcelNumber": "1-9-5-012-030-0032" +"ParkingFeatures": "Assigned,Guest,Two Spaces" +"ParkingTotal": "2.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2025-11-19T02:42:01Z" +"PhotosCount": 17 +"PostalCity": "Mililani" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Security Guard" +"SourceSystemKey": "1146271652" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Waikalani" +"StreetNumber": "95-2035" +"StreetSuffix": "Place" +"SubdivisionName": "WAIPIO ACRES/WAIKALANI WOODLANDS" +"TaxAnnualAmount": "1358.76" +"TaxAssessedValue": 388200 +"UnitNumber": "B302" +"View": "Mountain(s)" +"ViewYN": true +"YearBuiltEffective": 2020 +"ZoningDescription": "11 - A-1 Low Density Apartment" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1146271652"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1018.0 +"TaxAssessedValueLand": "126700" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "261500" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1146271652')" +"provider_name": "HICMLS" +"RecordSignature": -1565666906 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-5-012-030-0032" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485238" +"OriginatingSystemListAgentMemberKey": "15997770" +"Media": array:17 [ …17] +"ID": "62525" } 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4681 +post_id: "84075" +post_author: 1 +"ListingKey": "1167672244" +"ListingId": "202609700" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T03:01:20Z" +"RFModificationTimestamp": "2026-06-10T00:34:09Z" +"ListPrice": 595000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1129.0 +"BuildingAreaTotal": 1316.0 +"City": "Kapolei" +"PostalCode": "96707" +"UnparsedAddress": "92-936 Palailai Street 84, Kapolei, Hawaii 96707" +"Coordinates": array:2 [ …2] +"Latitude": 21.3340079 +"Longitude": -158.077849 +"YearBuilt": 1975 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Matt Householder" +"ListOfficeName": "Real Broker" +"ListAgentMlsId": "48599" +"ListOfficeMlsId": "RBLL" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Beautifully maintained 3-bedroom, 2-bath home in desirable Makakilo featuring a permitted full bathroom on the first floor for added flexibility and convenience. Freshly painted and move-in ready, this home welcomes you with cool island breezes, comfortable living spaces, and stunning ocean views. Enjoy indoor-outdoor living with a bright and airy layout perfect for relaxing or entertaining. Conveniently located near parks, schools, shopping, and freeway access while offering the peaceful charm of Makakilo living. Don’t miss this opportunity to own a well-cared-for home with comfort, functionality, and views all in one." +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,None,Sewer,Water" +"AttributionContact": "(855) 450-0442" +"BathroomsFull": 2 +"BuildingName": "Makakilo Mala 1" +"CLIP": 8486465989 +"CoListAgentDirectPhone": "(855) 450-0442" +"CoListAgentEmail": "move2oahu@gmail.com" +"CoListAgentFullName": "Cami Householder" +"CoListAgentKey": "26294030" +"CoListAgentKeyNumeric": "26294030" +"CoListAgentMlsId": "54625" +"CoListAgentPreferredPhone": "(808) 226-2826" +"CoListOfficeEmail": "realpbhawaii@gmail.com" +"CoListOfficeKey": "4102260" +"CoListOfficeKeyNumeric": "4102260" +"CoListOfficeMlsId": "RBLL" +"CoListOfficeName": "Real Broker" +"CoListOfficePhone": "(855) 450-0442" +"CommunityFeatures": "Community Pool" +"ConstructionMaterials": "Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-05-24T18:54:46.948760+00:00" +"DaysOnMarket": 15 +"DaysOnMarketReplication": 14 +"DaysOnMarketReplicationDate": "2026-06-07" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 1 +"Fencing": "Fenced, Wall" +"Flooring": "Ceramic Tile,Laminate" +"Furnished": "Unfurnished" +"Inclusions": "AC Window Unit,Ceiling Fan,Dishwasher,Disposal,Dryer,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"InteriorFeatures": "Full Bath on Main Level,Storage" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 294-7085" +"ListAgentEmail": "householderhomes@gmail.com" +"ListAgentKey": "10862891" +"ListAgentKeyNumeric": "10862891" +"ListAgentOfficePhone": "(855) 450-0442" +"ListAgentPreferredPhone": "(808) 294-7085" +"ListAgentStateLicense": "RB-23662" +"ListOfficeEmail": "realpbhawaii@gmail.com" +"ListOfficeKey": "4102260" +"ListOfficeKeyNumeric": "4102260" +"ListOfficePhone": "(855) 450-0442" +"ListingContractDate": "2026-05-24" +"ListingKeyNumeric": 1167672244 +"ListingService": "Full Service" +"MLSAreaMajor": "Makakilo" +"MaintenanceExpense": 561.0 +"MajorChangeTimestamp": "2026-05-24T08:48:58Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-05-24" +"OriginalListPrice": 595000.0 +"OriginatingSystemKey": "19465048" +"ParcelNumber": "1-9-2-019-016-0083" +"ParkingFeatures": "Assigned" +"ParkingTotal": "2.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-05-24T19:24:11Z" +"PhotosCount": 17 +"PostalCity": "Kapolei" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1167672244" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Palailai" +"StreetNumber": "92-936" +"StreetSuffix": "Street" +"StructureType": "Townhouse" +"SubdivisionName": "MAKAKILO-UPPER" +"TaxAnnualAmount": "1968.0" +"TaxAssessedValue": 576900 +"UnitNumber": "84" +"View": "Ocean, Sunset" +"ViewYN": true +"VirtualTourURLUnbranded": "https://realsee.ai/49kkWYZ2?theme=minimalist&unbranded=1" +"ZoningDescription": "11 - A-1 Low Density Apartment" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1167672244"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 561.0 +"TaxAssessedValueLand": "361500" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium,Townhouse" +"TaxAssessedValueImprovement": "215400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1167672244')" +"provider_name": "HICMLS" +"RecordSignature": 1701231853 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-2-019-016-0083" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15784376" +"OriginatingSystemCoListOfficeKey": "15784376" +"OriginatingSystemListAgentMemberKey": "12782211" +"OriginatingSystemCoListAgentMemberKey": "18723413" +"Media": array:17 [ …17] +"ID": "84075" } 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4682 +post_id: "84740" +post_author: 1 +"ListingKey": "1170845186" +"ListingId": "202610478" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T03:01:20Z" +"RFModificationTimestamp": "2026-06-08T03:04:14Z" +"ListPrice": 255000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 97749.0 +"LivingArea": 456.0 +"BuildingAreaTotal": 520.0 +"City": "Waianae" +"PostalCode": "96792" +"UnparsedAddress": "84-965 Farrington Highway A206, Waianae, Hawaii 96792" +"Coordinates": array:2 [ …2] +"Latitude": 21.446678 +"Longitude": -158.185272 +"YearBuilt": 1967 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Michael D DeMello" +"ListOfficeName": "Redfin Corporation" +"ListAgentMlsId": "25490" +"ListOfficeMlsId": "RFIN" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Sandy beachfront property! Amazing opportunity to own your very own piece of paradise from this beautifully upgraded 1-bedroom unit with breathtaking ocean and palm tree views. Relax at home to the soothing sounds of the Pacific Ocean right in your backyard. Tastefully designed with a tropical theme throughout, giving you that true Hawaii resort feel. The unit is in move-in ready condition and can even be conveyed fully furnished. Recent updates include the electrical panel, refrigerator, and luxury vinyl plank flooring in the bedroom. The building has also been undergoing numerous upgrades (please confirm details with management). Spalling work has already been completed, and there is a new security system in place along with security patrol. Upcoming improvements include climate-controlled elevators and laundry facilities, free Wi-Fi throughout the complex, new BBQ areas, and a Tesla robot arriving in November. The building is also transitioning from key fobs to facial and license plate recognition access. Put this incredible oceanfront retreat on your must-see list!" +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Sewer,Water" +"AttributionContact": "(808) 201-2821" +"BathroomsFull": 1 +"BuildingName": "Makaha Beach Cabanas" +"CLIP": 6280311017 +"CommunityFeatures": "Barbecue,Community Pool,Trash Chute,Gated" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-06-04T02:14:48.399606+00:00" +"DaysOnMarket": 5 +"DaysOnMarketReplication": 4 +"DaysOnMarketReplicationDate": "2026-06-07" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 2 +"Flooring": "Laminate" +"FrontageType": "Oceanfront, Waterfront" +"Inclusions": "AC Window Unit,Ceiling Fan,Disposal,Drapes,Kitchenware,Linens,Microwave Hood,Range/Oven,Refrigerator,Smoke Detector,Water Heater" +"InteriorFeatures": "Single Living Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More,One" +"ListAgentDirectPhone": "(808) 755-5052" +"ListAgentEmail": "mike.demello@redfin.com" +"ListAgentKey": "10777503" +"ListAgentKeyNumeric": "10777503" +"ListAgentOfficePhone": "(808) 201-2821" +"ListAgentPreferredPhone": "(808) 755-5052" +"ListAgentStateLicense": "RB-19192" +"ListOfficeEmail": "john.webb@redfin.com" +"ListOfficeKey": "2589083" +"ListOfficeKeyNumeric": "2589083" +"ListOfficePhone": "(808) 201-2821" +"ListingContractDate": "2026-06-03" +"ListingKeyNumeric": 1170845186 +"ListingService": "Full Service" +"MLSAreaMajor": "Leeward" +"MaintenanceExpense": 1093.16 +"MajorChangeTimestamp": "2026-06-03T16:12:25Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-06-03" +"OpenParkingYN": true +"OriginalListPrice": 255000.0 +"OriginatingSystemKey": "19487725" +"ParcelNumber": "1-8-4-004-014-0016" +"ParkingFeatures": "One Space,Secured,Unassigned" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-06-04T02:11:03Z" +"PhotosCount": 24 +"PostalCity": "Waianae" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Gated Community,Key Card Entry,Security Guard" +"SourceSystemKey": "1170845186" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Farrington" +"StreetNumber": "84-965" +"StreetSuffix": "Highway" +"SubdivisionName": "MAKAHA" +"TaxAnnualAmount": "1054.44" +"TaxAssessedValue": 293100 +"UnitNumber": "A206" +"View": "Coastline, Ocean, Sunset" +"ViewYN": true +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=KpPfYe8R4TS&mls=1" +"WaterfrontYN": true +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1170845186"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1093.0 +"TaxAssessedValueLand": "7700" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "285400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1170845186')" +"provider_name": "HICMLS" +"RecordSignature": -439708884 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-8-4-004-014-0016" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "9626004" +"OriginatingSystemListAgentMemberKey": "3475407" +"Media": array:24 [ …24] +"ID": "84740" } 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4683 +post_id: "61884" +post_author: 1 +"ListingKey": "1145718239" +"ListingId": "202524884" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T03:01:20Z" +"RFModificationTimestamp": "2026-06-08T03:04:17Z" +"ListPrice": 425000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 2.0 +"LotSizeArea": 73311.0 +"LivingArea": 870.0 +"BuildingAreaTotal": 870.0 +"City": "Aiea" +"PostalCode": "96701" +"UnparsedAddress": "98-310 Kamehameha Highway 217, Aiea, Hawaii 96701" +"Coordinates": array:2 [ …2] +"Latitude": 21.3822222 +"Longitude": -157.9336111 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Casey D Aytes" +"ListOfficeName": "Coldwell Banker Island Prop" +"ListAgentMlsId": "50402" +"ListOfficeMlsId": "CBIP04" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Back on the market! Move-in ready and priced to sell! This beautifully renovated 2-bedroom, 1.5-bath townhome with one assigned parking stall is centrally located in the heart of Aiea, just minutes from Pearlridge Center, Pearl Harbor, and with easy access to bus, rail, and freeway connections. Enjoy outdoor living at Blaisdell Park and along the Pearl Harbor bike path, perfect for biking, jogging, or leisurely walks. Inside, you’ll find a bright, open-concept layout filled with natural light and a fresh coat of paint throughout. Recent upgrades include a brand-new electric stove, washer and dryer, ceiling fans, front gate, and carpet on the stairs. Additional improvements feature updated electrical outlets, kitchen cabinets, closet shelving, water heater, and A/C units in both bedrooms for year-round comfort. Conveniently located near shopping, dining, and entertainment, this townhome offers the perfect blend of comfort, convenience, and value. Don’t miss this excellent opportunity in a desirable central Oahu location!" +"ArchitecturalStyle": "Multi-Level" +"AssociationFeeIncludes": "None, Sewer, Water" +"BathroomsFull": 1 +"BuildingName": "Waimalu Park" +"CLIP": 4204485959 +"CoListAgentDirectPhone": "(808) 875-7000" +"CoListAgentEmail": "luis.beza-cay@islandproperties.com" +"CoListAgentFullName": "Luis M Beza-Cay" +"CoListAgentKey": "22170046" +"CoListAgentKeyNumeric": "22170046" +"CoListAgentMlsId": "53095" +"CoListAgentPreferredPhone": "(787) 240-4618" +"CoListOfficeEmail": "steve.baker@islandproperties.com" +"CoListOfficeKey": "5227261" +"CoListOfficeKeyNumeric": "5227261" +"CoListOfficeMlsId": "CBIP04" +"CoListOfficeName": "Coldwell Banker Island Prop" +"CoListOfficePhone": "(808) 875-7000" +"CommunityFeatures": "Barbecue,Recreation Area" +"ConstructionMaterials": "Concrete,Single Wall,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-11-05T20:20:41.804416+00:00" +"DaysOnMarket": 196 +"DaysOnMarketReplication": 195 +"DaysOnMarketReplicationDate": "2026-06-07" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Waimalu" +"EntryLevel": 2 +"Fencing": "Fenced, Wall" +"Flooring": "Laminate" +"Furnished": "Unfurnished" +"HighSchool": "Aiea" +"Inclusions": "AC Window Unit,Cable TV,Ceiling Fan,Dishwasher,Disposal,Dryer,Microwave,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 875-7000" +"ListAgentEmail": "aytescd@yahoo.com" +"ListAgentKey": "14979683" +"ListAgentKeyNumeric": "14979683" +"ListAgentOfficePhone": "(808) 875-7000" +"ListAgentPreferredPhone": "(808) 875-7000" +"ListAgentStateLicense": "RS-83074" +"ListOfficeEmail": "steve.baker@islandproperties.com" +"ListOfficeKey": "5227261" +"ListOfficeKeyNumeric": "5227261" +"ListOfficePhone": "(808) 875-7000" +"ListingContractDate": "2025-11-04" +"ListingKeyNumeric": 1145718239 +"ListingService": "Full Service" +"MLSAreaMajor": "Pearl City" +"MaintenanceExpense": 554.0 +"MajorChangeTimestamp": "2026-05-22T09:08:10Z" +"MiddleOrJuniorSchool": "Aiea" +"MlsStatus": "Active" +"OnMarketDate": "2025-11-04" +"OpenParkingYN": true +"OriginalListPrice": 448000.0 +"OriginatingSystemKey": "19082215" +"ParcelNumber": "1-9-8-008-002-0037" +"ParkingFeatures": "Assigned,One Space,On Street" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-11-11T00:24:12Z" +"PhotosCount": 24 +"PostalCity": "Aiea" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Closed Circuit Camera(s)" +"SourceSystemKey": "1145718239" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Kamehameha" +"StreetNumber": "98-310" +"StreetSuffix": "Highway" +"StructureType": "Townhouse" +"SubdivisionName": "WAIMALU" +"TaxAnnualAmount": "1464.0" +"TaxAssessedValue": 417300 +"UnitNumber": "217" +"View": "None" +"ZoningDescription": "11 - A-1 Low Density Apartment" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1145718239"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 554.0 +"TaxAssessedValueLand": "180700" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium,Townhouse" +"TaxAssessedValueImprovement": "236600" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1145718239')" +"provider_name": "HICMLS" +"RecordSignature": 1472514154 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-8-008-002-0037" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "17472415" +"OriginatingSystemCoListOfficeKey": "17472415" +"OriginatingSystemListAgentMemberKey": "15185194" +"OriginatingSystemCoListAgentMemberKey": "17223255" +"Media": array:24 [ …24] +"ID": "61884" } 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4684 +post_id: "57951" +post_author: 1 +"ListingKey": "1128175950" +"ListingId": "202518498" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T03:01:20Z" +"RFModificationTimestamp": "2026-06-08T03:04:28Z" +"ListPrice": 1800000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1327.0 +"BuildingAreaTotal": 1327.0 +"City": "Honolulu" +"PostalCode": "96814" +"UnparsedAddress": "1001 Queen Street 1801, Honolulu, Hawaii 96814" +"Coordinates": array:2 [ …2] +"Latitude": 21.2948664 +"Longitude": -157.8529556 +"YearBuilt": 2018 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Joan KY Kashimoto" +"ListOfficeName": "Property Profiles, Inc." +"ListAgentMlsId": "23470" +"ListOfficeMlsId": "PPIN" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ This spacious 3-bedroom, 3-bath residence offers 1,327 sq. ft. of thoughtfully designed living space. The open-concept floor plan and wrap-around living room are framed by floor-to-ceiling windows that showcase sweeping ocean and sunset views with remote window shades. The modern kitchen is appointed with Bosch appliances and complemented by a separate laundry room for everyday convenience. The primary suite features a generous walk-in closet and a spa-inspired bathroom with dual vanities. This unit has an extra storage locker!\r\n Building Amenities include BBQ, Concierge, Exercise Room, Meeting Room, Patio/Deck, Pool, Recreation Area, Recreation Room, Resident Manager, Sauna, Storage, Car Wash Stall, Bike/Surfboard Storage and Trash Chute. Some photos are virtually enhanced. Request using Showing Time with an 8 hour notice. """ +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Concierge, Management" +"AssociationFee": "31.0" +"AssociationFee2": "272.0" +"AssociationFeeIncludes": "Common Areas,Hot Water,Internet,Sewer,Water" +"AttributionContact": "(808) 487-9500" +"BathroomsFull": 3 +"BuildingName": "Ae'o" +"CLIP": 5192178053 +"CoListAgentDirectPhone": "(808) 487-9500" +"CoListAgentEmail": "Berton@pro808.com" +"CoListAgentFullName": "Berton K Hamamoto" +"CoListAgentKey": "10773629" +"CoListAgentKeyNumeric": "10773629" +"CoListAgentMlsId": "01451" +"CoListAgentPreferredPhone": "(808) 383-7407" +"CoListOfficeEmail": "ppi@pro808.com" +"CoListOfficeKey": "2587181" +"CoListOfficeKeyNumeric": "2587181" +"CoListOfficeMlsId": "PPIN" +"CoListOfficeName": "Property Profiles, Inc." +"CoListOfficePhone": "(808) 487-9500" +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Concierge,Clubhouse,Conference/Meeting Room,Deck/Porch,Dog Park,Fitness,Patio,Pool,Recreation Area,Sauna,Storage Facilities,Trash Chute" +"ConstructionMaterials": "Other,Concrete,Steel Frame" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2025-08-26T20:07:56.967862+00:00" +"DaysOnMarket": 286 +"DaysOnMarketReplication": 285 +"DaysOnMarketReplicationDate": "2026-06-07" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Principal is Real Estate Licensed,Seller Disclosure" +"ElementarySchool": "Kaahumanu" +"EntryLevel": 18 +"Flooring": "Carpet,Ceramic Tile,Hardwood" +"FrontageType": "Other" +"Furnished": "Partially" +"HighSchool": "Mckinley" +"Inclusions": "AC Central,Convection Oven,Dishwasher,Disposal,Dryer,Microwave Hood,Range/Oven,Refrigerator,Washer,Water Heater" +"InteriorFeatures": "Handicap Access,Storage,Single Living Level" +"RFTransactionType": "For Sale" +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 487-9500" +"ListAgentEmail": "joni@pro808.com" +"ListAgentKey": "10773828" +"ListAgentKeyNumeric": "10773828" +"ListAgentOfficePhone": "(808) 487-9500" +"ListAgentPreferredPhone": "(808) 487-9500" +"ListAgentStateLicense": "RS-55246" +"ListOfficeEmail": "ppi@pro808.com" +"ListOfficeKey": "2587181" +"ListOfficeKeyNumeric": "2587181" +"ListOfficePhone": "(808) 487-9500" +"ListingContractDate": "2025-08-26" +"ListingKeyNumeric": 1128175950 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1380.69 +"MajorChangeTimestamp": "2025-08-26T10:01:52Z" +"MiddleOrJuniorSchool": "Keelikolani" +"MlsStatus": "Active" +"OnMarketDate": "2025-08-26" +"OriginalListPrice": 1800000.0 +"OriginatingSystemKey": "18937044" +"ParcelNumber": "1-2-3-002-106-0152" +"ParkingFeatures": "Assigned,Covered,Guest,Two Spaces" +"ParkingTotal": "2.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 25 +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Key Card Entry,Fire Sprinkler System,Security Guard" +"SourceSystemKey": "1128175950" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Queen" +"StreetNumber": "1001" +"StreetNumberNumeric": "1001" +"StreetSuffix": "Street" +"SubdivisionName": "KAKAAKO" +"TaxAnnualAmount": "14658.96" +"TaxAssessedValue": 1935000 +"UnitNumber": "1801" +"View": "Coastline, City, Ocean, Sunset" +"ViewYN": true +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1128175950"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1684.0 +"TaxAssessedValueLand": "98600" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "1836400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1128175950')" +"provider_name": "HICMLS" +"RecordSignature": -545456981 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-002-106-0152" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485563" +"OriginatingSystemCoListOfficeKey": "3485563" +"OriginatingSystemListAgentMemberKey": "8843155" +"OriginatingSystemCoListAgentMemberKey": "8842449" +"Media": array:25 [ …25] +"ID": "57951" } 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4685 +post_id: "81152" +post_author: 1 +"ListingKey": "1153501135" +"ListingId": "202604465" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T03:01:20Z" +"RFModificationTimestamp": "2026-06-08T03:04:29Z" +"ListPrice": 5990000.0 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 11752.0 +"LivingArea": 5897.0 +"BuildingAreaTotal": 6690.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "2999 Makalei Place, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.2580765 +"Longitude": -157.8156894 +"YearBuilt": 1931 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Myron N Kiriu" +"ListOfficeName": "REMAX Hawaii" +"ListAgentMlsId": "17960" +"ListOfficeMlsId": "ADVG" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "NEW LISTING!! Experience refined island luxury living in this executive-style 4-bedroom, 5.5-bath residence ideally positioned on the slopes of iconic Diamond Head. Encompassing nearly 5,900 sq ft of interior space on an 11,752 sq ft lot, this impressive home captures beautiful ocean and sunset views while offering exceptional indoor-outdoor living. Expansive lanai areas, complemented by a heated pool and spa, create a private retreat designed for effortless entertaining. Soaring ceilings enhance the home’s grand scale and invite abundant natural light throughout. The chef’s kitchen anchors the main living spaces, while separate guest quarters with a private entrance provide flexibility and privacy. Remodeled by Jeff Long in 1995, this distinguished property blends timeless design with a premier location just moments from Kapiolani Park, the Gold Coast, world-famous beaches, and renowned shopping and dining of Waikiki. A rare offering in one of Honolulu’s most prestigious neighborhoods." +"ArchitecturalStyle": "Detached" +"AttributionContact": "(808) 738-3600" +"BathroomsFull": 5 +"CLIP": 5169182661 +"CommunityFeatures": "Deck/Porch,Patio" +"ConstructionMaterials": "Double Wall,Masonry,Stucco" +"CountyOrParish": "Oahu" +"CreationDate": "2026-04-03T19:46:48.293656+00:00" +"DaysOnMarket": 66 +"DaysOnMarketReplication": 65 +"DaysOnMarketReplicationDate": "2026-06-07" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ExteriorFeatures": "Landscaping" +"Fencing": "Fenced, Wall" +"Flooring": "Ceramic Tile,Hardwood,Marble,Other,Vinyl" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"Inclusions": "AC Central,AC Split,Auto Garage Door Opener,Cable TV,Ceiling Fan,Chandelier,Convection Oven,Dishwasher,Disposal,Dryer,Microwave,Other,Range Hood,Refrigerator,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Two,Multi/Split" +"ListAgentDirectPhone": "(808) 738-3633" +"ListAgentEmail": "Myron.Kiriu@remaxhawaii.com" +"ListAgentKey": "10767514" +"ListAgentKeyNumeric": "10767514" +"ListAgentOfficePhone": "(808) 738-3600" +"ListAgentPreferredPhone": "(808) 738-3633" +"ListAgentStateLicense": "RB-17242" +"ListOfficeEmail": "Francis.VanRafelghem@remaxhawaii.com" +"ListOfficeKey": "2589107" +"ListOfficeKeyNumeric": "2589107" +"ListOfficePhone": "(808) 738-3600" +"ListingContractDate": "2026-04-03" +"ListingKeyNumeric": 1153501135 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Cul-De-Sac,Interior Lot,Level" +"MLSAreaMajor": "Diamond Hd" +"MajorChangeTimestamp": "2026-04-03T09:45:02Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-04-03" +"OriginalListPrice": 5990000.0 +"OriginatingSystemKey": "19293478" +"ParcelNumber": "1-3-1-035-026-0000" +"ParkingFeatures": "Driveway,Garage,Two Car Garage,Two Spaces" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-04-02T19:13:02Z" +"PhotosCount": 25 +"PoolFeatures": "In Ground,Pool,Pool/Spa Combo,Tile" +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"RoadFrontageType": "Private Road" +"RoomType": "Entry/Foyer,Guest Quarters" +"SecurityFeatures": "Key Card Entry" +"Sewer": "Cesspool" +"SourceSystemKey": "1153501135" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Makalei" +"StreetNumber": "2999" +"StreetNumberNumeric": "2999" +"StreetSuffix": "Place" +"SubdivisionName": "DIAMOND HEAD" +"TaxAnnualAmount": "62997.24" +"TaxAssessedValue": 6175200 +"Topography": "Level, Terraced" +"Utilities": "Cable Available,Electricity Available,Natural Gas Available,High Speed Internet Available,Underground Utilities,Water Available" +"View": "Mountain(s), Ocean, Sunset" +"ViewYN": true +"VirtualTourURLUnbranded": "https://listings.hetproductions.com/sites/2999-makalei-pl-honolulu-hi-96815-23446724/unbranded" +"WaterSource": "Public" +"YearBuiltEffective": 1995 +"ZoningDescription": "03 - R10 - Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1153501135"\n } """ +"HumanModifiedYN": false +"TaxAssessedValueLand": "4462300" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "1712900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1153501135')" +"provider_name": "HICMLS" +"RecordSignature": 657016899 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-3-1-035-026-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "9695164" +"OriginatingSystemListAgentMemberKey": "3473447" +"Media": array:25 [ …25] +"ID": "81152" } 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4686 +post_id: "84788" +post_author: 1 +"ListingKey": "1170848032" +"ListingId": "202610483" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-08T03:01:20Z" +"RFModificationTimestamp": "2026-06-08T03:04:02Z" +"ListPrice": 820000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 58806.0 +"LivingArea": 978.0 +"BuildingAreaTotal": 1023.0 +"City": "Honolulu" +"PostalCode": "96814" +"UnparsedAddress": "909 Kapiolani Boulevard 1101, Honolulu, Hawaii 96814" +"Coordinates": array:2 [ …2] +"Latitude": 21.2980848 +"Longitude": -157.8525468 +"YearBuilt": 2007 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Litton Ludwig" +"ListOfficeName": "List Sotheby's Int'l Realty" +"ListAgentMlsId": "48468" +"ListOfficeMlsId": "LIST" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Spacious and rare corner 2 bedroom, 2 bath residence featuring a private lanai with ocean, city, and sunset views. This desirable unit offers a well designed open floor plan, with bedrooms positioned on opposite ends for maximum privacy. Floor to ceiling windows fill the home with natural light, complemented by split AC units in every room for year round comfort. The modern kitchen is equipped with stainless steel appliances, a new KitchenAid refrigerator, and granite countertops, while thoughtful upgrades, including updated light fixtures, a kitchen backsplash, a sleek frameless shower door in the guest bathroom, a premium LG washer and dryer, and refined baseboards, reflect a level of care that truly sets this unit apart. Ideally located just minutes from Downtown Honolulu, Neal S. Blaisdell Center, Ala Moana Center, and Ward Village, you will enjoy effortless access to premier shopping, dining, and entertainment. This secure building offers an assigned parking stall in a secured garage, with ample guest parking. Enjoy excellent amenities, including a pool, Jacuzzi, BBQ area, fitness center, and meeting room. The building is pet friendly and 100% hurricane insured." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,None,Sewer,Water" +"AttributionContact": "(808) 735-2411" +"BathroomsFull": 2 +"BuildingName": "909 Kapiolani" +"CLIP": 4460784729 +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Clubhouse,Community Pool,Conference/Meeting Room,Deck/Porch,Fitness,Patio,Recreation Area,Trash Chute" +"ConstructionMaterials": "Double Wall,Concrete,Steel Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-06-04T20:50:05.269505+00:00" +"DaysOnMarket": 4 +"DaysOnMarketReplication": 3 +"DaysOnMarketReplicationDate": "2026-06-07" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 11 +"Flooring": "Vinyl" +"Inclusions": "AC Split,Auto Garage Door Opener,Blinds,Cable TV,Ceiling Fan,Dishwasher,Disposal,Dryer,Microwave,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 799-9733" +"ListAgentEmail": "lludwig@listsir.com" +"ListAgentKey": "10780813" +"ListAgentKeyNumeric": "10780813" +"ListAgentOfficePhone": "(808) 735-2411" +"ListAgentPreferredPhone": "(808) 799-9733" +"ListAgentStateLicense": "RB-23891" +"ListOfficeEmail": "info@listsir.com" +"ListOfficeKey": "2586183" +"ListOfficeKeyNumeric": "2586183" +"ListOfficePhone": "(808) 735-2411" +"ListingContractDate": "2026-06-04" +"ListingKeyNumeric": 1170848032 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1489.75 +"MajorChangeTimestamp": "2026-06-04T10:48:34Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-06-04" +"OriginalListPrice": 820000.0 +"OriginatingSystemKey": "19487834" +"ParcelNumber": "1-2-3-003-073-0040" +"ParkingFeatures": "Assigned,Covered,Guest,One Space,Secured" +"ParkingTotal": "1.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-06-04T21:00:02Z" +"PhotosCount": 25 +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Fire Sprinkler System,Security Guard" +"SourceSystemKey": "1170848032" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Kapiolani" +"StreetNumber": "909" +"StreetNumberNumeric": "909" +"StreetSuffix": "Boulevard" +"SubdivisionName": "KAKAAKO" +"TaxAnnualAmount": "3059.16" +"TaxAssessedValue": 764800 +"UnitNumber": "1101" +"View": "Coastline, City, Mountain(s), Ocean, Sunset" +"ViewYN": true +"YearBuiltEffective": 2020 +"ZoningDescription": "Kak – Kakaako Community Development Project" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1170848032"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1490.0 +"TaxAssessedValueLand": "102700" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "662100" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1170848032')" +"provider_name": "HICMLS" +"RecordSignature": 539006362 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-003-073-0040" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "9066313" +"OriginatingSystemListAgentMemberKey": "12647896" +"Media": array:25 [ …25] +"ID": "84788" } ] +success: true +page_size: 18 +page_count: 52 +count: 919 +after_key: "" } "RF Response Time" => "0.34 seconds" ] "RF Query: /Property?$select=ALL&$orderby=meta_value date DESC&$top=18&$filter=(StandardStatus eq 'Active') and PropertyCondition eq 'Good Condition'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#7464 +items: array:18 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7515 +post_id: "49346" +post_author: 1 +"ListingKey": "1104298135" +"ListingId": "202503343" +"PropertyType": "For Sale" +"PropertySubType": "Industrial" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-18T09:18:11Z" +"RFModificationTimestamp": "2025-11-18T09:21:21Z" +"ListPrice": 1215000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 21050.0 +"LivingArea": 0 +"BuildingAreaTotal": 5992.0 +"City": "Hilo" +"PostalCode": "96720" +"UnparsedAddress": "750 Kanoelehua Avenue, Hilo, Hawaii 96720" +"Coordinates": array:2 [ …2] +"Latitude": 19.706692815561 +"Longitude": -155.06405298303 +"YearBuilt": 2017 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Steven H Lau" +"ListOfficeName": "Lau & Associates, LLC" +"ListAgentMlsId": "26862" +"ListOfficeMlsId": "SLAU" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "This is a leasehold property. Prime commercial property for sale (leasehold) on busy Kanoelehua Ave., just minutes to Hilo International Airport. The center is known as Lehua Center and includes four retail spaces totaling 5,992 sq. ft. of leasable area. Each space has it's own private restroom and is individually metered for electricity. There are 25 parking stalls. The land area is 21,050 sq. ft. and is zoned MCX-20. The original 60 year ground lease has approximately 44 years remaining with known ground rents until 8/31/29. The fee is not available, but there is a first right of refusal. The entire property is leased to a single tenant until September 30, 2027. That tenant in turn subleases the individual spaces. Lessor is responsible for building exterior repairs and common area maintenance. Lessee is responsible maintaining the interior spaces. Priced below 2023 appraisal. Please DO NOT disturb tenants. Offer subject to inspection." +"AttributionContact": "(808) 223-0074" +"BuildingFeatures": "Public Restrooms" +"BuildingName": "None" +"BusinessType": "Recreation, Retail" +"CLIP": 9745378044 +"ConstructionMaterials": "Wood Frame" +"Cooling": "Other" +"CountyOrParish": "Hawaii" +"CreationDate": "2025-04-07T18:17:14.329597+00:00" +"DaysOnMarket": 468 +"DaysOnMarketReplication": 265 +"DaysOnMarketReplicationDate": "2025-11-17" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "See Remarks" +"EntryLevel": 1 +"ExistingLeaseType": "Other" +"Flooring": "Concrete" +"HumanModifiedYN": true +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LeaseAmount": "2932.0" +"LeaseExpiration": "2069-08-31" +"Levels": "One" +"ListAgentDirectPhone": "(808) 223-0074" +"ListAgentEmail": "slau@lauassociatesllc.com" +"ListAgentKey": "10777624" +"ListAgentKeyNumeric": "10777624" +"ListAgentOfficePhone": "(808) 223-0074" +"ListAgentPreferredPhone": "(808) 223-0074" +"ListAgentStateLicense": "RB-20307" +"ListOfficeEmail": "slau@lauassociates.com" +"ListOfficeKey": "2585552" +"ListOfficeKeyNumeric": "2585552" +"ListOfficePhone": "(808) 223-0074" +"ListingContractDate": "2025-02-25" +"ListingKeyNumeric": 1104298135 +"ListingService": "Full Service" +"MLSAreaMajor": "S. Hilo" +"MajorChangeTimestamp": "2025-09-19T00:31:47Z" +"MlsStatus": "Active" +"NetOperatingIncome": 106157.0 +"NumberOfUnitsTotal": "4" +"OnMarketDate": "2025-02-25" +"OperatingExpense": "89285.0" +"OriginalListPrice": 1350000.0 +"OriginatingSystemKey": "18528651" +"ParcelNumber": "3-2-2-037-029-0000" +"ParkingFeatures": "On Site" +"PhotosChangeTimestamp": "2025-11-11T00:21:13Z" +"PhotosCount": 24 +"PostalCity": "Hilo" +"PropertyCondition": "Good Condition" +"RoadFrontageType": "City Street" +"SecurityFeatures": "Fire Sprinkler System" +"Sewer": "Septic Tank" +"SourceSystemKey": "1104298135" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StoriesTotal": "1" +"StreetName": "Kanoelehua" +"StreetNumber": "750" +"StreetNumberNumeric": "750" +"StreetSuffix": "Avenue" +"SubdivisionName": "WAIAKEA HSELOTS" +"TaxAnnualAmount": "16020.0" +"TaxAssessedValue": 1496100 +"TenantPays": "Common Area Maintenance,Electricity,Gas,HVAC Maintenance,Insurance,Other Tax,Taxes,Trash Collection,Water" +"TotalActualRent": 16287.0 +"Utilities": "Electricity Available,Natural Gas Available" +"YearEstablished": 2017 +"ZoningDescription": "Neighbor Island - See Remarks" +"ListAOR": "HI Central" +"LandTenure": "Lease Hold" +"CustomFields": """ {\n "IncomeInformationSource": "Owner",\n "StreetViewParam": "1$19.707853$-155.064683$337.73$13.33$1.00$CAoSLEFGMVFpcFBOTUVNeTBNVGF0ZV9ZQ1o2Q0dIVzM4NjdpeVVfd2pVOHZEb0d2",\n "CompensationSubjectTo": "",\n "SQFTInterior": "5992",\n "TaxPaidBySellerYN": "",\n "LockBoxModDT": "2025-02-05T01:20:05.103",\n "SellingAgentRemarks": "",\n "LessorName": "Dale Steffens",\n "CommercialSpaceYN": "0",\n "FeeOptions": "None",\n "ExpensesInformationSource": "Owner",\n "Loading": "Loading Area",\n "CompensationMethod": "",\n "LandRecorded": "Regular System",\n "ListingKey": "1104298135",\n "LandlordPhone": "888-888-8888",\n "LandlordName": "Confidential",\n "LeaseFeeMonth": "2932.00",\n "LeaseExpirationYear": "2069",\n "TaxAssessedValueLand": "381400.00",\n "SQFTOther": "0",\n "TaxAssessedValueImprovements": "1116700.00",\n "LeaseRenegotiationDate": "2029-09-01",\n "Easements": "None",\n "TotalIncome": "195442.00",\n "OtherIncome": "0.00",\n "ShowingTimeFlagYN": "1"\n } """ +"TaxAssessedValueLand": "381400" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "1116700" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1104298135')" +"provider_name": "HICMLS" +"RecordSignature": 2036645844 +"UniversalParcelId": "urn:reso:upi:2.0:US:15001:3-2-2-037-029-0000" +"CountrySubdivision": "15001" +"OriginatingSystemListOfficeKey": "3487434" +"OriginatingSystemListAgentMemberKey": "3476508" +"Media": array:24 [ …24] +"ID": "49346" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7513 +post_id: "50748" +post_author: 1 +"ListingKey": "1108314606" +"ListingId": "202506339" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-18T03:36:12Z" +"RFModificationTimestamp": "2026-04-18T03:37:26Z" +"ListPrice": 490000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 23462.0 +"LivingArea": 836.0 +"BuildingAreaTotal": 836.0 +"City": "Honolulu" +"PostalCode": "96822" +"UnparsedAddress": "1540 Magazine Streets C/3, Honolulu, Hawaii 96822" +"Coordinates": array:2 [ …2] +"Latitude": 21.3079901 +"Longitude": -157.8453007 +"YearBuilt": 1986 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Bryn W Kaufman" +"ListOfficeName": "Oahu RE.com" +"ListAgentMlsId": "27729" +"ListOfficeMlsId": "GIVE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "1540 Magazine Street Unit C/3 is a condominium in Honolulu, Hawaii, built in 1986. This unit features 3 bedrooms, 2 bathrooms, and offers 836 square feet of living space. It includes in-unit laundry facilities and comes with two assigned parking stalls. Located in a quiet neighborhood, the property provides convenient access to local amenities." +"ArchitecturalStyle": "Low Rise" +"AttributionContact": "(808) 425-7887" +"BathroomsFull": 2 +"BuildingName": "Carlton Place 1" …86 } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7518 …100} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7496 …117} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7514 …118} 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7519 …119} 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7520 …139} 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7497 …118} 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7494 …115} 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7493 …133} 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7490 …117} 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7498 …123} 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7522 …121} 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7521 …130} 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7460 …129} 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7461 …145} 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7462 …120} 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7463 …118} ] +success: true +page_size: 18 +page_count: 52 +count: 919 +after_key: "" } "RF Response Time" => "0.32 seconds" ] ]