Previous Next

87-274 St Johns Road Unit A Waianae, HI 96792

Listing
Overview

Price: $689,000
Area: MAILI
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202512049"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "87-274"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "St Johns"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(1) "A"
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Waianae"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96792"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "689000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(5) "MAILI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1171) "Experience the ideal mix of contemporary comfort and island living in this beautifully upgraded 3-bedroom, 2-bath home nestled in the heart of Maili. With a bright and open layout, the kitchen seamlessly connects to the main living area—perfect for everyday living or hosting get-togethers. Enjoy cooking in the modern kitchen featuring all-new appliances, fresh cabinetry, and sleek quartz counters. Stay comfortable year-round with brand new split AC units, and take advantage of not one, but two covered lanais—ideal for morning coffee, evening pau hana, or weekend BBQs. 

The spa-like bathrooms are outfitted with floor-to-ceiling tiled showers for a clean, modern touch. Outside, you can enjoy the fenced yard with vinyl fencing that offers privacy and security, complemented by an irrigation system to keep your plants green and outdoor space vibrant. A covered carport provides convenient parking and includes a spacious storage closet for all your outdoor gear. Just a short drive to Maili Beach Park, this home combines stylish finishes and smart design in a relaxed coastal setting. Move-in ready with all the upgrades—come see why this one stands out."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(7) "Compass"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "5780.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1178"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1965"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(23) "Excellent,Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(5) "Maili"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waianae"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waianae"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "COHI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(27) "jessicaharrison@compass.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Jessica Harrison"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18747667"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-07-25T15:20:51.083"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-05-14"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Leeward"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "15:20:51.083"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26996809"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26996809"
    [1]=>
    string(8) "26996810"
    [2]=>
    string(8) "26996811"
    [3]=>
    string(8) "26996812"
    [4]=>
    string(8) "26996813"
    [5]=>
    string(8) "26996814"
    [6]=>
    string(8) "26996815"
    [7]=>
    string(8) "26996816"
    [8]=>
    string(8) "26996817"
    [9]=>
    string(8) "26996818"
    [10]=>
    string(8) "26996819"
    [11]=>
    string(8) "26996820"
    [12]=>
    string(8) "26996821"
    [13]=>
    string(8) "26996822"
    [14]=>
    string(8) "26996823"
    [15]=>
    string(8) "26996824"
    [16]=>
    string(8) "26996825"
    [17]=>
    string(8) "26996826"
    [18]=>
    string(8) "26996827"
    [19]=>
    string(8) "26996828"
    [20]=>
    string(8) "26996829"
    [21]=>
    string(8) "26996830"
    [22]=>
    string(8) "26996831"
    [23]=>
    string(8) "26996832"
    [24]=>
    string(8) "26996833"
    [25]=>
    string(8) "26996834"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202512049
        )

    [StreetNumber] => Array
        (
            [0] => 87-274
        )

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

    [StreetName] => Array
        (
            [0] => St Johns
        )

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Experience the ideal mix of contemporary comfort and island living in this beautifully upgraded 3-bedroom, 2-bath home nestled in the heart of Maili. With a bright and open layout, the kitchen seamlessly connects to the main living area—perfect for everyday living or hosting get-togethers. Enjoy cooking in the modern kitchen featuring all-new appliances, fresh cabinetry, and sleek quartz counters. Stay comfortable year-round with brand new split AC units, and take advantage of not one, but two covered lanais—ideal for morning coffee, evening pau hana, or weekend BBQs. 

The spa-like bathrooms are outfitted with floor-to-ceiling tiled showers for a clean, modern touch. Outside, you can enjoy the fenced yard with vinyl fencing that offers privacy and security, complemented by an irrigation system to keep your plants green and outdoor space vibrant. A covered carport provides convenient parking and includes a spacious storage closet for all your outdoor gear. Just a short drive to Maili Beach Park, this home combines stylish finishes and smart design in a relaxed coastal setting. Move-in ready with all the upgrades—come see why this one stands out.
        )

    [ListOfficeName] => Array
        (
            [0] => Compass
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => jessicaharrison@compass.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 825-4277
        )

    [ListAgentFullName] => Array
        (
            [0] => Jessica Harrison
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-07-25T15:20:51.083
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-05-14
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 15:20:51.083
        )

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

    [listing_image] => Array
        (
            [0] => 26996809
            [1] => 26996810
            [2] => 26996811
            [3] => 26996812
            [4] => 26996813
            [5] => 26996814
            [6] => 26996815
            [7] => 26996816
            [8] => 26996817
            [9] => 26996818
            [10] => 26996819
            [11] => 26996820
            [12] => 26996821
            [13] => 26996822
            [14] => 26996823
            [15] => 26996824
            [16] => 26996825
            [17] => 26996826
            [18] => 26996827
            [19] => 26996828
            [20] => 26996829
            [21] => 26996830
            [22] => 26996831
            [23] => 26996832
            [24] => 26996833
            [25] => 26996834
        )

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 2
• Land Area (sf): 5,780 sf
• Living (sf): 1,178
• Year Built: 1965

KEY FEATURES

• Property Condition: Excellent,Above Average
• Number of Parking Spaces: 4
• View: None
• Listing Office: Compass

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Maili
• Middle School: Waianae
• High School: Waianae

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 25, 2025 - 3:20 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.