87-274 A Saint Johns Road Waianae, HI 96792
Listing
Overview
Price: $749,000
Area: MAILI
Status: Active
Welcome to your slice of paradise! This stunning home is move-in ready and conveniently situated near beautiful beaches. Featuring brand-new everything, including flooring, paint, lighting, plumbing, roof, and even the carport down to the slab, this 3-bedroom, 2-bathroom haven offers the epitome of modern living. Enjoy the spacious, landscaped yard and relax on the lovely lanai in both the front and back yard. The carport is designed to accommodate large and high vehicles, easily fitting 4 vehicles. Perfect for first-time homeowners, this gem is a must-see! Listing by: West Beach Realty, Inc. (808) 696-4774
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202411438"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(8) "87-274 A"
}
["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(0) ""
}
["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) "749000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "749000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(5) "MAILI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(564) "Welcome to your slice of paradise! This stunning home is move-in ready and conveniently situated near beautiful beaches. Featuring brand-new everything, including flooring, paint, lighting, plumbing, roof, and even the carport down to the slab, this 3-bedroom, 2-bathroom haven offers the epitome of modern living. Enjoy the spacious, landscaped yard and relax on the lovely lanai in both the front and back yard. The carport is designed to accommodate large and high vehicles, easily fitting 4 vehicles. Perfect for first-time homeowners, this gem is a must-see!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(23) "West Beach Realty, Inc."
}
["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) "1000"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2023"
}
["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(14) "Mountain,Other"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "WEBR"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(20) "katkelii77@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 696-4774"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Katherine Kelii"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-29T17:00:01.173"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18011008"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-05-17T17:00:46.627"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Leeward"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26285620"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26285620"
[1]=>
string(8) "26285621"
[2]=>
string(8) "26285622"
[3]=>
string(8) "26285623"
[4]=>
string(8) "26285624"
[5]=>
string(8) "26285625"
[6]=>
string(8) "26285626"
[7]=>
string(8) "26285627"
[8]=>
string(8) "26285628"
[9]=>
string(8) "26285629"
[10]=>
string(8) "26285630"
[11]=>
string(8) "26285631"
[12]=>
string(8) "26285632"
[13]=>
string(8) "26285633"
[14]=>
string(8) "26285634"
[15]=>
string(8) "26285635"
[16]=>
string(8) "26285636"
[17]=>
string(8) "26285637"
[18]=>
string(8) "26285638"
[19]=>
string(8) "26285639"
[20]=>
string(8) "26285640"
[21]=>
string(8) "26285641"
[22]=>
string(8) "26285642"
[23]=>
string(8) "26285643"
[24]=>
string(8) "26285644"
[25]=>
string(8) "26285645"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202411438
)
[StreetNumber] => Array
(
[0] => 87-274 A
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Saint Johns
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waianae
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96792
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 749000.00
)
[CurrentPrice] => Array
(
[0] => 749000.00
)
[Neighbourhood] => Array
(
[0] => MAILI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to your slice of paradise! This stunning home is move-in ready and conveniently situated near beautiful beaches. Featuring brand-new everything, including flooring, paint, lighting, plumbing, roof, and even the carport down to the slab, this 3-bedroom, 2-bathroom haven offers the epitome of modern living. Enjoy the spacious, landscaped yard and relax on the lovely lanai in both the front and back yard. The carport is designed to accommodate large and high vehicles, easily fitting 4 vehicles. Perfect for first-time homeowners, this gem is a must-see!
)
[ListOfficeName] => Array
(
[0] => West Beach Realty, Inc.
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5780.00
)
[SqftTotal] => Array
(
[0] => 1000
)
[YearBuilt] => Array
(
[0] => 2023
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Mountain,Other
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => WEBR
)
[ListAgentEmail] => Array
(
[0] => katkelii77@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 696-4774
)
[ListAgentFullName] => Array
(
[0] => Katherine Kelii
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-29T17:00:01.173
)
[Matrix_Unique_ID] => Array
(
[0] => 18011008
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-05-17T17:00:46.627
)
[MLSAreaMajor] => Array
(
[0] => Leeward
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26285620
)
[listing_image] => Array
(
[0] => 26285620
[1] => 26285621
[2] => 26285622
[3] => 26285623
[4] => 26285624
[5] => 26285625
[6] => 26285626
[7] => 26285627
[8] => 26285628
[9] => 26285629
[10] => 26285630
[11] => 26285631
[12] => 26285632
[13] => 26285633
[14] => 26285634
[15] => 26285635
[16] => 26285636
[17] => 26285637
[18] => 26285638
[19] => 26285639
[20] => 26285640
[21] => 26285641
[22] => 26285642
[23] => 26285643
[24] => 26285644
[25] => 26285645
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 5,780
- Living (sf): 1,000
- Year Built: 2023
- Property Condition: Excellent
- Number of Parking Spaces: 4
- View: Mountain,Other
- Listing Office: West Beach Realty, Inc.
- Land Tenure: FS - Fee Simple
