Previous Next

59-043 Huelo Street Unit PRKG Haleiwa, HI 96712

Listing
Overview

Price: $1,240,000
Area: SUNSET AREA
Status: Active

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202406275"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "59-043"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(5) "Huelo"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "PRKG"
  }
  ["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(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1240000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(11) "SUNSET AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(441) "Beautiful beachside home at world famous Sunset Point. This is like a single family residence except for the association as there are no adjoining walls! First floor bedrooms (third actually a den), two baths plus wet bar and laundry room. Stunning views from the second floor and an entertaining area with kitchen and dining area that flows to the covered lanai also with extra dining and powder bath. The fantastic ocean views and sunsets."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(27) "Hawaii 5-0 Properties, Inc."
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "27966.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2118"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1985"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(18) "Sunset Beach Vista"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(12) "Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "935.36"
  }
  ["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) "HAFO"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(19) "ryota@hi50group.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 954-9691"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(10) "Ryota Seki"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-02-23T17:35:42.237"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17884483"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26127279"
  }
  ["listing_image"]=>
  array(20) {
    [0]=>
    string(8) "26127279"
    [1]=>
    string(8) "26127280"
    [2]=>
    string(8) "26127281"
    [3]=>
    string(8) "26127282"
    [4]=>
    string(8) "26127283"
    [5]=>
    string(8) "26127284"
    [6]=>
    string(8) "26127285"
    [7]=>
    string(8) "26127286"
    [8]=>
    string(8) "26127287"
    [9]=>
    string(8) "26127288"
    [10]=>
    string(8) "26127289"
    [11]=>
    string(8) "26127290"
    [12]=>
    string(8) "26127291"
    [13]=>
    string(8) "26127292"
    [14]=>
    string(8) "26127293"
    [15]=>
    string(8) "26127294"
    [16]=>
    string(8) "26127295"
    [17]=>
    string(8) "26127296"
    [18]=>
    string(8) "26127297"
    [19]=>
    string(8) "26127298"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-03-12"
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "17:35:42.237"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202406275
        )

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

    [PropertyType] => Array
        (
            [0] => Condo/Townhouse
        )

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Beautiful beachside home at world famous Sunset Point. This is like a single family residence except for the association as there are no adjoining walls! First floor bedrooms (third actually a den), two baths plus wet bar and laundry room. Stunning views from the second floor and an entertaining area with kitchen and dining area that flows to the covered lanai also with extra dining and powder bath. The fantastic ocean views and sunsets.
        )

    [ListOfficeName] => Array
        (
            [0] => Hawaii 5-0 Properties, Inc.
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Sunset Beach Vista
        )

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => ryota@hi50group.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 954-9691
        )

    [ListAgentFullName] => Array
        (
            [0] => Ryota Seki
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-02-23T17:35:42.237
        )

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

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

    [MLSAreaMajor] => Array
        (
            [0] => North Shore
        )

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

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

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

    [listing_image] => Array
        (
            [0] => 26127279
            [1] => 26127280
            [2] => 26127281
            [3] => 26127282
            [4] => 26127283
            [5] => 26127284
            [6] => 26127285
            [7] => 26127286
            [8] => 26127287
            [9] => 26127288
            [10] => 26127289
            [11] => 26127290
            [12] => 26127291
            [13] => 26127292
            [14] => 26127293
            [15] => 26127294
            [16] => 26127295
            [17] => 26127296
            [18] => 26127297
            [19] => 26127298
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-03-12
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 17:35:42.237
        )

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

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 2
• Half Baths: 1
• Land Area (sf): 27,966 sf
• Living (sf): 2,118
• Year Built: 1985
• Building Name: Sunset Beach Vista

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 2
• View: Ocean,Sunset
• Listing Office: Hawaii 5-0 Properties, Inc.

FINANCIAL INFO

• Maintenance Fees: $935
• 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 February 23, 2025 - 5:35 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.