Beautifully renovated 2 bedroom condo 1 block from the white sandy beaches and surf breaks of Waialua! This fully updated home boasts coastal charm and modern style. Higher end appliances, brand new instant water heater, and BRAND NEW WINDOWS are some of the upgrades that makes this unit stand apart. The home offers your North Shore escape with all the fun and possibilities the coastline has to offer, with Haleiwa town a short drive away. You don’t want to miss this one!! Listing by: BHGRE Advantage Realty N Shore (808) 979-5611
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202421859"
}
["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) "428000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "428000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(479) "Beautifully renovated 2 bedroom condo 1 block from the white sandy beaches and surf breaks of Waialua! This fully updated home boasts coastal charm and modern style. Higher end appliances, brand new instant water heater, and BRAND NEW WINDOWS are some of the upgrades that makes this unit stand apart. The home offers your North Shore escape with all the fun and possibilities the coastline has to offer, with 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) 979-5611"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Aleks Husmann"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-06T17:00:01.260"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18283843"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-27T18:41:24.350"
}
["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) "26710665"
}
["listing_image"]=>
array(13) {
[0]=>
string(8) "26710665"
[1]=>
string(8) "26710666"
[2]=>
string(8) "26710667"
[3]=>
string(8) "26710668"
[4]=>
string(8) "26710669"
[5]=>
string(8) "26710670"
[6]=>
string(8) "26710671"
[7]=>
string(8) "26710672"
[8]=>
string(8) "26710673"
[9]=>
string(8) "26710674"
[10]=>
string(8) "26710675"
[11]=>
string(8) "26710676"
[12]=>
string(8) "26710677"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202421859
)
[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] => 428000.00
)
[CurrentPrice] => Array
(
[0] => 428000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Beautifully renovated 2 bedroom condo 1 block from the white sandy beaches and surf breaks of Waialua! This fully updated home boasts coastal charm and modern style. Higher end appliances, brand new instant water heater, and BRAND NEW WINDOWS are some of the upgrades that makes this unit stand apart. The home offers your North Shore escape with all the fun and possibilities the coastline has to offer, with 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) 979-5611
)
[ListAgentFullName] => Array
(
[0] => Aleks Husmann
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-06T17:00:01.260
)
[Matrix_Unique_ID] => Array
(
[0] => 18283843
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-27T18:41:24.350
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26710665
)
[listing_image] => Array
(
[0] => 26710665
[1] => 26710666
[2] => 26710667
[3] => 26710668
[4] => 26710669
[5] => 26710670
[6] => 26710671
[7] => 26710672
[8] => 26710673
[9] => 26710674
[10] => 26710675
[11] => 26710676
[12] => 26710677
)
)
