61-809 Papailoa Road Haleiwa, HI 96712
Listing
Overview
Price: $5,200,000
Area: KAWAILOA-NORTH SHORE
Status: Active
Indulge in the ultimate beach front lifestyle and location. Located just about a mile from bustling Haleiwa Town but in a quiet, private feeling atmosphere. This rare gem is a street to beach property offering close to 20,000 square feet of land in a park like setting that comes with a main house plus a spacious cottage that sleeps 6 comfortably. Close to 130 linear feet of frontage!!! Breathtaking ocean, mountain and year round sunset views. Main house has vaulted ceilings, custom lighting, tons of natural light and sliders that open up to your large covered lanai facing the ocean. What truly sets this property apart though is its significant redevelopment potential. The zoning and lot size allows for significant expansion. Whether you are looking for a tranquil retreat or a lucrative investment opportunity this property on prestigious Papailoa Road is not to be missed. Listing by: Coldwell Banker Realty (808) 284-2459
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202424538"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "61-809"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Papailoa"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "5200000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "5200000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(20) "KAWAILOA-NORTH SHORE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(883) "Indulge in the ultimate beach front lifestyle and location. Located just about a mile from bustling Haleiwa Town but in a quiet, private feeling atmosphere. This rare gem is a street to beach property offering close to 20,000 square feet of land in a park like setting that comes with a main house plus a spacious cottage that sleeps 6 comfortably. Close to 130 linear feet of frontage!!! Breathtaking ocean, mountain and year round sunset views. Main house has vaulted ceilings, custom lighting, tons of natural light and sliders that open up to your large covered lanai facing the ocean. What truly sets this property apart though is its significant redevelopment potential. The zoning and lot size allows for significant expansion. Whether you are looking for a tranquil retreat or a lucrative investment opportunity this property on prestigious Papailoa Road is not to be missed."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "19857.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2888"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1959"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(38) "Coastline,Garden,Mountain,Ocean,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) "CBPP"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(19) "carlh@hawaii.rr.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 284-2459"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Carl J Higgins"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-07T09:03:36.710"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18343355"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-25T16:23:31.240"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(30) "Ocean,Sandy Beach,Stream/Canal"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26759083"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26759083"
[1]=>
string(8) "26759084"
[2]=>
string(8) "26759085"
[3]=>
string(8) "26759086"
[4]=>
string(8) "26759087"
[5]=>
string(8) "26759088"
[6]=>
string(8) "26759089"
[7]=>
string(8) "26759090"
[8]=>
string(8) "26759091"
[9]=>
string(8) "26759092"
[10]=>
string(8) "26759093"
[11]=>
string(8) "26759094"
[12]=>
string(8) "26759095"
[13]=>
string(8) "26759096"
[14]=>
string(8) "26759097"
[15]=>
string(8) "26759098"
[16]=>
string(8) "26759099"
[17]=>
string(8) "26759100"
[18]=>
string(8) "26759101"
[19]=>
string(8) "26759102"
[20]=>
string(8) "26759103"
[21]=>
string(8) "26759104"
[22]=>
string(8) "26759105"
[23]=>
string(8) "26759106"
[24]=>
string(8) "26759107"
[25]=>
string(8) "26759108"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202424538
)
[StreetNumber] => Array
(
[0] => 61-809
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Papailoa
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 5200000.00
)
[CurrentPrice] => Array
(
[0] => 5200000.00
)
[Neighbourhood] => Array
(
[0] => KAWAILOA-NORTH SHORE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Indulge in the ultimate beach front lifestyle and location. Located just about a mile from bustling Haleiwa Town but in a quiet, private feeling atmosphere. This rare gem is a street to beach property offering close to 20,000 square feet of land in a park like setting that comes with a main house plus a spacious cottage that sleeps 6 comfortably. Close to 130 linear feet of frontage!!! Breathtaking ocean, mountain and year round sunset views. Main house has vaulted ceilings, custom lighting, tons of natural light and sliders that open up to your large covered lanai facing the ocean. What truly sets this property apart though is its significant redevelopment potential. The zoning and lot size allows for significant expansion. Whether you are looking for a tranquil retreat or a lucrative investment opportunity this property on prestigious Papailoa Road is not to be missed.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 19857.00
)
[SqftTotal] => Array
(
[0] => 2888
)
[YearBuilt] => Array
(
[0] => 1959
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 6
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Coastline,Garden,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBPP
)
[ListAgentEmail] => Array
(
[0] => carlh@hawaii.rr.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 284-2459
)
[ListAgentFullName] => Array
(
[0] => Carl J Higgins
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-07T09:03:36.710
)
[Matrix_Unique_ID] => Array
(
[0] => 18343355
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-25T16:23:31.240
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach,Stream/Canal
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26759083
)
[listing_image] => Array
(
[0] => 26759083
[1] => 26759084
[2] => 26759085
[3] => 26759086
[4] => 26759087
[5] => 26759088
[6] => 26759089
[7] => 26759090
[8] => 26759091
[9] => 26759092
[10] => 26759093
[11] => 26759094
[12] => 26759095
[13] => 26759096
[14] => 26759097
[15] => 26759098
[16] => 26759099
[17] => 26759100
[18] => 26759101
[19] => 26759102
[20] => 26759103
[21] => 26759104
[22] => 26759105
[23] => 26759106
[24] => 26759107
[25] => 26759108
)
)
- BedsTotal: 1
- Full Baths: 3
- Land Area (sf): 19,857
- Living (sf): 2,888
- Year Built: 1959
- Property Condition: Above Average
- Number of Parking Spaces: 6
- View: Coastline,Garden,Mountain,Ocean,Sunset
- Listing Office: Coldwell Banker Realty
- Land Tenure: FS - Fee Simple
