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
        )

)

  • BedsTotal: 2
  • Full Baths: 1
  • Land Area (sf): 22,259 sf
  • Living (sf): 714
  • Year Built: 1969
  • Building Name: Cliff View Terrace

  • Property Condition: Excellent,Above Average
  • Number of Parking Spaces: 1
  • View: Mountain,Ocean,Sunrise
  • Listing Office: Compass

  • Maintenance Fees: $391
  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446

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.

© Marcus Realty. All Rights Reserved.