Previous Next

68-101 Waialua Beach Road Unit 304 Waialua, HI 96791

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202510421"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "68-101"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(13) "Waialua Beach"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(3) "304"
  }
  ["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) "480000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIALUA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1073) "Step into this newly renovated, rarely available 3-Bed, 1-Bath North Shore condo, blending modern with island comfort. This top floor end unit is located just moments away from the beach and Aweoweo Beach Park, featuring sleek finishes and thoughtful updates throughout, making it both stylish and move-in ready. Enjoy scenic views of Mount Ka'ala along with partial ocean views bringing a peaceful, natural backdrop to your everyday living. The location is great for commuters, whether you're heading to world famous surf breaks, military bases, or town, you'll have quick and easy access to all. You're also just a short drive from the historic town of Haleiwa, where you can explore unique shops, local restaurants, and soak in the relaxed charm of North Shore living. The unit includes two designated parking spaces, adding extra convenience to your daily routine. Whether you're dreaming of a peaceful island escape or a modern, well connected condo, this one offers the perfect blend of comfort, style, and location. Don't miss your chance to own a piece of paradise."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(14) "Sterman Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "14331.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "699"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1975"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(13) "Mokuleia Surf"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(5) "Three"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(14) "Mountain,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "784.00"
  }
  ["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(17) "david@sterman.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 371-4622"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "David J Sterman"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18701602"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-06-29T17:00:01.380"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-04-22"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "17:00:01.380"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26969037"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26969037"
    [1]=>
    string(8) "26969038"
    [2]=>
    string(8) "26969039"
    [3]=>
    string(8) "26969040"
    [4]=>
    string(8) "26969041"
    [5]=>
    string(8) "26969042"
    [6]=>
    string(8) "26969043"
    [7]=>
    string(8) "26969044"
    [8]=>
    string(8) "26969045"
    [9]=>
    string(8) "26969046"
    [10]=>
    string(8) "26969047"
    [11]=>
    string(8) "26969048"
    [12]=>
    string(8) "26969049"
    [13]=>
    string(8) "26969050"
    [14]=>
    string(8) "26969051"
    [15]=>
    string(8) "26969052"
    [16]=>
    string(8) "26969053"
    [17]=>
    string(8) "26969054"
    [18]=>
    string(8) "26969055"
    [19]=>
    string(8) "26969056"
    [20]=>
    string(8) "26969057"
    [21]=>
    string(8) "26969058"
    [22]=>
    string(8) "26969059"
    [23]=>
    string(8) "26969060"
    [24]=>
    string(8) "26969061"
    [25]=>
    string(8) "26969062"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202510421
        )

    [StreetNumber] => Array
        (
            [0] => 68-101
        )

    [PropertyType] => Array
        (
            [0] => Condo/Townhouse
        )

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Step into this newly renovated, rarely available 3-Bed, 1-Bath North Shore condo, blending modern with island comfort. This top floor end unit is located just moments away from the beach and Aweoweo Beach Park, featuring sleek finishes and thoughtful updates throughout, making it both stylish and move-in ready. Enjoy scenic views of Mount Ka'ala along with partial ocean views bringing a peaceful, natural backdrop to your everyday living. The location is great for commuters, whether you're heading to world famous surf breaks, military bases, or town, you'll have quick and easy access to all. You're also just a short drive from the historic town of Haleiwa, where you can explore unique shops, local restaurants, and soak in the relaxed charm of North Shore living. The unit includes two designated parking spaces, adding extra convenience to your daily routine. Whether you're dreaming of a peaceful island escape or a modern, well connected condo, this one offers the perfect blend of comfort, style, and location. Don't miss your chance to own a piece of paradise.
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [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] => david@sterman.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 371-4622
        )

    [ListAgentFullName] => Array
        (
            [0] => David J Sterman
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-06-29T17:00:01.380
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-04-22
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 17:00:01.380
        )

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

    [listing_image] => Array
        (
            [0] => 26969037
            [1] => 26969038
            [2] => 26969039
            [3] => 26969040
            [4] => 26969041
            [5] => 26969042
            [6] => 26969043
            [7] => 26969044
            [8] => 26969045
            [9] => 26969046
            [10] => 26969047
            [11] => 26969048
            [12] => 26969049
            [13] => 26969050
            [14] => 26969051
            [15] => 26969052
            [16] => 26969053
            [17] => 26969054
            [18] => 26969055
            [19] => 26969056
            [20] => 26969057
            [21] => 26969058
            [22] => 26969059
            [23] => 26969060
            [24] => 26969061
            [25] => 26969062
        )

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 1
• Land Area (sf): 14,331 sf
• Living (sf): 699
• Year Built: 1975
• Building Name: Mokuleia Surf

KEY FEATURES

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

FINANCIAL INFO

• Maintenance Fees: $784
• Land Tenure: FS - Fee Simple

SCHOOLS

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

CONTACT US

Marcus Realty

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

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on June 29, 2025 - 5:00 PM Information is deemed reliable but not guaranteed. Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®. If you are interested in those active listings, our company may represent you as the buyer's agent. If the active listing you are interested in is our company's active listing, you may speak to one of our agents regarding your options for representation.