Listing
Overview
Price: $3,400,000
Area: PUPUKEA
Status: Active
In the sought-after neighborhood of Pupukea, this property spans one level acre in a premier location and offers a peaceful retreat surrounded by mature fruit trees, including mango, banana, lychee, avocado, and several citrus varieties. The main residence boasts 4 bedrooms and 3 baths, blending modern comfort with the natural beauty of its surroundings. With vaulted ceilings and large windows, the open floor plan creates a spacious and airy ambiance. The gourmet kitchen is a culinary delight, featuring modern appliances and ample counter space. Attached to the 2 car garage, a 900-square-foot permitted recreation room awaits. The rec room is complete with a kitchenette and full bath, perfect for a large home office, writer/artist studio, or enjoying quiet relaxation. Outside, you will find a spacious covered lanai with beautifully installed Ipe decking, a perfect place for a dinner party or morning coffee. This property offers a rare opportunity to embrace the North Shore lifestyle while enjoying the comforts of modern luxury. With its versatile living spaces, abundant fruit trees, and serene surroundings, this residence is perfect for those seeking the ideal Hawaiian retreat. Listing by: BHGRE Advantage Realty N Shore (808) 741-3835
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202407734"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "59-791"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Alapio"
}
["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(59) "https://listings.hetproductions.com/sites/djpgxwe/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3400000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "3400000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "PUPUKEA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1195) "In the sought-after neighborhood of Pupukea, this property spans one level acre in a premier location and offers a peaceful retreat surrounded by mature fruit trees, including mango, banana, lychee, avocado, and several citrus varieties. The main residence boasts 4 bedrooms and 3 baths, blending modern comfort with the natural beauty of its surroundings. With vaulted ceilings and large windows, the open floor plan creates a spacious and airy ambiance. The gourmet kitchen is a culinary delight, featuring modern appliances and ample counter space. Attached to the 2 car garage, a 900-square-foot permitted recreation room awaits. The rec room is complete with a kitchenette and full bath, perfect for a large home office, writer/artist studio, or enjoying quiet relaxation. Outside, you will find a spacious covered lanai with beautifully installed Ipe decking, a perfect place for a dinner party or morning coffee. This property offers a rare opportunity to embrace the North Shore lifestyle while enjoying the comforts of modern luxury. With its versatile living spaces, abundant fruit trees, and serene surroundings, this residence is perfect for those seeking the ideal Hawaiian retreat."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(30) "BHGRE Advantage Realty N Shore"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "43560.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3237"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1993"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(15) "Garden,Mountain"
}
["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) "ADNS"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "MemeM@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 741-3835"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(10) "Meme Moody"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-08-04T17:00:01.797"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17924906"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-04-16T13:31:21.377"
}
["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) "26167828"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26167828"
[1]=>
string(8) "26167829"
[2]=>
string(8) "26167830"
[3]=>
string(8) "26167831"
[4]=>
string(8) "26167832"
[5]=>
string(8) "26167833"
[6]=>
string(8) "26167834"
[7]=>
string(8) "26167835"
[8]=>
string(8) "26167836"
[9]=>
string(8) "26167837"
[10]=>
string(8) "26167838"
[11]=>
string(8) "26167839"
[12]=>
string(8) "26167840"
[13]=>
string(8) "26167841"
[14]=>
string(8) "26167842"
[15]=>
string(8) "26167843"
[16]=>
string(8) "26167844"
[17]=>
string(8) "26167845"
[18]=>
string(8) "26167846"
[19]=>
string(8) "26167847"
[20]=>
string(8) "26167848"
[21]=>
string(8) "26167849"
[22]=>
string(8) "26167850"
[23]=>
string(8) "26167851"
[24]=>
string(8) "26167852"
[25]=>
string(8) "26167853"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202407734
)
[StreetNumber] => Array
(
[0] => 59-791
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Alapio
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/djpgxwe/unbranded
)
[ListPrice] => Array
(
[0] => 3400000.00
)
[CurrentPrice] => Array
(
[0] => 3400000.00
)
[Neighbourhood] => Array
(
[0] => PUPUKEA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => In the sought-after neighborhood of Pupukea, this property spans one level acre in a premier location and offers a peaceful retreat surrounded by mature fruit trees, including mango, banana, lychee, avocado, and several citrus varieties. The main residence boasts 4 bedrooms and 3 baths, blending modern comfort with the natural beauty of its surroundings. With vaulted ceilings and large windows, the open floor plan creates a spacious and airy ambiance. The gourmet kitchen is a culinary delight, featuring modern appliances and ample counter space. Attached to the 2 car garage, a 900-square-foot permitted recreation room awaits. The rec room is complete with a kitchenette and full bath, perfect for a large home office, writer/artist studio, or enjoying quiet relaxation. Outside, you will find a spacious covered lanai with beautifully installed Ipe decking, a perfect place for a dinner party or morning coffee. This property offers a rare opportunity to embrace the North Shore lifestyle while enjoying the comforts of modern luxury. With its versatile living spaces, abundant fruit trees, and serene surroundings, this residence is perfect for those seeking the ideal Hawaiian retreat.
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty N Shore
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 43560.00
)
[SqftTotal] => Array
(
[0] => 3237
)
[YearBuilt] => Array
(
[0] => 1993
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 6
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Garden,Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ADNS
)
[ListAgentEmail] => Array
(
[0] => MemeM@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 741-3835
)
[ListAgentFullName] => Array
(
[0] => Meme Moody
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-04T17:00:01.797
)
[Matrix_Unique_ID] => Array
(
[0] => 17924906
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-04-16T13:31:21.377
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26167828
)
[listing_image] => Array
(
[0] => 26167828
[1] => 26167829
[2] => 26167830
[3] => 26167831
[4] => 26167832
[5] => 26167833
[6] => 26167834
[7] => 26167835
[8] => 26167836
[9] => 26167837
[10] => 26167838
[11] => 26167839
[12] => 26167840
[13] => 26167841
[14] => 26167842
[15] => 26167843
[16] => 26167844
[17] => 26167845
[18] => 26167846
[19] => 26167847
[20] => 26167848
[21] => 26167849
[22] => 26167850
[23] => 26167851
[24] => 26167852
[25] => 26167853
)
)
- BedsTotal: 4
- Full Baths: 4
- Land Area (sf): 43,560
- Living (sf): 3,237
- Year Built: 1993
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 6
- View: Garden,Mountain
- Listing Office: BHGRE Advantage Realty N Shore
- Land Tenure: FS - Fee Simple
