Listing
Overview
Price: $3,990,000
Area: MAHINUI
Status: Active
Rare opportunity to own an exquisite, newly constructed, modern home with panoramic ocean and mountain views. Designed for today's lifestyle offering a guest floor with two ensuite bedrooms and a living room. Designer 'smart' kitchen with large central island opens to a living area boasting floor to ceiling windows and over 1,000 sf of lanai space for Hawai'ian-style indoor/outdoor living. Live in luxury with smart home technology, an elevator, and a custom-built four-person tram leading from the garage to the front door. Close to the white sandy beaches, restaurants, and shops of Kailua and minutes from the airport and downtown Honolulu. Listing by: Coldwell Banker Realty
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202216479"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "44-652"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(11) "Kaneohe Bay"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Drive"
}
["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(39) "http://player.vimeo.com/video/739134253"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3990000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "3990000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "MAHINUI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(647) "Rare opportunity to own an exquisite, newly constructed, modern home with panoramic ocean and mountain views. Designed for today's lifestyle offering a guest floor with two ensuite bedrooms and a living room. Designer 'smart' kitchen with large central island opens to a living area boasting floor to ceiling windows and over 1,000 sf of lanai space for Hawai'ian-style indoor/outdoor living. Live in luxury with smart home technology, an elevator, and a custom-built four-person tram leading from the garage to the front door. Close to the white sandy beaches, restaurants, and shops of Kailua and minutes from the airport and downtown Honolulu."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "2"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "10403.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "4992"
}
["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(6) "Three+"
}
["View"]=>
array(1) {
[0]=>
string(31) "Coastline,Mountain,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(6) "Aikahi"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(6) "CBPP04"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(21) "cyndiap@cbpacific.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(0) ""
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "Cyndia Pilkington"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-08-20T17:00:02.297"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "16824321"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2022-08-12T14:53:28.613"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25831067"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "25831067"
[1]=>
string(8) "25831068"
[2]=>
string(8) "25831069"
[3]=>
string(8) "25831070"
[4]=>
string(8) "25831071"
[5]=>
string(8) "25831072"
[6]=>
string(8) "25831073"
[7]=>
string(8) "25831074"
[8]=>
string(8) "25831075"
[9]=>
string(8) "25831076"
[10]=>
string(8) "25831077"
[11]=>
string(8) "25831078"
[12]=>
string(8) "25831079"
[13]=>
string(8) "25831080"
[14]=>
string(8) "25831081"
[15]=>
string(8) "25831082"
[16]=>
string(8) "25831083"
[17]=>
string(8) "25831084"
[18]=>
string(8) "25831085"
[19]=>
string(8) "25831086"
[20]=>
string(8) "25831087"
[21]=>
string(8) "25831088"
[22]=>
string(8) "25831089"
[23]=>
string(8) "25831090"
[24]=>
string(8) "25831091"
[25]=>
string(8) "25831092"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202216479
)
[StreetNumber] => Array
(
[0] => 44-652
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kaneohe Bay
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] => http://player.vimeo.com/video/739134253
)
[ListPrice] => Array
(
[0] => 3990000.00
)
[CurrentPrice] => Array
(
[0] => 3990000.00
)
[Neighbourhood] => Array
(
[0] => MAHINUI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Rare opportunity to own an exquisite, newly constructed, modern home with panoramic ocean and mountain views. Designed for today's lifestyle offering a guest floor with two ensuite bedrooms and a living room. Designer 'smart' kitchen with large central island opens to a living area boasting floor to ceiling windows and over 1,000 sf of lanai space for Hawai'ian-style indoor/outdoor living. Live in luxury with smart home technology, an elevator, and a custom-built four-person tram leading from the garage to the front door. Close to the white sandy beaches, restaurants, and shops of Kailua and minutes from the airport and downtown Honolulu.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 2
)
[LotSizeArea] => Array
(
[0] => 10403.00
)
[SqftTotal] => Array
(
[0] => 4992
)
[YearBuilt] => Array
(
[0] => 2022
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Three+
)
[View] => Array
(
[0] => Coastline,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Aikahi
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBPP04
)
[ListAgentEmail] => Array
(
[0] => cyndiap@cbpacific.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] =>
)
[ListAgentFullName] => Array
(
[0] => Cyndia Pilkington
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-08-20T17:00:02.297
)
[Matrix_Unique_ID] => Array
(
[0] => 16824321
)
[OriginalEntryTimestamp] => Array
(
[0] => 2022-08-12T14:53:28.613
)
[_thumbnail_id] => Array
(
[0] => 25831067
)
[listing_image] => Array
(
[0] => 25831067
[1] => 25831068
[2] => 25831069
[3] => 25831070
[4] => 25831071
[5] => 25831072
[6] => 25831073
[7] => 25831074
[8] => 25831075
[9] => 25831076
[10] => 25831077
[11] => 25831078
[12] => 25831079
[13] => 25831080
[14] => 25831081
[15] => 25831082
[16] => 25831083
[17] => 25831084
[18] => 25831085
[19] => 25831086
[20] => 25831087
[21] => 25831088
[22] => 25831089
[23] => 25831090
[24] => 25831091
[25] => 25831092
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- BedsTotal: 4
- Full Baths: 4
- Half Baths: 2
- Land Area (sf): 10,403
- Living (sf): 4,992
- Year Built: 2022
- Property Condition: Excellent
- Number of Parking Spaces: 2
- View: Coastline,Mountain,Ocean,Sunset
- Listing Office: Coldwell Banker Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Aikahi