718 Puuikena Drive Honolulu, HI 96821
Listing
Overview
Price: $5,750,000
Area: HAWAII LOA RIDGE
Status: Active
Welcome to your private estate in prestigious Hawaii Loa Ridge, a sanctuary of luxury and tranquility with breathtaking views of Diamond Head, the Pacific Ocean, and East Honolulu. Designed by award-winning local architect Jim Schmit, this exceptional residence blends South-East Asian influences with modern elegance, offering a seamless indoor-outdoor living experience. The open floor plan features soaring ceilings and a grand living area, complemented by exquisite teak floors and a gourmet kitchen with gas Viking range that will delight culinary enthusiasts. This spacious property includes separate living quarters for ultimate privacy, a luxurious primary wing, kids’ play area, and versatile office space. The 27,830-sq ft lot is an outdoor sanctuary, featuring a separate pool and pavilion area with an infinity pool, reflecting ponds, and elegant statues that adorn the grounds. Don't miss this rare opportunity to make this exceptional property your own private retreat. Listing by: Caron B Realty (808) 286-5256
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202417771"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "718"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Puuikena"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Drive"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96821"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "5750000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "5750000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(16) "HAWAII LOA RIDGE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(985) "Welcome to your private estate in prestigious Hawaii Loa Ridge, a sanctuary of luxury and tranquility with breathtaking views of Diamond Head, the Pacific Ocean, and East Honolulu. Designed by award-winning local architect Jim Schmit, this exceptional residence blends South-East Asian influences with modern elegance, offering a seamless indoor-outdoor living experience. The open floor plan features soaring ceilings and a grand living area, complemented by exquisite teak floors and a gourmet kitchen with gas Viking range that will delight culinary enthusiasts. This spacious property includes separate living quarters for ultimate privacy, a luxurious primary wing, kids’ play area, and versatile office space. The 27,830-sq ft lot is an outdoor sanctuary, featuring a separate pool and pavilion area with an infinity pool, reflecting ponds, and elegant statues that adorn the grounds. Don't miss this rare opportunity to make this exceptional property your own private retreat."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(14) "Caron B Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "7"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "6"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "4"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "27830.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "8154"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2004"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(35) "Coastline,Diamond Head,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(10) "Aina Haina"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(10) "Niu Valley"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kalani"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "CARB"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(16) "caron@caronb.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 286-5256"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Caron B Davis"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-10T11:24:00.567"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18186822"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-08-12T17:20:23.323"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26656904"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26656904"
[1]=>
string(8) "26656905"
[2]=>
string(8) "26656906"
[3]=>
string(8) "26656907"
[4]=>
string(8) "26656908"
[5]=>
string(8) "26656909"
[6]=>
string(8) "26656910"
[7]=>
string(8) "26656911"
[8]=>
string(8) "26656912"
[9]=>
string(8) "26656913"
[10]=>
string(8) "26656914"
[11]=>
string(8) "26656915"
[12]=>
string(8) "26656916"
[13]=>
string(8) "26656917"
[14]=>
string(8) "26656918"
[15]=>
string(8) "26656919"
[16]=>
string(8) "26656920"
[17]=>
string(8) "26656921"
[18]=>
string(8) "26656922"
[19]=>
string(8) "26656923"
[20]=>
string(8) "26656924"
[21]=>
string(8) "26656925"
[22]=>
string(8) "26656926"
[23]=>
string(8) "26656927"
[24]=>
string(8) "26656928"
[25]=>
string(8) "26656929"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202417771
)
[StreetNumber] => Array
(
[0] => 718
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Puuikena
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96821
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 5750000.00
)
[CurrentPrice] => Array
(
[0] => 5750000.00
)
[Neighbourhood] => Array
(
[0] => HAWAII LOA RIDGE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to your private estate in prestigious Hawaii Loa Ridge, a sanctuary of luxury and tranquility with breathtaking views of Diamond Head, the Pacific Ocean, and East Honolulu. Designed by award-winning local architect Jim Schmit, this exceptional residence blends South-East Asian influences with modern elegance, offering a seamless indoor-outdoor living experience. The open floor plan features soaring ceilings and a grand living area, complemented by exquisite teak floors and a gourmet kitchen with gas Viking range that will delight culinary enthusiasts. This spacious property includes separate living quarters for ultimate privacy, a luxurious primary wing, kids’ play area, and versatile office space. The 27,830-sq ft lot is an outdoor sanctuary, featuring a separate pool and pavilion area with an infinity pool, reflecting ponds, and elegant statues that adorn the grounds. Don't miss this rare opportunity to make this exceptional property your own private retreat.
)
[ListOfficeName] => Array
(
[0] => Caron B Realty
)
[BedsTotal] => Array
(
[0] => 7
)
[BathsFull] => Array
(
[0] => 6
)
[BathsHalf] => Array
(
[0] => 4
)
[LotSizeArea] => Array
(
[0] => 27830.00
)
[SqftTotal] => Array
(
[0] => 8154
)
[YearBuilt] => Array
(
[0] => 2004
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 6
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Coastline,Diamond Head,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Aina Haina
)
[MiddleOrJuniorSchool] => Array
(
[0] => Niu Valley
)
[HighSchool] => Array
(
[0] => Kalani
)
[ListOfficeMLSID] => Array
(
[0] => CARB
)
[ListAgentEmail] => Array
(
[0] => caron@caronb.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 286-5256
)
[ListAgentFullName] => Array
(
[0] => Caron B Davis
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-10T11:24:00.567
)
[Matrix_Unique_ID] => Array
(
[0] => 18186822
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-08-12T17:20:23.323
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26656904
)
[listing_image] => Array
(
[0] => 26656904
[1] => 26656905
[2] => 26656906
[3] => 26656907
[4] => 26656908
[5] => 26656909
[6] => 26656910
[7] => 26656911
[8] => 26656912
[9] => 26656913
[10] => 26656914
[11] => 26656915
[12] => 26656916
[13] => 26656917
[14] => 26656918
[15] => 26656919
[16] => 26656920
[17] => 26656921
[18] => 26656922
[19] => 26656923
[20] => 26656924
[21] => 26656925
[22] => 26656926
[23] => 26656927
[24] => 26656928
[25] => 26656929
)
)
- BedsTotal: 7
- Full Baths: 6
- Half Baths: 4
- Land Area (sf): 27,830
- Living (sf): 8,154
- Year Built: 2004
- Property Condition: Average
- Number of Parking Spaces: 6
- View: Coastline,Diamond Head,Ocean,Sunset
- Listing Office: Caron B Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Aina Haina
- Middle School: Niu Valley
- High School: Kalani
