Listing
Overview
Price: $925,000
Area: WAIALUA
Status: Active Under Contract
Escape the hustle and bustle and take a drive to the North Shore. Embrace the tranquility of country living in this freshly renovated 3-bedroom, 2-bathroom single-family duplex residence nestled in "Cement City" of Waialua. This property has undergone ~$100,000 stunning transformation boasting floor-to-ceiling renovations. Revel in the brand-new kitchen featuring a sleek island & dedicated dining area, new bathrooms, new luxury vinyl plank flooring that spans throughout. Includes new appliances, window AC, and ceiling fans. Convenience meets serenity as this home is just moments away from the idyllic Aweoweo & Pu'uiki Beach Park. Explore the nearby walking and biking paths, or soak in the charm of historic Haleiwa Town with its eclectic shops and eateries. Don't miss your chance to claim this North Shore oasis as your own. Act swiftly – this opportunity won't be available for long! See link for video. Listing by: Compass (808) 258-5950
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202408853"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "68-027"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(13) "Waialua Beach"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(1) "4"
}
["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(39) "http://player.vimeo.com/video/938167449"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "925000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "925000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(918) "Escape the hustle and bustle and take a drive to the North Shore. Embrace the tranquility of country living in this freshly renovated 3-bedroom, 2-bathroom single-family duplex residence nestled in "Cement City" of Waialua. This property has undergone ~$100,000 stunning transformation boasting floor-to-ceiling renovations. Revel in the brand-new kitchen featuring a sleek island & dedicated dining area, new bathrooms, new luxury vinyl plank flooring that spans throughout. Includes new appliances, window AC, and ceiling fans. Convenience meets serenity as this home is just moments away from the idyllic Aweoweo & Pu'uiki Beach Park. Explore the nearby walking and biking paths, or soak in the charm of historic Haleiwa Town with its eclectic shops and eateries. Don't miss your chance to claim this North Shore oasis as your own. Act swiftly – this opportunity won't be available for long! See link for video."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["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) "4876.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1098"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1988"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(14) "Mountain,Other"
}
["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(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "COHI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(26) "kendra.okihiro@compass.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 258-5950"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Kendra K Okihiro"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-05-03T11:17:17.813"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17956811"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-04-23T15:59:45.943"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26177284"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "26177284"
[1]=>
string(8) "26177285"
[2]=>
string(8) "26177286"
[3]=>
string(8) "26177287"
[4]=>
string(8) "26177288"
[5]=>
string(8) "26177289"
[6]=>
string(8) "26177290"
[7]=>
string(8) "26177291"
[8]=>
string(8) "26177292"
[9]=>
string(8) "26177293"
[10]=>
string(8) "26177294"
[11]=>
string(8) "26177295"
[12]=>
string(8) "26177296"
[13]=>
string(8) "26177297"
[14]=>
string(8) "26177298"
[15]=>
string(8) "26177299"
[16]=>
string(8) "26177300"
[17]=>
string(8) "26177301"
[18]=>
string(8) "26177302"
[19]=>
string(8) "26177303"
[20]=>
string(8) "26177304"
[21]=>
string(8) "26177305"
[22]=>
string(8) "26177306"
[23]=>
string(8) "26177307"
[24]=>
string(8) "26177308"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202408853
)
[StreetNumber] => Array
(
[0] => 68-027
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Waialua Beach
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => 4
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => http://player.vimeo.com/video/938167449
)
[ListPrice] => Array
(
[0] => 925000.00
)
[CurrentPrice] => Array
(
[0] => 925000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Escape the hustle and bustle and take a drive to the North Shore. Embrace the tranquility of country living in this freshly renovated 3-bedroom, 2-bathroom single-family duplex residence nestled in "Cement City" of Waialua. This property has undergone ~$100,000 stunning transformation boasting floor-to-ceiling renovations. Revel in the brand-new kitchen featuring a sleek island & dedicated dining area, new bathrooms, new luxury vinyl plank flooring that spans throughout. Includes new appliances, window AC, and ceiling fans. Convenience meets serenity as this home is just moments away from the idyllic Aweoweo & Pu'uiki Beach Park. Explore the nearby walking and biking paths, or soak in the charm of historic Haleiwa Town with its eclectic shops and eateries. Don't miss your chance to claim this North Shore oasis as your own. Act swiftly – this opportunity won't be available for long! See link for video.
)
[ListOfficeName] => Array
(
[0] => Compass
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 4876.00
)
[SqftTotal] => Array
(
[0] => 1098
)
[YearBuilt] => Array
(
[0] => 1988
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Mountain,Other
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialua
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => COHI
)
[ListAgentEmail] => Array
(
[0] => kendra.okihiro@compass.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 258-5950
)
[ListAgentFullName] => Array
(
[0] => Kendra K Okihiro
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-05-03T11:17:17.813
)
[Matrix_Unique_ID] => Array
(
[0] => 17956811
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-04-23T15:59:45.943
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26177284
)
[listing_image] => Array
(
[0] => 26177284
[1] => 26177285
[2] => 26177286
[3] => 26177287
[4] => 26177288
[5] => 26177289
[6] => 26177290
[7] => 26177291
[8] => 26177292
[9] => 26177293
[10] => 26177294
[11] => 26177295
[12] => 26177296
[13] => 26177297
[14] => 26177298
[15] => 26177299
[16] => 26177300
[17] => 26177301
[18] => 26177302
[19] => 26177303
[20] => 26177304
[21] => 26177305
[22] => 26177306
[23] => 26177307
[24] => 26177308
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 4,876
- Living (sf): 1,098
- Year Built: 1988
- Property Condition: Above Average
- Number of Parking Spaces: 2
- View: Mountain,Other
- Listing Office: Compass
- Land Tenure: FS - Fee Simple
- Elementary School: Waialua
- High School: Waialua
