Listing
Overview
Price: $1,875,000
Area: WAIALUA
Status: Active
This Home is the epitome of Island Living with lush landscaping, wide wrap around lanais with mountain views and your own deeded beach access ONLY for Kaiea Place owners! Don't miss the opportunity to live tucked away in a quiet Cul de Sac in one of the most desirable neighborhoods on Oahu's North Shore! The open floor plan upstairs and large covered space downstairs are perfect for entertaining or just relaxing. New split AC's in all rooms, ceiling speakers in kitchen, parking for 4+ cars, enclosed back yard with 3 gates and tall lava rock walls on both sides create a private oasis. Soaking in the 6-person Sundance Hot Tub (2020) is the perfect way to unwind at the end of the day. 24 OWNED solar panels with net metering, interior paint was refreshed in 2022 and new washing machine & dishwasher were installed in 2023. Large, covered workshop and plenty of storage space! Located near the Waialua Beach Rd bike path where you can ride to the Farmer's Market or Haleiwa Town. Come experience the North Shore lifestyle...This is a MUST SEE!
Buyer to do due diligence. Listing by: Seaside Realty LLC (808) 723-0953
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202411273"
}
["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(98) "https://www.hommati.com/3DTour-AerialVideo/unbranded/67-332-Kaiea-Pl-Waialua-Hi-96791--HPI35218465"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1875000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1875000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1079) "This Home is the epitome of Island Living with lush landscaping, wide wrap around lanais with mountain views and your own deeded beach access ONLY for Kaiea Place owners! Don't miss the opportunity to live tucked away in a quiet Cul de Sac in one of the most desirable neighborhoods on Oahu's North Shore! The open floor plan upstairs and large covered space downstairs are perfect for entertaining or just relaxing. New split AC's in all rooms, ceiling speakers in kitchen, parking for 4+ cars, enclosed back yard with 3 gates and tall lava rock walls on both sides create a private oasis. Soaking in the 6-person Sundance Hot Tub (2020) is the perfect way to unwind at the end of the day. 24 OWNED solar panels with net metering, interior paint was refreshed in 2022 and new washing machine & dishwasher were installed in 2023. Large, covered workshop and plenty of storage space! Located near the Waialua Beach Rd bike path where you can ride to the Farmer's Market or Haleiwa Town. Come experience the North Shore lifestyle...This is a MUST SEE!
Buyer to do due diligence."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(18) "Seaside Realty LLC"
}
["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(3) "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) "SSRE"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(25) "jessicaevemoody@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 723-0953"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Jessica Moody"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-22T17:00:01.720"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18006246"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-06-06T13:14:08.667"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26570254"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26570254"
[1]=>
string(8) "26570255"
[2]=>
string(8) "26570256"
[3]=>
string(8) "26570257"
[4]=>
string(8) "26570258"
[5]=>
string(8) "26570259"
[6]=>
string(8) "26570260"
[7]=>
string(8) "26570261"
[8]=>
string(8) "26570262"
[9]=>
string(8) "26570263"
[10]=>
string(8) "26570264"
[11]=>
string(8) "26570265"
[12]=>
string(8) "26570266"
[13]=>
string(8) "26570267"
[14]=>
string(8) "26570268"
[15]=>
string(8) "26570269"
[16]=>
string(8) "26570270"
[17]=>
string(8) "26570271"
[18]=>
string(8) "26570272"
[19]=>
string(8) "26570273"
[20]=>
string(8) "26570274"
[21]=>
string(8) "26570275"
[22]=>
string(8) "26570276"
[23]=>
string(8) "26570277"
[24]=>
string(8) "26570278"
[25]=>
string(8) "26570279"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202411273
)
[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://www.hommati.com/3DTour-AerialVideo/unbranded/67-332-Kaiea-Pl-Waialua-Hi-96791--HPI35218465
)
[ListPrice] => Array
(
[0] => 1875000.00
)
[CurrentPrice] => Array
(
[0] => 1875000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => This Home is the epitome of Island Living with lush landscaping, wide wrap around lanais with mountain views and your own deeded beach access ONLY for Kaiea Place owners! Don't miss the opportunity to live tucked away in a quiet Cul de Sac in one of the most desirable neighborhoods on Oahu's North Shore! The open floor plan upstairs and large covered space downstairs are perfect for entertaining or just relaxing. New split AC's in all rooms, ceiling speakers in kitchen, parking for 4+ cars, enclosed back yard with 3 gates and tall lava rock walls on both sides create a private oasis. Soaking in the 6-person Sundance Hot Tub (2020) is the perfect way to unwind at the end of the day. 24 OWNED solar panels with net metering, interior paint was refreshed in 2022 and new washing machine & dishwasher were installed in 2023. Large, covered workshop and plenty of storage space! Located near the Waialua Beach Rd bike path where you can ride to the Farmer's Market or Haleiwa Town. Come experience the North Shore lifestyle...This is a MUST SEE!
Buyer to do due diligence.
)
[ListOfficeName] => Array
(
[0] => Seaside Realty LLC
)
[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] => 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] => SSRE
)
[ListAgentEmail] => Array
(
[0] => jessicaevemoody@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 723-0953
)
[ListAgentFullName] => Array
(
[0] => Jessica Moody
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-22T17:00:01.720
)
[Matrix_Unique_ID] => Array
(
[0] => 18006246
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-06-06T13:14:08.667
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26570254
)
[listing_image] => Array
(
[0] => 26570254
[1] => 26570255
[2] => 26570256
[3] => 26570257
[4] => 26570258
[5] => 26570259
[6] => 26570260
[7] => 26570261
[8] => 26570262
[9] => 26570263
[10] => 26570264
[11] => 26570265
[12] => 26570266
[13] => 26570267
[14] => 26570268
[15] => 26570269
[16] => 26570270
[17] => 26570271
[18] => 26570272
[19] => 26570273
[20] => 26570274
[21] => 26570275
[22] => 26570276
[23] => 26570277
[24] => 26570278
[25] => 26570279
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 7,210
- Living (sf): 4,110
- Year Built: 1984
- Property Condition: Excellent
- Number of Parking Spaces: 4
- View: Garden,Mountain,Ocean,Sunset
- Listing Office: Seaside Realty LLC
- Land Tenure: FS - Fee Simple
- Elementary School: Waialua
- Middle School: Waialua
- High School: Waialua
