Listing
Overview
			
			
			
			
				
Price:     $525,000
                    
                Area: WAIKIKI
                Status: Active
			
			 
			 
		 
	 
 
	
		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-11-03T09:33:21.710"
  }
  ["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) "09:33:21.710"
  }
  ["_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-11-03T09:33:21.710
        )
    [ListingContractDate] => Array
        (
            [0] => 2025-11-03
        )
    [MLSAreaMajor] => Array
        (
            [0] => Metro
        )
    [PropertyFrontage] => Array
        (
            [0] => 
        )
    [ExemptListingEntryTimestamp] => Array
        (
            [0] => 
        )
    [MatrixModifiedTime] => Array
        (
            [0] => 09:33:21.710
        )
    [_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
        )
)
	
		
			
			 
    
    
      
	      
	      
		       		      - BedsTotal:  1
 
		      		      		      - Full Baths:  1
 
		      		      		      		      - Land Area (sf):  5,009 sf
 
		      		      		      - Living (sf):  572
 
		      		      		       - Year Built:  1960
 
		      		      		       - Building Name:  Niihau Apts Inc
 
		      	      
	      
	      
	      
	      
       
     
   
			
  
    
    
      
	      
		       		       - Property Condition: Excellent
 
		       		       		       - Number of Parking Spaces: 1
 
		       		        		       		       		       - View: City
 
		       		       		       - Listing Office: Talk Realty LLC
 
		       	      
       
     
   
 
 
 
    
    
      
	      
		      		      - Maintenance Fees: $452
 
		      		      		      		      		      - Land Tenure: FS - Fee Simple
 
		      	      
       
     
   
  
  
  
    
  
  
 
			
			
			
			
		 
		
	 
 
	  
	  
	  
    
  Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 3, 2025 - 9:33 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.
 
 
    
    
    
    
  
  
    
      ©  Marcus Realty. All Rights Reserved.