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) 735-4200
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) "1220000.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) 735-4200"
}
["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-04-06T17:00:01.640"
}
["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) "17:00:01.640"
}
["_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] => 1220000.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) 735-4200
)
[ListAgentFullName] => Array
(
[0] => Cannie Chum
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18544370
)
[MatrixModifiedDT] => Array
(
[0] => 2025-04-06T17:00:01.640
)
[ListingContractDate] => Array
(
[0] => 2025-02-10
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:01.640
)
[_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
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on April 6, 2025 - 5: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.
