Listing
Overview
Price: $2,875,000
Area: PUPUKEA
Status: Active Under Contract
Available for purchase with a 4.25% VA assumable loan! Experience luxury living in this meticulously crafted Pupukea estate, curated by a local designer with a recent full-scale renovation. The home is fully furnished and decorated, all included in the sale for immediate enjoyment. A grand entrance welcomes you, with a brand-new driveway leading to an automated aluminum gate. The fully fenced yard encompasses two residences, adorned with top-tier redwood fencing for privacy. The main house features 3 bedrooms, 2 bathrooms, a custom kitchen, and a primary bathroom with a skylight rain head and freestanding tub beneath an exquisite chandelier. A detached guest house offers a tranquil retreat with its own deck and kitchen. The backyard oasis boasts over 100 feet of towering areca palms, ideal for hosting gatherings. Meticulously landscaped grounds include over 30 fruit trees, 57 Italian cypress trees, and 3 Puakenikeni trees, enhancing the property's serene ambiance. Additionally, 24 owned solar panels with Net Metering through Hawaiian Electric. See link for virtual tour. Note: Tax records differ from actual square footage. Yard photos have been lightly enhanced. Listing by: Coldwell Banker Realty (808) 738-3904
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202417229"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "59-405"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Pupukea"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Haleiwa"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96712"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(53) "https://player.vimeo.com/video/928926513?h=55368c0192"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2875000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "2875000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "PUPUKEA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1179) "Available for purchase with a 4.25% VA assumable loan! Experience luxury living in this meticulously crafted Pupukea estate, curated by a local designer with a recent full-scale renovation. The home is fully furnished and decorated, all included in the sale for immediate enjoyment. A grand entrance welcomes you, with a brand-new driveway leading to an automated aluminum gate. The fully fenced yard encompasses two residences, adorned with top-tier redwood fencing for privacy. The main house features 3 bedrooms, 2 bathrooms, a custom kitchen, and a primary bathroom with a skylight rain head and freestanding tub beneath an exquisite chandelier. A detached guest house offers a tranquil retreat with its own deck and kitchen. The backyard oasis boasts over 100 feet of towering areca palms, ideal for hosting gatherings. Meticulously landscaped grounds include over 30 fruit trees, 57 Italian cypress trees, and 3 Puakenikeni trees, enhancing the property's serene ambiance. Additionally, 24 owned solar panels with Net Metering through Hawaiian Electric. See link for virtual tour. Note: Tax records differ from actual square footage. Yard photos have been lightly enhanced."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["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) "47219.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3162"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1978"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(21) "Garden,Mountain,Other"
}
["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) "CBPP02"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(26) "james.jenkins@cbrealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3904"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "James Jenkins"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-09T13:24:42.447"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18161586"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-08-01T08:38:59.700"
}
["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) "26644136"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26644136"
[1]=>
string(8) "26644137"
[2]=>
string(8) "26644138"
[3]=>
string(8) "26644139"
[4]=>
string(8) "26644140"
[5]=>
string(8) "26644141"
[6]=>
string(8) "26644142"
[7]=>
string(8) "26644143"
[8]=>
string(8) "26644144"
[9]=>
string(8) "26644145"
[10]=>
string(8) "26644146"
[11]=>
string(8) "26644147"
[12]=>
string(8) "26644148"
[13]=>
string(8) "26644149"
[14]=>
string(8) "26644150"
[15]=>
string(8) "26644151"
[16]=>
string(8) "26644152"
[17]=>
string(8) "26644153"
[18]=>
string(8) "26644154"
[19]=>
string(8) "26644155"
[20]=>
string(8) "26644156"
[21]=>
string(8) "26644157"
[22]=>
string(8) "26644158"
[23]=>
string(8) "26644159"
[24]=>
string(8) "26644160"
[25]=>
string(8) "26644161"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202417229
)
[StreetNumber] => Array
(
[0] => 59-405
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Pupukea
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/928926513?h=55368c0192
)
[ListPrice] => Array
(
[0] => 2875000.00
)
[CurrentPrice] => Array
(
[0] => 2875000.00
)
[Neighbourhood] => Array
(
[0] => PUPUKEA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Available for purchase with a 4.25% VA assumable loan! Experience luxury living in this meticulously crafted Pupukea estate, curated by a local designer with a recent full-scale renovation. The home is fully furnished and decorated, all included in the sale for immediate enjoyment. A grand entrance welcomes you, with a brand-new driveway leading to an automated aluminum gate. The fully fenced yard encompasses two residences, adorned with top-tier redwood fencing for privacy. The main house features 3 bedrooms, 2 bathrooms, a custom kitchen, and a primary bathroom with a skylight rain head and freestanding tub beneath an exquisite chandelier. A detached guest house offers a tranquil retreat with its own deck and kitchen. The backyard oasis boasts over 100 feet of towering areca palms, ideal for hosting gatherings. Meticulously landscaped grounds include over 30 fruit trees, 57 Italian cypress trees, and 3 Puakenikeni trees, enhancing the property's serene ambiance. Additionally, 24 owned solar panels with Net Metering through Hawaiian Electric. See link for virtual tour. Note: Tax records differ from actual square footage. Yard photos have been lightly enhanced.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 47219.00
)
[SqftTotal] => Array
(
[0] => 3162
)
[YearBuilt] => Array
(
[0] => 1978
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Garden,Mountain,Other
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBPP02
)
[ListAgentEmail] => Array
(
[0] => james.jenkins@cbrealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 738-3904
)
[ListAgentFullName] => Array
(
[0] => James Jenkins
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-09T13:24:42.447
)
[Matrix_Unique_ID] => Array
(
[0] => 18161586
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-08-01T08:38:59.700
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26644136
)
[listing_image] => Array
(
[0] => 26644136
[1] => 26644137
[2] => 26644138
[3] => 26644139
[4] => 26644140
[5] => 26644141
[6] => 26644142
[7] => 26644143
[8] => 26644144
[9] => 26644145
[10] => 26644146
[11] => 26644147
[12] => 26644148
[13] => 26644149
[14] => 26644150
[15] => 26644151
[16] => 26644152
[17] => 26644153
[18] => 26644154
[19] => 26644155
[20] => 26644156
[21] => 26644157
[22] => 26644158
[23] => 26644159
[24] => 26644160
[25] => 26644161
)
)
- BedsTotal: 4
- Full Baths: 3
- Land Area (sf): 47,219
- Living (sf): 3,162
- Year Built: 1978
- Property Condition: Excellent
- Number of Parking Spaces: 3
- View: Garden,Mountain,Other
- Listing Office: Coldwell Banker Realty
- Land Tenure: FS - Fee Simple
