87274 Saint Johns Road Waianae, HI 96792
Listing
Overview
Price: $749,000
Area: MAILI
Status: Active
This stunning, move-in ready home is conveniently located near beautiful beaches. The home is brand new with everything updated. With 3 bedrooms and 2 bathrooms, this modern haven offers the epitome of contemporary living. Enjoy the spacious, landscaped yard and relax on the lovely lanais in both the front and back yards. The carport is designed to accommodate large and high vehicles, easily fitting up to four. 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) "202411894"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(5) "87274"
}
["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(476) "This stunning, move-in ready home is conveniently located near beautiful beaches. The home is brand new with everything updated. With 3 bedrooms and 2 bathrooms, this modern haven offers the epitome of contemporary living. Enjoy the spacious, landscaped yard and relax on the lovely lanais in both the front and back yards. The carport is designed to accommodate large and high vehicles, easily fitting up to four. 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) "2021"
}
["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(5) "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) "18023184"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-05-25T12:14:34.753"
}
["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) "26439295"
}
["listing_image"]=>
array(19) {
[0]=>
string(8) "26439295"
[1]=>
string(8) "26439296"
[2]=>
string(8) "26439297"
[3]=>
string(8) "26439298"
[4]=>
string(8) "26439299"
[5]=>
string(8) "26439300"
[6]=>
string(8) "26439301"
[7]=>
string(8) "26439302"
[8]=>
string(8) "26439303"
[9]=>
string(8) "26439304"
[10]=>
string(8) "26439305"
[11]=>
string(8) "26439306"
[12]=>
string(8) "26439307"
[13]=>
string(8) "26439308"
[14]=>
string(8) "26439309"
[15]=>
string(8) "26439310"
[16]=>
string(8) "26439311"
[17]=>
string(8) "26439312"
[18]=>
string(8) "26439313"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202411894
)
[StreetNumber] => Array
(
[0] => 87274
)
[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] => This stunning, move-in ready home is conveniently located near beautiful beaches. The home is brand new with everything updated. With 3 bedrooms and 2 bathrooms, this modern haven offers the epitome of contemporary living. Enjoy the spacious, landscaped yard and relax on the lovely lanais in both the front and back yards. The carport is designed to accommodate large and high vehicles, easily fitting up to four. 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] => 2021
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => 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] => 18023184
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-05-25T12:14:34.753
)
[MLSAreaMajor] => Array
(
[0] => Leeward
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26439295
)
[listing_image] => Array
(
[0] => 26439295
[1] => 26439296
[2] => 26439297
[3] => 26439298
[4] => 26439299
[5] => 26439300
[6] => 26439301
[7] => 26439302
[8] => 26439303
[9] => 26439304
[10] => 26439305
[11] => 26439306
[12] => 26439307
[13] => 26439308
[14] => 26439309
[15] => 26439310
[16] => 26439311
[17] => 26439312
[18] => 26439313
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 5,780
- Living (sf): 1,000
- Year Built: 2021
- Property Condition: Excellent
- Number of Parking Spaces: 4
- View: Other
- Listing Office: West Beach Realty, Inc.
- Land Tenure: FS - Fee Simple
