67-431 Waialua Beach Rd # Waialua Beach Road Unit 2 Waialua, HI 96791

Listing
Overview

Price: $699,000
Area: WAIALUA
Status: Active

Discover this prime residential lot in Waialua on the North Shore of Oahu. This vacant parcel offers private beach access to miles of walkable shoreline, perfect for enjoying the best of island life. Just steps from the beach, this ready-to-build lot comes equipped with utilities, and septic providing an excellent opportunity to construct your ideal home. Enjoy the North Shore’s renowned surf, diving, hiking, and skydiving, while being only five minutes from Haleiwa and 35 minutes from HNL Airport. Invest in this prime location and create your perfect coastal retreat in the peaceful beach town of Haleiwa/Waialua with easy access to all the amenities you need. This property is a great investment opportunity, providing the perfect balance of natural beauty and convenient access to city amenities. Building plans submitted & awaiting approval with Dept of Planning and Permitting! Includes SMA approval. Please see supplements. Listing by: Sterman Realty (808) 637-6200

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202417161"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(25) "67-431 Waialua Beach Rd #"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(16) "Lots/Acres/Farms"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(13) "Waialua Beach"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["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(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "699000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "699000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIALUA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(944) "Discover this prime residential lot in Waialua on the North Shore of Oahu. This vacant parcel offers private beach access to miles of walkable shoreline, perfect for enjoying the best of island life. Just steps from the beach, this ready-to-build lot comes equipped with utilities, and septic providing an excellent opportunity to construct your ideal home. Enjoy the North Shore’s renowned surf, diving, hiking, and skydiving, while being only five minutes from Haleiwa and 35 minutes from HNL Airport.
Invest in this prime location and create your perfect coastal retreat in the peaceful beach town of Haleiwa/Waialua with easy access to all the amenities you need. This property is a great investment opportunity, providing the perfect balance of natural beauty and convenient access to city amenities.


Building plans submitted & awaiting approval with Dept of Planning and Permitting! Includes SMA approval.  Please see supplements."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(14) "Sterman Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "4686.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(16) "Mountain,Sunrise"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["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) "STER"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(20) "cathyshanley@aol.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 637-6200"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(17) "Cathryn L Shanley"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-09-26T19:29:13.887"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18159265"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-07-31T14:23:28.833"
  }
  ["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) "26643342"
  }
  ["listing_image"]=>
  array(18) {
    [0]=>
    string(8) "26643342"
    [1]=>
    string(8) "26643343"
    [2]=>
    string(8) "26643344"
    [3]=>
    string(8) "26643345"
    [4]=>
    string(8) "26643346"
    [5]=>
    string(8) "26643347"
    [6]=>
    string(8) "26643348"
    [7]=>
    string(8) "26643349"
    [8]=>
    string(8) "26643350"
    [9]=>
    string(8) "26643351"
    [10]=>
    string(8) "26643352"
    [11]=>
    string(8) "26643353"
    [12]=>
    string(8) "26643354"
    [13]=>
    string(8) "26643355"
    [14]=>
    string(8) "26643356"
    [15]=>
    string(8) "26643357"
    [16]=>
    string(8) "26643358"
    [17]=>
    string(8) "26643418"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202417161
        )

    [StreetNumber] => Array
        (
            [0] => 67-431 Waialua Beach Rd #
        )

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

    [StreetName] => Array
        (
            [0] => Waialua Beach
        )

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Discover this prime residential lot in Waialua on the North Shore of Oahu. This vacant parcel offers private beach access to miles of walkable shoreline, perfect for enjoying the best of island life. Just steps from the beach, this ready-to-build lot comes equipped with utilities, and septic providing an excellent opportunity to construct your ideal home. Enjoy the North Shore’s renowned surf, diving, hiking, and skydiving, while being only five minutes from Haleiwa and 35 minutes from HNL Airport.
Invest in this prime location and create your perfect coastal retreat in the peaceful beach town of Haleiwa/Waialua with easy access to all the amenities you need. This property is a great investment opportunity, providing the perfect balance of natural beauty and convenient access to city amenities.


Building plans submitted & awaiting approval with Dept of Planning and Permitting! Includes SMA approval.  Please see supplements.
        )

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

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => Mountain,Sunrise
        )

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 637-6200
        )

    [ListAgentFullName] => Array
        (
            [0] => Cathryn L Shanley
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-09-26T19:29:13.887
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-07-31T14:23:28.833
        )

    [MLSAreaMajor] => Array
        (
            [0] => North Shore
        )

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

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

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

    [listing_image] => Array
        (
            [0] => 26643342
            [1] => 26643343
            [2] => 26643344
            [3] => 26643345
            [4] => 26643346
            [5] => 26643347
            [6] => 26643348
            [7] => 26643349
            [8] => 26643350
            [9] => 26643351
            [10] => 26643352
            [11] => 26643353
            [12] => 26643354
            [13] => 26643355
            [14] => 26643356
            [15] => 26643357
            [16] => 26643358
            [17] => 26643418
        )

)

  • Land Area (sf): 4,686

  • View: Mountain,Sunrise
  • Listing Office: Sterman Realty

  • Land Tenure: FS - Fee Simple

  • Elementary School: Waialua
  • Middle School: Waialua
  • High School: Waialua

CONTACT US

Marcus Realty

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