68-265 Olao Place Waialua, HI 96791
Listing
Overview
Price: $3,800,000
Area: MOKULEIA
Status: Active
Discover unparalleled privacy and country elegance with this breathtaking Mokuleia estate. Encompassing two lush acres, the property is securely gated and surrounded by expansive, beautifully manicured grounds. Enjoy a diverse array of tropical fruit trees, including lychee, avocado, Hayden mangos, papaya, orange, grapefruit, tangerine, and coconut. Built in 2005, the custom home exudes craftsmanship, featuring an exquisite chef's kitchen, high-end stainless steel appliances, Brazilian Koa flooring, and seamless indoor-outdoor living spaces found throughout the residence. Relax on the spacious outdoor patio, unwind on the inviting lanais, or soak up the sun and gaze at the stars from the rooftop deck. This estate offers a serene North Shore retreat where every detail has been thoughtfully designed for comfort, beauty, and the quintessential country lifestyle. Also nearby you will find the character and charm of historic Haleiwa town which offers a wide array of restaurants, food trucks, boutique stores, and markets. These two-acre Mokuleia parcels are a rare offering, do not miss this incredible opportunity. Call your Realtor today to schedule a showing. Listing by: Locations LLC (808) 673-8681
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202418186"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "68-265"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(4) "Olao"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96791"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3800000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "3800000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "MOKULEIA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1172) "Discover unparalleled privacy and country elegance with this breathtaking Mokuleia estate. Encompassing two lush acres, the property is securely gated and surrounded by expansive, beautifully manicured grounds. Enjoy a diverse array of tropical fruit trees, including lychee, avocado, Hayden mangos, papaya, orange, grapefruit, tangerine, and coconut. Built in 2005, the custom home exudes craftsmanship, featuring an exquisite chef's kitchen, high-end stainless steel appliances, Brazilian Koa flooring, and seamless indoor-outdoor living spaces found throughout the residence. Relax on the spacious outdoor patio, unwind on the inviting lanais, or soak up the sun and gaze at the stars from the rooftop deck. This estate offers a serene North Shore retreat where every detail has been thoughtfully designed for comfort, beauty, and the quintessential country lifestyle. Also nearby you will find the character and charm of historic Haleiwa town which offers a wide array of restaurants, food trucks, boutique stores, and markets. These two-acre Mokuleia parcels are a rare offering, do not miss this incredible opportunity. Call your Realtor today to schedule a showing."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(13) "Locations LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "87599.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "5522"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2005"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "LOCA"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(33) "richard.linke@locationshawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 673-8681"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(19) "Richard O Linke Jr."
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-16T12:45:33.553"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18199640"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-08-19T11:07:09.673"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26664525"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26664525"
[1]=>
string(8) "26664526"
[2]=>
string(8) "26664527"
[3]=>
string(8) "26664528"
[4]=>
string(8) "26664529"
[5]=>
string(8) "26664530"
[6]=>
string(8) "26664531"
[7]=>
string(8) "26664532"
[8]=>
string(8) "26664533"
[9]=>
string(8) "26664534"
[10]=>
string(8) "26664535"
[11]=>
string(8) "26664536"
[12]=>
string(8) "26664537"
[13]=>
string(8) "26664538"
[14]=>
string(8) "26664539"
[15]=>
string(8) "26664540"
[16]=>
string(8) "26664541"
[17]=>
string(8) "26664542"
[18]=>
string(8) "26664543"
[19]=>
string(8) "26664544"
[20]=>
string(8) "26664545"
[21]=>
string(8) "26664546"
[22]=>
string(8) "26664547"
[23]=>
string(8) "26664548"
[24]=>
string(8) "26664549"
[25]=>
string(8) "26664550"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202418186
)
[StreetNumber] => Array
(
[0] => 68-265
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Olao
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 3800000.00
)
[CurrentPrice] => Array
(
[0] => 3800000.00
)
[Neighbourhood] => Array
(
[0] => MOKULEIA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Discover unparalleled privacy and country elegance with this breathtaking Mokuleia estate. Encompassing two lush acres, the property is securely gated and surrounded by expansive, beautifully manicured grounds. Enjoy a diverse array of tropical fruit trees, including lychee, avocado, Hayden mangos, papaya, orange, grapefruit, tangerine, and coconut. Built in 2005, the custom home exudes craftsmanship, featuring an exquisite chef's kitchen, high-end stainless steel appliances, Brazilian Koa flooring, and seamless indoor-outdoor living spaces found throughout the residence. Relax on the spacious outdoor patio, unwind on the inviting lanais, or soak up the sun and gaze at the stars from the rooftop deck. This estate offers a serene North Shore retreat where every detail has been thoughtfully designed for comfort, beauty, and the quintessential country lifestyle. Also nearby you will find the character and charm of historic Haleiwa town which offers a wide array of restaurants, food trucks, boutique stores, and markets. These two-acre Mokuleia parcels are a rare offering, do not miss this incredible opportunity. Call your Realtor today to schedule a showing.
)
[ListOfficeName] => Array
(
[0] => Locations LLC
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 87599.00
)
[SqftTotal] => Array
(
[0] => 5522
)
[YearBuilt] => Array
(
[0] => 2005
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialua
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => LOCA
)
[ListAgentEmail] => Array
(
[0] => richard.linke@locationshawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 673-8681
)
[ListAgentFullName] => Array
(
[0] => Richard O Linke Jr.
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-16T12:45:33.553
)
[Matrix_Unique_ID] => Array
(
[0] => 18199640
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-08-19T11:07:09.673
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26664525
)
[listing_image] => Array
(
[0] => 26664525
[1] => 26664526
[2] => 26664527
[3] => 26664528
[4] => 26664529
[5] => 26664530
[6] => 26664531
[7] => 26664532
[8] => 26664533
[9] => 26664534
[10] => 26664535
[11] => 26664536
[12] => 26664537
[13] => 26664538
[14] => 26664539
[15] => 26664540
[16] => 26664541
[17] => 26664542
[18] => 26664543
[19] => 26664544
[20] => 26664545
[21] => 26664546
[22] => 26664547
[23] => 26664548
[24] => 26664549
[25] => 26664550
)
)
- BedsTotal: 4
- Full Baths: 3
- Land Area (sf): 87,599
- Living (sf): 5,522
- Year Built: 2005
- Property Condition: Above Average
- Number of Parking Spaces: 4
- View: Mountain
- Listing Office: Locations LLC
- Land Tenure: FS - Fee Simple
- Elementary School: Waialua
- Middle School: Waialua
- High School: Waialua
