87-274 Saint Johns Road Unit B Waianae, HI 96792
Listing
Overview
Price: $689,000
Area: MAILI
Status: Active
Step into modern island living with this thoughtfully renovated 3-bedroom, 2-bath home in the coastal community of Maili. Located in a USDA-approved financing area, this property may qualify for zero down—making homeownership more accessible than ever.
Inside, a bright and airy floor plan connects the stylish kitchen to 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 and 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. Listing by: Compass (808) 497-0503
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) "689000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(5) "MAILI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1205) "Step into modern island living with this thoughtfully renovated 3-bedroom, 2-bath home in the coastal community of Maili. Located in a USDA-approved financing area, this property may qualify for zero down—making homeownership more accessible than ever.
Inside, a bright and airy floor plan connects the stylish kitchen to 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 and 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) 497-0503"
}
["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-06-29T17:00:01.380"
}
["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) "17:00:01.380"
}
["_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] => 689000.00
)
[Neighbourhood] => Array
(
[0] => MAILI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Step into modern island living with this thoughtfully renovated 3-bedroom, 2-bath home in the coastal community of Maili. Located in a USDA-approved financing area, this property may qualify for zero down—making homeownership more accessible than ever.
Inside, a bright and airy floor plan connects the stylish kitchen to 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 and 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) 497-0503
)
[ListAgentFullName] => Array
(
[0] => Jared O Musser
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18828004
)
[MatrixModifiedDT] => Array
(
[0] => 2025-06-29T17:00:01.380
)
[ListingContractDate] => Array
(
[0] => 2025-06-24
)
[MLSAreaMajor] => Array
(
[0] => Leeward
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:01.380
)
[_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
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 5,780 sf
- Living (sf): 1,178
- Year Built: 1965
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 4
- View: None
- Listing Office: Compass
- Land Tenure: FS - Fee Simple
- Elementary School: Maili
- Middle School: Waianae
- High School: Waianae
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on June 29, 2025 - 5:00 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.
© Marcus Realty. All Rights Reserved.
