Listing
Overview
Price: $889,000
Area: WAIALUA
Status: Active
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) 825-4277
array(45) {
["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) "889000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "889000.00"
}
["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) 825-4277"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Orion R Barels"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-21T11:59:52.130"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18261216"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-15T14:17:37.463"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_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"
}
}
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] => 889000.00
)
[CurrentPrice] => Array
(
[0] => 889000.00
)
[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) 825-4277
)
[ListAgentFullName] => Array
(
[0] => Orion R Barels
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-21T11:59:52.130
)
[Matrix_Unique_ID] => Array
(
[0] => 18261216
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-15T14:17:37.463
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_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
)
)
- BedsTotal: 2
- Full Baths: 2
- Living (sf): 860
- Year Built: 1982
- Building Name: Sunset Shores
- Property Condition: Above Average
- Number of Parking Spaces: 2
- View: Coastline,Ocean,Sunset
- Listing Office: Compass
- Maintenance Fees: $1,050
- Land Tenure: FS - Fee Simple
- Elementary School: Waialua
- Middle School: Waialua
- High School: Waialua
