Holiday Hours: Our office will close at Noon on December 24th and 31st and will be closed all day on December 25th and January 1st. Happy Holidays!
4280 Salt Lake Boulevard Unit D23 Honolulu, HI 96818
Listing Overview
Price: $625,000 Area: MILITARY Status: Active
Discover this beautifully upgraded two-story townhome in the well-maintained Foster Heights Villas complex. This charming 3-bedroom unit boasts a range of modern features, including elegant shutters on every window, stylish laminate flooring, cabinets and countertops in both the kitchen and bathrooms. The interior walls have been freshly painted, and the shower and bathtub area has been thoughtfully redesigned for comfort and functionality.
Situated in a central location, this townhome offers unparalleled convenience. Enjoy close proximity to shopping outlets, top-rated schools, Aloha Stadium, and major naval and air force bases. Aiea Town and the vibrant city of Honolulu are just minutes away, making this home ideal for anyone seeking balance of accessibility and tranquility.
With its spacious layout and low-maintenance lifestyle, this townhome presents an excellent alternative to the demands of single-family home yard care and home upkeep. Don't miss the opportunity to call this move-in ready gem your own! Listing by: Locations LLC (808) 625-3419
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202428737"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "4280"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(9) "Salt Lake"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(9) "Boulevard"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "D23"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "625000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "MILITARY"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1030) "Discover this beautifully upgraded two-story townhome in the well-maintained Foster Heights Villas complex. This charming 3-bedroom unit boasts a range of modern features, including elegant shutters on every window, stylish laminate flooring, cabinets and countertops in both the kitchen and bathrooms. The interior walls have been freshly painted, and the shower and bathtub area has been thoughtfully redesigned for comfort and functionality.
Situated in a central location, this townhome offers unparalleled convenience. Enjoy close proximity to shopping outlets, top-rated schools, Aloha Stadium, and major naval and air force bases. Aiea Town and the vibrant city of Honolulu are just minutes away, making this home ideal for anyone seeking balance of accessibility and tranquility.
With its spacious layout and low-maintenance lifestyle, this townhome presents an excellent alternative to the demands of single-family home yard care and home upkeep. Don't miss the opportunity to call this move-in ready gem your own!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(13) "Locations LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "162087.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1420"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1973"
}
["BuildingName"]=>
array(1) {
[0]=>
string(17) "Foster Hgts Villa"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1297.60"
}
["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(6) "LOCA03"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(33) "dan.koyamatsu@locationshawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 625-3419"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Dan Koyamatsu"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18451163"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-27T07:51:56.180"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-12-26"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "PearlCity"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "07:51:56.180"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26817000"
}
["listing_image"]=>
array(21) {
[0]=>
string(8) "26817000"
[1]=>
string(8) "26817001"
[2]=>
string(8) "26817002"
[3]=>
string(8) "26817003"
[4]=>
string(8) "26817004"
[5]=>
string(8) "26817005"
[6]=>
string(8) "26817006"
[7]=>
string(8) "26817007"
[8]=>
string(8) "26817008"
[9]=>
string(8) "26817009"
[10]=>
string(8) "26817010"
[11]=>
string(8) "26817011"
[12]=>
string(8) "26817012"
[13]=>
string(8) "26817013"
[14]=>
string(8) "26817014"
[15]=>
string(8) "26817015"
[16]=>
string(8) "26817016"
[17]=>
string(8) "26817017"
[18]=>
string(8) "26817018"
[19]=>
string(8) "26817019"
[20]=>
string(8) "26817020"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202428737
)
[StreetNumber] => Array
(
[0] => 4280
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Salt Lake
)
[StreetSuffix] => Array
(
[0] => Boulevard
)
[UnitNumber] => Array
(
[0] => D23
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96818
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 625000.00
)
[Neighbourhood] => Array
(
[0] => MILITARY
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Discover this beautifully upgraded two-story townhome in the well-maintained Foster Heights Villas complex. This charming 3-bedroom unit boasts a range of modern features, including elegant shutters on every window, stylish laminate flooring, cabinets and countertops in both the kitchen and bathrooms. The interior walls have been freshly painted, and the shower and bathtub area has been thoughtfully redesigned for comfort and functionality.
Situated in a central location, this townhome offers unparalleled convenience. Enjoy close proximity to shopping outlets, top-rated schools, Aloha Stadium, and major naval and air force bases. Aiea Town and the vibrant city of Honolulu are just minutes away, making this home ideal for anyone seeking balance of accessibility and tranquility.
With its spacious layout and low-maintenance lifestyle, this townhome presents an excellent alternative to the demands of single-family home yard care and home upkeep. Don't miss the opportunity to call this move-in ready gem your own!
)
[ListOfficeName] => Array
(
[0] => Locations LLC
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 162087.00
)
[SqftTotal] => Array
(
[0] => 1420
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Foster Hgts Villa
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] => 1297.60
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => LOCA03
)
[ListAgentEmail] => Array
(
[0] => dan.koyamatsu@locationshawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 625-3419
)
[ListAgentFullName] => Array
(
[0] => Dan Koyamatsu
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18451163
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-27T07:51:56.180
)
[ListingContractDate] => Array
(
[0] => 2024-12-26
)
[MLSAreaMajor] => Array
(
[0] => PearlCity
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 07:51:56.180
)
[_thumbnail_id] => Array
(
[0] => 26817000
)
[listing_image] => Array
(
[0] => 26817000
[1] => 26817001
[2] => 26817002
[3] => 26817003
[4] => 26817004
[5] => 26817005
[6] => 26817006
[7] => 26817007
[8] => 26817008
[9] => 26817009
[10] => 26817010
[11] => 26817011
[12] => 26817012
[13] => 26817013
[14] => 26817014
[15] => 26817015
[16] => 26817016
[17] => 26817017
[18] => 26817018
[19] => 26817019
[20] => 26817020
)
)
