68-695 Farrington Highway Waialua, HI 96791
Listing
Overview
Price: $1,600,000
Area: MOKULEIA
Status: Active Under Contract
Discover your dream oceanfront retreat in serene Mokuleia! This charming 3-bedroom, 2 bath home boasts breathtaking ocean views. The spacious living and dining area offer the perfect setting for relaxation and entertaining. This stunning property offers direct access to the ocean, perfect for fishing, diving and snorkeling right from your backyard. Enjoy the equestrian lifestyle with a nearby horse polo club, where you can ride along the beach and relax at the polo field and stables. Located just moments from Haleiwa town, you'll have access to an array of dining and shopping options, plus famous beaches that host exciting surfing competitions yearly. Permitted seawall. 18 PV panels and back up battery. Assumable VA loan about $800K at 2.25%. Don’t miss this unique opportunity to embrace the ultimate coastal living experience! This property is fully fenced, providing a sense of privacy and security. Imagine...... living this close to the ocean......... Listing by: Stott Real Estate, Inc. (808) 286-3394
array(48) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202424672"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "68-695"
}
["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) "1600000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "MOKULEIA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(970) "Discover your dream oceanfront retreat in serene Mokuleia! This charming 3-bedroom, 2 bath home boasts breathtaking ocean views. The spacious living and dining area offer the perfect setting for relaxation and entertaining. This stunning property offers direct access to the ocean, perfect for fishing, diving and snorkeling right from your backyard. Enjoy the equestrian lifestyle with a nearby horse polo club, where you can ride along the beach and relax at the polo field and stables. Located just moments from Haleiwa town, you'll have access to an array of dining and shopping options, plus famous beaches that host exciting surfing competitions yearly. Permitted seawall. 18 PV panels and back up battery. Assumable VA loan about $800K at 2.25%. Don’t miss this unique opportunity to embrace the ultimate coastal living experience! This property is fully fenced, providing a sense of privacy and security. Imagine...... living this close to the ocean........."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(23) "Stott Real Estate, Inc."
}
["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) "8250.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1288"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1960"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(31) "Coastline,Garden,Mountain,Ocean"
}
["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(4) "SOLD"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(27) "traceystottkelley@stott.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 286-3394"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(24) "Tracey Anne Stott Kelley"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-24T11:41:12.467"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18347334"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(16) "Ocean,Waterfront"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26789451"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26789451"
[1]=>
string(8) "26789452"
[2]=>
string(8) "26789453"
[3]=>
string(8) "26789454"
[4]=>
string(8) "26789455"
[5]=>
string(8) "26789456"
[6]=>
string(8) "26789457"
[7]=>
string(8) "26789458"
[8]=>
string(8) "26789459"
[9]=>
string(8) "26789460"
[10]=>
string(8) "26789461"
[11]=>
string(8) "26789462"
[12]=>
string(8) "26789463"
[13]=>
string(8) "26789464"
[14]=>
string(8) "26789465"
[15]=>
string(8) "26789466"
[16]=>
string(8) "26789467"
[17]=>
string(8) "26789468"
[18]=>
string(8) "26789469"
[19]=>
string(8) "26789470"
[20]=>
string(8) "26789471"
[21]=>
string(8) "26789472"
[22]=>
string(8) "26789473"
[23]=>
string(8) "26789474"
[24]=>
string(8) "26789475"
[25]=>
string(8) "26789476"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-11-29"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "11:41:12.467"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202424672
)
[StreetNumber] => Array
(
[0] => 68-695
)
[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] => 1600000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => MOKULEIA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Discover your dream oceanfront retreat in serene Mokuleia! This charming 3-bedroom, 2 bath home boasts breathtaking ocean views. The spacious living and dining area offer the perfect setting for relaxation and entertaining. This stunning property offers direct access to the ocean, perfect for fishing, diving and snorkeling right from your backyard. Enjoy the equestrian lifestyle with a nearby horse polo club, where you can ride along the beach and relax at the polo field and stables. Located just moments from Haleiwa town, you'll have access to an array of dining and shopping options, plus famous beaches that host exciting surfing competitions yearly. Permitted seawall. 18 PV panels and back up battery. Assumable VA loan about $800K at 2.25%. Don’t miss this unique opportunity to embrace the ultimate coastal living experience! This property is fully fenced, providing a sense of privacy and security. Imagine...... living this close to the ocean.........
)
[ListOfficeName] => Array
(
[0] => Stott Real Estate, Inc.
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 8250.00
)
[SqftTotal] => Array
(
[0] => 1288
)
[YearBuilt] => Array
(
[0] => 1960
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Coastline,Garden,Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialua
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => SOLD
)
[ListAgentEmail] => Array
(
[0] => traceystottkelley@stott.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 286-3394
)
[ListAgentFullName] => Array
(
[0] => Tracey Anne Stott Kelley
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-24T11:41:12.467
)
[Matrix_Unique_ID] => Array
(
[0] => 18347334
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Waterfront
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26789451
)
[listing_image] => Array
(
[0] => 26789451
[1] => 26789452
[2] => 26789453
[3] => 26789454
[4] => 26789455
[5] => 26789456
[6] => 26789457
[7] => 26789458
[8] => 26789459
[9] => 26789460
[10] => 26789461
[11] => 26789462
[12] => 26789463
[13] => 26789464
[14] => 26789465
[15] => 26789466
[16] => 26789467
[17] => 26789468
[18] => 26789469
[19] => 26789470
[20] => 26789471
[21] => 26789472
[22] => 26789473
[23] => 26789474
[24] => 26789475
[25] => 26789476
)
[ListingContractDate] => Array
(
[0] => 2024-11-29
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 11:41:12.467
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 8,250 sf
- Living (sf): 1,288
- Year Built: 1960
- Property Condition: Average
- Number of Parking Spaces: 2
- View: Coastline,Garden,Mountain,Ocean
- Listing Office: Stott Real Estate, Inc.
- Land Tenure: FS - Fee Simple
- Elementary School: Waialua
- Middle School: Waialua
- High School: Waialua
