59-043 Huelo Street Unit PRKG Haleiwa, HI 96712
Listing
Overview
Price: $1,240,000
Area: SUNSET AREA
Status: Active
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. Listing by: Hawaii 5-0 Properties, Inc. (808) 954-9691
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] =>
)
)
- 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
- Property Condition: Above Average
- Number of Parking Spaces: 2
- View: Ocean,Sunset
- Listing Office: Hawaii 5-0 Properties, Inc.
- Maintenance Fees: $935
- Land Tenure: FS - Fee Simple
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.
