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
