54-337 Kamehameha Highway Unit 2B Hauula, HI 96717

Listing
Overview

Price: $599,000
Area: HAUULA
Status: Active

Nice 5,165 sqft ocean view beachside lot in a newer development. Ready to build your dream home in paradise? Great location across from marketplace with shops and restaurants. Steps from the sand and a nice swimming hole. Great for snorkeling, Kayaking or just walking down the beach. Close to the North Shore and other attractions. All newer homes built in development. Seller disclosures are available upon offer. This area of Hawaii brings back memories of the South Pacific and Tahiti. Come live the Hawaiian lifestyle. Listing by: Hawaii Homes International

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202316285"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "54-337"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(16) "Lots/Acres/Farms"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(10) "Kamehameha"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(7) "Highway"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(2) "2B"
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(6) "Hauula"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96717"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "599000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "599000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "HAUULA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(523) "Nice 5,165 sqft ocean view beachside lot in a newer development. Ready to build your dream home in paradise? Great location across from marketplace with shops and restaurants. Steps from the sand and a nice swimming hole. Great for snorkeling, Kayaking or just walking down the beach. Close to the North Shore and other attractions. All newer homes built in development. Seller disclosures are available upon offer. This area of Hawaii brings back memories of the South Pacific and Tahiti. Come live the Hawaiian lifestyle."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(26) "Hawaii Homes International"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "5165.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(21) "Garden,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) "REEW"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(15) "bgwvrdr@aol.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Ralph S Gray"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2023-10-02T09:49:47.177"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17436354"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-07-18T05:00:45.663"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25870632"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "25870632"
    [1]=>
    string(8) "25870633"
    [2]=>
    string(8) "25870634"
    [3]=>
    string(8) "25870635"
    [4]=>
    string(8) "25870636"
    [5]=>
    string(8) "25870637"
    [6]=>
    string(8) "25870638"
    [7]=>
    string(8) "25870639"
    [8]=>
    string(8) "25870640"
    [9]=>
    string(8) "25870641"
    [10]=>
    string(8) "25870642"
    [11]=>
    string(8) "25870643"
    [12]=>
    string(8) "25870644"
    [13]=>
    string(8) "25870645"
    [14]=>
    string(8) "25870646"
    [15]=>
    string(8) "25870647"
    [16]=>
    string(8) "25870648"
    [17]=>
    string(8) "25870649"
    [18]=>
    string(8) "25870650"
    [19]=>
    string(8) "25870651"
    [20]=>
    string(8) "25870652"
    [21]=>
    string(8) "25870653"
    [22]=>
    string(8) "25870654"
    [23]=>
    string(8) "25870655"
    [24]=>
    string(8) "25870656"
    [25]=>
    string(8) "25870657"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202316285
        )

    [StreetNumber] => Array
        (
            [0] => 54-337
        )

    [PropertyType] => Array
        (
            [0] => Lots/Acres/Farms
        )

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

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

    [UnitNumber] => Array
        (
            [0] => 2B
        )

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Nice 5,165 sqft ocean view beachside lot in a newer development. Ready to build your dream home in paradise? Great location across from marketplace with shops and restaurants. Steps from the sand and a nice swimming hole. Great for snorkeling, Kayaking or just walking down the beach. Close to the North Shore and other attractions. All newer homes built in development. Seller disclosures are available upon offer. This area of Hawaii brings back memories of the South Pacific and Tahiti. Come live the Hawaiian lifestyle.
        )

    [ListOfficeName] => Array
        (
            [0] => Hawaii Homes International
        )

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => Garden,Mountain,Ocean
        )

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

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

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

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

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

    [ListOfficeMLSID] => Array
        (
            [0] => REEW
        )

    [ListAgentEmail] => Array
        (
            [0] => bgwvrdr@aol.com
        )

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

    [ListAgentFullName] => Array
        (
            [0] => Ralph S Gray
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2023-10-02T09:49:47.177
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-07-18T05:00:45.663
        )

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

    [listing_image] => Array
        (
            [0] => 25870632
            [1] => 25870633
            [2] => 25870634
            [3] => 25870635
            [4] => 25870636
            [5] => 25870637
            [6] => 25870638
            [7] => 25870639
            [8] => 25870640
            [9] => 25870641
            [10] => 25870642
            [11] => 25870643
            [12] => 25870644
            [13] => 25870645
            [14] => 25870646
            [15] => 25870647
            [16] => 25870648
            [17] => 25870649
            [18] => 25870650
            [19] => 25870651
            [20] => 25870652
            [21] => 25870653
            [22] => 25870654
            [23] => 25870655
            [24] => 25870656
            [25] => 25870657
        )

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

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

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

)

  • Land Area (sf): 5,165

  • View: Garden,Mountain,Ocean
  • Listing Office: Hawaii Homes International

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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