Our office will be closed on November 28 and 29, 2024, for Thanksgiving and the Day After Thanksgiving.
45-075 Waikalua Road Unit Q Kaneohe, HI 96744
Listing Overview
Price: $1,875,000 Area: WAIKALUA Status: Active
Welcome to your luxurious oceanfront retreat, newly built in 2017 on a rare corner lot on Kaneohe Bay, where the beauty of island living meets modern convenience. Step into a formal living room that flows seamlessly into a modern kitchen and dining area. Downstairs, an extra-large second family room provides ample space for relaxation with a premium German audiophile home theater setup. This 3-bedroom, 3.5-bath residence offers full AC, double-pane windows, and an unobstructed ocean view without power lines. With two expansive lanais, you’ll enjoy breathtaking views of Kaneohe Bay and the Koolau Mountains, plus unforgettable sunrises over the water. A two-car garage with a Gator storage system adds practicality, and the nearby boat ramp allows you to launch your paddleboard or performance-grade ocean kayak right from your backyard. Complete with a French hot water heating system, this home is ideal for ocean enthusiasts. With shopping, parks, dining, and easy access to Likelike and H1 highways, it’s an effortless commute to Honolulu. Discover ultimate waterfront living on Oahu—make every day a getaway in this exceptional home! Listing by: Keller Williams Honolulu (970) 846-7201
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202424705"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "45-075"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Waikalua"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(1) "Q"
}
["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(10) "1875000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1875000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "WAIKALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1150) "Welcome to your luxurious oceanfront retreat, newly built in 2017 on a rare corner lot on Kaneohe Bay, where the beauty of island living meets modern convenience. Step into a formal living room that flows seamlessly into a modern kitchen and dining area. Downstairs, an extra-large second family room provides ample space for relaxation with a premium German audiophile home theater setup. This 3-bedroom, 3.5-bath residence offers full AC, double-pane windows, and an unobstructed ocean view without power lines. With two expansive lanais, you’ll enjoy breathtaking views of Kaneohe Bay and the Koolau Mountains, plus unforgettable sunrises over the water. A two-car garage with a Gator storage system adds practicality, and the nearby boat ramp allows you to launch your paddleboard or performance-grade ocean kayak right from your backyard. Complete with a French hot water heating system, this home is ideal for ocean enthusiasts. With shopping, parks, dining, and easy access to Likelike and H1 highways, it’s an effortless commute to Honolulu. Discover ultimate waterfront living on Oahu—make every day a getaway in this exceptional home!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6762.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3539"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2017"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(39) "Coastline,Mountain,Ocean,Sunrise,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1060.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) "KWPP"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(20) "audrey.alessi@kw.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(970) 846-7201"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Audrey M Alessi"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-24T17:00:01.623"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18348076"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-30T14:13:48.110"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(29) "Ocean,Stream/Canal,Waterfront"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26761382"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26761382"
[1]=>
string(8) "26761383"
[2]=>
string(8) "26761384"
[3]=>
string(8) "26761385"
[4]=>
string(8) "26761386"
[5]=>
string(8) "26761387"
[6]=>
string(8) "26761388"
[7]=>
string(8) "26761389"
[8]=>
string(8) "26761390"
[9]=>
string(8) "26761391"
[10]=>
string(8) "26761392"
[11]=>
string(8) "26761393"
[12]=>
string(8) "26761394"
[13]=>
string(8) "26761395"
[14]=>
string(8) "26761396"
[15]=>
string(8) "26761397"
[16]=>
string(8) "26761398"
[17]=>
string(8) "26761399"
[18]=>
string(8) "26761400"
[19]=>
string(8) "26761401"
[20]=>
string(8) "26761402"
[21]=>
string(8) "26761403"
[22]=>
string(8) "26761404"
[23]=>
string(8) "26761405"
[24]=>
string(8) "26761406"
[25]=>
string(8) "26761407"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202424705
)
[StreetNumber] => Array
(
[0] => 45-075
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Waikalua
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => Q
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1875000.00
)
[CurrentPrice] => Array
(
[0] => 1875000.00
)
[Neighbourhood] => Array
(
[0] => WAIKALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to your luxurious oceanfront retreat, newly built in 2017 on a rare corner lot on Kaneohe Bay, where the beauty of island living meets modern convenience. Step into a formal living room that flows seamlessly into a modern kitchen and dining area. Downstairs, an extra-large second family room provides ample space for relaxation with a premium German audiophile home theater setup. This 3-bedroom, 3.5-bath residence offers full AC, double-pane windows, and an unobstructed ocean view without power lines. With two expansive lanais, you’ll enjoy breathtaking views of Kaneohe Bay and the Koolau Mountains, plus unforgettable sunrises over the water. A two-car garage with a Gator storage system adds practicality, and the nearby boat ramp allows you to launch your paddleboard or performance-grade ocean kayak right from your backyard. Complete with a French hot water heating system, this home is ideal for ocean enthusiasts. With shopping, parks, dining, and easy access to Likelike and H1 highways, it’s an effortless commute to Honolulu. Discover ultimate waterfront living on Oahu—make every day a getaway in this exceptional home!
)
[ListOfficeName] => Array
(
[0] => Keller Williams Honolulu
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 6762.00
)
[SqftTotal] => Array
(
[0] => 3539
)
[YearBuilt] => Array
(
[0] => 2017
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Coastline,Mountain,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 1060.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => KWPP
)
[ListAgentEmail] => Array
(
[0] => audrey.alessi@kw.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (970) 846-7201
)
[ListAgentFullName] => Array
(
[0] => Audrey M Alessi
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-24T17:00:01.623
)
[Matrix_Unique_ID] => Array
(
[0] => 18348076
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-30T14:13:48.110
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Ocean,Stream/Canal,Waterfront
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26761382
)
[listing_image] => Array
(
[0] => 26761382
[1] => 26761383
[2] => 26761384
[3] => 26761385
[4] => 26761386
[5] => 26761387
[6] => 26761388
[7] => 26761389
[8] => 26761390
[9] => 26761391
[10] => 26761392
[11] => 26761393
[12] => 26761394
[13] => 26761395
[14] => 26761396
[15] => 26761397
[16] => 26761398
[17] => 26761399
[18] => 26761400
[19] => 26761401
[20] => 26761402
[21] => 26761403
[22] => 26761404
[23] => 26761405
[24] => 26761406
[25] => 26761407
)
)