Listing
Overview
Price: $1,748,000
Area: CLUB VIEW ESTATE
Status: Active Under Contract
Tucked away in this quiet neighborhood at the foot of the majestic Ko'olau Mountain range, this large custom 3-bedroom, 3.5 bath retreat gets a dramatic front-row view of Kaneohe's famous waterfalls that seem almost close enough to touch. Immerse yourself in nature in this private oasis that backs up to preservation land, surrounded by flowers and fruit trees – Puakenikeni, gardenia, orchids, ti, bananas, coconut, clove, papaya, citrus and more. The lower level features an oversized living room, spacious kitchen with ample cabinetry and a gas stove, a formal dining area and 2 bedrooms, each with ensuite bathrooms and split ACs, plus an extra half bath. A large primary suite comprises the entire second level, with a large bathroom, double walk-in closets, and a loft sitting room that leads to a private outdoor deck with breathtaking mountain views. Imagine waking to the symphony of birdsong! Upgrades include a new roof, skylights and rain gutters, newly renovated deck, freshly painted exterior and new ceiling fans throughout. Convenient to the beaches and bays of Kaneohe and Kailua, with easy access to highways, Honolulu, the airport & O'ahu's military installations. Listing by: Coldwell Banker Realty (808) 343-0659
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202605012"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "47-594"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(9) "Hui Ulili"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["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(59) "https://s3.amazonaws.com/video.creativeedge.tv/898472-4.mp4"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1748000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(16) "CLUB VIEW ESTATE"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1186) "Tucked away in this quiet neighborhood at the foot of the majestic Ko'olau Mountain range, this large custom 3-bedroom, 3.5 bath retreat gets a dramatic front-row view of Kaneohe's famous waterfalls that seem almost close enough to touch. Immerse yourself in nature in this private oasis that backs up to preservation land, surrounded by flowers and fruit trees – Puakenikeni, gardenia, orchids, ti, bananas, coconut, clove, papaya, citrus and more. The lower level features an oversized living room, spacious kitchen with ample cabinetry and a gas stove, a formal dining area and 2 bedrooms, each with ensuite bathrooms and split ACs, plus an extra half bath. A large primary suite comprises the entire second level, with a large bathroom, double walk-in closets, and a loft sitting room that leads to a private outdoor deck with breathtaking mountain views. Imagine waking to the symphony of birdsong! Upgrades include a new roof, skylights and rain gutters, newly renovated deck, freshly painted exterior and new ceiling fans throughout. Convenient to the beaches and bays of Kaneohe and Kailua, with easy access to highways, Honolulu, the airport & O'ahu's military installations."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "8304.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3595"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1970"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(15) "Garden,Mountain"
}
["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(6) "CBPP04"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(19) "dianep@cbrealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 343-0659"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Diane C Pizarro"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19308098"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2026-06-03T00:05:44.340"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2026-03-30"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(12) "Preservation"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "00:05:44.340"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27345765"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27345765"
[1]=>
string(8) "27345766"
[2]=>
string(8) "27345767"
[3]=>
string(8) "27345768"
[4]=>
string(8) "27345769"
[5]=>
string(8) "27345770"
[6]=>
string(8) "27345771"
[7]=>
string(8) "27345772"
[8]=>
string(8) "27345773"
[9]=>
string(8) "27345774"
[10]=>
string(8) "27345775"
[11]=>
string(8) "27345776"
[12]=>
string(8) "27345777"
[13]=>
string(8) "27345778"
[14]=>
string(8) "27345779"
[15]=>
string(8) "27345780"
[16]=>
string(8) "27345781"
[17]=>
string(8) "27345782"
[18]=>
string(8) "27345783"
[19]=>
string(8) "27345784"
[20]=>
string(8) "27345785"
[21]=>
string(8) "27345786"
[22]=>
string(8) "27345787"
[23]=>
string(8) "27345788"
[24]=>
string(8) "27345789"
[25]=>
string(8) "27345790"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202605012
)
[StreetNumber] => Array
(
[0] => 47-594
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Hui Ulili
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://s3.amazonaws.com/video.creativeedge.tv/898472-4.mp4
)
[ListPrice] => Array
(
[0] => 1748000.00
)
[Neighbourhood] => Array
(
[0] => CLUB VIEW ESTATE
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Tucked away in this quiet neighborhood at the foot of the majestic Ko'olau Mountain range, this large custom 3-bedroom, 3.5 bath retreat gets a dramatic front-row view of Kaneohe's famous waterfalls that seem almost close enough to touch. Immerse yourself in nature in this private oasis that backs up to preservation land, surrounded by flowers and fruit trees – Puakenikeni, gardenia, orchids, ti, bananas, coconut, clove, papaya, citrus and more. The lower level features an oversized living room, spacious kitchen with ample cabinetry and a gas stove, a formal dining area and 2 bedrooms, each with ensuite bathrooms and split ACs, plus an extra half bath. A large primary suite comprises the entire second level, with a large bathroom, double walk-in closets, and a loft sitting room that leads to a private outdoor deck with breathtaking mountain views. Imagine waking to the symphony of birdsong! Upgrades include a new roof, skylights and rain gutters, newly renovated deck, freshly painted exterior and new ceiling fans throughout. Convenient to the beaches and bays of Kaneohe and Kailua, with easy access to highways, Honolulu, the airport & O'ahu's military installations.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 8304.00
)
[SqftTotal] => Array
(
[0] => 3595
)
[YearBuilt] => Array
(
[0] => 1970
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Garden,Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBPP04
)
[ListAgentEmail] => Array
(
[0] => dianep@cbrealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 343-0659
)
[ListAgentFullName] => Array
(
[0] => Diane C Pizarro
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19308098
)
[MatrixModifiedDT] => Array
(
[0] => 2026-06-03T00:05:44.340
)
[ListingContractDate] => Array
(
[0] => 2026-03-30
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Preservation
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 00:05:44.340
)
[_thumbnail_id] => Array
(
[0] => 27345765
)
[listing_image] => Array
(
[0] => 27345765
[1] => 27345766
[2] => 27345767
[3] => 27345768
[4] => 27345769
[5] => 27345770
[6] => 27345771
[7] => 27345772
[8] => 27345773
[9] => 27345774
[10] => 27345775
[11] => 27345776
[12] => 27345777
[13] => 27345778
[14] => 27345779
[15] => 27345780
[16] => 27345781
[17] => 27345782
[18] => 27345783
[19] => 27345784
[20] => 27345785
[21] => 27345786
[22] => 27345787
[23] => 27345788
[24] => 27345789
[25] => 27345790
)
)
- BedsTotal: 3
- Full Baths: 3
- Half Baths: 1
- Land Area (sf): 8,304 sf
- Living (sf): 3,595
- Year Built: 1970
- Property Condition: Above Average
- Number of Parking Spaces: 3
- View: Garden,Mountain
- Listing Office: Coldwell Banker Realty
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on June 3, 2026 - 12:05 AM
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.
© Marcus Realty. All Rights Reserved.
