Escape to this oceanfront condo on Oahu’s North Shore and discover the magic of beachfront living! This cozy yet modern 2-bed, 2-bath, 2 PARKING unit on the third floor of the desirable Sunset Shores building offers breathtaking ocean views from Ka’ena Point to Waimea Bay. Start your day with the sound of the waves and enjoy the trade wind breezes from your Juliet balcony. The partially furnished unit features newer stainless-steel appliances, an in-unit washer/dryer, and a bright, open layout. This secure well managed oceanfront building combines the nostalgic charm of old Hawaii with modern amenities, including a secured lobby, open-air hallways, a saltwater pool, hot tub, and oceanfront BBQ area. A rare highlight is the two tandem parking spaces assigned to the unit. Step outside to explore miles of secluded Mokuleia white sand beaches or enjoy snorkeling, surfing, and hiking right practically at your doorstep. Just a short drive to charming Haleiwa Town, you’ll have access to world-class dining, surfing, and local farmers' markets without the hassle of North Shore traffic. Conveniently located 35 minutes from Honolulu International Airport. Come see this gem before its gone. Listing by: Compass (808) 228-7195
array(46) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202421034"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "68-121"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(2) "Au"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "303"
}
["City"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96791"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(74) "https://shoots.styronphoto.com/videos/0191f179-e4fc-7023-a5af-97982b2a2212"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "869000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1203) "Escape to this oceanfront condo on Oahu’s North Shore and discover the magic of beachfront living! This cozy yet modern 2-bed, 2-bath, 2 PARKING unit on the third floor of the desirable Sunset Shores building offers breathtaking ocean views from Ka’ena Point to Waimea Bay. Start your day with the sound of the waves and enjoy the trade wind breezes from your Juliet balcony. The partially furnished unit features newer stainless-steel appliances, an in-unit washer/dryer, and a bright, open layout. This secure well managed oceanfront building combines the nostalgic charm of old Hawaii with modern amenities, including a secured lobby, open-air hallways, a saltwater pool, hot tub, and oceanfront BBQ area. A rare highlight is the two tandem parking spaces assigned to the unit. Step outside to explore miles of secluded Mokuleia white sand beaches or enjoy snorkeling, surfing, and hiking right practically at your doorstep. Just a short drive to charming Haleiwa Town, you’ll have access to world-class dining, surfing, and local farmers' markets without the hassle of North Shore traffic. Conveniently located 35 minutes from Honolulu International Airport. Come see this gem before its gone."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "860"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1982"
}
["BuildingName"]=>
array(1) {
[0]=>
string(13) "Sunset Shores"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "4-7"
}
["View"]=>
array(1) {
[0]=>
string(22) "Coastline,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1049.83"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "COHI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "orion@coastalhawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 228-7195"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Orion R Barels"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-04T16:32:59.180"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18261216"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26695818"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26695818"
[1]=>
string(8) "26695819"
[2]=>
string(8) "26695820"
[3]=>
string(8) "26695821"
[4]=>
string(8) "26695822"
[5]=>
string(8) "26695823"
[6]=>
string(8) "26695824"
[7]=>
string(8) "26695825"
[8]=>
string(8) "26695826"
[9]=>
string(8) "26695827"
[10]=>
string(8) "26695828"
[11]=>
string(8) "26695829"
[12]=>
string(8) "26695830"
[13]=>
string(8) "26695831"
[14]=>
string(8) "26695832"
[15]=>
string(8) "26695833"
[16]=>
string(8) "26695834"
[17]=>
string(8) "26695835"
[18]=>
string(8) "26695836"
[19]=>
string(8) "26695837"
[20]=>
string(8) "26695838"
[21]=>
string(8) "26695839"
[22]=>
string(8) "26695840"
[23]=>
string(8) "26695841"
[24]=>
string(8) "26695842"
[25]=>
string(8) "26695843"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-09-15"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202421034
)
[StreetNumber] => Array
(
[0] => 68-121
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Au
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 303
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://shoots.styronphoto.com/videos/0191f179-e4fc-7023-a5af-97982b2a2212
)
[ListPrice] => Array
(
[0] => 869000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Escape to this oceanfront condo on Oahu’s North Shore and discover the magic of beachfront living! This cozy yet modern 2-bed, 2-bath, 2 PARKING unit on the third floor of the desirable Sunset Shores building offers breathtaking ocean views from Ka’ena Point to Waimea Bay. Start your day with the sound of the waves and enjoy the trade wind breezes from your Juliet balcony. The partially furnished unit features newer stainless-steel appliances, an in-unit washer/dryer, and a bright, open layout. This secure well managed oceanfront building combines the nostalgic charm of old Hawaii with modern amenities, including a secured lobby, open-air hallways, a saltwater pool, hot tub, and oceanfront BBQ area. A rare highlight is the two tandem parking spaces assigned to the unit. Step outside to explore miles of secluded Mokuleia white sand beaches or enjoy snorkeling, surfing, and hiking right practically at your doorstep. Just a short drive to charming Haleiwa Town, you’ll have access to world-class dining, surfing, and local farmers' markets without the hassle of North Shore traffic. Conveniently located 35 minutes from Honolulu International Airport. Come see this gem before its gone.
)
[ListOfficeName] => Array
(
[0] => Compass
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 860
)
[YearBuilt] => Array
(
[0] => 1982
)
[BuildingName] => Array
(
[0] => Sunset Shores
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => 4-7
)
[View] => Array
(
[0] => Coastline,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 1049.83
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialua
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => COHI
)
[ListAgentEmail] => Array
(
[0] => orion@coastalhawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 228-7195
)
[ListAgentFullName] => Array
(
[0] => Orion R Barels
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-04T16:32:59.180
)
[Matrix_Unique_ID] => Array
(
[0] => 18261216
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26695818
)
[listing_image] => Array
(
[0] => 26695818
[1] => 26695819
[2] => 26695820
[3] => 26695821
[4] => 26695822
[5] => 26695823
[6] => 26695824
[7] => 26695825
[8] => 26695826
[9] => 26695827
[10] => 26695828
[11] => 26695829
[12] => 26695830
[13] => 26695831
[14] => 26695832
[15] => 26695833
[16] => 26695834
[17] => 26695835
[18] => 26695836
[19] => 26695837
[20] => 26695838
[21] => 26695839
[22] => 26695840
[23] => 26695841
[24] => 26695842
[25] => 26695843
)
[ListingContractDate] => Array
(
[0] => 2024-09-15
)
)
