235 Kuahiwi Avenue Wahiawa, HI 96786

Listing
Overview

Price: $1,380,000
Area: WAHIAWA AREA
Status: Active

Stunning newly built two-story single-family home offering an expansive layout with 5 bedrooms, 4 full bathrooms, and a 2-car garage. Designed with both functionality and luxury. The first floor features 2 bedrooms, 2 full bathrooms, and a convenient wet bar, all accentuated by elegant ceramic tile flooring. The second floor continues to impress with 3 bedrooms, 2 bathrooms, and a large open kitchen featuring premium finishes and vinyl plank flooring. This modern masterpiece is designed for comfort and style, with an open-concept layout that seamlessly blends the living, dining, and kitchen areas. Each floor is thoughtfully crafted to provide ample space and versatility, with luxurious finishes throughout. Indoor split A/C units keep the home comfortable year-round, the living & primary bedroom at upstairs are enhanced by a fascinating suspended ceiling with amazing ceiling lights, elevating the home's aesthetic appeal. Enjoy the tranquility of this location while being just minutes away from local amenities, schools, dining, and the vibrant Wahiawa Freshwater State Recreation Area. Don’t miss this rare opportunity to own a piece of paradise in a prime location. Listing by: Coldwell Banker Realty (808) 262-3104

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202418689"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(3) "235"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Kuahiwi"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Avenue"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Wahiawa"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96786"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1380000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1380000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(12) "WAHIAWA AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1185) "Stunning newly built two-story single-family home offering an expansive layout with 5 bedrooms, 4 full bathrooms, and a  2-car garage. Designed with both functionality and luxury.  The first floor features 2 bedrooms, 2 full bathrooms, and a convenient wet bar, all accentuated by elegant ceramic tile flooring. The second floor continues to impress with 3 bedrooms, 2 bathrooms, and a large open kitchen featuring premium finishes and vinyl plank flooring. This modern masterpiece is designed for comfort and style, with an open-concept layout that seamlessly blends the living, dining, and kitchen areas. Each floor is thoughtfully crafted to provide ample space and versatility, with luxurious finishes throughout. Indoor split A/C units keep the home comfortable year-round, the living & primary bedroom at upstairs  are enhanced by a fascinating suspended ceiling with amazing ceiling lights, elevating the home's aesthetic appeal. Enjoy the tranquility of this location while being just minutes away from local amenities, schools, dining, and the vibrant Wahiawa Freshwater State Recreation Area. Don’t miss this rare opportunity to own a piece of paradise in a prime location."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "5700.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2965"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2022"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["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(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["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(6) "CBPP04"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "marina.wang@cbrealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 262-3104"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Marina Wang"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-11-13T12:30:00.927"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18213168"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-08-30T14:20:36.093"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Central"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26676814"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26676814"
    [1]=>
    string(8) "26676815"
    [2]=>
    string(8) "26676816"
    [3]=>
    string(8) "26676817"
    [4]=>
    string(8) "26676818"
    [5]=>
    string(8) "26676819"
    [6]=>
    string(8) "26676820"
    [7]=>
    string(8) "26676821"
    [8]=>
    string(8) "26676822"
    [9]=>
    string(8) "26676823"
    [10]=>
    string(8) "26676824"
    [11]=>
    string(8) "26676825"
    [12]=>
    string(8) "26676826"
    [13]=>
    string(8) "26676827"
    [14]=>
    string(8) "26676828"
    [15]=>
    string(8) "26676829"
    [16]=>
    string(8) "26676830"
    [17]=>
    string(8) "26676831"
    [18]=>
    string(8) "26676832"
    [19]=>
    string(8) "26676833"
    [20]=>
    string(8) "26676834"
    [21]=>
    string(8) "26676835"
    [22]=>
    string(8) "26676836"
    [23]=>
    string(8) "26676837"
    [24]=>
    string(8) "26676838"
    [25]=>
    string(8) "26676839"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202418689
        )

    [StreetNumber] => Array
        (
            [0] => 235
        )

    [PropertyType] => Array
        (
            [0] => Single Family
        )

    [StreetName] => Array
        (
            [0] => Kuahiwi
        )

    [StreetSuffix] => Array
        (
            [0] => Avenue
        )

    [UnitNumber] => Array
        (
            [0] => 
        )

    [City] => Array
        (
            [0] => Wahiawa
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96786
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 1380000.00
        )

    [CurrentPrice] => Array
        (
            [0] => 1380000.00
        )

    [Neighbourhood] => Array
        (
            [0] => WAHIAWA AREA
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => Stunning newly built two-story single-family home offering an expansive layout with 5 bedrooms, 4 full bathrooms, and a  2-car garage. Designed with both functionality and luxury.  The first floor features 2 bedrooms, 2 full bathrooms, and a convenient wet bar, all accentuated by elegant ceramic tile flooring. The second floor continues to impress with 3 bedrooms, 2 bathrooms, and a large open kitchen featuring premium finishes and vinyl plank flooring. This modern masterpiece is designed for comfort and style, with an open-concept layout that seamlessly blends the living, dining, and kitchen areas. Each floor is thoughtfully crafted to provide ample space and versatility, with luxurious finishes throughout. Indoor split A/C units keep the home comfortable year-round, the living & primary bedroom at upstairs  are enhanced by a fascinating suspended ceiling with amazing ceiling lights, elevating the home's aesthetic appeal. Enjoy the tranquility of this location while being just minutes away from local amenities, schools, dining, and the vibrant Wahiawa Freshwater State Recreation Area. Don’t miss this rare opportunity to own a piece of paradise in a prime location.
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Realty
        )

    [BedsTotal] => Array
        (
            [0] => 5
        )

    [BathsFull] => Array
        (
            [0] => 4
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 5700.00
        )

    [SqftTotal] => Array
        (
            [0] => 2965
        )

    [YearBuilt] => Array
        (
            [0] => 2022
        )

    [BuildingName] => Array
        (
            [0] => 
        )

    [PropertyCondition] => Array
        (
            [0] => Excellent
        )

    [ParkingTotal] => Array
        (
            [0] => 2
        )

    [StoriesType] => Array
        (
            [0] => Two
        )

    [View] => Array
        (
            [0] => None
        )

    [MaintenanceExpense] => Array
        (
            [0] => 
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => 
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => 
        )

    [HighSchool] => Array
        (
            [0] => 
        )

    [ListOfficeMLSID] => Array
        (
            [0] => CBPP04
        )

    [ListAgentEmail] => Array
        (
            [0] => marina.wang@cbrealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 262-3104
        )

    [ListAgentFullName] => Array
        (
            [0] => Marina Wang
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-11-13T12:30:00.927
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18213168
        )

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-08-30T14:20:36.093
        )

    [MLSAreaMajor] => Array
        (
            [0] => Central
        )

    [PropertyFrontage] => Array
        (
            [0] => 
        )

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

    [_thumbnail_id] => Array
        (
            [0] => 26676814
        )

    [listing_image] => Array
        (
            [0] => 26676814
            [1] => 26676815
            [2] => 26676816
            [3] => 26676817
            [4] => 26676818
            [5] => 26676819
            [6] => 26676820
            [7] => 26676821
            [8] => 26676822
            [9] => 26676823
            [10] => 26676824
            [11] => 26676825
            [12] => 26676826
            [13] => 26676827
            [14] => 26676828
            [15] => 26676829
            [16] => 26676830
            [17] => 26676831
            [18] => 26676832
            [19] => 26676833
            [20] => 26676834
            [21] => 26676835
            [22] => 26676836
            [23] => 26676837
            [24] => 26676838
            [25] => 26676839
        )

)

  • BedsTotal: 5
  • Full Baths: 4
  • Land Area (sf): 5,700
  • Living (sf): 2,965
  • Year Built: 2022

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • View: None
  • Listing Office: Coldwell Banker Realty

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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