Listing
Overview
Price: $5,650,000
Area: HAWAII LOA RIDGE
Status: Active
Exquisite Private Estate in a gated community. An incredible value, original construction cost of over 12 million dollars. Turn key convenience, with breath taking views of the Ocean, Diamond Head Crater, and more. "One or more photos has been enhanced." Listing by: Compass (808) 228-5683
array(42) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202212093"
}
["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(49) "http://www.slickpixelshawaii.com/718puuikenadrive"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "5650000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "5650000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(16) "HAWAII LOA RIDGE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(254) "Exquisite Private Estate in a gated community. An incredible value, original construction cost of over 12 million dollars. Turn key convenience, with breath taking views of the Ocean, Diamond Head Crater, and more. "One or more photos has been enhanced.""
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "7"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "8"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["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(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "7"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(47) "City,Diamond Head,Mountain,Ocean,Sunrise,Sunset"
}
["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) "COHI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(17) "wweldridge@me.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 228-5683"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Wana'ao W Eldridge"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-06-25T12:27:25.377"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "16722832"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2022-06-23T16:02:41.347"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25830652"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "25830652"
[1]=>
string(8) "25830653"
[2]=>
string(8) "25830654"
[3]=>
string(8) "25830655"
[4]=>
string(8) "25830656"
[5]=>
string(8) "25830657"
[6]=>
string(8) "25830658"
[7]=>
string(8) "25830659"
[8]=>
string(8) "25830660"
[9]=>
string(8) "25830661"
[10]=>
string(8) "25830662"
[11]=>
string(8) "25830663"
[12]=>
string(8) "25830664"
[13]=>
string(8) "25830665"
[14]=>
string(8) "25830666"
[15]=>
string(8) "25830667"
[16]=>
string(8) "25830668"
[17]=>
string(8) "25830669"
[18]=>
string(8) "25830670"
[19]=>
string(8) "25830671"
[20]=>
string(8) "25830672"
[21]=>
string(8) "25830673"
[22]=>
string(8) "25830674"
[23]=>
string(8) "25830675"
[24]=>
string(8) "25830676"
[25]=>
string(8) "25830677"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202212093
)
[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] => http://www.slickpixelshawaii.com/718puuikenadrive
)
[ListPrice] => Array
(
[0] => 5650000.00
)
[CurrentPrice] => Array
(
[0] => 5650000.00
)
[Neighbourhood] => Array
(
[0] => HAWAII LOA RIDGE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Exquisite Private Estate in a gated community. An incredible value, original construction cost of over 12 million dollars. Turn key convenience, with breath taking views of the Ocean, Diamond Head Crater, and more. "One or more photos has been enhanced."
)
[ListOfficeName] => Array
(
[0] => Compass
)
[BedsTotal] => Array
(
[0] => 7
)
[BathsFull] => Array
(
[0] => 8
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 27830.00
)
[SqftTotal] => Array
(
[0] => 8154
)
[YearBuilt] => Array
(
[0] => 2004
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 7
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => City,Diamond Head,Mountain,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => COHI
)
[ListAgentEmail] => Array
(
[0] => wweldridge@me.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 228-5683
)
[ListAgentFullName] => Array
(
[0] => Wana'ao W Eldridge
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-06-25T12:27:25.377
)
[Matrix_Unique_ID] => Array
(
[0] => 16722832
)
[OriginalEntryTimestamp] => Array
(
[0] => 2022-06-23T16:02:41.347
)
[_thumbnail_id] => Array
(
[0] => 25830652
)
[listing_image] => Array
(
[0] => 25830652
[1] => 25830653
[2] => 25830654
[3] => 25830655
[4] => 25830656
[5] => 25830657
[6] => 25830658
[7] => 25830659
[8] => 25830660
[9] => 25830661
[10] => 25830662
[11] => 25830663
[12] => 25830664
[13] => 25830665
[14] => 25830666
[15] => 25830667
[16] => 25830668
[17] => 25830669
[18] => 25830670
[19] => 25830671
[20] => 25830672
[21] => 25830673
[22] => 25830674
[23] => 25830675
[24] => 25830676
[25] => 25830677
)
)
- BedsTotal: 7
- Full Baths: 8
- Land Area (sf): 27,830
- Living (sf): 8,154
- Year Built: 2004
- Property Condition: Excellent
- Number of Parking Spaces: 7
- View: City,Diamond Head,Mountain,Ocean,Sunrise,Sunset
- Listing Office: Compass
- Land Tenure: FS - Fee Simple
