Listing
Overview
Price: $1,998,000
Area: MOKULEIA
Status: Active
Would you like to own a serene and most charming oceanfront property on Oahu's North Shore? Come and view this 3bed/2bath gem with many upgrades inside and out, well-maintained and move-in ready in Mokuleia. Rare opportunity to enjoy the tranquility of the North Shore. You'll be mesmerized by the waves as the clouds drift on the horizon. Expansive unobstructed views of the beautiful ocean. New vinyl plank flooring, granite counter tops, sleek ceiling fans, freshly painted inside and out, fully fenced and gated with 68 linear feet of direct ocean front, this lovely home awaits your enjoyment of pleasure and privacy. Please see Virtual Tour! Listing by: Coldwell Banker Realty (808) 738-3904
array(42) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202221305"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "68-701"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Farrington"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(7) "Highway"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96791"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(83) "https://www.pineapplelabs.io/virtualtour/e4f07892-8366-41d7-b99c-598d01c83c27/video"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1998000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1998000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "MOKULEIA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(653) "Would you like to own a serene and most charming oceanfront property on Oahu's North Shore? Come and view this 3bed/2bath gem with many upgrades inside and out, well-maintained and move-in ready in Mokuleia. Rare opportunity to enjoy the tranquility of the North Shore. You'll be mesmerized by the waves as the clouds drift on the horizon. Expansive unobstructed views of the beautiful ocean. New vinyl plank flooring, granite counter tops, sleek ceiling fans, freshly painted inside and out, fully fenced and gated with 68 linear feet of direct ocean front, this lovely home awaits your enjoyment of pleasure and privacy. Please see Virtual Tour!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "8762.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1440"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1973"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(31) "Coastline,Mountain,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(6) "CBPP02"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(25) "Ida.Elliott@cbpacific.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3904"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Ida Elliott"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-04-02T07:33:49.627"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "16939236"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2022-10-20T11:05:17.300"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25832962"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "25832962"
[1]=>
string(8) "25832963"
[2]=>
string(8) "25832964"
[3]=>
string(8) "25832965"
[4]=>
string(8) "25832966"
[5]=>
string(8) "25832967"
[6]=>
string(8) "25832968"
[7]=>
string(8) "25832969"
[8]=>
string(8) "25832970"
[9]=>
string(8) "25832971"
[10]=>
string(8) "25832972"
[11]=>
string(8) "25832973"
[12]=>
string(8) "25832974"
[13]=>
string(8) "25832975"
[14]=>
string(8) "25832976"
[15]=>
string(8) "25832977"
[16]=>
string(8) "25832978"
[17]=>
string(8) "25832979"
[18]=>
string(8) "25832980"
[19]=>
string(8) "25832981"
[20]=>
string(8) "25832982"
[21]=>
string(8) "25832983"
[22]=>
string(8) "25832984"
[23]=>
string(8) "25832985"
[24]=>
string(8) "25832986"
[25]=>
string(8) "25832987"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202221305
)
[StreetNumber] => Array
(
[0] => 68-701
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Farrington
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.pineapplelabs.io/virtualtour/e4f07892-8366-41d7-b99c-598d01c83c27/video
)
[ListPrice] => Array
(
[0] => 1998000.00
)
[CurrentPrice] => Array
(
[0] => 1998000.00
)
[Neighbourhood] => Array
(
[0] => MOKULEIA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Would you like to own a serene and most charming oceanfront property on Oahu's North Shore? Come and view this 3bed/2bath gem with many upgrades inside and out, well-maintained and move-in ready in Mokuleia. Rare opportunity to enjoy the tranquility of the North Shore. You'll be mesmerized by the waves as the clouds drift on the horizon. Expansive unobstructed views of the beautiful ocean. New vinyl plank flooring, granite counter tops, sleek ceiling fans, freshly painted inside and out, fully fenced and gated with 68 linear feet of direct ocean front, this lovely home awaits your enjoyment of pleasure and privacy. Please see Virtual Tour!
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 8762.00
)
[SqftTotal] => Array
(
[0] => 1440
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Coastline,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialua
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => CBPP02
)
[ListAgentEmail] => Array
(
[0] => Ida.Elliott@cbpacific.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 738-3904
)
[ListAgentFullName] => Array
(
[0] => Ida Elliott
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-04-02T07:33:49.627
)
[Matrix_Unique_ID] => Array
(
[0] => 16939236
)
[OriginalEntryTimestamp] => Array
(
[0] => 2022-10-20T11:05:17.300
)
[_thumbnail_id] => Array
(
[0] => 25832962
)
[listing_image] => Array
(
[0] => 25832962
[1] => 25832963
[2] => 25832964
[3] => 25832965
[4] => 25832966
[5] => 25832967
[6] => 25832968
[7] => 25832969
[8] => 25832970
[9] => 25832971
[10] => 25832972
[11] => 25832973
[12] => 25832974
[13] => 25832975
[14] => 25832976
[15] => 25832977
[16] => 25832978
[17] => 25832979
[18] => 25832980
[19] => 25832981
[20] => 25832982
[21] => 25832983
[22] => 25832984
[23] => 25832985
[24] => 25832986
[25] => 25832987
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 8,762
- Living (sf): 1,440
- Year Built: 1973
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 2
- View: Coastline,Mountain,Ocean,Sunset
- Listing Office: Coldwell Banker Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Waialua
- Middle School: Waialua
- High School: Waialua
