66-815 Wanini Street Waialua, HI 96791
Listing
Overview
Price: $825,000
Area: PAALAAKAI
Status: Active
Here's a fantastic opportunity to enjoy the stunning Waialua skies on the North Shore! This charming community offers easy access to beautiful surfing spots, scenic beaches, and excellent recreational fishing. You'll also be a short distance from the quaint town of Haleiwa, known for its delightful dining options, local art galleries, banks, unique shops, and beloved shave ice spots. The property was appraised in October 2024, and the assessed value was used to determine the listing price. Don't miss out on this chance to embrace the vibrant lifestyle of this amazing area! The property will be sold "As Is and Where Is." Listing by: HOMES R US REALTY, LLC (808) 295-0543
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202425931"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "66-815"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Wanini"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "825000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "825000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(9) "PAALAAKAI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(631) "Here's a fantastic opportunity to enjoy the stunning Waialua skies on the North Shore! This charming community offers easy access to beautiful surfing spots, scenic beaches, and excellent recreational fishing. You'll also be a short distance from the quaint town of Haleiwa, known for its delightful dining options, local art galleries, banks, unique shops, and beloved shave ice spots. The property was appraised in October 2024, and the assessed value was used to determine the listing price. Don't miss out on this chance to embrace the vibrant lifestyle of this amazing area! The property will be sold "As Is and Where Is.""
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "HOMES R US REALTY, LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "4682.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "850"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1980"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(4) "Fair"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["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(7) "Waialua"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "HRUS"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(17) "paluyen@yahoo.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 295-0543"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Pureza A Aluyen"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-08T15:05:36.017"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18363854"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-11-05T18:05:15.833"
}
["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) "26757049"
}
["listing_image"]=>
array(10) {
[0]=>
string(8) "26757049"
[1]=>
string(8) "26757050"
[2]=>
string(8) "26757051"
[3]=>
string(8) "26757052"
[4]=>
string(8) "26757053"
[5]=>
string(8) "26757054"
[6]=>
string(8) "26757055"
[7]=>
string(8) "26757056"
[8]=>
string(8) "26757057"
[9]=>
string(8) "26757058"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202425931
)
[StreetNumber] => Array
(
[0] => 66-815
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Wanini
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 825000.00
)
[CurrentPrice] => Array
(
[0] => 825000.00
)
[Neighbourhood] => Array
(
[0] => PAALAAKAI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Here's a fantastic opportunity to enjoy the stunning Waialua skies on the North Shore! This charming community offers easy access to beautiful surfing spots, scenic beaches, and excellent recreational fishing. You'll also be a short distance from the quaint town of Haleiwa, known for its delightful dining options, local art galleries, banks, unique shops, and beloved shave ice spots. The property was appraised in October 2024, and the assessed value was used to determine the listing price. Don't miss out on this chance to embrace the vibrant lifestyle of this amazing area! The property will be sold "As Is and Where Is."
)
[ListOfficeName] => Array
(
[0] => HOMES R US REALTY, LLC
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 4682.00
)
[SqftTotal] => Array
(
[0] => 850
)
[YearBuilt] => Array
(
[0] => 1980
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Fair
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => HRUS
)
[ListAgentEmail] => Array
(
[0] => paluyen@yahoo.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 295-0543
)
[ListAgentFullName] => Array
(
[0] => Pureza A Aluyen
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-08T15:05:36.017
)
[Matrix_Unique_ID] => Array
(
[0] => 18363854
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-11-05T18:05:15.833
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26757049
)
[listing_image] => Array
(
[0] => 26757049
[1] => 26757050
[2] => 26757051
[3] => 26757052
[4] => 26757053
[5] => 26757054
[6] => 26757055
[7] => 26757056
[8] => 26757057
[9] => 26757058
)
)
- BedsTotal: 3
- Full Baths: 1
- Half Baths: 1
- Land Area (sf): 4,682
- Living (sf): 850
- Year Built: 1980
- Property Condition: Fair
- Number of Parking Spaces: 1
- View: None
- Listing Office: HOMES R US REALTY, LLC
- Land Tenure: FS - Fee Simple
- Middle School: Waialua
- High School: Waialua
