Listing
Overview
Price: $6,795,000
Area: KAWAILOA-NORTH SHORE
Status: Active
Indulge in the ultimate beachfront lifestyle with this charming oceanfront house in Haleiwa, Papailoa Road! This rare gem is situated on a prime piece of real estate with breathtaking ocean, mountain & sunset views and a stunning beach right at your doorstep. The existing house has vaulted ceilings, custom lighting, lots of natural light and opens up to a covered lanai perfect for outdoor dining and relaxation. However, what truly sets this property apart is it's significant redevelopment potential. With a generous lot size and zoning that allows for significant expansion this property offers endless possibilities to create your dream oceanfront estate or for now, to just to enjoy the main home plus cottage on a park-like setting. 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) 596-0456
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202217141"
}
["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(190) "https://urldefense.com/v3/__https://player.vimeo.com/video/757057661?h=b740311ad5__;!!CHCva4lQ!BLK3mhv42enOkjr5hnZv5aWH9oqy0BwRNIuEvAL2nGQiBlrGA2D6o3LgyBfClaNyRscdfotZo6VI8SFQpFD2o7vQAfZqhA$"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "6795000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "6795000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(20) "KAWAILOA-NORTH SHORE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(889) "Indulge in the ultimate beachfront lifestyle with this charming oceanfront house in Haleiwa, Papailoa Road! This rare gem is situated on a prime piece of real estate with breathtaking ocean, mountain & sunset views and a stunning beach right at your doorstep. The existing house has vaulted ceilings, custom lighting, lots of natural light and opens up to a covered lanai perfect for outdoor dining and relaxation. However, what truly sets this property apart is it's significant redevelopment potential. With a generous lot size and zoning that allows for significant expansion this property offers endless possibilities to create your dream oceanfront estate or for now, to just to enjoy the main home plus cottage on a park-like setting. 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(2) "10"
}
["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) 596-0456"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Carl J Higgins"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-09-29T13:17:42.483"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "16843609"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2022-09-23T16:12:41.127"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25831306"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "25831306"
[1]=>
string(8) "25831307"
[2]=>
string(8) "25831308"
[3]=>
string(8) "25831309"
[4]=>
string(8) "25831310"
[5]=>
string(8) "25831311"
[6]=>
string(8) "25831312"
[7]=>
string(8) "25831313"
[8]=>
string(8) "25831314"
[9]=>
string(8) "25831315"
[10]=>
string(8) "25831316"
[11]=>
string(8) "25831317"
[12]=>
string(8) "25831318"
[13]=>
string(8) "25831319"
[14]=>
string(8) "25831320"
[15]=>
string(8) "25831321"
[16]=>
string(8) "25831322"
[17]=>
string(8) "25831323"
[18]=>
string(8) "25831324"
[19]=>
string(8) "25831325"
[20]=>
string(8) "25831326"
[21]=>
string(8) "25831327"
[22]=>
string(8) "25831328"
[23]=>
string(8) "25831329"
[24]=>
string(8) "25831330"
[25]=>
string(8) "25831331"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(28) "Ocean,Sandy Beach,Waterfront"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202217141
)
[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] => https://urldefense.com/v3/__https://player.vimeo.com/video/757057661?h=b740311ad5__;!!CHCva4lQ!BLK3mhv42enOkjr5hnZv5aWH9oqy0BwRNIuEvAL2nGQiBlrGA2D6o3LgyBfClaNyRscdfotZo6VI8SFQpFD2o7vQAfZqhA$
)
[ListPrice] => Array
(
[0] => 6795000.00
)
[CurrentPrice] => Array
(
[0] => 6795000.00
)
[Neighbourhood] => Array
(
[0] => KAWAILOA-NORTH SHORE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Indulge in the ultimate beachfront lifestyle with this charming oceanfront house in Haleiwa, Papailoa Road! This rare gem is situated on a prime piece of real estate with breathtaking ocean, mountain & sunset views and a stunning beach right at your doorstep. The existing house has vaulted ceilings, custom lighting, lots of natural light and opens up to a covered lanai perfect for outdoor dining and relaxation. However, what truly sets this property apart is it's significant redevelopment potential. With a generous lot size and zoning that allows for significant expansion this property offers endless possibilities to create your dream oceanfront estate or for now, to just to enjoy the main home plus cottage on a park-like setting. 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] => 10
)
[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) 596-0456
)
[ListAgentFullName] => Array
(
[0] => Carl J Higgins
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-09-29T13:17:42.483
)
[Matrix_Unique_ID] => Array
(
[0] => 16843609
)
[OriginalEntryTimestamp] => Array
(
[0] => 2022-09-23T16:12:41.127
)
[_thumbnail_id] => Array
(
[0] => 25831306
)
[listing_image] => Array
(
[0] => 25831306
[1] => 25831307
[2] => 25831308
[3] => 25831309
[4] => 25831310
[5] => 25831311
[6] => 25831312
[7] => 25831313
[8] => 25831314
[9] => 25831315
[10] => 25831316
[11] => 25831317
[12] => 25831318
[13] => 25831319
[14] => 25831320
[15] => 25831321
[16] => 25831322
[17] => 25831323
[18] => 25831324
[19] => 25831325
[20] => 25831326
[21] => 25831327
[22] => 25831328
[23] => 25831329
[24] => 25831330
[25] => 25831331
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach,Waterfront
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- 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: 10
- View: Coastline,Garden,Mountain,Ocean,Sunset
- Listing Office: Coldwell Banker Realty
- Land Tenure: FS - Fee Simple