45-075 Waikalua Road Unit N Kaneohe, HI 96744

Take a Virtual Tour

Listing
Overview

Price: $1,690,000
Area: WAIKALUA
Status: Active

Welcome to Waikalua Bayside in the Kaneohe community. This incredible three level home is well constructed with OPEN FLOOR PLAN, porcelain tile floors, quartz countertops, stainless steel appliances, gas stove, gas tankless flash water heater, 2 gas dryers. Exterior has a fresh coat of paint!! This gorgeous 5 bedrooms, 3.5 baths 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. The home boasts high ceilings, huge open floor plan, spacious primary suite, covered lanais, 2 car garage & 2 parking in front, fenced yard, large picture windows in many rooms capturing spectacular views of the Ko'olau mountain range and Kaneohe Bay. This quaint waterfront community with its private bay access invites you to bring a canoe/stand up paddle board to cruise on the bay. 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 Kailua beaches. Live your dream life of luxury at Waikalua Bayside. Make this your forever home! Listing by: Coldwell Banker Realty (808) 772-0670

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202411279"
  }
  ["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) "1690000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1690000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(8) "WAIKALUA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1155) "Welcome to Waikalua Bayside in the Kaneohe community. This incredible three level home is well constructed with OPEN FLOOR PLAN, porcelain tile floors, quartz countertops, stainless steel appliances, gas stove, gas tankless flash water heater, 2 gas dryers. Exterior has a fresh coat of paint!! This gorgeous 5 bedrooms, 3.5 baths 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. The home boasts high ceilings, huge open floor plan, spacious primary suite, covered lanais, 2 car garage & 2 parking in front, fenced yard, large picture windows in many rooms capturing spectacular views of the Ko'olau mountain range and Kaneohe Bay. This quaint waterfront community with its private bay access invites you to bring a canoe/stand up paddle board to cruise on the bay. 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 Kailua beaches. 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) 772-0670"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(10) "Kathy Burt"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-07-14T16:00:00.853"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18006454"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-05-15T08:47:19.000"
  }
  ["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) "26204093"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26204093"
    [1]=>
    string(8) "26204094"
    [2]=>
    string(8) "26204095"
    [3]=>
    string(8) "26204096"
    [4]=>
    string(8) "26204097"
    [5]=>
    string(8) "26204098"
    [6]=>
    string(8) "26204099"
    [7]=>
    string(8) "26204100"
    [8]=>
    string(8) "26204101"
    [9]=>
    string(8) "26204102"
    [10]=>
    string(8) "26204103"
    [11]=>
    string(8) "26204104"
    [12]=>
    string(8) "26204105"
    [13]=>
    string(8) "26204106"
    [14]=>
    string(8) "26204107"
    [15]=>
    string(8) "26204108"
    [16]=>
    string(8) "26204109"
    [17]=>
    string(8) "26204110"
    [18]=>
    string(8) "26204111"
    [19]=>
    string(8) "26204112"
    [20]=>
    string(8) "26204113"
    [21]=>
    string(8) "26204114"
    [22]=>
    string(8) "26204115"
    [23]=>
    string(8) "26204116"
    [24]=>
    string(8) "26204117"
    [25]=>
    string(8) "26204118"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202411279
        )

    [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] => 1690000.00
        )

    [CurrentPrice] => Array
        (
            [0] => 1690000.00
        )

    [Neighbourhood] => Array
        (
            [0] => WAIKALUA
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => Welcome to Waikalua Bayside in the Kaneohe community. This incredible three level home is well constructed with OPEN FLOOR PLAN, porcelain tile floors, quartz countertops, stainless steel appliances, gas stove, gas tankless flash water heater, 2 gas dryers. Exterior has a fresh coat of paint!! This gorgeous 5 bedrooms, 3.5 baths 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. The home boasts high ceilings, huge open floor plan, spacious primary suite, covered lanais, 2 car garage & 2 parking in front, fenced yard, large picture windows in many rooms capturing spectacular views of the Ko'olau mountain range and Kaneohe Bay. This quaint waterfront community with its private bay access invites you to bring a canoe/stand up paddle board to cruise on the bay. 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 Kailua beaches. 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) 772-0670
        )

    [ListAgentFullName] => Array
        (
            [0] => Kathy Burt
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-07-14T16:00:00.853
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18006454
        )

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-05-15T08:47:19.000
        )

    [MLSAreaMajor] => Array
        (
            [0] => Kaneohe
        )

    [PropertyFrontage] => Array
        (
            [0] => 
        )

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

    [_thumbnail_id] => Array
        (
            [0] => 26204093
        )

    [listing_image] => Array
        (
            [0] => 26204093
            [1] => 26204094
            [2] => 26204095
            [3] => 26204096
            [4] => 26204097
            [5] => 26204098
            [6] => 26204099
            [7] => 26204100
            [8] => 26204101
            [9] => 26204102
            [10] => 26204103
            [11] => 26204104
            [12] => 26204105
            [13] => 26204106
            [14] => 26204107
            [15] => 26204108
            [16] => 26204109
            [17] => 26204110
            [18] => 26204111
            [19] => 26204112
            [20] => 26204113
            [21] => 26204114
            [22] => 26204115
            [23] => 26204116
            [24] => 26204117
            [25] => 26204118
        )

)

  • 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

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446