59-047 Hoalua Street Haleiwa, HI 96712

Take a Virtual Tour

Listing
Overview

Price: $2,950,000
Area: SUNSET AREA
Status: Active

Incredible opportunity to own a 15000 sq. ft. level lot -fee simple- R-5- with a spacious duplex located in the world-famous Sunset Beach neighborhood. Features include: Minutes to incredible surf beaches, skate park and Foodland. There is an outdoor shower to rinse off after you return from your ocean adventure! The home itself is older, however, very livable until one decides how they will redo the home to their personal needs. A Must-See. Property to be sold in AS IS condition. Seller is participating in a 1031 tax deferred exchange at no expense to the buyer. Listing by: Marianne Abrigo Properties (808) 637-3511

array(42) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202303469"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "59-047"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Hoalua"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96712"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(52) "https://tours.propertyphotoshawaii.com/2154500?idx=1"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "2950000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "2950000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(11) "SUNSET AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(569) "Incredible opportunity to own a 15000 sq. ft. level lot -fee simple- R-5- with a spacious duplex located in the world-famous Sunset Beach neighborhood. Features include: Minutes to incredible surf beaches, skate park and Foodland. There is an outdoor shower to rinse off after you return from your ocean adventure! The home itself is older, however, very livable until one decides how they will redo the home to their personal needs. A Must-See. Property to be sold in AS IS condition. Seller is participating in a 1031 tax deferred exchange at no expense to the buyer."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(26) "Marianne Abrigo Properties"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "15000.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1798"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1943"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(7) "Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(6) "Garden"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["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) "ABRI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(18) "mabrigo222@aol.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 637-3511"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(17) "Marianne M Abrigo"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2023-07-17T08:16:04.153"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17162653"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-03-02T13:13:46.900"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25839328"
  }
  ["listing_image"]=>
  array(22) {
    [0]=>
    string(8) "25839328"
    [1]=>
    string(8) "25839329"
    [2]=>
    string(8) "25839330"
    [3]=>
    string(8) "25839331"
    [4]=>
    string(8) "25839332"
    [5]=>
    string(8) "25839333"
    [6]=>
    string(8) "25839334"
    [7]=>
    string(8) "25839335"
    [8]=>
    string(8) "25839336"
    [9]=>
    string(8) "25839337"
    [10]=>
    string(8) "25839338"
    [11]=>
    string(8) "25839339"
    [12]=>
    string(8) "25839340"
    [13]=>
    string(8) "25839341"
    [14]=>
    string(8) "25839342"
    [15]=>
    string(8) "25839343"
    [16]=>
    string(8) "25839344"
    [17]=>
    string(8) "25839345"
    [18]=>
    string(8) "25839346"
    [19]=>
    string(8) "25839347"
    [20]=>
    string(8) "25839348"
    [21]=>
    string(8) "25839349"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202303469
        )

    [StreetNumber] => Array
        (
            [0] => 59-047
        )

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://tours.propertyphotoshawaii.com/2154500?idx=1
        )

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

    [CurrentPrice] => Array
        (
            [0] => 2950000.00
        )

    [Neighbourhood] => Array
        (
            [0] => SUNSET AREA
        )

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

    [PublicRemarks] => Array
        (
            [0] => Incredible opportunity to own a 15000 sq. ft. level lot -fee simple- R-5- with a spacious duplex located in the world-famous Sunset Beach neighborhood. Features include: Minutes to incredible surf beaches, skate park and Foodland. There is an outdoor shower to rinse off after you return from your ocean adventure! The home itself is older, however, very livable until one decides how they will redo the home to their personal needs. A Must-See. Property to be sold in AS IS condition. Seller is participating in a 1031 tax deferred exchange at no expense to the buyer.
        )

    [ListOfficeName] => Array
        (
            [0] => Marianne Abrigo Properties
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => mabrigo222@aol.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 637-3511
        )

    [ListAgentFullName] => Array
        (
            [0] => Marianne M Abrigo
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2023-07-17T08:16:04.153
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-03-02T13:13:46.900
        )

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

    [listing_image] => Array
        (
            [0] => 25839328
            [1] => 25839329
            [2] => 25839330
            [3] => 25839331
            [4] => 25839332
            [5] => 25839333
            [6] => 25839334
            [7] => 25839335
            [8] => 25839336
            [9] => 25839337
            [10] => 25839338
            [11] => 25839339
            [12] => 25839340
            [13] => 25839341
            [14] => 25839342
            [15] => 25839343
            [16] => 25839344
            [17] => 25839345
            [18] => 25839346
            [19] => 25839347
            [20] => 25839348
            [21] => 25839349
        )

)

  • BedsTotal: 5
  • Full Baths: 2
  • Land Area (sf): 15,000
  • Living (sf): 1,798
  • Year Built: 1943

  • Property Condition: Average
  • Number of Parking Spaces: 4
  • View: Garden
  • Listing Office: Marianne Abrigo Properties

  • Maintenance Fees: $0
  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446