Listing
Overview
Price: $930,000
Area: COUNTRY CLUB
Status: Active Under Contract
Prepare to be WOWED! The previous owners stripped this unit to the studs and spent over $450K on an extensive remodel. Everything was done, top to bottom, with architect designed amenities including the addition of central AC and an electrical upgrade to 200 amps. There's even an EV charger! Redesigned kitchen with top-of-the-line Miele appliances, expresso maker, wine frig, granite counters, custom cabinetry, Ash flooring throughout, extensive built-ins, Pella windows and doors with built-in blinds, and huge covered lanai with bay view. Every aspect of this unit has been carefully considered and upgraded to make the most of this space and location. Add to all this the fact that this is the rare single level floor plan and you have a unit that is a joy to live in! Well located with easy access to H-3 and Marine Corps Base Hawaii with Kailua beach right around the corner. Seller has even paid the assessment in full. This is one you don't want to miss! Listing by: Homequest LLC (808) 225-2350
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202521206"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(8) "44-150-1"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(3) "Kou"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "2201"
}
["City"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96744"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(54) "https://shoots.styronphoto.com/sites/pnknpjr/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "930000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(12) "COUNTRY CLUB"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(973) "Prepare to be WOWED! The previous owners stripped this unit to the studs and spent over $450K on an extensive remodel. Everything was done, top to bottom, with architect designed amenities including the addition of central AC and an electrical upgrade to 200 amps. There's even an EV charger! Redesigned kitchen with top-of-the-line Miele appliances, expresso maker, wine frig, granite counters, custom cabinetry, Ash flooring throughout, extensive built-ins, Pella windows and doors with built-in blinds, and huge covered lanai with bay view. Every aspect of this unit has been carefully considered and upgraded to make the most of this space and location. Add to all this the fact that this is the rare single level floor plan and you have a unit that is a joy to live in! Well located with easy access to H-3 and Marine Corps Base Hawaii with Kailua beach right around the corner. Seller has even paid the assessment in full. This is one you don't want to miss!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(13) "Homequest 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(10) "1427635.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1810"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1973"
}
["BuildingName"]=>
array(1) {
[0]=>
string(18) "Yacht Club Terrace"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(21) "Garden,Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "897.00"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(6) "Aikahi"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Kalaheo"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "HOMQ"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "lynnwells@hawaii.rr.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 225-2350"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Lynn I Wells"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19002670"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-10-28T16:12:15.520"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-09-25"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "16:12:15.520"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27167827"
}
["listing_image"]=>
array(23) {
[0]=>
string(8) "27167827"
[1]=>
string(8) "27167828"
[2]=>
string(8) "27167829"
[3]=>
string(8) "27167830"
[4]=>
string(8) "27167831"
[5]=>
string(8) "27167832"
[6]=>
string(8) "27167833"
[7]=>
string(8) "27167834"
[8]=>
string(8) "27167835"
[9]=>
string(8) "27167836"
[10]=>
string(8) "27167837"
[11]=>
string(8) "27167838"
[12]=>
string(8) "27167839"
[13]=>
string(8) "27167840"
[14]=>
string(8) "27167841"
[15]=>
string(8) "27167842"
[16]=>
string(8) "27167843"
[17]=>
string(8) "27167844"
[18]=>
string(8) "27167845"
[19]=>
string(8) "27167846"
[20]=>
string(8) "27167847"
[21]=>
string(8) "27167848"
[22]=>
string(8) "27167849"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202521206
)
[StreetNumber] => Array
(
[0] => 44-150-1
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Kou
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => 2201
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://shoots.styronphoto.com/sites/pnknpjr/unbranded
)
[ListPrice] => Array
(
[0] => 930000.00
)
[Neighbourhood] => Array
(
[0] => COUNTRY CLUB
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Prepare to be WOWED! The previous owners stripped this unit to the studs and spent over $450K on an extensive remodel. Everything was done, top to bottom, with architect designed amenities including the addition of central AC and an electrical upgrade to 200 amps. There's even an EV charger! Redesigned kitchen with top-of-the-line Miele appliances, expresso maker, wine frig, granite counters, custom cabinetry, Ash flooring throughout, extensive built-ins, Pella windows and doors with built-in blinds, and huge covered lanai with bay view. Every aspect of this unit has been carefully considered and upgraded to make the most of this space and location. Add to all this the fact that this is the rare single level floor plan and you have a unit that is a joy to live in! Well located with easy access to H-3 and Marine Corps Base Hawaii with Kailua beach right around the corner. Seller has even paid the assessment in full. This is one you don't want to miss!
)
[ListOfficeName] => Array
(
[0] => Homequest LLC
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 1427635.00
)
[SqftTotal] => Array
(
[0] => 1810
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Yacht Club Terrace
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Garden,Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] => 897.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Aikahi
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kailua
)
[HighSchool] => Array
(
[0] => Kalaheo
)
[ListOfficeMLSID] => Array
(
[0] => HOMQ
)
[ListAgentEmail] => Array
(
[0] => lynnwells@hawaii.rr.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 225-2350
)
[ListAgentFullName] => Array
(
[0] => Lynn I Wells
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19002670
)
[MatrixModifiedDT] => Array
(
[0] => 2025-10-28T16:12:15.520
)
[ListingContractDate] => Array
(
[0] => 2025-09-25
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 16:12:15.520
)
[_thumbnail_id] => Array
(
[0] => 27167827
)
[listing_image] => Array
(
[0] => 27167827
[1] => 27167828
[2] => 27167829
[3] => 27167830
[4] => 27167831
[5] => 27167832
[6] => 27167833
[7] => 27167834
[8] => 27167835
[9] => 27167836
[10] => 27167837
[11] => 27167838
[12] => 27167839
[13] => 27167840
[14] => 27167841
[15] => 27167842
[16] => 27167843
[17] => 27167844
[18] => 27167845
[19] => 27167846
[20] => 27167847
[21] => 27167848
[22] => 27167849
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 1,427,635 sf
- Living (sf): 1,810
- Year Built: 1973
- Building Name: Yacht Club Terrace
- Property Condition: Excellent
- Number of Parking Spaces: 2
- View: Garden,Mountain,Ocean
- Listing Office: Homequest LLC
- Maintenance Fees: $897
- Land Tenure: FS - Fee Simple
- Elementary School: Aikahi
- Middle School: Kailua
- High School: Kalaheo
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on October 28, 2025 - 4:12 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.