Previous Next

2450 Prince Edward Street Unit 905A Honolulu, HI 96815

Listing
Overview

Price: $138,000
Area: WAIKIKI
Status: Active

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202414518"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "2450"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(13) "Prince Edward"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "905A"
  }
  ["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(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "138000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "138000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIKIKI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1047) "Discover this charming, fully furnished studio condo in the heart of Waikiki, perfect for short-term rentals. Just two blocks from the iconic Waikiki Beach and Duke Kahanamoku Statue, this higher-floor unit offers a serene mountain view from the lanai and a peekaboo ocean view from the front door. The condo is tastefully decorated with a relaxed island vibe, providing a cozy and inviting atmosphere.

**Features:**
- **Turnkey Vacation Rental:** Ready for immediate occupancy.
- **Views:** Mountain view from the lanai and peekaboo ocean view from the front door.
Location:** It is centrally located, close to International Marketplace, Duke's Waikiki, and numerous shops and restaurants.
- **Amenities:** Newly renovated lobby with a surfboard rack, e-bike rental shop, and luggage storage.
- **Parking:** Paid parking garage in the basement (no assigned parking).

**Income Potential:**
This legal short-term rental is an excellent income-producing property, ideal for investors seeking a convenient and comfortable stay in Waikiki."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(14) "TLC Realty LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "9670.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "292"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1975"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(15) "Kuhio Village 2"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(4) "8-14"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "City"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "581.00"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(14) "LH - Leasehold"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "TLCT"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(23) "cherise@tlcrealtyhi.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 852-2555"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(26) "Cherise FMA Antoque-Tilton"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-12-31T19:40:46.553"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18079230"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-06-18T15:08:43.687"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26600853"
  }
  ["listing_image"]=>
  array(24) {
    [0]=>
    string(8) "26600853"
    [1]=>
    string(8) "26600854"
    [2]=>
    string(8) "26600855"
    [3]=>
    string(8) "26600856"
    [4]=>
    string(8) "26600857"
    [5]=>
    string(8) "26600858"
    [6]=>
    string(8) "26600859"
    [7]=>
    string(8) "26600860"
    [8]=>
    string(8) "26600861"
    [9]=>
    string(8) "26600862"
    [10]=>
    string(8) "26600863"
    [11]=>
    string(8) "26600864"
    [12]=>
    string(8) "26600865"
    [13]=>
    string(8) "26600866"
    [14]=>
    string(8) "26600867"
    [15]=>
    string(8) "26600868"
    [16]=>
    string(8) "26600869"
    [17]=>
    string(8) "26600870"
    [18]=>
    string(8) "26600871"
    [19]=>
    string(8) "26600872"
    [20]=>
    string(8) "26600873"
    [21]=>
    string(8) "26600874"
    [22]=>
    string(8) "26600875"
    [23]=>
    string(8) "26600876"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-06-23"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "19:40:46.553"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202414518
        )

    [StreetNumber] => Array
        (
            [0] => 2450
        )

    [PropertyType] => Array
        (
            [0] => Condo/Townhouse
        )

    [StreetName] => Array
        (
            [0] => Prince Edward
        )

    [StreetSuffix] => Array
        (
            [0] => Street
        )

    [UnitNumber] => Array
        (
            [0] => 905A
        )

    [City] => Array
        (
            [0] => Honolulu
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96815
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 138000.00
        )

    [CurrentPrice] => Array
        (
            [0] => 138000.00
        )

    [Neighbourhood] => Array
        (
            [0] => WAIKIKI
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => Discover this charming, fully furnished studio condo in the heart of Waikiki, perfect for short-term rentals. Just two blocks from the iconic Waikiki Beach and Duke Kahanamoku Statue, this higher-floor unit offers a serene mountain view from the lanai and a peekaboo ocean view from the front door. The condo is tastefully decorated with a relaxed island vibe, providing a cozy and inviting atmosphere.

**Features:**
- **Turnkey Vacation Rental:** Ready for immediate occupancy.
- **Views:** Mountain view from the lanai and peekaboo ocean view from the front door.
Location:** It is centrally located, close to International Marketplace, Duke's Waikiki, and numerous shops and restaurants.
- **Amenities:** Newly renovated lobby with a surfboard rack, e-bike rental shop, and luggage storage.
- **Parking:** Paid parking garage in the basement (no assigned parking).

**Income Potential:**
This legal short-term rental is an excellent income-producing property, ideal for investors seeking a convenient and comfortable stay in Waikiki.
        )

    [ListOfficeName] => Array
        (
            [0] => TLC Realty LLC
        )

    [BedsTotal] => Array
        (
            [0] => 0
        )

    [BathsFull] => Array
        (
            [0] => 1
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 9670.00
        )

    [SqftTotal] => Array
        (
            [0] => 292
        )

    [YearBuilt] => Array
        (
            [0] => 1975
        )

    [BuildingName] => Array
        (
            [0] => Kuhio Village 2
        )

    [PropertyCondition] => Array
        (
            [0] => Above Average
        )

    [ParkingTotal] => Array
        (
            [0] => 0
        )

    [StoriesType] => Array
        (
            [0] => 8-14
        )

    [View] => Array
        (
            [0] => City
        )

    [MaintenanceExpense] => Array
        (
            [0] => 581.00
        )

    [LandTenure] => Array
        (
            [0] => LH - Leasehold
        )

    [ElementarySchool] => Array
        (
            [0] => 
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => 
        )

    [HighSchool] => Array
        (
            [0] => 
        )

    [ListOfficeMLSID] => Array
        (
            [0] => TLCT
        )

    [ListAgentEmail] => Array
        (
            [0] => cherise@tlcrealtyhi.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 852-2555
        )

    [ListAgentFullName] => Array
        (
            [0] => Cherise FMA Antoque-Tilton
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-12-31T19:40:46.553
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18079230
        )

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-06-18T15:08:43.687
        )

    [MLSAreaMajor] => Array
        (
            [0] => Metro
        )

    [PropertyFrontage] => Array
        (
            [0] => Other
        )

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

    [_thumbnail_id] => Array
        (
            [0] => 26600853
        )

    [listing_image] => Array
        (
            [0] => 26600853
            [1] => 26600854
            [2] => 26600855
            [3] => 26600856
            [4] => 26600857
            [5] => 26600858
            [6] => 26600859
            [7] => 26600860
            [8] => 26600861
            [9] => 26600862
            [10] => 26600863
            [11] => 26600864
            [12] => 26600865
            [13] => 26600866
            [14] => 26600867
            [15] => 26600868
            [16] => 26600869
            [17] => 26600870
            [18] => 26600871
            [19] => 26600872
            [20] => 26600873
            [21] => 26600874
            [22] => 26600875
            [23] => 26600876
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-06-23
        )

    [ExemptListingEntryTimestamp] => Array
        (
            [0] => 
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 19:40:46.553
        )

)

PROPERTY INFO

• Full Baths: 1
• Land Area (sf): 9,670 sf
• Living (sf): 292
• Year Built: 1975
• Building Name: Kuhio Village 2

KEY FEATURES

• Property Condition: Above Average
• View: City
• Listing Office: TLC Realty LLC

FINANCIAL INFO

• Maintenance Fees: $581
• Land Tenure: LH - Leasehold

SCHOOLS

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on December 31, 2024 - 7:40 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.