192 Properties
Sort by:
Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=18&$filter=(StandardStatus eq 'Active') and PropertyCondition eq 'Excellent,Good Condition,Updated/Remodeled'&$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: "85439" +post_author: 1 +"ListingKey": "1176996584" +"ListingId": "202613530" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T20:32:51Z" +"RFModificationTimestamp": "2026-08-03T20:36:59Z" +"ListPrice": 2300000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 9064.0 +"LivingArea": 2539.0 +"BuildingAreaTotal": 3289.0 +"City": "Honolulu" +"PostalCode": "96825" +"UnparsedAddress": "889 Kaohe Place, Honolulu, Hawaii 96825" +"Coordinates": array:2 [ …2] +"Latitude": 21.2919414 +"Longitude": -157.704252 +"YearBuilt": 1971 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Dan Madden" +"ListOfficeName": "Hawaii Life" +"ListAgentMlsId": "15713" +"ListOfficeMlsId": "HLRE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Lower Mariner's Ridge - Awesome Sweeping South-Facing Views (Ocean/Marina/Koko Head & Crater) & Cool Breezes - UNIQUELY, a 2,500+ Square Foot SINGLE LEVEL Fritz Johnson-Designed Custom Home (Originally a 1400 SF "Grant Home") - Won BIA Award For Best Residential Remodel - Great Entertainment Home - Step Down 3 Steps To Living Room & Primary Suite - Office 4th Bedroom - Dramatic Entry - Very High Vaulted Ceiling With Insulation & Skylights - Central AC - Vinyl Windows/Sliders - Limestone & Hardwood Flooring - Granite Counter Tops - High End Gas Appliances - Red & White Wine Coolers & Ice Maker - Special Japanese Front Door & Etched Glass Side Panels - Dedicated Office - Large Laundry Room/Pantry - Central Vacuum System - Stucco Exterior - Tile Roof - Copper Gutters - 60 Owned Photovoltaic Panels (With Net Metering) - Large Covered Rear Deck With Views, Hot Tub & Hammock Swing - Enclosed Back Yard - Herb Garden - Plumeria, Lilikoi, Puakinikini, Hibiscus, Avocado, Ginger, Gardenia, Bougainvillia & Bird Of Paradise - Quiet Cul De Sac (Only 4 Homes) - Mariner's Ridge Association $250/Year - Sewer Fee $165.10/Two Months - No For Sale Sign - Private Showings" +"ArchitecturalStyle": "Detached" +"AssociationFee": "21.0" +"AssociationName": "Mariner Ridge" +"AttributionContact": "(800) 667-5028" +"BathroomsFull": 2 +"CLIP": 5827662847 +"CommunityFeatures": "Deck/Porch,Patio,Storage Facilities" +"ConstructionMaterials": "Double Wall,Masonry,Stucco,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-07-29T00:52:30.009125+00:00" +"DaysOnMarket": 6 +"DaysOnMarketReplication": 6 +"DaysOnMarketReplicationDate": "2026-08-03" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Pet on Property,Seller Disclosure" +"ElementarySchool": "Hahaione" +"ExteriorFeatures": "Landscaping" +"Fencing": "Fenced, Wall" +"Flooring": "Ceramic Tile,Hardwood,Marble,Other" +"Furnished": "Unfurnished" +"GarageYN": true +"HighSchool": "Kaiser" +"HumanModifiedYN": true +"Inclusions": "AC Central,Auto Garage Door Opener,Ceiling Fan,Dishwasher,Disposal,Dryer,Gas Grill,Lawn Sprinkler,Microwave,Photovoltaic - Owned,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Solar Heater,Washer,Wine Refrigerator" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 384-9933" +"ListAgentEmail": "danmadden@hawaiilife.com" +"ListAgentKey": "10778678" +"ListAgentKeyNumeric": "10778678" +"ListAgentOfficePhone": "(800) 667-5028" +"ListAgentPreferredPhone": "(808) 384-9933" +"ListAgentStateLicense": "RB-15535" +"ListOfficeEmail": "paloluckett@hawaiilife.com" +"ListOfficeKey": "2588754" +"ListOfficeKeyNumeric": "2588754" +"ListOfficePhone": "(800) 667-5028" +"ListingContractDate": "2026-07-28" +"ListingKeyNumeric": 1176996584 +"ListingService": "Full Service" +"LotFeatures": "Cul-De-Sac,Other,Level,Steep Slope" +"MLSAreaMajor": "Hawaii Kai" +"MajorChangeTimestamp": "2026-08-03T10:32:19Z" +"MiddleOrJuniorSchool": "Niu Valley" +"MlsStatus": "Active" +"OnMarketDate": "2026-07-28" +"OriginalListPrice": 2250000.0 +"OriginatingSystemKey": "19576002" +"ParcelNumber": "1-3-9-073-041-0000" +"ParkingFeatures": "Driveway,Garage,Three or more Spaces" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-07-28T19:38:02Z" +"PhotosCount": 25 +"PoolFeatures": "Pool/Spa Combo" +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"RoomType": "Entry/Foyer" +"SourceSystemKey": "1176996584" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Kaohe" +"StreetNumber": "889" +"StreetNumberNumeric": "889" +"StreetSuffix": "Place" +"SubdivisionName": "MARINERS RIDGE" +"TaxAnnualAmount": "6072.0" +"TaxAssessedValue": 1895300 +"Topography": "Level, Sloping" +"Utilities": "Cable Available,Electricity Available,High Speed Internet Available,Other,Sewer Available,Underground Utilities,Water Available" +"View": "Canal, Coastline, Garden, Mountain(s), Ocean" +"ViewYN": true +"VirtualTourURLUnbranded": "http://www.hirephoto.com/889kaohe/slideshow" +"WaterSource": "Public" +"YearBuiltEffective": 1993 +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1176996584"\n } """ +"AssociationFeeTotal": 21.0 +"TaxAssessedValueLand": "1323500" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "571800" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1176996584')" +"provider_name": "HICMLS" +"RecordSignature": -1493355883 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-3-9-073-041-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3487136" +"OriginatingSystemListAgentMemberKey": "8842879" +"Media": array:25 [ …25] +"ID": "85439" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5261 +post_id: "82633" +post_author: 1 +"ListingKey": "1157116971" +"ListingId": "202607218" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T20:30:13Z" +"RFModificationTimestamp": "2026-08-03T20:36:16Z" +"ListPrice": 329000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 114868.0 +"LivingArea": 475.0 +"BuildingAreaTotal": 633.0 +"City": "Hauula" +"PostalCode": "96717" +"UnparsedAddress": "53-549 Kamehameha Highway 201, Hauula, Hawaii 96717" +"Coordinates": array:2 [ …2] +"Latitude": 21.609712 +"Longitude": -157.912249 +"YearBuilt": 1973 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Pearl Hong" +"ListOfficeName": "Keller Williams Honolulu" +"ListAgentMlsId": "53430" +"ListOfficeMlsId": "KWPP" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "**NEW PRICE IMPROVEMENT!** Wake up to the sound of the ocean from this beautifully remodeled oceanfront 1-bedroom condo. This thoughtfully upgraded condo is offered fully furnished and move-in ready. The kitchen is fully stocked with cookware and appliances. The 158 sqf lanai is perfect for morning coffee at sunrise or unwinding in the evening with ocean views. The bathroom features an oversized shower, a rare feature. Secured FOB entry, security cameras, and an on-site manager. Additional comforts include a portable AC unit and dehumidifier to help maintain a comfortable interior environment year-round. Included with the sale is an array of lifestyle amenities such as beach gear, snorkeling equipment, fishing poles, spearfishing gear, as well as a yoga ball and exercise mat—perfect for enjoying indoor or outdoor routines. Enjoy seasonal whale sightings, while sea turtles are often seen along the shoreline. Perfect for a turn-key investment, second home, or full-time residence. **Seller will pay off current assessment of $218 to end in March 2027, bringing Maintenance fee down to $1125/mo.**NEXT OPEN HOUSE 8/30 Sun 2pm-4pm" +"ArchitecturalStyle": "Low Rise" +"AssociationAmenities": "Management" +"AssociationFee2": "218.0" +"AssociationFeeIncludes": "Common Areas,Hot Water,Sewer,Water" +"AttributionContact": "(808) 596-2888" +"BathroomsFull": 1 +"BuildingName": "Hanohano Hale" +"CLIP": 3156980957 +"CommunityFeatures": "Barbecue,Community Pool,Deck/Porch,Laundry Facilities,Patio,Pool" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-04-30T22:16:48.562530+00:00" +"DaysOnMarket": 95 +"DaysOnMarketReplication": 95 +"DaysOnMarketReplicationDate": "2026-08-03" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 2 +"Flooring": "Ceramic Tile" +"FrontageType": "Oceanfront, Waterfront" +"Furnished": "Furnished" +"Inclusions": "Ceiling Fan,Disposal,Drapes,Home Warranty,Microwave Hood,Range/Oven,Refrigerator,Security System,Smoke Detector" +"InteriorFeatures": "Single Living Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(931) 933-3521" +"ListAgentEmail": "pearlhong@kw.com" +"ListAgentKey": "22417392" +"ListAgentKeyNumeric": "22417392" +"ListAgentOfficePhone": "(808) 596-2888" +"ListAgentPreferredPhone": "(931) 933-3521" +"ListAgentStateLicense": "RS-86537" +"ListOfficeEmail": "frontdesk946@kw.com" +"ListOfficeKey": "2586166" +"ListOfficeKeyNumeric": "2586166" +"ListOfficePhone": "(808) 596-2888" +"ListingContractDate": "2026-04-30" +"ListingKeyNumeric": 1157116971 +"ListingService": "Full Service" +"MLSAreaMajor": "Kaneohe" +"MaintenanceExpense": 1125.41 +"MajorChangeTimestamp": "2026-06-19T23:26:18Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-04-30" +"OpenParkingYN": true +"OriginalListPrice": 425000.0 +"OriginatingSystemKey": "19380395" +"ParcelNumber": "1-5-3-008-001-0018" +"ParkingFeatures": "One Space" +"ParkingTotal": "1.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-08-03T20:22:02Z" +"PhotosCount": 25 +"PostalCity": "Hauula" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Key Card Entry,Security Guard" +"SourceSystemKey": "1157116971" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Kamehameha" +"StreetNumber": "53-549" +"StreetSuffix": "Highway" +"SubdivisionName": "PUNALUU" +"TaxAnnualAmount": "552.0" +"TaxAssessedValue": 229600 +"UnitNumber": "201" +"View": "Coastline, Garden, Mountain(s), Ocean, Sunrise" +"ViewYN": true +"WaterfrontYN": true +"YearBuiltEffective": 2024 +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1157116971"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1343.0 +"TaxAssessedValueLand": "90100" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "139500" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1157116971')" +"provider_name": "HICMLS" +"RecordSignature": -1248181245 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-5-3-008-001-0018" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "8991040" +"OriginatingSystemListAgentMemberKey": "17506000" +"Media": array:25 [ …25] +"ID": "82633" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5258 +post_id: "84190" +post_author: 1 +"ListingKey": "1158534711" +"ListingId": "202608239" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T20:15:29Z" +"RFModificationTimestamp": "2026-08-03T20:18:42Z" +"ListPrice": 855000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 4330.0 +"LivingArea": 1498.0 +"BuildingAreaTotal": 3026.0 +"City": "Ewa Beach" +"PostalCode": "96706" +"UnparsedAddress": "91-1018 Kamailio Street 91, Ewa Beach, Hawaii 96706" +"Coordinates": array:2 [ …2] +"Latitude": 21.315603 +"Longitude": -158.008804 +"YearBuilt": 2002 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Matthew J Iannaccio" +"ListOfficeName": "eXp Realty" +"ListAgentMlsId": "46960" +"ListOfficeMlsId": "EXPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ TURN KEY - SPACIOUS FLOOR PLAN - FULL PV SYSTEM - COMPLETELY REMODELED INTERIOR\r\n \r\n Boasting 4-bedrooms, 2.5-baths with a two-car garage & two driveway spaces, this beautiful two-story home welcomes you with an open, spacious floor plan throughout. The entire interior has been thoughtfully remodeled to create a warm and inviting atmosphere.\r\n \r\n The heart of the home is a completely updated kitchen featuring modern cabinetry, fresh fixtures, and quality finishes that blend style with functionality. Both bathrooms have been reimagined with new vanities, updated fixtures, and contemporary finishes—including the primary bath with its elegant dual vanity and ample closet space.\r\n \r\n New flooring flows seamlessly throughout the home, enhancing the open layout and creating a cohesive, refreshed feel in every room. The grand primary bedroom includes a bonus room perfect for an office or personal retreat, giving you flexibility to work from home or pursue hobbies in comfort. """ +"ArchitecturalStyle": "Detached" +"AssociationFee": "55.0" +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 725-2794" +"BathroomsFull": 2 +"CLIP": 4691153805 +"CoListAgentDirectPhone": "(808) 420-5082" +"CoListAgentEmail": "hawaiirealtorben@gmail.com" +"CoListAgentFullName": "Ben Janszen" +"CoListAgentKey": "24548531" +"CoListAgentKeyNumeric": "24548531" +"CoListAgentMlsId": "54180" +"CoListAgentPreferredPhone": "(808) 420-5082" +"CoListOfficeEmail": "hi.broker@exprealty.net" +"CoListOfficeKey": "2589160" +"CoListOfficeKeyNumeric": "2589160" +"CoListOfficeMlsId": "EXPI" +"CoListOfficeName": "eXp Realty" +"CoListOfficePhone": "(808) 725-2794" +"CommunityFeatures": "Deck/Porch,Playground,Patio" +"ConstructionMaterials": "Masonry, Stucco" +"CountyOrParish": "Oahu" +"CreationDate": "2026-06-24T20:13:02.490947+00:00" +"DaysOnMarket": 40 +"DaysOnMarketReplication": 40 +"DaysOnMarketReplicationDate": "2026-08-03" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None,Seller Disclosure" +"Fencing": "Fenced, Wall" +"Flooring": "Hardwood, Laminate" +"Furnished": "Unfurnished" +"GarageSpaces": "2.0" +"GarageYN": true +"Inclusions": "AC Central,Auto Garage Door Opener,Blinds,Ceiling Fan,Dishwasher,Disposal,Dryer,Lawn Sprinkler,Microwave,Photovoltaic – Leased,Range/Oven,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 222-0478" +"ListAgentEmail": "matt.hirealtor@gmail.com" +"ListAgentKey": "10774592" +"ListAgentKeyNumeric": "10774592" +"ListAgentOfficePhone": "(808) 725-2794" +"ListAgentPreferredPhone": "(808) 222-0478" +"ListAgentStateLicense": "RB-23540" +"ListOfficeEmail": "hi.broker@exprealty.net" +"ListOfficeKey": "2589160" +"ListOfficeKeyNumeric": "2589160" +"ListOfficePhone": "(808) 725-2794" +"ListingContractDate": "2026-06-24" +"ListingKeyNumeric": 1158534711 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Interior Lot,Level" +"MLSAreaMajor": "Ewaplain" +"MaintenanceExpense": 708.0 +"MajorChangeTimestamp": "2026-08-03T10:11:27Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-06-24" +"OriginalListPrice": 870000.0 +"OriginatingSystemKey": "19413079" +"ParcelNumber": "1-9-1-010-071-0003" +"ParkingFeatures": "Driveway,Two Car Garage,Two Spaces,On Street" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-06-24T20:14:01Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Ewa Beach" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"SecurityFeatures": "Security Guard" +"SourceSystemKey": "1158534711" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Kamailio" +"StreetNumber": "91-1018" +"StreetSuffix": "Street" +"SubdivisionName": "EWA GEN TERRAZZA" +"TaxAnnualAmount": "2511.0" +"TaxAssessedValue": 815700 +"Topography": "Level" +"UnitNumber": "91" +"Utilities": "Cable Available,Electricity Available,High Speed Internet Available,Sewer Available,Underground Utilities,Water Available" +"View": "None" +"WaterSource": "Public" +"YearBuiltEffective": 2024 +"ZoningDescription": "11 - A-1 Low Density Apartment" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1158534711"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 763.0 +"TaxAssessedValueLand": "519500" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "296200" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1158534711')" +"provider_name": "HICMLS" +"RecordSignature": -1713885920 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-1-010-071-0003" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10013908" +"OriginatingSystemCoListOfficeKey": "10013908" +"OriginatingSystemListAgentMemberKey": "10699461" +"OriginatingSystemCoListAgentMemberKey": "18194062" +"Media": array:25 [ …25] +"ID": "84190" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5262 +post_id: "85794" +post_author: 1 +"ListingKey": "1178739367" +"ListingId": "202614781" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T17:19:02Z" +"RFModificationTimestamp": "2026-08-03T17:24:43Z" +"ListPrice": 1188000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 3756.0 +"LivingArea": 1516.0 +"BuildingAreaTotal": 1736.0 +"City": "Ewa Beach" +"PostalCode": "96706" +"UnparsedAddress": "91-517 Kuhialoko Street, Ewa Beach, Hawaii 96706" +"Coordinates": array:2 [ …2] +"Latitude": 21.315603 +"Longitude": -158.008804 +"YearBuilt": 1998 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Yolly Pascua" +"ListOfficeName": "eXp Realty" +"ListAgentMlsId": "47024" +"ListOfficeMlsId": "EXPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Don't miss this rare opportunity to own a golf course-front home in the peaceful Kula Lei neighborhood! Enjoy tropical living in this beautifully upgraded and maintained residence, perfectly positioned along Coral Creek Golf Course. With over $100,000 in improvements, this home offers sweeping fairway views, a spacious backyard, and a peaceful setting where you can start your day with a cup of coffee while listening to birds sing and taking in the tranquil golf course scenery.\r\n \r\n The open-concept layout features vaulted ceilings, a covered lanai, and seamless flow throughout the living spaces, making it ideal for both everyday living and entertaining. A spacious and versatile family room offers the flexibility to serve as a fourth bedroom, home office, media room, or guest suite. Upstairs, the primary suite overlooks the fairways.\r\n \r\n Conveniently located near Ka Makana Ali?i, H-1 freeway access, Skyline, parks, schools, dining, shopping, and beaches, with Coral Creek Championship Golf Course just beyond your backyard. Enjoy refreshing trade winds, breathtaking sunrise views, and the rare opportunity to own golf course-front home in Hawaii. A must see! """ +"ArchitecturalStyle": "Detached" +"AssociationFee": "55.0" +"AssociationName": "Ewa by Gentry" +"AttributionContact": "(808) 725-2794" +"BathroomsFull": 2 +"CLIP": 6285407740 +"CommunityFeatures": "Deck/Porch,Patio" +"ConstructionMaterials": "Double Wall,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-08-02T18:49:56.062294+00:00" +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Principal is Real Estate Licensed" +"ExteriorFeatures": "Landscaping" +"Fencing": "Fenced, Wall" +"Flooring": "Vinyl" +"FrontageType": "Golf Course" +"Furnished": "Partially" +"GarageYN": true +"HumanModifiedYN": true +"Inclusions": "AC Split,Auto Garage Door Opener,Ceiling Fan,Chandelier,Disposal,Dryer,Fireplace,Lawn Sprinkler,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Washer" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 352-4822" +"ListAgentEmail": "yolanda.pascua@exprealty.com" +"ListAgentKey": "10774707" +"ListAgentKeyNumeric": "10774707" +"ListAgentOfficePhone": "(808) 725-2794" +"ListAgentPreferredPhone": "(808) 352-4822" +"ListAgentStateLicense": "RS-78988" +"ListOfficeEmail": "hi.broker@exprealty.net" +"ListOfficeKey": "2589160" +"ListOfficeKeyNumeric": "2589160" +"ListOfficePhone": "(808) 725-2794" +"ListingContractDate": "2026-08-02" +"ListingKeyNumeric": 1178739367 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Other, Level" +"MLSAreaMajor": "Ewaplain" +"MajorChangeTimestamp": "2026-08-02T08:46:59Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-08-02" +"OriginalListPrice": 1188000.0 +"OriginatingSystemKey": "19613153" +"ParcelNumber": "1-9-1-093-011-0000" +"ParkingFeatures": "Driveway,Garage,Three or more Spaces,On Street" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-08-03T17:19:02Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Ewa Beach" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"RoadFrontageType": "County Road" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1178739367" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Kuhialoko" +"StreetNumber": "91-517" +"StreetSuffix": "Street" +"SubdivisionName": "EWA GEN KULA LEI" +"TaxAnnualAmount": "2796.84" +"TaxAssessedValue": 919100 +"Topography": "Level" +"Utilities": "Electricity Available,Sewer Available,Underground Utilities,Water Available" +"View": "Sunrise" +"WaterSource": "Public" +"YearBuiltEffective": 2022 +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1178739367"\n } """ +"AssociationFeeTotal": 55.0 +"TaxAssessedValueLand": "652400" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "266700" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178739367')" +"provider_name": "HICMLS" +"RecordSignature": -2094702598 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-1-093-011-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10013908" +"OriginatingSystemListAgentMemberKey": "10753431" +"Media": array:25 [ …25] +"DaysOnMarket": 0 +"ID": "85794" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5260 +post_id: "85429" +post_author: 1 +"ListingKey": "1178479341" +"ListingId": "202614478" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T05:44:25Z" +"RFModificationTimestamp": "2026-08-03T05:45:40Z" +"ListPrice": 1389000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 6320.0 +"LivingArea": 1492.0 +"BuildingAreaTotal": 1716.0 +"City": "Aiea" +"PostalCode": "96701" +"UnparsedAddress": "98-1022 Kupukupu Place, Aiea, Hawaii 96701" +"Coordinates": array:2 [ …2] +"Latitude": 21.4032394 +"Longitude": -157.9443824 +"YearBuilt": 1974 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Anina M Quaranto" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "43950" +"ListOfficeMlsId": "CBPP" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Perched in a prime Newtown location, this meticulously maintained single-level residence captures refreshing trade wind breezes and beautiful ocean and Pearl Harbor views from its spacious balcony. Featuring 4 bedrooms and 2 bathrooms, the light-filled interior is enhanced by vaulted ceilings, updated windows, improved flooring, and tastefully renovated kitchen and bath spaces. Pride of ownership shines throughout, with thoughtful upkeep and practical improvements including an asphalt roof, interior washer and dryer, and generous under-home storage. Outside, the low-maintenance yard and patio offer additional space to relax and enjoy the peaceful surroundings. Located in one of Central Oahu's most sought-after communities, Newtown is known for its underground utilities, walkable streets, strong sense of community, and convenient access to shopping, dining, schools, military bases, and freeway connections. A rare opportunity to own a move-in ready home with views, breezes, and the exceptional lifestyle Newtown residents enjoy. Not to mention access to Newtown Community Rec Center providing amenities like pools, gyms, and courts for its members!" +"ArchitecturalStyle": "Detached" +"AssociationName": "Newtown Estates" +"AttributionContact": "(808) 596-0456" +"BathroomsFull": 2 +"CLIP": 6280651570 +"ConstructionMaterials": "Double Wall,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-07-28T21:44:44.932904+00:00" +"DaysOnMarket": 5 +"DaysOnMarketReplication": 5 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"Flooring": "Carpet,Ceramic Tile,Laminate" +"GarageYN": true +"HumanModifiedYN": true +"Inclusions": "Auto Garage Door Opener,Book Shelves,Ceiling Fan,Dishwasher,Disposal,Drapes,Dryer,Microwave Hood,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 397-7732" +"ListAgentEmail": "anina.quaranto@cbrealty.com" +"ListAgentKey": "10773489" +"ListAgentKeyNumeric": "10773489" +"ListAgentOfficePhone": "(808) 596-0456" +"ListAgentPreferredPhone": "(808) 397-7732" +"ListAgentStateLicense": "RB-23346" +"ListOfficeEmail": "mike.james@cbrealty.com" +"ListOfficeKey": "2586830" +"ListOfficeKeyNumeric": "2586830" +"ListOfficePhone": "(808) 596-0456" +"ListingContractDate": "2026-07-28" +"ListingKeyNumeric": 1178479341 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Corner Lot" +"MLSAreaMajor": "Pearl City" +"MaintenanceExpense": 55.0 +"MajorChangeTimestamp": "2026-07-28T11:40:57Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-07-28" +"OriginalListPrice": 1389000.0 +"OriginatingSystemKey": "19603586" +"ParcelNumber": "1-9-8-057-016-0000" +"ParkingFeatures": "Driveway,Garage,Three or more Spaces,On Street" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-07-29T03:01:01Z" +"PhotosCount": 25 +"PoolFeatures": "Community" +"PostalCity": "Aiea" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"RoadFrontageType": "County Road" +"SourceSystemKey": "1178479341" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Kupukupu" +"StreetNumber": "98-1022" +"StreetSuffix": "Place" +"SubdivisionName": "NEWTOWN" +"TaxAnnualAmount": "3711.0" +"TaxAssessedValue": 1220300 +"Topography": "Other" +"Utilities": "Cable Available,Electricity Available,High Speed Internet Available,Sewer Available,Underground Utilities,Water Available" +"View": "Coastline, City, Mountain(s), Ocean, Other" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltEffective": 2016 +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1178479341"\n } """ +"AssociationFeeTotal": 55.0 +"TaxAssessedValueLand": "1002600" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "217700" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178479341')" +"provider_name": "HICMLS" +"RecordSignature": 805046953 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-8-057-016-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485212" +"OriginatingSystemListAgentMemberKey": "8806810" +"Media": array:25 [ …25] +"ID": "85429" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5257 +post_id: "85818" +post_author: 1 +"ListingKey": "1178750450" +"ListingId": "202614797" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T04:11:17Z" +"RFModificationTimestamp": "2026-08-03T04:14:27Z" +"ListPrice": 1000000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 3749.0 +"LivingArea": 1560.0 +"BuildingAreaTotal": 1725.0 +"City": "Ewa Beach" +"PostalCode": "96706" +"UnparsedAddress": "91-1191 Kaileolea Drive, Ewa Beach, Hawaii 96706" +"Coordinates": array:2 [ …2] +"Latitude": 21.315603 +"Longitude": -158.008804 +"YearBuilt": 2005 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jessel Riccardini" +"ListOfficeName": "Hawaii Modern Realty" +"ListAgentMlsId": "48126" +"ListOfficeMlsId": "BHHR03" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Looking for a home that checks all the boxes? This beautifully updated 4-bedroom, 3-bath paired single-family home in the desirable Ocean Pointe community offers the perfect blend of comfort, style, and functionality. A bedroom and full bath on the main level provide the flexibility that's ideal for guests, extended family, or a home office.\r\n Thoughtfully upgraded throughout, the home features a newer roof, A/C replaced in 2021, a remodeled kitchen with updated appliances, renovated bathrooms, and engineered flooring throughout. A Tesla Wall Charger is also included for added convenience.\r\n Conveniently located just minutes from beaches, Wai Kai Wave Pool and Lagoon, Hoakalei Country Club, schools, shopping, dining, and more, this home offers the best of island living. Come see for yourself why this could be the perfect place to call home.\r\n \r\n *Photos were taken prior to the replacement of the bedroom carpets and updating the bathrooms* """ +"AssociationFee": "164.0" +"AssociationName": "Ocean Pointe" +"AttributionContact": "(808) 792-3910" +"BathroomsFull": 3 +"CLIP": 6184387970 +"CommunityFeatures": "Deck/Porch,Patio" +"ConstructionMaterials": "Double Wall,Steel Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-08-03T04:14:24.904578+00:00" +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Pet on Property,Seller Disclosure,See Remarks" +"ExteriorFeatures": "Landscaping" +"Fencing": "Fenced, Wall" +"Flooring": "Ceramic Tile,Hardwood,Other" +"FoundationDetails": "Slab" +"FrontageType": "Other" +"Furnished": "Unfurnished" +"GarageSpaces": "2.0" +"GarageYN": true +"HumanModifiedYN": true +"Inclusions": "AC Central,Auto Garage Door Opener,Blinds,Cable TV,Ceiling Fan,Dishwasher,Disposal,Dryer,Lawn Sprinkler,Microwave Hood,Other,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 321-8944" +"ListAgentEmail": "jessel.riccardini@modernhawaii.com" +"ListAgentKey": "10780203" +"ListAgentKeyNumeric": "10780203" +"ListAgentOfficePhone": "(808) 792-3910" +"ListAgentPreferredPhone": "(808) 321-8944" +"ListAgentStateLicense": "RS-80315" +"ListOfficeEmail": "aloha@modernhawaii.com" +"ListOfficeKey": "2589368" +"ListOfficeKeyNumeric": "2589368" +"ListOfficePhone": "(808) 792-3910" +"ListingContractDate": "2026-08-02" +"ListingKeyNumeric": 1178750450 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Corner Lot,Level" +"MLSAreaMajor": "Ewaplain" +"MajorChangeTimestamp": "2026-08-02T18:11:15Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-08-02" +"OriginalListPrice": 1000000.0 +"OriginatingSystemKey": "19613682" +"ParcelNumber": "1-9-1-131-121-0000" +"ParkingFeatures": "Garage,Two Car Garage,Two Spaces" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-08-02T22:52:00Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Ewa Beach" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"RoomType": "Entry/Foyer" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1178750450" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Kaileolea" +"StreetNumber": "91-1191" +"StreetSuffix": "Drive" +"SubdivisionName": "OCEAN POINTE" +"TaxAnnualAmount": "2652.0" +"TaxAssessedValue": 887900 +"Topography": "Level" +"Utilities": "Cable Available,Electricity Available,Other,Phone Available,Underground Utilities,Water Available" +"View": "Other" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltEffective": 2020 +"ZoningDescription": "11 - A-1 Low Density Apartment" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1178750450"\n } """ +"AssociationFeeTotal": 164.0 +"TaxAssessedValueLand": "570100" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "317800" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178750450')" +"provider_name": "HICMLS" +"short_address": "Ewa Beach, Hawaii 96706, USA" +"RecordSignature": 1331034711 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-1-131-121-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "12418584" +"OriginatingSystemListAgentMemberKey": "12412967" +"Media": array:25 [ …25] +"DaysOnMarket": 0 +"ID": "85818" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5252 +post_id: "83935" +post_author: 1 +"ListingKey": "1157600815" +"ListingId": "202607536" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T03:01:14Z" +"RFModificationTimestamp": "2026-08-03T03:04:17Z" +"ListPrice": 2670000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 10500.0 +"LivingArea": 3782.0 +"BuildingAreaTotal": 4357.0 +"City": "Honolulu" +"PostalCode": "96825" +"UnparsedAddress": "1025 Hanohano Way, Honolulu, Hawaii 96825" +"Coordinates": array:2 [ …2] +"Latitude": 21.2979341 +"Longitude": -157.6807303 +"YearBuilt": 1992 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "George Lobley Jr." +"ListOfficeName": "REMAX Hawaii" +"ListAgentMlsId": "26316" +"ListOfficeMlsId": "ADVG" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Perched in prestigious Na Pali Haweo, this uniquely designed 5BD/4.5BA contemporary estate offers 3,782 sqft on a 10,500 sqft lot.\r\n Kitchen, dining, living room, wet bar & primary suite are all on the 2nd floor to capture panoramic views — ocean, coastline, Diamond\r\n Head, marina, mountain & city lights from virtually every room. Enjoy the rare luxury of both sunrise & sunset daily, with clear-day views to Molokai, Maui & the Big Island. Three tiled lanais let you embrace the views from morning to evening. New luxury vinyl plank flooring throughout with new carpet in the primary bedroom & family room. Primary suite features soaking tub, dual vanity & walk-in closet. All five bedrooms are suite-sized retreats with walk in closets - downstairs offers two en-suite bedrooms & two bedrooms connected by a full bath. Additional features include Corian Island kitchen, wet bar with sink, two family rooms, laundry room, workshop, covered porch & attached 3-car garage. 24-hour security patrol & private community park at your doorstep — $142/mo HOA. Minutes to Sandy Beach, Hanauma Bay, Koko Marina & Hawaii Kai Town Center. A rare opportunity to own one of Hawaii Kai's finest! """ +"ArchitecturalStyle": "Detached" +"AssociationFee": "142.0" +"AssociationName": "Na Pali Haweo" +"AttributionContact": "(808) 738-3600" +"BathroomsFull": 4 +"CLIP": 2963037153 +"CoListAgentDirectPhone": "(808) 398-7597" +"CoListAgentEmail": "Chikako.Lobley@remaxhawaii.com" +"CoListAgentFullName": "Chikako Lobley" +"CoListAgentKey": "10772544" +"CoListAgentKeyNumeric": "10772544" +"CoListAgentMlsId": "26078" +"CoListAgentPreferredPhone": "(808) 398-7597" +"CoListOfficeEmail": "Francis.VanRafelghem@remaxhawaii.com" +"CoListOfficeKey": "2589107" +"CoListOfficeKeyNumeric": "2589107" +"CoListOfficeMlsId": "ADVG" +"CoListOfficeName": "REMAX Hawaii" +"CoListOfficePhone": "(808) 738-3600" +"CommunityFeatures": "Deck/Porch,Patio,Storage Facilities" +"ConstructionMaterials": "Double Wall,Masonry,Concrete,Stucco" +"CountyOrParish": "Oahu" +"CreationDate": "2026-06-06T00:12:06.683463+00:00" +"DaysOnMarket": 58 +"DaysOnMarketReplication": 58 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Owner Is Listing Agent,Principal is Real Estate Licensed,Seller Disclosure" +"ElementarySchool": "Kamiloiki" +"ExteriorFeatures": "Landscaping" +"Fencing": "Fenced, Wall" +"Flooring": "Carpet,Ceramic Tile,Vinyl" +"FoundationDetails": "Slab" +"GarageYN": true +"HighSchool": "Kaiser" +"Inclusions": "Auto Garage Door Opener,Cable TV,Ceiling Fan,Chandelier,Dishwasher,Disposal,Dryer,Lawn Sprinkler,Microwave Hood,Microwave,Range/Oven,Refrigerator,Smoke Detector,Solar Heater,Washer,Water Heater" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 382-7286" +"ListAgentEmail": "George.Lobley@remaxhawaii.com" +"ListAgentKey": "10772565" +"ListAgentKeyNumeric": "10772565" +"ListAgentOfficePhone": "(808) 738-3600" +"ListAgentPreferredPhone": "(808) 382-7286" +"ListAgentStateLicense": "RS-30902" +"ListOfficeEmail": "Francis.VanRafelghem@remaxhawaii.com" +"ListOfficeKey": "2589107" +"ListOfficeKeyNumeric": "2589107" +"ListOfficePhone": "(808) 738-3600" +"ListingContractDate": "2026-06-05" +"ListingKeyNumeric": 1157600815 +"ListingService": "Full Service" +"LotFeatures": "Interior Lot,Rim Lot" +"MLSAreaMajor": "Hawaii Kai" +"MajorChangeTimestamp": "2026-07-09T08:18:05Z" +"MiddleOrJuniorSchool": "Niu Valley" +"MlsStatus": "Active" +"OnMarketDate": "2026-06-05" +"OriginalListPrice": 2700000.0 +"OriginatingSystemKey": "19388665" +"OtherStructures": "Workshop" +"ParcelNumber": "1-3-9-106-006-0000" +"ParkingFeatures": "Driveway,Garage,Three or more Spaces,On Street" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2026-06-30T01:56:00Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"RoomType": "Entry/Foyer" +"SecurityFeatures": "Security Guard" +"SourceSystemKey": "1157600815" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Hanohano" +"StreetNumber": "1025" +"StreetNumberNumeric": "1025" +"StreetSuffix": "Way" +"SubdivisionName": "NAPALI HAWEO" +"TaxAnnualAmount": "7824.0" +"TaxAssessedValue": 2731600 +"Topography": "Sloping" +"Utilities": "Cable Available,Electricity Available,High Speed Internet Available,Phone Available,Sewer Available,Underground Utilities,Water Available" +"View": "Canal, Coastline, City, Garden, Mountain(s), Ocean, Sunset, Sunrise" +"ViewYN": true +"VirtualTourURLUnbranded": "https://listings.hetproductions.com/videos/019e9905-c5b6-7383-8751-a59e9a032fdc" +"WaterSource": "Public" +"YearBuiltEffective": 2026 +"ZoningDescription": "03 - R10 - Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1157600815"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 142.0 +"TaxAssessedValueLand": "1079800" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "1651800" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1157600815')" +"provider_name": "HICMLS" +"RecordSignature": 560951367 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-3-9-106-006-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "9695164" +"OriginatingSystemCoListOfficeKey": "9695164" +"OriginatingSystemListAgentMemberKey": "3476009" +"OriginatingSystemCoListAgentMemberKey": "3475802" +"Media": array:25 [ …25] +"ID": "83935" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5263 +post_id: "82170" +post_author: 1 +"ListingKey": "1157527649" +"ListingId": "202607435" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T03:01:14Z" +"RFModificationTimestamp": "2026-08-03T03:04:27Z" +"ListPrice": 485000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 104718.0 +"LivingArea": 681.0 +"BuildingAreaTotal": 739.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "400 Hobron Lane 2309, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.2874861 +"Longitude": -157.8362151 +"YearBuilt": 1974 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Carole A Manuwa" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "22751" +"ListOfficeMlsId": "CBPP02" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ VILLA ON EATON SQUARE #2309 \r\n \r\n This Unit is 100% Fee Simple - No Sandwich Lease! ** A DREAM COME TRUE TO LIVE HERE! ** FANTASTIC LOCATION **\r\n \r\n ** BEAUTIFUL REMODELED CONDO ** OCEAN & DIAMOND HEAD VIEWS ** OPEN KITCHEN W/HUGE BAR-COUNTER ** NEW LUXURY VINYL FLOORING ** NEW PAINT ** SMOOTH CEILIINGS ** CROWN MOLDINGS ** NEW SS APPLIANCES ** NEW WASHER/DRYER ** NEW LIGHTING ** HARDWOOD CABS ** GRANITE COUNTERS ** ABUNDANT STORAGE ** COVERED LANAI ** COVERED PARKING ** ROOTOP AMENITIES W/360 VIEWS (HEATED POOL * GYM * YOGA ROOM * SAUNA ROOMS * BBQ'S) ** EASY TO SHOW ** CALL TO SEE ** """ +"ArchitecturalStyle": "High Rise" +"AssociationFeeIncludes": "Common Areas,Cable TV,Electricity,HVAC,Internet,None,Sewer,Water" +"AttributionContact": "(808) 738-3904" +"BathroomsFull": 1 +"BuildingName": "Villa On Eaton Square" +"CLIP": 4199309522 +"CommunityFeatures": "Barbecue,Community Pool,Deck/Porch,Fitness,Patio,Pool,Recreation Area,Sauna,Trash Chute" +"ConstructionMaterials": "Double Wall,Concrete,Steel Frame" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2026-04-23T03:25:39.349323+00:00" +"DaysOnMarket": 82 +"DaysOnMarketReplication": 82 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,Seller Disclosure" +"EntryLevel": 23 +"Flooring": "Ceramic Tile,Vinyl" +"FrontageType": "Other" +"Furnished": "Unfurnished" +"Inclusions": "AC Central,Cable TV,Dishwasher,Disposal,Dryer,Range Hood,Range/Oven,Refrigerator,Washer" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level,Single Living Level" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 387-8898" +"ListAgentEmail": "carole.manuwa@cbrealty.com" +"ListAgentKey": "10777366" +"ListAgentKeyNumeric": "10777366" +"ListAgentOfficePhone": "(808) 738-3904" +"ListAgentPreferredPhone": "(808) 387-8898" +"ListAgentStateLicense": "RB-18606" +"ListOfficeEmail": "mike.james@cbrealty.com" +"ListOfficeKey": "2586856" +"ListOfficeKeyNumeric": "2586856" +"ListOfficePhone": "(808) 738-3904" +"ListingContractDate": "2026-04-22" +"ListingKeyNumeric": 1157527649 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1156.81 +"MajorChangeTimestamp": "2026-06-13T17:29:43Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-04-22" +"OpenParkingYN": true +"OriginalListPrice": 485000.0 +"OriginatingSystemKey": "19386091" +"ParcelNumber": "1-2-6-013-014-0265" +"ParkingFeatures": "Covered,Open,One Space,Unassigned" +"ParkingTotal": "1.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-06-20T20:59:00Z" +"PhotosCount": 20 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry,Security Guard" +"SourceSystemKey": "1157527649" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Hobron" +"StreetNumber": "400" +"StreetNumberNumeric": "400" +"StreetSuffix": "Lane" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "1245.6" +"TaxAssessedValue": 475900 +"UnitNumber": "2309" +"View": "Coastline, City, Mountain(s), Ocean, Sunset" +"ViewYN": true +"YearBuiltEffective": 2026 +"ZoningDescription": "18 - AMX-3 High Density Apt Mix" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1157527649"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1157.0 +"TaxAssessedValueLand": "77500" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "398400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1157527649')" +"provider_name": "HICMLS" +"RecordSignature": -502170762 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-013-014-0265" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485238" +"OriginatingSystemListAgentMemberKey": "3474455" +"Media": array:20 [ …20] +"ID": "82170" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5264 +post_id: "80732" +post_author: 1 +"ListingKey": "1154481846" +"ListingId": "202605095" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T03:01:14Z" +"RFModificationTimestamp": "2026-08-03T03:04:00Z" +"ListPrice": 485000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 72615.0 +"LivingArea": 904.0 +"BuildingAreaTotal": 1046.0 +"City": "Honolulu" +"PostalCode": "96818" +"UnparsedAddress": "3130 Ala Ilima Street 26c, Honolulu, Hawaii 96818" +"Coordinates": array:2 [ …2] +"Latitude": 21.304547 +"Longitude": -157.855676 +"YearBuilt": 1981 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Roberta A Arakawa" +"ListOfficeName": "Property Insights Inc." +"ListAgentMlsId": "38147" +"ListOfficeMlsId": "PIHI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Price Reduction!! Don't miss this beautifully upgraded and remodeled 2-bedroom, 2-bathroom condo features ocean views from both bedrooms! Not to mention, the in-unit laundry, 1 covered prime parking near to the lobby entrance, totally renovated kitchen, bathrooms and flooring in 2018. The kitchen features recessed lighting, a new stainless-steel stove and stainless-steel refrigerator, quartz countertops and sleek maple cabinets to compliment the matching floors. The Horizon View Tower condo in Salt Lake, Honolulu is known for its central location, secure building, and easy access to shopping, dining, schools, proximity to the airport and freeway routes. Experience the best of Salt Lake living—modern upgrades, thoughtful features, and a place you’ll love coming home to. Contact your agent today for more information and to schedule a private showing. Open House scheduled for Aug 2, 2026 from 2-5pm." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Cable TV,Internet,Sewer,Water" +"AssociationName": "Horizon View AOAO" +"BathroomsFull": 2 +"BuildingName": "Horizon View Tower" +"CLIP": 7972709496 +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Community Pool,Conference/Meeting Room,Deck/Porch,Other,Patio,Pool,Trails/Paths,Trash Chute,Gated" +"ConstructionMaterials": "Concrete,Steel Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-03-28T04:42:29.201441+00:00" +"DaysOnMarket": 130 +"DaysOnMarketReplication": 130 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure,See Remarks" +"ElementarySchool": "Salt Lake" +"EntryLevel": 26 +"Flooring": "Ceramic Tile,Vinyl" +"FoundationDetails": "Slab" +"FrontageType": "Other" +"Furnished": "Unfurnished" +"HighSchool": "Moanalua" +"Inclusions": "Dryer,Range/Oven,Refrigerator,Washer,Water Heater" +"InteriorFeatures": "Single Living Level" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 375-0336" +"ListAgentEmail": "RobertaAArakawaRealtor@gmail.com" +"ListAgentKey": "10773121" +"ListAgentKeyNumeric": "10773121" +"ListAgentOfficePhone": "(808) 458-4880" +"ListAgentPreferredPhone": "(808) 375-0336" +"ListAgentStateLicense": "RB-22751" +"ListOfficeEmail": "nyamane@gmail.com" +"ListOfficeKey": "5203759" +"ListOfficeKeyNumeric": "5203759" +"ListOfficePhone": "(808) 458-4880" +"ListingContractDate": "2026-03-25" +"ListingKeyNumeric": 1154481846 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1027.31 +"MajorChangeTimestamp": "2026-07-24T13:29:47Z" +"MiddleOrJuniorSchool": "Moanalua" +"MlsStatus": "Active" +"OnMarketDate": "2026-03-25" +"OriginalListPrice": 499000.0 +"OriginatingSystemKey": "19320317" +"ParcelNumber": "1-1-1-058-007-0095" +"ParkingFeatures": "Assigned,Covered,Guest,Other,One Space,On Street,Secured" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-04-17T01:45:02Z" +"PhotosCount": 21 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"SecurityFeatures": "Elevator Secured,Gated Community,Key Card Entry,Security Guard" +"SourceSystemKey": "1154481846" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Ala Ilima" +"StreetNumber": "3130" +"StreetNumberNumeric": "3130" +"StreetSuffix": "Street" +"SubdivisionName": "SALT LAKE" +"TaxAnnualAmount": "2079.96" +"TaxAssessedValue": 594400 +"UnitNumber": "26C" +"View": "Coastline, City, Mountain(s), Ocean, Other, Sunset" +"ViewYN": true +"VirtualTourURLUnbranded": "https://shoots.styronphoto.com/sites/rmobbjjx/unbranded" +"YearBuiltEffective": 2018 +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1154481846"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1027.0 +"TaxAssessedValueLand": "74200" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "520200" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1154481846')" +"provider_name": "HICMLS" +"RecordSignature": -949912992 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-1-058-007-0095" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "17310015" +"OriginatingSystemListAgentMemberKey": "3481543" +"Media": array:21 [ …21] +"ID": "80732" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5265 +post_id: "79188" +post_author: 1 +"ListingKey": "1153407292" +"ListingId": "202604401" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T03:01:14Z" +"RFModificationTimestamp": "2026-08-03T03:04:01Z" +"ListPrice": 1900000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 267981.0 +"LivingArea": 1413.0 +"BuildingAreaTotal": 1468.0 +"City": "Honolulu" +"PostalCode": "96814" +"UnparsedAddress": "88 Piikoi Street 2309, Honolulu, Hawaii 96814" +"Coordinates": array:2 [ …2] +"Latitude": 21.2929048 +"Longitude": -157.847513 +"YearBuilt": 1999 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Rina Bland" +"ListOfficeName": "Sachi HI Pacific Century Prop." +"ListAgentMlsId": "53077" +"ListOfficeMlsId": "SACH" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Discover Hawaiki Tower #2309, an exceptional luxury residence situated in the sought-after '09' stack, where panoramic floor-to-ceiling windows draw in views of Diamond Head, Ala Moana Beach Park, and the Pacific Ocean. Meticulously upgraded, this high-end 2-bedroom, 2-bath front-corner residence includes a new luxury kitchen with built-in bar seating, two fully upgraded luxury bathrooms, upgraded flooring, lighting, closet systems, roller shades throughout, bespoke built-ins, high-end fixtures, appliances, upgraded plumbing, electrical, and other upgrades. Well-kept amenities include a grand 3-story lobby area, large infinity-edge pool, tennis court, multiple barbecue areas, kid's play area, and more. Hawaiki Tower's superb location puts beaches, shops, restaurants, entertainment and more just outside your doorstep. Rarely will you find a residence of this caliber, in this coveted location, offered with such exquisite upgrades. Don't miss this extraordinary opportunity to own a piece of paradise at Hawaiki Tower #2309." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Cable TV,HVAC,Hot Water,Internet,Maintenance Grounds,Maintenance Structure,Sewer,Water" +"AttributionContact": "(808) 596-8801" +"BathroomsFull": 2 +"BuildingName": "Hawaiki Tower" +"CLIP": 3484595671 +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Conference/Meeting Room,Dog Park,Pool,Recreation Area,Storage Facilities,Tennis Court(s),Trash Chute,Gated" +"ConstructionMaterials": "Double Wall,Other,Concrete" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2026-02-25T21:48:34.069988+00:00" +"DaysOnMarket": 158 +"DaysOnMarketReplication": 158 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Kaahumanu" +"EntryLevel": 23 +"Flooring": "Laminate" +"FrontageType": "Other" +"Furnished": "Furnished" +"HighSchool": "Mckinley" +"Inclusions": "AC Central,Auto Garage Door Opener,Blinds,Cable TV,Ceiling Fan,Convection Oven,Dishwasher,Disposal,Drapes,Dryer,Intercom,Microwave,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Washer" +"InteriorFeatures": "Single Living Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 596-8801" +"ListAgentEmail": "rina@sachihawaii.com" +"ListAgentKey": "22052457" +"ListAgentKeyNumeric": "22052457" +"ListAgentOfficePhone": "(808) 596-8801" +"ListAgentPreferredPhone": "(808) 596-8801" +"ListAgentStateLicense": "RS-85907" +"ListOfficeEmail": "moe@sachihawaii.com" +"ListOfficeKey": "2588157" +"ListOfficeKeyNumeric": "2588157" +"ListOfficePhone": "(808) 596-8801" +"ListingContractDate": "2026-02-25" +"ListingKeyNumeric": 1153407292 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1428.0 +"MajorChangeTimestamp": "2026-02-25T11:43:41Z" +"MiddleOrJuniorSchool": "Stevenson" +"MlsStatus": "Active" +"OnMarketDate": "2026-02-25" +"OriginalListPrice": 1900000.0 +"OriginatingSystemKey": "19291900" +"ParcelNumber": "1-2-3-006-004-0206" +"ParkingFeatures": "Assigned,Covered,Two Spaces,Secured" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-04-09T01:12:00Z" +"PhotosCount": 25 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Gated Community,Security Guard" +"SourceSystemKey": "1153407292" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Piikoi" +"StreetNumber": "88" +"StreetNumberNumeric": "88" +"StreetSuffix": "Street" +"SubdivisionName": "KAKAAKO" +"TaxAnnualAmount": "10130.76" +"TaxAssessedValue": 1442100 +"UnitNumber": "2309" +"View": "Coastline, Mountain(s), Ocean, Sunset, Sunrise" +"ViewYN": true +"VirtualTourURLUnbranded": "https://new.express.adobe.com/webpage/LA87Cd4usWIPk" +"YearBuiltEffective": 2021 +"ZoningDescription": "Kak – Kakaako Community Development Project" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1153407292"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1428.0 +"TaxAssessedValueLand": "79400" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "1362700" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1153407292')" +"provider_name": "HICMLS" +"RecordSignature": -637437927 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-006-004-0206" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486539" +"OriginatingSystemListAgentMemberKey": "17205476" +"Media": array:25 [ …25] +"ID": "79188" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5266 +post_id: "85673" +post_author: 1 +"ListingKey": "1178697230" +"ListingId": "202614708" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T03:01:14Z" +"RFModificationTimestamp": "2026-08-03T03:04:16Z" +"ListPrice": 1495000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 2309421.0 +"LivingArea": 1946.0 +"BuildingAreaTotal": 2493.0 +"City": "Kailua" +"PostalCode": "96734" +"UnparsedAddress": "1150b Kamahele Street #3002, Kailua, Hawaii 96734" +"Coordinates": array:2 [ …2] +"Latitude": 21.3801153 +"Longitude": -157.7265992 +"YearBuilt": 1979 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sally Tam Suemoto" +"ListOfficeName": "Lau & Associates, LLC" +"ListAgentMlsId": "46023" +"ListOfficeMlsId": "SLAU" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Bluestone's Kamahele Townhome - under $1.5M! Welcome to Bluestone, one of Kailua’s most private and prestigious gated communities.\r\n Set on nearly 50 acres of lush grounds fronting Mid-Pacific Country Club and surrounded by preservation land, this\r\n 3-bedroom, 2.5-bath townhome offers rare privacy, sweeping golf course, Ko‘olau mountain, and sunset views,\r\n plus an attached full-size garage and driveway parking for two additional vehicles. Three covered lanais capture\r\n cooling trade winds and provide seamless indoor-outdoor living. Bluestone residents enjoy resort-style amenities\r\n including a pool, whirlpool, BBQ areas, recreation spaces, tennis/pickleball courts, sauna, and gated security with\r\n patrol. Ideally located in the hills of Kailua, just minutes from Lanikai Beach and the Pillbox hike, this is a rare\r\n opportunity to own a townhome style with attached garage in the prestigious community of Bluestone at\r\n $1,495,000 — one of the few under $1.5M. Come and see what the Bluestone community has to offer! Sold As-Is. Furniture is negotiable. """ +"ArchitecturalStyle": "Multi-Level" +"AssociationFeeIncludes": "Common Areas,Cable TV,Internet,Sewer,Water" +"AttributionContact": "(808) 223-0074" +"BathroomsFull": 2 +"BuildingName": "Bluestone" +"CLIP": 4706652215 +"CommunityFeatures": "Barbecue,Clubhouse,Community Pool,Deck/Porch,Patio,Recreation Area,Sauna,Tennis Court(s),Trails/Paths,Gated" +"ConstructionMaterials": "Double Wall,Masonry,Stucco" +"CountyOrParish": "Oahu" +"CreationDate": "2026-07-31T23:47:29.593825+00:00" +"DaysOnMarket": 2 +"DaysOnMarketReplication": 2 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure,See Remarks" +"EntryLevel": 1 +"Flooring": "Carpet,Ceramic Tile,Hardwood,Other" +"FrontageType": "Golf Course,Preservation" +"Furnished": "Negotiable" +"GarageYN": true +"Inclusions": "AC Split,AC Window Unit,Auto Garage Door Opener,Ceiling Fan,Chandelier,Dishwasher,Disposal,Drapes,Dryer,Microwave,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 203-0474" +"ListAgentEmail": "sally.suemoto@lauassociatesllc.com" +"ListAgentKey": "10774291" +"ListAgentKeyNumeric": "10774291" +"ListAgentOfficePhone": "(808) 223-0074" +"ListAgentPreferredPhone": "(808) 203-0474" +"ListAgentStateLicense": "RS-79152" +"ListOfficeEmail": "slau@lauassociates.com" +"ListOfficeKey": "2585552" +"ListOfficeKeyNumeric": "2585552" +"ListOfficePhone": "(808) 223-0074" +"ListingContractDate": "2026-07-31" +"ListingKeyNumeric": 1178697230 +"ListingService": "Full Service" +"MLSAreaMajor": "Kailua" +"MaintenanceExpense": 1862.72 +"MajorChangeTimestamp": "2026-07-31T13:45:08Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-07-31" +"OpenParkingYN": true +"OriginalListPrice": 1495000.0 +"OriginatingSystemKey": "19610891" +"ParcelNumber": "1-4-2-002-016-0135" +"ParkingFeatures": "Assigned,Covered,Garage,Guest,Two Spaces,Secured" +"ParkingTotal": "2.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-07-31T23:46:01Z" +"PhotosCount": 25 +"PostalCity": "Kailua" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"SecurityFeatures": "Closed Circuit Camera(s),Gated Community,Key Card Entry,Security Guard" +"SourceSystemKey": "1178697230" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kamahele" +"StreetNumber": "1150B" +"StreetSuffix": "Street" +"StructureType": "Townhouse" +"SubdivisionName": "BLUESTONE" +"TaxAnnualAmount": "10689.48" +"TaxAssessedValue": 1586800 +"UnitNumber": "#3002" +"View": "Golf Course,Mountain(s),Sunset" +"ViewYN": true +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1178697230"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1863.0 +"TaxAssessedValueLand": "363400" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium,Townhouse" +"TaxAssessedValueImprovement": "1223400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1178697230')" +"provider_name": "HICMLS" +"RecordSignature": -2066646532 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-4-2-002-016-0135" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3487434" +"OriginatingSystemListAgentMemberKey": "9928835" +"Media": array:25 [ …25] +"ID": "85673" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5267 +post_id: "83414" +post_author: 1 +"ListingKey": "1159749897" +"ListingId": "202609203" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T03:01:14Z" +"RFModificationTimestamp": "2026-08-03T03:04:17Z" +"ListPrice": 2099500.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 12572.0 +"LivingArea": 2471.0 +"BuildingAreaTotal": 2471.0 +"City": "Kailua" +"PostalCode": "96734" +"UnparsedAddress": "1287 Puualoha Street, Kailua, Hawaii 96734" +"Coordinates": array:2 [ …2] +"Latitude": 21.358229 +"Longitude": -157.7664184 +"YearBuilt": 1970 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sal Gonzalez" +"ListOfficeName": "REMAX Hawaii" +"ListAgentMlsId": "50574" +"ListOfficeMlsId": "ADVG02" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Welcome home to beautiful Maunawili! Tucked away on a quiet cul-de-sac and surrounded by lush greenery, this beautifully renovated home is stunning with Ko’olau mountain views that capture the essence of Windward living. Inside, enjoy a spacious open-concept layout with soaring high ceilings, creating a bright and airy feel throughout. The home features luxury vinyl flooring, split AC units in every room, and a modern kitchen with quartz countertops, a large waterfall island, and new appliances, perfect for everyday living and entertaining. The main level offers 3 bedrooms and 2 bathrooms, with the primary bedroom located on the lower level, while the upstairs includes a separate 1-bedroom, 1-bath living area, ideal for extended family or guests. Step outside to a large Trex deck overlooking a private, lush backyard, perfect for relaxing or hosting while taking in the surrounding greenery. A rare opportunity to own a move-in ready home in highly desirable Maunawili." +"ArchitecturalStyle": "Detached" +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 261-1800" +"BathroomsFull": 3 +"CLIP": 3426277530 +"ConstructionMaterials": "Double Wall,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-05-13T17:41:40.380405+00:00" +"DaysOnMarket": 81 +"DaysOnMarketReplication": 81 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Maunawili" +"Flooring": "Vinyl" +"FoundationDetails": "Slab" +"GarageYN": true +"HighSchool": "Kailua" +"Inclusions": "AC Split,Auto Garage Door Opener,Ceiling Fan,Dishwasher,Disposal,Dryer,Microwave,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater,Wine Refrigerator" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 372-0946" +"ListAgentEmail": "Sal.Gonzalez@remaxhawaii.com" +"ListAgentKey": "17324039" +"ListAgentKeyNumeric": "17324039" +"ListAgentOfficePhone": "(808) 261-1800" +"ListAgentPreferredPhone": "(808) 372-0946" +"ListAgentStateLicense": "RS-83224" +"ListOfficeEmail": "Francis.VanRafelghem@remaxhawaii.com" +"ListOfficeKey": "2589181" +"ListOfficeKeyNumeric": "2589181" +"ListOfficePhone": "(808) 261-1800" +"ListingContractDate": "2026-05-13" +"ListingKeyNumeric": 1159749897 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Cul-De-Sac" +"MLSAreaMajor": "Kailua" +"MajorChangeTimestamp": "2026-07-21T16:33:41Z" +"MiddleOrJuniorSchool": "Kailua" +"MlsStatus": "Active" +"OnMarketDate": "2026-05-13" +"OriginalListPrice": 2149500.0 +"OriginatingSystemKey": "19450507" +"ParcelNumber": "1-4-2-066-002-0000" +"ParkingFeatures": "Garage,Three or more Spaces" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-05-13T18:17:00Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Kailua" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"RoadFrontageType": "County Road" +"SourceSystemKey": "1159749897" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Puualoha" +"StreetNumber": "1287" +"StreetNumberNumeric": "1287" +"StreetSuffix": "Street" +"SubdivisionName": "MAUNAWILI" +"TaxAnnualAmount": "5789.76" +"TaxAssessedValue": 1894500 +"Topography": "Sloping, Terraced" +"Utilities": "Electricity Available,Sewer Available,Underground Utilities,Water Available" +"View": "Mountain(s)" +"ViewYN": true +"VirtualTourURLUnbranded": "https://listings.hetproductions.com/sites/eqlqdbyv/unbranded" +"WaterSource": "Public" +"YearBuiltEffective": 2026 +"ZoningDescription": "02 - R-20 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1159749897"\n } """ +"HumanModifiedYN": false +"TaxAssessedValueLand": "1543200" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "351300" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1159749897')" +"provider_name": "HICMLS" +"RecordSignature": -1644210160 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-4-2-066-002-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10139093" +"OriginatingSystemListAgentMemberKey": "15328681" +"Media": array:25 [ …25] +"ID": "83414" } 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5268 +post_id: "79781" +post_author: 1 +"ListingKey": "1150558534" +"ListingId": "202528258" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T03:01:14Z" +"RFModificationTimestamp": "2026-08-03T03:04:48Z" +"ListPrice": 795000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 134600.0 +"LivingArea": 964.0 +"BuildingAreaTotal": 1056.0 +"City": "Kailua" +"PostalCode": "96734" +"UnparsedAddress": "322 Aoloa Street 505, Kailua, Hawaii 96734" +"Coordinates": array:2 [ …2] +"Latitude": 21.3912829 +"Longitude": -157.7380697 +"YearBuilt": 1979 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Yvonne Jaramillo Ahearn" +"ListOfficeName": "Compass" +"ListAgentMlsId": "36308" +"ListOfficeMlsId": "COHI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "A gorgeous, breezy light-filled space is yours with this remodeled 2 BR/2 Full BA condo in the premiere Windward Passage building. Features include a tree-top view, smooth/no-popcorn ceiling, fresh paint, new lighting & fans, & new primary bedroom carpet. Oak cabinets & granite counters with a breakfast bar, complement the expanded kitchen area. This condo has great storage & includes a separate exterior locker, as well as common spaces for surfboard, bike, & kayak storage. Building amenities are many: on-site manager, 24/7 security, pool, spa, fitness center, dog park, recreation area near pool, recreation/party room, & even tennis & pickle ball courts. The Windward Passage plumbing project is also complete, meaning new toilets, as well as new drain & supply lines, & shut-off valves for all units in building. Garage spalling project ongoing & near completion. This building is very well-maintained & already includes sprinklers & other fire safety measures. Pet friendly & the minimum rental period is 6 mo. The building is ideally located in the center of Kailua, within a mile of Kailua Beach & just a few blocks to shopping (Target/Whole Foods/Safeway etc.) & many restaurants." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Cable TV,Hot Water,Sewer,Water" +"AssociationName": "Kailua Gardens Community Association" +"AttributionContact": "(808) 825-4277" +"BathroomsFull": 2 +"BuildingName": "Windward Passage" +"CLIP": 9335358202 +"CoListAgentDirectPhone": "(808) 825-4277" +"CoListAgentEmail": "ana.kuna@compass.com" +"CoListAgentFullName": "Ana Kuna" +"CoListAgentKey": "10768217" +"CoListAgentKeyNumeric": "10768217" +"CoListAgentMlsId": "43147" +"CoListAgentPreferredPhone": "(808) 295-2311" +"CoListOfficeEmail": "julie.meier@compass.com" +"CoListOfficeKey": "3944102" +"CoListOfficeKeyNumeric": "3944102" +"CoListOfficeMlsId": "COHI" +"CoListOfficeName": "Compass" +"CoListOfficePhone": "(808) 825-4277" +"CommunityFeatures": "Barbecue,Clubhouse,Community Pool,Deck/Porch,Dog Park,Fitness,Patio,Pool,Recreation Area,Sauna,Storage Facilities,Tennis Court(s),Trails/Paths,Trash Chute" +"ConstructionMaterials": "Concrete,Steel Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-03-07T19:36:16.209994+00:00" +"DaysOnMarket": 148 +"DaysOnMarketReplication": 148 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Kailua" +"EntryLevel": 5 +"Flooring": "Carpet, Marble, Other" +"FrontageType": "Other" +"Furnished": "Partially" +"GarageYN": true +"HighSchool": "Kailua" +"Inclusions": "AC Window Unit,Blinds,Dishwasher,Dryer,Range/Oven,Refrigerator,Washer" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level,Single Living Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 721-8088" +"ListAgentEmail": "yvonne.ahearn@compass.com" +"ListAgentKey": "10778000" +"ListAgentKeyNumeric": "10778000" +"ListAgentOfficePhone": "(808) 825-4277" +"ListAgentPreferredPhone": "(808) 721-8088" +"ListAgentStateLicense": "RB-20262" +"ListOfficeEmail": "julie.meier@compass.com" +"ListOfficeKey": "3944102" +"ListOfficeKeyNumeric": "3944102" +"ListOfficePhone": "(808) 825-4277" +"ListingContractDate": "2026-03-07" +"ListingKeyNumeric": 1150558534 +"ListingService": "Full Service" +"MLSAreaMajor": "Kailua" +"MaintenanceExpense": 1129.75 +"MajorChangeTimestamp": "2026-03-07T09:32:44Z" +"MiddleOrJuniorSchool": "Kailua" +"MlsStatus": "Active" +"OnMarketDate": "2026-03-07" +"OriginalListPrice": 795000.0 +"OriginatingSystemKey": "19180527" +"ParcelNumber": "1-4-2-001-046-0040" +"ParkingFeatures": "Assigned,Covered,Garage,Guest,Two Spaces,On Street,Secured" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-05-28T08:54:01Z" +"PhotosCount": 25 +"PoolFeatures": "Heated" +"PostalCity": "Kailua" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry,Fire Sprinkler System,Security Guard" +"SourceSystemKey": "1150558534" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Aoloa" +"StreetNumber": "322" +"StreetNumberNumeric": "322" +"StreetSuffix": "Street" +"SubdivisionName": "KAILUA TOWN" +"TaxAnnualAmount": "3024.0" +"TaxAssessedValue": 863300 +"UnitNumber": "505" +"View": "Garden, Sunrise" +"ViewYN": true +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1150558534"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1130.0 +"TaxAssessedValueLand": "112000" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "751300" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1150558534')" +"provider_name": "HICMLS" +"RecordSignature": -1994357725 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-4-2-001-046-0040" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15465233" +"OriginatingSystemCoListOfficeKey": "15465233" +"OriginatingSystemListAgentMemberKey": "3480875" +"OriginatingSystemCoListAgentMemberKey": "3483381" +"Media": array:25 [ …25] +"ID": "79781" } 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5269 +post_id: "83678" +post_author: 1 +"ListingKey": "1167258413" +"ListingId": "202609679" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T03:01:14Z" +"RFModificationTimestamp": "2026-08-03T03:04:16Z" +"ListPrice": 475000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 22041.0 +"LivingArea": 585.0 +"BuildingAreaTotal": 675.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "2410 Cleghorn Street 1904, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.2777813 +"Longitude": -157.8230666 +"YearBuilt": 1978 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Alina Spatariu" +"ListOfficeName": "List Sotheby's Int'l Realty" +"ListAgentMlsId": "47681" +"ListOfficeMlsId": "LIST" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Welcome Home to Waikiki Skytower, an upgraded 1-bedroom, 1-bath condo with 1 covered parking stall in the heart of Waikiki. This well-maintained residence features a remodeled kitchen completed in 2023 with modern cabinetry, stylish backsplash, sleek countertops, and stainless steel appliances including refrigerator, dishwasher, stove, and microwave hood. New flooring throughout creates a clean, updated feel, while the enclosed lanai adds functional living space and offers beautiful ocean views. Additional improvements include a new washer/dryer and new curtains. Waikiki Skytower offers desirable amenities including a pool, sauna, BBQ area, and secure gated covered parking. Conveniently located just two blocks from Waikiki Beach and near shopping, dining, entertainment, parks, and surf spots, this property offers comfort, convenience, and an ideal Waikiki lifestyle. Extra fee of $472.50 per month ends 12/26, for the new fire alarm system. HOA is $1333 without this assessment." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFee2": "473.0" +"AssociationFeeIncludes": "Common Areas,Cable TV,Internet,Sewer,Water" +"AttributionContact": "(808) 735-2411" +"BathroomsFull": 1 +"BuildingName": "Waikiki Skytower" +"CLIP": 8568190747 +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Deck/Porch,Patio,Pool,Recreation Area,Sauna,Trash Chute" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-05-16T22:19:21.910293+00:00" +"DaysOnMarket": 78 +"DaysOnMarketReplication": 78 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"EntryLevel": 19 +"Flooring": "Ceramic Tile,Vinyl" +"Furnished": "Furnished" +"GarageYN": true +"Inclusions": "AC Window Unit,Cable TV,Dishwasher,Disposal,Drapes,Dryer,Kitchenware,Linens,Microwave Hood,Range/Oven,Refrigerator,Smoke Detector,Washer" +"InteriorFeatures": "Handicap Access,Single Living Level" +"RFTransactionType": "For Sale" +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 979-5990" +"ListAgentEmail": "YourAgentAlina@gmail.com" +"ListAgentKey": "10776161" +"ListAgentKeyNumeric": "10776161" +"ListAgentOfficePhone": "(808) 735-2411" +"ListAgentPreferredPhone": "(808) 979-5990" +"ListAgentStateLicense": "RS-80037" +"ListOfficeEmail": "info@listsir.com" +"ListOfficeKey": "2586183" +"ListOfficeKeyNumeric": "2586183" +"ListOfficePhone": "(808) 735-2411" +"ListingContractDate": "2026-05-16" +"ListingKeyNumeric": 1167258413 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1333.27 +"MajorChangeTimestamp": "2026-07-25T16:51:05Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-05-16" +"OriginalListPrice": 499000.0 +"OriginatingSystemKey": "19464496" +"ParcelNumber": "1-2-6-024-053-0053" +"ParkingFeatures": "Assigned,Covered,Garage,One Space,Secured" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-05-17T00:39:00Z" +"PhotosCount": 24 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"SecurityFeatures": "Elevator Secured,Key Card Entry" +"SourceSystemKey": "1167258413" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Cleghorn" +"StreetNumber": "2410" +"StreetNumberNumeric": "2410" +"StreetSuffix": "Street" +"SubdivisionName": "WAIKIKI" +"TaxAnnualAmount": "1488.0" +"TaxAssessedValue": 418200 +"TotalActualRent": 3100.0 +"UnitNumber": "1904" +"View": "Canal, City, Mountain(s), Ocean, Sunset" +"ViewYN": true +"YearBuiltEffective": 2023 +"ZoningDescription": "X2 - Apartment Precinct" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1167258413"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1806.0 +"TaxAssessedValueLand": "79200" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "339000" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1167258413')" +"provider_name": "HICMLS" +"RecordSignature": -605020778 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-6-024-053-0053" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "9066313" +"OriginatingSystemListAgentMemberKey": "12143587" +"Media": array:24 [ …24] +"ID": "83678" } 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5270 +post_id: "85105" +post_author: 1 +"ListingKey": "1176229351" +"ListingId": "202612571" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T03:01:14Z" +"RFModificationTimestamp": "2026-08-03T03:04:30Z" +"ListPrice": 409000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 782.0 +"BuildingAreaTotal": 867.0 +"City": "Honolulu" +"PostalCode": "96822" +"UnparsedAddress": "1716 Keeaumoku Street 706, Honolulu, Hawaii 96822" +"Coordinates": array:2 [ …2] +"Latitude": 21.3066614 +"Longitude": -157.8350664 +"YearBuilt": 1967 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ali Ban" +"ListOfficeName": "20 Degrees North Real Estate" +"ListAgentMlsId": "43351" +"ListOfficeMlsId": "DGRS" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "This central Makiki residence prioritizes security and comfort with gated resident parking and a bright interior designed for natural light and cross breezes. The home was extensively updated in 2023, featuring a full kitchen renovation (new cabinets, counters, and appliances), also the bathroom, and luxury vinyl plank flooring throughout. Corner unit, located on the quiet side of the building and neighborhood. Enjoy peaceful, sunset views of the city from your living room and Tantalus views from the kitchen. You are minutes away from Ala Moana, Waikiki, and UH Manoa, with easy access to the freeway and bus lines. Makiki District Park, with basketball / tennis courts, pool and community garden, is only a few blocks away. A weekly Farmer’s Market is also in walking distance. Building amenities include a pool, BBQ areas, garden space and onsite manager. 2 convenient trash rooms on each floor. Recent building projects include painting and spalling completed in 2024." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,None,Sewer,Water" +"AttributionContact": "(808) 388-5555" +"BathroomsFull": 1 +"BuildingName": "Mokulani Apts" +"CLIP": 4516527873 +"CoListAgentDirectPhone": "(808) 388-5555" +"CoListAgentEmail": "sora@20DegreesN.com" +"CoListAgentFullName": "Sora Lim" +"CoListAgentKey": "24810339" +"CoListAgentKeyNumeric": "24810339" +"CoListAgentMlsId": "54217" +"CoListAgentPreferredPhone": "(808) 638-1187" +"CoListOfficeEmail": "Chris@20DegreesN.com" +"CoListOfficeKey": "2597471" +"CoListOfficeKeyNumeric": "2597471" +"CoListOfficeMlsId": "DGRS" +"CoListOfficeName": "20 Degrees North Real Estate" +"CoListOfficePhone": "(808) 388-5555" +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Community Pool,Other,Pool,Gated" +"ConstructionMaterials": "Double Wall,Masonry,Concrete,Stucco" +"CountyOrParish": "Oahu" +"CreationDate": "2026-07-25T05:36:49.277640+00:00" +"DaysOnMarket": 9 +"DaysOnMarketReplication": 9 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 7 +"Flooring": "Vinyl" +"Furnished": "Partially" +"Inclusions": "Auto Garage Door Opener,Blinds,Disposal,Drapes,Dryer,Microwave,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"InteriorFeatures": "Single Living Level" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More,One" +"ListAgentDirectPhone": "(808) 388-5555" +"ListAgentEmail": "aliban1012@gmail.com" +"ListAgentKey": "10778356" +"ListAgentKeyNumeric": "10778356" +"ListAgentOfficePhone": "(808) 388-5555" +"ListAgentPreferredPhone": "(808) 388-5555" +"ListAgentStateLicense": "RB-21955" +"ListOfficeEmail": "Chris@20DegreesN.com" +"ListOfficeKey": "2597471" +"ListOfficeKeyNumeric": "2597471" +"ListOfficePhone": "(808) 388-5555" +"ListingContractDate": "2026-07-24" +"ListingKeyNumeric": 1176229351 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1223.23 +"MajorChangeTimestamp": "2026-07-24T19:32:01Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-07-24" +"OriginalListPrice": 409000.0 +"OriginatingSystemKey": "19548324" +"ParcelNumber": "1-2-4-025-067-0035" +"ParkingFeatures": "Assigned,Covered,One Space,Secured" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-07-26T23:34:03Z" +"PhotosCount": 23 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Gated Community,Key Card Entry" +"SourceSystemKey": "1176229351" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Keeaumoku" +"StreetNumber": "1716" +"StreetNumberNumeric": "1716" +"StreetSuffix": "Street" +"SubdivisionName": "MAKIKI AREA" +"TaxAnnualAmount": "1388.76" +"TaxAssessedValue": 396800 +"UnitNumber": "706" +"View": "City, Mountain(s)" +"ViewYN": true +"YearBuiltEffective": 2023 +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1176229351"\n } """ +"HumanModifiedYN": false +"AssociationFeeTotal": 1223.0 +"TaxAssessedValueLand": "93700" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "303100" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1176229351')" +"provider_name": "HICMLS" +"RecordSignature": -722930182 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-4-025-067-0035" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "12747418" +"OriginatingSystemCoListOfficeKey": "12747418" +"OriginatingSystemListAgentMemberKey": "3483525" +"OriginatingSystemCoListAgentMemberKey": "18220245" +"Media": array:23 [ …23] +"ID": "85105" } 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5271 +post_id: "84625" +post_author: 1 +"ListingKey": "1177640716" +"ListingId": "202613975" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T03:01:14Z" +"RFModificationTimestamp": "2026-08-03T03:04:32Z" +"ListPrice": 1699500.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 13937.0 +"LivingArea": 1642.0 +"BuildingAreaTotal": 1926.0 +"City": "Honolulu" +"PostalCode": "96813" +"UnparsedAddress": "2490 Tantalus Drive, Honolulu, Hawaii 96813" +"Coordinates": array:2 [ …2] +"Latitude": 21.3169293 +"Longitude": -157.8343859 +"YearBuilt": 1954 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Keith EH Sakoda" +"ListOfficeName": "Sakoda Realty, LLC" +"ListAgentMlsId": "04333" +"ListOfficeMlsId": "SAKR" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Private Gated Single Level 3 Bedroom 2 Bath Home w/2 Car Enclosed Garage w/City Views! 24 PV Panels w/Battery System (2020) Fully Owned. Newer Roof (2024), Appliances, Kitchen Counters (2026), Flooring (2026), Newly Painted Interior/Exterior. Ample Storage! Extended Driveway to accommodate 15+ vehicles. Building Plans for Future ADU included in sale. No Catchment - City Water Supply! A Must See!" +"ArchitecturalStyle": "Detached" +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 596-0077" +"BathroomsFull": 2 +"CLIP": 5599263121 +"CommunityFeatures": "Deck/Porch,Patio,Storage Facilities" +"ConstructionMaterials": "Double Wall,Hollow Tile,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-07-21T17:57:16.676995+00:00" +"DaysOnMarket": 12 +"DaysOnMarketReplication": 12 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Lincoln" +"ExteriorFeatures": "Landscaping" +"Fencing": "Fenced, Wall" +"Flooring": "Vinyl" +"FoundationDetails": "Slab" +"FrontageType": "Conservation, Preservation" +"Furnished": "Partially" +"GarageYN": true +"HighSchool": "Roosevelt" +"Inclusions": "AC Split,Auto Garage Door Opener,Blinds,Cable TV,Disposal,Dryer,Photovoltaic - Owned,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 224-6577" +"ListAgentEmail": "keith@sakodarealty.com" +"ListAgentKey": "10768417" +"ListAgentKeyNumeric": "10768417" +"ListAgentOfficePhone": "(808) 596-0077" +"ListAgentPreferredPhone": "(808) 224-6577" +"ListAgentStateLicense": "RB-12645" +"ListOfficeEmail": "keith@sakodarealty.com" +"ListOfficeKey": "2587777" +"ListOfficeKeyNumeric": "2587777" +"ListOfficePhone": "(808) 596-0077" +"ListingContractDate": "2026-07-21" +"ListingKeyNumeric": 1177640716 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Interior Lot,Rim Lot,Level,Steep Slope" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2026-07-21T07:54:39Z" +"MiddleOrJuniorSchool": "Stevenson" +"MlsStatus": "Active" +"OnMarketDate": "2026-07-21" +"OriginalListPrice": 1699500.0 +"OriginatingSystemKey": "19588879" +"ParcelNumber": "1-2-5-023-014-0000" +"ParkingFeatures": "Boat,Driveway,Garage,Three or more Spaces" +"ParkingTotal": "10.0" +"PhotosChangeTimestamp": "2026-07-20T23:58:01Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"RoadFrontageType": "County Road" +"RoomType": "Entry/Foyer" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1177640716" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Tantalus" +"StreetNumber": "2490" +"StreetNumberNumeric": "2490" +"StreetSuffix": "Drive" +"SubdivisionName": "MAKIKI HEIGHTS" +"TaxAnnualAmount": "7800.0" +"TaxAssessedValue": 1726000 +"Topography": "Level, Sloping, Terraced" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,High Speed Internet Available,Other,Phone Available,Water Available" +"View": "Coastline, City, Garden, Mountain(s), Ocean, Sunset" +"ViewYN": true +"WaterSource": "Public" +"YearBuiltEffective": 2026 +"ZoningDescription": "03 - R10 - Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1177640716"\n } """ +"HumanModifiedYN": false +"TaxAssessedValueLand": "1608600" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "117400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1177640716')" +"provider_name": "HICMLS" +"RecordSignature": -1840909062 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-5-023-014-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486159" +"OriginatingSystemListAgentMemberKey": "8842605" +"Media": array:25 [ …25] +"ID": "84625" } 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5272 +post_id: "84193" +post_author: 1 +"ListingKey": "1173733968" +"ListingId": "202611200" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T03:01:14Z" +"RFModificationTimestamp": "2026-08-03T03:04:43Z" +"ListPrice": 1375000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 13241.0 +"LivingArea": 2170.0 +"BuildingAreaTotal": 2170.0 +"City": "Honolulu" +"PostalCode": "96817" +"UnparsedAddress": "718 Alewa Drive, Honolulu, Hawaii 96817" +"Coordinates": array:2 [ …2] +"Latitude": 21.3334082 +"Longitude": -157.8514574 +"YearBuilt": 2002 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Tommy Kim" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "44909" +"ListOfficeMlsId": "CBPP" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Enjoy panoramic city and mountain vistas from this well maintained multi level Honolulu home. Built in 2002 and in excellent condition, this 3 bedroom, 3.5 bath CPR residence offers 2,170 sq. ft. of interior living space on a 13,241 sq. ft. lot. Generously sized bedrooms, thoughtful living spaces, and two spacious balconies provide comfort and flexibility while showcasing the home's beautiful views. Modern features include split A/C throughout, an owned photovoltaic system with twenty-one panels and two Tesla batteries, solar water heating, and a two car garage. Conveniently located with easy access to downtown Honolulu, schools, shopping, and major highways, this move in ready home combines comfort, efficiency, and island living. Actual building size and floor plan differs from Tax records. Click on the virtual tour tab for property video!" +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 596-0456" +"BathroomsFull": 3 +"CLIP": 4650835608 +"ConstructionMaterials": "Double Wall,Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-06-11T17:02:08.591117+00:00" +"DaysOnMarket": 52 +"DaysOnMarketReplication": 52 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Pet on Property,Seller Disclosure" +"Flooring": "Ceramic Tile,Other" +"Furnished": "Unfurnished" +"GarageSpaces": "2.0" +"GarageYN": true +"Inclusions": "AC Split,Attic Fan,Auto Garage Door Opener,Blinds,Cable TV,Ceiling Fan,Chandelier,Dishwasher,Disposal,Dryer,Photovoltaic - Owned,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Solar Heater,Washer" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 779-1416" +"ListAgentEmail": "tommy.kim@cbpacific.com" +"ListAgentKey": "10779043" +"ListAgentKeyNumeric": "10779043" +"ListAgentOfficePhone": "(808) 596-0456" +"ListAgentPreferredPhone": "(808) 779-1416" +"ListAgentStateLicense": "RS-76201" +"ListOfficeEmail": "mike.james@cbrealty.com" +"ListOfficeKey": "2586830" +"ListOfficeKeyNumeric": "2586830" +"ListOfficePhone": "(808) 596-0456" +"ListingContractDate": "2026-06-11" +"ListingKeyNumeric": 1173733968 +"ListingService": "Full Service" +"LotFeatures": "Flag Lot,Interior Lot,Wooded,Steep Slope" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2026-06-11T06:59:36Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-06-11" +"OriginalListPrice": 1375000.0 +"OriginatingSystemKey": "19507951" +"ParcelNumber": "1-1-8-023-053-0002" +"ParkingFeatures": "Garage,Two Car Garage,Two Spaces" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-06-11T18:29:01Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"RoadFrontageType": "County Road" +"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry" +"SourceSystemKey": "1173733968" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Alewa" +"StreetNumber": "718" +"StreetNumberNumeric": "718" +"StreetSuffix": "Drive" +"SubdivisionName": "ALEWA HEIGHTS" +"TaxAnnualAmount": "4342.8" +"TaxAssessedValue": 1360800 +"Topography": "Sloping" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,High Speed Internet Available,Phone Available,Sewer Available,Water Available" +"View": "City, Garden, Mountain(s)" +"ViewYN": true +"VirtualTourURLUnbranded": "https://player.vimeo.com/video/1199951200" +"WaterSource": "Public" +"YearBuiltEffective": 2023 +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1173733968"\n } """ +"HumanModifiedYN": false +"TaxAssessedValueLand": "890000" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "470800" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1173733968')" +"provider_name": "HICMLS" +"RecordSignature": 645480392 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-8-023-053-0002" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485212" +"OriginatingSystemListAgentMemberKey": "9350639" +"Media": array:25 [ …25] +"ID": "84193" } 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5273 +post_id: "84037" +post_author: 1 +"ListingKey": "1176656122" +"ListingId": "202613207" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-08-03T03:01:14Z" +"RFModificationTimestamp": "2026-08-03T03:04:13Z" +"ListPrice": 1100000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 7113.0 +"LivingArea": 1464.0 +"BuildingAreaTotal": 1674.0 +"City": "Mililani" +"PostalCode": "96789" +"UnparsedAddress": "95-234 Waiala Street, Mililani, Hawaii 96789" +"Coordinates": array:2 [ …2] +"Latitude": 21.4653782 +"Longitude": -158.0115011 +"YearBuilt": 1961 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Gregory D Studt" +"ListOfficeName": "American Dream Realty LLC" +"ListAgentMlsId": "40099" +"ListOfficeMlsId": "ADRL" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Come quick, you will not want to miss this one. It’s a turnkey property that will not disappoint. It’s currently set up as a 3/1 and a 1/1 with a wet bar but it’s a very flexible floor plan that can accommodate large families, multigenerational living, or a possible rental to help with the mortgage payments. Very open kitchen/living/dining room layout with tons of natural light. The recently remodeled kitchen includes granite countertops, real wood cabinets, and stainless-steel appliances. Additional features include fresh paint, vinyl windows, and 4 split A/C’s. The home sits on a large 7,113 sf lot that is nicely landscaped and fully fenced in. There is a covered gazebo, a tree swing, multiple fruit trees, and an extra storage shed in the backyard. The carport/patio has a built-in workshop and plenty of parking (4 cars or more) and the covered lanai is perfect for indoor/outdoor living and for entertaining family and friends. Watch our online tour and come see for yourself at our open house on 7-12-2026 from 2-5pm." +"ArchitecturalStyle": "Detached" +"AssociationFeeIncludes": "None" +"AttributionContact": "(808) 258-2436" +"BathroomsFull": 2 +"CLIP": 1000427618 +"CarportYN": true +"CoListAgentDirectPhone": "(808) 351-8733" +"CoListAgentEmail": "chris_garth@outlook.com" +"CoListAgentFullName": "Christopher H Garth" +"CoListAgentKey": "26521288" +"CoListAgentKeyNumeric": "26521288" +"CoListAgentMlsId": "54702" +"CoListAgentPreferredPhone": "(808) 351-8733" +"CoListOfficeEmail": "gregstudt@gmail.com" +"CoListOfficeKey": "2587993" +"CoListOfficeKeyNumeric": "2587993" +"CoListOfficeMlsId": "ADRL" +"CoListOfficeName": "American Dream Realty LLC" +"CoListOfficePhone": "(808) 258-2436" +"CommunityFeatures": "Deck/Porch,Patio,Storage Facilities" +"ConstructionMaterials": "Double Wall,Hollow Tile,Single Wall,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-07-08T16:34:15.553519+00:00" +"DaysOnMarket": 25 +"DaysOnMarketReplication": 25 +"DaysOnMarketReplicationDate": "2026-08-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Kipapa" +"ExteriorFeatures": "Landscaping" +"Fencing": "Fenced, Wall" +"Flooring": "Ceramic Tile,Laminate,Vinyl" +"FoundationDetails": "Slab" +"FrontageType": "Other" +"Furnished": "Partially" +"HighSchool": "Mililani" +"Inclusions": "AC Split,Blinds,Cable TV,Ceiling Fan,Dishwasher,Disposal,Dryer,Microwave,Range/Oven,Refrigerator,Washer,Water Heater" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 258-2436" +"ListAgentEmail": "gregstudt@gmail.com" +"ListAgentKey": "10773178" +"ListAgentKeyNumeric": "10773178" +"ListAgentOfficePhone": "(808) 258-2436" +"ListAgentPreferredPhone": "(808) 258-2436" +"ListAgentStateLicense": "RB-21874" +"ListOfficeEmail": "gregstudt@gmail.com" +"ListOfficeKey": "2587993" +"ListOfficeKeyNumeric": "2587993" +"ListOfficePhone": "(808) 258-2436" +"ListingContractDate": "2026-07-08" +"ListingKeyNumeric": 1176656122 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Interior Lot,Level" +"MLSAreaMajor": "Central" +"MajorChangeTimestamp": "2026-07-08T06:28:47Z" +"MiddleOrJuniorSchool": "Mililani" +"MlsStatus": "Active" +"OnMarketDate": "2026-07-08" +"OriginalListPrice": 1100000.0 +"OriginatingSystemKey": "19566310" +"OtherStructures": "Workshop" +"ParcelNumber": "1-9-5-007-095-0000" +"ParkingFeatures": "Carport,Driveway,Three or more Spaces,On Street" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2026-07-08T17:27:01Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Mililani" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"RoadFrontageType": "County Road" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1176656122" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Waiala" +"StreetNumber": "95-234" +"StreetSuffix": "Street" +"SubdivisionName": "WAIPIO ACRES/WAIKALANI WOODLANDS" +"TaxAnnualAmount": "2580.0" +"TaxAssessedValue": 853900 +"Topography": "Level, Sloping" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,High Speed Internet Available,Other,Phone Available,Water Available" +"View": "Mountain(s)" +"ViewYN": true +"VirtualTourURLUnbranded": "https://hommati.tours/tour/2664643?play=no&mls=yes" +"WaterSource": "Public" +"YearBuiltEffective": 2022 +"ZoningDescription": "04 - R-7.5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1176656122"\n } """ +"HumanModifiedYN": false +"TaxAssessedValueLand": "695900" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Single Family Residence" +"TaxAssessedValueImprovement": "158000" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1176656122')" +"provider_name": "HICMLS" +"RecordSignature": -1341027044 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-5-007-095-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486375" +"OriginatingSystemCoListOfficeKey": "3486375" +"OriginatingSystemListAgentMemberKey": "3482202" +"OriginatingSystemCoListAgentMemberKey": "18793824" +"Media": array:25 [ …25] +"ID": "84037" } ] +success: true +page_size: 18 +page_count: 11 +count: 192 +after_key: "" } "RF Response Time" => "0.39 seconds" ] "RF Query: /Property?$select=ALL&$orderby=meta_value date DESC&$top=18&$filter=(StandardStatus eq 'Active') and PropertyCondition eq 'Excellent,Good Condition,Updated/Remodeled'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#8119 +items: array:18 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8168 +post_id: "50600" +post_author: 1 +"ListingKey": "1100990717" +"ListingId": "202501186" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-24T18:44:02Z" +"RFModificationTimestamp": "2026-07-24T18:48:14Z" +"ListPrice": 399999.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 130724.0 +"LivingArea": 632.0 +"BuildingAreaTotal": 744.0 +"City": "Waianae" +"PostalCode": "96792" +"UnparsedAddress": "87-561 Farrington Highway 318, Waianae, Hawaii 96792" +"Coordinates": array:2 [ …2] +"Latitude": 21.4146743 +"Longitude": -158.17712031449 +"YearBuilt": 1975 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Matthew J Iannaccio" +"ListOfficeName": "eXp Realty" +"ListAgentMlsId": "46960" +"ListOfficeMlsId": "EXPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Oceanfront Condo with Stunning Views! Experience coastal living in this oceanfront, top-floor condominium located on the cool side of the building. NEW FLOORING, NEW DISHWASHER, NEW REFRIGERATOR, NEW WASHER DRYER, NEW CEILING FANS & PAINTED CABINETS. UPGRADED AND NEW ELECTRICAL PANEL. This well-maintained and meticulously cared-for unit features one bedroom and one bathroom, offering a comfortable and functional layout. The property includes one assigned parking space in a secure parking area, providing convenience and peace of mind. Residents can enjoy exclusive access to amenities such as a private swimming pool and a BBQ area, perfect for outdoor gatherings. Fully furnished with an additional Murphy Bed in the Living Room make this property Turnkey ready for immediate move-in. This unit boasts a spacious balcony with direct ocean views, ideal for relaxing and taking in the serene surroundings. Schedule a showing today to explore this exceptional property." +"ArchitecturalStyle": "Low Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Cable TV,Internet,Maintenance Grounds,Maintenance Structure,Sewer,Water" +"AttributionContact": "(808) 725-2794" +"BathroomsFull": 1 +"BuildingName": "MAILI COVE" +"CLIP": 7976144472 +"CoListAgentDirectPhone": "(808) 725-2794" +"CoListAgentEmail": "dawnnoahrealtor@gmail.com" +"CoListAgentFullName": "Dawn Noah" +"CoListAgentKey": "22402453" +"CoListAgentKeyNumeric": "22402453" +"CoListAgentMlsId": "53393" +"CoListAgentPreferredPhone": "(808) 375-9721" +"CoListOfficeEmail": "hi.broker@exprealty.net" +"CoListOfficeKey": "2589160" +"CoListOfficeKeyNumeric": "2589160" +"CoListOfficeMlsId": "EXPI" +"CoListOfficeName": "eXp Realty" +"CoListOfficePhone": "(808) 725-2794" +"CommunityFeatures": "Barbecue,Community Pool,Deck/Porch,Patio,Pool,Gated" +"ConstructionMaterials": "Masonry, Concrete, Stucco" +"CountyOrParish": "Oahu" +"CreationDate": "2025-04-07T22:44:13.288828+00:00" +"DaysOnMarket": 229 +"DaysOnMarketReplication": 219 +"DaysOnMarketReplicationDate": "2026-07-24" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Principal is Real Estate Licensed,Seller Disclosure" +"EntryLevel": 3 +"Fencing": "Fenced, Wall" +"Flooring": "Carpet,Ceramic Tile" +"FrontageType": "Oceanfront" +"Furnished": "Furnished" +"HumanModifiedYN": true +"Inclusions": "AC Window Unit,Blinds,Cable TV,Ceiling Fan,Chandelier,Dishwasher,Disposal,Drapes,Dryer,Microwave,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"InteriorFeatures": "Single Living Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 725-2794" +"ListAgentEmail": "matt.hirealtor@gmail.com" +"ListAgentKey": "10774592" +"ListAgentKeyNumeric": "10774592" +"ListAgentOfficePhone": "(808) 725-2794" +"ListAgentPreferredPhone": "(808) 725-2794" +"ListAgentStateLicense": "RB-23540" +"ListOfficeEmail": "hi.broker@exprealty.net" +"ListOfficeKey": "2589160" +"ListOfficeKeyNumeric": "2589160" +"ListOfficePhone": "(808) 725-2794" +"ListingContractDate": "2025-01-09" +"ListingKeyNumeric": 1100990717 +"ListingService": "Full Service" +"MLSAreaMajor": "Leeward" +"MaintenanceExpense": 1000.56 +"MajorChangeTimestamp": "2026-07-17T18:26:49Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-01-09" +"OpenParkingYN": true +"OriginalListPrice": 475000.0 +"OriginatingSystemKey": "18471846" +"ParcelNumber": "1-8-7-028-017-0058" +"ParkingFeatures": "Assigned,Guest,One Space" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2026-07-24T18:44:02Z" +"PhotosCount": 19 +"PostalCity": "Waianae" +"PropertyCondition": "Excellent,Good Condition,Updated/Remodeled" +"SecurityFeatures": "Gated Community" +"SourceSystemKey": "1100990717" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Farrington" +"StreetNumber": "87-561" +"StreetSuffix": "Highway" +"SubdivisionName": "MAILI" +"TaxAnnualAmount": "1554.96" +"TaxAssessedValue": 444300 +"UnitNumber": "318" +"View": "Coastline, Mountain(s), Ocean, Sunset" +"ViewYN": true +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1100990717"\n } """ +"AssociationFeeTotal": 1001.0 +"TaxAssessedValueLand": "138900" +"OriginatingSystemSubName": "HICMLS_HBR" +"PropertySubTypeAdditional": "Condominium" +"TaxAssessedValueImprovement": "305400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1100990717')" +"provider_name": "HICMLS" +"RecordSignature": -432440046 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-8-7-028-017-0058" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10013908" +"OriginatingSystemCoListOfficeKey": "10013908" +"OriginatingSystemListAgentMemberKey": "10699461" +"OriginatingSystemCoListAgentMemberKey": "17486983" …2 } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8166 …121} 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8171 …123} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8148 …123} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8167 …124} 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8172 …118} 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8173 …135} 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8149 …134} 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8146 …122} 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8144 …126} 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8143 …115} 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8150 …118} 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8175 …134} 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8174 …120} 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8115 …125} 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8116 …120} 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8117 …120} 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#8118 …119} ] +success: true +page_size: 18 +page_count: 11 +count: 192 +after_key: "" } "RF Response Time" => "0.3 seconds" ] ]