Previous Next

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

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202613224"
  }
  ["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) "29"
  }
  ["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) "1365000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(9) "KOA RIDGE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1028) "Experience elevated island living in this exceptionally upgraded 4-bedroom, 3-bath residence located in the award-winning master-planned community of Koa Ridge. A desirable first-floor bedroom and full bath provide flexibility for guests, extended family, or a private home office. Upstairs, the tranquil primary suite offers a peaceful retreat complete with a TOTO toilet and generous closet space, while two additional bedrooms provide comfort and versatility, alongside an extra living room. Every detail has been thoughtfully considered, from split energy-efficient air conditioning, Owned PV system, spacious two-car garage with epoxy and screens for functional everyday use. Koa Ridge offers a vibrant lifestyle with beautifully landscaped parks, walking paths, playgrounds, and a true sense of community. Just minutes from shopping, dining, medical facilities, golf courses, and convenient freeway access, this location seamlessly balances tranquility with accessibility. This is more than a home—it’s an opportunity."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(17) "Horita Realty LLC"
  }
  ["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) "3530.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1698"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2023"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["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) "HRTA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(27) "traceystottkelley@stott.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 286-3394"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(24) "Tracey Anne Stott Kelley"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19566709"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-07-28T14:34:28.340"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-07-14"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Waipahu"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2026-07-13T15:53:33.350"
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "14:34:28.340"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27457664"
  }
  ["listing_image"]=>
  array(21) {
    [0]=>
    string(8) "27457664"
    [1]=>
    string(8) "27457665"
    [2]=>
    string(8) "27457666"
    [3]=>
    string(8) "27457667"
    [4]=>
    string(8) "27457668"
    [5]=>
    string(8) "27457669"
    [6]=>
    string(8) "27457670"
    [7]=>
    string(8) "27457671"
    [8]=>
    string(8) "27457672"
    [9]=>
    string(8) "27457673"
    [10]=>
    string(8) "27457674"
    [11]=>
    string(8) "27457675"
    [12]=>
    string(8) "27457676"
    [13]=>
    string(8) "27457677"
    [14]=>
    string(8) "27457678"
    [15]=>
    string(8) "27457679"
    [16]=>
    string(8) "27457680"
    [17]=>
    string(8) "27457681"
    [18]=>
    string(8) "27457682"
    [19]=>
    string(8) "27457683"
    [20]=>
    string(8) "27457684"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202613224
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Experience elevated island living in this exceptionally upgraded 4-bedroom, 3-bath residence located in the award-winning master-planned community of Koa Ridge. A desirable first-floor bedroom and full bath provide flexibility for guests, extended family, or a private home office. Upstairs, the tranquil primary suite offers a peaceful retreat complete with a TOTO toilet and generous closet space, while two additional bedrooms provide comfort and versatility, alongside an extra living room. Every detail has been thoughtfully considered, from split energy-efficient air conditioning, Owned PV system, spacious two-car garage with epoxy and screens for functional everyday use. Koa Ridge offers a vibrant lifestyle with beautifully landscaped parks, walking paths, playgrounds, and a true sense of community. Just minutes from shopping, dining, medical facilities, golf courses, and convenient freeway access, this location seamlessly balances tranquility with accessibility. This is more than a home—it’s an opportunity.
        )

    [ListOfficeName] => Array
        (
            [0] => Horita Realty LLC
        )

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

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

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

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

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

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

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

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

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

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

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

    [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] => HRTA
        )

    [ListAgentEmail] => Array
        (
            [0] => traceystottkelley@stott.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 286-3394
        )

    [ListAgentFullName] => Array
        (
            [0] => Tracey Anne Stott Kelley
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-07-28T14:34:28.340
        )

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

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

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

    [ExemptListingEntryTimestamp] => Array
        (
            [0] => 2026-07-13T15:53:33.350
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 14:34:28.340
        )

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

    [listing_image] => Array
        (
            [0] => 27457664
            [1] => 27457665
            [2] => 27457666
            [3] => 27457667
            [4] => 27457668
            [5] => 27457669
            [6] => 27457670
            [7] => 27457671
            [8] => 27457672
            [9] => 27457673
            [10] => 27457674
            [11] => 27457675
            [12] => 27457676
            [13] => 27457677
            [14] => 27457678
            [15] => 27457679
            [16] => 27457680
            [17] => 27457681
            [18] => 27457682
            [19] => 27457683
            [20] => 27457684
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 2
• View: None
• Listing Office: Horita Realty LLC

FINANCIAL INFO

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

SCHOOLS

• 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 28, 2026 - 2:34 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.