Listing
Overview
Price: $1,280,000
Area: HALE KOU
Status: Active
Stunning Contemporary Home in Windward Oahu – Rarely Available
This beautifully renovated 2025 home is tucked away at the end of a private, quiet cul-de-sac, offering both privacy and convenience. The spacious backyard provides the perfect setting for outdoor living and entertaining, while the large lot allows for ample parking for up to nine cars.
Designed with modern living in mind, this move-in-ready residence features brand-new appliances, contemporary finishes, and thoughtful upgrades throughout. Ideally situated near shopping, dining, and top amenities, with easy access to Likelike and H-3 freeways for seamless island travel. Just a short drive to the breathtaking Kailua Beach Park, this home offers the best of Windward Oahu living. Actual square footage does not match the tax record.
A rare opportunity not to be missed—schedule a showing today! Listing by: Locations LLC (808) 772-9680
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202504578"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "45-554"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Huawaina"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["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(59) "https://media.visionaryviewsllc.com/sites/vepwbon/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1280000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "HALE KOU"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(876) "Stunning Contemporary Home in Windward Oahu – Rarely Available
This beautifully renovated 2025 home is tucked away at the end of a private, quiet cul-de-sac, offering both privacy and convenience. The spacious backyard provides the perfect setting for outdoor living and entertaining, while the large lot allows for ample parking for up to nine cars.
Designed with modern living in mind, this move-in-ready residence features brand-new appliances, contemporary finishes, and thoughtful upgrades throughout. Ideally situated near shopping, dining, and top amenities, with easy access to Likelike and H-3 freeways for seamless island travel. Just a short drive to the breathtaking Kailua Beach Park, this home offers the best of Windward Oahu living. Actual square footage does not match the tax record.
A rare opportunity not to be missed—schedule a showing today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(13) "Locations LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "8613.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1235"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1959"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(4) "King"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Castle"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "LOCA"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(20) "canniechum@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 772-9680"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Cannie Chum"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18544370"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-02-26T10:15:01.720"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-02-10"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "10:15:01.720"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26874775"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "26874775"
[1]=>
string(8) "26874776"
[2]=>
string(8) "26874777"
[3]=>
string(8) "26874778"
[4]=>
string(8) "26874779"
[5]=>
string(8) "26874780"
[6]=>
string(8) "26874781"
[7]=>
string(8) "26874782"
[8]=>
string(8) "26874783"
[9]=>
string(8) "26874784"
[10]=>
string(8) "26874785"
[11]=>
string(8) "26874786"
[12]=>
string(8) "26874787"
[13]=>
string(8) "26874788"
[14]=>
string(8) "26874789"
[15]=>
string(8) "26874790"
[16]=>
string(8) "26874791"
[17]=>
string(8) "26874792"
[18]=>
string(8) "26874793"
[19]=>
string(8) "26874794"
[20]=>
string(8) "26874795"
[21]=>
string(8) "26874796"
[22]=>
string(8) "26874797"
[23]=>
string(8) "26874798"
[24]=>
string(8) "26874799"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202504578
)
[StreetNumber] => Array
(
[0] => 45-554
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Huawaina
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://media.visionaryviewsllc.com/sites/vepwbon/unbranded
)
[ListPrice] => Array
(
[0] => 1280000.00
)
[Neighbourhood] => Array
(
[0] => HALE KOU
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Stunning Contemporary Home in Windward Oahu – Rarely Available
This beautifully renovated 2025 home is tucked away at the end of a private, quiet cul-de-sac, offering both privacy and convenience. The spacious backyard provides the perfect setting for outdoor living and entertaining, while the large lot allows for ample parking for up to nine cars.
Designed with modern living in mind, this move-in-ready residence features brand-new appliances, contemporary finishes, and thoughtful upgrades throughout. Ideally situated near shopping, dining, and top amenities, with easy access to Likelike and H-3 freeways for seamless island travel. Just a short drive to the breathtaking Kailua Beach Park, this home offers the best of Windward Oahu living. Actual square footage does not match the tax record.
A rare opportunity not to be missed—schedule a showing today!
)
[ListOfficeName] => Array
(
[0] => Locations LLC
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 8613.00
)
[SqftTotal] => Array
(
[0] => 1235
)
[YearBuilt] => Array
(
[0] => 1959
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kaneohe
)
[MiddleOrJuniorSchool] => Array
(
[0] => King
)
[HighSchool] => Array
(
[0] => Castle
)
[ListOfficeMLSID] => Array
(
[0] => LOCA
)
[ListAgentEmail] => Array
(
[0] => canniechum@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 772-9680
)
[ListAgentFullName] => Array
(
[0] => Cannie Chum
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18544370
)
[MatrixModifiedDT] => Array
(
[0] => 2025-02-26T10:15:01.720
)
[ListingContractDate] => Array
(
[0] => 2025-02-10
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 10:15:01.720
)
[_thumbnail_id] => Array
(
[0] => 26874775
)
[listing_image] => Array
(
[0] => 26874775
[1] => 26874776
[2] => 26874777
[3] => 26874778
[4] => 26874779
[5] => 26874780
[6] => 26874781
[7] => 26874782
[8] => 26874783
[9] => 26874784
[10] => 26874785
[11] => 26874786
[12] => 26874787
[13] => 26874788
[14] => 26874789
[15] => 26874790
[16] => 26874791
[17] => 26874792
[18] => 26874793
[19] => 26874794
[20] => 26874795
[21] => 26874796
[22] => 26874797
[23] => 26874798
[24] => 26874799
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 8,613 sf
- Living (sf): 1,235
- Year Built: 1959
- Property Condition: Excellent
- Number of Parking Spaces: 4
- View: Mountain
- Listing Office: Locations LLC
- Land Tenure: FS - Fee Simple
- Elementary School: Kaneohe
- Middle School: King
- High School: Castle
