Office will be closed on Friday, July 3, 2026 for Independence Day.
47-271 Miomio Loop Kaneohe, HI 96744
Listing Overview
Price: $2,400,000 Area: MIOMIO Status: Active
Rare Kaneohe Bay oceanfront with a panoramic view that is truly the centerpiece of the property. Set along peaceful Miomio Lp, this home enjoys a commanding outlook over Kaneohe Bay, the coastline, the Ko'olau Mountains, and Mokoli'i — a rare oceanfront view plane that is difficult to replicate and central to the value of this offering. The dwelling features 3 bedrooms and 1 bathroom downstairs, plus an upstairs primary suite with full bathroom that has been converted into a separate living area with a wet bar, but can easily be converted back. A large deck off the upstairs suite overlooks the water, further enhancing the connection to the bay. Enjoy close proximity to Kaneohe Sandbar, further enhancing the appeal of this exceptional bayfront setting. The property also features an in-ground pool and a fairly low-maintenance yard. Pre-Listing home inspection by Building Specs available upon request. Properties like this do not come available often. Open House, Sunday, 6/14/26 2:00-5:00. Listing by: Horita Realty LLC (808) 783-6011
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202609017"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "47-271"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Miomio"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Loop"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96744"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2400000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "MIOMIO"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1002) "Rare Kaneohe Bay oceanfront with a panoramic view that is truly the centerpiece of the property. Set along peaceful Miomio Lp, this home enjoys a commanding outlook over Kaneohe Bay, the coastline, the Ko'olau Mountains, and Mokoli'i — a rare oceanfront view plane that is difficult to replicate and central to the value of this offering. The dwelling features 3 bedrooms and 1 bathroom downstairs, plus an upstairs primary suite with full bathroom that has been converted into a separate living area with a wet bar, but can easily be converted back. A large deck off the upstairs suite overlooks the water, further enhancing the connection to the bay. Enjoy close proximity to Kaneohe Sandbar, further enhancing the appeal of this exceptional bayfront setting. The property also features an in-ground pool and a fairly low-maintenance yard. Pre-Listing home inspection by Building Specs available upon request. Properties like this do not come available often. Open House, Sunday, 6/14/26 2:00-5:00."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(17) "Horita Realty LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "7517.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2028"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1974"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(12) "Average,Fair"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(39) "Coastline,Garden,Mountain,Ocean,Sunrise"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "HRTA"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(26) "timborsch@horitarealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 783-6011"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(10) "Tim Borsch"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19435248"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2026-06-22T16:55:29.053"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2026-06-04"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "16:55:29.053"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27414051"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27414051"
[1]=>
string(8) "27414052"
[2]=>
string(8) "27414053"
[3]=>
string(8) "27414054"
[4]=>
string(8) "27414055"
[5]=>
string(8) "27414056"
[6]=>
string(8) "27414057"
[7]=>
string(8) "27414058"
[8]=>
string(8) "27414059"
[9]=>
string(8) "27414060"
[10]=>
string(8) "27414061"
[11]=>
string(8) "27414062"
[12]=>
string(8) "27414063"
[13]=>
string(8) "27414064"
[14]=>
string(8) "27414065"
[15]=>
string(8) "27414066"
[16]=>
string(8) "27414067"
[17]=>
string(8) "27414068"
[18]=>
string(8) "27414069"
[19]=>
string(8) "27414070"
[20]=>
string(8) "27414071"
[21]=>
string(8) "27414072"
[22]=>
string(8) "27414073"
[23]=>
string(8) "27414074"
[24]=>
string(8) "27414075"
[25]=>
string(8) "27414076"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202609017
)
[StreetNumber] => Array
(
[0] => 47-271
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Miomio
)
[StreetSuffix] => Array
(
[0] => Loop
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 2400000.00
)
[Neighbourhood] => Array
(
[0] => MIOMIO
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Rare Kaneohe Bay oceanfront with a panoramic view that is truly the centerpiece of the property. Set along peaceful Miomio Lp, this home enjoys a commanding outlook over Kaneohe Bay, the coastline, the Ko'olau Mountains, and Mokoli'i — a rare oceanfront view plane that is difficult to replicate and central to the value of this offering. The dwelling features 3 bedrooms and 1 bathroom downstairs, plus an upstairs primary suite with full bathroom that has been converted into a separate living area with a wet bar, but can easily be converted back. A large deck off the upstairs suite overlooks the water, further enhancing the connection to the bay. Enjoy close proximity to Kaneohe Sandbar, further enhancing the appeal of this exceptional bayfront setting. The property also features an in-ground pool and a fairly low-maintenance yard. Pre-Listing home inspection by Building Specs available upon request. Properties like this do not come available often. Open House, Sunday, 6/14/26 2:00-5:00.
)
[ListOfficeName] => Array
(
[0] => Horita Realty LLC
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 7517.00
)
[SqftTotal] => Array
(
[0] => 2028
)
[YearBuilt] => Array
(
[0] => 1974
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average,Fair
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Coastline,Garden,Mountain,Ocean,Sunrise
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => HRTA
)
[ListAgentEmail] => Array
(
[0] => timborsch@horitarealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 783-6011
)
[ListAgentFullName] => Array
(
[0] => Tim Borsch
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19435248
)
[MatrixModifiedDT] => Array
(
[0] => 2026-06-22T16:55:29.053
)
[ListingContractDate] => Array
(
[0] => 2026-06-04
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Ocean
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 16:55:29.053
)
[_thumbnail_id] => Array
(
[0] => 27414051
)
[listing_image] => Array
(
[0] => 27414051
[1] => 27414052
[2] => 27414053
[3] => 27414054
[4] => 27414055
[5] => 27414056
[6] => 27414057
[7] => 27414058
[8] => 27414059
[9] => 27414060
[10] => 27414061
[11] => 27414062
[12] => 27414063
[13] => 27414064
[14] => 27414065
[15] => 27414066
[16] => 27414067
[17] => 27414068
[18] => 27414069
[19] => 27414070
[20] => 27414071
[21] => 27414072
[22] => 27414073
[23] => 27414074
[24] => 27414075
[25] => 27414076
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on June 22, 2026 - 4:55 PM
Information is deemed reliable but not guaranteed.
Copyright: 2026 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, our company may represent you as the buyer's agent.
If the active listing you are interested in is our company's active listing, you may speak to one of our agents
regarding your options for representation.
