Listing
Overview
Price: $430,000
Area: WAIALUA
Status: Active
Beautifully renovated two bedroom condo located one block from the white sandy beaches and surf breaks of Waialua! This fully updated home boasts coastal charm and modern style. High end appliances, instant water heater, and brand new windows throughout are some of the upgrades that make this unit stand out. Located on the corner end of the building, look out your window to gorgeous views of Mt. Kaaala. This home offers your North Shore escape with all the fun and possibilities the coastline and mountains have to offer, with the conveniences and delicious food options in Haleiwa town a short drive away. You don’t want to miss this one!! Listing by: BHGRE Advantage Realty N Shore (808) 637-1500
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202414657"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "68-051"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(5) "Akule"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "201"
}
["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(60) "https://my.matterport.com/show/?m=bhkNgZxyiZf&brand=0&mls=1&"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "430000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "430000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(646) "Beautifully renovated two bedroom condo located one block from the white sandy beaches and surf breaks of Waialua! This fully updated home boasts coastal charm and modern style. High end appliances, instant water heater, and brand new windows throughout are some of the upgrades that make this unit stand out. Located on the corner end of the building, look out your window to gorgeous views of Mt. Kaaala. This home offers your North Shore escape with all the fun and possibilities the coastline and mountains have to offer, with the conveniences and delicious food options in Haleiwa town a short drive away. You don’t want to miss this one!!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(30) "BHGRE Advantage Realty N Shore"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "563"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1977"
}
["BuildingName"]=>
array(1) {
[0]=>
string(19) "Mokuleia Beach Apts"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(5) "Three"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "668.57"
}
["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(23) "AleksH@betterhawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 637-1500"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Aleks Husmann"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-22T12:00:01.380"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18083924"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-06-21T17:06:02.280"
}
["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) "26594974"
}
["listing_image"]=>
array(13) {
[0]=>
string(8) "26594974"
[1]=>
string(8) "26594975"
[2]=>
string(8) "26594976"
[3]=>
string(8) "26594977"
[4]=>
string(8) "26594978"
[5]=>
string(8) "26594979"
[6]=>
string(8) "26594980"
[7]=>
string(8) "26594981"
[8]=>
string(8) "26594982"
[9]=>
string(8) "26594983"
[10]=>
string(8) "26594984"
[11]=>
string(8) "26594985"
[12]=>
string(8) "26594986"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202414657
)
[StreetNumber] => Array
(
[0] => 68-051
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Akule
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 201
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=bhkNgZxyiZf&brand=0&mls=1&
)
[ListPrice] => Array
(
[0] => 430000.00
)
[CurrentPrice] => Array
(
[0] => 430000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Beautifully renovated two bedroom condo located one block from the white sandy beaches and surf breaks of Waialua! This fully updated home boasts coastal charm and modern style. High end appliances, instant water heater, and brand new windows throughout are some of the upgrades that make this unit stand out. Located on the corner end of the building, look out your window to gorgeous views of Mt. Kaaala. This home offers your North Shore escape with all the fun and possibilities the coastline and mountains have to offer, with the conveniences and delicious food options in Haleiwa town a short drive away. You don’t want to miss this one!!
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty N Shore
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 563
)
[YearBuilt] => Array
(
[0] => 1977
)
[BuildingName] => Array
(
[0] => Mokuleia Beach Apts
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => Three
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] => 668.57
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ADNS
)
[ListAgentEmail] => Array
(
[0] => AleksH@betterhawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 637-1500
)
[ListAgentFullName] => Array
(
[0] => Aleks Husmann
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-22T12:00:01.380
)
[Matrix_Unique_ID] => Array
(
[0] => 18083924
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-06-21T17:06:02.280
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26594974
)
[listing_image] => Array
(
[0] => 26594974
[1] => 26594975
[2] => 26594976
[3] => 26594977
[4] => 26594978
[5] => 26594979
[6] => 26594980
[7] => 26594981
[8] => 26594982
[9] => 26594983
[10] => 26594984
[11] => 26594985
[12] => 26594986
)
)
- BedsTotal: 2
- Full Baths: 1
- Living (sf): 563
- Year Built: 1977
- Building Name: Mokuleia Beach Apts
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: Mountain
- Listing Office: BHGRE Advantage Realty N Shore
- Maintenance Fees: $669
- Land Tenure: FS - Fee Simple
