54-259 Kaipapau Loop Unit B Hauula, HI 96717

Take a Virtual Tour

Listing
Overview

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

Enjoy island country living at its finest in this beautifully renovated oceanfront home located in the serene coastal community of Hau‘ula. This 2-bedroom, 2- bathroom home, with a separate office, offers a relaxed island style feel. 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 and breathtaking sunrises over the Pacific. The new renovations showcase fresh interiors with thoughtful details throughout, including a brand new kitchen, new luxury vinyl plank flooring, and a completely updated electrical system. The living and dining areas flow seamlessly onto a private oceanfront yard and deck - perfect for morning coffee or evening relaxation as the waves roll in. 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! Listing by: Coldwell Banker Realty (808) 384-6959

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(999) "Enjoy island country living at its finest in this beautifully renovated oceanfront home located in the serene coastal community of Hau‘ula. This 2-bedroom, 2- bathroom home, with a separate office, offers a relaxed island style feel. 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 and breathtaking sunrises over the Pacific. The new renovations showcase fresh interiors with thoughtful details throughout, including a brand new kitchen, new luxury vinyl plank flooring, and a completely updated electrical system. The living and dining areas flow seamlessly onto a private oceanfront yard and deck - perfect for morning coffee or evening relaxation as the waves roll in. 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) "2025-12-15T12:15:01.443"
  }
  ["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) "12:15:01.443"
  }
  ["_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] => Enjoy island country living at its finest in this beautifully renovated oceanfront home located in the serene coastal community of Hau‘ula. This 2-bedroom, 2- bathroom home, with a separate office, offers a relaxed island style feel. 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 and breathtaking sunrises over the Pacific. The new renovations showcase fresh interiors with thoughtful details throughout, including a brand new kitchen, new luxury vinyl plank flooring, and a completely updated electrical system. The living and dining areas flow seamlessly onto a private oceanfront yard and deck - perfect for morning coffee or evening relaxation as the waves roll in. 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] => 2025-12-15T12:15:01.443
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 12:15:01.443
        )

    [_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
        )

)

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

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

  • Land Tenure: FS - Fee Simple

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 December 15, 2025 - 12:15 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.

© Marcus Realty. All Rights Reserved.