68-715 Farrington Highway Waialua, HI 96791
Listing
Overview
Price: $2,250,000
Area: MOKULEIA
Status: Active
Welcome to your dream beach house at 68-715 Farrington Hwy, Waialua. This 3-bedroom, 2-bathroom gem offers direct access to a pristine sandy beach, ideal for sunbathing, fishing, and beachcombing. Enjoy watching the Super Bowl on the outdoor TV, relaxing by the fire pit under the stars or enjoying the hot tub. The open-concept living space, bathed in natural light, provides breathtaking ocean views. The modern kitchen and serene bedrooms, including a lanai bedroom suite with stunning views, create the perfect coastal retreat. Listing by: Coldwell Banker Realty (808) 222-0978
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202419323"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "68-715"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2250000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "2250000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "MOKULEIA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(531) "Welcome to your dream beach house at 68-715 Farrington Hwy, Waialua. This 3-bedroom, 2-bathroom gem offers direct access to a pristine sandy beach, ideal for sunbathing, fishing, and beachcombing. Enjoy watching the Super Bowl on the outdoor TV, relaxing by the fire pit under the stars or enjoying the hot tub. The open-concept living space, bathed in natural light, provides breathtaking ocean views. The modern kitchen and serene bedrooms, including a lanai bedroom suite with stunning views, create the perfect coastal retreat."
}
["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) "8307.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1108"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1961"
}
["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(15) "Coastline,Ocean"
}
["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(18) "diane@dianeito.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 222-0978"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Diane O Ito"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-19T16:30:01.997"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18231157"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-03T17:44:16.457"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(17) "Ocean,Sandy Beach"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26681248"
}
["listing_image"]=>
array(21) {
[0]=>
string(8) "26681248"
[1]=>
string(8) "26681249"
[2]=>
string(8) "26681250"
[3]=>
string(8) "26681251"
[4]=>
string(8) "26681252"
[5]=>
string(8) "26681253"
[6]=>
string(8) "26681254"
[7]=>
string(8) "26681255"
[8]=>
string(8) "26681256"
[9]=>
string(8) "26681257"
[10]=>
string(8) "26681258"
[11]=>
string(8) "26681259"
[12]=>
string(8) "26681260"
[13]=>
string(8) "26681261"
[14]=>
string(8) "26681262"
[15]=>
string(8) "26681263"
[16]=>
string(8) "26681264"
[17]=>
string(8) "26681265"
[18]=>
string(8) "26681266"
[19]=>
string(8) "26681267"
[20]=>
string(8) "26681268"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202419323
)
[StreetNumber] => Array
(
[0] => 68-715
)
[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] =>
)
[ListPrice] => Array
(
[0] => 2250000.00
)
[CurrentPrice] => Array
(
[0] => 2250000.00
)
[Neighbourhood] => Array
(
[0] => MOKULEIA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to your dream beach house at 68-715 Farrington Hwy, Waialua. This 3-bedroom, 2-bathroom gem offers direct access to a pristine sandy beach, ideal for sunbathing, fishing, and beachcombing. Enjoy watching the Super Bowl on the outdoor TV, relaxing by the fire pit under the stars or enjoying the hot tub. The open-concept living space, bathed in natural light, provides breathtaking ocean views. The modern kitchen and serene bedrooms, including a lanai bedroom suite with stunning views, create the perfect coastal retreat.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 8307.00
)
[SqftTotal] => Array
(
[0] => 1108
)
[YearBuilt] => Array
(
[0] => 1961
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Coastline,Ocean
)
[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] => diane@dianeito.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 222-0978
)
[ListAgentFullName] => Array
(
[0] => Diane O Ito
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-19T16:30:01.997
)
[Matrix_Unique_ID] => Array
(
[0] => 18231157
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-03T17:44:16.457
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26681248
)
[listing_image] => Array
(
[0] => 26681248
[1] => 26681249
[2] => 26681250
[3] => 26681251
[4] => 26681252
[5] => 26681253
[6] => 26681254
[7] => 26681255
[8] => 26681256
[9] => 26681257
[10] => 26681258
[11] => 26681259
[12] => 26681260
[13] => 26681261
[14] => 26681262
[15] => 26681263
[16] => 26681264
[17] => 26681265
[18] => 26681266
[19] => 26681267
[20] => 26681268
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 8,307
- Living (sf): 1,108
- Year Built: 1961
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 2
- View: Coastline,Ocean
- Listing Office: Coldwell Banker Realty
- Land Tenure: FS - Fee Simple
