54-016 Pipilani Place Hauula, HI 96717

Listing
Overview

Price: $645,000
Area: HAUULA
Status: Active

Make an offer! Located along Kaipapau stream and just a few houses from the ocean. Short distance to Hauula shopping center. Build your own mini estate. Being sold for land value only. Structure is in teardown condition, unsafe and not accessible. Sold AS IS. Listing by: Summit Realty, LLC (808) 391-1561

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202526339"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "54-016"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Pipilani"
  }
  ["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(9) "645000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "HAUULA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(259) "Make an offer! Located along Kaipapau stream and just a few houses from the ocean. Short distance to Hauula shopping center. Build your own mini estate. Being sold for land value only. Structure is in teardown condition, unsafe and not accessible. Sold AS IS."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(18) "Summit Realty, LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "8034.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "672"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1949"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Tear Down"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(14) "Mountain,Other"
  }
  ["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(4) "SUMR"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(23) "fuku@summitrealtyhi.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 391-1561"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Fukuyuki Puckett"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19144814"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-12-02T15:11:13.313"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-12-01"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(12) "Stream/Canal"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "15:11:13.313"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27235075"
  }
  ["listing_image"]=>
  array(19) {
    [0]=>
    string(8) "27235075"
    [1]=>
    string(8) "27235076"
    [2]=>
    string(8) "27235077"
    [3]=>
    string(8) "27235078"
    [4]=>
    string(8) "27235079"
    [5]=>
    string(8) "27235080"
    [6]=>
    string(8) "27235081"
    [7]=>
    string(8) "27235082"
    [8]=>
    string(8) "27235083"
    [9]=>
    string(8) "27235084"
    [10]=>
    string(8) "27235085"
    [11]=>
    string(8) "27235086"
    [12]=>
    string(8) "27235087"
    [13]=>
    string(8) "27235088"
    [14]=>
    string(8) "27235089"
    [15]=>
    string(8) "27235090"
    [16]=>
    string(8) "27235091"
    [17]=>
    string(8) "27235755"
    [18]=>
    string(8) "27235756"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202526339
        )

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Make an offer! Located along Kaipapau stream and just a few houses from the ocean. Short distance to Hauula shopping center. Build your own mini estate. Being sold for land value only. Structure is in teardown condition, unsafe and not accessible. Sold AS IS.
        )

    [ListOfficeName] => Array
        (
            [0] => Summit Realty, LLC
        )

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Tear Down
        )

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => fuku@summitrealtyhi.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 391-1561
        )

    [ListAgentFullName] => Array
        (
            [0] => Fukuyuki Puckett
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-12-02T15:11:13.313
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-12-01
        )

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

    [PropertyFrontage] => Array
        (
            [0] => Stream/Canal
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 15:11:13.313
        )

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

    [listing_image] => Array
        (
            [0] => 27235075
            [1] => 27235076
            [2] => 27235077
            [3] => 27235078
            [4] => 27235079
            [5] => 27235080
            [6] => 27235081
            [7] => 27235082
            [8] => 27235083
            [9] => 27235084
            [10] => 27235085
            [11] => 27235086
            [12] => 27235087
            [13] => 27235088
            [14] => 27235089
            [15] => 27235090
            [16] => 27235091
            [17] => 27235755
            [18] => 27235756
        )

)

  • BedsTotal: 3
  • Full Baths: 1
  • Land Area (sf): 8,034 sf
  • Living (sf): 672
  • Year Built: 1949

  • Property Condition: Tear Down
  • View: Mountain,Other
  • Listing Office: Summit Realty, LLC

  • 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 2, 2025 - 3:11 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.