248 Aiokoa Street Kailua, HI 96734
Listing
Overview
Price: $1,625,000
Area: AIKAHI PARK
Status: Active Under Contract
Come discover a spacious corner lot and upgraded home in the highly sought-after Aikahi Park neighborhood. This 3 bedroom, 2 bath home features large living areas overlooking a beautifully tiled swimming pool. Experience Hawaiian indoor-outdoor living at its best! The living area off the primary suite is enormous and has such possibilities! The kitchen ideally situated perfectly in the center of the home for easy gathering and entertaining. Freshly painted interior, exterior, new flooring, new interior doors, new outlets, new fixtures, a few new appliances. AC units throughout the home to keep you cool. Convenient second bathroom opening up to the back yard area which is shaded by a large mango tree. Expansive carport with storage galore! This is the one you have been waiting for! Close to Kailua Beach, Aikahi Elementary, Starbucks, Safeway, Marine Corps Base, as well as H-3. Come discover your new home. Listing by: Stott Real Estate, Inc. (808) 286-3394
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202415270"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "248"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Aiokoa"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96734"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1625000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1625000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "AIKAHI PARK"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(925) "Come discover a spacious corner lot and upgraded home in the highly sought-after Aikahi Park neighborhood. This 3 bedroom, 2 bath home features large living areas overlooking a beautifully tiled swimming pool. Experience Hawaiian indoor-outdoor living at its best! The living area off the primary suite is enormous and has such possibilities! The kitchen ideally situated perfectly in the center of the home for easy gathering and entertaining. Freshly painted interior, exterior, new flooring, new interior doors, new outlets, new fixtures, a few new appliances. AC units throughout the home to keep you cool. Convenient second bathroom opening up to the back yard area which is shaded by a large mango tree. Expansive carport with storage galore! This is the one you have been waiting for! Close to Kailua Beach, Aikahi Elementary, Starbucks, Safeway, Marine Corps Base, as well as H-3. Come discover your new home."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(23) "Stott Real Estate, Inc."
}
["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(7) "7537.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1836"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1964"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["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) "SOLD"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(27) "traceystottkelley@stott.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 286-3394"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(24) "Tracey Anne Stott Kelley"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-08-11T17:00:01.257"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18105041"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-07-03T15:10:34.453"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(6) "Kailua"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26651541"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26651541"
[1]=>
string(8) "26651542"
[2]=>
string(8) "26651543"
[3]=>
string(8) "26651544"
[4]=>
string(8) "26651545"
[5]=>
string(8) "26651546"
[6]=>
string(8) "26651547"
[7]=>
string(8) "26651548"
[8]=>
string(8) "26651549"
[9]=>
string(8) "26651550"
[10]=>
string(8) "26651551"
[11]=>
string(8) "26651552"
[12]=>
string(8) "26651553"
[13]=>
string(8) "26651554"
[14]=>
string(8) "26651555"
[15]=>
string(8) "26651556"
[16]=>
string(8) "26651557"
[17]=>
string(8) "26651558"
[18]=>
string(8) "26651559"
[19]=>
string(8) "26651560"
[20]=>
string(8) "26651561"
[21]=>
string(8) "26651562"
[22]=>
string(8) "26651563"
[23]=>
string(8) "26651564"
[24]=>
string(8) "26651565"
[25]=>
string(8) "26651566"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202415270
)
[StreetNumber] => Array
(
[0] => 248
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Aiokoa
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kailua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96734
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1625000.00
)
[CurrentPrice] => Array
(
[0] => 1625000.00
)
[Neighbourhood] => Array
(
[0] => AIKAHI PARK
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Come discover a spacious corner lot and upgraded home in the highly sought-after Aikahi Park neighborhood. This 3 bedroom, 2 bath home features large living areas overlooking a beautifully tiled swimming pool. Experience Hawaiian indoor-outdoor living at its best! The living area off the primary suite is enormous and has such possibilities! The kitchen ideally situated perfectly in the center of the home for easy gathering and entertaining. Freshly painted interior, exterior, new flooring, new interior doors, new outlets, new fixtures, a few new appliances. AC units throughout the home to keep you cool. Convenient second bathroom opening up to the back yard area which is shaded by a large mango tree. Expansive carport with storage galore! This is the one you have been waiting for! Close to Kailua Beach, Aikahi Elementary, Starbucks, Safeway, Marine Corps Base, as well as H-3. Come discover your new home.
)
[ListOfficeName] => Array
(
[0] => Stott Real Estate, Inc.
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 7537.00
)
[SqftTotal] => Array
(
[0] => 1836
)
[YearBuilt] => Array
(
[0] => 1964
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Aikahi
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kailua
)
[HighSchool] => Array
(
[0] => Kalaheo
)
[ListOfficeMLSID] => Array
(
[0] => SOLD
)
[ListAgentEmail] => Array
(
[0] => traceystottkelley@stott.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 286-3394
)
[ListAgentFullName] => Array
(
[0] => Tracey Anne Stott Kelley
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-11T17:00:01.257
)
[Matrix_Unique_ID] => Array
(
[0] => 18105041
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-07-03T15:10:34.453
)
[MLSAreaMajor] => Array
(
[0] => Kailua
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26651541
)
[listing_image] => Array
(
[0] => 26651541
[1] => 26651542
[2] => 26651543
[3] => 26651544
[4] => 26651545
[5] => 26651546
[6] => 26651547
[7] => 26651548
[8] => 26651549
[9] => 26651550
[10] => 26651551
[11] => 26651552
[12] => 26651553
[13] => 26651554
[14] => 26651555
[15] => 26651556
[16] => 26651557
[17] => 26651558
[18] => 26651559
[19] => 26651560
[20] => 26651561
[21] => 26651562
[22] => 26651563
[23] => 26651564
[24] => 26651565
[25] => 26651566
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 7,537
- Living (sf): 1,836
- Year Built: 1964
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 2
- View: Mountain
- Listing Office: Stott Real Estate, Inc.
- Land Tenure: FS - Fee Simple
- Elementary School: Aikahi
- Middle School: Kailua
- High School: Kalaheo
