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 (ExteriorFeatures eq 'Bedroom on Main Level' OR InteriorFeatures eq 'Bedroom on Main Level' OR Appliances eq 'Bedroom on Main Level')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5274 +items: array:18 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5259 +post_id: "84511" +post_author: 1 +"ListingKey": "1175235043" +"ListingId": "202611928" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T03:30:31Z" +"RFModificationTimestamp": "2026-08-03T03:31:31Z" +"ListPrice": 695000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1008.0 +"BuildingAreaTotal": 1053.0 +"City": "Ewa Beach" +"PostalCode": "96706" +"UnparsedAddress": "91-1041 Kaileolea Drive 2a4, Ewa Beach, Hawaii 96706" +"Coordinates": array:2 [ …2] +"Latitude": 21.315603 +"Longitude": -158.008804 +"YearBuilt": 2000 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Tiffany Agpaoa" +"ListOfficeName": "Plumeria Hawaii Properties LLC" +"ListAgentMlsId": "54041" +"ListOfficeMlsId": "ARIA" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Welcome to Ocean Pointe living at its finest! This stunning, move-in ready 3-bedroom, 2.5-bath townhome checks every box with a detached 2-car garage, private yard, and a thoughtfully designed floor plan built for the way you actually live. The bottom floor features a bedroom, perfect for guests or a home office, open living and dining area, and a full kitchen with a brand new refrigerator and dishwasher — everything you need, all on one level. Upstairs, discover a serene primary retreat with a private ensuite bath, a third bedroom, and additional bathroom — all topped with brand new carpet throughout. Step outside to your private yard, perfect for morning coffee, weekend BBQs, or letting the kids and pets roam free. The detached 2-car garage offers abundant storage and keeps your vehicles secure and out of the elements. Nestled in the highly sought-after Ocean Pointe community in Ewa Beach, you are minutes from Wai Kai, sandy beaches, schools, shopping, and dining. Whether you are a first-time buyer, growing family, or investor, this one is not to be missed!" +"AssociationFee": "130.0" +"AssociationFeeIncludes": "Common Areas,Sewer,Water" +"AssociationName": "Ocean Pointe CA" +"AttributionContact": "(808) 729-6006" +"BathroomsFull": 2 +"BuildingName": "Ke Aina Kai Townhomes 5" +"CLIP": 7301764152 +"CommonWalls": "No One Above,No One Below" +"CommunityFeatures": "Playground,Recreation Area" +"ConstructionMaterials": "Double Wall,Steel Frame" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2026-06-21T00:21:24.738969+00:00" +"DaysOnMarket": 43 +"DaysOnMarketReplication": 43 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 1 +"Flooring": "Carpet, Vinyl" +"FoundationDetails": "Slab" +"GarageYN": true +"Inclusions": "AC Central,Auto Garage Door Opener,Ceiling Fan,Dishwasher,Disposal,Dryer,Microwave Hood,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two,Multi/Split" +"ListAgentDirectPhone": "(808) 729-6006" +"ListAgentEmail": "tiffany.agpaoa@gmail.com" +"ListAgentKey": "24033038" +"ListAgentKeyNumeric": "24033038" +"ListAgentOfficePhone": "(808) 729-6006" +"ListAgentPreferredPhone": "(808) 729-6006" +"ListAgentStateLicense": "RS-87224" +"ListOfficeEmail": "ashley@plhawaii.com" +"ListOfficeKey": "3306906" +"ListOfficeKeyNumeric": "3306906" +"ListOfficePhone": "(808) 729-6006" +"ListingContractDate": "2026-06-20" +"ListingKeyNumeric": 1175235043 +"ListingService": "Full Service" +"LotFeatures": "Private, Yard" +"MLSAreaMajor": "Ewaplain" +"MaintenanceExpense": 792.07 +"MajorChangeTimestamp": "2026-06-20T14:20:13Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-06-20" +"OriginalListPrice": 695000.0 +"OriginatingSystemKey": "19529064" +"ParcelNumber": "1-9-1-114-164-0004" +"ParkingFeatures": "Covered,Garage,Guest,Two Spaces,On Street" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-06-21T00:23:03Z" +"PhotosCount": 22 +"PostalCity": "Ewa Beach" +"PropertyCondition": "Excellent,Good Condition" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1175235043" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Kaileolea" +"StreetNumber": "91-1041" +"StreetSuffix": "Drive" +"StructureType": "Townhouse" +"SubdivisionName": "OCEAN POINTE" +"TaxAnnualAmount": "1749.96" +"TaxAssessedValue": 620000 +"UnitNumber": "2A4" +"View": "None" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1175235043"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 922.0 +"TaxAssessedValueLand": "262300" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium,Townhouse" +"TaxAssessedValueImprovement": "357700" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1175235043')" +"provider_name": "HICMLS" +"RecordSignature": 1857447283 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-1-114-164-0004" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15156346" +"OriginatingSystemListAgentMemberKey": "18014981" +"Media": array:22 [ …22] +"ID": "84511" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5261 +post_id: "85825" +post_author: 1 +"ListingKey": "1178754079" +"ListingId": "202614811" +"PropertyType": "Residential Lease" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T03:24:12Z" +"RFModificationTimestamp": "2026-08-03T03:27:00Z" +"ListPrice": 1500.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 242019.0 +"LivingArea": 412.0 +"BuildingAreaTotal": 412.0 +"City": "Waianae" +"PostalCode": "96792" +"UnparsedAddress": "85-175 Farrington Highway A209, Waianae, Hawaii 96792" +"Coordinates": array:2 [ …2] +"Latitude": 21.446678 +"Longitude": -158.185272 +"YearBuilt": 1974 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Edward A Halfinger" +"ListOfficeName": "Edward A. Halfinger Realty" +"ListAgentMlsId": "25881" +"ListOfficeMlsId": "HALF" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "One bedroom unit with ocean view. Call listor for application." +"Appliances": "Oven, Range, Refrigerator" +"ArchitecturalStyle": "Low Rise" +"AssociationAmenities": "Management" +"AttributionContact": "edwardhal@hotmail.com" +"AvailabilityDate": "2026-08-02" +"BathroomsFull": 1 +"BuildingName": "Makaha Surfside" +"CLIP": 7302955950 +"CommunityFeatures": "Barbecue,Laundry Facilities,Property Manager On-Site,Sauna,Trash Chute" +"Cooling": "Window Unit(s)" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2026-08-03T03:26:52.199790+00:00" +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Flooring": "Vinyl" +"FrontageType": "Oceanfront" +"Furnished": "Partially" +"HumanModifiedYN": true +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Rent" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 696-7356" +"ListAgentEmail": "edwardhalf@gmail.com" +"ListAgentKey": "10758632" +"ListAgentKeyNumeric": "10758632" +"ListAgentOfficePhone": "(808) 754-2125" +"ListAgentPreferredPhone": "(808) 696-7356" +"ListAgentStateLicense": "RB-20054" +"ListOfficeEmail": "edwardhal@hotmail.com" +"ListOfficeKey": "2585461" +"ListOfficeKeyNumeric": "2585461" +"ListOfficePhone": "(808) 754-2125" +"ListingContractDate": "2026-08-02" +"ListingKeyNumeric": 1178754079 +"MLSAreaMajor": "Leeward" +"MajorChangeTimestamp": "2026-08-02T17:24:09Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-08-02" +"OriginalListPrice": 1500.0 +"OriginatingSystemKey": "19614023" +"ParcelNumber": "1-8-5-017-008-0047" +"ParkingFeatures": "Assigned, Guest, Secured" +"ParkingTotal": "1.0" +"PetsAllowed": "No" +"PhotosChangeTimestamp": "2026-08-03T03:19:14Z" +"PhotosCount": 3 +"PostalCity": "Waianae" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Closed Circuit Camera(s),24 Hour Security,Key Card Entry,Security Guard" +"SourceSystemKey": "1178754079" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Farrington" +"StreetNumber": "85-175" +"StreetSuffix": "Highway" +"SubdivisionName": "WAIANAE" +"UnitNumber": "A209" +"Utilities": "Sewer Available,Water Available" +"View": "Ocean" +"ViewYN": true +"ZoningDescription": "11 - A-1 Low Density Apartment" +"ListAOR": "HI Central" +"CustomFields": """ {\n "ListingKey": "1178754079"\n } """ +"AvailabilityType": "Long Term" +"OriginatingSystemSubName": "HICMLS_HBR" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178754079')" +"provider_name": "HICMLS" +"short_address": "Waianae, Hawaii 96792, USA" +"RecordSignature": 1352010654 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-8-5-017-008-0047" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3487343" +"OriginatingSystemListAgentMemberKey": "3475662" +"Media": array:3 [ …3] +"DaysOnMarket": 0 +"ID": "85825" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5258 +post_id: "83249" +post_author: 1 +"ListingKey": "1157249027" +"ListingId": "202607276" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T03:01:14Z" +"RFModificationTimestamp": "2026-08-03T03:04:00Z" +"ListPrice": 875000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 1427635.0 +"LivingArea": 1287.0 +"BuildingAreaTotal": 1787.0 +"City": "Kaneohe" +"PostalCode": "96744" +"UnparsedAddress": "44-145 Hako Street 141401, Kaneohe, Hawaii 96744" +"Coordinates": array:2 [ …2] +"Latitude": 21.414596 +"Longitude": -157.7645893 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Cindy Siok" +"ListOfficeName": "At Home Hawaii LLC" +"ListAgentMlsId": "26253" +"ListOfficeMlsId": "AHHI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Quiet & peaceful corner/end unit with 2 side-by-side parking spots, right in front - no stairs to the unit. This preferred layout has the primary BR, full bath, kitchen, living area, a deck, a courtyard & a W/D all on the main level with 2 add'l BRs that open to a walk-out lanai and a full bath downstairs.\r\n Upgrades include 22-Panel PV System with a transferrable Net Metering contract (electric bill is $31). Stay cool with split AC & ceiling fan. A renovated kitchen is a joy to cook in with stainless appliances, quiet Bosch dishwasher and copper farm sink. Extra windows in the corner/end location and they feature Hunter Douglas automated blinds - download the app to program sunrise/sunset opening/closing, to set zones & other features. The home also has upgraded flooring & vaulted ceilings.\r\n The 33-acre park-like complex is pet friendly and has 27 buildings with a heated saltwater pool, clubhouse, BBQ area, walking paths and ample guest parking. Near H-3, 25 miles from Honolulu Airport and just 3 miles to Kailua Beach. The community is also known for Aikahi Elementary School ranking in the top 10% of all schools in Hawaii for overall test scores. """ +"AssociationFeeIncludes": "Common Areas,Sewer,Water" +"AttributionContact": "(808) 954-6435" +"BathroomsFull": 2 +"BuildingName": "Yacht Club Terrace" +"CLIP": 9034555757 +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Clubhouse,Community Pool,Deck/Porch,Patio,Storage Facilities,Trails/Paths" +"ConstructionMaterials": "Double Wall,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-05-09T22:12:11.962797+00:00" +"DaysOnMarket": 69 +"DaysOnMarketReplication": 69 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Aikahi" +"EntryLevel": 1 +"Fencing": "Fenced, Wall" +"Flooring": "Ceramic Tile,Laminate" +"Furnished": "Partially" +"HighSchool": "Kalaheo" +"Inclusions": "AC Split,Blinds,Ceiling Fan,Dishwasher,Disposal,Dryer,Microwave Hood,Photovoltaic - Owned,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Two,Multi/Split" +"ListAgentDirectPhone": "(808) 954-6435" +"ListAgentEmail": "cindy@athomehawaii.com" +"ListAgentKey": "10772562" +"ListAgentKeyNumeric": "10772562" +"ListAgentOfficePhone": "(808) 954-6435" +"ListAgentPreferredPhone": "(808) 954-6435" +"ListAgentStateLicense": "RB-20508" +"ListOfficeEmail": "AtHome@hawaii.rr.com" +"ListOfficeKey": "2585662" +"ListOfficeKeyNumeric": "2585662" +"ListOfficePhone": "(808) 954-6435" +"ListingContractDate": "2026-04-10" +"ListingKeyNumeric": 1157249027 +"ListingService": "Full Service" +"LotFeatures": "Yard" +"MLSAreaMajor": "Kaneohe" +"MaintenanceExpense": 990.0 +"MajorChangeTimestamp": "2026-07-24T07:59:43Z" +"MiddleOrJuniorSchool": "Kailua" +"MlsStatus": "Active" +"OnMarketDate": "2026-04-10" +"OpenParkingYN": true +"OriginalListPrice": 875000.0 +"OriginatingSystemKey": "19382022" +"ParcelNumber": "1-4-4-012-064-0080" +"ParkingFeatures": "Assigned,Guest,Two Spaces" +"ParkingTotal": "2.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-06-01T10:56:01Z" +"PhotosCount": 20 +"PostalCity": "Kaneohe" +"PropertyCondition": "Good Condition,Updated/Remodeled" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1157249027" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Hako" +"StreetNumber": "44-145" +"StreetSuffix": "Street" +"StructureType": "Townhouse" +"SubdivisionName": "COUNTRY CLUB" +"TaxAnnualAmount": "2448.0" +"TaxAssessedValue": 860600 +"UnitNumber": "141401" +"View": "Garden" +"ViewYN": true +"VirtualTourURLUnbranded": "https://youtube.com/shorts/sWjH4mO4xP4?feature=share" +"ZoningDescription": "03 - R10 - Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1157249027"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 990.0 +"TaxAssessedValueLand": "267500" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium,Townhouse" +"TaxAssessedValueImprovement": "593100" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1157249027')" +"provider_name": "HICMLS" +"RecordSignature": -1377569982 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-4-4-012-064-0080" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3487544" +"OriginatingSystemListAgentMemberKey": "3475955" +"Media": array:20 [ …20] +"ID": "83249" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5262 +post_id: "80724" +post_author: 1 +"ListingKey": "1156049475" +"ListingId": "202606322" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T03:01:14Z" +"RFModificationTimestamp": "2026-08-03T03:04:27Z" +"ListPrice": 965000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 138216.0 +"LivingArea": 1324.0 +"BuildingAreaTotal": 1453.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "1650 Ala Moana Boulevard 3405, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.287303 +"Longitude": -157.8402868 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Damon B Rhys" +"ListOfficeName": "Damon HI Pac Intl Prop LLC" +"ListAgentMlsId": "45206" +"ListOfficeMlsId": "DAHI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Rare opportunity—high-floor view residence, priced to sell. Experience elevated island living from this high-floor residence at Yacht Harbor Towers, featuring breathtaking panoramic views of the Pacific Ocean, Ala Wai Yacht Harbor, Magic Island, and the coastline beyond. The spacious layout is enhanced by an expansive lanai spanning the living area and bedrooms, creating seamless indoor-outdoor living—perfect for relaxing or entertaining while taking in ever-changing ocean views and cooling trade winds. Ideally positioned at the gateway to Waikiki and directly across from Ala Moana Center, with close proximity to Ala Moana Beach Park, Ward Village, and world-class dining and nightlife. Resort-style amenities include a heated pool, jacuzzi, tennis and pickleball courts, BBQ areas, and 24-hour security. An exceptional opportunity to own a premier view residence in one of Honolulu's most desirable locations—this is island living at its finest. High-floor positioning offers exceptional privacy and a true sense of retreat above it all. Stunning sightlines capture unforgettable sunsets and ever-changing ocean vistas." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Cable TV,Electricity,HVAC,Hot Water,Internet,None" +"AssociationName": "AOAO Yacht Harbor Towers" +"AttributionContact": "(808) 468-1838" +"BathroomsFull": 2 +"BuildingName": "Yacht Harbor Towers" +"CLIP": 4701824892 +"CoListAgentDirectPhone": "(808) 650-2382" +"CoListAgentEmail": "info@h2owatermark.com" +"CoListAgentFullName": "Christine K Kim" +"CoListAgentKey": "10767882" +"CoListAgentKeyNumeric": "10767882" +"CoListAgentMlsId": "31651" +"CoListAgentPreferredPhone": "(808) 285-4357" +"CoListOfficeEmail": "aloha.ckim@gmail.com" +"CoListOfficeKey": "2585716" +"CoListOfficeKeyNumeric": "2585716" +"CoListOfficeMlsId": "HWPP" +"CoListOfficeName": "H2O Watermark Pacific Prop LLC" +"CoListOfficePhone": "(808) 650-2382" +"CommunityFeatures": "Barbecue,Clubhouse,Community Pool,Deck/Porch,Fitness,Patio,Pool,Recreation Area,Tennis Court(s),Trash Chute" +"ConstructionMaterials": "Concrete" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2026-03-28T04:02:04.915648+00:00" +"DaysOnMarket": 128 +"DaysOnMarketReplication": 128 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Ala Wai" +"EntryLevel": 34 +"Flooring": "Carpet,Ceramic Tile,Vinyl" +"FrontageType": "Other" +"Furnished": "Negotiable" +"HighSchool": "Kaimuki" +"Inclusions": "AC Central,Cable TV,Dishwasher,Disposal,Drapes,Dryer,Microwave Hood,Range/Oven,Refrigerator,Smoke Detector,Washer" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 358-2331" +"ListAgentEmail": "damon@hawaiidamon.com" +"ListAgentKey": "10774136" +"ListAgentKeyNumeric": "10774136" +"ListAgentOfficePhone": "(808) 468-1838" +"ListAgentPreferredPhone": "(808) 358-2331" +"ListAgentStateLicense": "RB-23023" +"ListOfficeEmail": "damon@hawaiidamon.com" +"ListOfficeKey": "4018701" +"ListOfficeKeyNumeric": "4018701" +"ListOfficePhone": "(808) 468-1838" +"ListingContractDate": "2026-03-27" +"ListingKeyNumeric": 1156049475 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 2200.0 +"MajorChangeTimestamp": "2026-06-07T21:43:08Z" +"MiddleOrJuniorSchool": "Washington" +"MlsStatus": "Active" +"OnMarketDate": "2026-03-27" +"OriginalListPrice": 980000.0 +"OriginatingSystemKey": "19355811" +"ParcelNumber": "1-2-3-036-039-0422" +"ParkingFeatures": "Assigned,Covered,One Space" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-04-30T21:42:00Z" +"PhotosCount": 24 +"PoolFeatures": "Heated" +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Updated/Remodeled" +"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry,Fire Sprinkler System,Security Guard" +"SourceSystemKey": "1156049475" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Ala Moana" +"StreetNumber": "1650" +"StreetNumberNumeric": "1650" +"StreetSuffix": "Boulevard" +"SubdivisionName": "ALA MOANA" +"TaxAnnualAmount": "4047.72" +"TaxAssessedValue": 864700 +"TotalActualRent": 4000.0 +"UnitNumber": "3405" +"View": "Coastline, Ocean, Sunset" +"ViewYN": true +"VirtualTourURLUnbranded": "https://player.vimeo.com/video/1178112409?h=61d52ed31a" +"YearBuiltEffective": 2020 +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1156049475"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 2200.0 +"TaxAssessedValueLand": "61600" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "803100" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1156049475')" +"provider_name": "HICMLS" +"RecordSignature": -1514344487 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-036-039-0422" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15710199" +"OriginatingSystemCoListOfficeKey": "3487598" +"OriginatingSystemListAgentMemberKey": "9563780" +"OriginatingSystemCoListAgentMemberKey": "3479036" +"Media": array:24 [ …24] +"ID": "80724" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5260 +post_id: "84967" +post_author: 1 +"ListingKey": "1177926078" +"ListingId": "202614180" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T03:01:14Z" +"RFModificationTimestamp": "2026-08-03T03:04:15Z" +"ListPrice": 2050000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 5439.0 +"LivingArea": 2053.0 +"BuildingAreaTotal": 2278.0 +"City": "Kailua" +"PostalCode": "96734" +"UnparsedAddress": "240 Kalama Street, Kailua, Hawaii 96734" +"Coordinates": array:2 [ …2] +"Latitude": 21.4083895 +"Longitude": -157.7467445 +"YearBuilt": 2026 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Michael J Tucker" +"ListOfficeName": "eXp Realty" +"ListAgentMlsId": "49433" +"ListOfficeMlsId": "EXPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Relax and enjoy your slice of paradise just blocks from world famous Kailua beaches. There are cool tropical tradewinds for this brand new construction 4 bedroom 3 bath detached single family home with a brand new swimming pool and covered lanai. Enjoy an active beach, hiking and biking lifestyle with great restaurants and shopping right down the road. There is an open floor plan. High quality construction with lovely finishes throughout including quartz countertops, stainless steel appliances with durable ceramic tile and vinyl flooring. Split AC throughout and a 220 outlet for your electric car." +"ArchitecturalStyle": "Detached" +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 725-2794" +"BathroomsFull": 3 +"CLIP": 2905357538 +"CommunityFeatures": "Deck/Porch,Patio,Storage Facilities" +"ConstructionMaterials": "Double Wall,Vinyl Siding,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-07-23T10:08:00.698028+00:00" +"DaysOnMarket": 10 +"DaysOnMarketReplication": 10 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Owner Is Listing Agent" +"ElementarySchool": "Kainalu" +"ExteriorFeatures": "Landscaping" +"Fencing": "Fenced, Wall" +"Flooring": "Ceramic Tile,Vinyl" +"FoundationDetails": "Slab" +"FrontageType": "Other" +"Furnished": "Unfurnished" +"HighSchool": "Kalaheo" +"Inclusions": "AC Split,Ceiling Fan,Dishwasher,Disposal,Dryer,Microwave,Range/Oven,Refrigerator,Smoke Detector,Solar Heater,Washer,Water Heater,Wine Refrigerator" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 387-2807" +"ListAgentEmail": "tucker24932@gmail.com" +"ListAgentKey": "13402434" +"ListAgentKeyNumeric": "13402434" +"ListAgentOfficePhone": "(808) 725-2794" +"ListAgentPreferredPhone": "(808) 387-2807" +"ListAgentStateLicense": "RS-81946" +"ListOfficeEmail": "hi.broker@exprealty.net" +"ListOfficeKey": "2589160" +"ListOfficeKeyNumeric": "2589160" +"ListOfficePhone": "(808) 725-2794" +"ListingContractDate": "2026-07-23" +"ListingKeyNumeric": 1177926078 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Other, Level" +"MLSAreaMajor": "Kailua" +"MajorChangeTimestamp": "2026-07-23T00:02:23Z" +"MiddleOrJuniorSchool": "Kailua" +"MlsStatus": "Active" +"NewConstructionYN": true +"OnMarketDate": "2026-07-23" +"OriginalListPrice": 2050000.0 +"OriginatingSystemKey": "19594596" +"ParcelNumber": "1-4-3-038-002-0000" +"ParkingFeatures": "Three or more Spaces" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-08-01T03:19:00Z" +"PhotosCount": 23 +"PoolFeatures": "In Ground,Pool" +"PostalCity": "Kailua" +"PropertyCondition": "Excellent" +"SourceSystemKey": "1177926078" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Kalama" +"StreetNumber": "240" +"StreetNumberNumeric": "240" +"StreetSuffix": "Street" +"SubdivisionName": "COCONUT GROVE" +"TaxAnnualAmount": "4542.0" +"TaxAssessedValue": 1047600 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,Phone Available,Water Available" +"View": "Mountain(s)" +"ViewYN": true +"WaterSource": "Public" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1177926078"\n } """ +"HumanModifiedYN": false +"TaxAssessedValueLand": "1012800" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "34800" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1177926078')" +"provider_name": "HICMLS" +"RecordSignature": 1734671138 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-4-3-038-002-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10013908" +"OriginatingSystemListAgentMemberKey": "14219335" +"Media": array:23 [ …23] +"ID": "84967" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5257 +post_id: "80201" +post_author: 1 +"ListingKey": "1151653367" +"ListingId": "202601613" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T03:01:14Z" +"RFModificationTimestamp": "2026-08-03T03:04:31Z" +"ListPrice": 2999000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 16142.0 +"LivingArea": 3294.0 +"BuildingAreaTotal": 3794.0 +"City": "Honolulu" +"PostalCode": "96822" +"UnparsedAddress": "2618 Ferdinand Avenue, Honolulu, Hawaii 96822" +"Coordinates": array:2 [ …2] +"Latitude": 21.3101722 +"Longitude": -157.8193507 +"YearBuilt": 1927 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lisa A Camacho" +"ListOfficeName": "Compass" +"ListAgentMlsId": "35267" +"ListOfficeMlsId": "COHI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Step back in time and experience the enduring elegance of this Historic Registry residence. Nestled against lush valley greenery, this classic Manoa home showcases timeless architecture, expansive living spaces, and abundant natural light throughout. Original details, warm hardwood floors, and oversized picture windows create an inviting atmosphere that reflects the craftsmanship of a bygone era.\r\n Gracious living and dining areas flow seamlessly for both everyday living and refined entertaining, while multiple sitting areas and built-in features add depth and character. Enjoy stunning Diamond Head, city, and sunrise views alongside tranquil valley vistas. The flexible layout offers ideal spaces for work, relaxation, or hosting guests. Charming courtyards and garden settings are surrounded by Manoa’s signature tropical landscape—perfect for quiet mornings or evening gatherings. With its stately presence, storybook curb appeal, and coveted Manoa location, this is a rare opportunity to own a distinguished piece of Honolulu history. """ +"ArchitecturalStyle": "Detached" +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 825-4277" +"BathroomsFull": 2 +"CLIP": 4906280630 +"CoListAgentDirectPhone": "(808) 825-4277" +"CoListAgentEmail": "malia.siu@compass.com" +"CoListAgentFullName": "Malia Siu" +"CoListAgentKey": "10777808" +"CoListAgentKeyNumeric": "10777808" +"CoListAgentMlsId": "30733" +"CoListAgentPreferredPhone": "(808) 479-8418" +"CoListOfficeEmail": "julie.meier@compass.com" +"CoListOfficeKey": "3944102" +"CoListOfficeKeyNumeric": "3944102" +"CoListOfficeMlsId": "COHI" +"CoListOfficeName": "Compass" +"CoListOfficePhone": "(808) 825-4277" +"CommunityFeatures": "Deck/Porch,Patio,Storage Facilities" +"ConstructionMaterials": "Double Wall,Masonry,Stucco,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-03-17T05:41:33.360498+00:00" +"DaysOnMarket": 139 +"DaysOnMarketReplication": 139 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ExteriorFeatures": "Landscaping" +"Fencing": "Fenced, Wall" +"Flooring": "Hardwood, Vinyl" +"Inclusions": "Ceiling Fan,Disposal,Dryer,Range/Oven,Refrigerator,Washer,Water Heater" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 348-0468" +"ListAgentEmail": "lisa.camacho@compass.com" +"ListAgentKey": "10773022" +"ListAgentKeyNumeric": "10773022" +"ListAgentOfficePhone": "(808) 825-4277" +"ListAgentPreferredPhone": "(808) 348-0468" +"ListAgentStateLicense": "RB-23625" +"ListOfficeEmail": "julie.meier@compass.com" +"ListOfficeKey": "3944102" +"ListOfficeKeyNumeric": "3944102" +"ListOfficePhone": "(808) 825-4277" +"ListingContractDate": "2026-03-16" +"ListingKeyNumeric": 1151653367 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Other, Level" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2026-05-30T07:48:37Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-03-16" +"OriginalListPrice": 3450000.0 +"OriginatingSystemKey": "19232409" +"ParcelNumber": "1-2-9-009-015-0000" +"ParkingFeatures": "Driveway,Three or more Spaces,On Street" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-07-27T06:21:01Z" +"PhotosCount": 23 +"PoolFeatures": "None" +"PostalCity": "Honolulu" +"PropertyCondition": "Average Condition" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1151653367" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Ferdinand" +"StreetNumber": "2618" +"StreetNumberNumeric": "2618" +"StreetSuffix": "Avenue" +"SubdivisionName": "MANOA AREA" +"TaxAnnualAmount": "300.0" +"TaxAssessedValue": 2313200 +"Topography": "Level, Sloping" +"Utilities": "Above Ground Utilities,Electricity Available,Natural Gas Available,Other,Sewer Available,Water Available" +"View": "City, Mountain(s), Ocean, Sunrise" +"ViewYN": true +"VirtualTourURLUnbranded": "https://player.vimeo.com/video/1174244441?badge=0&autopause=0&player_id=0&app_id=58479" +"WaterSource": "Public" +"YearBuiltEffective": 1999 +"ZoningDescription": "03 - R10 - Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1151653367"\n } """ +"HumanModifiedYN": false +"TaxAssessedValueLand": "1999900" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "313300" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1151653367')" +"provider_name": "HICMLS" +"RecordSignature": -831634132 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-9-009-015-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15465233" +"OriginatingSystemCoListOfficeKey": "15465233" +"OriginatingSystemListAgentMemberKey": "3480474" +"OriginatingSystemCoListAgentMemberKey": "3478664" +"Media": array:23 [ …23] +"ID": "80201" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5252 +post_id: "84302" +post_author: 1 +"ListingKey": "1177163541" +"ListingId": "202613740" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T01:00:15Z" +"RFModificationTimestamp": "2026-08-03T01:02:27Z" +"ListPrice": 759000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 719.0 +"BuildingAreaTotal": 744.0 +"City": "Kailua" +"PostalCode": "96734" +"UnparsedAddress": "445 Kailua Road 5304, Kailua, Hawaii 96734" +"Coordinates": array:2 [ …2] +"Latitude": 21.3927281 +"Longitude": -157.738128 +"YearBuilt": 2014 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rachel Bradley" +"ListOfficeName": "Hawaii Modern Realty" +"ListAgentMlsId": "46063" +"ListOfficeMlsId": "BHHR" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Tucked away in one of the most peaceful locations within Ka Malanai, this desirable one-bedroom residence enjoys a quiet back corner, top floor setting surrounded by lush tropical landscaping, offering exceptional privacy and a serene island atmosphere. Fresh new carpet and a bright, well-maintained interior create a welcoming space ready to enjoy, while the convenient in-unit washer and dryer make everyday living effortless. Two parking stalls provide the flexibility and convenience that are rarely found with a one-bedroom home.\r\n \r\n Perfectly positioned in the heart of Kailua, this residence offers easy access to world-famous Kailua Beach, where turquoise waters and powder-soft sand invite morning swims, paddling, and sunset strolls. Kailua Town's vibrant collection of boutiques, cafés, restaurants, grocery stores, and everyday conveniences are just moments away, creating an ideal balance of relaxation and accessibility. Nearby Kailua District Park offers tennis courts, sports fields, fitness opportunities, and community events, completing the lifestyle that makes Ka Malanai one of Kailua's most sought-after communities. """ +"ArchitecturalStyle": "Low Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Cable TV,None,Sewer,Water" +"AttributionContact": "(808) 792-3910" +"BathroomsFull": 1 +"BuildingName": "Ka Malanai At Kailua" +"CLIP": 2284731691 +"CoListAgentDirectPhone": "(808) 436-3301" +"CoListAgentEmail": "sky.ross@modernhawaii.com" +"CoListAgentFullName": "Sky Ross" +"CoListAgentKey": "30338797" +"CoListAgentKeyNumeric": "30338797" +"CoListAgentMlsId": "55247" +"CoListAgentPreferredPhone": "(808) 436-3301" +"CoListOfficeEmail": "aloha@modernhawaii.com" +"CoListOfficeKey": "2589163" +"CoListOfficeKeyNumeric": "2589163" +"CoListOfficeMlsId": "BHHR" +"CoListOfficeName": "Hawaii Modern Realty" +"CoListOfficePhone": "(808) 792-3910" +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Trails/Paths,Trash Chute" +"ConstructionMaterials": "Double Wall,Masonry,Steel Frame,Stucco" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2026-07-20T17:01:40.348479+00:00" +"DaysOnMarket": 13 +"DaysOnMarketReplication": 13 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 3 +"Flooring": "Carpet,Ceramic Tile" +"FrontageType": "Other" +"Inclusions": "AC Central,Auto Garage Door Opener,Blinds,Cable TV,Ceiling Fan,Dishwasher,Disposal,Drapes,Dryer,Microwave Hood,Range/Oven,Refrigerator,Smoke Detector,Washer" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 358-7056" +"ListAgentEmail": "Rachel.Bradley@modernhawaii.com" +"ListAgentKey": "10779369" +"ListAgentKeyNumeric": "10779369" +"ListAgentOfficePhone": "(808) 792-3910" +"ListAgentPreferredPhone": "(808) 358-7056" +"ListAgentStateLicense": "RB-22807" +"ListOfficeEmail": "aloha@modernhawaii.com" +"ListOfficeKey": "2589163" +"ListOfficeKeyNumeric": "2589163" +"ListOfficePhone": "(808) 792-3910" +"ListingContractDate": "2026-07-20" +"ListingKeyNumeric": 1177163541 +"ListingService": "Full Service" +"MLSAreaMajor": "Kailua" +"MaintenanceExpense": 549.21 +"MajorChangeTimestamp": "2026-07-20T06:58:45Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-07-20" +"OpenParkingYN": true +"OriginalListPrice": 759000.0 +"OriginatingSystemKey": "19581680" +"ParcelNumber": "1-4-2-001-059-0117" +"ParkingFeatures": "Assigned,Covered,One Space" +"ParkingTotal": "2.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-07-19T00:02:01Z" +"PhotosCount": 20 +"PostalCity": "Kailua" +"PropertyCondition": "Excellent" +"SecurityFeatures": "Elevator Secured,Key Card Entry,Fire Sprinkler System,Security Guard" +"SourceSystemKey": "1177163541" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kailua" +"StreetNumber": "445" +"StreetNumberNumeric": "445" +"StreetSuffix": "Road" +"SubdivisionName": "KAILUA TOWN" +"TaxAnnualAmount": "2931.24" +"TaxAssessedValue": 837500 +"UnitNumber": "5304" +"View": "Garden, Mountain(s)" +"ViewYN": true +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1177163541"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 549.0 +"TaxAssessedValueLand": "123100" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "714400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1177163541')" +"provider_name": "HICMLS" +"RecordSignature": 677992034 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-4-2-001-059-0117" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10036030" +"OriginatingSystemCoListOfficeKey": "10036030" +"OriginatingSystemListAgentMemberKey": "10007986" +"OriginatingSystemCoListAgentMemberKey": "19394238" +"Media": array:20 [ …20] +"ID": "84302" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5263 +post_id: 85844 +post_author: 1 +"ListingKey": "1178701372" +"ListingId": "202614720" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-01T01:44:01Z" +"RFModificationTimestamp": "2026-08-01T01:48:59Z" +"ListPrice": 239000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 480.0 +"BuildingAreaTotal": 480.0 +"City": "Honolulu" +"PostalCode": "96822" +"UnparsedAddress": "1700 Makiki Street 112, Honolulu, Hawaii 96822" +"Coordinates": array:2 [ …2] +"Latitude": 21.30502 +"Longitude": -157.833839 +"YearBuilt": 1956 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Gloria C Brasuel" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "43530" +"ListOfficeMlsId": "CBPP" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Welcome to Unit 112 at 1700 Makiki Street, a ground-floor 1-bedroom, 1-bath residence in the iconic Oahuan, a celebrated mid-century modern community designed by renowned Hawaii architect Edwin Bauer. Known for his philosophy of "bringing the outdoors indoors," Bauer created a thoughtfully designed urban oasis centered around lush tropical gardens and a tranquil courtyard pool.\r\n This home has been refreshed with new luxury vinyl flooring and includes all utilities, cable, and internet in the maintenance fees. Residents enjoy the architectural details that make the Oahuan so distinctive, including lava rock walls, wooden louvers, mature landscaping, and a peaceful atmosphere in urban Honolulu. Located in the heart of Makiki, residents enjoy easy access to Makiki District Park and its weekly farmers market, the Tantalus trail system, and convenient H-1 access. Punahou School, Maryknoll School, and the University of Hawaii at Manoa are just minutes away. Shopping, dining, and everyday conveniences are nearby at Manoa Marketplace, Walmart, Sam's Club, Ala Moana Center, and Ala Moana Beach Park. Some photos have been virtually staged. """ +"ArchitecturalStyle": "Low Rise" +"AssociationFeeIncludes": "Common Areas,Electricity,Hot Water,Internet,Sewer" +"AttributionContact": "(808) 596-0456" +"BathroomsFull": 1 +"BuildingName": "Oahuan Ltd" +"CLIP": 1017046086 +"CommunityFeatures": "Deck/Porch,Laundry Facilities,Patio,Pool" +"ConstructionMaterials": "Double Wall,Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-08-01T01:48:52.686082+00:00" +"DaysOnMarketReplicationDate": "2026-07-31" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 1 +"Flooring": "Ceramic Tile,Laminate" +"HumanModifiedYN": true +"Inclusions": "Range/Oven,Refrigerator" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 352-8278" +"ListAgentEmail": "gloriab@cbpacific.com" +"ListAgentKey": "10773419" +"ListAgentKeyNumeric": "10773419" +"ListAgentOfficePhone": "(808) 596-0456" +"ListAgentPreferredPhone": "(808) 352-8278" +"ListAgentStateLicense": "RS-73388" +"ListOfficeEmail": "mike.james@cbrealty.com" +"ListOfficeKey": "2586830" +"ListOfficeKeyNumeric": "2586830" +"ListOfficePhone": "(808) 596-0456" +"ListingContractDate": "2026-07-31" +"ListingKeyNumeric": 1178701372 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 826.0 +"MajorChangeTimestamp": "2026-07-31T15:43:16Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-07-31" +"OriginalListPrice": 239000.0 +"OriginatingSystemKey": "19611123" +"ParcelNumber": "1-2-4-024-066-0012" +"ParkingFeatures": "None" +"PhotosChangeTimestamp": "2026-08-01T01:44:01Z" +"PhotosCount": 24 +"PostalCity": "Honolulu" +"PropertyCondition": "Average Condition" +"SourceSystemKey": "1178701372" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Makiki" +"StreetNumber": "1700" +"StreetNumberNumeric": "1700" +"StreetSuffix": "Street" +"SubdivisionName": "MAKIKI AREA" +"TaxAnnualAmount": "780.0" +"TaxAssessedValue": 223100 +"UnitNumber": "112" +"View": "Garden" +"ViewYN": true +"VirtualTourURLUnbranded": "http://player.vimeo.com/video/1172701466" +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1178701372"\n } """ +"AssociationFeeTotal": 826.0 +"TaxAssessedValueLand": "162300" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "60800" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178701372')" +"provider_name": "HICMLS" +"short_address": "Honolulu, Hawaii 96822, USA" +"RecordSignature": -913543484 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-4-024-066-0012" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485212" +"OriginatingSystemListAgentMemberKey": "3483659" +"Media": array:24 [ …24] +"DaysOnMarket": 2 +"ID": 85844 } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5264 +post_id: "85312" +post_author: 1 +"ListingKey": "1178118817" +"ListingId": "202614276" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-01T01:25:48Z" +"RFModificationTimestamp": "2026-08-01T01:29:02Z" +"ListPrice": 475000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 125453.0 +"LivingArea": 863.0 +"BuildingAreaTotal": 863.0 +"City": "Kaneohe" +"PostalCode": "96744" +"UnparsedAddress": "45-535 Luluku Road B82, Kaneohe, Hawaii 96744" +"Coordinates": array:2 [ …2] +"Latitude": 21.418555 +"Longitude": -157.804184 +"YearBuilt": 1967 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Eric R Olson" +"ListOfficeName": "Carvill Sotheby's Intl. Realty" +"ListAgentMlsId": "45231" +"ListOfficeMlsId": "CRVL" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Framed by breathtaking views of the Koolau Mountains, this beautifully renovated high-floor residence at Na Pali Gardens offers the perfect blend of modern comfort, everyday convenience, and the natural beauty that defines Windward Oahu. Offering 2 bedrooms, 1 bathroom, 863 square feet of living space, covered lanai, and 1 assigned parking stall, this beautifully updated residence features a bright, open layout filled with natural light and stunning mountain vistas. Generously sized bedrooms, a well-appointed bathroom, and tasteful finishes throughout create a welcoming, contemporary living space.\r\n \r\n Ideally located in the heart of Kaneohe, you’ll be just minutes from Windward Mall, grocery stores, restaurants, schools, and everyday conveniences. Easy access to H-3, the Pali Highway, and Likelike Highway makes commuting a breeze, while nearby Kaneohe Bay, Hoomaluhia Botanical Garden, scenic hiking trails, and the Windward Coast’s beautiful beaches offer endless opportunities to enjoy Oahu’s renowned outdoor lifestyle. """ +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFee2": "179.0" +"AssociationFeeIncludes": "Common Areas,Cable TV,Sewer,Water" +"AssociationName": "Na Pali Gardens" +"AttributionContact": "(808) 263-5900" +"BathroomsFull": 1 +"BuildingName": "Na Pali Gardens" +"CLIP": 1403263565 +"CommunityFeatures": "Community Pool,Laundry Facilities,Trash Chute" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-07-27T17:57:38.176606+00:00" +"DaysOnMarket": 6 +"DaysOnMarketReplication": 4 +"DaysOnMarketReplicationDate": "2026-07-31" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Kapunahala" +"EntryLevel": 8 +"Flooring": "Ceramic Tile,Laminate" +"Furnished": "Unfurnished" +"HighSchool": "Castle" +"HumanModifiedYN": true +"Inclusions": "Disposal,Range/Oven,Refrigerator,Washer,Water Heater" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 389-8071" +"ListAgentEmail": "eric@carvillsir.com" +"ListAgentKey": "10774142" +"ListAgentKeyNumeric": "10774142" +"ListAgentOfficePhone": "(808) 263-5900" +"ListAgentPreferredPhone": "(808) 389-8071" +"ListAgentStateLicense": "RB-22855" +"ListOfficeEmail": "scott@carvillsir.com" +"ListOfficeKey": "2587434" +"ListOfficeKeyNumeric": "2587434" +"ListOfficePhone": "(808) 263-5900" +"ListingContractDate": "2026-07-27" +"ListingKeyNumeric": 1178118817 +"ListingService": "Full Service" +"MLSAreaMajor": "Kaneohe" +"MaintenanceExpense": 787.05 +"MajorChangeTimestamp": "2026-07-27T07:53:12Z" +"MiddleOrJuniorSchool": "King" +"MlsStatus": "Active" +"OnMarketDate": "2026-07-27" +"OpenParkingYN": true +"OriginalListPrice": 475000.0 +"OriginatingSystemKey": "19597352" +"ParcelNumber": "1-4-5-030-001-0060" +"ParkingFeatures": "Assigned,Guest,One Space,On Street" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-07-27T19:05:01Z" +"PhotosCount": 24 +"PostalCity": "Kaneohe" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Elevator Secured,Key Card Entry" +"SourceSystemKey": "1178118817" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Luluku" +"StreetNumber": "45-535" +"StreetSuffix": "Road" +"SubdivisionName": "PUOHALA VILLAGE" +"TaxAnnualAmount": "1489.32" +"TaxAssessedValue": 425500 +"UnitNumber": "B82" +"View": "Mountain(s), Sunset" +"ViewYN": true +"ZoningDescription": "42 - I-2 General Industrial Dis" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1178118817"\n } """ +"AssociationFeeTotal": 966.0 +"TaxAssessedValueLand": "44900" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "380" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178118817')" +"provider_name": "HICMLS" +"RecordSignature": 342731968 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-4-5-030-001-0060" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485816" +"OriginatingSystemListAgentMemberKey": "9581019" +"Media": array:24 [ …24] +"ID": "85312" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5265 +post_id: "85628" +post_author: 1 +"ListingKey": "1169136679" +"ListingId": "202609942" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-31T05:46:31Z" +"RFModificationTimestamp": "2026-07-31T05:51:00Z" +"ListPrice": 345888.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 322.0 +"BuildingAreaTotal": 367.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "444 Kanekapolei Street 1504, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.2790457 +"Longitude": -157.8236645 +"YearBuilt": 1968 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kristy Lynn Nakamura" +"ListOfficeName": "eXp Realty" +"ListAgentMlsId": "51137" +"ListOfficeMlsId": "EXPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Perched on the 15th floor of the iconic Aloha Surf Hotel, this deluxe, high-floor, fully renovated studio delivers legal Waikiki short-term rental income and your own island escape, just two blocks from the beach. Sweeping city and Ala Wai canal views frame cool mauka breezes, while a modern split AC keeps the bright 322 sq ft retreat comfortable year-round. Smart, stylish updates, a clean kitchenette, and an open, light-filled layout make every inch count. Tucked on the building's quiet side, it is your front-row seat to the Friday-night fireworks after a day in the surf. As a true condotel with hotel-resort zoning, the choice is yours: personal getaway, cash-flowing vacation rental, or both. Owners enjoy on-site management plus resort-style amenities including pool, BBQ, fitness room, lounge, laundry, on-site spa, restaurant, and security, all wrapped around a stylish, welcoming lobby. Walk to Waikiki's best dining, shopping, bus lines, and golden sand. Turnkey, income-ready, and impossibly well-located, this is the Waikiki lifestyle and investment opportunity you have been waiting for. Schedule your private showing today!" +"ArchitecturalStyle": "High Rise" +"AssociationFeeIncludes": "Common Areas,Cable TV,Electricity,Hot Water,Internet,None,Sewer,Water" +"AttributionContact": "(808) 725-2794" +"BathroomsFull": 1 +"BuildingName": "Aloha Surf Hotel" +"CLIP": 5376924204 +"CoListAgentDirectPhone": "(808) 725-2794" +"CoListAgentEmail": "austin@kahomegourp.com" +"CoListAgentFullName": "Austin Y Nakamura" +"CoListAgentKey": "26088824" +"CoListAgentKeyNumeric": "26088824" +"CoListAgentMlsId": "54516" +"CoListAgentPreferredPhone": "(808) 358-5262" +"CoListOfficeEmail": "hi.broker@exprealty.net" +"CoListOfficeKey": "2589160" +"CoListOfficeKeyNumeric": "2589160" +"CoListOfficeMlsId": "EXPI" +"CoListOfficeName": "eXp Realty" +"CoListOfficePhone": "(808) 725-2794" +"CommunityFeatures": "Barbecue,Community Pool,Conference/Meeting Room,Laundry Facilities,Trash Chute" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-05-23T18:38:53.636836+00:00" +"DaysOnMarket": 72 +"DaysOnMarketReplication": 69 +"DaysOnMarketReplicationDate": "2026-07-30" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure,See Remarks" +"EntryLevel": 15 +"Flooring": "Ceramic Tile" +"FrontageType": "Other" +"Furnished": "Partially" +"HumanModifiedYN": true +"Inclusions": "AC Split,Cable TV,Microwave Hood,Other,Refrigerator,Smoke Detector" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 725-2794" +"ListAgentEmail": "kristy@youroahuhome.com" +"ListAgentKey": "18300141" +"ListAgentKeyNumeric": "18300141" +"ListAgentOfficePhone": "(808) 725-2794" +"ListAgentPreferredPhone": "(808) 725-2794" +"ListAgentStateLicense": "RB-24579" +"ListOfficeEmail": "hi.broker@exprealty.net" +"ListOfficeKey": "2589160" +"ListOfficeKeyNumeric": "2589160" +"ListOfficePhone": "(808) 725-2794" +"ListingContractDate": "2026-05-22" +"ListingKeyNumeric": 1169136679 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 708.0 +"MajorChangeTimestamp": "2026-07-30T19:46:08Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-05-22" +"OriginalListPrice": 360000.0 +"OriginatingSystemKey": "19471421" +"ParcelNumber": "1-2-6-021-016-0195" +"ParkingFeatures": "None" +"PhotosChangeTimestamp": "2026-05-30T01:59:00Z" +"PhotosCount": 25 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Updated/Remodeled" +"SecurityFeatures": "Closed Circuit Camera(s),Fire Sprinkler System" +"SourceSystemKey": "1169136679" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kanekapolei" +"StreetNumber": "444" +"StreetNumberNumeric": "444" +"StreetSuffix": "Street" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "1221.24" +"TaxAssessedValue": 335500 +"UnitNumber": "1504" +"View": "City" +"ViewYN": true +"YearBuiltEffective": 2016 +"ZoningDescription": "X2 - Apartment Precinct" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1169136679"\n } """ +"AssociationFeeTotal": 708.0 +"TaxAssessedValueLand": "79000" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "256500" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1169136679')" +"provider_name": "HICMLS" +"RecordSignature": 1610708604 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-021-016-0195" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10013908" +"OriginatingSystemCoListOfficeKey": "10013908" +"OriginatingSystemListAgentMemberKey": "15739222" +"OriginatingSystemCoListAgentMemberKey": "18584551" +"Media": array:25 [ …25] +"ID": "85628" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5266 +post_id: "85591" +post_author: 1 +"ListingKey": "1178475899" +"ListingId": "202614470" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-31T04:38:01Z" +"RFModificationTimestamp": "2026-07-31T04:44:33Z" +"ListPrice": 119000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 588.0 +"BuildingAreaTotal": 588.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "425 Ena Road 607c, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.304547 +"Longitude": -157.855676 +"YearBuilt": 1958 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Michelle Anne Lynch" +"ListOfficeName": "Oceans Realty Group LLC" +"ListAgentMlsId": "25004" +"ListOfficeMlsId": "OCRG" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Welcome to this beautifully remodeled, 1 bdrm 1 Bath Leasehold Coop at The Kalia! This home is a true blank canvas with clean, modern finishes throughout. Custom kitchen and bathroom, white soft-close cabinetry, quartz countertops, extended kitchen counters, abundant cabinetry, and a little breakfast nook or workstation. New LVT flooring and fresh interior paint. Beautiful tiled shower. Brand new white plantation shutters. Enclosed lanai. Peaceful treetop setting with lush green palm trees. This one truly has it all! Tropical lush grounds. Gated entrance, fob key access, security cameras, and on-site security. Close to the beach, restaurants, shopping, and bus lines. Open BBQ area. Rooftop community laundry. Open-air lobby, security patrol, Food Pantry grocery store, bakery, bus lines, restaurants and U.S. Post Office across the street. Monthly operating expenses total $1,503.94 and include Maintenance Fee ($726.24), Lease Rent ($634.00), Property Tax ($90.00), and Cable/Internet ($54.00). Long lease with fixed lease rent increases through 2048. Parking is available for owner occupants by waitlist (approximately $130-$140 per month)." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFee2": "54.0" +"AssociationFeeIncludes": "Common Areas,Electricity,Hot Water,Sewer,Water" +"AttributionContact": "(808) 864-1534" +"BathroomsFull": 1 +"BuildingName": "Kalia" +"CLIP": 6997602007 +"CommonInterest": "Stock Cooperative" +"CommunityFeatures": "Barbecue,Laundry Facilities,Pool,Trails/Paths,Trash Chute,Gated" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-07-31T01:56:37.847334+00:00" +"DaysOnMarketReplicationDate": "2026-07-30" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 6 +"Flooring": "Ceramic Tile,Laminate" +"Furnished": "Partially" +"HumanModifiedYN": true +"Inclusions": "Ceiling Fan,Disposal,Range/Oven,Refrigerator" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LeaseAmount": "634.09" +"LeaseExpiration": "2048-01-01" +"Levels": "One" +"ListAgentDirectPhone": "(808) 864-1534" +"ListAgentEmail": "Michelle.lynch@oceansrealtygrp.com" +"ListAgentKey": "10777458" +"ListAgentKeyNumeric": "10777458" +"ListAgentOfficePhone": "(808) 864-1534" +"ListAgentPreferredPhone": "(808) 864-1534" +"ListAgentStateLicense": "RB-19390" +"ListOfficeEmail": "michelle.lynch@oceansrealtygrp.com" +"ListOfficeKey": "2974528" +"ListOfficeKeyNumeric": "2974528" +"ListOfficePhone": "(808) 864-1534" +"ListingContractDate": "2026-07-30" +"ListingKeyNumeric": 1178475899 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 727.0 +"MajorChangeTimestamp": "2026-07-30T15:53:05Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-07-30" +"OriginalListPrice": 119000.0 +"OriginatingSystemKey": "19603469" +"ParcelNumber": "1-2-6-012-066-0047" +"ParkingFeatures": "None,On Street" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-07-31T04:38:01Z" +"PhotosCount": 14 +"PoolFeatures": "Heated" +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Gated Community,Key Card Entry,Security Guard" +"SourceSystemKey": "1178475899" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Ena" +"StreetNumber": "425" +"StreetNumberNumeric": "425" +"StreetSuffix": "Road" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "1164.0" +"TaxAssessedValue": 305000 +"UnitNumber": "607C" +"View": "City, Garden, Mountain(s)" +"ViewYN": true +"YearBuiltEffective": 2025 +"ZoningDescription": "X2 - Apartment Precinct" +"ListAOR": "HI Central" +"LandTenure": "Lease Hold" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1178475899"\n } """ +"AssociationFeeTotal": 781.0 +"TaxAssessedValueLand": "83100" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "221900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178475899')" +"provider_name": "HICMLS" +"RecordSignature": -585864768 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-012-066-0047" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "14804792" +"OriginatingSystemListAgentMemberKey": "3475128" +"Media": array:14 [ …14] +"DaysOnMarket": 3 +"ID": "85591" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5267 +post_id: "85615" +post_author: 1 +"ListingKey": "1174429350" +"ListingId": "202611474" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-31T02:12:02Z" +"RFModificationTimestamp": "2026-07-31T02:18:12Z" +"ListPrice": 225000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 46261.0 +"LivingArea": 362.0 +"BuildingAreaTotal": 362.0 +"City": "Honolulu" +"PostalCode": "96814" +"UnparsedAddress": "1650 Kanunu Street 714, Honolulu, Hawaii 96814" +"Coordinates": array:2 [ …2] +"Latitude": 21.2942369 +"Longitude": -157.8375879 +"YearBuilt": 1966 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Chelsea Pferschy" +"ListOfficeName": "eXp Realty" +"ListAgentMlsId": "44813" +"ListOfficeMlsId": "EXPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Welcome to your next smart investment in the heart of Honolulu! This fully furnished studio is nestled in the sought-after Holiday Mart area, putting you minutes from Don Quijote, Walmart, Ala Moana Shopping Center, and the University of Hawaii at Manoa.\r\n At 362 square feet of fee simple ownership, this unit is move-in ready with stylish vinyl plank flooring throughout, fresh paint, and a cool, shaded exposure — perfect for keeping electricity bills in check year-round.\r\n Whether you're a first-time buyer looking to break into the Honolulu market or a savvy investor ready to grow your portfolio, fee simple ownership at $232,000 is a rare find in this location.\r\n Start your investment legacy today. Call your favorite Realtor today to make a private showing appointment. """ +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFee2": "128.0" +"AssociationFeeIncludes": "Common Areas,Electricity,Hot Water,Sewer,Water" +"AttributionContact": "(808) 725-2794" +"BathroomsFull": 1 +"BuildingName": "Holiday Manor" +"CLIP": 2198716941 +"CommunityFeatures": "Clubhouse,Community Pool,Deck/Porch,Laundry Facilities,Patio,Pool" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-06-17T06:57:46.493256+00:00" +"DaysOnMarket": 48 +"DaysOnMarketReplication": 45 +"DaysOnMarketReplicationDate": "2026-07-30" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None,Seller Disclosure" +"EntryLevel": 7 +"Flooring": "Vinyl" +"Furnished": "Furnished" +"HumanModifiedYN": true +"Inclusions": "Ceiling Fan,Drapes,Range/Oven,Refrigerator" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 754-6000" +"ListAgentEmail": "chelseapferschy@gmail.com" +"ListAgentKey": "10779023" +"ListAgentKeyNumeric": "10779023" +"ListAgentOfficePhone": "(808) 725-2794" +"ListAgentPreferredPhone": "(808) 754-6000" +"ListAgentStateLicense": "RS-76072" +"ListOfficeEmail": "hi.broker@exprealty.net" +"ListOfficeKey": "2589160" +"ListOfficeKeyNumeric": "2589160" +"ListOfficePhone": "(808) 725-2794" +"ListingContractDate": "2026-06-15" +"ListingKeyNumeric": 1174429350 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 353.0 +"MajorChangeTimestamp": "2026-07-30T16:11:45Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-06-15" +"OriginalListPrice": 232000.0 +"OriginatingSystemKey": "19516678" +"ParcelNumber": "1-2-3-019-061-0099" +"ParkingFeatures": "On Street" +"PhotosChangeTimestamp": "2026-06-15T07:46:00Z" +"PhotosCount": 20 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"SecurityFeatures": "Key Card Entry,Fire Sprinkler System" +"SourceSystemKey": "1174429350" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Kanunu" +"StreetNumber": "1650" +"StreetNumberNumeric": "1650" +"StreetSuffix": "Street" +"SubdivisionName": "PAWAA" +"TaxAnnualAmount": "864.0" +"TaxAssessedValue": 238600 +"UnitNumber": "714" +"View": "City, Garden, Mountain(s)" +"ViewYN": true +"ZoningDescription": "13 - A-3 High Density Apartment" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1174429350"\n } """ +"AssociationFeeTotal": 481.0 +"TaxAssessedValueLand": "42400" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "196200" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1174429350')" +"provider_name": "HICMLS" +"RecordSignature": -955477129 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-019-061-0099" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10013908" +"OriginatingSystemListAgentMemberKey": "9295863" +"Media": array:20 [ …20] +"ID": "85615" } 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5268 +post_id: "85537" +post_author: 1 +"ListingKey": "1178296834" +"ListingId": "202614362" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-31T01:59:17Z" +"RFModificationTimestamp": "2026-07-31T02:03:49Z" +"ListPrice": 1099000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 738.0 +"BuildingAreaTotal": 875.0 +"City": "Kahuku" +"PostalCode": "96731" +"UnparsedAddress": "57-077 Eleku Kuilima Place 15/163, Kahuku, Hawaii 96731" +"Coordinates": array:2 [ …2] +"Latitude": 21.679124 +"Longitude": -157.94838 +"YearBuilt": 1975 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Bryn W Kaufman" +"ListOfficeName": "Oahu RE.com" +"ListAgentMlsId": "27729" +"ListOfficeMlsId": "GIVE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Optional fully furnished turnkey 1-bed/2-bath condo in Kuilima Estates East at Turtle Bay. Ideal as a vacation rental, second home, or primary residence, and/or as fully legal short-term rental. Consistently ranked in the top 5–10% of rentals and specifically recognized for its interior design and custom craftsmanship that stands out against cookie-cutter units. Closest possible location to the resort with a beautiful and unobstructed view of the 18th hole, a 5-minute walk to the beach, and steps to the trails. Custom recessed lighting throughout, and handcrafted pendants accent for perfect mood lighting. Brand new mini-splits cool the entire space and slash energy costs. Bathroom renovations, custom kitchen countertops, new appliances, water heater, plus fully overhauled plumbing and electrical mean low overhead and no big projects ahead. With upcoming Ritz Carlton resort expansions that do not include more permitted short-term rentals, you get a coveted turnkey rental asset while the surrounding amenities expand." +"AssociationAmenities": "Management" +"AssociationFee": "1164.0" +"AssociationFeeIncludes": "Common Areas,Cable TV,Maintenance Grounds,Maintenance Structure,Sewer,Water" +"AttributionContact": "(808) 425-7887" +"BathroomsFull": 2 +"BuildingName": "Kuilima Ests East" +"CLIP": 7902787850 +"CommunityFeatures": "Barbecue,Clubhouse,Community Pool,Deck/Porch,Patio,Tennis Court(s)" +"ConstructionMaterials": "Double Wall" +"CountyOrParish": "Oahu" +"CreationDate": "2026-07-30T06:52:19.597903+00:00" +"DaysOnMarket": 4 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2026-07-30" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Kahuku" +"EntryLevel": 1 +"Flooring": "Ceramic Tile" +"HighSchool": "Kahuku" +"HumanModifiedYN": true +"Inclusions": "AC Split,Dishwasher,Disposal,Drapes,Dryer,Microwave Hood,Range Hood,Range/Oven,Refrigerator,Washer" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 425-7887" +"ListAgentEmail": "bryn@oahure.com" +"ListAgentKey": "10772716" +"ListAgentKeyNumeric": "10772716" +"ListAgentOfficePhone": "(808) 425-7887" +"ListAgentPreferredPhone": "(808) 425-7887" +"ListAgentStateLicense": "RB-21252" +"ListOfficeEmail": "bryn@oahure.com" +"ListOfficeKey": "2586143" +"ListOfficeKeyNumeric": "2586143" +"ListOfficePhone": "(808) 425-7887" +"ListingContractDate": "2026-07-29" +"ListingKeyNumeric": 1178296834 +"ListingService": "Full Service" +"MLSAreaMajor": "North Shore" +"MajorChangeTimestamp": "2026-07-29T20:48:46Z" +"MiddleOrJuniorSchool": "Kahuku" +"MlsStatus": "Active" +"OnMarketDate": "2026-07-29" +"OriginalListPrice": 1099000.0 +"OriginatingSystemKey": "19600047" +"ParcelNumber": "1-5-7-001-027-0162" +"ParkingFeatures": "None" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-07-28T06:34:00Z" +"PhotosCount": 24 +"PostalCity": "Kahuku" +"PropertyCondition": "Excellent" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1178296834" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Eleku Kuilima" +"StreetNumber": "57-077" +"StreetSuffix": "Place" +"StructureType": "Townhouse" +"SubdivisionName": "KUILIMA" +"TaxAnnualAmount": "4007.76" +"TaxAssessedValue": 1145100 +"UnitNumber": "15/163" +"View": "Golf Course,Garden" +"ViewYN": true +"YearBuiltEffective": 2023 +"ZoningDescription": "11 - A-1 Low Density Apartment" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1178296834"\n } """ +"AssociationFeeTotal": 1164.0 +"TaxAssessedValueLand": "284400" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium,Townhouse" +"TaxAssessedValueImprovement": "860700" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178296834')" +"provider_name": "HICMLS" +"RecordSignature": -1421941833 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-5-7-001-027-0162" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "8884041" +"OriginatingSystemListAgentMemberKey": "3477362" +"Media": array:24 [ …24] +"ID": "85537" } 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5269 +post_id: "63941" +post_author: 1 +"ListingKey": "1149675727" +"ListingId": "202528234" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-31T00:23:01Z" +"RFModificationTimestamp": "2026-07-31T00:29:11Z" +"ListPrice": 115000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 856.0 +"BuildingAreaTotal": 1031.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "425 Ena Roads 706b, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.304547 +"Longitude": -157.855676 +"YearBuilt": 1958 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Michelle Anne Lynch" +"ListOfficeName": "Oceans Realty Group LLC" +"ListAgentMlsId": "25004" +"ListOfficeMlsId": "OCRG" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "2bdrm 1 bath at the Kalia. Perfect for full time living or island second home. The Kalia is a Leasehold Co-op located at the gateway to Waikiki. 856 sq ft interior + 175 sq ft covered lanai. Enjoy indoor-outdoor living with a generous lanai featuring remote-controlled motorized blinds. Includes brand new plantation shutters, refrigerator, stove/oven, & dishwasher. Kitchen, breakfast bar, Bedrooms with window A/C and ceiling fans. Bath with granite counter & bowl sink. Tropical lush gardens, heated saltwater pool, BBQ area & rooftop community laundry. Secure, gated community with key fob access, security cameras & patrol. Minutes to Hilton Hawaiian Village and Waikiki Beach grab your beach gear or explore world-class dining, shopping nearby. Food Pantry, bakery & USPS across the street. Bus lines close by. Parking available for a fee; waitlist applies. Leasehold with fixed increases through 2048. Air conditioners are $65 each addl per month. Total Mo Operating fees are $2590.34 includes Maintenance and leasehold fees, Electricity, Water, sewer, and internet." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFee2": "54.0" +"AssociationFeeIncludes": "Common Areas,Cable TV,Electricity,Hot Water,None,Sewer,Water" +"AttributionContact": "(808) 864-1534" +"BathroomsFull": 1 +"BuildingName": "Kalia" +"CLIP": 8408366629 +"CommonInterest": "Stock Cooperative" +"CommunityFeatures": "Barbecue,Laundry Facilities,Pool,Trails/Paths,Gated" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2025-12-21T04:18:22.944026+00:00" +"DaysOnMarket": 226 +"DaysOnMarketReplication": 223 +"DaysOnMarketReplicationDate": "2026-07-30" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 7 +"Fencing": "Fenced, Wall" +"Flooring": "Carpet,Ceramic Tile,Laminate" +"Furnished": "Furnished" +"HumanModifiedYN": true +"Inclusions": "AC Window Unit,Cable TV,Ceiling Fan,Dishwasher,Range/Oven,Refrigerator" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LeaseAmount": "1118.12" +"LeaseExpiration": "2048-01-01" +"Levels": "One" +"ListAgentDirectPhone": "(808) 864-1534" +"ListAgentEmail": "Michelle.lynch@oceansrealtygrp.com" +"ListAgentKey": "10777458" +"ListAgentKeyNumeric": "10777458" +"ListAgentOfficePhone": "(808) 864-1534" +"ListAgentPreferredPhone": "(808) 864-1534" +"ListAgentStateLicense": "RB-19390" +"ListOfficeEmail": "michelle.lynch@oceansrealtygrp.com" +"ListOfficeKey": "2974528" +"ListOfficeKeyNumeric": "2974528" +"ListOfficePhone": "(808) 864-1534" +"ListingContractDate": "2025-12-19" +"ListingKeyNumeric": 1149675727 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1280.61 +"MajorChangeTimestamp": "2025-12-20T18:13:53Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-12-19" +"OriginalListPrice": 115000.0 +"OriginatingSystemKey": "19179856" +"ParcelNumber": "1-2-6-012-001-0054" +"ParkingFeatures": "None,On Street" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-07-31T00:23:01Z" +"PhotosCount": 19 +"PoolFeatures": "Heated" +"PostalCity": "Honolulu" +"PropertyCondition": "Average Condition" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Gated Community,Key Card Entry,Security Guard" +"SourceSystemKey": "1149675727" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Ena" +"StreetNumber": "425" +"StreetNumberNumeric": "425" +"StreetSuffix": "Road" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "1332.0" +"TaxAssessedValue": 478800 +"UnitNumber": "706B" +"View": "City, Garden, Mountain(s)" +"ViewYN": true +"ZoningDescription": "X2 - Apartment Precinct" +"ListAOR": "HI Central" +"LandTenure": "Lease Hold" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1149675727"\n } """ +"AssociationFeeTotal": 1335.0 +"TaxAssessedValueLand": "97000" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "376900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1149675727')" +"provider_name": "HICMLS" +"RecordSignature": 627374022 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-012-001-0054" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "14804792" +"OriginatingSystemListAgentMemberKey": "3475128" +"Media": array:19 [ …19] +"ID": "63941" } 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5270 +post_id: 85845 +post_author: 1 +"ListingKey": "1172020438" +"ListingId": "202610629" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-30T21:37:47Z" +"RFModificationTimestamp": "2026-07-30T22:07:40Z" +"ListPrice": 299000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 12253.0 +"LivingArea": 1200.0 +"BuildingAreaTotal": 1200.0 +"City": "Pahoa" +"PostalCode": "96778" +"UnparsedAddress": "15-303 Puni Makai Loop N, Pahoa, Hawaii 96778" +"Coordinates": array:2 [ …2] +"Latitude": 19.552134001957 +"Longitude": -154.89828797025 +"YearBuilt": 1971 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Linda Mensching" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "20898" +"ListOfficeMlsId": "CBPP04" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Welcome home to Hawaiian Parks Subdivision, where you'll enjoy private water, overhead electricity, mail delivery, and ocean cliffs just a short 3-minute drive away. Conveniently located only 10 minutes from the Puna Kai Shopping Center with restaurants, grocery shopping, gas stations, and entertainment nearby. \r\n This beautifully remodeled home has been updated from top to bottom. From the popcorn ceiling being removed to the new flooring in the living room, kitchen and primary bedroom. Pride of ownership shines in every detail. The open-concept kitchen is perfect for entertaining, cooking and gathering with family and friends. \r\n Just off the kitchen, you'll find a covered lanai ideal for barbecuing, relaxing, or enjoying your morning coffee. the owner, an epoxy artist has incorporated custom artistic touches throughout the home, including unique countertops and beautifully finished shower. The Primary suite features its own private bathroom for added comfort and convenience. Outside, the fully fenced yard is a tropical paradise filled with producing lilikoi, papaya, mountain apple, avocado, lemon, lime, macadamia nut trees, and so much more. """ +"ArchitecturalStyle": "Detached" +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 262-3104" +"BathroomsFull": 1 +"CLIP": 4413475999 +"ConstructionMaterials": "Double Wall,Wood Frame" +"CountyOrParish": "Hawaii" +"CreationDate": "2026-06-02T21:00:46.468637+00:00" +"DaysOnMarket": 61 +"DaysOnMarketReplication": 58 +"DaysOnMarketReplicationDate": "2026-07-30" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"Fencing": "Fenced, Wall" +"Flooring": "Laminate" +"FoundationDetails": "Slab" +"GarageSpaces": "2.0" +"GarageYN": true +"HumanModifiedYN": true +"Inclusions": "Ceiling Fan,Dishwasher,Dryer,Range Hood,Range/Oven,Washer" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 285-6776" +"ListAgentEmail": "Lindam@cbpacific.com" +"ListAgentKey": "10778512" +"ListAgentKeyNumeric": "10778512" +"ListAgentOfficePhone": "(808) 262-3104" +"ListAgentPreferredPhone": "(808) 285-6776" +"ListAgentStateLicense": "RB-18534" +"ListOfficeEmail": "mike.james@cbrealty.com" +"ListOfficeKey": "2586332" +"ListOfficeKeyNumeric": "2586332" +"ListOfficePhone": "(808) 262-3104" +"ListingContractDate": "2026-06-02" +"ListingKeyNumeric": 1172020438 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Interior Lot,Level" +"MLSAreaMajor": "Puna" +"MajorChangeTimestamp": "2026-07-30T11:37:28Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-06-02" +"OriginalListPrice": 325000.0 +"OriginatingSystemKey": "19492220" +"ParcelNumber": "3-1-5-066-040-0000" +"ParkingFeatures": "Two Car Garage,Two Spaces" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-07-02T00:33:02Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Pahoa" +"PropertyCondition": "Excellent" +"RoadFrontageType": "County Road" +"Sewer": "Cesspool" +"SourceSystemKey": "1172020438" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Puni Makai" +"StreetNumber": "15-303" +"StreetSuffix": "Loop" +"SubdivisionName": "HAWAIIAN PARKS" +"TaxAnnualAmount": "1980.0" +"TaxAssessedValue": 177900 +"Topography": "Level" +"UnitNumber": "N" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,High Speed Internet Available,Phone Available,Water Available" +"View": "Garden" +"ViewYN": true +"WaterSource": "Private" +"YearBuiltEffective": 1971 +"ZoningDescription": "Neighbor Island - See Remarks" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1172020438"\n } """ +"TaxAssessedValueLand": "18700" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "159200" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1172020438')" +"provider_name": "HICMLS" +"RecordSignature": -727207005 +"UniversalParcelId": "urn:reso:upi:2.0:US:15001:3-1-5-066-040-0000" +"CountrySubdivision": "15001" +"OriginatingSystemListOfficeKey": "3484714" +"OriginatingSystemListAgentMemberKey": "8834401" +"Media": array:25 [ …25] +"ID": 85845 } 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5271 +post_id: "85564" +post_author: 1 +"ListingKey": "1177886235" +"ListingId": "202614139" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-30T19:35:19Z" +"RFModificationTimestamp": "2026-07-30T19:40:13Z" +"ListPrice": 4500000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 15786.0 +"LivingArea": 1412.0 +"BuildingAreaTotal": 1748.0 +"City": "Kihei" +"PostalCode": "96753" +"UnparsedAddress": "1756 Halama Street, Kihei, Hawaii 96753" +"Coordinates": array:2 [ …2] +"Latitude": 20.7359293 +"Longitude": -156.4556478 +"YearBuilt": 1955 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Shane H Fuke" +"ListOfficeName": "Five Star Realty, Inc." +"ListAgentMlsId": "52769" +"ListOfficeMlsId": "FIVE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "RARE KIHEI BEACHFRONT OPPORTUNITY – PRICED WITH EMPHASIS ON LAND VALUE. An exceptional opportunity to acquire an oversized 15,785 sq. ft. direct beachfront property along highly desirable Halama Street on Maui’s South Shore. With limited beachfront land available, the value here is in the land, location and long-term potential. Enjoy breathtaking panoramic ocean and outer-island views of Lanai, Kahoolawe, West Maui and Molokini. The property fronts a peaceful sandy beach sheltered by offshore reefs, creating calm, shallow waters ideal for swimming and paddling. An existing 3-bedroom, 2-bath residence provides the opportunity to enjoy, rent or renovate while exploring the potential for a future custom beachfront estate, subject to applicable governmental approvals. Conveniently located near restaurants, coffee shops, shopping, parks, tennis courts and golf. Acquire the land. Enjoy it today. Create your vision for tomorrow. A truly rare opportunity to secure a substantial fee-simple beachfront parcel in one of South Maui’s most desirable locations. Whether held for the future, renovated or reimagined, this is an opportunity to own an irreplaceable piece of Maui beachfront." +"ArchitecturalStyle": "Detached" +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 382-6871" +"BathroomsFull": 2 +"CLIP": 7648794760 +"CoListAgentDirectPhone": "(808) 382-6871" +"CoListAgentEmail": "Ky@FiveStarRealty.org" +"CoListAgentFullName": "Ky Lao" +"CoListAgentKey": "10779181" +"CoListAgentKeyNumeric": "10779181" +"CoListAgentMlsId": "45384" +"CoListAgentPreferredPhone": "(808) 258-9698" +"CoListOfficeEmail": "vincent@fivestarrealty.org" +"CoListOfficeKey": "2588170" +"CoListOfficeKeyNumeric": "2588170" +"CoListOfficeMlsId": "FIVE" +"CoListOfficeName": "Five Star Realty, Inc." +"CoListOfficePhone": "(808) 382-6871" +"ConstructionMaterials": "Masonry,Single Wall,Stucco" +"CountyOrParish": "Maui" +"CreationDate": "2026-07-30T19:39:51.335947+00:00" +"DaysOnMarketReplicationDate": "2026-07-30" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "1031 Exchange,Familial Relation,Principal is Real Estate Licensed,Seller Disclosure" +"Flooring": "Ceramic Tile" +"FrontageType": "Oceanfront" +"Furnished": "Partially" +"HumanModifiedYN": true +"Inclusions": "None" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 223-9919" +"ListAgentEmail": "shane@fivestarrealty.org" +"ListAgentKey": "21403045" +"ListAgentKeyNumeric": "21403045" +"ListAgentOfficePhone": "(808) 382-6871" +"ListAgentPreferredPhone": "(808) 223-9919" +"ListAgentStateLicense": "RS-85663" +"ListOfficeEmail": "vincent@fivestarrealty.org" +"ListOfficeKey": "2588170" +"ListOfficeKeyNumeric": "2588170" +"ListOfficePhone": "(808) 382-6871" +"ListingContractDate": "2026-07-30" +"ListingKeyNumeric": 1177886235 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Interior Lot" +"MLSAreaMajor": "Maui" +"MajorChangeTimestamp": "2026-07-30T09:34:46Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-07-30" +"OriginalListPrice": 4500000.0 +"OriginatingSystemKey": "19593408" +"ParcelNumber": "2-3-9-012-008-0000" +"ParkingFeatures": "Boat,Driveway,Three or more Spaces,On Street" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2026-07-22T23:58:01Z" +"PhotosCount": 6 +"PoolFeatures": "None" +"PostalCity": "Kihei" +"PropertyCondition": "Average Condition,Updated/Remodeled" +"RoadFrontageType": "County Road" +"SourceSystemKey": "1177886235" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Halama" +"StreetNumber": "1756" +"StreetNumberNumeric": "1756" +"StreetSuffix": "Street" +"SubdivisionName": "KIHEI" +"TaxAnnualAmount": "25644.0" +"TaxAssessedValue": 4823600 +"Topography": "Sloping" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,Phone Available,Sewer Available,Water Available" +"View": "Ocean" +"ViewYN": true +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=A1m3dHb9q6y" +"YearBuiltEffective": 2006 +"ZoningDescription": "07 - R-3.5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1177886235"\n } """ +"TaxAssessedValueLand": "4681200" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "142200" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1177886235')" +"provider_name": "HICMLS" +"short_address": "Kihei, Hawaii 96753, USA" +"RecordSignature": -618058186 +"UniversalParcelId": "urn:reso:upi:2.0:US:15009:2-3-9-012-008-0000" +"CountrySubdivision": "15009" +"OriginatingSystemListOfficeKey": "3486552" +"OriginatingSystemCoListOfficeKey": "3486552" +"OriginatingSystemListAgentMemberKey": "16925792" +"OriginatingSystemCoListAgentMemberKey": "9677937" +"Media": array:6 [ …6] +"DaysOnMarket": 4 +"ID": "85564" } 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5272 +post_id: "81907" +post_author: 1 +"ListingKey": "1157788897" +"ListingId": "202607680" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-30T02:28:02Z" +"RFModificationTimestamp": "2026-07-30T02:32:27Z" +"ListPrice": 2680000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 12718.0 +"LivingArea": 6560.0 +"BuildingAreaTotal": 7762.0 +"City": "Honolulu" +"PostalCode": "96825" +"UnparsedAddress": "928 Puuomao Place, Honolulu, Hawaii 96825" +"Coordinates": array:2 [ …2] +"Latitude": 21.3090129 +"Longitude": -157.7095524 +"YearBuilt": 1975 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "David Cordeiro" +"ListOfficeName": "Keller Williams Honolulu" +"ListAgentMlsId": "50274" +"ListOfficeMlsId": "KWPP" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Nestled in a highly desirable Hawaii Kai neighborhood, this exceptional home at 928 Puuomao Place offers breathtaking panoramic views of the ocean, coastline, and surrounding mountains. Enjoy stunning sunrises and tranquil island breezes from this peaceful, elevated location.\r\n \r\n Situated on a quiet cul-de-sac, the property provides both privacy and convenience-just minutes from world-class beaches, scenic hiking trails, marina activities, shopping centers, dining, and top-rated schools. The home's prime location perfectly balances serene island living with easy access to all that East Honolulu has to offer.\r\n \r\n A rare opportunity to own a view property in one of Oahu's most sought-after communities. """ +"ArchitecturalStyle": "Detached" +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 596-2888" +"BathroomsFull": 5 +"CLIP": 3424644391 +"CommunityFeatures": "Deck/Porch,Other,Patio" +"ConstructionMaterials": "Other" +"CountyOrParish": "Oahu" +"CreationDate": "2026-04-18T19:19:50.235115+00:00" +"DaysOnMarket": 106 +"DaysOnMarketReplication": 102 +"DaysOnMarketReplicationDate": "2026-07-29" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None,See Remarks" +"ExteriorFeatures": "Landscaping" +"Fencing": "Fenced, Wall" +"Flooring": "Laminate, Vinyl" +"FrontageType": "Other" +"HumanModifiedYN": true +"Inclusions": "AC Window Unit,Dishwasher,Dryer,Other,Range Hood,Smoke Detector,Water Heater" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 551-2704" +"ListAgentEmail": "david.cordeiro@kw.com" +"ListAgentKey": "13555272" +"ListAgentKeyNumeric": "13555272" +"ListAgentOfficePhone": "(808) 596-2888" +"ListAgentPreferredPhone": "(808) 551-2704" +"ListAgentStateLicense": "RS-82891" +"ListOfficeEmail": "frontdesk946@kw.com" +"ListOfficeKey": "2586166" +"ListOfficeKeyNumeric": "2586166" +"ListOfficePhone": "(808) 596-2888" +"ListingContractDate": "2026-04-18" +"ListingKeyNumeric": 1157788897 +"ListingService": "Full Service" +"LotFeatures": "Cul-De-Sac,Rim Lot" +"MLSAreaMajor": "Hawaii Kai" +"MajorChangeTimestamp": "2026-07-29T16:27:39Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-04-18" +"OriginalListPrice": 2800000.0 +"OriginatingSystemKey": "19393099" +"ParcelNumber": "1-3-9-085-009-0000" +"ParkingFeatures": "Three or more Spaces" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-04-19T23:00:00Z" +"PhotosCount": 22 +"PoolFeatures": "None" +"PostalCity": "Honolulu" +"PropertyCondition": "Good Condition,Updated/Remodeled" +"SourceSystemKey": "1157788897" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Puuomao" +"StreetNumber": "928" +"StreetNumberNumeric": "928" +"StreetSuffix": "Place" +"SubdivisionName": "HAHAIONE-UPPER" +"TaxAnnualAmount": "9089.88" +"TaxAssessedValue": 2597100 +"Topography": "Terraced" +"Utilities": "Cable Available,Other,Water Available" +"View": "Mountain(s), Ocean" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltEffective": 1998 +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1157788897"\n } """ +"TaxAssessedValueLand": "1142800" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "1454300" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1157788897')" +"provider_name": "HICMLS" +"RecordSignature": -467684228 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-3-9-085-009-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "8991040" +"OriginatingSystemListAgentMemberKey": "15029787" +"Media": array:22 [ …22] +"ID": "81907" } 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5273 +post_id: "84726" +post_author: 1 +"ListingKey": "1170763394" +"ListingId": "202610450" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-29T18:47:25Z" +"RFModificationTimestamp": "2026-07-29T18:53:32Z" +"ListPrice": 2000000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 16669.0 +"LivingArea": 3683.0 +"BuildingAreaTotal": 3683.0 +"City": "Kaneohe" +"PostalCode": "96744" +"UnparsedAddress": "45-55 Lilipuna Road, Kaneohe, Hawaii 96744" +"Coordinates": array:2 [ …2] +"Latitude": 21.425195062726 +"Longitude": -157.79251376414 +"YearBuilt": 1986 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ana Maria Contis" +"ListOfficeName": "eXp Realty" +"ListAgentMlsId": "47146" +"ListOfficeMlsId": "EXPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Discover a truly unique Windward Oahu retreat offering over 3,600 sq. ft. of flexible living space and breathtaking views of Kaneohe Bay & the Ko'olau Mountains. Designed across four distinct levels, each with its own private entrance, lanai & vaulted ceilings, this exceptional property offers endless possibilities for multigenerational living, rental income, guest accommodations, home offices, or a customized island lifestyle. The upper level features a modern kitchen with stainless steel appliances, functional attic space, a landscaped yard, and a wraparound lanai perfectly positioned to capture spectacular sunrises, cooling trade winds, and panoramic bay views. Large picture windows fill the home with natural light and showcase the stunning scenery from multiple living areas.\r\n Thoughtfully designed to maximize privacy, flexibility, and indoor-outdoor living, this property offers inviting spaces for entertaining, relaxing, and enjoying the beauty of Hawaii. Conveniently located just minutes from fwy, Kailua, beaches, hiking trails, shopping, dining, and Marine Corps Base Hawaii, this rare offering combines versatility, privacy, and unforgettable views in one exceptional location. """ +"ArchitecturalStyle": "Detached" +"AttributionContact": "(808) 725-2794" +"BathroomsFull": 4 +"CLIP": 5537258445 +"CarportYN": true +"CommunityFeatures": "Deck/Porch,Patio" +"ConstructionMaterials": "Masonry, Concrete, Stucco" +"CountyOrParish": "Oahu" +"CreationDate": "2026-06-05T02:33:52.674114+00:00" +"DaysOnMarket": 60 +"DaysOnMarketReplication": 55 +"DaysOnMarketReplicationDate": "2026-07-29" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"ElementarySchool": "Parker" +"Flooring": "Ceramic Tile,Marble,Vinyl" +"FoundationDetails": "Slab" +"Furnished": "Negotiable" +"HighSchool": "Castle" +"HumanModifiedYN": true +"Inclusions": "Blinds,Ceiling Fan,Chandelier,Dishwasher,Disposal,Dryer,Microwave,Range Hood,Range/Oven,Refrigerator,Security System,Smoke Detector,Solar Heater,Washer,Water Heater" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 800-7821" +"ListAgentEmail": "Info@CoastalHE.com" +"ListAgentKey": "10779812" +"ListAgentKeyNumeric": "10779812" +"ListAgentOfficePhone": "(808) 725-2794" +"ListAgentPreferredPhone": "(808) 800-7821" +"ListAgentStateLicense": "RB-22216" +"ListOfficeEmail": "hi.broker@exprealty.net" +"ListOfficeKey": "2589160" +"ListOfficeKeyNumeric": "2589160" +"ListOfficePhone": "(808) 725-2794" +"ListingContractDate": "2026-06-04" +"ListingKeyNumeric": 1170763394 +"ListingService": "Full Service" +"LotFeatures": "Dead End,Irregular Lot,Steep Slope" +"MLSAreaMajor": "Kaneohe" +"MajorChangeTimestamp": "2026-07-24T10:28:56Z" +"MiddleOrJuniorSchool": "King" +"MlsStatus": "Active" +"OnMarketDate": "2026-06-04" +"OriginalListPrice": 2100000.0 +"OriginatingSystemKey": "19486905" +"ParcelNumber": "1-4-5-001-045-0002" +"ParkingFeatures": "Carport,Driveway,Three or more Spaces" +"ParkingTotal": "6.0" +"PhotosChangeTimestamp": "2026-06-23T01:35:01Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Kaneohe" +"PropertyCondition": "Good Condition" +"SecurityFeatures": "Closed Circuit Camera(s)" +"SourceSystemKey": "1170763394" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Lilipuna" +"StreetNumber": "45-55" +"StreetSuffix": "Road" +"SubdivisionName": "LILIPUNA" +"TaxAnnualAmount": "8808.0" +"TaxAssessedValue": 1508800 +"Topography": "Sloping" +"UnitNumber": "B" +"Utilities": "Cable Available,High Speed Internet Available,Other,Water Available" +"View": "Coastline, Mountain(s), Ocean, Sunrise" +"ViewYN": true +"WaterSource": "Public" +"ZoningDescription": "00 - Residential" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1170763394"\n } """ +"TaxAssessedValueLand": "1053000" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "455800" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1170763394')" +"provider_name": "HICMLS" +"RecordSignature": -1870523234 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-4-5-001-045-0002" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10013908" +"OriginatingSystemListAgentMemberKey": "10827976" +"Media": array:25 [ …25] +"ID": "84726" } ] +success: true +page_size: 18 +page_count: 5 +count: 81 +after_key: "" } "RF Response Time" => "0.24 seconds" ] "RF Query: /Property?$select=ALL&$orderby=meta_value date DESC&$top=18&$filter=(StandardStatus eq 'Active') and (ExteriorFeatures eq 'Bedroom on Main Level' OR InteriorFeatures eq 'Bedroom on Main Level' OR Appliances eq 'Bedroom on Main Level')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#7989 +items: array:18 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8036 +post_id: "49973" +post_author: 1 +"ListingKey": "1100546331" +"ListingId": "202428599" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-17T19:33:00Z" +"RFModificationTimestamp": "2026-06-17T19:38:46Z" +"ListPrice": 2400000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 2235.0 +"BuildingAreaTotal": 2235.0 +"City": "Honolulu" +"PostalCode": "96813" +"UnparsedAddress": "600 Queen Street 4302, Honolulu, Hawaii 96813" +"Coordinates": array:2 [ …2] +"Latitude": 21.3020833 +"Longitude": -157.85729357311 +"YearBuilt": 2008 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Shizue S Goldblatt" +"ListOfficeName": "Sachi HI Pacific Century Prop." +"ListAgentMlsId": "24299" +"ListOfficeMlsId": "SACH" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "PRICE REDUCTION - Priced to Sell! Superb value Penthouse in Kaka'ako. Soaring above Honolulu's Skyline, welcome home to Keola Lai Penthouse #4302, a sophisticated Ocean View residence in the heart of Kaka'ako. This 2 Bedroom + Den, 2.5 Bath home has been fully re-imagined into an island-luxury retreat; discover a designer chef's kitchen with cherry cabinetry, high-end appliances, and a walk-in pantry, dedicated formal dining area, open main living area with sweeping panoramic vistas, upgraded lighting throughout, separate walk-in laundry room, a spacious lanai area with breathtaking views of paradise, and much more. The primary bedroom suite enjoys stunning ocean views, with the second bedroom and den area situated facing Diamond Head. This incredible location puts you just blocks from sandy beaches, Ala Moana Center, Ward Village, SALT, dining, shopping, entertainment, water sports and more. Capture this stunning Penthouse and enjoy Hawaii's sought-after "Work, Play, Live" lifestyle in the heart of Honolulu. Listing includes enhanced & zoomed-in photos." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Cable TV,Internet,Sewer,Water" +"AttributionContact": "(808) 596-8801" +"BathroomsFull": 2 +"BuildingName": "Keola Lai" +"CLIP": 3825956249 +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Community Pool,Fitness,Trash Chute" +"ConstructionMaterials": "Concrete" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2025-04-07T19:32:35.353522+00:00" +"DaysOnMarket": 591 +"DaysOnMarketReplication": 544 +"DaysOnMarketReplicationDate": "2026-06-17" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Royal" +"EntryLevel": 43 +"Flooring": "Hardwood, Marble" +"FrontageType": "Other" +"Furnished": "Unfurnished" +"HighSchool": "Mckinley" +"HumanModifiedYN": true +"Inclusions": "AC Central,Auto Garage Door Opener,Cable TV,Chandelier,Convection Oven,Dishwasher,Disposal,Dryer,Microwave,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 596-8801" +"ListAgentEmail": "shizue@sachihawaii.com" +"ListAgentKey": "10772411" +"ListAgentKeyNumeric": "10772411" +"ListAgentOfficePhone": "(808) 596-8801" +"ListAgentPreferredPhone": "(808) 596-8801" +"ListAgentStateLicense": "RB-18934" +"ListOfficeKey": "2588157" +"ListOfficeKeyNumeric": "2588157" +"ListOfficePhone": "(808) 596-8801" +"ListingContractDate": "2024-12-20" +"ListingKeyNumeric": 1100546331 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1887.45 +"MajorChangeTimestamp": "2025-09-22T09:15:18Z" +"MlsStatus": "Active" +"OnMarketDate": "2024-12-20" +"OriginalListPrice": 2550000.0 +"OriginatingSystemKey": "18447183" +"ParcelNumber": "1-2-1-048-008-0352" +"ParkingFeatures": "Covered,Three or more Spaces,Secured" +"ParkingTotal": "3.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-06-17T19:33:00Z" +"PhotosCount": 25 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Key Card Entry,Fire Sprinkler System,Security Guard" +"SourceSystemKey": "1100546331" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Queen" +"StreetNumber": "600" +"StreetNumberNumeric": "600" +"StreetSuffix": "Street" +"SubdivisionName": "KAKAAKO" +"TaxAnnualAmount": "22179.48" +"TaxAssessedValue": 2594700 +"UnitNumber": "4302" +"View": "Ocean, Sunset" +"ViewYN": true +"VirtualTourURLUnbranded": "https://express.adobe.com/page/FhXpuV8L9qHq0/" +"ZoningDescription": "Kak – Kakaako Community Development Project" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1100546331"\n } """ +"AssociationFeeTotal": 1887.0 +"TaxAssessedValueLand": "188300" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "2406400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1100546331')" +"provider_name": "HICMLS" +"RecordSignature": -2080472080 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-1-048-008-0352" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486539" +"OriginatingSystemListAgentMemberKey": "3474821" +"Media": array:25 [ …25] +"ID": "49973" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8034 +post_id: "52356" +post_author: 1 +"ListingKey": "1114298333" +"ListingId": "202512414" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-11T00:09:46Z" +"RFModificationTimestamp": "2026-03-11T00:11:54Z" +"ListPrice": 395000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 84201.0 +"LivingArea": 616.0 +"BuildingAreaTotal": 616.0 +"City": "Waipahu" +"PostalCode": "96797" +"UnparsedAddress": "94-249 Waikele Road B214, Waipahu, Hawaii 96797" +"Coordinates": array:2 [ …2] +"Latitude": 21.3866667 +"Longitude": -158.009166 +"YearBuilt": 1964 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Joyce Anna Miller" +"ListOfficeName": "20 Degrees North Real Estate" +"ListAgentMlsId": "49927" +"ListOfficeMlsId": "DGRS" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Welcome home to Plantation View Hale! This lovely corner end, 2 bedroom 1 bath unit features, fresh paint, newer appliances, the popcorn ceiling has been removed throughout, updated bathroom, open kitchen layout, and freshly painted lanai. This unit has 1 dedicated parking stall, and 3 guest stalls with ample street parking. Conveniently located near bus stops, grocery stores, shopping, hwy." +"ArchitecturalStyle": "Low Rise" +"AssociationFee2": "75.0" +"AssociationFeeIncludes": "Common Areas,Electricity,Hot Water,Sewer,Water" +"AttributionContact": "(808) 388-5555" +"BathroomsFull": 1 +"BuildingName": "Plantation View Hale" +"CLIP": 3250824858 +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Community Pool,Pool" +"ConstructionMaterials": "Masonry, Stucco" +"CountyOrParish": "Oahu" +"CreationDate": "2025-05-20T02:56:40.626854+00:00" +"DaysOnMarket": 440 +"DaysOnMarketReplication": 295 +"DaysOnMarketReplicationDate": "2026-03-10" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,Pet on Property" +"EntryLevel": 2 +"Flooring": "Laminate" +"Furnished": "Negotiable" +"HumanModifiedYN": true +"Inclusions": "Ceiling Fan,Disposal,Drapes,Microwave,Range/Oven,Refrigerator,Smoke Detector,Water Heater" +"InteriorFeatures": "Bedroom on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 600-4255" +"ListAgentEmail": "joyceanna@20degreesn.com" +"ListAgentKey": "13403319" +"ListAgentKeyNumeric": "13403319" +"ListAgentOfficePhone": "(808) 388-5555" +"ListAgentPreferredPhone": "(808) 600-4255" +"ListAgentStateLicense": "RS-82536" …53 } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8039 …118} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8016 …116} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8035 …135} 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8040 …135} 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8041 …126} 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8017 …138} 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8014 …121} 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8012 …120} 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8011 …121} 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8018 …141} 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8043 …126} 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8042 …140} 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7985 …129} 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7986 …119} 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7987 …130} 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#7988 …136} ] +success: true +page_size: 18 +page_count: 5 +count: 81 +after_key: "" } "RF Response Time" => "0.24 seconds" ] ]
