Listing
Overview
Price: $4,300,000
Area: WAIKANE
Status: Active
Welcome to your private retreat! This gated, 2.25-acre estate neighbors Kualoa Ranch and is just minutes from Kualoa Beach Park. This property invites you in with a lush, palm-lined driveway leading to an elegantly updated 4-bedroom, 3.5-bath Main House with Ohana Quarters featuring Separate Entrance, and Bonus Workshop with Full Bath! Gorgeously updated, the home optimizes indoor/outdoor living with large gathering spaces, including an expansive great room with a fireplace that flows seamlessly into a generous wrap-around lanai that spans Over 4,000 sqft! Here, you'll find a pond, waterfall, pergola, and garden, creating the perfect spot to enjoy sunrise and moonrise views over the ocean and Mokoli'i Island (Chinaman’s Hat). Inside, the home showcases a newly redesigned interior with a blend of modern and bespoke materials, woven wallcoverings, beautiful natural stone, mosaic tile details, brass accents, and premium fixtures. Upgraded appliances and 52 owned photovoltaic panels offer both comfort and sustainability. Zoned AG-2, this secluded estate also provides ample space and potential for a small farm or agricultural endeavor making it an ideal getaway. Listing by: RE/MAX ALOHA HOMES (808) 773-9390
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202426576"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "48-500"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Kamehameha"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(7) "Highway"
}
["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(131) "https://player.vimeo.com/video/1031226926?byline=0&title=0&owner=0&name=0&logos=0&profile=0&profilepicture=0&vimeologo=0&portrait=0"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "4300000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "4300000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKANE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1177) "Welcome to your private retreat! This gated, 2.25-acre estate neighbors Kualoa Ranch and is just minutes from Kualoa Beach Park. This property invites you in with a lush, palm-lined driveway leading to an elegantly updated 4-bedroom, 3.5-bath Main House with Ohana Quarters featuring Separate Entrance, and Bonus Workshop with Full Bath! Gorgeously updated, the home optimizes indoor/outdoor living with large gathering spaces, including an expansive great room with a fireplace that flows seamlessly into a generous wrap-around lanai that spans Over 4,000 sqft! Here, you'll find a pond, waterfall, pergola, and garden, creating the perfect spot to enjoy sunrise and moonrise views over the ocean and Mokoli'i Island (Chinaman’s Hat). Inside, the home showcases a newly redesigned interior with a blend of modern and bespoke materials, woven wallcoverings, beautiful natural stone, mosaic tile details, brass accents, and premium fixtures. Upgraded appliances and 52 owned photovoltaic panels offer both comfort and sustainability. Zoned AG-2, this secluded estate also provides ample space and potential for a small farm or agricultural endeavor making it an ideal getaway."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(18) "RE/MAX ALOHA HOMES"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "98271.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "7708"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1988"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "8"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(28) "Mountain,Ocean,Other,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) "RMXA"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(30) "stephanie@hawaiidreamhomes.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 773-9390"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Stephanie Rae Band"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-22T16:40:38.283"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18381630"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-11-18T16:00:31.170"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26775208"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26775208"
[1]=>
string(8) "26775209"
[2]=>
string(8) "26775210"
[3]=>
string(8) "26775211"
[4]=>
string(8) "26775212"
[5]=>
string(8) "26775213"
[6]=>
string(8) "26775214"
[7]=>
string(8) "26775215"
[8]=>
string(8) "26775216"
[9]=>
string(8) "26775217"
[10]=>
string(8) "26775218"
[11]=>
string(8) "26775219"
[12]=>
string(8) "26775220"
[13]=>
string(8) "26775221"
[14]=>
string(8) "26775222"
[15]=>
string(8) "26775223"
[16]=>
string(8) "26775224"
[17]=>
string(8) "26775225"
[18]=>
string(8) "26775226"
[19]=>
string(8) "26775227"
[20]=>
string(8) "26775228"
[21]=>
string(8) "26775229"
[22]=>
string(8) "26775230"
[23]=>
string(8) "26775231"
[24]=>
string(8) "26775232"
[25]=>
string(8) "26775233"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202426576
)
[StreetNumber] => Array
(
[0] => 48-500
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kamehameha
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/1031226926?byline=0&title=0&owner=0&name=0&logos=0&profile=0&profilepicture=0&vimeologo=0&portrait=0
)
[ListPrice] => Array
(
[0] => 4300000.00
)
[CurrentPrice] => Array
(
[0] => 4300000.00
)
[Neighbourhood] => Array
(
[0] => WAIKANE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to your private retreat! This gated, 2.25-acre estate neighbors Kualoa Ranch and is just minutes from Kualoa Beach Park. This property invites you in with a lush, palm-lined driveway leading to an elegantly updated 4-bedroom, 3.5-bath Main House with Ohana Quarters featuring Separate Entrance, and Bonus Workshop with Full Bath! Gorgeously updated, the home optimizes indoor/outdoor living with large gathering spaces, including an expansive great room with a fireplace that flows seamlessly into a generous wrap-around lanai that spans Over 4,000 sqft! Here, you'll find a pond, waterfall, pergola, and garden, creating the perfect spot to enjoy sunrise and moonrise views over the ocean and Mokoli'i Island (Chinaman’s Hat). Inside, the home showcases a newly redesigned interior with a blend of modern and bespoke materials, woven wallcoverings, beautiful natural stone, mosaic tile details, brass accents, and premium fixtures. Upgraded appliances and 52 owned photovoltaic panels offer both comfort and sustainability. Zoned AG-2, this secluded estate also provides ample space and potential for a small farm or agricultural endeavor making it an ideal getaway.
)
[ListOfficeName] => Array
(
[0] => RE/MAX ALOHA HOMES
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 98271.00
)
[SqftTotal] => Array
(
[0] => 7708
)
[YearBuilt] => Array
(
[0] => 1988
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 8
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain,Ocean,Other,Sunrise
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => RMXA
)
[ListAgentEmail] => Array
(
[0] => stephanie@hawaiidreamhomes.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 773-9390
)
[ListAgentFullName] => Array
(
[0] => Stephanie Rae Band
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-22T16:40:38.283
)
[Matrix_Unique_ID] => Array
(
[0] => 18381630
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-11-18T16:00:31.170
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26775208
)
[listing_image] => Array
(
[0] => 26775208
[1] => 26775209
[2] => 26775210
[3] => 26775211
[4] => 26775212
[5] => 26775213
[6] => 26775214
[7] => 26775215
[8] => 26775216
[9] => 26775217
[10] => 26775218
[11] => 26775219
[12] => 26775220
[13] => 26775221
[14] => 26775222
[15] => 26775223
[16] => 26775224
[17] => 26775225
[18] => 26775226
[19] => 26775227
[20] => 26775228
[21] => 26775229
[22] => 26775230
[23] => 26775231
[24] => 26775232
[25] => 26775233
)
)
- BedsTotal: 4
- Full Baths: 3
- Half Baths: 1
- Land Area (sf): 98,271
- Living (sf): 7,708
- Year Built: 1988
- Property Condition: Excellent
- Number of Parking Spaces: 8
- View: Mountain,Ocean,Other,Sunrise
- Listing Office: RE/MAX ALOHA HOMES
- Land Tenure: FS - Fee Simple
