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&$skip=4176&$filter=(StandardStatus eq 'Active') and (StandardStatus eq 'Active' OR RFTransactionType eq 'Active')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4357 +items: array:18 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4342 +post_id: "58690" +post_author: 1 +"ListingKey": "1133209040" +"ListingId": "202519839" +"PropertyType": "Land" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-09-09T23:37:37Z" +"RFModificationTimestamp": "2025-11-11T14:02:58Z" +"ListPrice": 1760000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 22651.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Haleiwa" +"PostalCode": "96712" +"UnparsedAddress": "61-560 Pohaku Loa Way, Haleiwa, Hawaii 96712" +"Coordinates": array:2 [ …2] +"Latitude": 21.619899 +"Longitude": -158.084186 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Richard D Sterman" +"ListOfficeName": "Sterman Realty" +"ListAgentMlsId": "05516" +"ListOfficeMlsId": "STER" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Incredible "Double Lot" Beach-Side of Kamehameha Highway and just a few steps to several sandy beaches and several famous Surf Breaks (Laniakea on one side, Chun's Reef on the other and Jockos right out front). \r\n Zoned for at least 2 Homes - subject to "approvals". . . And - future CPR Possibilities.\r\n Sell one and live in the other home!?\r\n Feel free to drive by and picture yourself living this close to world-class Surf Breaks! \r\n Fully enclosed property with 6' Rock Walls around the perimeter. \r\n Two Gates (one on Kamehameha Highway and the other on Pohaku Loa Way).\r\n Ocean view from any second Floor rooms of either of the two possible homes! """ +"AttributionContact": "(808) 637-6200" +"CLIP": 1009012109 +"CountyOrParish": "Oahu" +"CreationDate": "2025-09-09T23:39:21.501165+00:00" +"CurrentUse": "Residential,Single Family" +"DaysOnMarketReplicationDate": "2025-09-09" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ExteriorFeatures": "Sprinkler/Irrigation, Landscaping" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 637-6200" +"ListAgentEmail": "richard@sterman.com" +"ListAgentKey": "10768350" +"ListAgentKeyNumeric": "10768350" +"ListAgentOfficePhone": "(808) 637-6200" +"ListAgentPreferredPhone": "(808) 637-6200" +"ListAgentStateLicense": "RB-11935" +"ListOfficeEmail": "richard@sterman.com" +"ListOfficeKey": "2586627" +"ListOfficeKeyNumeric": "2586627" +"ListOfficePhone": "(808) 637-6200" +"ListingContractDate": "2025-09-09" +"ListingKeyNumeric": 1133209040 +"ListingService": "Full Service" +"LotFeatures": "Level" +"MLSAreaMajor": "North Shore" +"MajorChangeTimestamp": "2025-09-09T13:37:03Z" +"MlsStatus": "Active" +"NumberOfLots": "2" +"OnMarketDate": "2025-09-09" +"OriginalListPrice": 1760000.0 +"OriginatingSystemKey": "18970407" +"ParcelNumber": "1-6-1-009-018-0000" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 18 +"PossibleUse": "Multi-Family,Residential,Single Family" +"PostalCity": "Haleiwa" +"RoadFrontageType": "Highway,Private Road" +"Sewer": "None" +"SourceSystemKey": "1133209040" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Pohaku Loa" +"StreetNumber": "61-560" +"StreetSuffix": "Way" +"SubdivisionName": "KAWAILOA-NORTH SHORE" +"TaxAnnualAmount": "6276.0" +"TaxAssessedValue": 1411900 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,Phone Available,Water Available,Sewer Not Available" +"View": "Mountain(s), Ocean, Sunset, Sunrise" +"ViewYN": true +"WaterSource": "Public" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1133209040"\n } """ +"Restrictions": "No Restrictions" +"HumanModifiedYN": true +"TaxAssessedValueLand": "1411900" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1133209040')" +"provider_name": "HICMLS" +"RecordSignature": 2059361458 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-6-1-009-018-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485009" +"OriginatingSystemListAgentMemberKey": "8834361" +"Media": array:18 [ …18] +"ID": "58690" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4344 +post_id: "61674" +post_author: 1 +"ListingKey": "1145440848" +"ListingId": "202524702" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-01T21:18:46Z" +"RFModificationTimestamp": "2025-11-11T14:11:12Z" +"ListPrice": 590000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 6600.0 +"LivingArea": 976.0 +"BuildingAreaTotal": 976.0 +"City": "Wahiawa" +"PostalCode": "96786" +"UnparsedAddress": "216 Walker Avenue, Wahiawa, Hawaii 96786" +"Coordinates": array:2 [ …2] +"Latitude": 21.4935478 +"Longitude": -158.0273433 +"YearBuilt": 1958 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Felix He" +"ListOfficeName": "Central Pacific Properties Inc" +"ListAgentMlsId": "49313" +"ListOfficeMlsId": "CPPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "BRING YOUR CONTRACTOR! This prime 6,600 sq. ft. lot in the heart of Wahiawa offers incredible potential for development or renovation. Perfect for builders or investors, this property is priced to sell and presents a fantastic opportunity in a vibrant, convenient community. Enjoy proximity to local dining, shopping, and essential services, as well as nearby parks and recreation. The actual number of bedrooms, bathrooms, and living area may differ from tax office records. As-is Sale." +"ArchitecturalStyle": "Detached" +"AttributionContact": "(808) 521-3777" +"BathroomsFull": 1 +"CommunityFeatures": "None" +"ConstructionMaterials": "Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-11-01T21:22:41.357078+00:00" +"DaysOnMarketReplicationDate": "2025-11-01" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,Seller Disclosure" +"Flooring": "Other" +"FoundationDetails": "Slab" +"FrontageType": "Other" +"Furnished": "Unfurnished" +"Inclusions": "None" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 258-7631" +"ListAgentEmail": "zhihe808@gmail.com" +"ListAgentKey": "13402223" +"ListAgentKeyNumeric": "13402223" +"ListAgentOfficePhone": "(808) 521-3777" +"ListAgentPreferredPhone": "(808) 258-7631" +"ListAgentStateLicense": "RS-81644" +"ListOfficeEmail": "joannie.jav@gmail.com" +"ListOfficeKey": "2587912" +"ListOfficeKeyNumeric": "2587912" +"ListOfficePhone": "(808) 521-3777" +"ListingContractDate": "2025-11-01" +"ListingKeyNumeric": 1145440848 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Other, Level" +"MLSAreaMajor": "Central" +"MajorChangeTimestamp": "2025-11-01T11:16:32Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-11-01" +"OriginalListPrice": 590000.0 +"OriginatingSystemKey": "19077487" +"ParcelNumber": "1-7-4-002-017-0000" +"ParkingFeatures": "Three or more Spaces" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 3 +"PoolFeatures": "None" +"PostalCity": "Wahiawa" +"PropertyCondition": "Updated/Remodeled,Repairs Major" +"SourceSystemKey": "1145440848" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Walker" +"StreetNumber": "216" +"StreetNumberNumeric": "216" +"StreetSuffix": "Avenue" +"SubdivisionName": "WAHIAWA AREA" +"TaxAnnualAmount": "2687.64" +"TaxAssessedValue": 767900 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Electricity Available,Phone Available,Sewer Available,Water Available" +"View": "None" +"WaterSource": "Public" +"YearBuiltEffective": 2024 +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1145440848"\n } """ +"HumanModifiedYN": true +"TaxAssessedValueLand": "604800" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "163100" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1145440848')" +"provider_name": "HICMLS" +"RecordSignature": -1608978604 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-7-4-002-017-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486294" +"OriginatingSystemListAgentMemberKey": "14108909" +"Media": array:3 [ …3] +"ID": "61674" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4341 +post_id: "48979" +post_author: 1 +"ListingKey": "1093574926" +"ListingId": "202425992" +"PropertyType": "Land" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-03T19:33:13Z" +"RFModificationTimestamp": "2025-11-11T18:53:32Z" +"ListPrice": 399000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 27558.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Kaunakakai" +"PostalCode": "96748" +"UnparsedAddress": "125 Kaunakakai Place, Kaunakakai, Hawaii 96748" +"Coordinates": array:2 [ …2] +"Latitude": 21.084033312538 +"Longitude": -157.02566565542 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Karen E Lau" +"ListOfficeName": "Locations LLC" +"ListAgentMlsId": "13550" +"ListOfficeMlsId": "LOCA" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Discover the endless possibilities with this prime, 27,558 square foot, waterfront corner lot, ideally located near the pier in\r\n desirable Kaunakakai and offering stunning views. Rare opportunity to create something extraordinary on Moloka'i’s coastline.\r\n The borders on land in photos are for general location reference purposes only, exact boundary to be verified in escrow. """ +"AttributionContact": "(808) 735-4200" +"CLIP": 8346096529 +"CoListAgentDirectPhone": "(808) 392-1906" +"CoListAgentEmail": "nana.thain@cbrealty.com" +"CoListAgentFullName": "Nana Thain" +"CoListAgentKey": "10778813" +"CoListAgentKeyNumeric": "10778813" +"CoListAgentMlsId": "25795" +"CoListAgentPreferredPhone": "(808) 542-4863" +"CoListOfficeEmail": "darryl.macha@locationshawaii.com" +"CoListOfficeKey": "2586923" +"CoListOfficeKeyNumeric": "2586923" +"CoListOfficeMlsId": "LOCA" +"CoListOfficeName": "Locations LLC" +"CoListOfficePhone": "(808) 735-4200" +"CountyOrParish": "Maui" +"CreationDate": "2025-04-08T01:31:02.353943+00:00" +"CurrentUse": "Other" +"DaysOnMarket": 521 +"DaysOnMarketReplication": 364 +"DaysOnMarketReplicationDate": "2025-11-03" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Call Agent,Seller Disclosure" +"ExteriorFeatures": "None" +"FrontageType": "Oceanfront" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 735-4200" +"ListAgentEmail": "karen.lau@locationshawaii.com" +"ListAgentKey": "10768465" +"ListAgentKeyNumeric": "10768465" +"ListAgentOfficePhone": "(808) 735-4200" +"ListAgentPreferredPhone": "(808) 735-4200" +"ListAgentStateLicense": "RS-40961" +"ListOfficeEmail": "darryl.macha@locationshawaii.com" +"ListOfficeKey": "2586923" +"ListOfficeKeyNumeric": "2586923" +"ListOfficePhone": "(808) 735-4200" +"ListingContractDate": "2024-11-04" +"ListingKeyNumeric": 1093574926 +"ListingService": "Full Service" +"LotFeatures": "Level" +"MLSAreaMajor": "Molokai" +"MajorChangeTimestamp": "2024-11-04T10:57:02Z" +"MlsStatus": "Active" +"OnMarketDate": "2024-11-04" +"OriginalListPrice": 399000.0 +"OriginatingSystemKey": "18365702" +"ParcelNumber": "2-5-3-001-009-0000" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 6 +"PostalCity": "Kaunakakai" +"RoadFrontageType": "County Road" +"Sewer": "None" +"SourceSystemKey": "1093574926" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kaunakakai" +"StreetNumber": "125" +"StreetNumberNumeric": "125" +"StreetSuffix": "Place" +"SubdivisionName": "Molokai Central" +"TaxAnnualAmount": "1884.0" +"TaxAssessedValue": 321300 +"Topography": "Level" +"Utilities": "Water Available,Sewer Not Available" +"View": "Ocean" +"ViewYN": true +"ZoningDescription": "Neighbor Island - See Remarks" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "StreetViewParam": "1$21.08621$-157.022935$167.43$13.33$1.00$MZJQ_taZNZpGrxoYiQUORg",\n "CompensationSubjectTo": "",\n "UtilitiesMeters": "Water",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "321300.00",\n "LockBoxModDT": "2024-11-04T10:43:23.937",\n "SellingAgentRemarks": "",\n "TaxAssessedValueImprovements": "0.00",\n "SetBacks": "Of Record",\n "CompensationMethod": "",\n "Easements": "None",\n "LandRecorded": "Land Court",\n "ListingKey": "1093574926"\n } """ +"Restrictions": "Other Restrictions" +"HumanModifiedYN": true +"TaxAssessedValueLand": "321300" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1093574926')" +"provider_name": "HICMLS" +"RecordSignature": 1502684326 +"UniversalParcelId": "urn:reso:upi:2.0:US:15009:2-5-3-001-009-0000" +"CountrySubdivision": "15009" +"OriginatingSystemListOfficeKey": "3485305" +"OriginatingSystemCoListOfficeKey": "3485305" +"OriginatingSystemListAgentMemberKey": "8842826" +"OriginatingSystemCoListAgentMemberKey": "8843292" +"Media": array:6 [ …6] +"ID": "48979" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4345 +post_id: "60791" +post_author: 1 +"ListingKey": "1137574435" +"ListingId": "202521579" +"PropertyType": "Land" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-15T20:58:05Z" +"RFModificationTimestamp": "2025-11-11T18:53:04Z" +"ListPrice": 1100000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 69827.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Haleiwa" +"PostalCode": "96712" +"UnparsedAddress": "0000 Kamehameha Highway Lot 35, Haleiwa, Hawaii 96712" +"Coordinates": array:2 [ …2] +"Latitude": 21.5817934 +"Longitude": -158.1050145 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ralph S Gray" +"ListOfficeName": "Hawaii Homes International" +"ListAgentMlsId": "24511" +"ListOfficeMlsId": "REEW" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "1.6 acres of Anahulu Stream Front land which allows 1 farm home up to 5,000 sqft on the 1st floor and can do a second floor. Can also build supporting barns and AG structures. Can build up to a maximum of 1,000 sqft AG structures without a permit for fast use. Perfect for grazing or farming. Direct stream front for prawn fishing and fun. Paddleboard or kayak from the river located near the property to Haleiwa Harbor and Beach Park for fun in the sun. Additional lots are available if you need more space. Visitors say this is one of the most beautiful pieces of land they have seen in rural Oahu and is the best-kept secret on the North Shore. Perfect for a family compound, farm, or yoga retreat. Build a yurt or 1,000 sqft footprint AG structure with a second floor today and enjoy the land while you design and build your custom farm dwelling. A ten-minute bike ride to the center of Haleiwa town. Easy access to Kam Hwy and no north shore traffic. A magical place in the Anahulu Valley. Price includes future electrical and freshwater access if and when approved and completed (special terms apply)." +"AttributionContact": "(808) 949-0020" +"BusinessType": "Florist/Nursery" +"CountyOrParish": "Oahu" +"CreationDate": "2025-10-15T21:03:27.532838+00:00" +"CurrentUse": "Agricultural,Other,Residential,Single Family" +"DaysOnMarketReplicationDate": "2025-10-15" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Owner Is Listing Agent,Principal is Real Estate Licensed" +"FrontageType": "Canal" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 295-0704" +"ListAgentEmail": "bgwvrdr@aol.com" +"ListAgentKey": "10772420" +"ListAgentKeyNumeric": "10772420" +"ListAgentOfficePhone": "(808) 949-0020" +"ListAgentPreferredPhone": "(808) 295-0704" +"ListAgentStateLicense": "RS-57803" +"ListOfficeEmail": "hihomesintl@gmail.com" +"ListOfficeKey": "2587968" +"ListOfficeKeyNumeric": "2587968" +"ListOfficePhone": "(808) 949-0020" +"ListingContractDate": "2025-10-15" +"ListingKeyNumeric": 1137574435 +"ListingService": "Full Service" +"LotFeatures": "Interior Lot,Wooded,Level" +"MLSAreaMajor": "North Shore" +"MajorChangeTimestamp": "2025-10-15T10:57:44Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-10-15" +"OriginalListPrice": 1100000.0 +"OriginatingSystemKey": "19012421" +"ParcelNumber": "1-6-2-008-035-0000" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 25 +"PossibleUse": "Farm,Nursery,Single Family" +"PostalCity": "Haleiwa" +"RoadFrontageType": "Private Road" +"Sewer": "None" +"SourceSystemKey": "1137574435" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kamehameha" +"StreetNumber": "0000" +"StreetSuffix": "Highway" +"SubdivisionName": "HALEIWA" +"TaxAnnualAmount": "417.96" +"TaxAssessedValue": 73300 +"Topography": "Level, Sloping" +"UnitNumber": "Lot 35" +"Utilities": "None,Sewer Not Available" +"View": "Mountain(s), Other" +"ViewYN": true +"VirtualTourURLUnbranded": "https://www.youtube.com/embed/Guqfr5aUTf0" +"ZoningDescription": "51 - AG-1 Restricted Agricultur" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1137574435"\n } """ +"Restrictions": "No Restrictions" +"HumanModifiedYN": true +"TaxAssessedValueLand": "73300" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1137574435')" +"provider_name": "HICMLS" +"RecordSignature": -696582791 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-6-2-008-035-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486350" +"OriginatingSystemListAgentMemberKey": "3474891" +"Media": array:25 [ …25] +"ID": "60791" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4343 +post_id: "50895" +post_author: 1 +"ListingKey": "1084818728" +"ListingId": "202419362" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-09-05T10:14:44Z" +"RFModificationTimestamp": "2025-11-11T16:18:04Z" +"ListPrice": 3180000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 12267.0 +"LivingArea": 4151.0 +"BuildingAreaTotal": 4151.0 +"City": "Aiea" +"PostalCode": "96701" +"UnparsedAddress": "98-628 Kuini Street, Aiea, Hawaii 96701" +"Coordinates": array:2 [ …2] +"Latitude": 21.3987677 +"Longitude": -157.9381131 +"YearBuilt": 1984 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Bonnie H Timm" +"ListOfficeName": "INET Realty" +"ListAgentMlsId": "31283" +"ListOfficeMlsId": "PRKK" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Soak up breathtaking views as you lounge in your own private oasis! Rarely available available gorgeous home with two levels to enjoy in Royal Summit. Perfect for entertaining! Beautifully designed home with attention to detail and quality!" +"ArchitecturalStyle": "Detached" +"AssociationFee": "35.0" +"AssociationName": "Newtown Estates Community Association" +"AttributionContact": "(808) 955-7653" +"BathroomsFull": 3 +"CLIP": 5162342856 +"CommunityFeatures": "Deck/Porch, Patio" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2025-04-08T01:49:51.004282+00:00" +"DaysOnMarket": 583 +"DaysOnMarketReplication": 366 +"DaysOnMarketReplicationDate": "2025-09-05" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Pearl Ridge" +"Flooring": "Ceramic Tile,Marble" +"Furnished": "Unfurnished" +"GarageYN": true +"HighSchool": "Aiea" +"Inclusions": "AC Window Unit,Auto Garage Door Opener,Disposal,Drapes,Dryer,Microwave,Range/Oven,Refrigerator,Washer" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 554-3672" +"ListAgentEmail": "bonnietimm@gmail.com" +"ListAgentKey": "10772873" +"ListAgentKeyNumeric": "10772873" +"ListAgentOfficePhone": "(808) 955-7653" +"ListAgentPreferredPhone": "(808) 554-3672" +"ListAgentStateLicense": "RS-66619" +"ListOfficeEmail": "support@inethi.com" +"ListOfficeKey": "2587395" +"ListOfficeKeyNumeric": "2587395" +"ListOfficePhone": "(808) 955-7653" +"ListingContractDate": "2024-09-04" +"ListingKeyNumeric": 1084818728 +"ListingService": "Full Service" +"LotFeatures": "Cleared, Cul-De-Sac, Other" +"MLSAreaMajor": "Pearl City" +"MajorChangeTimestamp": "2025-09-05T00:14:21Z" +"MiddleOrJuniorSchool": "Aiea" +"MlsStatus": "Active" +"OnMarketDate": "2024-09-04" +"OriginalListPrice": 2900000.0 +"OriginatingSystemKey": "18232427" +"ParcelNumber": "1-9-8-067-070-0000" +"ParkingFeatures": "Garage" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 11 +"PoolFeatures": "In Ground" +"PostalCity": "Aiea" +"PropertyCondition": "Excellent,Good Condition" +"SourceSystemKey": "1084818728" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Kuini" +"StreetNumber": "98-628" +"StreetSuffix": "Street" +"SubdivisionName": "ROYAL SUMMIT" +"TaxAnnualAmount": "5580.0" +"TaxAssessedValue": 1754200 +"Topography": "Sloping, Terraced" +"Utilities": "Cable Available,High Speed Internet Available,Water Available" +"View": "City, Ocean" +"ViewYN": true +"VirtualTourURLUnbranded": "https://www.youtube.com/embed/Xwj6dI9obBo?si=8bB45eoED-i3vv8g" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "FractionalOwnershipYN": "0",\n "StreetViewParam": "1$21.398427$-157.938089$236.11$13.33$1.00$k-0PPKXaqPmgWP2JAzWyyA",\n "CompensationSubjectTo": "",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "1221900.00",\n "LockBoxModDT": "2024-09-04T08:12:29.240",\n "SellingAgentRemarks": "",\n "TaxAssessedValueImprovements": "532300.00",\n "CondoPropertyRegimeYN": "0",\n "SetBacks": "C\u0026C",\n "CompensationMethod": "",\n "Easements": "None",\n "LandRecorded": "Land Court",\n "ListingKey": "1084818728",\n "SQFTGarageCarport": "465",\n "TaxExcemptionOwnerOccupancy": "160000",\n "ShowingTimeFlagYN": "1"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 35.0 +"TaxAssessedValueLand": "1221900" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "532300" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1084818728')" +"provider_name": "HICMLS" +"RecordSignature": -542811476 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-8-067-070-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485777" +"OriginatingSystemListAgentMemberKey": "3478892" +"Media": array:11 [ …11] +"ID": "50895" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4340 +post_id: "60092" +post_author: 1 +"ListingKey": "1137121605" +"ListingId": "202521396" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-04T00:06:20Z" +"RFModificationTimestamp": "2025-11-11T14:09:13Z" +"ListPrice": 265000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 26005.0 +"LivingArea": 395.0 +"BuildingAreaTotal": 395.0 +"City": "Honolulu" +"PostalCode": "96817" +"UnparsedAddress": "2040 Nuuanu Avenue 1203, Honolulu, Hawaii 96817" +"Coordinates": array:2 [ …2] +"Latitude": 21.3223712 +"Longitude": -157.8508909 +"YearBuilt": 1984 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Casey S Yoo" +"ListOfficeName": "Compass" +"ListAgentMlsId": "40757" +"ListOfficeMlsId": "COHI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Experience convenient city living at 2040 Nuuanu. This move-in ready studio is a great opportunity for first-time homebuyers or investors. The unit features updated kitchen countertops and cabinets, as well as the convenience of an in-unit washer/dryer. Ceramic tile flooring runs throughout, with in-unit sprinklers that provide comfort and peace of mind. Enjoy stunning views of the Honolulu city skyline from the comfort of your own home.\r\n 2040 Nuuanu is a secure, well-managed building with gated garage parking and excellent amenities, including a pool, whirlpool, sauna, BBQ area, car wash area, meeting room, guest parking, and a welcoming lobby. Conveniently located near bus lines, shopping, Queen’s Hospital, Kuakini Medical Center, Safeway, Long’s, freeway access, and schools. """ +"ArchitecturalStyle": "High Rise" +"AssociationFeeIncludes": "Common Areas,Sewer,Water" +"AttributionContact": "(808) 825-4277" +"BathroomsFull": 1 +"BuildingName": "2040 Nuuanu" +"CommunityFeatures": "Barbecue,Clubhouse,Community Pool,Trash Chute" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2025-10-04T00:11:58.163355+00:00" +"DaysOnMarketReplicationDate": "2025-10-03" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 12 +"Flooring": "Ceramic Tile" +"Furnished": "Unfurnished" +"Inclusions": "Ceiling Fan,Disposal,Dryer,Microwave Hood,Range/Oven,Refrigerator,Washer" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 222-8910" +"ListAgentEmail": "Casey.Yoo@compass.com" +"ListAgentKey": "10773201" +"ListAgentKeyNumeric": "10773201" +"ListAgentOfficePhone": "(808) 825-4277" +"ListAgentPreferredPhone": "(808) 222-8910" +"ListAgentStateLicense": "RB-24273" +"ListOfficeEmail": "julie.meier@compass.com" +"ListOfficeKey": "3944102" +"ListOfficeKeyNumeric": "3944102" +"ListOfficePhone": "(808) 825-4277" +"ListingContractDate": "2025-10-03" +"ListingKeyNumeric": 1137121605 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 802.46 +"MajorChangeTimestamp": "2025-10-03T14:05:46Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-10-03" +"OriginalListPrice": 265000.0 +"OriginatingSystemKey": "19008155" +"ParcelNumber": "1-1-7-012-013-0051" +"ParkingFeatures": "Assigned,Covered,One Space" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 16 +"PostalCity": "Honolulu" +"PropertyCondition": "Average Condition" +"SecurityFeatures": "Closed Circuit Camera(s),Key Card Entry,Fire Sprinkler System" +"SourceSystemKey": "1137121605" +"SpaFeatures": "Community" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Nuuanu" +"StreetNumber": "2040" +"StreetNumberNumeric": "2040" +"StreetSuffix": "Avenue" +"SubdivisionName": "NUUANU-LOWER" +"TaxAnnualAmount": "1029.0" +"TaxAssessedValue": 294100 +"UnitNumber": "1203" +"View": "City" +"ViewYN": true +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1137121605"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 802.0 +"TaxAssessedValueLand": "31700" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "262400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1137121605')" +"provider_name": "HICMLS" +"RecordSignature": -754719859 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-7-012-013-0051" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15465233" +"OriginatingSystemListAgentMemberKey": "3482420" +"Media": array:16 [ …16] +"ID": "60092" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4339 +post_id: "59830" +post_author: 1 +"ListingKey": "1137117206" +"ListingId": "202521378" +"PropertyType": "For Sale" +"PropertySubType": "Multi Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-01T03:15:19Z" +"RFModificationTimestamp": "2025-11-11T18:19:44Z" +"ListPrice": 1395000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 10509.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Honolulu" +"PostalCode": "96817" +"UnparsedAddress": "916 Eu Lane, Honolulu, Hawaii 96817" +"Coordinates": array:2 [ …2] +"Latitude": 21.3229292 +"Longitude": -157.8687306 +"YearBuilt": 1910 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kevin Y Nishikawa" +"ListOfficeName": "Marcus Realty" +"ListAgentMlsId": "21965" +"ListOfficeMlsId": "MARC" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Priced to sell way below tax assessed value! Great for owner-user to redevelop property. Sale includes TMKs: 1-1-5-4: parcels 8, 24, and 27 (10,509 SF land in total). IMX-1 (Industrial Mixed-Use) zoning. Four 2-bedroom/1 bath house all around 100 years old. Small open shed in rear of property. Price based on land value only. Showings subject to accepted offer. Some improvements non-permitted. Being sold in As-Is, Where-Is condition. Buyer to perform their own due diligence. All units rented on month-to-month tenancy. Flood Zone X. DO NOT DISTURB TENANTS OR WALK ON PROEPRTY WITHOUT PROPER NOTICE. Showings based on accepted offer only. Call listor for more details. Note: One or more photos may have been enhanced." +"AttributionContact": "(808) 839-7446" +"CoListAgentDirectPhone": "(808) 392-6475" +"CoListAgentEmail": "Alexander Y@marcushawaii.com" +"CoListAgentFullName": "Alexander C Yen" +"CoListAgentKey": "13401597" +"CoListAgentKeyNumeric": "13401597" +"CoListAgentMlsId": "48978" +"CoListAgentPreferredPhone": "(808) 392-6475" +"CoListOfficeEmail": "kevinn@marcushawaii.com" +"CoListOfficeKey": "2586281" +"CoListOfficeKeyNumeric": "2586281" +"CoListOfficeMlsId": "MARC" +"CoListOfficeName": "Marcus Realty" +"CoListOfficePhone": "(808) 839-7446" +"CommunityFeatures": "None" +"ConstructionMaterials": "Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-09-30T02:32:48.878436+00:00" +"DaysOnMarket": 192 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2025-09-30" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"FrontageType": "Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "None" +"Levels": "One" +"ListAgentDirectPhone": "(808) 220-9220" +"ListAgentEmail": "Kevin N@marcushawaii.com" +"ListAgentKey": "10778737" +"ListAgentKeyNumeric": "10778737" +"ListAgentOfficePhone": "(808) 839-7446" +"ListAgentPreferredPhone": "(808) 220-9220" +"ListAgentStateLicense": "RB-17304" +"ListOfficeEmail": "kevinn@marcushawaii.com" +"ListOfficeKey": "2586281" +"ListOfficeKeyNumeric": "2586281" +"ListOfficePhone": "(808) 839-7446" +"ListingContractDate": "2025-09-29" +"ListingKeyNumeric": 1137117206 +"ListingService": "Full Service" +"LotFeatures": "Dead End,Other,Level" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2025-09-29T16:31:10Z" +"MlsStatus": "Active" +"NetOperatingIncome": 42040.0 +"NumberOfUnitsTotal": "4" +"OnMarketDate": "2025-09-29" +"OpenParkingYN": true +"OperatingExpense": "17000.0" +"OperatingExpenseIncludes": "Insurance,Maintenance,Real Estate Tax,New Tax" +"OriginalListPrice": 1395000.0 +"OriginatingSystemKey": "19007710" +"ParcelNumber": "1-1-5-004-008-0000" +"ParkingFeatures": "Assigned, Open" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 7 +"PostalCity": "Honolulu" +"PropertyCondition": "Repairs Major" +"Sewer": "Connected" +"SourceSystemKey": "1137117206" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Eu" +"StreetNumber": "916" +"StreetNumberNumeric": "916" +"StreetSuffix": "Lane" +"StructureType": "Multi Family" +"SubdivisionName": "DILLINGHAM" +"TaxAnnualAmount": "7439.28" +"TaxAssessedValue": 2926800 +"TenantPays": "Cable TV,Electricity,Gas,Water" +"Topography": "Level" +"TotalActualRent": 4920.0 +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,Phone Available,Sewer Available,Water Available,Sewer Connected" +"View": "None" +"ZoningDescription": "46 - IMX-1 Industrial-Commercia" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1137117206"\n } """ +"HumanModifiedYN": true +"TaxAssessedValueLand": "2800900" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "125900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1137117206')" +"provider_name": "HICMLS" +"RecordSignature": -12730484 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-1-5-004-008-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3484663" +"OriginatingSystemCoListOfficeKey": "3484663" +"OriginatingSystemListAgentMemberKey": "8843080" +"OriginatingSystemCoListAgentMemberKey": "13076467" +"Media": array:7 [ …7] +"ID": "59830" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4346 +post_id: "58605" +post_author: 1 +"ListingKey": "1132998499" +"ListingId": "202519715" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-27T00:12:53Z" +"RFModificationTimestamp": "2025-11-11T18:20:33Z" +"ListPrice": 1039000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 6926.0 +"LivingArea": 1668.0 +"BuildingAreaTotal": 1766.0 +"City": "Ewa Beach" +"PostalCode": "96706" +"UnparsedAddress": "91-1531 Kaikohola Street D72, Ewa Beach, Hawaii 96706" +"Coordinates": array:2 [ …2] +"Latitude": 21.312932 +"Longitude": -158.026978 +"YearBuilt": 2014 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Chari B Badua-Robinson" +"ListOfficeName": "CBR Island Properties & Invest" +"ListAgentMlsId": "43648" +"ListOfficeMlsId": "CRIP" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ PRICE ENHANCED! Set apart by its corner lot location within the gated Kipuka at Hoakalei community, this home combines functional design with neighborhood amenities in one of Ewa Beach’s most desirable settings. \r\n \r\n Features include an open living/dining and kitchen with center island for casual dining. A first-floor bedroom with a full bath makes hosting guests or multigenerational living simple and flexible. \r\n \r\n Upstairs, the primary suite offers a walk-in closet, ensuite bath, tub/shower and a private commode. Two additional bedrooms and a full bath complete the upper level, providing ample space for family and guests. The home also includes central AC, a 2-car garage, and access to exclusive community amenities such as a pool, spa, playgrounds, and manicured walking paths.\r\n \r\n As part of the Hoakalei community, residents also enjoy access to the Wai Kai Lagoon, where you can kayak, paddleboard, and experience water activities in a serene setting, just minutes from your door.\r\n \r\n Close to golf, beaches, schools, shopping, and dining, this home presents a solid opportunity to enjoy both the lifestyle and security of Kipuka at Hoakalei. Weekend showings please. """ +"ArchitecturalStyle": "Detached" +"AssociationAmenities": "Marina" +"AssociationFee": "43.0" +"AssociationFee2": "265.0" +"AssociationFeeIncludes": "Common Areas,Sewer" +"AssociationName": "Kipuka @ Hoakalei" +"AttributionContact": "(808) 351-1712" +"BathroomsFull": 3 +"CLIP": 3236334980 +"CommunityFeatures": "Deck/Porch, Patio, Gated" +"ConstructionMaterials": "Concrete,Steel Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-09-09T00:21:11.333251+00:00" +"DaysOnMarket": 213 +"DaysOnMarketReplication": 48 +"DaysOnMarketReplicationDate": "2025-10-26" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"Fencing": "Fenced, Wall" +"Flooring": "Ceramic Tile,Laminate" +"Furnished": "Unfurnished" +"GarageSpaces": "2.0" +"GarageYN": true +"Inclusions": "AC Central,Auto Garage Door Opener,Blinds,Cable TV,Ceiling Fan,Dishwasher,Disposal,Dryer,Microwave Hood,Range/Oven,Refrigerator,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) 351-1712" +"ListAgentEmail": "charibadua@gmail.com" +"ListAgentKey": "10773432" +"ListAgentKeyNumeric": "10773432" +"ListAgentOfficePhone": "(808) 351-1712" +"ListAgentPreferredPhone": "(808) 351-1712" +"ListAgentStateLicense": "RB-22789" +"ListOfficeEmail": "charibadua@gmail.com" +"ListOfficeKey": "4488110" +"ListOfficeKeyNumeric": "4488110" +"ListOfficePhone": "(808) 351-1712" +"ListingContractDate": "2025-09-08" +"ListingKeyNumeric": 1132998499 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Corner Lot,Level" +"MLSAreaMajor": "Ewaplain" +"MaintenanceExpense": 465.0 +"MajorChangeTimestamp": "2025-09-30T16:42:46Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-09-08" +"OriginalListPrice": 1050000.0 +"OriginatingSystemKey": "18967817" +"ParcelNumber": "1-9-1-162-009-0001" +"ParkingFeatures": "Garage,Two Car Garage,Two Spaces" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 25 +"PoolFeatures": "Community" +"PostalCity": "Ewa Beach" +"PropertyCondition": "Average Condition,Good Condition" +"SecurityFeatures": "Gated Community" +"SourceSystemKey": "1132998499" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Kaikohola" +"StreetNumber": "91-1531" +"StreetSuffix": "Street" +"SubdivisionName": "HOAKALEI-KIPUKA" +"TaxAnnualAmount": "2211.96" +"TaxAssessedValue": 1037200 +"Topography": "Level" +"UnitNumber": "D72" +"Utilities": "Cable Available,Electricity Available,High Speed Internet Available,Other,Underground Utilities,Water Available" +"View": "None" +"VirtualTourURLUnbranded": "https://track.pstmrk.it/3s/media.visionaryviewsllc.com%2Fsites%2Fkjzjxpl%2Funbranded/cUpU/66q-AQ/AQ/af06dd82-84ff-4818-9603-28f73d0be56a/3/HLgiAQQa3w" +"WaterSource": "Public" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1132998499"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 773.0 +"TaxAssessedValueLand": "778900" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "258300" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1132998499')" +"provider_name": "HICMLS" +"RecordSignature": -613762138 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-1-162-009-0001" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "16362009" +"OriginatingSystemListAgentMemberKey": "3483732" +"Media": array:25 [ …25] +"ID": "58605" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4347 +post_id: "61722" +post_author: 1 +"ListingKey": "1145139936" +"ListingId": "202524579" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-03T19:39:51Z" +"RFModificationTimestamp": "2025-11-11T20:16:55Z" +"ListPrice": 63800.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 31886.0 +"LivingArea": 500.0 +"BuildingAreaTotal": 500.0 +"City": "Honolulu" +"PostalCode": "96813" +"UnparsedAddress": "1188 Bishop Street 1302, Honolulu, Hawaii 96813" +"Coordinates": array:2 [ …2] +"Latitude": 21.310586 +"Longitude": -157.8591719 +"YearBuilt": 1981 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lucy Liu Shen" +"ListOfficeName": "eXp Realty" +"ListAgentMlsId": "45737" +"ListOfficeMlsId": "EXPI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Large SQFT leasehold office in prime downtown Honolulu location! This 500 sq ft corner unit features a private office room, kitchenette and full bathroom for added convenience. This unit features marble flooring, whirlpool bathtub and a high ceiling with popcorn texture removed. The building provides 24-hour security, giving you peace of mind for your business. Conveniently located near courthouses, restaurants, and major bus lines, this unit is ideal for businesses seeking a prime Honolulu address in a building that provides accessibility and visibility. Weekly cleaning and daily trash service provided." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "HVAC,Hot Water,Sewer,Water" +"AttributionContact": "(808) 725-2794" +"BathroomsFull": 1 +"BuildingName": "Century Square" +"CommonWalls": "End Unit" +"CommunityFeatures": "Conference/Meeting Room" +"ConstructionMaterials": "Concrete" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2025-11-03T19:42:27.976451+00:00" +"DaysOnMarketReplicationDate": "2025-11-03" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 13 +"Flooring": "Laminate, Marble" +"Furnished": "Partially" +"Inclusions": "AC Central,Microwave,Range/Oven,Refrigerator" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LeaseAmount": "382.0" +"LeaseExpiration": "2044-02-29" +"ListAgentDirectPhone": "(808) 358-2021" +"ListAgentEmail": "lucyliushen@gmail.com" +"ListAgentKey": "10779264" +"ListAgentKeyNumeric": "10779264" +"ListAgentOfficePhone": "(808) 725-2794" +"ListAgentPreferredPhone": "(808) 358-2021" +"ListAgentStateLicense": "RS-77203" +"ListOfficeEmail": "hi.broker@exprealty.net" +"ListOfficeKey": "2589160" +"ListOfficeKeyNumeric": "2589160" +"ListOfficePhone": "(808) 725-2794" +"ListingContractDate": "2025-11-03" +"ListingKeyNumeric": 1145139936 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 654.0 +"MajorChangeTimestamp": "2025-11-03T09:38:47Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-11-03" +"OriginalListPrice": 63800.0 +"OriginatingSystemKey": "19074311" +"ParcelNumber": "1-2-1-010-046-0089" +"ParkingFeatures": "Unassigned" +"ParkingTotal": "1.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 16 +"PostalCity": "Honolulu" +"PropertyCondition": "Average Condition,Good Condition,Updated/Remodeled" +"SecurityFeatures": "Elevator Secured,Key Card Entry,Security Guard" +"SourceSystemKey": "1145139936" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Bishop" +"StreetNumber": "1188" +"StreetNumberNumeric": "1188" +"StreetSuffix": "Street" +"SubdivisionName": "DOWNTOWN" +"TaxAnnualAmount": "1944.0" +"TaxAssessedValue": 156600 +"UnitNumber": "1302" +"View": "City, Ocean" +"ViewYN": true +"YearBuiltEffective": 2010 +"ZoningDescription": "34 - BMX-4 Central Business Mix" +"ListAOR": "HI Central" +"LandTenure": "Lease Hold" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1145139936"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 654.0 +"TaxAssessedValueLand": "23300" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "133300" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1145139936')" +"provider_name": "HICMLS" +"RecordSignature": -1847567921 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-1-010-046-0089" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "10013908" +"OriginatingSystemListAgentMemberKey": "9802532" +"Media": array:16 [ …16] +"ID": "61722" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4348 +post_id: "59950" +post_author: 1 +"ListingKey": "1136790211" +"ListingId": "202521036" +"PropertyType": "For Sale" +"PropertySubType": "Multi Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-11T02:07:06Z" +"RFModificationTimestamp": "2025-11-11T17:28:19Z" +"ListPrice": 2850000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 5376.0 +"LivingArea": 0 +"BuildingAreaTotal": 3978.0 +"City": "Honolulu" +"PostalCode": "96813" +"UnparsedAddress": "404 Magellan Avenue, Honolulu, Hawaii 96813" +"Coordinates": array:2 [ …2] +"Latitude": 21.3104804 +"Longitude": -157.8518251 +"YearBuilt": 1948 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Stephanie Rae Band" +"ListOfficeName": "Compass" +"ListAgentMlsId": "51562" +"ListOfficeMlsId": "COHI" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "PRIME INVESTMENT OPPORTUNITY - REALIZE IMMEDIATE INCOME UPSIDE OF 5.7-6% CAP RATE W/ ONLY A FEW MINOR CHANGES!! - In the heart of Honolulu this 9-unit property at 404 Magellan Ave offers a strong foundation with 9 separate electric meters, 9 separate gas meters, and individual gas water heaters for each unit—a rare setup that maximizes tenant independence and reduces ownership expenses. The building is currently generating income with solid rental history, and offers excellent upside potential: simply increase rents to market value or enhance returns with light remodeling or upgrades. This property provides flexibility and long-term growth opportunities in a highly desirable location close to schools, shops, and major transit routes. A must-see for investors looking for cash flow today and room to grow tomorrow!" +"Appliances": "Dryer, Washer" +"AttributionContact": "(808) 825-4277" +"CommunityFeatures": "None" +"ConstructionMaterials": "Hollow Tile,Other,Single Wall,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-10-02T03:56:20.291259+00:00" +"DaysOnMarket": 190 +"DaysOnMarketReplication": 9 +"DaysOnMarketReplicationDate": "2025-10-10" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Pet on Property,Seller Disclosure" +"FrontageType": "Other" +"Furnished": "Partially" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": "Coin-operated" +"Levels": "Three Or More" +"ListAgentDirectPhone": "(808) 773-9390" +"ListAgentEmail": "stephanie@hawaiidreamhomes.com" +"ListAgentKey": "19179745" +"ListAgentKeyNumeric": "19179745" +"ListAgentOfficePhone": "(808) 825-4277" +"ListAgentPreferredPhone": "(808) 773-9390" +"ListAgentStateLicense": "RS-84381" +"ListOfficeEmail": "julie.meier@compass.com" +"ListOfficeKey": "3944102" +"ListOfficeKeyNumeric": "3944102" +"ListOfficePhone": "(808) 825-4277" +"ListingContractDate": "2025-10-01" +"ListingKeyNumeric": 1136790211 +"ListingService": "Full Service" +"LotFeatures": "Other" +"MLSAreaMajor": "Metro" +"MajorChangeTimestamp": "2025-10-01T17:37:39Z" +"MlsStatus": "Active" +"NetOperatingIncome": 102967.0 +"NumberOfUnitsTotal": "9" +"OnMarketDate": "2025-10-01" +"OperatingExpense": "22313.0" +"OperatingExpenseIncludes": "Insurance,Other,Real Estate Tax,Water/Sewer" +"OriginalListPrice": 2850000.0 +"OriginatingSystemKey": "18997788" +"ParcelNumber": "1-2-1-021-047-0000" +"ParkingFeatures": "Assigned" +"ParkingTotal": "9.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 23 +"PostalCity": "Honolulu" +"PropertyCondition": "Average Condition" +"Sewer": "Connected" +"SourceSystemKey": "1136790211" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Magellan" +"StreetNumber": "404" +"StreetNumberNumeric": "404" +"StreetSuffix": "Avenue" +"StructureType": "Apartment" +"SubdivisionName": "PUNCHBOWL-LOWER" +"TaxAnnualAmount": "4413.12" +"TaxAssessedValue": 1260900 +"TenantPays": "Cable TV,Electricity,Gas,Other" +"Topography": "Sloping" +"TotalActualRent": 10375.0 +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,Natural Gas Available,High Speed Internet Available,Phone Available,Sewer Available,Water Available,Sewer Connected" +"View": "City, Mountain(s)" +"ViewYN": true +"VirtualTourURLUnbranded": "https://www.youtube.com/embed/k3y-dFPSqZo?si=WzIviUoBnByuC8Q-" +"WaterSource": "Public" +"YearBuiltEffective": 1960 +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1136790211"\n } """ +"HumanModifiedYN": true +"TaxAssessedValueLand": "1053800" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "207100" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1136790211')" +"provider_name": "HICMLS" +"RecordSignature": 1384953013 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-1-021-047-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "15465233" +"OriginatingSystemListAgentMemberKey": "16055746" +"Media": array:23 [ …23] +"ID": "59950" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4349 +post_id: "60612" +post_author: 1 +"ListingKey": "1139783220" +"ListingId": "202523464" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-31T18:07:17Z" +"RFModificationTimestamp": "2025-11-11T13:32:03Z" +"ListPrice": 750000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 6361.0 +"LivingArea": 1832.0 +"BuildingAreaTotal": 1832.0 +"City": "Waianae" +"PostalCode": "96792" +"UnparsedAddress": "87-866 Hakeakea Street, Waianae, Hawaii 96792" +"Coordinates": array:2 [ …2] +"Latitude": 21.4066812 +"Longitude": -158.1753204 +"YearBuilt": 1962 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Alexie Manabat-Rule" +"ListOfficeName": "Corcoran Pacific Properties" +"ListAgentMlsId": "50902" +"ListOfficeMlsId": "ELIT04" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Discover this exceptional four-bedroom, three bathroom home on a quiet dead-end street in Maili. Recently refurbished, this 1,832 sqft residence features durable construction and an open concept living space. Exposed beam ceilings create a sense of spaciousness and architectural charm. The primary bedroom offers a private retreat, while three additional bedrooms provide flexibility for family and guests. There's also a dedicated office area for remote work or creative pursuits. The back patio is perfect for morning coffee or sunset relaxation, with gentle trade winds keeping things comfortable year-round. You're minutes from Maili Point Beach Park where ocean adventures await. Move in and enjoy island living right away! Quality construction, recent renovations and a welcoming atmosphere are waiting. This is more than a house; It is a place where memories are made." +"ArchitecturalStyle": "Detached" +"AttributionContact": "(808) 589-2040" +"BathroomsFull": 3 +"CarportYN": true +"CommunityFeatures": "Deck/Porch, Patio" +"ConstructionMaterials": "Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-10-14T03:07:54.479031+00:00" +"DaysOnMarket": 181 +"DaysOnMarketReplication": 21 +"DaysOnMarketReplicationDate": "2025-10-31" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"Fencing": "Fenced, Wall" +"Flooring": "Hardwood, Vinyl" +"Inclusions": "AC Window Unit,Ceiling Fan,Dryer,Range/Oven,Refrigerator,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 589-2040" +"ListAgentEmail": "alexie.manabat-rule@corcoranpacific.com" +"ListAgentOfficePhone": "(808) 589-2040" +"ListAgentPreferredPhone": "(808) 589-2040" +"ListOfficeEmail": "office@corcoranpacific.com" +"ListOfficeKey": "2589373" +"ListOfficeKeyNumeric": "2589373" +"ListOfficePhone": "(808) 589-2040" +"ListingContractDate": "2025-10-10" +"ListingKeyNumeric": 1139783220 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Dead End,Level" +"MLSAreaMajor": "Leeward" +"MajorChangeTimestamp": "2025-10-13T17:03:01Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-10-10" +"OriginalListPrice": 750000.0 +"OriginatingSystemKey": "19043736" +"ParcelNumber": "1-8-7-020-041-0000" +"ParkingFeatures": "Carport" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 21 +"PoolFeatures": "None" +"PostalCity": "Waianae" +"PropertyCondition": "Good Condition" +"RoadFrontageType": "County Road" +"SourceSystemKey": "1139783220" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Hakeakea" +"StreetNumber": "87-866" +"StreetSuffix": "Street" +"SubdivisionName": "MAILI" +"TaxAnnualAmount": "1742.64" +"TaxAssessedValue": 657900 +"Topography": "Level" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,High Speed Internet Available,Water Available" +"View": "None" +"WaterSource": "Public" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1139783220"\n } """ +"HumanModifiedYN": false +"TaxAssessedValueLand": "373800" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "284100" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1139783220')" +"provider_name": "HICMLS" +"RecordSignature": -1711733128 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-8-7-020-041-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "12427406" +"OriginatingSystemListAgentMemberKey": "15570535" +"Media": array:21 [ …21] +"ID": "60612" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4350 +post_id: "52588" +post_author: 1 +"ListingKey": "1111892397" +"ListingId": "202510245" +"PropertyType": "Land" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-03T05:00:29Z" +"RFModificationTimestamp": "2025-11-11T14:53:48Z" +"ListPrice": 745000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 9020.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hauula" +"PostalCode": "96717" +"UnparsedAddress": "53-014 Makao Road F, Hauula, Hawaii 96717" +"Coordinates": array:2 [ …2] +"Latitude": 21.6055697 +"Longitude": -157.9031322 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Deborah V Low" +"ListOfficeName": "Coldwell Banker Realty" +"ListAgentMlsId": "42766" +"ListOfficeMlsId": "CBPP04" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ Endless Possibilities Await! Just one block from the ocean and framed by scenic mountain views, this spacious R-5 zoned lot offers the perfect setting for your next great project. Whether you're envisioning your dream home or planning an investment opportunity, the possibilities here are wide open. With a blank canvas like this, all you need is your vision, your plans, and your contractor to bring it to life. Don’t miss this rare chance to create something truly special!\r\n \r\n **To be sold simultaneously with TMK 1-5-3-016-016 (MLS 202510237)** """ +"AttributionContact": "(808) 262-3104" +"CLIP": 1084273899 +"CoListAgentDirectPhone": "(808) 262-3104" +"CoListAgentEmail": "caitlin.strickland@cbrealty.com" +"CoListAgentFullName": "Caitlin Strickland" +"CoListAgentKey": "21961307" +"CoListAgentKeyNumeric": "21961307" +"CoListAgentMlsId": "52923" +"CoListAgentPreferredPhone": "(808) 465-6168" +"CoListOfficeEmail": "mike.james@cbrealty.com" +"CoListOfficeKey": "2586332" +"CoListOfficeKeyNumeric": "2586332" +"CoListOfficeMlsId": "CBPP04" +"CoListOfficeName": "Coldwell Banker Realty" +"CoListOfficePhone": "(808) 262-3104" +"CountyOrParish": "Oahu" +"CreationDate": "2025-05-03T05:01:53.366537+00:00" +"CurrentUse": "Residential,Single Family" +"DaysOnMarketReplicationDate": "2025-05-02" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure,See Remarks" +"ElementarySchool": "Hauula" +"ExteriorFeatures": "None" +"HighSchool": "Kahuku" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 382-8005" +"ListAgentEmail": "dlow@cbrealty.com" +"ListAgentKey": "10778268" +"ListAgentKeyNumeric": "10778268" +"ListAgentOfficePhone": "(808) 262-3104" +"ListAgentPreferredPhone": "(808) 382-8005" +"ListAgentStateLicense": "RS-73474" +"ListOfficeEmail": "mike.james@cbrealty.com" +"ListOfficeKey": "2586332" +"ListOfficeKeyNumeric": "2586332" +"ListOfficePhone": "(808) 262-3104" +"ListingContractDate": "2025-05-02" +"ListingKeyNumeric": 1111892397 +"ListingService": "Full Service" +"LotFeatures": "Level" +"MLSAreaMajor": "Kaneohe" +"MajorChangeTimestamp": "2025-05-02T18:58:50Z" +"MiddleOrJuniorSchool": "Kahuku" +"MlsStatus": "Active" +"OnMarketDate": "2025-05-02" +"OriginalListPrice": 745000.0 +"OriginatingSystemKey": "18696219" +"ParcelNumber": "1-5-3-016-019-0000" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 6 +"PostalCity": "Hauula" +"Sewer": "None" +"SourceSystemKey": "1111892397" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Makao" +"StreetNumber": "53-014" +"StreetSuffix": "Road" +"SubdivisionName": "HAUULA" +"TaxAnnualAmount": "2250.36" +"TaxAssessedValue": 643100 +"Topography": "Level" +"UnitNumber": "F" +"Utilities": "Above Ground Utilities,Cable Available,Electricity Available,Water Available,Sewer Not Available" +"View": "Garden, Mountain(s)" +"ViewYN": true +"WaterSource": "Public" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "CompensationSubjectTo": "",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "643100.00",\n "LockBoxModDT": "2025-04-17T11:52:31.867",\n "CompensationMethod": "",\n "SellingAgentRemarks": "",\n "LandRecorded": "Regular System",\n "ListingKey": "1111892397",\n "StreetViewParam": "1$21.604907$-157.902427$325.19$13.33$1.00$vh32vXRw_hjvUBFFxw8EOw",\n "TaxAssessedValueImprovements": "0.00",\n "SetBacks": "Of Record",\n "Easements": "None",\n "ShowingTimeFlagYN": "0"\n } """ +"Restrictions": "No Restrictions" +"HumanModifiedYN": false +"TaxAssessedValueLand": "643100" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1111892397')" +"provider_name": "HICMLS" +"RecordSignature": -1346284972 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-5-3-016-019-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3484714" +"OriginatingSystemCoListOfficeKey": "3484714" +"OriginatingSystemListAgentMemberKey": "3483099" +"OriginatingSystemCoListAgentMemberKey": "17069725" +"Media": array:6 [ …6] +"ID": "52588" } 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4351 +post_id: "57142" +post_author: 1 +"ListingKey": "1126885995" +"ListingId": "202518050" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-30T19:55:30Z" +"RFModificationTimestamp": "2025-11-11T15:27:23Z" +"ListPrice": 239000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 297.0 +"BuildingAreaTotal": 297.0 +"City": "Honolulu" +"PostalCode": "96814" +"UnparsedAddress": "410 Atkinson Drive 1714, Honolulu, Hawaii 96814" +"Coordinates": array:2 [ …2] +"Latitude": 21.2904878 +"Longitude": -157.8395414 +"YearBuilt": 1970 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ryota Seki" +"ListOfficeName": "Hawaii 5-0 Properties, Inc." +"ListAgentMlsId": "39951" +"ListOfficeMlsId": "HAFO" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Modern studio at Ala Moana Hotel Condo with partial ocean view. Just steps from Ala Moana Shopping Center, Ala Moana Beach Park, and the Convention Center. Enjoy full hotel services and a top-floor steakhouse with stunning city views. Prime Honolulu location for shopping, dining, and entertainment. Legal short-term rental—perfect for personal use or income when you’re away." +"ArchitecturalStyle": "High Rise" +"AssociationFeeIncludes": "Common Areas,Cable TV,Electricity,Hot Water,None,Sewer,Water" +"AttributionContact": "(808) 971-7711" +"BathroomsFull": 1 +"BuildingName": "Ala Moana Hotel Condo" +"CLIP": 8736119861 +"CommunityFeatures": "Conference/Meeting Room,Deck/Porch,Fitness,Patio,Pool,Recreation Area,Restaurant,Sauna,Trash Chute" +"ConstructionMaterials": "Concrete" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2025-08-14T02:35:09.997836+00:00" +"DaysOnMarket": 239 +"DaysOnMarketReplication": 17 +"DaysOnMarketReplicationDate": "2025-08-30" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 17 +"Flooring": "Carpet" +"Inclusions": "AC Central,Cable TV,Drapes,Microwave,Refrigerator,Smoke Detector" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 954-9691" +"ListAgentEmail": "ryota@hi50group.com" +"ListAgentKey": "10768091" +"ListAgentKeyNumeric": "10768091" +"ListAgentOfficePhone": "(808) 971-7711" +"ListAgentPreferredPhone": "(808) 954-9691" +"ListAgentStateLicense": "RB-22960" +"ListOfficeEmail": "yuri@hi50group.com" +"ListOfficeKey": "2586910" +"ListOfficeKeyNumeric": "2586910" +"ListOfficePhone": "(808) 971-7711" +"ListingContractDate": "2025-08-13" +"ListingKeyNumeric": 1126885995 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1314.27 +"MajorChangeTimestamp": "2025-08-13T16:33:26Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-08-13" +"OriginalListPrice": 239000.0 +"OriginatingSystemKey": "18923939" +"ParcelNumber": "1-2-3-038-002-0622" +"ParkingFeatures": "None, Valet" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 18 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Key Card Entry,Security Guard" +"SourceSystemKey": "1126885995" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Atkinson" +"StreetNumber": "410" +"StreetNumberNumeric": "410" +"StreetSuffix": "Drive" +"SubdivisionName": "ALA MOANA" +"TaxAnnualAmount": "3180.0" +"TaxAssessedValue": 203800 +"UnitNumber": "1714" +"View": "City, Ocean" +"ViewYN": true +"ZoningDescription": "33 - BMX-3 Community Business M" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1126885995"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 1314.0 +"TaxAssessedValueLand": "58800" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "145000" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1126885995')" +"provider_name": "HICMLS" +"RecordSignature": 783338025 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-3-038-002-0622" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3485292" +"OriginatingSystemListAgentMemberKey": "3482158" +"Media": array:18 [ …18] +"ID": "57142" } 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4352 +post_id: "56659" +post_author: 1 +"ListingKey": "1125626659" +"ListingId": "202517480" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-05T22:08:18Z" +"RFModificationTimestamp": "2025-11-11T15:52:11Z" +"ListPrice": 12600000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 54743.0 +"LivingArea": 2836.0 +"BuildingAreaTotal": 2836.0 +"City": "Honolulu" +"PostalCode": "96816" +"UnparsedAddress": "3841 Pukalani Place, Honolulu, Hawaii 96816" +"Coordinates": array:2 [ …2] +"Latitude": 21.287356 +"Longitude": -157.791664 +"YearBuilt": 2021 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jianu Chen" +"ListOfficeName": "Prestige Realty LLC" +"ListAgentMlsId": "46831" +"ListOfficeMlsId": "PSTG" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Rare development opportunity in highly desirable Wilhelmina Rise! This property features a huge R-5 zoned lot with the potential to build up to 8 CPR single-family homes (subject to approval). The CPR process is already underway, with several building permits currently pending approval. Existing structure has an open permit, pending on a revision/addition permit for the basement. Prime location just minutes from Kaimuki, Kahala, and freeway access. Stunning diamond head and ocean views." +"ArchitecturalStyle": "Detached" +"AttributionContact": "(808) 942-8172" +"BathroomsFull": 4 +"CLIP": 8199482743 +"ConstructionMaterials": "Double Wall,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-08-05T22:09:18.361875+00:00" +"DaysOnMarketReplicationDate": "2025-08-05" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"Flooring": "Ceramic Tile,Marble,Vinyl" +"FoundationDetails": "Slab" +"GarageYN": true +"Inclusions": "AC Split,Auto Garage Door Opener,Blinds,Ceiling Fan,Convection Oven,Disposal,Dryer,Microwave Hood,Range/Oven,Refrigerator,Washer" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 721-8886" +"ListAgentEmail": "kchen@prllc.us" +"ListAgentKey": "10779672" +"ListAgentKeyNumeric": "10779672" +"ListAgentOfficePhone": "(808) 942-8172" +"ListAgentPreferredPhone": "(808) 721-8886" +"ListAgentStateLicense": "RS-78711" +"ListOfficeEmail": "hi@prllc.us" +"ListOfficeKey": "2585532" +"ListOfficeKeyNumeric": "2585532" +"ListOfficePhone": "(808) 942-8172" +"ListingContractDate": "2025-08-05" +"ListingKeyNumeric": 1125626659 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Dead End,Irregular Lot,Rim Lot" +"MLSAreaMajor": "Diamond Hd" +"MajorChangeTimestamp": "2025-08-05T12:07:42Z" +"MlsStatus": "Active" +"NewConstructionYN": true +"OnMarketDate": "2025-08-05" +"OriginalListPrice": 12600000.0 +"OriginatingSystemKey": "18907807" +"ParcelNumber": "1-3-3-017-030-0000" +"ParkingFeatures": "Garage,Three or more Spaces" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 6 +"PoolFeatures": "Above Ground" +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition" +"SourceSystemKey": "1125626659" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Pukalani" +"StreetNumber": "3841" +"StreetNumberNumeric": "3841" +"StreetSuffix": "Place" +"SubdivisionName": "WILHELMINA" +"TaxAnnualAmount": "13417.56" +"TaxAssessedValue": 1826100 +"Topography": "Sloping" +"Utilities": "Above Ground Utilities,Electricity Available,Other,Water Available" +"View": "City, Garden, Mountain(s), Ocean" +"ViewYN": true +"WaterSource": "Public" +"ZoningDescription": "05 - R-5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "ListingKey": "1125626659"\n } """ +"HumanModifiedYN": true +"TaxAssessedValueLand": "1015500" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "810600" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1125626659')" +"provider_name": "HICMLS" +"RecordSignature": 670587129 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-3-3-017-030-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3487414" +"OriginatingSystemListAgentMemberKey": "10619120" +"Media": array:6 [ …6] +"ID": "56659" } 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4353 +post_id: "48970" +post_author: 1 +"ListingKey": "1093436820" +"ListingId": "202425809" +"PropertyType": "Land" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-11-04T23:48:07Z" +"RFModificationTimestamp": "2025-11-11T15:35:27Z" +"ListPrice": 1894999.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 1869900.0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hawi" +"PostalCode": "96719" +"UnparsedAddress": "Lot #9 Lahuiki Place, Hawi, Hawaii 96719" +"Coordinates": array:2 [ …2] +"Latitude": 20.228608 +"Longitude": -155.872017 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Heather Selvitelle" +"ListOfficeName": "List Sotheby's Int'l Realty" +"ListAgentMlsId": "29869" +"ListOfficeMlsId": "LIST" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Discover a unique opportunity to develop a thriving agricultural estate in Kohala! This remarkable property features breathtaking ocean views and stunning sunsets, with the Maui coastline and Haleakala visible on clear days. You’ll also enjoy panoramic vistas of Mauna Loa and Hualalai, enhancing the natural beauty of your future homestead. Located in an established, private community, the property benefits from sensible CC&Rs that provide essential protections without the rigidity found in many newer developments. This flexibility allows for creative agricultural and residential possibilities. Access to the property is via a private road and is available by appointment only, ensuring a serene atmosphere. Embrace the chance to cultivate your vision in this picturesque location—perfect for farming, relaxation, or creating your dream estate!" +"AttributionContact": "(808) 735-2411" +"CoListAgentDirectPhone": "(808) 478-2568" +"CoListAgentEmail": "jeffhughes96743@gmail.com" +"CoListAgentFullName": "Jeffrey A Hughes" +"CoListAgentKey": "10778816" +"CoListAgentKeyNumeric": "10778816" +"CoListAgentMlsId": "25917" +"CoListAgentPreferredPhone": "(808) 478-2568" +"CoListOfficeEmail": "info@listsir.com" +"CoListOfficeKey": "2586183" +"CoListOfficeKeyNumeric": "2586183" +"CoListOfficeMlsId": "LIST" +"CoListOfficeName": "List Sotheby's Int'l Realty" +"CoListOfficePhone": "(808) 735-2411" +"CountyOrParish": "Hawaii" +"CreationDate": "2025-10-14T07:41:12.495860+00:00" +"CurrentUse": "Agricultural" +"DaysOnMarket": 521 +"DaysOnMarketReplication": 365 +"DaysOnMarketReplicationDate": "2025-11-04" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ExteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 282-1764" +"ListAgentEmail": "heather@surfhawaiianhomes.com" +"ListAgentKey": "10777780" +"ListAgentKeyNumeric": "10777780" +"ListAgentOfficePhone": "(808) 735-2411" +"ListAgentPreferredPhone": "(808) 282-1764" +"ListAgentStateLicense": "RB-22771" +"ListOfficeEmail": "info@listsir.com" +"ListOfficeKey": "2586183" +"ListOfficeKeyNumeric": "2586183" +"ListOfficePhone": "(808) 735-2411" +"ListingContractDate": "2024-11-04" +"ListingKeyNumeric": 1093436820 +"ListingService": "Full Service" +"LotFeatures": "Rolling Slope" +"MLSAreaMajor": "N. Kohala" +"MajorChangeTimestamp": "2025-11-04T13:47:54Z" +"MlsStatus": "Active" +"OnMarketDate": "2024-11-04" +"OriginalListPrice": 1900000.0 +"OriginatingSystemKey": "18360531" +"ParcelNumber": "3-5-6-001-023-0000" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 23 +"PostalCity": "Hawi" +"RoadFrontageType": "Private Road" +"Sewer": "Septic Tank" +"SourceSystemKey": "1093436820" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Lahuiki" +"StreetNumber": "Lot #9" +"StreetSuffix": "Place" +"SubdivisionName": "KAPAAU" +"TaxAnnualAmount": "200.04" +"TaxAssessedValue": 18000 +"Topography": "Rolling, Sloping" +"Utilities": "Electricity Available,Natural Gas Available,None,Septic Available,Water Available" +"View": "Coastline, Ocean, Other, Sunset" +"ViewYN": true +"ZoningDescription": "Neighbor Island - See Remarks" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "SetBacks": "Of Record",\n "CompensationSubjectTo": "",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "18000.00",\n "LockBoxModDT": "2024-10-31T08:55:20.953",\n "CompensationMethod": "",\n "SellingAgentRemarks": "",\n "Easements": "Electric,Other",\n "LandRecorded": "Regular System",\n "ListingKey": "1093436820",\n "TaxAssessedValueImprovements": "0.00",\n "ShowingTimeFlagYN": "1"\n } """ +"Restrictions": "Restrictive Covenant" +"HumanModifiedYN": true +"TaxAssessedValueLand": "18000" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "0" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1093436820')" +"provider_name": "HICMLS" +"RecordSignature": -1772586978 +"UniversalParcelId": "urn:reso:upi:2.0:US:15001:3-5-6-001-023-0000" +"CountrySubdivision": "15001" +"OriginatingSystemListOfficeKey": "9066313" +"OriginatingSystemCoListOfficeKey": "9066313" +"OriginatingSystemListAgentMemberKey": "3478268" +"OriginatingSystemCoListAgentMemberKey": "8843301" +"Media": array:23 [ …23] +"ID": "48970" } 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4354 +post_id: "53468" +post_author: 1 +"ListingKey": "1114286226" +"ListingId": "202512370" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-18T01:24:16Z" +"RFModificationTimestamp": "2025-11-11T20:06:23Z" +"ListPrice": 583000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 911.0 +"BuildingAreaTotal": 911.0 +"City": "Kapolei" +"PostalCode": "96707" +"UnparsedAddress": "91-1029 Kamaaha Avenue 1204, Kapolei, Hawaii 96707" +"Coordinates": array:2 [ …2] +"Latitude": 21.3340079 +"Longitude": -158.077849 +"YearBuilt": 2011 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "John Mack Encarnacion" +"ListOfficeName": "Option One Real Estate LLC" +"ListAgentMlsId": "51208" +"ListOfficeMlsId": "OONE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": """ VA Loan 3.75% Assumable even for non VA Buyers Yess! Enjoy the vibrant energy of Kapolei, where modern convenience meets island charm! Nestled in the heart of Makakilo-Kapolei-Honokai Hale, this incredible opportunity places you minutes from stunning beaches, world-class shopping, and top-rated schools.\r\n Imagine living in a thriving community with easy access to dining, entertainment, and major roadways, making every day seamless and enjoyable. Whether you're looking for comfort, convenience, or investment potential. \r\n Move in ready Vacant! """ +"AssociationFee": "648.0" +"AssociationName": "Villages at Kapolei" +"BathroomsFull": 2 +"BuildingName": "Kealakai@Kapolei V" +"CLIP": 3757405446 +"CommonWalls": "End Unit" +"CommunityFeatures": "Deck/Porch, Patio" +"ConstructionMaterials": "Double Wall,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-05-22T23:49:59.279884+00:00" +"DaysOnMarket": 323 +"DaysOnMarketReplication": 149 +"DaysOnMarketReplicationDate": "2025-10-17" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ElementarySchool": "Kapolei" +"EntryLevel": 2 +"Flooring": "Laminate" +"Furnished": "Unfurnished" +"HighSchool": "Kapolei" +"Inclusions": "AC Window Unit,Blinds,Ceiling Fan,Dishwasher,Dryer,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAgentDirectPhone": "(808) 793-8356" +"ListAgentEmail": "hawaiihomeownersclub@gmail.com" +"ListAgentKey": "18330694" +"ListAgentKeyNumeric": "18330694" +"ListAgentOfficePhone": "(210) 389-5266" +"ListAgentPreferredPhone": "(808) 793-8356" +"ListAgentStateLicense": "RS-83916" +"ListOfficeEmail": "Jason@Real Estate Bad Ass.com" +"ListOfficeKey": "5525368" +"ListOfficeKeyNumeric": "5525368" +"ListOfficePhone": "(210) 389-5266" +"ListingContractDate": "2025-05-21" +"ListingKeyNumeric": 1114286226 +"ListingService": "Full Service" +"MLSAreaMajor": "Ewaplain" +"MaintenanceExpense": 55.0 +"MajorChangeTimestamp": "2025-10-17T15:23:55Z" +"MiddleOrJuniorSchool": "Kapolei" +"MlsStatus": "Active" +"OnMarketDate": "2025-05-21" +"OpenParkingYN": true +"OriginalListPrice": 598000.0 +"OriginatingSystemKey": "18756897" +"ParcelNumber": "1-9-1-016-200-0012" +"ParkingFeatures": "Guest,Two Spaces" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 5 +"PostalCity": "Kapolei" +"PropertyCondition": "Good Condition" +"SourceSystemKey": "1114286226" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Kamaaha" +"StreetNumber": "91-1029" +"StreetSuffix": "Avenue" +"StructureType": "Townhouse" +"SubdivisionName": "KAPOLEI" +"TaxAnnualAmount": "2148.0" +"TaxAssessedValue": 584400 +"UnitNumber": "1204" +"View": "Other" +"ViewYN": true +"ZoningDescription": "12 - A-2 Medium Density Apartme" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"CustomFields": """ {\n "CompensationSubjectTo": "",\n "TaxPaidBySellerYN": "",\n "TaxAssessedValueLand": "298400.00",\n "LockBoxModDT": "2025-06-02T19:03:29.853",\n "CompensationMethod": "",\n "SellingAgentRemarks": "",\n "ListingKey": "1114286226",\n "TaxAssessedValueImprovements": "286000.00",\n "ManagementCompanyName": "Associa",\n "StreetViewParam": "1$21.331861$-158.0722$61.11$13.33$1.00$_hArqfzGrLaxrZsOr5bC2w",\n "ManagementCompanyPhone": "808-836-0911",\n "OwnerOccupancyPercentage": "1",\n "TaxExcemptionOwnerOccupancy": "Owner Occupant",\n "LandRecorded": "Regular System",\n "FractionalOwnershipYN": "0",\n "CondoParkingUnit": "Guest",\n "ParkingAdditional": "0",\n "ShowingTimeFlagYN": "0"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 703.0 +"TaxAssessedValueLand": "298400" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "286000" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1114286226')" +"provider_name": "HICMLS" +"RecordSignature": 1916363200 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-9-1-016-200-0012" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "17999443" +"OriginatingSystemListAgentMemberKey": "15797853" +"Media": array:5 [ …5] +"ID": "53468" } 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4355 +post_id: "58072" +post_author: 1 +"ListingKey": "1130224188" +"ListingId": "202519051" +"PropertyType": "For Sale" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-09-05T18:00:54Z" +"RFModificationTimestamp": "2025-11-11T17:58:08Z" +"ListPrice": 5100000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 13522.0 +"LivingArea": 2048.0 +"BuildingAreaTotal": 2648.0 +"City": "Koloa" +"PostalCode": "96756" +"UnparsedAddress": "2815 Ke Alaula Street, Koloa, Hawaii 96756" +"Coordinates": array:2 [ …2] +"Latitude": 21.9042279 +"Longitude": -159.465733 +"YearBuilt": 2012 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Karen E Lau" +"ListOfficeName": "Locations LLC" +"ListAgentMlsId": "13550" +"ListOfficeMlsId": "LOCA" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Club Cottage #11 within Kukuiula consists of a serene and architecturally significant 2-bedroom/2.5-bath residence and a complementing 1 bedroom 1 bath detached guest house. Located adjacent to The Club at Kukuiula, this property affords the exclusive opportunity to join the exclusive Lodge Program at Kukuiula where you and your vacationing guests may enjoy coveted access to the Club at Kukuiula and its amenities.This Club Cottage Property provides fine features including: 2 Primary Suites, a Separate, Detached 1-bdrm Cottage, Professionally Designed Furnishings, Private Front and Backyards, Lush Tropical Native Plantings, and Lava Rock Fire Pit. Amenities Include: Private Club Membership, Tom Weiskopf-designed, Private 18-hole Par-72 golf course, World-class spa featuring indoor/outdoor treatment rooms, outdoor lap pool, steam rooms, and complete fitness rooms and movement studios, Golf Club House, Fine dining in the Kukuiula Plantation House, Design Guidelines, Comprehensive paths and hiking trails throughout the Community, Roving 24/7 Security Services, Access to Upcountry Farm and Lake, Fitness and Spa Programs, Volleyball, Pickleball, Tennis, Pool Bar and Grille." +"ArchitecturalStyle": "Cottage, Detached, Studio" +"AssociationFee": "1673.0" +"AssociationFee2": "2080.0" +"AssociationName": "Kukuiula Community Assoc." +"AttributionContact": "(808) 735-4200" +"BathroomsFull": 3 +"CLIP": 4402569726 +"CoListAgentDirectPhone": "(808) 542-4863" +"CoListAgentEmail": "nana.thain@cbrealty.com" +"CoListAgentFullName": "Nana Thain" +"CoListAgentKey": "10778813" +"CoListAgentKeyNumeric": "10778813" +"CoListAgentMlsId": "25795" +"CoListAgentPreferredPhone": "(808) 542-4863" +"CoListOfficeEmail": "Jordan PChow@gmail.com" +"CoListOfficeKey": "4339040" +"CoListOfficeKeyNumeric": "4339040" +"CoListOfficeMlsId": "CBCR" +"CoListOfficeName": "Coldwell Banker Comm Realty" +"CoListOfficePhone": "(808) 392-1906" +"CommunityFeatures": "Deck/Porch,Patio,Tennis Court(s)" +"ConstructionMaterials": "Double Wall" +"CountyOrParish": "Kauai" +"CreationDate": "2025-08-29T20:24:48.178442+00:00" +"DaysOnMarket": 224 +"DaysOnMarketReplication": 8 +"DaysOnMarketReplicationDate": "2025-09-05" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"ExteriorFeatures": "Landscaping" +"Flooring": "Ceramic Tile,Hardwood" +"Furnished": "Furnished" +"Inclusions": "AC Split,Blinds,Cable TV,Ceiling Fan,Dishwasher,Disposal,Dryer,Microwave,Range Hood,Range/Oven,Refrigerator,Smoke Detector,Washer,Water Heater" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 292-2492" +"ListAgentEmail": "karen.lau@locationshawaii.com" +"ListAgentKey": "10768465" +"ListAgentKeyNumeric": "10768465" +"ListAgentOfficePhone": "(808) 735-4200" +"ListAgentPreferredPhone": "(808) 292-2492" +"ListAgentStateLicense": "RS-40961" +"ListOfficeEmail": "darryl.macha@locationshawaii.com" +"ListOfficeKey": "2586923" +"ListOfficeKeyNumeric": "2586923" +"ListOfficePhone": "(808) 735-4200" +"ListingContractDate": "2025-08-28" +"ListingKeyNumeric": 1130224188 +"ListingService": "Full Service" +"LotFeatures": "Cleared,Interior Lot,Level" +"MLSAreaMajor": "Kauai" +"MaintenanceExpense": 1713.81 +"MajorChangeTimestamp": "2025-09-05T08:00:52Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-08-28" +"OriginalListPrice": 5400000.0 +"OriginatingSystemKey": "18951259" +"ParcelNumber": "4-2-6-019-011-0000" +"ParkingFeatures": "Driveway" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 2 +"PoolFeatures": "Community" +"PostalCity": "Koloa" +"PropertyCondition": "Good Condition" +"RoadFrontageType": "Private Road" +"RoomType": "Guest Quarters" +"SourceSystemKey": "1130224188" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "1" +"StreetName": "Ke Alaula" +"StreetNumber": "2815" +"StreetNumberNumeric": "2815" +"StreetSuffix": "Street" +"SubdivisionName": "KOLOA" +"TaxAnnualAmount": "657360.0" +"TaxAssessedValue": 5252200 +"Topography": "Level, Sloping" +"Utilities": "Cable Available,Electricity Available,Natural Gas Available,High Speed Internet Available,Sewer Available,Underground Utilities,Water Available" +"View": "Garden, Mountain(s)" +"ViewYN": true +"WaterSource": "Public" +"ZoningDescription": "03 - R10 - Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1130224188"\n } """ +"HumanModifiedYN": true +"AssociationFeeTotal": 5467.0 +"TaxAssessedValueLand": "3645900" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "1606300" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1130224188')" +"provider_name": "HICMLS" +"RecordSignature": -1108238284 +"UniversalParcelId": "urn:reso:upi:2.0:US:15007:4-2-6-019-011-0000" +"CountrySubdivision": "15007" +"OriginatingSystemListOfficeKey": "3485305" +"OriginatingSystemCoListOfficeKey": "16117127" +"OriginatingSystemListAgentMemberKey": "8842826" +"OriginatingSystemCoListAgentMemberKey": "8843292" +"Media": array:2 [ …2] +"ID": "58072" } 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#4356 +post_id: "60005" +post_author: 1 +"ListingKey": "1135674420" +"ListingId": "202520629" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-10-18T02:25:13Z" +"RFModificationTimestamp": "2025-11-11T19:25:41Z" +"ListPrice": 55000000.0 +"BathroomsTotalInteger": 11.0 +"BathroomsHalf": 1 +"BedroomsTotal": 11.0 +"LotSizeArea": 89125.0 +"LivingArea": 10047.0 +"BuildingAreaTotal": 13626.0 +"City": "Honolulu" +"PostalCode": "96816" +"UnparsedAddress": "3735 Diamond Head Road, Honolulu, Hawaii 96816" +"Coordinates": array:2 [ …2] +"Latitude": 21.2579311 +"Longitude": -157.8005757 +"YearBuilt": 1967 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Noel Pietsch Shaw" +"ListOfficeName": "Hawaii Life" +"ListAgentMlsId": "45076" +"ListOfficeMlsId": "HLRE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Located on Diamond Head Road, Ho‘oluana Estate is one of Honolulu’s last remaining legacy estate-sized properties, spanning over two acres across two adjacent parcels. Zoned R-7.5 and encompassing nearly 89,120 square feet, the estate features two residences and an open lot, offering sweeping ocean views, beachfront access, and exceptional flexibility for development or preservation. Perfectly positioned between Kahala and Waikiki, this property combines luxury, tranquility, and proximity to world-class surfing, shopping, dining, golf, hiking, and more. Offered as a singular acquisition under TMKs 1-3-1-039-042-0000 and 1-3-1-039-005-0000, Ho‘oluana Estate presents a rare opportunity to establish a landmark estate in one of Honolulu’s most prestigious locations. Property details may not match tax records. Last four digits of the listing TMK do not exist, these are used only for MLS entry purposes." +"ArchitecturalStyle": "Detached, Multiplex" +"AttributionContact": "(800) 667-5028" +"BathroomsFull": 10 +"CommunityFeatures": "Deck/Porch,Patio,Storage Facilities" +"ConstructionMaterials": "Double Wall,Concrete,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2025-10-02T19:18:04.593357+00:00" +"DaysOnMarket": 189 +"DaysOnMarketReplication": 15 +"DaysOnMarketReplicationDate": "2025-10-17" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "None" +"ExteriorFeatures": "Landscaping" +"Fencing": "Fenced, Wall" +"Flooring": "Ceramic Tile,Hardwood,Other" +"FrontageType": "Oceanfront, Waterfront" +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "AC Split,Blinds,Book Shelves,Dishwasher,Drapes,Lawn Sprinkler,Range/Oven,Refrigerator,Security System,Smoke Detector,Washer,Water Heater" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": "Two" +"ListAgentDirectPhone": "(808) 221-8889" +"ListAgentEmail": "noelshaw@hawaiilife.com" +"ListAgentKey": "10779096" +"ListAgentKeyNumeric": "10779096" +"ListAgentOfficePhone": "(800) 667-5028" +"ListAgentPreferredPhone": "(808) 221-8889" +"ListAgentStateLicense": "RS-75888" +"ListOfficeEmail": "Admin@hawaiilife.com" +"ListOfficeKey": "2588754" +"ListOfficeKeyNumeric": "2588754" +"ListOfficePhone": "(800) 667-5028" +"ListingContractDate": "2025-10-02" +"ListingKeyNumeric": 1135674420 +"ListingService": "Full Service" +"LotFeatures": "Other, Level" +"MLSAreaMajor": "Diamond Hd" +"MajorChangeTimestamp": "2025-10-02T09:17:14Z" +"MlsStatus": "Active" +"OnMarketDate": "2025-10-02" +"OriginalListPrice": 55000000.0 +"OriginatingSystemKey": "18987311" +"OtherStructures": "Workshop" +"ParcelNumber": "1-3-1-039-005-9999" +"ParkingFeatures": "Boat,Driveway,Garage,Three or more Spaces" +"ParkingTotal": "10.0" +"PhotosChangeTimestamp": "2025-11-11T00:22:05Z" +"PhotosCount": 11 +"PoolFeatures": "In Ground" +"PostalCity": "Honolulu" +"PropertyCondition": "Average Condition,Updated/Remodeled" +"RoadFrontageType": "Private Road" +"RoomType": "Entry/Foyer,Guest Quarters" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1135674420" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Diamond Head" +"StreetNumber": "3735" +"StreetNumberNumeric": "3735" +"StreetSuffix": "Road" +"SubdivisionName": "DIAMOND HEAD" +"TaxAnnualAmount": "84636.0" +"TaxAssessedValue": 15367400 +"Topography": "Level, Sloping" +"Utilities": "Above Ground Utilities,Electricity Available,Water Available" +"View": "Coastline, Garden, Mountain(s), Ocean" +"ViewYN": true +"WaterfrontYN": true +"ZoningDescription": "04 - R-7.5 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1135674420"\n } """ +"HumanModifiedYN": false +"TaxAssessedValueLand": "14178000" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "1189400" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1135674420')" +"provider_name": "HICMLS" +"RecordSignature": -98169481 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-3-1-039-005-9999" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3487136" +"OriginatingSystemListAgentMemberKey": "9493566" +"Media": array:11 [ …11] +"ID": "60005" } ] +success: true +page_size: 18 +page_count: 239 +count: 4293 +after_key: "" } "RF Response Time" => "0.33 seconds" ] "RF Query: /Property?$select=ALL&$orderby=meta_value date DESC&$top=18&$skip=4176&$filter=(StandardStatus eq 'Active') and (StandardStatus eq 'Active' OR RFTransactionType eq 'Active')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#6852 +items: array:18 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6894 +post_id: "81423" +post_author: 1 +"ListingKey": "1156894019" +"ListingId": "202607008" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-10T02:21:12Z" +"RFModificationTimestamp": "2026-04-10T02:22:47Z" +"ListPrice": 1650000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 12627.0 +"LivingArea": 1392.0 +"BuildingAreaTotal": 2371.0 +"City": "Kailua" +"PostalCode": "96734" +"UnparsedAddress": "1343 Maleko Street, Kailua, Hawaii 96734" +"Coordinates": array:2 [ …2] +"Latitude": 21.3556823 +"Longitude": -157.7684841 +"YearBuilt": 2000 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ky Lao" +"ListOfficeName": "Five Star Realty, Inc." +"ListAgentMlsId": "45384" +"ListOfficeMlsId": "FIVE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Nestled in Maunawili Estates, this beautifully crafted home offers privacy, comfort, and the best of island living. Located on a quiet cul-de-sac with no through traffic, the fully enclosed property provides a serene setting ideal for relaxation and pets. Built in 2000 on an elevated 12,627 sqft lot, the home captures cool trade wind breezes and is filled with abundant natural light, with split AC in every room for added comfort. The main living level features 2 en suite bedrooms, complemented by an additional den on the lower yard level... perfect for an office or workshop. A separate studio cottage with a closet and a full bathroom adds versatility for multigenerational living, rental potential, or a private workspace. Enjoy breathtaking Olomana and Koolau mountain views from the expansive wrap-around covered lanai. The classic kitchen features granite countertops, flagstone backsplash, a Viking range, along with koa hardwood floors and travertine tile bathrooms throughout. Spacious lot offers excellent potential for future expansion. Conveniently located with easy access to Kailua Town & Honolulu, yet tucked away from the daily hustle. Offered below tax assessed value." +"ArchitecturalStyle": "Cottage, Detached, Studio" +"AttributionContact": "(808) 382-6871" +"BathroomsFull": 3 +"CoListAgentDirectPhone": "(808) 777-9523" +"CoListAgentEmail": "izzi@Five Star Realty.org" +"CoListAgentFullName": "Izzi Chan" +"CoListAgentKey": "21999865" +"CoListAgentKeyNumeric": "21999865" +"CoListAgentMlsId": "53008" +"CoListAgentPreferredPhone": "(808) 777-9523" +"CoListOfficeEmail": "vincent@fivestarrealty.org" +"CoListOfficeKey": "2588170" +"CoListOfficeKeyNumeric": "2588170" +"CoListOfficeMlsId": "FIVE" +"CoListOfficeName": "Five Star Realty, Inc." +"CoListOfficePhone": "(808) 382-6871" +"CommunityFeatures": "Deck/Porch, Patio" +"ConstructionMaterials": "Double Wall,Wood Frame" +"CountyOrParish": "Oahu" +"CreationDate": "2026-04-08T20:12:37.763874+00:00" +"DaysOnMarket": 1 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2026-04-09" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure,See Remarks" +"ElementarySchool": "Maunawili" +"Fencing": "Fenced, Wall" +"Flooring": "Carpet, Hardwood, Other" +"FoundationDetails": "Slab" +"FrontageType": "Canal" +"Furnished": "Unfurnished" +"GarageSpaces": "2.0" +"GarageYN": true +"HighSchool": "Kailua" +"HumanModifiedYN": true +"Inclusions": "AC Split,Auto Garage Door Opener,Ceiling Fan,Dishwasher,Disposal,Dryer,Microwave,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": "Two" +"ListAgentDirectPhone": "(808) 258-9698" +"ListAgentEmail": "Ky@Five Star Realty.org" +"ListAgentKey": "10779181" +"ListAgentKeyNumeric": "10779181" +"ListAgentOfficePhone": "(808) 382-6871" +"ListAgentPreferredPhone": "(808) 258-9698" +"ListAgentStateLicense": "RB-22543" +"ListOfficeEmail": "vincent@fivestarrealty.org" +"ListOfficeKey": "2588170" +"ListOfficeKeyNumeric": "2588170" +"ListOfficePhone": "(808) 382-6871" +"ListingContractDate": "2026-04-08" +"ListingKeyNumeric": 1156894019 +"ListingService": "Full Service" +"LotFeatures": "Cul-De-Sac,Dead End,Other,Level" +"MLSAreaMajor": "Kailua" +"MajorChangeTimestamp": "2026-04-08T10:09:06Z" +"MiddleOrJuniorSchool": "Kailua" +"MlsStatus": "Active" +"OnMarketDate": "2026-04-08" +"OriginalListPrice": 1650000.0 +"OriginatingSystemKey": "19374570" +"ParcelNumber": "1-4-2-064-001-0000" +"ParkingFeatures": "Driveway,Two Car Garage,Two Spaces,On Street" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2026-04-07T17:51:01Z" +"PhotosCount": 25 +"PoolFeatures": "None" +"PostalCity": "Kailua" +"PropertyCondition": "Excellent,Good Condition" +"RoomType": "Guest Quarters" +"SecurityFeatures": "Key Card Entry" +"SourceSystemKey": "1156894019" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"Stories": "2" +"StreetName": "Maleko" +"StreetNumber": "1343" +"StreetNumberNumeric": "1343" +"StreetSuffix": "Street" +"SubdivisionName": "MAUNAWILI" +"TaxAnnualAmount": "5436.0" +"TaxAssessedValue": 1757400 +"Topography": "Level, Sloping" +"Utilities": "Cable Available,Electricity Available,High Speed Internet Available,Other,Sewer Available,Underground Utilities,Water Available" +"View": "Garden, Mountain(s)" +"ViewYN": true +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=g5ZtoHBrXmd&mls=1" +"WaterSource": "Public" +"ZoningDescription": "02 - R-20 Residential District" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1156894019"\n } """ +"TaxAssessedValueLand": "1452500" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "304900" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1156894019')" +"provider_name": "HICMLS" +"RecordSignature": -2095311310 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-4-2-064-001-0000" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3486552" +"OriginatingSystemCoListOfficeKey": "3486552" +"OriginatingSystemListAgentMemberKey": "9677937" +"OriginatingSystemCoListAgentMemberKey": "17110168" +"Media": array:25 [ …25] +"ID": "81423" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6892 +post_id: "81351" +post_author: 1 +"ListingKey": "1156951978" +"ListingId": "202607066" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-08T20:19:33Z" +"RFModificationTimestamp": "2026-04-08T20:24:56Z" +"ListPrice": 680000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 67910.0 +"LivingArea": 1014.0 +"BuildingAreaTotal": 1100.0 +"City": "Honolulu" +"PostalCode": "96813" +"UnparsedAddress": "700 Richards Street 2406, Honolulu, Hawaii 96813" +"Coordinates": array:2 [ …2] +"Latitude": 21.3061577 +"Longitude": -157.8623027 +"YearBuilt": 1971 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Pam Maeda" +"ListOfficeName": "Marcus Realty" +"ListAgentMlsId": "48962" +"ListOfficeMlsId": "MARC" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "ALL UTILITIES INCLUDED. This 2-bedroom, 2-bath corner residence at Harbor Square offers ocean and mountain views in the heart of Downtown Honolulu. Recent updates include stainless steel kitchen appliances, central A/C with Smart Thermostat, a new in-unit washer and dryer, primary bath renovation and updated luxury vinyl plank flooring. The functional layout provides comfortable living for socializing or a quiet retreat. It comes with a covered end parking stall and 24/7 security. Maintenance fees INCLUDES electricity, water, sewer, cable, and internet. Enjoy spending time on the recently updated pool deck with ocean views, use of the convenient surfboard and paddle board storage, and a warm-welcoming secured lobby area. Conveniently located within walking distance of the waterfront, Iolani Palace, Aloha Tower, Kaka'ako, and a variety of dining and retail options. Ala Moana Beach Park is approximately one mile away. For qualified VA buyers, a VA assumable loan at 2.25% may be available, subject to lender approval and eligibility requirements." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFeeIncludes": "Common Areas,Cable TV,Electricity,HVAC,Hot Water,Internet,Maintenance Grounds,Maintenance Structure" +"AttributionContact": "(808) 839-7446" +"BathroomsFull": 2 +"BuildingName": "Harbor Square" +"CommonWalls": "End Unit" +"CommunityFeatures": "Barbecue,Community Pool,Pool,Recreation Area,Trash Chute" +"ConstructionMaterials": "Double Wall,Masonry,Other,Concrete,Stucco" +"Cooling": "Central Air" +"CoolingYN": true +"CountyOrParish": "Oahu" +"CreationDate": "2026-04-08T20:18:34.384826+00:00" +"DaysOnMarketReplicationDate": "2026-04-08" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "Seller Disclosure" +"EntryLevel": 24 +"Flooring": "Ceramic Tile,Laminate" +"GarageYN": true +"HumanModifiedYN": true +"Inclusions": "AC Central,Disposal,Drapes,Dryer,Microwave Hood,Range/Oven,Refrigerator,Smoke Detector,Washer" +"InteriorFeatures": "Bedroom on Main Level,Full Bath on Main Level,Storage" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": "One" +"ListAgentDirectPhone": "(808) 839-7446" +"ListAgentEmail": "pamm@marcushawaii.com" +"ListAgentKey": "13401554" +"ListAgentKeyNumeric": "13401554" +"ListAgentOfficePhone": "(808) 839-7446" +"ListAgentPreferredPhone": "(808) 839-7446" +"ListAgentStateLicense": "RB-24297" +"ListOfficeEmail": "kevinn@marcushawaii.com" +"ListOfficeKey": "2586281" +"ListOfficeKeyNumeric": "2586281" +"ListOfficePhone": "(808) 839-7446" +"ListingContractDate": "2026-04-08" +"ListingKeyNumeric": 1156951978 +"ListingService": "Full Service" +"MLSAreaMajor": "Metro" +"MaintenanceExpense": 1731.21 +"MajorChangeTimestamp": "2026-04-08T10:14:39Z" +"MlsStatus": "Active" +"OnMarketDate": "2026-04-08" +"OriginalListPrice": 680000.0 +"OriginatingSystemKey": "19375992" +"ParcelNumber": "1-2-1-016-015-0326" +"ParkingFeatures": "Assigned,Covered,Garage,One Space,Secured" +"ParkingTotal": "1.0" +"PetsAllowed": "Call" +"PhotosChangeTimestamp": "2026-04-08T20:20:00Z" +"PhotosCount": 19 +"PostalCity": "Honolulu" +"PropertyCondition": "Excellent,Good Condition" +"SecurityFeatures": "Closed Circuit Camera(s),Elevator Secured,Key Card Entry,Security Guard" +"SourceSystemKey": "1156951978" +"SpecialListingConditions": "None" +"StateOrProvince": "HI" +"StreetName": "Richards" +"StreetNumber": "700" +"StreetNumberNumeric": "700" +"StreetSuffix": "Street" +"SubdivisionName": "DOWNTOWN" +"TaxAnnualAmount": "2394.72" +"TaxAssessedValue": 650000 +"UnitNumber": "2406" +"View": "Coastline, City, Mountain(s), Sunrise" +"ViewYN": true +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=ZFuJYAprrUL&mls=1" +"ZoningDescription": "34 - BMX-4 Central Business Mix" +"ListAOR": "HI Central" +"LandTenure": "Fee Simple" +"Permission": "IDX" +"CustomFields": """ {\n "ListingKey": "1156951978"\n } """ +"AssociationFeeTotal": 1731.0 +"TaxAssessedValueLand": "72200" +"OriginatingSystemSubName": "HICMLS_HBR" +"TaxAssessedValueImprovement": "577800" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('1156951978')" +"provider_name": "HICMLS" +"RecordSignature": 1310249136 +"UniversalParcelId": "urn:reso:upi:2.0:US:15003:1-2-1-016-015-0326" +"CountrySubdivision": "15003" +"OriginatingSystemListOfficeKey": "3484663" +"OriginatingSystemListAgentMemberKey": "13063134" +"Media": array:19 [ …19] +"ID": "81351" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6897 +post_id: "81350" +post_author: 1 +"ListingKey": "1156953665" +"ListingId": "202607073" +"PropertyType": "For Sale" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-09T23:09:38Z" +"RFModificationTimestamp": "2026-04-09T23:13:49Z" +"ListPrice": 750000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 55016.0 +"LivingArea": 651.0 +"BuildingAreaTotal": 679.0 +"City": "Honolulu" +"PostalCode": "96815" +"UnparsedAddress": "1765 Ala Moana Boulevard 786, Honolulu, Hawaii 96815" +"Coordinates": array:2 [ …2] +"Latitude": 21.2847074 +"Longitude": -157.837256 +"YearBuilt": 1968 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Ron Parsons" +"ListOfficeName": "Sunset Reef Realty" +"ListAgentMlsId": "45072" +"ListOfficeMlsId": "CEBE" +"OriginatingSystemName": "HICMLS" +"PublicRemarks": "Experience true Hawaiian lifestyle living, with unparalleled Marina panoramic views, unobstructed sunsets of the Pacific Ocean, tropical views of Magic Island and the serene lagoons at Hilton Hawaiian Village; all completed with weekly Friday night fireworks to be enjoyed from your lanai or comfort of your living-room. This updated 1-bedroom 1-bathroom is fully furnished, and turnkey ready. Currently rented as a short-term rental with excellent occupancy, can be a perfect investment opportunity or a vacation getaway in the heart of Waikiki. Walking distance to the Ala Moana shopping center and all the attractions Waikiki has to offer. Building amenities include two restaurants onsite, 24-hour security and parking available for daily/monthly rent." +"ArchitecturalStyle": "High Rise" +"AssociationAmenities": "Management" +"AssociationFee2": "72.0" +"AttributionContact": "(808) 271-9007" +"BathroomsFull": 1 +"BuildingName": "Ilikai Marina" +"CoListAgentDirectPhone": "(808) 271-9007" +"CoListAgentEmail": "diana_damius@yahoo.com" +"CoListAgentFullName": "Diana Damian-Bakcsi" +"CoListAgentKey": "10779888" +"CoListAgentKeyNumeric": "10779888" +"CoListAgentMlsId": "47352" +"CoListAgentPreferredPhone": "(808) 927-7942" +"CoListOfficeEmail": "aliceclombardo@aol.com" +"CoListOfficeKey": "2587597" +"CoListOfficeKeyNumeric": "2587597" +"CoListOfficeMlsId": "CEBE" +"CoListOfficeName": "Sunset Reef Realty" +"CoListOfficePhone": "(808) 271-9007" +"CommunityFeatures": "Laundry Facilities" +"ConstructionMaterials": "Concrete" +"CountyOrParish": "Oahu" +"CreationDate": "2026-04-08T20:24:48.755165+00:00" +"DaysOnMarket": 1 +"DaysOnMarketReplication": 1 +"DaysOnMarketReplicationDate": "2026-04-09" +"DaysOnMarketReplicationIncreasingYN": true +"Disclosures": "See Remarks" +"ElementarySchool": "Jefferson" +"EntryLevel": 7 +"Flooring": "Other, Vinyl" +"Furnished": "Furnished" …71 } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6875 …114} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6893 …107} 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6898 …110} 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6899 …119} 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6876 …124} 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6873 …117} 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6862 …124} 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6869 …109} 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6877 …113} 12 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6949 …115} 13 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6900 …133} 14 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6848 …123} 15 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6849 …118} 16 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6850 …130} 17 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6851 …130} ] +success: true +page_size: 18 +page_count: 239 +count: 4293 +after_key: "" } "RF Response Time" => "0.29 seconds" ] ]
