Impressive Multi-Unit Property situated on a Huge 10,000 SF! Conveniently located just minutes from restaurants, beaches & parks, this property features 3 separate renovated units in 2 structures presenting multi-generational living and income opportunities! Explore the main home to discover two-units (1st floor: 2BR/1BA/1,604sqft & 2nd floor: 2BR/2BA/1,044sqft) with tons of natural light, gorgeous LVP flooring, spacious rooms, separate entrances, & stunning gourmet kitchens boasting stainless-steel appliances & quartz countertops. The first floor also features a wet bar, perfect for entertaining guests! Nestled on the back of the property, a separate 1,062 SF home dazzles with tile floors, large living room, open concept kitchen, two main-level bedrooms, and one main-level full bathroom. Venture to the second floor to find a spacious bedroom, kitchenette, and a full bathroom. The outdoor space offers endless possibilities for enjoyment with a beautiful waterfall koi pond and large concrete pad, perfect for hosting outdoor gatherings! Ideal location within close proximity to Waikiki, Diamond Head, and Kaimuki, and much more! Come see it today! Listing by: Real Estate Specialists (808) 347-8005
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202423289"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "3232"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Castle"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["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) "96815"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(79) "https://listings.hetproductions.com/videos/019234db-313c-73e3-ac0e-da062048cb2e"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3100000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "3100000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "KAPAHULU"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1163) "Impressive Multi-Unit Property situated on a Huge 10,000 SF! Conveniently located just minutes from restaurants, beaches & parks, this property features 3 separate renovated units in 2 structures presenting multi-generational living and income opportunities! Explore the main home to discover two-units (1st floor: 2BR/1BA/1,604sqft & 2nd floor: 2BR/2BA/1,044sqft) with tons of natural light, gorgeous LVP flooring, spacious rooms, separate entrances, & stunning gourmet kitchens boasting stainless-steel appliances & quartz countertops. The first floor also features a wet bar, perfect for entertaining guests! Nestled on the back of the property, a separate 1,062 SF home dazzles with tile floors, large living room, open concept kitchen, two main-level bedrooms, and one main-level full bathroom. Venture to the second floor to find a spacious bedroom, kitchenette, and a full bathroom. The outdoor space offers endless possibilities for enjoyment with a beautiful waterfall koi pond and large concrete pad, perfect for hosting outdoor gatherings! Ideal location within close proximity to Waikiki, Diamond Head, and Kaimuki, and much more! Come see it today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(23) "Real Estate Specialists"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "7"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "10000.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3710"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1947"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(6) "Garden"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["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) "HRES"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "derek.lau@reshawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 347-8005"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Derek C Lau"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-24T16:38:15.110"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18306154"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-03T09:07:41.327"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26717212"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26717212"
[1]=>
string(8) "26717213"
[2]=>
string(8) "26717214"
[3]=>
string(8) "26717215"
[4]=>
string(8) "26717216"
[5]=>
string(8) "26717217"
[6]=>
string(8) "26717218"
[7]=>
string(8) "26717219"
[8]=>
string(8) "26717220"
[9]=>
string(8) "26717221"
[10]=>
string(8) "26717222"
[11]=>
string(8) "26717223"
[12]=>
string(8) "26717224"
[13]=>
string(8) "26717225"
[14]=>
string(8) "26717226"
[15]=>
string(8) "26717227"
[16]=>
string(8) "26717228"
[17]=>
string(8) "26717229"
[18]=>
string(8) "26717230"
[19]=>
string(8) "26717231"
[20]=>
string(8) "26717232"
[21]=>
string(8) "26717233"
[22]=>
string(8) "26717234"
[23]=>
string(8) "26717235"
[24]=>
string(8) "26717236"
[25]=>
string(8) "26717237"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202423289
)
[StreetNumber] => Array
(
[0] => 3232
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Castle
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96815
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/videos/019234db-313c-73e3-ac0e-da062048cb2e
)
[ListPrice] => Array
(
[0] => 3100000.00
)
[CurrentPrice] => Array
(
[0] => 3100000.00
)
[Neighbourhood] => Array
(
[0] => KAPAHULU
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Impressive Multi-Unit Property situated on a Huge 10,000 SF! Conveniently located just minutes from restaurants, beaches & parks, this property features 3 separate renovated units in 2 structures presenting multi-generational living and income opportunities! Explore the main home to discover two-units (1st floor: 2BR/1BA/1,604sqft & 2nd floor: 2BR/2BA/1,044sqft) with tons of natural light, gorgeous LVP flooring, spacious rooms, separate entrances, & stunning gourmet kitchens boasting stainless-steel appliances & quartz countertops. The first floor also features a wet bar, perfect for entertaining guests! Nestled on the back of the property, a separate 1,062 SF home dazzles with tile floors, large living room, open concept kitchen, two main-level bedrooms, and one main-level full bathroom. Venture to the second floor to find a spacious bedroom, kitchenette, and a full bathroom. The outdoor space offers endless possibilities for enjoyment with a beautiful waterfall koi pond and large concrete pad, perfect for hosting outdoor gatherings! Ideal location within close proximity to Waikiki, Diamond Head, and Kaimuki, and much more! Come see it today!
)
[ListOfficeName] => Array
(
[0] => Real Estate Specialists
)
[BedsTotal] => Array
(
[0] => 7
)
[BathsFull] => Array
(
[0] => 5
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 10000.00
)
[SqftTotal] => Array
(
[0] => 3710
)
[YearBuilt] => Array
(
[0] => 1947
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 6
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Garden
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => HRES
)
[ListAgentEmail] => Array
(
[0] => derek.lau@reshawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 347-8005
)
[ListAgentFullName] => Array
(
[0] => Derek C Lau
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-24T16:38:15.110
)
[Matrix_Unique_ID] => Array
(
[0] => 18306154
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-03T09:07:41.327
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26717212
)
[listing_image] => Array
(
[0] => 26717212
[1] => 26717213
[2] => 26717214
[3] => 26717215
[4] => 26717216
[5] => 26717217
[6] => 26717218
[7] => 26717219
[8] => 26717220
[9] => 26717221
[10] => 26717222
[11] => 26717223
[12] => 26717224
[13] => 26717225
[14] => 26717226
[15] => 26717227
[16] => 26717228
[17] => 26717229
[18] => 26717230
[19] => 26717231
[20] => 26717232
[21] => 26717233
[22] => 26717234
[23] => 26717235
[24] => 26717236
[25] => 26717237
)
)