Thanksgiving - The office will be closed on Thursday 11/27/25 and Friday 11/28/25
Christmas - The office will be closed on Thursday 12/25/25 and Friday 12/26/25
New Years - The office will be closed on Thursday 1/1/26 and Friday 1/2/26
45-342 Lilipuna Road Unit 204 Kaneohe, HI 96744
Listing Overview
Price: $465,000 Area: KANEOHE TOWN Status: Active Under Contract
Remodeled from top to bottom, this 2 bed / 1 bath condo offers both Kaneohe Bay and Ko'olau mountain views. The second floor walk-up has a redesigned kitchen with quartz countertops, shaker cabinets, stainless steel appliances, and a peninsula with range/oven. Updates continue throughout with vinyl flooring, smooth ceilings (no popcorn), and refinished brick walls, while the bathroom features new tile and a custom shower. The tiled lanai extends the living space and takes advantage of the cool trade winds. Ceiling fans are installed in each room, and the unit includes one assigned parking stall plus community laundry. Set in Cliff View Terrace at 45-342 Lilipuna Rd, this turnkey home combines modern finishes with an easy location near shopping, dining, and freeway access. Listing by: Compass (808) 825-4277
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202520874"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "45-342"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Lilipuna"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "204"
}
["City"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96744"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "465000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(12) "KANEOHE TOWN"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(782) "Remodeled from top to bottom, this 2 bed / 1 bath condo offers both Kaneohe Bay and Ko'olau mountain views. The second floor walk-up has a redesigned kitchen with quartz countertops, shaker cabinets, stainless steel appliances, and a peninsula with range/oven. Updates continue throughout with vinyl flooring, smooth ceilings (no popcorn), and refinished brick walls, while the bathroom features new tile and a custom shower. The tiled lanai extends the living space and takes advantage of the cool trade winds. Ceiling fans are installed in each room, and the unit includes one assigned parking stall plus community laundry. Set in Cliff View Terrace at 45-342 Lilipuna Rd, this turnkey home combines modern finishes with an easy location near shopping, dining, and freeway access."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "22259.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "714"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1969"
}
["BuildingName"]=>
array(1) {
[0]=>
string(18) "Cliff View Terrace"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(5) "Three"
}
["View"]=>
array(1) {
[0]=>
string(22) "Mountain,Ocean,Sunrise"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "391.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) "COHI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "alesia@barneshawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 825-4277"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Alesia D Barnes"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18993308"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-10-24T12:00:01.770"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-09-26"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "12:00:01.770"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27164718"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27164718"
[1]=>
string(8) "27164719"
[2]=>
string(8) "27164720"
[3]=>
string(8) "27164721"
[4]=>
string(8) "27164722"
[5]=>
string(8) "27164723"
[6]=>
string(8) "27164724"
[7]=>
string(8) "27164725"
[8]=>
string(8) "27164726"
[9]=>
string(8) "27164727"
[10]=>
string(8) "27164728"
[11]=>
string(8) "27164729"
[12]=>
string(8) "27164730"
[13]=>
string(8) "27164731"
[14]=>
string(8) "27164732"
[15]=>
string(8) "27164733"
[16]=>
string(8) "27164734"
[17]=>
string(8) "27164735"
[18]=>
string(8) "27164736"
[19]=>
string(8) "27164737"
[20]=>
string(8) "27164738"
[21]=>
string(8) "27164739"
[22]=>
string(8) "27164740"
[23]=>
string(8) "27164741"
[24]=>
string(8) "27164742"
[25]=>
string(8) "27164743"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202520874
)
[StreetNumber] => Array
(
[0] => 45-342
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Lilipuna
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => 204
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 465000.00
)
[Neighbourhood] => Array
(
[0] => KANEOHE TOWN
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Remodeled from top to bottom, this 2 bed / 1 bath condo offers both Kaneohe Bay and Ko'olau mountain views. The second floor walk-up has a redesigned kitchen with quartz countertops, shaker cabinets, stainless steel appliances, and a peninsula with range/oven. Updates continue throughout with vinyl flooring, smooth ceilings (no popcorn), and refinished brick walls, while the bathroom features new tile and a custom shower. The tiled lanai extends the living space and takes advantage of the cool trade winds. Ceiling fans are installed in each room, and the unit includes one assigned parking stall plus community laundry. Set in Cliff View Terrace at 45-342 Lilipuna Rd, this turnkey home combines modern finishes with an easy location near shopping, dining, and freeway access.
)
[ListOfficeName] => Array
(
[0] => Compass
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 22259.00
)
[SqftTotal] => Array
(
[0] => 714
)
[YearBuilt] => Array
(
[0] => 1969
)
[BuildingName] => Array
(
[0] => Cliff View Terrace
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => Three
)
[View] => Array
(
[0] => Mountain,Ocean,Sunrise
)
[MaintenanceExpense] => Array
(
[0] => 391.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => COHI
)
[ListAgentEmail] => Array
(
[0] => alesia@barneshawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 825-4277
)
[ListAgentFullName] => Array
(
[0] => Alesia D Barnes
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18993308
)
[MatrixModifiedDT] => Array
(
[0] => 2025-10-24T12:00:01.770
)
[ListingContractDate] => Array
(
[0] => 2025-09-26
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 12:00:01.770
)
[_thumbnail_id] => Array
(
[0] => 27164718
)
[listing_image] => Array
(
[0] => 27164718
[1] => 27164719
[2] => 27164720
[3] => 27164721
[4] => 27164722
[5] => 27164723
[6] => 27164724
[7] => 27164725
[8] => 27164726
[9] => 27164727
[10] => 27164728
[11] => 27164729
[12] => 27164730
[13] => 27164731
[14] => 27164732
[15] => 27164733
[16] => 27164734
[17] => 27164735
[18] => 27164736
[19] => 27164737
[20] => 27164738
[21] => 27164739
[22] => 27164740
[23] => 27164741
[24] => 27164742
[25] => 27164743
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on October 24, 2025 - 12:00 PM
Information is deemed reliable but not guaranteed.
Copyright: 2025 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.
