Thanksgiving - The office will be closed on Thursday 11/27/25 and Friday 11/28/25
Christmas - The office will be closed on Thursday 12/25/25 and Friday 12/26/25
New Years - The office will be closed on Thursday 1/1/26 and Friday 1/2/26
Welcome to your slice of Waikiki paradise! This beautifully renovated condo offers the perfect blend of island living and investment opportunity! Step inside to discover a thoughtfully redesigned space featuring a stunning modern kitchen and clever custom built-ins, including a Murphy bed in the living room that seamlessly transforms into a comfortable couch. W/D in unit too! Enjoy the private lanai and catch glimpses of the Hilton's spectacular Friday night fireworks display in the distance.The location simply can't be beat—everything you could possibly need and more is within easy walking distance.The ultimate Waikiki lifestyle is right outside your door.!With incredibly low HOA fees and the flexibility for short-term rentals, this unit presents an exceptional opportunity for both owner-occupants and savvy investors looking to capitalize on Waikiki's thriving vacation rental market. Whether you're seeking a personal beach-side haven or a strong income-producing property, this condo delivers! Covered parking and keyed elevator access, too! Don't miss your chance to own a piece of paradise where the beach lifestyle is literally at your doorstep. Schedule your private viewing today! Listing by: Talk Realty LLC (603) 860-0064
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202524700"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "247"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(5) "Beach"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Walk"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "303"
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96815"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(83) "https://drive.google.com/file/d/1TScC3yRbgHlbIgEAiOFrI3DNR2jvea74/view?usp=drivesdk"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "525000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKIKI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1202) "Welcome to your slice of Waikiki paradise! This beautifully renovated condo offers the perfect blend of island living and investment opportunity! Step inside to discover a thoughtfully redesigned space featuring a stunning modern kitchen and clever custom built-ins, including a Murphy bed in the living room that seamlessly transforms into a comfortable couch. W/D in unit too! Enjoy the private lanai and catch glimpses of the Hilton's spectacular Friday night fireworks display in the distance.The location simply can't be beat—everything you could possibly need and more is within easy walking distance.The ultimate Waikiki lifestyle is right outside your door.!With incredibly low HOA fees and the flexibility for short-term rentals, this unit presents an exceptional opportunity for both owner-occupants and savvy investors looking to capitalize on Waikiki's thriving vacation rental market. Whether you're seeking a personal beach-side haven or a strong income-producing property, this condo delivers! Covered parking and keyed elevator access, too! Don't miss your chance to own a piece of paradise where the beach lifestyle is literally at your doorstep. Schedule your private viewing today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(15) "Talk Realty LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5009.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "572"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1960"
}
["BuildingName"]=>
array(1) {
[0]=>
string(15) "Niihau Apts Inc"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(4) "8-14"
}
["View"]=>
array(1) {
[0]=>
string(4) "City"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "452.09"
}
["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) "TALK"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "info@heatherstasiak.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(603) 860-0064"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "Heather L Stasiak"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19077402"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-12-11T10:32:49.860"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-11-03"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "10:32:49.860"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27207498"
}
["listing_image"]=>
array(19) {
[0]=>
string(8) "27207498"
[1]=>
string(8) "27207499"
[2]=>
string(8) "27207500"
[3]=>
string(8) "27207501"
[4]=>
string(8) "27207502"
[5]=>
string(8) "27207503"
[6]=>
string(8) "27207504"
[7]=>
string(8) "27207505"
[8]=>
string(8) "27207506"
[9]=>
string(8) "27207507"
[10]=>
string(8) "27207508"
[11]=>
string(8) "27207509"
[12]=>
string(8) "27207510"
[13]=>
string(8) "27207511"
[14]=>
string(8) "27207512"
[15]=>
string(8) "27207513"
[16]=>
string(8) "27207514"
[17]=>
string(8) "27207515"
[18]=>
string(8) "27207516"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202524700
)
[StreetNumber] => Array
(
[0] => 247
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Beach
)
[StreetSuffix] => Array
(
[0] => Walk
)
[UnitNumber] => Array
(
[0] => 303
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96815
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://drive.google.com/file/d/1TScC3yRbgHlbIgEAiOFrI3DNR2jvea74/view?usp=drivesdk
)
[ListPrice] => Array
(
[0] => 525000.00
)
[Neighbourhood] => Array
(
[0] => WAIKIKI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to your slice of Waikiki paradise! This beautifully renovated condo offers the perfect blend of island living and investment opportunity! Step inside to discover a thoughtfully redesigned space featuring a stunning modern kitchen and clever custom built-ins, including a Murphy bed in the living room that seamlessly transforms into a comfortable couch. W/D in unit too! Enjoy the private lanai and catch glimpses of the Hilton's spectacular Friday night fireworks display in the distance.The location simply can't be beat—everything you could possibly need and more is within easy walking distance.The ultimate Waikiki lifestyle is right outside your door.!With incredibly low HOA fees and the flexibility for short-term rentals, this unit presents an exceptional opportunity for both owner-occupants and savvy investors looking to capitalize on Waikiki's thriving vacation rental market. Whether you're seeking a personal beach-side haven or a strong income-producing property, this condo delivers! Covered parking and keyed elevator access, too! Don't miss your chance to own a piece of paradise where the beach lifestyle is literally at your doorstep. Schedule your private viewing today!
)
[ListOfficeName] => Array
(
[0] => Talk Realty LLC
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5009.00
)
[SqftTotal] => Array
(
[0] => 572
)
[YearBuilt] => Array
(
[0] => 1960
)
[BuildingName] => Array
(
[0] => Niihau Apts Inc
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 8-14
)
[View] => Array
(
[0] => City
)
[MaintenanceExpense] => Array
(
[0] => 452.09
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => TALK
)
[ListAgentEmail] => Array
(
[0] => info@heatherstasiak.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (603) 860-0064
)
[ListAgentFullName] => Array
(
[0] => Heather L Stasiak
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19077402
)
[MatrixModifiedDT] => Array
(
[0] => 2025-12-11T10:32:49.860
)
[ListingContractDate] => Array
(
[0] => 2025-11-03
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 10:32:49.860
)
[_thumbnail_id] => Array
(
[0] => 27207498
)
[listing_image] => Array
(
[0] => 27207498
[1] => 27207499
[2] => 27207500
[3] => 27207501
[4] => 27207502
[5] => 27207503
[6] => 27207504
[7] => 27207505
[8] => 27207506
[9] => 27207507
[10] => 27207508
[11] => 27207509
[12] => 27207510
[13] => 27207511
[14] => 27207512
[15] => 27207513
[16] => 27207514
[17] => 27207515
[18] => 27207516
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on December 11, 2025 - 10:32 AM
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.
