Listing
Overview
Price: $1,550,000
Area: PAALAAKAI
Status: Active
Live the North Shore Dream! Breathe in the fresh country air with this fantastic opportunity to own a beautiful, versatile home in one of Oahu's most desirable location. Built in 2015, this spacious residence features 3 bedrooms and 2 bathrooms upstairs, paired with a HUGE 958 sq. ft. bonus living space downstairs complete with a separate entrance, kitchenette, bathroom, outdoor shower and open lanai for family BBQ's after a long beach day. This area is perfect for, a home office or homeschooling hub, extended family visits, an entertainment suite or the ultimate man cave or she shed! Upstairs boasts an open-concept kitchen, a generous primary suite with direct access to a large lanai, multiple split AC's and a dedicated laundry room. Outside enjoy ample boat or trailer parking, a 2-car garage, and being just blocks from beaches, schools, parks, and historic Haleiwa Town, approx. 8 miles to Schofield Army Base and approx. 25 miles to the airport, this is a must-see North Shore gem - and it won't last long!"
(Note: Tax records do not match - buyer to perform due diligence.) Listing by: BHGRE Advantage Realty (808) 261-1800
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202510151"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "66-166"
}
["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) "A"
}
["City"]=>
array(1) {
[0]=>
string(7) "Haleiwa"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96712"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(59) "https://listings.hetproductions.com/sites/enrkeeq/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1550000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(9) "PAALAAKAI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1091) "Live the North Shore Dream! Breathe in the fresh country air with this fantastic opportunity to own a beautiful, versatile home in one of Oahu's most desirable location. Built in 2015, this spacious residence features 3 bedrooms and 2 bathrooms upstairs, paired with a HUGE 958 sq. ft. bonus living space downstairs complete with a separate entrance, kitchenette, bathroom, outdoor shower and open lanai for family BBQ's after a long beach day. This area is perfect for, a home office or homeschooling hub, extended family visits, an entertainment suite or the ultimate man cave or she shed! Upstairs boasts an open-concept kitchen, a generous primary suite with direct access to a large lanai, multiple split AC's and a dedicated laundry room. Outside enjoy ample boat or trailer parking, a 2-car garage, and being just blocks from beaches, schools, parks, and historic Haleiwa Town, approx. 8 miles to Schofield Army Base and approx. 25 miles to the airport, this is a must-see North Shore gem - and it won't last long!"
(Note: Tax records do not match - buyer to perform due diligence.)"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5640.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2472"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2015"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(15) "Garden,Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Haleiwa"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(6) "ADVG02"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "mundenrealtor@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 261-1800"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(22) "Margarita Margo Munden"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18693211"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-05-04T17:00:01.333"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-04-23"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "17:00:01.333"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26969608"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26969608"
[1]=>
string(8) "26969609"
[2]=>
string(8) "26969610"
[3]=>
string(8) "26969611"
[4]=>
string(8) "26969612"
[5]=>
string(8) "26969613"
[6]=>
string(8) "26969614"
[7]=>
string(8) "26969615"
[8]=>
string(8) "26969616"
[9]=>
string(8) "26969617"
[10]=>
string(8) "26969618"
[11]=>
string(8) "26969619"
[12]=>
string(8) "26969620"
[13]=>
string(8) "26969621"
[14]=>
string(8) "26969622"
[15]=>
string(8) "26969623"
[16]=>
string(8) "26969624"
[17]=>
string(8) "26969625"
[18]=>
string(8) "26969626"
[19]=>
string(8) "26969627"
[20]=>
string(8) "26969628"
[21]=>
string(8) "26969629"
[22]=>
string(8) "26969630"
[23]=>
string(8) "26969631"
[24]=>
string(8) "26969632"
[25]=>
string(8) "26969633"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202510151
)
[StreetNumber] => Array
(
[0] => 66-166
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Waialua Beach
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => A
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/enrkeeq/unbranded
)
[ListPrice] => Array
(
[0] => 1550000.00
)
[Neighbourhood] => Array
(
[0] => PAALAAKAI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Live the North Shore Dream! Breathe in the fresh country air with this fantastic opportunity to own a beautiful, versatile home in one of Oahu's most desirable location. Built in 2015, this spacious residence features 3 bedrooms and 2 bathrooms upstairs, paired with a HUGE 958 sq. ft. bonus living space downstairs complete with a separate entrance, kitchenette, bathroom, outdoor shower and open lanai for family BBQ's after a long beach day. This area is perfect for, a home office or homeschooling hub, extended family visits, an entertainment suite or the ultimate man cave or she shed! Upstairs boasts an open-concept kitchen, a generous primary suite with direct access to a large lanai, multiple split AC's and a dedicated laundry room. Outside enjoy ample boat or trailer parking, a 2-car garage, and being just blocks from beaches, schools, parks, and historic Haleiwa Town, approx. 8 miles to Schofield Army Base and approx. 25 miles to the airport, this is a must-see North Shore gem - and it won't last long!"
(Note: Tax records do not match - buyer to perform due diligence.)
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5640.00
)
[SqftTotal] => Array
(
[0] => 2472
)
[YearBuilt] => Array
(
[0] => 2015
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 5
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Garden,Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Haleiwa
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => ADVG02
)
[ListAgentEmail] => Array
(
[0] => mundenrealtor@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 261-1800
)
[ListAgentFullName] => Array
(
[0] => Margarita Margo Munden
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18693211
)
[MatrixModifiedDT] => Array
(
[0] => 2025-05-04T17:00:01.333
)
[ListingContractDate] => Array
(
[0] => 2025-04-23
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:01.333
)
[_thumbnail_id] => Array
(
[0] => 26969608
)
[listing_image] => Array
(
[0] => 26969608
[1] => 26969609
[2] => 26969610
[3] => 26969611
[4] => 26969612
[5] => 26969613
[6] => 26969614
[7] => 26969615
[8] => 26969616
[9] => 26969617
[10] => 26969618
[11] => 26969619
[12] => 26969620
[13] => 26969621
[14] => 26969622
[15] => 26969623
[16] => 26969624
[17] => 26969625
[18] => 26969626
[19] => 26969627
[20] => 26969628
[21] => 26969629
[22] => 26969630
[23] => 26969631
[24] => 26969632
[25] => 26969633
)
)
- BedsTotal: 3
- Full Baths: 3
- Land Area (sf): 5,640 sf
- Living (sf): 2,472
- Year Built: 2015
- Property Condition: Excellent
- Number of Parking Spaces: 5
- View: Garden,Mountain
- Listing Office: BHGRE Advantage Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Haleiwa
- Middle School: Waialua
- High School: Waialua
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on May 4, 2025 - 5:00 PM
Information is deemed reliable but not guaranteed.
Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, our company may represent you as the buyer's agent.
If the active listing you are interested in is our company's active listing, you may speak to one of our agents
regarding your options for representation.
© Marcus Realty. All Rights Reserved.
