Listing
Overview
Price: $490,000
Area: SALT LAKE
Status: Active
New Improved price!!, Great Location, spacious and bright unit in the pet-friendly Lehua Manor. This unit boasts an abundance of natural light and refreshing breezes, thanks to its numerous windows, which perfectly showcase the breathtaking views of the ocean, mountains, and city. Featuring 2 bedrooms and a spacious den/office that can easily function as a third bedroom, this unit offers versatility and flexibility to suit your needs. highlighted by luxurious marble and travertine flooring throughout the living area and bedrooms, with little TLC, this unique condo with semi private elevator (servicing only two units per floor) can be your next home or investment. Washer, dryer and extra large storage room are in the unit. The monthly maintenance fee covers gas, electricity, water, and sewer, offering a truly hassle-free lifestyle. Near the Airport, multiple parks, a library, shopping centers, schools, and bus lines, this location provides the utmost convenience without sacrificing tranquility. This is a must see unit, Priced to move. *Unit floor plan does not reflect the actual tax record. Listing by: Avalon Realty LLC (808) 587-7770
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202316089"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "2929"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(9) "Ala Ilima"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(7) "Streets"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "1204"
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96818"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(42) "https://hommati.tours/tour/1890589?mls=yes"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "490000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "490000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(9) "SALT LAKE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1113) "New Improved price!!, Great Location, spacious and bright unit in the pet-friendly Lehua Manor. This unit boasts an abundance of natural light and refreshing breezes, thanks to its numerous windows, which perfectly showcase the breathtaking views of the ocean, mountains, and city. Featuring 2 bedrooms and a spacious den/office that can easily function as a third bedroom, this unit offers versatility and flexibility to suit your needs. highlighted by luxurious marble and travertine flooring throughout the living area and bedrooms, with little TLC, this unique condo with semi private elevator (servicing only two units per floor) can be your next home or investment. Washer, dryer and extra large storage room are in the unit. The monthly maintenance fee covers gas, electricity, water, and sewer, offering a truly hassle-free lifestyle. Near the Airport, multiple parks, a library, shopping centers, schools, and bus lines, this location provides the utmost convenience without sacrificing tranquility. This is a must see unit, Priced to move. *Unit floor plan does not reflect the actual tax record."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(17) "Avalon Realty LLC"
}
["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(8) "44344.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1060"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1973"
}
["BuildingName"]=>
array(1) {
[0]=>
string(11) "Lehua Manor"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(5) "15-20"
}
["View"]=>
array(1) {
[0]=>
string(28) "City,Mountain,Sunrise,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "810.00"
}
["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) "AVAL"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(15) "jf@avalonhi.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 587-7770"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(19) "June HJ Freundschuh"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-09-29T13:47:35.020"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17431011"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-07-06T22:14:25.303"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25864721"
}
["listing_image"]=>
array(23) {
[0]=>
string(8) "25864721"
[1]=>
string(8) "25864722"
[2]=>
string(8) "25864723"
[3]=>
string(8) "25864724"
[4]=>
string(8) "25864725"
[5]=>
string(8) "25864726"
[6]=>
string(8) "25864727"
[7]=>
string(8) "25864728"
[8]=>
string(8) "25864729"
[9]=>
string(8) "25864730"
[10]=>
string(8) "25864731"
[11]=>
string(8) "25864732"
[12]=>
string(8) "25864733"
[13]=>
string(8) "25864734"
[14]=>
string(8) "25864735"
[15]=>
string(8) "25864736"
[16]=>
string(8) "25864737"
[17]=>
string(8) "25864738"
[18]=>
string(8) "25864739"
[19]=>
string(8) "25864740"
[20]=>
string(8) "25864741"
[21]=>
string(8) "25864742"
[22]=>
string(8) "25973112"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202316089
)
[StreetNumber] => Array
(
[0] => 2929
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Ala Ilima
)
[StreetSuffix] => Array
(
[0] => Streets
)
[UnitNumber] => Array
(
[0] => 1204
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96818
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://hommati.tours/tour/1890589?mls=yes
)
[ListPrice] => Array
(
[0] => 490000.00
)
[CurrentPrice] => Array
(
[0] => 490000.00
)
[Neighbourhood] => Array
(
[0] => SALT LAKE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => New Improved price!!, Great Location, spacious and bright unit in the pet-friendly Lehua Manor. This unit boasts an abundance of natural light and refreshing breezes, thanks to its numerous windows, which perfectly showcase the breathtaking views of the ocean, mountains, and city. Featuring 2 bedrooms and a spacious den/office that can easily function as a third bedroom, this unit offers versatility and flexibility to suit your needs. highlighted by luxurious marble and travertine flooring throughout the living area and bedrooms, with little TLC, this unique condo with semi private elevator (servicing only two units per floor) can be your next home or investment. Washer, dryer and extra large storage room are in the unit. The monthly maintenance fee covers gas, electricity, water, and sewer, offering a truly hassle-free lifestyle. Near the Airport, multiple parks, a library, shopping centers, schools, and bus lines, this location provides the utmost convenience without sacrificing tranquility. This is a must see unit, Priced to move. *Unit floor plan does not reflect the actual tax record.
)
[ListOfficeName] => Array
(
[0] => Avalon Realty LLC
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 44344.00
)
[SqftTotal] => Array
(
[0] => 1060
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Lehua Manor
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 15-20
)
[View] => Array
(
[0] => City,Mountain,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 810.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => AVAL
)
[ListAgentEmail] => Array
(
[0] => jf@avalonhi.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 587-7770
)
[ListAgentFullName] => Array
(
[0] => June HJ Freundschuh
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-09-29T13:47:35.020
)
[Matrix_Unique_ID] => Array
(
[0] => 17431011
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-07-06T22:14:25.303
)
[_thumbnail_id] => Array
(
[0] => 25864721
)
[listing_image] => Array
(
[0] => 25864721
[1] => 25864722
[2] => 25864723
[3] => 25864724
[4] => 25864725
[5] => 25864726
[6] => 25864727
[7] => 25864728
[8] => 25864729
[9] => 25864730
[10] => 25864731
[11] => 25864732
[12] => 25864733
[13] => 25864734
[14] => 25864735
[15] => 25864736
[16] => 25864737
[17] => 25864738
[18] => 25864739
[19] => 25864740
[20] => 25864741
[21] => 25864742
[22] => 25973112
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 44,344
- Living (sf): 1,060
- Year Built: 1973
- Building Name: Lehua Manor
- Property Condition: Average
- Number of Parking Spaces: 1
- View: City,Mountain,Sunrise,Sunset
- Listing Office: Avalon Realty LLC
- Maintenance Fees: $810
- Land Tenure: FS - Fee Simple
