Listing
Overview
Price: $749,500
Area: WAIALUA
Status: Active
Modern, beautifully renovated 2-bed, 2.5-bath North Shore home with a versatile first-floor bonus room ideal for an office or guest space, and full bath. The primary bedroom upstairs features a partial walk-in closet; the second bedroom offers stunning Mount Ka’ala views from the window. Each bedroom has its own private vanity and toilet areas, connected to a shared bathroom with tub/shower, providing added privacy and convenience. With a private outdoor area and 2 parking spaces, this home is conveniently located near public beach access and Aweoweo Beach Park, known for its calm turquoise waters and playground. Close to Haleiwa town, world-class surf, schools, nearby hiking trails and a bike path, with easy freeway access for commuting to town and military bases. Listing by: Sterman Realty (808) 371-4622
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202617758"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "68-037"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Apuhihi"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(1) "D"
}
["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(67) "https://tour.giraffe360.com/2124b91508bd43aa960b2e8b042d8e7f/?lsf=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "749500.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(777) "Modern, beautifully renovated 2-bed, 2.5-bath North Shore home with a versatile first-floor bonus room ideal for an office or guest space, and full bath. The primary bedroom upstairs features a partial walk-in closet; the second bedroom offers stunning Mount Ka’ala views from the window. Each bedroom has its own private vanity and toilet areas, connected to a shared bathroom with tub/shower, providing added privacy and convenience. With a private outdoor area and 2 parking spaces, this home is conveniently located near public beach access and Aweoweo Beach Park, known for its calm turquoise waters and playground. Close to Haleiwa town, world-class surf, schools, nearby hiking trails and a bike path, with easy freeway access for commuting to town and military bases."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(14) "Sterman Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "10934.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1052"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1993"
}
["BuildingName"]=>
array(1) {
[0]=>
string(13) "Waialua Palms"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "921.00"
}
["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) "STER"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(17) "david@sterman.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 371-4622"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "David J Sterman"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19720661"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2026-09-20T17:00:02.150"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2026-09-17"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "17:00:02.150"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27527641"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27527641"
[1]=>
string(8) "27527642"
[2]=>
string(8) "27527643"
[3]=>
string(8) "27527644"
[4]=>
string(8) "27527645"
[5]=>
string(8) "27527646"
[6]=>
string(8) "27527647"
[7]=>
string(8) "27527648"
[8]=>
string(8) "27527649"
[9]=>
string(8) "27527650"
[10]=>
string(8) "27527651"
[11]=>
string(8) "27527652"
[12]=>
string(8) "27527653"
[13]=>
string(8) "27527654"
[14]=>
string(8) "27527655"
[15]=>
string(8) "27527656"
[16]=>
string(8) "27527657"
[17]=>
string(8) "27527658"
[18]=>
string(8) "27527659"
[19]=>
string(8) "27527660"
[20]=>
string(8) "27527661"
[21]=>
string(8) "27527662"
[22]=>
string(8) "27527663"
[23]=>
string(8) "27527664"
[24]=>
string(8) "27527665"
[25]=>
string(8) "27527666"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202617758
)
[StreetNumber] => Array
(
[0] => 68-037
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Apuhihi
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => D
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://tour.giraffe360.com/2124b91508bd43aa960b2e8b042d8e7f/?lsf=1
)
[ListPrice] => Array
(
[0] => 749500.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Modern, beautifully renovated 2-bed, 2.5-bath North Shore home with a versatile first-floor bonus room ideal for an office or guest space, and full bath. The primary bedroom upstairs features a partial walk-in closet; the second bedroom offers stunning Mount Ka’ala views from the window. Each bedroom has its own private vanity and toilet areas, connected to a shared bathroom with tub/shower, providing added privacy and convenience. With a private outdoor area and 2 parking spaces, this home is conveniently located near public beach access and Aweoweo Beach Park, known for its calm turquoise waters and playground. Close to Haleiwa town, world-class surf, schools, nearby hiking trails and a bike path, with easy freeway access for commuting to town and military bases.
)
[ListOfficeName] => Array
(
[0] => Sterman Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 10934.00
)
[SqftTotal] => Array
(
[0] => 1052
)
[YearBuilt] => Array
(
[0] => 1993
)
[BuildingName] => Array
(
[0] => Waialua Palms
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] => 921.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialua
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => STER
)
[ListAgentEmail] => Array
(
[0] => david@sterman.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 371-4622
)
[ListAgentFullName] => Array
(
[0] => David J Sterman
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19720661
)
[MatrixModifiedDT] => Array
(
[0] => 2026-09-20T17:00:02.150
)
[ListingContractDate] => Array
(
[0] => 2026-09-17
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:02.150
)
[_thumbnail_id] => Array
(
[0] => 27527641
)
[listing_image] => Array
(
[0] => 27527641
[1] => 27527642
[2] => 27527643
[3] => 27527644
[4] => 27527645
[5] => 27527646
[6] => 27527647
[7] => 27527648
[8] => 27527649
[9] => 27527650
[10] => 27527651
[11] => 27527652
[12] => 27527653
[13] => 27527654
[14] => 27527655
[15] => 27527656
[16] => 27527657
[17] => 27527658
[18] => 27527659
[19] => 27527660
[20] => 27527661
[21] => 27527662
[22] => 27527663
[23] => 27527664
[24] => 27527665
[25] => 27527666
)
)
- BedsTotal: 2
- Full Baths: 2
- Half Baths: 1
- Land Area (sf): 10,934 sf
- Living (sf): 1,052
- Year Built: 1993
- Building Name: Waialua Palms
- Property Condition: Excellent
- Number of Parking Spaces: 2
- View: Mountain
- Listing Office: Sterman Realty
- Maintenance Fees: $921
- Land Tenure: FS - Fee Simple
- Elementary School: Waialua
- Middle School: Waialua
- High School: Waialua
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on September 20, 2026 - 5:00 PM
Information is deemed reliable but not guaranteed.
Copyright: 2026 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.
© Marcus Realty. All Rights Reserved.
