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(45) {
["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]=>
string(10) "1240000.00"
}
["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) "2024-09-01T12:57:33.967"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17884483"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-03-13T08:46:43.030"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_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"
}
}
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] => 1240000.00
)
[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] => 2024-09-01T12:57:33.967
)
[Matrix_Unique_ID] => Array
(
[0] => 17884483
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-03-13T08:46:43.030
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_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
)
)
- BedsTotal: 3
- Full Baths: 2
- Half Baths: 1
- Land Area (sf): 27,966
- 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
