45-075 Waikalua Road Unit J Kaneohe, HI 96744

Listing
Overview

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

Welcome to this stunning home in Waikalua Bayside. Nestled in the beautiful Kaneohe town. Enjoy the cool Windward breeze, views of Kaneohe Bay and the majestic Ko'olau mountain range. This beautiful 3 bedroom, 3 1/2 bath home has an open floor plan, enclosed garage, and ample guest parking. Enjoy private access to the bay just steps away! Easy access to Kaneohe MCBH, Kailua beaches, H-3 Highway, Windward mall, Target, shopping centers, schools and more! This home has a 2.5% assumable VA rate with a 30 year term. Move-in ready and the motivated sellers are offering a $10,000 credit to the buyer at closing! Listing by: eXp Realty (808) 725-2794

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202416375"
  }
  ["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) "J"
  }
  ["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(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1395000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1395000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(8) "WAIKALUA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(613) "Welcome to this stunning home in Waikalua Bayside. Nestled in the beautiful Kaneohe town. Enjoy the cool Windward breeze, views of Kaneohe Bay and the majestic Ko'olau mountain range. This beautiful 3 bedroom, 3 1/2 bath home has an open floor plan, enclosed garage, and ample guest parking. Enjoy private access to the bay just steps away!  Easy access to Kaneohe MCBH, Kailua beaches, H-3 Highway, Windward mall, Target, shopping centers, schools and more! This home has a 2.5% assumable VA rate with a 30 year term. Move-in ready and the motivated sellers are offering a $10,000 credit to the buyer at closing!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "3671.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2304"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2016"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["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(4) "EXPI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(25) "kuira.young@exprealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Kuira Young"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-09-22T17:00:01.720"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18136857"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-07-18T07:44:56.197"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26626811"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26626811"
    [1]=>
    string(8) "26626812"
    [2]=>
    string(8) "26626813"
    [3]=>
    string(8) "26626814"
    [4]=>
    string(8) "26626815"
    [5]=>
    string(8) "26626816"
    [6]=>
    string(8) "26626817"
    [7]=>
    string(8) "26626818"
    [8]=>
    string(8) "26626819"
    [9]=>
    string(8) "26626820"
    [10]=>
    string(8) "26626821"
    [11]=>
    string(8) "26626822"
    [12]=>
    string(8) "26626823"
    [13]=>
    string(8) "26626824"
    [14]=>
    string(8) "26626825"
    [15]=>
    string(8) "26626826"
    [16]=>
    string(8) "26626827"
    [17]=>
    string(8) "26626828"
    [18]=>
    string(8) "26626829"
    [19]=>
    string(8) "26626830"
    [20]=>
    string(8) "26626831"
    [21]=>
    string(8) "26626832"
    [22]=>
    string(8) "26626833"
    [23]=>
    string(8) "26626834"
    [24]=>
    string(8) "26626835"
    [25]=>
    string(8) "26626836"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202416375
        )

    [StreetNumber] => Array
        (
            [0] => 45-075
        )

    [PropertyType] => Array
        (
            [0] => Single Family
        )

    [StreetName] => Array
        (
            [0] => Waikalua
        )

    [StreetSuffix] => Array
        (
            [0] => Road
        )

    [UnitNumber] => Array
        (
            [0] => J
        )

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

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96744
        )

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

    [ListPrice] => Array
        (
            [0] => 1395000.00
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Welcome to this stunning home in Waikalua Bayside. Nestled in the beautiful Kaneohe town. Enjoy the cool Windward breeze, views of Kaneohe Bay and the majestic Ko'olau mountain range. This beautiful 3 bedroom, 3 1/2 bath home has an open floor plan, enclosed garage, and ample guest parking. Enjoy private access to the bay just steps away!  Easy access to Kaneohe MCBH, Kailua beaches, H-3 Highway, Windward mall, Target, shopping centers, schools and more! This home has a 2.5% assumable VA rate with a 30 year term. Move-in ready and the motivated sellers are offering a $10,000 credit to the buyer at closing!
        )

    [ListOfficeName] => Array
        (
            [0] => eXp Realty
        )

    [BedsTotal] => Array
        (
            [0] => 3
        )

    [BathsFull] => Array
        (
            [0] => 3
        )

    [BathsHalf] => Array
        (
            [0] => 1
        )

    [LotSizeArea] => Array
        (
            [0] => 3671.00
        )

    [SqftTotal] => Array
        (
            [0] => 2304
        )

    [YearBuilt] => Array
        (
            [0] => 2016
        )

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

    [PropertyCondition] => Array
        (
            [0] => Above Average
        )

    [ParkingTotal] => Array
        (
            [0] => 3
        )

    [StoriesType] => Array
        (
            [0] => Two
        )

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

    [ListAgentEmail] => Array
        (
            [0] => kuira.young@exprealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 725-2794
        )

    [ListAgentFullName] => Array
        (
            [0] => Kuira Young
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-09-22T17:00:01.720
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-07-18T07:44:56.197
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26626811
            [1] => 26626812
            [2] => 26626813
            [3] => 26626814
            [4] => 26626815
            [5] => 26626816
            [6] => 26626817
            [7] => 26626818
            [8] => 26626819
            [9] => 26626820
            [10] => 26626821
            [11] => 26626822
            [12] => 26626823
            [13] => 26626824
            [14] => 26626825
            [15] => 26626826
            [16] => 26626827
            [17] => 26626828
            [18] => 26626829
            [19] => 26626830
            [20] => 26626831
            [21] => 26626832
            [22] => 26626833
            [23] => 26626834
            [24] => 26626835
            [25] => 26626836
        )

)

  • BedsTotal: 3
  • Full Baths: 3
  • Half Baths: 1
  • Land Area (sf): 3,671
  • Living (sf): 2,304
  • Year Built: 2016

  • Property Condition: Above Average
  • Number of Parking Spaces: 3
  • View: Mountain,Ocean
  • Listing Office: eXp Realty

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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