823 Halula Place Kailua, HI 96734

Take a Virtual Tour

Listing
Overview

Price: $2,099,000
Area: ENCHANTED LAKE
Status: Active

Tucked away at the end of one of the quietest cul-de-sacs in Enchanted Lake! This beautiful move-in ready home includes four bedrooms, four baths, two kitchens, and two living room rooms! Inside, enjoy a spacious open-concept layout with high ceilings, creating a bright and airy feel throughout. The home features Koa hardwood cabinets, solid wood flooring, granite flooring, split AC units, two modern kitchens, large waterfall art piece made of slate and copper, brand new Kitchen Aid appliances and brand new solar hot water heater. Perfect for everyday living and entertaining. The permitted ohana unit can be separated into a 1-bedroom, 1-bath living area, ideal for extended family or guests. Step outside to a large private, lush backyard, perfect for relaxing or hosting while taking in the surrounding greenery. Fruit trees include: avocado, apple banana, dessert banana, papayas, Noni, and mango. Landscaping includes Hala, Areca palms, giant birds of paradise, plenty of open space for entertaining. A rare opportunity to own a move-in ready home at this size and price in highly desirable Kailua. Owner is listing agent. Virtual Tour: my.matterport.com/show/?m=SxJkbTX4upp&mls=1 Listing by: SC Realty, LLC (808) 399-0700

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202615042"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(3) "823"
  }
  ["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(51) "https://my.matterport.com/show/?m=SxJkbTX4upp&mls=1"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "2099000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(14) "ENCHANTED LAKE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1191) "Tucked away at the end of one of the quietest cul-de-sacs in Enchanted Lake! This beautiful move-in ready home includes four bedrooms, four baths, two kitchens, and two living room rooms! Inside, enjoy a spacious open-concept layout with high ceilings, creating a bright and airy feel throughout. The home features Koa hardwood cabinets, solid wood flooring, granite flooring, split AC units, two modern kitchens, large waterfall art piece made of slate and copper, brand new Kitchen Aid appliances and brand new solar hot water heater. Perfect for everyday living and entertaining. The permitted ohana unit can be separated into a 1-bedroom, 1-bath living area, ideal for extended family or guests. Step outside to a large private, lush backyard, perfect for relaxing or hosting while taking in the surrounding greenery. Fruit trees include: avocado, apple banana, dessert banana, papayas, Noni, and mango. Landscaping includes Hala, Areca palms, giant birds of paradise, plenty of open space for entertaining. A rare opportunity to own a move-in ready home at this size and price in highly desirable Kailua. Owner is listing agent. Virtual Tour: my.matterport.com/show/?m=SxJkbTX4upp&mls=1"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(14) "SC Realty, LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "8889.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "3155"
  }
  ["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(8) "Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(14) "Enchanted Lake"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kailua"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(7) "Kalaheo"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "SCRE"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(23) "mattfoster310@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 399-0700"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Matthew Foster"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19619986"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-09-09T06:33:40.300"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-08-10"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(6) "Kailua"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "06:33:40.300"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27487039"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27487039"
    [1]=>
    string(8) "27487040"
    [2]=>
    string(8) "27487041"
    [3]=>
    string(8) "27487042"
    [4]=>
    string(8) "27487043"
    [5]=>
    string(8) "27487044"
    [6]=>
    string(8) "27487045"
    [7]=>
    string(8) "27487046"
    [8]=>
    string(8) "27487047"
    [9]=>
    string(8) "27487048"
    [10]=>
    string(8) "27487049"
    [11]=>
    string(8) "27487050"
    [12]=>
    string(8) "27487051"
    [13]=>
    string(8) "27487052"
    [14]=>
    string(8) "27487053"
    [15]=>
    string(8) "27487054"
    [16]=>
    string(8) "27487055"
    [17]=>
    string(8) "27487056"
    [18]=>
    string(8) "27487057"
    [19]=>
    string(8) "27487058"
    [20]=>
    string(8) "27487059"
    [21]=>
    string(8) "27487060"
    [22]=>
    string(8) "27487061"
    [23]=>
    string(8) "27487062"
    [24]=>
    string(8) "27487063"
    [25]=>
    string(8) "27487064"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202615042
        )

    [StreetNumber] => Array
        (
            [0] => 823
        )

    [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://my.matterport.com/show/?m=SxJkbTX4upp&mls=1
        )

    [ListPrice] => Array
        (
            [0] => 2099000.00
        )

    [Neighbourhood] => Array
        (
            [0] => ENCHANTED LAKE
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => Tucked away at the end of one of the quietest cul-de-sacs in Enchanted Lake! This beautiful move-in ready home includes four bedrooms, four baths, two kitchens, and two living room rooms! Inside, enjoy a spacious open-concept layout with high ceilings, creating a bright and airy feel throughout. The home features Koa hardwood cabinets, solid wood flooring, granite flooring, split AC units, two modern kitchens, large waterfall art piece made of slate and copper, brand new Kitchen Aid appliances and brand new solar hot water heater. Perfect for everyday living and entertaining. The permitted ohana unit can be separated into a 1-bedroom, 1-bath living area, ideal for extended family or guests. Step outside to a large private, lush backyard, perfect for relaxing or hosting while taking in the surrounding greenery. Fruit trees include: avocado, apple banana, dessert banana, papayas, Noni, and mango. Landscaping includes Hala, Areca palms, giant birds of paradise, plenty of open space for entertaining. A rare opportunity to own a move-in ready home at this size and price in highly desirable Kailua. Owner is listing agent. Virtual Tour: my.matterport.com/show/?m=SxJkbTX4upp&mls=1
        )

    [ListOfficeName] => Array
        (
            [0] => SC Realty, LLC
        )

    [BedsTotal] => Array
        (
            [0] => 4
        )

    [BathsFull] => Array
        (
            [0] => 4
        )

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

    [LotSizeArea] => Array
        (
            [0] => 8889.00
        )

    [SqftTotal] => Array
        (
            [0] => 3155
        )

    [YearBuilt] => Array
        (
            [0] => 1963
        )

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

    [PropertyCondition] => Array
        (
            [0] => Excellent
        )

    [ParkingTotal] => Array
        (
            [0] => 2
        )

    [StoriesType] => Array
        (
            [0] => One
        )

    [View] => Array
        (
            [0] => Mountain
        )

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

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => Enchanted Lake
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => Kailua
        )

    [HighSchool] => Array
        (
            [0] => Kalaheo
        )

    [ListOfficeMLSID] => Array
        (
            [0] => SCRE
        )

    [ListAgentEmail] => Array
        (
            [0] => mattfoster310@gmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 399-0700
        )

    [ListAgentFullName] => Array
        (
            [0] => Matthew Foster
        )

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

    [Matrix_Unique_ID] => Array
        (
            [0] => 19619986
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-09-09T06:33:40.300
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-08-10
        )

    [MLSAreaMajor] => Array
        (
            [0] => Kailua
        )

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 06:33:40.300
        )

    [_thumbnail_id] => Array
        (
            [0] => 27487039
        )

    [listing_image] => Array
        (
            [0] => 27487039
            [1] => 27487040
            [2] => 27487041
            [3] => 27487042
            [4] => 27487043
            [5] => 27487044
            [6] => 27487045
            [7] => 27487046
            [8] => 27487047
            [9] => 27487048
            [10] => 27487049
            [11] => 27487050
            [12] => 27487051
            [13] => 27487052
            [14] => 27487053
            [15] => 27487054
            [16] => 27487055
            [17] => 27487056
            [18] => 27487057
            [19] => 27487058
            [20] => 27487059
            [21] => 27487060
            [22] => 27487061
            [23] => 27487062
            [24] => 27487063
            [25] => 27487064
        )

)

  • BedsTotal: 4
  • Full Baths: 4
  • Land Area (sf): 8,889 sf
  • Living (sf): 3,155
  • Year Built: 1963

  • Property Condition: Excellent
  • Number of Parking Spaces: 2
  • View: Mountain
  • Listing Office: SC Realty, LLC

  • Land Tenure: FS - Fee Simple

  • Elementary School: Enchanted Lake
  • Middle School: Kailua
  • High School: Kalaheo

CONTACT US

Marcus Realty

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

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on September 9, 2026 - 6:33 AM Information is deemed reliable but not guaranteed. Copyright: 2026 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®. If you are interested in those active listings, our company may represent you as the buyer's agent. If the active listing you are interested in is our company's active listing, you may speak to one of our agents regarding your options for representation.

© Marcus Realty. All Rights Reserved.