54-18 Haukoi Place Hauula, HI 96717

Listing
Overview

Price: $1,250,000
Area: HAUULA
Status: Sold (Limited photos per MLS privacy policy)

Lovely home with potential to provide great rental income or can be used as multi-generational home. Potential to have 3 rentals in this unit! This is a Extra Large LEGAL PERMITTED Duplex. Main house has 5 bedrooms and 3 full baths. Above the oversized 2 car gargae is a separate 1 Bdrm, 1 Bath rental unit with partial ocean views. Enclosed garage with space for additional workshop area. Carpeting, tile, laminate flooring. Located on a quiet dead end street right across from Tamura's & Long's Drugs, 3 homes from beach access path & minutes to other shopping, schools, BYU, City & School Bus stop located just steps away. Excellent investment opportunity! Land Tenure: FS - Fee Simple. Agent is owner. Contact agent for Lockbox code. Listing by: Marlene's Realty, Inc. (808) 293-2413 

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202514695"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(5) "54-18"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Haukoi"
  }
  ["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) "1250000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "HAUULA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(737) "Lovely home with potential to provide great rental income or can be used as multi-generational home. Potential to have 3 rentals in this unit! This is a Extra Large LEGAL PERMITTED Duplex. Main house has 5 bedrooms and 3 full baths. Above the oversized 2 car gargae is a separate 1 Bdrm, 1 Bath rental unit with partial ocean views. Enclosed garage with space for additional workshop area. Carpeting, tile, laminate flooring. Located on a quiet dead end street right across from Tamura's & Long's Drugs, 3 homes from beach access path & minutes to other shopping, schools, BYU, City & School Bus stop located just steps away. Excellent investment opportunity! Land Tenure: FS - Fee Simple. Agent is owner. Contact agent for Lockbox code."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Marlene's Realty, Inc."
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "7872.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2884"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2000"
  }
  ["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(14) "Mountain,Ocean"
  }
  ["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(4) "MARL"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(18) "mealoham@yahoo.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 293-2413"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Wendi Vivas"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-10-08"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18825591"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-10-17T10:33:03.527"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-06-23"
  }
  ["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) "10:33:03.527"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27041847"
  }
  ["listing_image"]=>
  array(23) {
    [0]=>
    string(8) "27041847"
    [1]=>
    string(8) "27041848"
    [2]=>
    string(8) "27041849"
    [3]=>
    string(8) "27041850"
    [4]=>
    string(8) "27041851"
    [5]=>
    string(8) "27041852"
    [6]=>
    string(8) "27041853"
    [7]=>
    string(8) "27041854"
    [8]=>
    string(8) "27041855"
    [9]=>
    string(8) "27041856"
    [10]=>
    string(8) "27041857"
    [11]=>
    string(8) "27041858"
    [12]=>
    string(8) "27041859"
    [13]=>
    string(8) "27041860"
    [14]=>
    string(8) "27041861"
    [15]=>
    string(8) "27041862"
    [16]=>
    string(8) "27041863"
    [17]=>
    string(8) "27041864"
    [18]=>
    string(8) "27041865"
    [19]=>
    string(8) "27041866"
    [20]=>
    string(8) "27041867"
    [21]=>
    string(8) "27041868"
    [22]=>
    string(8) "27041869"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202514695
        )

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Lovely home with potential to provide great rental income or can be used as multi-generational home. Potential to have 3 rentals in this unit! This is a Extra Large LEGAL PERMITTED Duplex. Main house has 5 bedrooms and 3 full baths. Above the oversized 2 car gargae is a separate 1 Bdrm, 1 Bath rental unit with partial ocean views. Enclosed garage with space for additional workshop area. Carpeting, tile, laminate flooring. Located on a quiet dead end street right across from Tamura's & Long's Drugs, 3 homes from beach access path & minutes to other shopping, schools, BYU, City & School Bus stop located just steps away. Excellent investment opportunity! Land Tenure: FS - Fee Simple. Agent is owner. Contact agent for Lockbox code.
        )

    [ListOfficeName] => Array
        (
            [0] => Marlene's Realty, Inc.
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => mealoham@yahoo.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 293-2413
        )

    [ListAgentFullName] => Array
        (
            [0] => Wendi Vivas
        )

    [CloseDate] => Array
        (
            [0] => 2025-10-08
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-10-17T10:33:03.527
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 10:33:03.527
        )

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

    [listing_image] => Array
        (
            [0] => 27041847
            [1] => 27041848
            [2] => 27041849
            [3] => 27041850
            [4] => 27041851
            [5] => 27041852
            [6] => 27041853
            [7] => 27041854
            [8] => 27041855
            [9] => 27041856
            [10] => 27041857
            [11] => 27041858
            [12] => 27041859
            [13] => 27041860
            [14] => 27041861
            [15] => 27041862
            [16] => 27041863
            [17] => 27041864
            [18] => 27041865
            [19] => 27041866
            [20] => 27041867
            [21] => 27041868
            [22] => 27041869
        )

)

  • BedsTotal: 6
  • Full Baths: 4
  • Land Area (sf): 7,872 sf
  • Living (sf): 2,884
  • Year Built: 2000

  • Property Condition: Above Average
  • Number of Parking Spaces: 5
  • View: Mountain,Ocean
  • Listing Office: Marlene's Realty, Inc.

  • Land Tenure: FS - Fee Simple

  • 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 October 17, 2025 - 10:33 AM 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.

Terms of Use Privacy Policy DMCA Policy
© Marcus Realty. All Rights Reserved.