Previous Next

174 Hauoli Street Kailua, HI 96734

Listing
Overview

Price: $1,945,000
Area: KALAMA TRACT
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202513418"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(3) "174"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Hauoli"
  }
  ["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) "1945000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(12) "KALAMA TRACT"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1198) "Opportunity to live a block to Kalama Beach Park located in a highly desirable neighborhood of Kalama Tract. This newly renovated one story home with vaulted ceilings boast 4 bedrooms, 2 baths and a bonus room that can be used as an office/den, yoga/exercise room or an art studio. Other features include shaker cabinets, quartz countertops, stainless steel appliances, beverage fridge, pantry, tile & LVP flooring, ceiling fans, split AC, soaker tub and updated electrical & plumbing. Primary bedroom with sliding door opens out to a large brand new hot tub where you can enjoy private time to unwind & relax or spend time with family and friends. The expansive and spacious outdoor area provides many possibilities for creating your ideal outdoor oasis, great for barbeque and entertainment and a large space to build a pool, fully fenced yard with tropical landscaping. Large 2 car carport for vehicles and yard boat storage with extra parking. Outdoor shower to rinse off after a fun day at the beach. Minutes away to Buzz's steak house, Kalapawai Market, Target, Whole Foods, schools, parks, golf course, eateries and shops. Easy access to H-3, Likelike & Pali Hwy. Seller financing available."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(21) "MG Hawaii Realty, LLC"
  }
  ["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(8) "10000.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1657"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1926"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "8"
  }
  ["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(6) "Kailua"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kailua"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(7) "Kalaheo"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "KMBL"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "MGHawaiiRealty@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 489-5227"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(24) "Maribeth Agbayani George"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18787872"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-07-19T13:32:26.217"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-06-06"
  }
  ["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) "13:32:26.217"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27021336"
  }
  ["listing_image"]=>
  array(22) {
    [0]=>
    string(8) "27021336"
    [1]=>
    string(8) "27021337"
    [2]=>
    string(8) "27021338"
    [3]=>
    string(8) "27021339"
    [4]=>
    string(8) "27021340"
    [5]=>
    string(8) "27021341"
    [6]=>
    string(8) "27021342"
    [7]=>
    string(8) "27021343"
    [8]=>
    string(8) "27021344"
    [9]=>
    string(8) "27021345"
    [10]=>
    string(8) "27021346"
    [11]=>
    string(8) "27021347"
    [12]=>
    string(8) "27021348"
    [13]=>
    string(8) "27021349"
    [14]=>
    string(8) "27021350"
    [15]=>
    string(8) "27021351"
    [16]=>
    string(8) "27021352"
    [17]=>
    string(8) "27021353"
    [18]=>
    string(8) "27021354"
    [19]=>
    string(8) "27021355"
    [20]=>
    string(8) "27021356"
    [21]=>
    string(8) "27021357"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202513418
        )

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

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

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

    [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] => 1945000.00
        )

    [Neighbourhood] => Array
        (
            [0] => KALAMA TRACT
        )

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

    [PublicRemarks] => Array
        (
            [0] => Opportunity to live a block to Kalama Beach Park located in a highly desirable neighborhood of Kalama Tract. This newly renovated one story home with vaulted ceilings boast 4 bedrooms, 2 baths and a bonus room that can be used as an office/den, yoga/exercise room or an art studio. Other features include shaker cabinets, quartz countertops, stainless steel appliances, beverage fridge, pantry, tile & LVP flooring, ceiling fans, split AC, soaker tub and updated electrical & plumbing. Primary bedroom with sliding door opens out to a large brand new hot tub where you can enjoy private time to unwind & relax or spend time with family and friends. The expansive and spacious outdoor area provides many possibilities for creating your ideal outdoor oasis, great for barbeque and entertainment and a large space to build a pool, fully fenced yard with tropical landscaping. Large 2 car carport for vehicles and yard boat storage with extra parking. Outdoor shower to rinse off after a fun day at the beach. Minutes away to Buzz's steak house, Kalapawai Market, Target, Whole Foods, schools, parks, golf course, eateries and shops. Easy access to H-3, Likelike & Pali Hwy. Seller financing available.
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 489-5227
        )

    [ListAgentFullName] => Array
        (
            [0] => Maribeth Agbayani George
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-07-19T13:32:26.217
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-06-06
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 13:32:26.217
        )

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

    [listing_image] => Array
        (
            [0] => 27021336
            [1] => 27021337
            [2] => 27021338
            [3] => 27021339
            [4] => 27021340
            [5] => 27021341
            [6] => 27021342
            [7] => 27021343
            [8] => 27021344
            [9] => 27021345
            [10] => 27021346
            [11] => 27021347
            [12] => 27021348
            [13] => 27021349
            [14] => 27021350
            [15] => 27021351
            [16] => 27021352
            [17] => 27021353
            [18] => 27021354
            [19] => 27021355
            [20] => 27021356
            [21] => 27021357
        )

)

PROPERTY INFO

• BedsTotal: 4
• Full Baths: 2
• Land Area (sf): 10,000 sf
• Living (sf): 1,657
• Year Built: 1926

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 8
• View: Mountain
• Listing Office: MG Hawaii Realty, LLC

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Kailua
• 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 July 19, 2025 - 1:32 PM Information is deemed reliable but not guaranteed. Copyright: 2025 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.