Listing
Overview
Price: $1,995,000
Area: MAHALANI
Status: Active
Huge Price Improvement! Welcome to your island paradise at this exceptional ocean front property. Wake up every morning to enjoy the unparalleled panoramic views of the sunrising over world famous Kaneohe Bay. The open floor plan is designed for seamless living and entertaining that flows effortlessly from the modern kitchen with brand new Samsung appliances to dining and living areas. The new windows throughout the house allow for an abundance of natural light and frame the stunning ocean views. This 3 bedroom 3 bathroom home also boast new luxury vinyl plank flooring, new roof, Owned solar and you have your own DLNR leased pier attached to a permitted seawall! Don't miss this rare opportunity to own a well maintained oceanfront home. Listing by: Real Broker, LLC (808) 650-5145
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202414076"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "45-107"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Mahalani"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Circle"
}
["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(130) "https://player.vimeo.com/video/976767919?byline=0&title=0&owner=0&name=0&logos=0&profile=0&profilepicture=0&vimeologo=0&portrait=0"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1995000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1995000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "MAHALANI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(745) "Huge Price Improvement! Welcome to your island paradise at this exceptional ocean front property. Wake up every morning to enjoy the unparalleled panoramic views of the sunrising over world famous Kaneohe Bay. The open floor plan is designed for seamless living and entertaining that flows effortlessly from the modern kitchen with brand new Samsung appliances to dining and living areas. The new windows throughout the house allow for an abundance of natural light and frame the stunning ocean views. This 3 bedroom 3 bathroom home also boast new luxury vinyl plank flooring, new roof, Owned solar and you have your own DLNR leased pier attached to a permitted seawall! Don't miss this rare opportunity to own a well maintained oceanfront home."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(16) "Real Broker, LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5045.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2200"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1957"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(13) "Ocean,Sunrise"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(6) "Parker"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(4) "King"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Castle"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "RBLL"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(26) "criadorealestate@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 650-5145"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Clinton J Criado"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-01T16:00:01.740"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18066716"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-07-04T12:57:43.970"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(16) "Ocean,Waterfront"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26610245"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "26610245"
[1]=>
string(8) "26610246"
[2]=>
string(8) "26610247"
[3]=>
string(8) "26610248"
[4]=>
string(8) "26610249"
[5]=>
string(8) "26610250"
[6]=>
string(8) "26610251"
[7]=>
string(8) "26610252"
[8]=>
string(8) "26610253"
[9]=>
string(8) "26610254"
[10]=>
string(8) "26610255"
[11]=>
string(8) "26610256"
[12]=>
string(8) "26610257"
[13]=>
string(8) "26610258"
[14]=>
string(8) "26610259"
[15]=>
string(8) "26610260"
[16]=>
string(8) "26610261"
[17]=>
string(8) "26610262"
[18]=>
string(8) "26610263"
[19]=>
string(8) "26610264"
[20]=>
string(8) "26610265"
[21]=>
string(8) "26610266"
[22]=>
string(8) "26610267"
[23]=>
string(8) "26610268"
[24]=>
string(8) "26610269"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202414076
)
[StreetNumber] => Array
(
[0] => 45-107
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Mahalani
)
[StreetSuffix] => Array
(
[0] => Circle
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/976767919?byline=0&title=0&owner=0&name=0&logos=0&profile=0&profilepicture=0&vimeologo=0&portrait=0
)
[ListPrice] => Array
(
[0] => 1995000.00
)
[CurrentPrice] => Array
(
[0] => 1995000.00
)
[Neighbourhood] => Array
(
[0] => MAHALANI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Huge Price Improvement! Welcome to your island paradise at this exceptional ocean front property. Wake up every morning to enjoy the unparalleled panoramic views of the sunrising over world famous Kaneohe Bay. The open floor plan is designed for seamless living and entertaining that flows effortlessly from the modern kitchen with brand new Samsung appliances to dining and living areas. The new windows throughout the house allow for an abundance of natural light and frame the stunning ocean views. This 3 bedroom 3 bathroom home also boast new luxury vinyl plank flooring, new roof, Owned solar and you have your own DLNR leased pier attached to a permitted seawall! Don't miss this rare opportunity to own a well maintained oceanfront home.
)
[ListOfficeName] => Array
(
[0] => Real Broker, LLC
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5045.00
)
[SqftTotal] => Array
(
[0] => 2200
)
[YearBuilt] => Array
(
[0] => 1957
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Ocean,Sunrise
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Parker
)
[MiddleOrJuniorSchool] => Array
(
[0] => King
)
[HighSchool] => Array
(
[0] => Castle
)
[ListOfficeMLSID] => Array
(
[0] => RBLL
)
[ListAgentEmail] => Array
(
[0] => criadorealestate@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 650-5145
)
[ListAgentFullName] => Array
(
[0] => Clinton J Criado
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-01T16:00:01.740
)
[Matrix_Unique_ID] => Array
(
[0] => 18066716
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-07-04T12:57:43.970
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Ocean,Waterfront
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26610245
)
[listing_image] => Array
(
[0] => 26610245
[1] => 26610246
[2] => 26610247
[3] => 26610248
[4] => 26610249
[5] => 26610250
[6] => 26610251
[7] => 26610252
[8] => 26610253
[9] => 26610254
[10] => 26610255
[11] => 26610256
[12] => 26610257
[13] => 26610258
[14] => 26610259
[15] => 26610260
[16] => 26610261
[17] => 26610262
[18] => 26610263
[19] => 26610264
[20] => 26610265
[21] => 26610266
[22] => 26610267
[23] => 26610268
[24] => 26610269
)
)
- BedsTotal: 3
- Full Baths: 3
- Land Area (sf): 5,045
- Living (sf): 2,200
- Year Built: 1957
- Property Condition: Above Average
- Number of Parking Spaces: 4
- View: Ocean,Sunrise
- Listing Office: Real Broker, LLC
- Land Tenure: FS - Fee Simple
- Elementary School: Parker
- Middle School: King
- High School: Castle
