Previous Next

54-290 Kawaipuna Place Hauula, HI 96717

Listing
Overview

Price: $1,199,000
Area: HAUULA
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202514196"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "54-290"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(9) "Kawaipuna"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(5) "Place"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(6) "Hauula"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96717"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1199000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "HAUULA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1206) "More Space. More Flexibility. More Hawai‘i Life. Tucked away at the end of a quiet cul-de-sac in Hau'ula, this spacious 2,335 sq ft 2-story home offers a flexible layout ideal for multi-gen living or rental income. With 3 distinct living areas, there’s room for 'ohana, guests, or work-from-home needs. Fresh interior paint, updated kitchens and baths, and thoughtfully designed spaces add to the appeal.

The main home features 3 bed, 2 baths, and a large bonus room (staged as a 4th bedroom). The kitchen has beautiful blue cabinets, white quartz countertops, new appliances, and flows into the bright living area with tall ceilings and natural light.

Downstairs, a mother-in-law suite with wet bar offers privacy or rental potential. Upstairs, a studio apartment includes a full kitchen and an oversized lanai with mountain views and peekaboo ocean views—perfect for entertaining or unwinding.

Two-car enclosed garage with workshop bay. Just 0.6 miles to Hau'ula Beach Park and close to Pounders Beach, Hau'ula Loop Trail, and everyday essentials. A short drive brings you to BYU–Hawai‘i, the Polynesian Cultural Center, Turtle Bay Resort, and the North Shore’s world-famous beaches."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "5022.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "3270"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1965"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(8) "Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(6) "Hauula"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(6) "CBPP04"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(30) "crystal.cabansag@cbpacific.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(817) 308-5339"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Crystal Cabansag"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18810924"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-07-06T16:00:01.170"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-06-20"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "16:00:01.170"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27038765"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27038765"
    [1]=>
    string(8) "27038766"
    [2]=>
    string(8) "27038767"
    [3]=>
    string(8) "27038768"
    [4]=>
    string(8) "27038769"
    [5]=>
    string(8) "27038770"
    [6]=>
    string(8) "27038771"
    [7]=>
    string(8) "27038772"
    [8]=>
    string(8) "27038773"
    [9]=>
    string(8) "27038774"
    [10]=>
    string(8) "27038775"
    [11]=>
    string(8) "27038776"
    [12]=>
    string(8) "27038777"
    [13]=>
    string(8) "27038778"
    [14]=>
    string(8) "27038779"
    [15]=>
    string(8) "27038780"
    [16]=>
    string(8) "27038781"
    [17]=>
    string(8) "27038782"
    [18]=>
    string(8) "27038783"
    [19]=>
    string(8) "27038784"
    [20]=>
    string(8) "27038785"
    [21]=>
    string(8) "27038786"
    [22]=>
    string(8) "27038787"
    [23]=>
    string(8) "27038788"
    [24]=>
    string(8) "27038789"
    [25]=>
    string(8) "27038790"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202514196
        )

    [StreetNumber] => Array
        (
            [0] => 54-290
        )

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => More Space. More Flexibility. More Hawai‘i Life. Tucked away at the end of a quiet cul-de-sac in Hau'ula, this spacious 2,335 sq ft 2-story home offers a flexible layout ideal for multi-gen living or rental income. With 3 distinct living areas, there’s room for 'ohana, guests, or work-from-home needs. Fresh interior paint, updated kitchens and baths, and thoughtfully designed spaces add to the appeal.

The main home features 3 bed, 2 baths, and a large bonus room (staged as a 4th bedroom). The kitchen has beautiful blue cabinets, white quartz countertops, new appliances, and flows into the bright living area with tall ceilings and natural light.

Downstairs, a mother-in-law suite with wet bar offers privacy or rental potential. Upstairs, a studio apartment includes a full kitchen and an oversized lanai with mountain views and peekaboo ocean views—perfect for entertaining or unwinding.

Two-car enclosed garage with workshop bay. Just 0.6 miles to Hau'ula Beach Park and close to Pounders Beach, Hau'ula Loop Trail, and everyday essentials. A short drive brings you to BYU–Hawai‘i, the Polynesian Cultural Center, Turtle Bay Resort, and the North Shore’s world-famous beaches.
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => crystal.cabansag@cbpacific.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (817) 308-5339
        )

    [ListAgentFullName] => Array
        (
            [0] => Crystal Cabansag
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-07-06T16:00:01.170
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-06-20
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 16:00:01.170
        )

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

    [listing_image] => Array
        (
            [0] => 27038765
            [1] => 27038766
            [2] => 27038767
            [3] => 27038768
            [4] => 27038769
            [5] => 27038770
            [6] => 27038771
            [7] => 27038772
            [8] => 27038773
            [9] => 27038774
            [10] => 27038775
            [11] => 27038776
            [12] => 27038777
            [13] => 27038778
            [14] => 27038779
            [15] => 27038780
            [16] => 27038781
            [17] => 27038782
            [18] => 27038783
            [19] => 27038784
            [20] => 27038785
            [21] => 27038786
            [22] => 27038787
            [23] => 27038788
            [24] => 27038789
            [25] => 27038790
        )

)

PROPERTY INFO

• BedsTotal: 5
• Full Baths: 4
• Land Area (sf): 5,022 sf
• Living (sf): 3,270
• Year Built: 1965

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 5
• View: Mountain
• Listing Office: Coldwell Banker Realty

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Hauula
• Middle School: Kahuku
• High School: Kahuku

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 6, 2025 - 4: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.