The opportunity of a lifetime! Last of its kind, extremely rare and precious, intact HUGE 25,372 sq. ft. lot in Kaimuki zoned R-5, with expansive mountain, ocean, and city views - Diamond Head, Koko Head, Waikiki, Kahala, neighbor islands! Views from the front, rear, and side of the lot! Tons of options for rebuilding, remodeling, expanding, dividing, and more! Make this your castle, fortress, multi-unit compound, or unique community of units. Perfectly located in Kaimuki near beaches, hikes, restaurants, shops, medical care, freeway on/off, schools, churches, parks, everything you need! Existing structures: 1) Single family home with kitchen, living room, 2 bedrooms, 3 bathrooms & bonus rooms on the main level, a large upstairs loft/bedroom and a large basement, 2) a 1 bed/1 bath unit, and 3) a studio unit. All sq. ft. stated is from tax record - actual measurements and # of rooms/bathrooms may differ from tax record. DO NOT GO ONTO THE PROPERTY WITHOUT LISTING AGENT - NO TRESPASSING. All items at the property shall remain there at closing except for tenant's belongings. AS IS sale. Buyer to order own TIR, and do own thorough due diligence. Rent shown is for the 1/1 and studio. Listing by: Demarked Realty Hawaii LLC
array(46) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202205336"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "766"
}
["PropertyType"]=>
array(1) {
[0]=>
string(12) "Multi-Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Ocean View"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Drive"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96816"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(28) "https://youtu.be/akzY81V4QVo"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "4000000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "4000000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAIMUKI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1200) "The opportunity of a lifetime! Last of its kind, extremely rare and precious, intact HUGE 25,372 sq. ft. lot in Kaimuki zoned R-5, with expansive mountain, ocean, and city views - Diamond Head, Koko Head, Waikiki, Kahala, neighbor islands! Views from the front, rear, and side of the lot! Tons of options for rebuilding, remodeling, expanding, dividing, and more! Make this your castle, fortress, multi-unit compound, or unique community of units. Perfectly located in Kaimuki near beaches, hikes, restaurants, shops, medical care, freeway on/off, schools, churches, parks, everything you need! Existing structures: 1) Single family home with kitchen, living room, 2 bedrooms, 3 bathrooms & bonus rooms on the main level, a large upstairs loft/bedroom and a large basement, 2) a 1 bed/1 bath unit, and 3) a studio unit. All sq. ft. stated is from tax record - actual measurements and # of rooms/bathrooms may differ from tax record. DO NOT GO ONTO THE PROPERTY WITHOUT LISTING AGENT - NO TRESPASSING. All items at the property shall remain there at closing except for tenant's belongings. AS IS sale. Buyer to order own TIR, and do own thorough due diligence. Rent shown is for the 1/1 and studio."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(26) "Demarked Realty Hawaii LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "25372.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3361"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1937"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(21) "Above Average,Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(2) "10"
}
["StoriesType"]=>
array(1) {
[0]=>
string(7) "One,Two"
}
["View"]=>
array(1) {
[0]=>
string(70) "City,Coastline,Diamond Head,Garden,Mountain,Ocean,Other,Sunrise,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
NULL
}
["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) "DMKD"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "Lori@demarkedrealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(0) ""
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Lori K Kaizawa"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-15T12:15:30.053"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "16521136"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2022-03-30T17:46:31.130"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25870740"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "25870740"
[1]=>
string(8) "25870741"
[2]=>
string(8) "25870742"
[3]=>
string(8) "25870743"
[4]=>
string(8) "25870744"
[5]=>
string(8) "25870745"
[6]=>
string(8) "25870746"
[7]=>
string(8) "25870747"
[8]=>
string(8) "25870748"
[9]=>
string(8) "25870749"
[10]=>
string(8) "25870750"
[11]=>
string(8) "25870751"
[12]=>
string(8) "25870752"
[13]=>
string(8) "25870753"
[14]=>
string(8) "25870754"
[15]=>
string(8) "25870755"
[16]=>
string(8) "25870756"
[17]=>
string(8) "25870757"
[18]=>
string(8) "25870758"
[19]=>
string(8) "25870759"
[20]=>
string(8) "25870760"
[21]=>
string(8) "25870761"
[22]=>
string(8) "25870762"
[23]=>
string(8) "25870763"
[24]=>
string(8) "25870764"
[25]=>
string(8) "25870765"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "12:15:30.053"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202205336
)
[StreetNumber] => Array
(
[0] => 766
)
[PropertyType] => Array
(
[0] => Multi-Family
)
[StreetName] => Array
(
[0] => Ocean View
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96816
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://youtu.be/akzY81V4QVo
)
[ListPrice] => Array
(
[0] => 4000000.00
)
[CurrentPrice] => Array
(
[0] => 4000000.00
)
[Neighbourhood] => Array
(
[0] => KAIMUKI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => The opportunity of a lifetime! Last of its kind, extremely rare and precious, intact HUGE 25,372 sq. ft. lot in Kaimuki zoned R-5, with expansive mountain, ocean, and city views - Diamond Head, Koko Head, Waikiki, Kahala, neighbor islands! Views from the front, rear, and side of the lot! Tons of options for rebuilding, remodeling, expanding, dividing, and more! Make this your castle, fortress, multi-unit compound, or unique community of units. Perfectly located in Kaimuki near beaches, hikes, restaurants, shops, medical care, freeway on/off, schools, churches, parks, everything you need! Existing structures: 1) Single family home with kitchen, living room, 2 bedrooms, 3 bathrooms & bonus rooms on the main level, a large upstairs loft/bedroom and a large basement, 2) a 1 bed/1 bath unit, and 3) a studio unit. All sq. ft. stated is from tax record - actual measurements and # of rooms/bathrooms may differ from tax record. DO NOT GO ONTO THE PROPERTY WITHOUT LISTING AGENT - NO TRESPASSING. All items at the property shall remain there at closing except for tenant's belongings. AS IS sale. Buyer to order own TIR, and do own thorough due diligence. Rent shown is for the 1/1 and studio.
)
[ListOfficeName] => Array
(
[0] => Demarked Realty Hawaii LLC
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 25372.00
)
[SqftTotal] => Array
(
[0] => 3361
)
[YearBuilt] => Array
(
[0] => 1937
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average,Average
)
[ParkingTotal] => Array
(
[0] => 10
)
[StoriesType] => Array
(
[0] => One,Two
)
[View] => Array
(
[0] => City,Coastline,Diamond Head,Garden,Mountain,Ocean,Other,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => DMKD
)
[ListAgentEmail] => Array
(
[0] => Lori@demarkedrealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] =>
)
[ListAgentFullName] => Array
(
[0] => Lori K Kaizawa
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-15T12:15:30.053
)
[Matrix_Unique_ID] => Array
(
[0] => 16521136
)
[OriginalEntryTimestamp] => Array
(
[0] => 2022-03-30T17:46:31.130
)
[_thumbnail_id] => Array
(
[0] => 25870740
)
[listing_image] => Array
(
[0] => 25870740
[1] => 25870741
[2] => 25870742
[3] => 25870743
[4] => 25870744
[5] => 25870745
[6] => 25870746
[7] => 25870747
[8] => 25870748
[9] => 25870749
[10] => 25870750
[11] => 25870751
[12] => 25870752
[13] => 25870753
[14] => 25870754
[15] => 25870755
[16] => 25870756
[17] => 25870757
[18] => 25870758
[19] => 25870759
[20] => 25870760
[21] => 25870761
[22] => 25870762
[23] => 25870763
[24] => 25870764
[25] => 25870765
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[MatrixModifiedTime] => Array
(
[0] => 12:15:30.053
)
)
