4954 KILAUEA Avenue Unit 51 Honolulu, HI 96816
Listing
Overview
Price: $545,000
Area: WAIALAE NUI VLY
Status: Active
VACANT - SHOW ON SHORT NOTICE. But please use SENTRIKEY and TO agent Philip Enomoto, Realtor. (Please call the agent for the Masterlock box combination.)
***PLEASE NOTE: The price reflects a structural problem and is therefore severely discounted by approximately $100K to reflect the repair cost. (The actual problem requires an engineering study for confirmation.) Literature is available upon request to show the initial inspection by the representative of Foundation Systems LLC.
***PLEASE NOTE: SOME DOCUMENTS ARE AVAILABLE IN THE LISTING UNDER - SUPPLEMENTS.****
***Illness in the corporation requires that the property be sold immediately.***
TO BE SOLD IN "AS-IS" CONDITION, PLEASE USE THE "AS-IS ADDENDUM."
***This unit has two (2) assigned parking stalls.*** Foreign seller, please use Title Guaranty Escrow - RP Saunders Escrow Officer. Listing by: Philip I. Enomoto (808) 620-1336
array(48) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202420928"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "4954"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "KILAUEA"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Avenue"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(2) "51"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "545000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(15) "WAIALAE NUI VLY"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(876) "VACANT - SHOW ON SHORT NOTICE. But please use SENTRIKEY and TO agent Philip Enomoto, Realtor. (Please call the agent for the Masterlock box combination.)
***PLEASE NOTE: The price reflects a structural problem and is therefore severely discounted by approximately $100K to reflect the repair cost. (The actual problem requires an engineering study for confirmation.) Literature is available upon request to show the initial inspection by the representative of Foundation Systems LLC.
***PLEASE NOTE: SOME DOCUMENTS ARE AVAILABLE IN THE LISTING UNDER - SUPPLEMENTS.****
***Illness in the corporation requires that the property be sold immediately.***
TO BE SOLD IN "AS-IS" CONDITION, PLEASE USE THE "AS-IS ADDENDUM."
***This unit has two (2) assigned parking stalls.*** Foreign seller, please use Title Guaranty Escrow - RP Saunders Escrow Officer."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(17) "Philip I. Enomoto"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1035"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1966"
}
["BuildingName"]=>
array(1) {
[0]=>
string(15) "WAIALAE GARDENS"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "775.00"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(6) "Wilson"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Kaimuki"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kalani"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "PIER"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(21) "pier.hawaii@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 620-1336"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Philip I Enomoto"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-02-05T21:29:33.273"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18258190"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26691666"
}
["listing_image"]=>
array(22) {
[0]=>
string(8) "26691666"
[1]=>
string(8) "26691667"
[2]=>
string(8) "26691668"
[3]=>
string(8) "26767564"
[4]=>
string(8) "26767565"
[5]=>
string(8) "26767566"
[6]=>
string(8) "26767567"
[7]=>
string(8) "26767568"
[8]=>
string(8) "26767569"
[9]=>
string(8) "26767570"
[10]=>
string(8) "26767571"
[11]=>
string(8) "26767572"
[12]=>
string(8) "26767573"
[13]=>
string(8) "26869444"
[14]=>
string(8) "26869445"
[15]=>
string(8) "26869446"
[16]=>
string(8) "26869447"
[17]=>
string(8) "26869448"
[18]=>
string(8) "26869449"
[19]=>
string(8) "26869450"
[20]=>
string(8) "26869451"
[21]=>
string(8) "26869452"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-09-12"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "21:29:33.273"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202420928
)
[StreetNumber] => Array
(
[0] => 4954
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => KILAUEA
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] => 51
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96816
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 545000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => WAIALAE NUI VLY
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => VACANT - SHOW ON SHORT NOTICE. But please use SENTRIKEY and TO agent Philip Enomoto, Realtor. (Please call the agent for the Masterlock box combination.)
***PLEASE NOTE: The price reflects a structural problem and is therefore severely discounted by approximately $100K to reflect the repair cost. (The actual problem requires an engineering study for confirmation.) Literature is available upon request to show the initial inspection by the representative of Foundation Systems LLC.
***PLEASE NOTE: SOME DOCUMENTS ARE AVAILABLE IN THE LISTING UNDER - SUPPLEMENTS.****
***Illness in the corporation requires that the property be sold immediately.***
TO BE SOLD IN "AS-IS" CONDITION, PLEASE USE THE "AS-IS ADDENDUM."
***This unit has two (2) assigned parking stalls.*** Foreign seller, please use Title Guaranty Escrow - RP Saunders Escrow Officer.
)
[ListOfficeName] => Array
(
[0] => Philip I. Enomoto
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 1035
)
[YearBuilt] => Array
(
[0] => 1966
)
[BuildingName] => Array
(
[0] => WAIALAE GARDENS
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] => 775.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Wilson
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kaimuki
)
[HighSchool] => Array
(
[0] => Kalani
)
[ListOfficeMLSID] => Array
(
[0] => PIER
)
[ListAgentEmail] => Array
(
[0] => pier.hawaii@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 620-1336
)
[ListAgentFullName] => Array
(
[0] => Philip I Enomoto
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2025-02-05T21:29:33.273
)
[Matrix_Unique_ID] => Array
(
[0] => 18258190
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26691666
)
[listing_image] => Array
(
[0] => 26691666
[1] => 26691667
[2] => 26691668
[3] => 26767564
[4] => 26767565
[5] => 26767566
[6] => 26767567
[7] => 26767568
[8] => 26767569
[9] => 26767570
[10] => 26767571
[11] => 26767572
[12] => 26767573
[13] => 26869444
[14] => 26869445
[15] => 26869446
[16] => 26869447
[17] => 26869448
[18] => 26869449
[19] => 26869450
[20] => 26869451
[21] => 26869452
)
[ListingContractDate] => Array
(
[0] => 2024-09-12
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 21:29:33.273
)
)
- BedsTotal: 2
- Full Baths: 2
- Living (sf): 1,035
- Year Built: 1966
- Building Name: WAIALAE GARDENS
- Property Condition: Average
- Number of Parking Spaces: 2
- View: None
- Listing Office: Philip I. Enomoto
- Maintenance Fees: $775
- Land Tenure: FS - Fee Simple
- Elementary School: Wilson
- Middle School: Kaimuki
- High School: Kalani
