66-148 Niuula Road Unit A Haleiwa, HI 96712
Listing
Overview
Price: $1,525,000
Area: HALEIWA
Status: Sold
Find this home minutes from Historic Haleiwa Town, Ali'i Beach, and all the charm the North Shore boasts. This enchanting 3-bed, 2-bath home embodies the essence of North Shore living. Boasting a picturesque front lanai, this residence offers breathtaking views of both the ocean and the majestic mountains that frame the coastline. The flexible layout of the home provides ample opportunities, whether you envision creating cozy nooks for relaxation or transforming spaces to accommodate your lifestyle needs. Feel the beautiful afternoon breeze and natural light that fill the home throughout the day. Outside, the yard is fully fenced, offering privacy and the perfect place for your pet. In the backyard, you will find a great outdoor BBQ area—ideal for hosting gatherings with family and friends. The location is simply unbeatable, allowing for easy access to the renowned surf breaks of the North Shore, a quick bike ride to Haleiwa, or a minute stroll to the beach just across the street. Ideal for those seeking both tranquility and adventure, this property promises a rare opportunity to own a home in one of Oahu's most coveted destinations. 1st Open House Saturday 11-2pm, 2nd Sunday 2-5pm Listing by: BHGRE Advantage Realty N Shore (808) 741-3835
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202415323"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "66-148"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Niuula"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1650000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1525000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "HALEIWA"
}
["Status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1202) "Find this home minutes from Historic Haleiwa Town, Ali'i Beach, and all the charm the North Shore boasts. This enchanting 3-bed, 2-bath home embodies the essence of North Shore living. Boasting a picturesque front lanai, this residence offers breathtaking views of both the ocean and the majestic mountains that frame the coastline. The flexible layout of the home provides ample opportunities, whether you envision creating cozy nooks for relaxation or transforming spaces to accommodate your lifestyle needs. Feel the beautiful afternoon breeze and natural light that fill the home throughout the day. Outside, the yard is fully fenced, offering privacy and the perfect place for your pet. In the backyard, you will find a great outdoor BBQ area—ideal for hosting gatherings with family and friends. The location is simply unbeatable, allowing for easy access to the renowned surf breaks of the North Shore, a quick bike ride to Haleiwa, or a minute stroll to the beach just across the street. Ideal for those seeking both tranquility and adventure, this property promises a rare opportunity to own a home in one of Oahu's most coveted destinations. 1st Open House Saturday 11-2pm, 2nd Sunday 2-5pm"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(30) "BHGRE Advantage Realty N Shore"
}
["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) "5100.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1200"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2007"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(14) "Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "ADNS"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "MemeM@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 741-3835"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(10) "Meme Moody"
}
["CloseDate"]=>
array(1) {
[0]=>
string(10) "2024-09-27"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-27T10:17:43.503"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18106476"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-07-08T17:20:31.670"
}
["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) "26614609"
}
["listing_image"]=>
array(24) {
[0]=>
string(8) "26614609"
[1]=>
string(8) "26614610"
[2]=>
string(8) "26614611"
[3]=>
string(8) "26614612"
[4]=>
string(8) "26614613"
[5]=>
string(8) "26614614"
[6]=>
string(8) "26614615"
[7]=>
string(8) "26614616"
[8]=>
string(8) "26614617"
[9]=>
string(8) "26614618"
[10]=>
string(8) "26614619"
[11]=>
string(8) "26614620"
[12]=>
string(8) "26614621"
[13]=>
string(8) "26614622"
[14]=>
string(8) "26614623"
[15]=>
string(8) "26614624"
[16]=>
string(8) "26614625"
[17]=>
string(8) "26614626"
[18]=>
string(8) "26614627"
[19]=>
string(8) "26614628"
[20]=>
string(8) "26614629"
[21]=>
string(8) "26614630"
[22]=>
string(8) "26614631"
[23]=>
string(8) "26614632"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202415323
)
[StreetNumber] => Array
(
[0] => 66-148
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Niuula
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => A
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1650000.00
)
[CurrentPrice] => Array
(
[0] => 1525000.00
)
[Neighbourhood] => Array
(
[0] => HALEIWA
)
[Status] => Array
(
[0] => Sold
)
[PublicRemarks] => Array
(
[0] => Find this home minutes from Historic Haleiwa Town, Ali'i Beach, and all the charm the North Shore boasts. This enchanting 3-bed, 2-bath home embodies the essence of North Shore living. Boasting a picturesque front lanai, this residence offers breathtaking views of both the ocean and the majestic mountains that frame the coastline. The flexible layout of the home provides ample opportunities, whether you envision creating cozy nooks for relaxation or transforming spaces to accommodate your lifestyle needs. Feel the beautiful afternoon breeze and natural light that fill the home throughout the day. Outside, the yard is fully fenced, offering privacy and the perfect place for your pet. In the backyard, you will find a great outdoor BBQ area—ideal for hosting gatherings with family and friends. The location is simply unbeatable, allowing for easy access to the renowned surf breaks of the North Shore, a quick bike ride to Haleiwa, or a minute stroll to the beach just across the street. Ideal for those seeking both tranquility and adventure, this property promises a rare opportunity to own a home in one of Oahu's most coveted destinations. 1st Open House Saturday 11-2pm, 2nd Sunday 2-5pm
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty N Shore
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5100.00
)
[SqftTotal] => Array
(
[0] => 1200
)
[YearBuilt] => Array
(
[0] => 2007
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ADNS
)
[ListAgentEmail] => Array
(
[0] => MemeM@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 741-3835
)
[ListAgentFullName] => Array
(
[0] => Meme Moody
)
[CloseDate] => Array
(
[0] => 2024-09-27
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-27T10:17:43.503
)
[Matrix_Unique_ID] => Array
(
[0] => 18106476
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-07-08T17:20:31.670
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26614609
)
[listing_image] => Array
(
[0] => 26614609
[1] => 26614610
[2] => 26614611
[3] => 26614612
[4] => 26614613
[5] => 26614614
[6] => 26614615
[7] => 26614616
[8] => 26614617
[9] => 26614618
[10] => 26614619
[11] => 26614620
[12] => 26614621
[13] => 26614622
[14] => 26614623
[15] => 26614624
[16] => 26614625
[17] => 26614626
[18] => 26614627
[19] => 26614628
[20] => 26614629
[21] => 26614630
[22] => 26614631
[23] => 26614632
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 5,100
- Living (sf): 1,200
- Year Built: 2007
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 2
- View: Mountain,Ocean
- Listing Office: BHGRE Advantage Realty N Shore
- Land Tenure: FS - Fee Simple
