Listing
Overview
Price: $575,000
Area: ST. LOUIS
Status: Active
Crazy bargain price for this expanded 2-bedroom fronting nature's own water feature. Regency Park is a 7.5 acre tropical oasis conveniently located near Waikiki, Kahala, beaches, UH Manoa, and the bus line. Primary bedroom, expanded in 2022, features en suite bath and walk-in closet. The 2019 total renovation opened up the kitchen, adding stainless appliances, sleek quartz counters, and a dramatic vent hood. Quartz counters and maple Shaker cabinets in the updated baths. Full-size laundry pair is tucked into hall bath. Luxury vinyl plank flooring, impervious to sandy toes and pets' paws. By the way--no breed or size limits for your furry companions. Impressive amenities include pool, tennis, pickleball, basketball, gorgeous walking/jogging trails. NOTE: This well-managed association has 100% insurance coverage, ample reserves, and there are NO planned assessments. DON'T MISS THIS OPPORTUNITY! Listing by: Judy Barrett Realty (808) 263-0250
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202513170"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "3138"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Waialae"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Avenue"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "114"
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96816"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(59) "https://unbranded.visithome.ai/7mZcA7DYkTmSJLtWmp6JZ6?mu=ft"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "575000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(9) "ST. LOUIS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(906) "Crazy bargain price for this expanded 2-bedroom fronting nature's own water feature. Regency Park is a 7.5 acre tropical oasis conveniently located near Waikiki, Kahala, beaches, UH Manoa, and the bus line. Primary bedroom, expanded in 2022, features en suite bath and walk-in closet. The 2019 total renovation opened up the kitchen, adding stainless appliances, sleek quartz counters, and a dramatic vent hood. Quartz counters and maple Shaker cabinets in the updated baths. Full-size laundry pair is tucked into hall bath. Luxury vinyl plank flooring, impervious to sandy toes and pets' paws. By the way--no breed or size limits for your furry companions. Impressive amenities include pool, tennis, pickleball, basketball, gorgeous walking/jogging trails. NOTE: This well-managed association has 100% insurance coverage, ample reserves, and there are NO planned assessments. DON'T MISS THIS OPPORTUNITY!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(19) "Judy Barrett Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "323999.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "931"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1981"
}
["BuildingName"]=>
array(1) {
[0]=>
string(12) "Regency Park"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(4) "8-14"
}
["View"]=>
array(1) {
[0]=>
string(12) "Garden,Other"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1289.15"
}
["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) "JBAR"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(21) "judyb@judybarrett.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 263-0250"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Judy Barrett"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18780980"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-07-18T13:51:15.677"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-05-31"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(12) "Stream/Canal"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "13:51:15.677"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27015186"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "27015186"
[1]=>
string(8) "27015187"
[2]=>
string(8) "27015188"
[3]=>
string(8) "27015189"
[4]=>
string(8) "27015190"
[5]=>
string(8) "27015191"
[6]=>
string(8) "27015192"
[7]=>
string(8) "27015193"
[8]=>
string(8) "27015194"
[9]=>
string(8) "27015195"
[10]=>
string(8) "27015196"
[11]=>
string(8) "27015197"
[12]=>
string(8) "27015198"
[13]=>
string(8) "27015199"
[14]=>
string(8) "27015200"
[15]=>
string(8) "27015201"
[16]=>
string(8) "27015202"
[17]=>
string(8) "27015203"
[18]=>
string(8) "27015204"
[19]=>
string(8) "27015205"
[20]=>
string(8) "27015206"
[21]=>
string(8) "27015207"
[22]=>
string(8) "27015208"
[23]=>
string(8) "27015209"
[24]=>
string(8) "27015210"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202513170
)
[StreetNumber] => Array
(
[0] => 3138
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Waialae
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] => 114
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96816
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://unbranded.visithome.ai/7mZcA7DYkTmSJLtWmp6JZ6?mu=ft
)
[ListPrice] => Array
(
[0] => 575000.00
)
[Neighbourhood] => Array
(
[0] => ST. LOUIS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Crazy bargain price for this expanded 2-bedroom fronting nature's own water feature. Regency Park is a 7.5 acre tropical oasis conveniently located near Waikiki, Kahala, beaches, UH Manoa, and the bus line. Primary bedroom, expanded in 2022, features en suite bath and walk-in closet. The 2019 total renovation opened up the kitchen, adding stainless appliances, sleek quartz counters, and a dramatic vent hood. Quartz counters and maple Shaker cabinets in the updated baths. Full-size laundry pair is tucked into hall bath. Luxury vinyl plank flooring, impervious to sandy toes and pets' paws. By the way--no breed or size limits for your furry companions. Impressive amenities include pool, tennis, pickleball, basketball, gorgeous walking/jogging trails. NOTE: This well-managed association has 100% insurance coverage, ample reserves, and there are NO planned assessments. DON'T MISS THIS OPPORTUNITY!
)
[ListOfficeName] => Array
(
[0] => Judy Barrett Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 323999.00
)
[SqftTotal] => Array
(
[0] => 931
)
[YearBuilt] => Array
(
[0] => 1981
)
[BuildingName] => Array
(
[0] => Regency Park
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => 8-14
)
[View] => Array
(
[0] => Garden,Other
)
[MaintenanceExpense] => Array
(
[0] => 1289.15
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => JBAR
)
[ListAgentEmail] => Array
(
[0] => judyb@judybarrett.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 263-0250
)
[ListAgentFullName] => Array
(
[0] => Judy Barrett
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18780980
)
[MatrixModifiedDT] => Array
(
[0] => 2025-07-18T13:51:15.677
)
[ListingContractDate] => Array
(
[0] => 2025-05-31
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] => Stream/Canal
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 13:51:15.677
)
[_thumbnail_id] => Array
(
[0] => 27015186
)
[listing_image] => Array
(
[0] => 27015186
[1] => 27015187
[2] => 27015188
[3] => 27015189
[4] => 27015190
[5] => 27015191
[6] => 27015192
[7] => 27015193
[8] => 27015194
[9] => 27015195
[10] => 27015196
[11] => 27015197
[12] => 27015198
[13] => 27015199
[14] => 27015200
[15] => 27015201
[16] => 27015202
[17] => 27015203
[18] => 27015204
[19] => 27015205
[20] => 27015206
[21] => 27015207
[22] => 27015208
[23] => 27015209
[24] => 27015210
)
)
- BedsTotal: 2
- Full Baths: 2
- Land Area (sf): 323,999 sf
- Living (sf): 931
- Year Built: 1981
- Building Name: Regency Park
- Property Condition: Excellent
- Number of Parking Spaces: 2
- View: Garden,Other
- Listing Office: Judy Barrett Realty
- Maintenance Fees: $1,289
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on July 18, 2025 - 1:51 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.
© Marcus Realty. All Rights Reserved.
