Listing
Overview
Price: $1,590,000
Area: WAIKALUA
Status: Active
Welcome to Waikalua Bayside in the Kaneohe community. This gorgeous gem is 5 bedrooms, 3.5 baths, three level home that is well constructed with OPEN FLOOR PLAN—a large 3,049 sq. ft. home, priced to sell! One of THE LOWEST $ / sq. ft. NEWER MODERN CONSTRUCTED BUILT HOME IN THE BEAUTIFUL WINDWARD SIDE! Spectacular Hawaii ocean views and the Ko’olau mountain range on display with large picture windows throughout. This gorgeous executive home has a wet bar with two bedrooms, one bath, and covered patio on separate level and separate entry perfect for flexible living arrangements. It has porcelain wide wood plank tile floors, quartz countertops, stainless steel appliances, gas stove, gas tankless flash water heater, 2 gas dryers. The home boasts high ceilings, huge open floor plan, spacious primary suite, 3 covered lanais, 2 car garage & 2 parking in front, fenced yard. Located in the heart of Kaneohe allows easy access to Windward Mall with Target, movie theaters, shops & restaurants. Effortless commuting to downtown Honolulu, Oahu's military bases and the famous Kailua and Lanikai beaches. Welcome home! Live your dream life of luxury at Waikalua Bayside. Make this your forever home! Listing by: Coldwell Banker Realty (808) 262-3104
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202418171"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "45-075"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Waikalua"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(1) "N"
}
["City"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96744"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(53) "https://my.matterport.com/show/?m=zo6q8qpqhWK&brand=0"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1590000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1590000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "WAIKALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1203) "Welcome to Waikalua Bayside in the Kaneohe community. This gorgeous gem is 5 bedrooms, 3.5 baths, three level home that is well constructed with OPEN FLOOR PLAN—a large 3,049 sq. ft. home, priced to sell! One of THE LOWEST $ / sq. ft. NEWER MODERN CONSTRUCTED BUILT HOME IN THE BEAUTIFUL WINDWARD SIDE! Spectacular Hawaii ocean views and the Ko’olau mountain range on display with large picture windows throughout. This gorgeous executive home has a wet bar with two bedrooms, one bath, and covered patio on separate level and separate entry perfect for flexible living arrangements. It has porcelain wide wood plank tile floors, quartz countertops, stainless steel appliances, gas stove, gas tankless flash water heater, 2 gas dryers. The home boasts high ceilings, huge open floor plan, spacious primary suite, 3 covered lanais, 2 car garage & 2 parking in front, fenced yard. Located in the heart of Kaneohe allows easy access to Windward Mall with Target, movie theaters, shops & restaurants. Effortless commuting to downtown Honolulu, Oahu's military bases and the famous Kailua and Lanikai beaches. Welcome home! Live your dream life of luxury at Waikalua Bayside. Make this your forever home!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "3864.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3523"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2016"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(6) "Three+"
}
["View"]=>
array(1) {
[0]=>
string(14) "Mountain,Ocean"
}
["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(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(6) "CBPP04"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(20) "kathyb@cbpacific.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 262-3104"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(10) "Kathy Burt"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-27T11:00:01.753"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18199059"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-08-15T15:34:28.920"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26660776"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26660776"
[1]=>
string(8) "26660777"
[2]=>
string(8) "26660778"
[3]=>
string(8) "26660779"
[4]=>
string(8) "26660780"
[5]=>
string(8) "26660781"
[6]=>
string(8) "26660782"
[7]=>
string(8) "26660783"
[8]=>
string(8) "26660784"
[9]=>
string(8) "26660785"
[10]=>
string(8) "26660786"
[11]=>
string(8) "26660787"
[12]=>
string(8) "26660788"
[13]=>
string(8) "26660789"
[14]=>
string(8) "26660790"
[15]=>
string(8) "26660791"
[16]=>
string(8) "26660792"
[17]=>
string(8) "26660793"
[18]=>
string(8) "26660794"
[19]=>
string(8) "26660795"
[20]=>
string(8) "26660796"
[21]=>
string(8) "26660797"
[22]=>
string(8) "26660798"
[23]=>
string(8) "26660799"
[24]=>
string(8) "26660800"
[25]=>
string(8) "26660801"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202418171
)
[StreetNumber] => Array
(
[0] => 45-075
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Waikalua
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => N
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=zo6q8qpqhWK&brand=0
)
[ListPrice] => Array
(
[0] => 1590000.00
)
[CurrentPrice] => Array
(
[0] => 1590000.00
)
[Neighbourhood] => Array
(
[0] => WAIKALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to Waikalua Bayside in the Kaneohe community. This gorgeous gem is 5 bedrooms, 3.5 baths, three level home that is well constructed with OPEN FLOOR PLAN—a large 3,049 sq. ft. home, priced to sell! One of THE LOWEST $ / sq. ft. NEWER MODERN CONSTRUCTED BUILT HOME IN THE BEAUTIFUL WINDWARD SIDE! Spectacular Hawaii ocean views and the Ko’olau mountain range on display with large picture windows throughout. This gorgeous executive home has a wet bar with two bedrooms, one bath, and covered patio on separate level and separate entry perfect for flexible living arrangements. It has porcelain wide wood plank tile floors, quartz countertops, stainless steel appliances, gas stove, gas tankless flash water heater, 2 gas dryers. The home boasts high ceilings, huge open floor plan, spacious primary suite, 3 covered lanais, 2 car garage & 2 parking in front, fenced yard. Located in the heart of Kaneohe allows easy access to Windward Mall with Target, movie theaters, shops & restaurants. Effortless commuting to downtown Honolulu, Oahu's military bases and the famous Kailua and Lanikai beaches. Welcome home! Live your dream life of luxury at Waikalua Bayside. Make this your forever home!
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 3864.00
)
[SqftTotal] => Array
(
[0] => 3523
)
[YearBuilt] => Array
(
[0] => 2016
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Three+
)
[View] => Array
(
[0] => Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBPP04
)
[ListAgentEmail] => Array
(
[0] => kathyb@cbpacific.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 262-3104
)
[ListAgentFullName] => Array
(
[0] => Kathy Burt
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-27T11:00:01.753
)
[Matrix_Unique_ID] => Array
(
[0] => 18199059
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-08-15T15:34:28.920
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26660776
)
[listing_image] => Array
(
[0] => 26660776
[1] => 26660777
[2] => 26660778
[3] => 26660779
[4] => 26660780
[5] => 26660781
[6] => 26660782
[7] => 26660783
[8] => 26660784
[9] => 26660785
[10] => 26660786
[11] => 26660787
[12] => 26660788
[13] => 26660789
[14] => 26660790
[15] => 26660791
[16] => 26660792
[17] => 26660793
[18] => 26660794
[19] => 26660795
[20] => 26660796
[21] => 26660797
[22] => 26660798
[23] => 26660799
[24] => 26660800
[25] => 26660801
)
)
- BedsTotal: 5
- Full Baths: 3
- Half Baths: 1
- Land Area (sf): 3,864
- Living (sf): 3,523
- Year Built: 2016
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 4
- View: Mountain,Ocean
- Listing Office: Coldwell Banker Realty
- Land Tenure: FS - Fee Simple
