Listing
Overview
Price: $535,000
Area: WAIALUA
Status: Active
Sellers Highly Motivated – bring us a buyer! VA Assumable loan with 3.75% interest rate. Embrace North Shore living in this beautiful 2 bedroom, 1 bath split-level unit situated just moments away from the Aweoweo Beach. Partially renovated with a newly painted kitchen and LVP wood-look flooring upstairs, this unit is the perfect place to call home. Step into the main living area and you’re greeted by an open concept kitchen, living, and dining space full of natural light. The spacious lanai is a welcoming space to relax and listen to the waves crash in the evenings. Downstairs you’ll find a full bathroom, two large bedrooms, washer and dryer, and ample closet storage. Owners in Ono Vista have access to a saltwater pool and sauna, conveniently located just downstairs. Tucked away in the quiet streets of Waialua, you’re just minutes from all Historic Haleiwa town and the picturesque North Shore has to offer, yet just a short 15 minute drive to H2 access and Schofield Barracks. Schedule a private showing to view this beauty today. Listing by: eXp Realty (808) 725-2794
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202412312"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "68-090"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(2) "Au"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "E304"
}
["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(50) "https://hommati.tours/tour/2162411?play=no&mls=yes"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "535000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "535000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1051) "Sellers Highly Motivated – bring us a buyer! VA Assumable loan with 3.75% interest rate. Embrace North Shore living in this beautiful 2 bedroom, 1 bath split-level unit situated just moments away from the Aweoweo Beach. Partially renovated with a newly painted kitchen and LVP wood-look flooring upstairs, this unit is the perfect place to call home. Step into the main living area and you’re greeted by an open concept kitchen, living, and dining space full of natural light. The spacious lanai is a welcoming space to relax and listen to the waves crash in the evenings. Downstairs you’ll find a full bathroom, two large bedrooms, washer and dryer, and ample closet storage. Owners in Ono Vista have access to a saltwater pool and sauna, conveniently located just downstairs. Tucked away in the quiet streets of Waialua, you’re just minutes from all Historic Haleiwa town and the picturesque North Shore has to offer, yet just a short 15 minute drive to H2 access and Schofield Barracks. Schedule a private showing to view this beauty today."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["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(8) "51662.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "864"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1975"
}
["BuildingName"]=>
array(1) {
[0]=>
string(9) "Ono Vista"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(18) "Coastline,Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1079.48"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "EXPI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "brandi@karmahawaii.life"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(21) "Brandi Morgan Collins"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-01T17:00:01.707"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18035385"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-06-05T09:41:19.683"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26574930"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26574930"
[1]=>
string(8) "26574931"
[2]=>
string(8) "26574932"
[3]=>
string(8) "26574933"
[4]=>
string(8) "26574934"
[5]=>
string(8) "26574935"
[6]=>
string(8) "26574936"
[7]=>
string(8) "26574937"
[8]=>
string(8) "26574938"
[9]=>
string(8) "26574939"
[10]=>
string(8) "26574940"
[11]=>
string(8) "26574941"
[12]=>
string(8) "26574942"
[13]=>
string(8) "26574943"
[14]=>
string(8) "26574944"
[15]=>
string(8) "26574945"
[16]=>
string(8) "26574946"
[17]=>
string(8) "26574947"
[18]=>
string(8) "26574948"
[19]=>
string(8) "26574949"
[20]=>
string(8) "26574950"
[21]=>
string(8) "26574951"
[22]=>
string(8) "26574952"
[23]=>
string(8) "26574953"
[24]=>
string(8) "26574954"
[25]=>
string(8) "26574955"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202412312
)
[StreetNumber] => Array
(
[0] => 68-090
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Au
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => E304
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://hommati.tours/tour/2162411?play=no&mls=yes
)
[ListPrice] => Array
(
[0] => 535000.00
)
[CurrentPrice] => Array
(
[0] => 535000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Sellers Highly Motivated – bring us a buyer! VA Assumable loan with 3.75% interest rate. Embrace North Shore living in this beautiful 2 bedroom, 1 bath split-level unit situated just moments away from the Aweoweo Beach. Partially renovated with a newly painted kitchen and LVP wood-look flooring upstairs, this unit is the perfect place to call home. Step into the main living area and you’re greeted by an open concept kitchen, living, and dining space full of natural light. The spacious lanai is a welcoming space to relax and listen to the waves crash in the evenings. Downstairs you’ll find a full bathroom, two large bedrooms, washer and dryer, and ample closet storage. Owners in Ono Vista have access to a saltwater pool and sauna, conveniently located just downstairs. Tucked away in the quiet streets of Waialua, you’re just minutes from all Historic Haleiwa town and the picturesque North Shore has to offer, yet just a short 15 minute drive to H2 access and Schofield Barracks. Schedule a private showing to view this beauty today.
)
[ListOfficeName] => Array
(
[0] => eXp Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 51662.00
)
[SqftTotal] => Array
(
[0] => 864
)
[YearBuilt] => Array
(
[0] => 1975
)
[BuildingName] => Array
(
[0] => Ono Vista
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Coastline,Mountain
)
[MaintenanceExpense] => Array
(
[0] => 1079.48
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialua
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => EXPI
)
[ListAgentEmail] => Array
(
[0] => brandi@karmahawaii.life
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 725-2794
)
[ListAgentFullName] => Array
(
[0] => Brandi Morgan Collins
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-01T17:00:01.707
)
[Matrix_Unique_ID] => Array
(
[0] => 18035385
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-06-05T09:41:19.683
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26574930
)
[listing_image] => Array
(
[0] => 26574930
[1] => 26574931
[2] => 26574932
[3] => 26574933
[4] => 26574934
[5] => 26574935
[6] => 26574936
[7] => 26574937
[8] => 26574938
[9] => 26574939
[10] => 26574940
[11] => 26574941
[12] => 26574942
[13] => 26574943
[14] => 26574944
[15] => 26574945
[16] => 26574946
[17] => 26574947
[18] => 26574948
[19] => 26574949
[20] => 26574950
[21] => 26574951
[22] => 26574952
[23] => 26574953
[24] => 26574954
[25] => 26574955
)
)
- BedsTotal: 2
- Full Baths: 1
- Land Area (sf): 51,662
- Living (sf): 864
- Year Built: 1975
- Building Name: Ono Vista
- Property Condition: Above Average
- Number of Parking Spaces: 2
- View: Coastline,Mountain
- Listing Office: eXp Realty
- Maintenance Fees: $1,079
- Land Tenure: FS - Fee Simple
- Elementary School: Waialua
- Middle School: Waialua
- High School: Waialua
