Previous Next

1504 Ainakoa Avenue Honolulu, HI 96821

Listing
Overview

Price: $1,888,000
Area: WAIALAE NUI-LWR
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202510514"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "1504"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Ainakoa"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Avenue"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96821"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1888000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(15) "WAIALAE NUI-LWR"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1200) "Exceptional Brand New Home! This nearly new 1-story gem is designed with comfort & accessibility in mind, perfect for families looking to age-in-place. Step into a spacious & inviting entry foyer that flows seamlessly into the open kitchen, dining, & living areas—ideal for entertaining family and friends! This home features 4 generous bdrms & 3 full baths, ensuring ample space for everyone. You'll appreciate the abundance of storage options, including a walk-in pantry, entry closet, & a dedicated laundry room. The entry porch offers convenient access to the enclosed two-car garage. Quality upgrades abound, showcasing luxury vinyl tile floors & stylish sand wash cabinets in the kitchen & baths, complemented by quartz countertops. Additional features include energy-efficient LED lighting, a 200 amp service, double-pane windows, & insulated double walls. The rear yard is low-maintenance, boasting a mature avocado tree & space for your gardening dreams. Nestled in the desirable Waialae Nui neighborhood, this home is situated on a peaceful street with no rear neighbors. Easy access to the mall, freeways, top-rated schools, parks, golf course, & all the conveniences of the Kahala area."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "BHGRE Advantage Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "5000.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2085"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1957"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(13) "City,Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(6) "Wilson"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(7) "Kaimuki"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kalani"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "ADVG"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(20) "Mathew@MathewNgo.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 738-3600"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(10) "Mathew Ngo"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18703719"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-05-18T22:25:31.990"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-04-22"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(9) "DiamondHd"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "22:25:31.990"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26967545"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26967545"
    [1]=>
    string(8) "26967546"
    [2]=>
    string(8) "26967547"
    [3]=>
    string(8) "26967548"
    [4]=>
    string(8) "26967549"
    [5]=>
    string(8) "26967550"
    [6]=>
    string(8) "26967551"
    [7]=>
    string(8) "26967552"
    [8]=>
    string(8) "26967553"
    [9]=>
    string(8) "26967554"
    [10]=>
    string(8) "26967555"
    [11]=>
    string(8) "26967556"
    [12]=>
    string(8) "26967557"
    [13]=>
    string(8) "26967558"
    [14]=>
    string(8) "26967559"
    [15]=>
    string(8) "26967560"
    [16]=>
    string(8) "26967561"
    [17]=>
    string(8) "26967562"
    [18]=>
    string(8) "26967563"
    [19]=>
    string(8) "26967564"
    [20]=>
    string(8) "26967565"
    [21]=>
    string(8) "26967566"
    [22]=>
    string(8) "26967567"
    [23]=>
    string(8) "26967568"
    [24]=>
    string(8) "26967569"
    [25]=>
    string(8) "26967570"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202510514
        )

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

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

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => WAIALAE NUI-LWR
        )

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

    [PublicRemarks] => Array
        (
            [0] => Exceptional Brand New Home! This nearly new 1-story gem is designed with comfort & accessibility in mind, perfect for families looking to age-in-place. Step into a spacious & inviting entry foyer that flows seamlessly into the open kitchen, dining, & living areas—ideal for entertaining family and friends! This home features 4 generous bdrms & 3 full baths, ensuring ample space for everyone. You'll appreciate the abundance of storage options, including a walk-in pantry, entry closet, & a dedicated laundry room. The entry porch offers convenient access to the enclosed two-car garage. Quality upgrades abound, showcasing luxury vinyl tile floors & stylish sand wash cabinets in the kitchen & baths, complemented by quartz countertops. Additional features include energy-efficient LED lighting, a 200 amp service, double-pane windows, & insulated double walls. The rear yard is low-maintenance, boasting a mature avocado tree & space for your gardening dreams. Nestled in the desirable Waialae Nui neighborhood, this home is situated on a peaceful street with no rear neighbors. Easy access to the mall, freeways, top-rated schools, parks, golf course, & all the conveniences of the Kahala area.
        )

    [ListOfficeName] => Array
        (
            [0] => BHGRE Advantage Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Mathew@MathewNgo.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 738-3600
        )

    [ListAgentFullName] => Array
        (
            [0] => Mathew Ngo
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-05-18T22:25:31.990
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-04-22
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 22:25:31.990
        )

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

    [listing_image] => Array
        (
            [0] => 26967545
            [1] => 26967546
            [2] => 26967547
            [3] => 26967548
            [4] => 26967549
            [5] => 26967550
            [6] => 26967551
            [7] => 26967552
            [8] => 26967553
            [9] => 26967554
            [10] => 26967555
            [11] => 26967556
            [12] => 26967557
            [13] => 26967558
            [14] => 26967559
            [15] => 26967560
            [16] => 26967561
            [17] => 26967562
            [18] => 26967563
            [19] => 26967564
            [20] => 26967565
            [21] => 26967566
            [22] => 26967567
            [23] => 26967568
            [24] => 26967569
            [25] => 26967570
        )

)

PROPERTY INFO

• BedsTotal: 4
• Full Baths: 3
• Land Area (sf): 5,000 sf
• Living (sf): 2,085
• Year Built: 1957

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 4
• View: City,Mountain
• Listing Office: BHGRE Advantage Realty

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Wilson
• Middle School: Kaimuki
• High School: Kalani

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 May 18, 2025 - 10:25 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.