Previous Next

54-259 Kaipapau Loop Unit B Hauula, HI 96717

Take a Virtual Tour

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202524351"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "54-259"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Kaipapau"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(4) "Loop"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(1) "B"
  }
  ["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(41) "https://player.vimeo.com/video/1135666595"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1188000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "HAUULA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1149) "DIRECT OCEANFRONT LIVING AND GATED FLAG LOT FOR PRIVACY! Enjoy island country living at its finest in this beautifully renovated oceanfront home located in the serene coastal community of Hau’ula. Step inside to find a bright and breezy open floor plan - ideal for entertaining or quiet seaside living. Large windows and sliding doors fill the home with natural light and cooling trade winds, framing unobstructed ocean views. Enjoy stunning sunrises over the Pacific from the comfort of your living space or the private oceanfront yard and deck. Recent updates showcase fresh interiors with thoughtful details throughout, including brand-new kitchen cabinets and countertops, luxury vinyl plank flooring, and a fully upgraded electrical system. Complementing the 2 bedrooms is your very own dedicated office space - perfect for remote work, creative projects, or quiet study. Additional highlights include direct shoreline access and an existing grandfathered seawall with steps to a backyard fishpond. Experience the charm of this Hau'ula gem as it offers the rare opportunity to live the Hawaiian dream - bright, breezy, and right on the ocean!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "5118.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1131"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1974"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(32) "Coastline,Mountain,Ocean,Sunrise"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["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(6) "CBPP04"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(25) "jason.paulo@cbpacific.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 384-6959"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Jason Paulo"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19067731"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-03-09T13:30:01.860"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-11-10"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Ocean"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "13:30:01.860"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27215986"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27215986"
    [1]=>
    string(8) "27215987"
    [2]=>
    string(8) "27215988"
    [3]=>
    string(8) "27215989"
    [4]=>
    string(8) "27215990"
    [5]=>
    string(8) "27215991"
    [6]=>
    string(8) "27215992"
    [7]=>
    string(8) "27215993"
    [8]=>
    string(8) "27215994"
    [9]=>
    string(8) "27215995"
    [10]=>
    string(8) "27215996"
    [11]=>
    string(8) "27215997"
    [12]=>
    string(8) "27215998"
    [13]=>
    string(8) "27215999"
    [14]=>
    string(8) "27216000"
    [15]=>
    string(8) "27216001"
    [16]=>
    string(8) "27216002"
    [17]=>
    string(8) "27216003"
    [18]=>
    string(8) "27216004"
    [19]=>
    string(8) "27216005"
    [20]=>
    string(8) "27216006"
    [21]=>
    string(8) "27216007"
    [22]=>
    string(8) "27216008"
    [23]=>
    string(8) "27216009"
    [24]=>
    string(8) "27216010"
    [25]=>
    string(8) "27216011"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202524351
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://player.vimeo.com/video/1135666595
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => DIRECT OCEANFRONT LIVING AND GATED FLAG LOT FOR PRIVACY! Enjoy island country living at its finest in this beautifully renovated oceanfront home located in the serene coastal community of Hau’ula. Step inside to find a bright and breezy open floor plan - ideal for entertaining or quiet seaside living. Large windows and sliding doors fill the home with natural light and cooling trade winds, framing unobstructed ocean views. Enjoy stunning sunrises over the Pacific from the comfort of your living space or the private oceanfront yard and deck. Recent updates showcase fresh interiors with thoughtful details throughout, including brand-new kitchen cabinets and countertops, luxury vinyl plank flooring, and a fully upgraded electrical system. Complementing the 2 bedrooms is your very own dedicated office space - perfect for remote work, creative projects, or quiet study. Additional highlights include direct shoreline access and an existing grandfathered seawall with steps to a backyard fishpond. Experience the charm of this Hau'ula gem as it offers the rare opportunity to live the Hawaiian dream - bright, breezy, and right on the ocean!
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => jason.paulo@cbpacific.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 384-6959
        )

    [ListAgentFullName] => Array
        (
            [0] => Jason Paulo
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-03-09T13:30:01.860
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-11-10
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 13:30:01.860
        )

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

    [listing_image] => Array
        (
            [0] => 27215986
            [1] => 27215987
            [2] => 27215988
            [3] => 27215989
            [4] => 27215990
            [5] => 27215991
            [6] => 27215992
            [7] => 27215993
            [8] => 27215994
            [9] => 27215995
            [10] => 27215996
            [11] => 27215997
            [12] => 27215998
            [13] => 27215999
            [14] => 27216000
            [15] => 27216001
            [16] => 27216002
            [17] => 27216003
            [18] => 27216004
            [19] => 27216005
            [20] => 27216006
            [21] => 27216007
            [22] => 27216008
            [23] => 27216009
            [24] => 27216010
            [25] => 27216011
        )

)

PROPERTY INFO

• BedsTotal: 2
• Full Baths: 2
• Land Area (sf): 5,118 sf
• Living (sf): 1,131
• Year Built: 1974

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 3
• View: Coastline,Mountain,Ocean,Sunrise
• Listing Office: Coldwell Banker Realty

FINANCIAL INFO

• 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 9, 2026 - 1:30 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.