Listing
Overview
Price: $428,000
Area: WAIALUA
Status: Sold
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(4) "Sold"
}
["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(10) "2024-11-22"
}
["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] => Sold
)
[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] => 2024-11-22
)
[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
)
)
- 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
