Listing
Overview
Price: $1,900,000
Area: WAIALUA
Status: Active
Experience true Island Living in this beautiful home! Surrounded by lush landscaping, it boasts wide wrap-around lanais with stunning mountain views and private deeded beach access exclusive to Kaiea Place owners! "Hammerheads" surf break is right out your back door & other breaks are close by. Nestled in a quiet cul-de-sac in one of Oahu's most sought-after North Shore neighborhoods, it’s a dream house with an open layout, cozy loft & large covered area downstairs. Enjoy new split ACs in every room, kitchen ceiling speakers, parking for 4+ cars, and a private, enclosed backyard with tall lava rock walls. Relax in your 6-person Sundance Hot Tub (2020) and benefit from 24 OWNED solar panels with net metering. Recent updates include fresh interior paint (2022), new washer and dishwasher (2023). Steps from the Waialua Beach Rd bike path, where you can easily access the Farmer’s Market or Haleiwa Town. Close proximity to desirable Waialua Elementary, Intermediate & High Schools. ***View the amazing 3D virtual tour NOW***, and then schedule your in-person showing! A “do-not-miss” North Shore gem! Listing by: eXp Realty (808) 294-1794
array(47) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202428169"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "67-332"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(5) "Kaiea"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["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(144) "https://click.pstmrk.it/3s/shoots.styronphoto.com%2Fsites%2Fzekezlo%2Funbranded/cUpU/B525AQ/AQ/2b8f35dd-9bd8-4b8c-aa81-d0b2f0b9e8e4/3/2Iyq5AHzuF"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1900000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1116) "Experience true Island Living in this beautiful home! Surrounded by lush landscaping, it boasts wide wrap-around lanais with stunning mountain views and private deeded beach access exclusive to Kaiea Place owners! "Hammerheads" surf break is right out your back door & other breaks are close by. Nestled in a quiet cul-de-sac in one of Oahu's most sought-after North Shore neighborhoods, it’s a dream house with an open layout, cozy loft & large covered area downstairs. Enjoy new split ACs in every room, kitchen ceiling speakers, parking for 4+ cars, and a private, enclosed backyard with tall lava rock walls. Relax in your 6-person Sundance Hot Tub (2020) and benefit from 24 OWNED solar panels with net metering. Recent updates include fresh interior paint (2022), new washer and dishwasher (2023). Steps from the Waialua Beach Rd bike path, where you can easily access the Farmer’s Market or Haleiwa Town. Close proximity to desirable Waialua Elementary, Intermediate & High Schools. ***View the amazing 3D virtual tour NOW***, and then schedule your in-person showing! A “do-not-miss” North Shore gem!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "eXp 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) "7210.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "4110"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1984"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(7) "One,Two"
}
["View"]=>
array(1) {
[0]=>
string(28) "Garden,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(4) "EXPI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(16) "Team@OBHomes.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 294-1794"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "John W Stallings"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-23T12:44:07.270"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18435291"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-12-12"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26807509"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26807509"
[1]=>
string(8) "26807510"
[2]=>
string(8) "26807511"
[3]=>
string(8) "26807512"
[4]=>
string(8) "26807513"
[5]=>
string(8) "26807514"
[6]=>
string(8) "26807515"
[7]=>
string(8) "26807516"
[8]=>
string(8) "26807517"
[9]=>
string(8) "26807518"
[10]=>
string(8) "26807519"
[11]=>
string(8) "26807520"
[12]=>
string(8) "26807521"
[13]=>
string(8) "26807522"
[14]=>
string(8) "26807523"
[15]=>
string(8) "26807524"
[16]=>
string(8) "26807525"
[17]=>
string(8) "26807526"
[18]=>
string(8) "26807527"
[19]=>
string(8) "26807528"
[20]=>
string(8) "26807529"
[21]=>
string(8) "26807530"
[22]=>
string(8) "26807531"
[23]=>
string(8) "26807532"
[24]=>
string(8) "26807533"
[25]=>
string(8) "26807534"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202428169
)
[StreetNumber] => Array
(
[0] => 67-332
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kaiea
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://click.pstmrk.it/3s/shoots.styronphoto.com%2Fsites%2Fzekezlo%2Funbranded/cUpU/B525AQ/AQ/2b8f35dd-9bd8-4b8c-aa81-d0b2f0b9e8e4/3/2Iyq5AHzuF
)
[ListPrice] => Array
(
[0] => 1900000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Experience true Island Living in this beautiful home! Surrounded by lush landscaping, it boasts wide wrap-around lanais with stunning mountain views and private deeded beach access exclusive to Kaiea Place owners! "Hammerheads" surf break is right out your back door & other breaks are close by. Nestled in a quiet cul-de-sac in one of Oahu's most sought-after North Shore neighborhoods, it’s a dream house with an open layout, cozy loft & large covered area downstairs. Enjoy new split ACs in every room, kitchen ceiling speakers, parking for 4+ cars, and a private, enclosed backyard with tall lava rock walls. Relax in your 6-person Sundance Hot Tub (2020) and benefit from 24 OWNED solar panels with net metering. Recent updates include fresh interior paint (2022), new washer and dishwasher (2023). Steps from the Waialua Beach Rd bike path, where you can easily access the Farmer’s Market or Haleiwa Town. Close proximity to desirable Waialua Elementary, Intermediate & High Schools. ***View the amazing 3D virtual tour NOW***, and then schedule your in-person showing! A “do-not-miss” North Shore gem!
)
[ListOfficeName] => Array
(
[0] => eXp Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 7210.00
)
[SqftTotal] => Array
(
[0] => 4110
)
[YearBuilt] => Array
(
[0] => 1984
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => One,Two
)
[View] => Array
(
[0] => Garden,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] => EXPI
)
[ListAgentEmail] => Array
(
[0] => Team@OBHomes.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 294-1794
)
[ListAgentFullName] => Array
(
[0] => John W Stallings
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-23T12:44:07.270
)
[Matrix_Unique_ID] => Array
(
[0] => 18435291
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[ListingContractDate] => Array
(
[0] => 2024-12-12
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26807509
)
[listing_image] => Array
(
[0] => 26807509
[1] => 26807510
[2] => 26807511
[3] => 26807512
[4] => 26807513
[5] => 26807514
[6] => 26807515
[7] => 26807516
[8] => 26807517
[9] => 26807518
[10] => 26807519
[11] => 26807520
[12] => 26807521
[13] => 26807522
[14] => 26807523
[15] => 26807524
[16] => 26807525
[17] => 26807526
[18] => 26807527
[19] => 26807528
[20] => 26807529
[21] => 26807530
[22] => 26807531
[23] => 26807532
[24] => 26807533
[25] => 26807534
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 7,210 sf
- Living (sf): 4,110
- Year Built: 1984
- Property Condition: Excellent
- Number of Parking Spaces: 4
- View: Garden,Mountain,Ocean,Sunset
- Listing Office: eXp Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Waialua
- Middle School: Waialua
- High School: Waialua
