851 Halula Place Kailua, HI 96734

Take a Virtual Tour

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) 725-2794

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) 725-2794"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Tiare Lando"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-11-26T15:45:00.930"
  }
  ["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) 725-2794
        )

    [ListAgentFullName] => Array
        (
            [0] => Tiare Lando
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-11-26T15:45:00.930
        )

    [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

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446