94-1251 Hale Halawai Drive Unit 40 Waipahu, HI 96797

Listing
Overview

Price: $1,175,000
Area: KOA RIDGE
Status: Active

Welcome home to Waioha at Koa Ridge! This one has all the feel of new construction without the wait, and the smartest part is how it lives. The bedrooms all sit together upstairs, giving families a private retreat tucked away from the daily action, while a full bath on the main level keeps things easy for guests and get-togethers. The open concept kitchen, dining, and living flow together under bright, modern finishes and spill out to a usable yard where the keiki and pets have room to play. Downstairs for living and entertaining, upstairs for resting, it just makes sense. Set in the heart of Oahu's newest master planned community, you are minutes from Waipio Costco, shopping, dining, parks, and easy freeway access, with the future Koa Ridge Village Center taking shape nearby. Barely lived in and move in ready, come see why this one feels different! Listing by: eXp Realty (808) 459-6450

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202612222"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(7) "94-1251"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(12) "Hale Halawai"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(5) "Drive"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(2) "40"
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96797"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1175000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(9) "KOA RIDGE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(861) "Welcome home to Waioha at Koa Ridge! This one has all the feel of new construction without the wait, and the smartest part is how it lives. The bedrooms all sit together upstairs, giving families a private retreat tucked away from the daily action, while a full bath on the main level keeps things easy for guests and get-togethers. The open concept kitchen, dining, and living flow together under bright, modern finishes and spill out to a usable yard where the keiki and pets have room to play. Downstairs for living and entertaining, upstairs for resting, it just makes sense. Set in the heart of Oahu's newest master planned community, you are minutes from Waipio Costco, shopping, dining, parks, and easy freeway access, with the future Koa Ridge Village Center taking shape nearby. Barely lived in and move in ready, come see why this one feels different!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "3375.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1544"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2023"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(15) "Garden,Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "138.93"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(5) "Lehua"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(9) "Highlands"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(10) "Pearl City"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "EXPI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(21) "devin@teamtaparra.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 459-6450"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Devin D Hammack"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19537504"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-07-29T15:51:19.873"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-07-02"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "15:51:19.873"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27443675"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27443675"
    [1]=>
    string(8) "27443676"
    [2]=>
    string(8) "27443677"
    [3]=>
    string(8) "27443678"
    [4]=>
    string(8) "27443679"
    [5]=>
    string(8) "27443680"
    [6]=>
    string(8) "27443681"
    [7]=>
    string(8) "27443682"
    [8]=>
    string(8) "27443683"
    [9]=>
    string(8) "27443684"
    [10]=>
    string(8) "27443685"
    [11]=>
    string(8) "27443686"
    [12]=>
    string(8) "27443687"
    [13]=>
    string(8) "27443688"
    [14]=>
    string(8) "27443689"
    [15]=>
    string(8) "27443690"
    [16]=>
    string(8) "27443691"
    [17]=>
    string(8) "27443692"
    [18]=>
    string(8) "27443693"
    [19]=>
    string(8) "27443694"
    [20]=>
    string(8) "27443695"
    [21]=>
    string(8) "27443696"
    [22]=>
    string(8) "27443697"
    [23]=>
    string(8) "27443698"
    [24]=>
    string(8) "27443699"
    [25]=>
    string(8) "27443700"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202612222
        )

    [StreetNumber] => Array
        (
            [0] => 94-1251
        )

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

    [StreetName] => Array
        (
            [0] => Hale Halawai
        )

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => KOA RIDGE
        )

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

    [PublicRemarks] => Array
        (
            [0] => Welcome home to Waioha at Koa Ridge! This one has all the feel of new construction without the wait, and the smartest part is how it lives. The bedrooms all sit together upstairs, giving families a private retreat tucked away from the daily action, while a full bath on the main level keeps things easy for guests and get-togethers. The open concept kitchen, dining, and living flow together under bright, modern finishes and spill out to a usable yard where the keiki and pets have room to play. Downstairs for living and entertaining, upstairs for resting, it just makes sense. Set in the heart of Oahu's newest master planned community, you are minutes from Waipio Costco, shopping, dining, parks, and easy freeway access, with the future Koa Ridge Village Center taking shape nearby. Barely lived in and move in ready, come see why this one feels different!
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => devin@teamtaparra.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 459-6450
        )

    [ListAgentFullName] => Array
        (
            [0] => Devin D Hammack
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-07-29T15:51:19.873
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 15:51:19.873
        )

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

    [listing_image] => Array
        (
            [0] => 27443675
            [1] => 27443676
            [2] => 27443677
            [3] => 27443678
            [4] => 27443679
            [5] => 27443680
            [6] => 27443681
            [7] => 27443682
            [8] => 27443683
            [9] => 27443684
            [10] => 27443685
            [11] => 27443686
            [12] => 27443687
            [13] => 27443688
            [14] => 27443689
            [15] => 27443690
            [16] => 27443691
            [17] => 27443692
            [18] => 27443693
            [19] => 27443694
            [20] => 27443695
            [21] => 27443696
            [22] => 27443697
            [23] => 27443698
            [24] => 27443699
            [25] => 27443700
        )

)

  • BedsTotal: 4
  • Full Baths: 3
  • Land Area (sf): 3,375 sf
  • Living (sf): 1,544
  • Year Built: 2023

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

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

  • Elementary School: Lehua
  • Middle School: Highlands
  • High School: Pearl City

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 July 29, 2026 - 3:51 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.

© Marcus Realty. All Rights Reserved.