Listing
Overview
Price: $1,985,000
Area: ENCHANTED LAKE
Status: Active
Fully Renovated Kailua Corner Property on a large lot boasts luxurious finishes and functional design! Don’t miss out on this over 9,000 sq ft front, side, and backyard home with room to expand! Rarely available in the ideal ENCHANTED LAKES NEIGHBORHOOD, this single-story residence prioritizes open-concept living with modern finishes. The dream kitchen features white oak cabinets, top-notch appliances, and a beautifully designed butler’s pantry transitioning into the internal laundry room. The floor plan emphasizes easy entertaining, with a bar area, wine chiller, floating shelves, and living room views of the Ko‘olau Mountains. Retreat to the primary bedroom, complete with a spa-like bathroom featuring a soaking tub, curbless shower, walk-in closet, and sliding doors opening to the jacuzzi and outdoor dining area. Each bedroom has split AC units, mirrored closets, and access to a luxurious full hallway bathroom with LED backlit mirrors and Bluetooth audio. A short drive to Kailua Beach, Castle Hospital, and Kailua Town. Easy access to Pali Hwy, H-3, KMCB, and nearby shopping. Make this Kailua home part of your legacy! Listing by: eXp Realty (808) 381-7824
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202424347"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "851"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Halula"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96734"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(41) "https://player.vimeo.com/video/1022295761"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1985000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1985000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(14) "ENCHANTED LAKE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1142) "Fully Renovated Kailua Corner Property on a large lot boasts luxurious finishes and functional design! Don’t miss out on this over 9,000 sq ft front, side, and backyard home with room to expand! Rarely available in the ideal ENCHANTED LAKES NEIGHBORHOOD, this single-story residence prioritizes open-concept living with modern finishes. The dream kitchen features white oak cabinets, top-notch appliances, and a beautifully designed butler’s pantry transitioning into the internal laundry room. The floor plan emphasizes easy entertaining, with a bar area, wine chiller, floating shelves, and living room views of the Ko‘olau Mountains. Retreat to the primary bedroom, complete with a spa-like bathroom featuring a soaking tub, curbless shower, walk-in closet, and sliding doors opening to the jacuzzi and outdoor dining area. Each bedroom has split AC units, mirrored closets, and access to a luxurious full hallway bathroom with LED backlit mirrors and Bluetooth audio. A short drive to Kailua Beach, Castle Hospital, and Kailua Town. Easy access to Pali Hwy, H-3, KMCB, and nearby shopping. Make this Kailua home part of your legacy!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "9289.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2204"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1963"
}
["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(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(21) "Marina/Canal,Mountain"
}
["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) "EXPI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(30) "tiarelando@legacylivingnow.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 381-7824"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Tiare Lando"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-31T14:15:01.243"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18337201"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-22T18:19:39.627"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26742209"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26742209"
[1]=>
string(8) "26742210"
[2]=>
string(8) "26742211"
[3]=>
string(8) "26742212"
[4]=>
string(8) "26742213"
[5]=>
string(8) "26742214"
[6]=>
string(8) "26742215"
[7]=>
string(8) "26742216"
[8]=>
string(8) "26742217"
[9]=>
string(8) "26742218"
[10]=>
string(8) "26742219"
[11]=>
string(8) "26742220"
[12]=>
string(8) "26742221"
[13]=>
string(8) "26742222"
[14]=>
string(8) "26742223"
[15]=>
string(8) "26742224"
[16]=>
string(8) "26742225"
[17]=>
string(8) "26742226"
[18]=>
string(8) "26742227"
[19]=>
string(8) "26742228"
[20]=>
string(8) "26742229"
[21]=>
string(8) "26742230"
[22]=>
string(8) "26742231"
[23]=>
string(8) "26742232"
[24]=>
string(8) "26742233"
[25]=>
string(8) "26742234"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202424347
)
[StreetNumber] => Array
(
[0] => 851
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Halula
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kailua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96734
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/1022295761
)
[ListPrice] => Array
(
[0] => 1985000.00
)
[CurrentPrice] => Array
(
[0] => 1985000.00
)
[Neighbourhood] => Array
(
[0] => ENCHANTED LAKE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Fully Renovated Kailua Corner Property on a large lot boasts luxurious finishes and functional design! Don’t miss out on this over 9,000 sq ft front, side, and backyard home with room to expand! Rarely available in the ideal ENCHANTED LAKES NEIGHBORHOOD, this single-story residence prioritizes open-concept living with modern finishes. The dream kitchen features white oak cabinets, top-notch appliances, and a beautifully designed butler’s pantry transitioning into the internal laundry room. The floor plan emphasizes easy entertaining, with a bar area, wine chiller, floating shelves, and living room views of the Ko‘olau Mountains. Retreat to the primary bedroom, complete with a spa-like bathroom featuring a soaking tub, curbless shower, walk-in closet, and sliding doors opening to the jacuzzi and outdoor dining area. Each bedroom has split AC units, mirrored closets, and access to a luxurious full hallway bathroom with LED backlit mirrors and Bluetooth audio. A short drive to Kailua Beach, Castle Hospital, and Kailua Town. Easy access to Pali Hwy, H-3, KMCB, and nearby shopping. Make this Kailua home part of your legacy!
)
[ListOfficeName] => Array
(
[0] => eXp Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 9289.00
)
[SqftTotal] => Array
(
[0] => 2204
)
[YearBuilt] => Array
(
[0] => 1963
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Marina/Canal,Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => EXPI
)
[ListAgentEmail] => Array
(
[0] => tiarelando@legacylivingnow.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 381-7824
)
[ListAgentFullName] => Array
(
[0] => Tiare Lando
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-31T14:15:01.243
)
[Matrix_Unique_ID] => Array
(
[0] => 18337201
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-22T18:19:39.627
)
[MLSAreaMajor] => Array
(
[0] => Kailua
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26742209
)
[listing_image] => Array
(
[0] => 26742209
[1] => 26742210
[2] => 26742211
[3] => 26742212
[4] => 26742213
[5] => 26742214
[6] => 26742215
[7] => 26742216
[8] => 26742217
[9] => 26742218
[10] => 26742219
[11] => 26742220
[12] => 26742221
[13] => 26742222
[14] => 26742223
[15] => 26742224
[16] => 26742225
[17] => 26742226
[18] => 26742227
[19] => 26742228
[20] => 26742229
[21] => 26742230
[22] => 26742231
[23] => 26742232
[24] => 26742233
[25] => 26742234
)
)
- BedsTotal: 4
- Full Baths: 2
- Land Area (sf): 9,289
- Living (sf): 2,204
- Year Built: 1963
- Property Condition: Excellent
- Number of Parking Spaces: 2
- View: Marina/Canal,Mountain
- Listing Office: eXp Realty
- Land Tenure: FS - Fee Simple