Previous Next

68-037 Apuhihi Street Unit A Waialua, HI 96791

Take a Virtual Tour

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202604492"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "68-037"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Apuhihi"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(1) "A"
  }
  ["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(60) "https://listings.hetproductions.com/sites/raobnplp/unbranded"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "820000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIALUA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1046) "Enjoy North Shore living just one block from the beach. This beautifully renovated 2-bedroom, 2.5-bath end unit townhouse offers over 1,000 sq ft of updated interior living space in a desirable Waialua beachside community. The first floor includes a versatile bonus room ideal for a home office, den, guest room, or potential third bedroom. Energy-efficient split AC units provide comfort.

The move-in-ready interior features a spacious feel with easy flow between the living, dining, and outdoor areas, perfect for everyday island living and entertaining.

Step outside to a lush, tropical landscaped yard with outdoor storage and a convenient outdoor shower. As an end unit, the home enjoys added privacy and abundant natural light, plus two dedicated parking spaces.

Ideally located near a bike path and quiet beaches, and just moments from Aweoweo Beach Park featuring basketball courts, a playground, and open green space for dogs. Also just minutes to Haleiwa Town, the Waialua Sugar Mill shops and eateries, and Schofield Barracks."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(24) "REMAX Hawaii North Shore"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1018"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1993"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(13) "Waialua Palms"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(8) "Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "921.00"
  }
  ["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) "ADNS"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(26) "Meme.Moody@remaxhawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 741-3835"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(10) "Meme Moody"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19293933"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-03-01T17:39:27.233"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-02-27"
  }
  ["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:39:27.233"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27317592"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27317592"
    [1]=>
    string(8) "27317593"
    [2]=>
    string(8) "27317594"
    [3]=>
    string(8) "27317595"
    [4]=>
    string(8) "27317596"
    [5]=>
    string(8) "27317597"
    [6]=>
    string(8) "27317598"
    [7]=>
    string(8) "27317599"
    [8]=>
    string(8) "27317600"
    [9]=>
    string(8) "27317601"
    [10]=>
    string(8) "27317602"
    [11]=>
    string(8) "27317603"
    [12]=>
    string(8) "27317604"
    [13]=>
    string(8) "27317605"
    [14]=>
    string(8) "27317606"
    [15]=>
    string(8) "27317607"
    [16]=>
    string(8) "27317608"
    [17]=>
    string(8) "27317609"
    [18]=>
    string(8) "27317610"
    [19]=>
    string(8) "27317611"
    [20]=>
    string(8) "27317612"
    [21]=>
    string(8) "27317613"
    [22]=>
    string(8) "27317614"
    [23]=>
    string(8) "27317615"
    [24]=>
    string(8) "27317616"
    [25]=>
    string(8) "27317617"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202604492
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://listings.hetproductions.com/sites/raobnplp/unbranded
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Enjoy North Shore living just one block from the beach. This beautifully renovated 2-bedroom, 2.5-bath end unit townhouse offers over 1,000 sq ft of updated interior living space in a desirable Waialua beachside community. The first floor includes a versatile bonus room ideal for a home office, den, guest room, or potential third bedroom. Energy-efficient split AC units provide comfort.

The move-in-ready interior features a spacious feel with easy flow between the living, dining, and outdoor areas, perfect for everyday island living and entertaining.

Step outside to a lush, tropical landscaped yard with outdoor storage and a convenient outdoor shower. As an end unit, the home enjoys added privacy and abundant natural light, plus two dedicated parking spaces.

Ideally located near a bike path and quiet beaches, and just moments from Aweoweo Beach Park featuring basketball courts, a playground, and open green space for dogs. Also just minutes to Haleiwa Town, the Waialua Sugar Mill shops and eateries, and Schofield Barracks.
        )

    [ListOfficeName] => Array
        (
            [0] => REMAX Hawaii North Shore
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Meme.Moody@remaxhawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 741-3835
        )

    [ListAgentFullName] => Array
        (
            [0] => Meme Moody
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-03-01T17:39:27.233
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-02-27
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 17:39:27.233
        )

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

    [listing_image] => Array
        (
            [0] => 27317592
            [1] => 27317593
            [2] => 27317594
            [3] => 27317595
            [4] => 27317596
            [5] => 27317597
            [6] => 27317598
            [7] => 27317599
            [8] => 27317600
            [9] => 27317601
            [10] => 27317602
            [11] => 27317603
            [12] => 27317604
            [13] => 27317605
            [14] => 27317606
            [15] => 27317607
            [16] => 27317608
            [17] => 27317609
            [18] => 27317610
            [19] => 27317611
            [20] => 27317612
            [21] => 27317613
            [22] => 27317614
            [23] => 27317615
            [24] => 27317616
            [25] => 27317617
        )

)

PROPERTY INFO

• BedsTotal: 2
• Full Baths: 2
• Half Baths: 1
• Living (sf): 1,018
• Year Built: 1993
• Building Name: Waialua Palms

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 2
• View: Mountain
• Listing Office: REMAX Hawaii North Shore

FINANCIAL INFO

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

SCHOOLS

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 March 1, 2026 - 5:39 PM Information is deemed reliable but not guaranteed. Copyright: 2026 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.