Previous Next

87-274 Saint Johns Road Unit B Waianae, HI 96792

Listing
Overview

Price: $644,000
Area: MAILI
Status: Active Under Contract

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202514785"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "87-274"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(11) "Saint Johns"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(1) "B"
  }
  ["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) "644000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(5) "MAILI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1068) "Step into modern island living with this thoughtfully renovated 3-bedroom, 2-bath home in the coastal community of Maili. 

Inside, a bright & airy floor plan blends the stylish kitchen with the main living space, creating a seamless flow for daily life and entertaining. The kitchen boasts new stainless steel appliances, sleek quartz countertops, and updated cabinetry that blends function with style. Split AC units throughout ensure year-round comfort. Retreat to either of the two covered lanais—ideal for morning coffee, weekend BBQs, or simply enjoying the breeze. Both bathrooms feature spa-like finishes, including floor-to-ceiling tiled showers that add a clean, contemporary feel. 

The fenced yard offers privacy and low-maintenance landscaping, complete with an irrigation system to keep everything green. A covered carport & storage room provide added convenience for your gear and tools. Minutes from sandy beaches and everyday amenities, this move-in ready home is packed with upgrades—offering both value and lifestyle in one inviting package."
  }
  ["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(24) "jared.musser@compass.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 825-4277"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Jared O Musser"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18828004"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-12-18T12:38:08.593"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-06-24"
  }
  ["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) "12:38:08.593"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27043283"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27043283"
    [1]=>
    string(8) "27043284"
    [2]=>
    string(8) "27043285"
    [3]=>
    string(8) "27043286"
    [4]=>
    string(8) "27043287"
    [5]=>
    string(8) "27043288"
    [6]=>
    string(8) "27043289"
    [7]=>
    string(8) "27043290"
    [8]=>
    string(8) "27043291"
    [9]=>
    string(8) "27043292"
    [10]=>
    string(8) "27043293"
    [11]=>
    string(8) "27043294"
    [12]=>
    string(8) "27043295"
    [13]=>
    string(8) "27043296"
    [14]=>
    string(8) "27043297"
    [15]=>
    string(8) "27043298"
    [16]=>
    string(8) "27043299"
    [17]=>
    string(8) "27043300"
    [18]=>
    string(8) "27043301"
    [19]=>
    string(8) "27043302"
    [20]=>
    string(8) "27043303"
    [21]=>
    string(8) "27043304"
    [22]=>
    string(8) "27043305"
    [23]=>
    string(8) "27043306"
    [24]=>
    string(8) "27043307"
    [25]=>
    string(8) "27043308"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202514785
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Step into modern island living with this thoughtfully renovated 3-bedroom, 2-bath home in the coastal community of Maili. 

Inside, a bright & airy floor plan blends the stylish kitchen with the main living space, creating a seamless flow for daily life and entertaining. The kitchen boasts new stainless steel appliances, sleek quartz countertops, and updated cabinetry that blends function with style. Split AC units throughout ensure year-round comfort. Retreat to either of the two covered lanais—ideal for morning coffee, weekend BBQs, or simply enjoying the breeze. Both bathrooms feature spa-like finishes, including floor-to-ceiling tiled showers that add a clean, contemporary feel. 

The fenced yard offers privacy and low-maintenance landscaping, complete with an irrigation system to keep everything green. A covered carport & storage room provide added convenience for your gear and tools. Minutes from sandy beaches and everyday amenities, this move-in ready home is packed with upgrades—offering both value and lifestyle in one inviting package.
        )

    [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] => jared.musser@compass.com
        )

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

    [ListAgentFullName] => Array
        (
            [0] => Jared O Musser
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-12-18T12:38:08.593
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 12:38:08.593
        )

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

    [listing_image] => Array
        (
            [0] => 27043283
            [1] => 27043284
            [2] => 27043285
            [3] => 27043286
            [4] => 27043287
            [5] => 27043288
            [6] => 27043289
            [7] => 27043290
            [8] => 27043291
            [9] => 27043292
            [10] => 27043293
            [11] => 27043294
            [12] => 27043295
            [13] => 27043296
            [14] => 27043297
            [15] => 27043298
            [16] => 27043299
            [17] => 27043300
            [18] => 27043301
            [19] => 27043302
            [20] => 27043303
            [21] => 27043304
            [22] => 27043305
            [23] => 27043306
            [24] => 27043307
            [25] => 27043308
        )

)

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 December 18, 2025 - 12:38 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.