Previous Next

564 Uluhala Street Kailua, HI 96734

Listing
Overview

Price: $1,450,000
Area: OLOMANA
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202611773"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(3) "564"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Uluhala"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["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(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1450000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "OLOMANA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1199) "THE ONE YOU'VE BEEN WAITING FOR! Single-level 4 bedroom with a BIG Living Room and an even BIGGER Family Room, plus an open dining area opposite the newly updated Kitchen — all-stainless appliances, deep stainless sink, gleaming new quartz counters. Dishwasher, disposal, cooktop, and microwave are brand new; built-in oven is near-new. Nice-size utility room too, with extra storage including a clever broom closet, plus washer, dryer, and utility sink. Bare toes will love the cushy new carpet in the bedrooms and new luxury vinyl plank flooring everywhere else. Every inch, inside and out, freshly painted.
The yard is a tropical Garden of Eden: 5 kinds of mango on one tree, Jamaican and yellow lilikoi, Meyer lemons, limes, oranges, calamansi, bananas. For lei-making — puakenikeni and green rose out front, stephanotis winding the mailbox, pakalana on the arbor, purple crown flowers in back. Vase-fillers galore too: roses, red ginger, torch ginger, heleconias, Song of India. Or get cooking with mint, Cuban oregano, lemon grass, and butterfly blue peas! 
Celebrate with an umbrella drink under the retractable awning on the lanai. Offers will be reviewed by Seller on Friday, June 26."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(19) "Judy Barrett 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) "7742.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1811"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1961"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(23) "Excellent,Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(15) "Garden,Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(9) "Maunawili"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kailua"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kailua"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "JBAR"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(21) "judyb@judybarrett.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 263-0250"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Judy Barrett"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19524905"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-06-22T21:18:24.063"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-06-19"
  }
  ["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) "21:18:24.063"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27430623"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "27430623"
    [1]=>
    string(8) "27430624"
    [2]=>
    string(8) "27430625"
    [3]=>
    string(8) "27430626"
    [4]=>
    string(8) "27430627"
    [5]=>
    string(8) "27430628"
    [6]=>
    string(8) "27430629"
    [7]=>
    string(8) "27430630"
    [8]=>
    string(8) "27430631"
    [9]=>
    string(8) "27430632"
    [10]=>
    string(8) "27430633"
    [11]=>
    string(8) "27430634"
    [12]=>
    string(8) "27430635"
    [13]=>
    string(8) "27430636"
    [14]=>
    string(8) "27430637"
    [15]=>
    string(8) "27430638"
    [16]=>
    string(8) "27430639"
    [17]=>
    string(8) "27430640"
    [18]=>
    string(8) "27430641"
    [19]=>
    string(8) "27430642"
    [20]=>
    string(8) "27430643"
    [21]=>
    string(8) "27431415"
    [22]=>
    string(8) "27431416"
    [23]=>
    string(8) "27431417"
    [24]=>
    string(8) "27431418"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202611773
        )

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

    [PropertyType] => Array
        (
            [0] => Single Family
        )

    [StreetName] => Array
        (
            [0] => Uluhala
        )

    [StreetSuffix] => Array
        (
            [0] => Street
        )

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

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

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96734
        )

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

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

    [Neighbourhood] => Array
        (
            [0] => OLOMANA
        )

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

    [PublicRemarks] => Array
        (
            [0] => THE ONE YOU'VE BEEN WAITING FOR! Single-level 4 bedroom with a BIG Living Room and an even BIGGER Family Room, plus an open dining area opposite the newly updated Kitchen — all-stainless appliances, deep stainless sink, gleaming new quartz counters. Dishwasher, disposal, cooktop, and microwave are brand new; built-in oven is near-new. Nice-size utility room too, with extra storage including a clever broom closet, plus washer, dryer, and utility sink. Bare toes will love the cushy new carpet in the bedrooms and new luxury vinyl plank flooring everywhere else. Every inch, inside and out, freshly painted.
The yard is a tropical Garden of Eden: 5 kinds of mango on one tree, Jamaican and yellow lilikoi, Meyer lemons, limes, oranges, calamansi, bananas. For lei-making — puakenikeni and green rose out front, stephanotis winding the mailbox, pakalana on the arbor, purple crown flowers in back. Vase-fillers galore too: roses, red ginger, torch ginger, heleconias, Song of India. Or get cooking with mint, Cuban oregano, lemon grass, and butterfly blue peas! 
Celebrate with an umbrella drink under the retractable awning on the lanai. Offers will be reviewed by Seller on Friday, June 26.
        )

    [ListOfficeName] => Array
        (
            [0] => Judy Barrett Realty
        )

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Excellent,Above Average
        )

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

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

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

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

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

    [ElementarySchool] => Array
        (
            [0] => Maunawili
        )

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => judyb@judybarrett.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 263-0250
        )

    [ListAgentFullName] => Array
        (
            [0] => Judy Barrett
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-06-22T21:18:24.063
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-06-19
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 21:18:24.063
        )

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

    [listing_image] => Array
        (
            [0] => 27430623
            [1] => 27430624
            [2] => 27430625
            [3] => 27430626
            [4] => 27430627
            [5] => 27430628
            [6] => 27430629
            [7] => 27430630
            [8] => 27430631
            [9] => 27430632
            [10] => 27430633
            [11] => 27430634
            [12] => 27430635
            [13] => 27430636
            [14] => 27430637
            [15] => 27430638
            [16] => 27430639
            [17] => 27430640
            [18] => 27430641
            [19] => 27430642
            [20] => 27430643
            [21] => 27431415
            [22] => 27431416
            [23] => 27431417
            [24] => 27431418
        )

)

PROPERTY INFO

• BedsTotal: 4
• Full Baths: 2
• Land Area (sf): 7,742 sf
• Living (sf): 1,811
• Year Built: 1961

KEY FEATURES

• Property Condition: Excellent,Above Average
• Number of Parking Spaces: 2
• View: Garden,Mountain
• Listing Office: Judy Barrett Realty

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Maunawili
• Middle School: Kailua
• High School: Kailua

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 June 22, 2026 - 9:18 PM 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.