47-461 Aiai Place Kaneohe, HI 96744
Listing
Overview
Price: $1,050,000
Area: AHUIMANU AREA
Status: Active
Hidden Gem with Untapped Potential!! Make this family home your own. Nestled in a peaceful neighborhood in Ahuimanu, this stunning property offers breathtaking views of the Ko'olau mountains, and easy access to Kaneohe Bay. Located minutes from Kaneohe's top amenities, shopping, dining, and excellent schools, this home combines tranquility with convenience. Quick access to H-3, Pali, and Likelike Highways makes commuting to Honolulu, Pearl Harbor, or the airport a breeze. Whether you're looking for a serene retreat or a family home with local charm, 47-461 Aiai Place is an unparalleled find. Embrace the Hawaii lifestyle and make this captivating Kaneohe property yours today! Being Sold "As Is" number of bedrooms and square footage do not match tax records. No showings till the first open house Sunday from 2-5 November 24th. Please do not disturb occupants. Call listing agent for more information. Listing by: Keller Williams Honolulu (808) 551-2704
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202426678"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "47-461"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(4) "Aiai"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1050000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1050000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "AHUIMANU AREA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(913) "Hidden Gem with Untapped Potential!! Make this family home your own. Nestled in a peaceful neighborhood in Ahuimanu, this stunning property offers breathtaking views of the Ko'olau mountains, and easy access to Kaneohe Bay. Located minutes from Kaneohe's top amenities, shopping, dining, and excellent schools, this home combines tranquility with convenience. Quick access to H-3, Pali, and Likelike Highways makes commuting to Honolulu, Pearl Harbor, or the airport a breeze. Whether you're looking for a serene retreat or a family home with local charm, 47-461 Aiai Place is an unparalleled find. Embrace the Hawaii lifestyle and make this captivating Kaneohe property yours today! Being Sold "As Is" number of bedrooms and square footage do not match tax records. No showings till the first open house Sunday from 2-5 November 24th. Please do not disturb occupants. Call listing agent for more information."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6005.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2256"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1984"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["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(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "KWPP"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(21) "david.cordeiro@kw.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 551-2704"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "David Cordeiro"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-17T21:30:01.363"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18384430"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-11-14T18:41:28.833"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26773307"
}
["listing_image"]=>
array(11) {
[0]=>
string(8) "26773307"
[1]=>
string(8) "26773308"
[2]=>
string(8) "26773309"
[3]=>
string(8) "26773310"
[4]=>
string(8) "26773311"
[5]=>
string(8) "26773312"
[6]=>
string(8) "26773313"
[7]=>
string(8) "26773314"
[8]=>
string(8) "26773315"
[9]=>
string(8) "26773316"
[10]=>
string(8) "26773317"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202426678
)
[StreetNumber] => Array
(
[0] => 47-461
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Aiai
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1050000.00
)
[CurrentPrice] => Array
(
[0] => 1050000.00
)
[Neighbourhood] => Array
(
[0] => AHUIMANU AREA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Hidden Gem with Untapped Potential!! Make this family home your own. Nestled in a peaceful neighborhood in Ahuimanu, this stunning property offers breathtaking views of the Ko'olau mountains, and easy access to Kaneohe Bay. Located minutes from Kaneohe's top amenities, shopping, dining, and excellent schools, this home combines tranquility with convenience. Quick access to H-3, Pali, and Likelike Highways makes commuting to Honolulu, Pearl Harbor, or the airport a breeze. Whether you're looking for a serene retreat or a family home with local charm, 47-461 Aiai Place is an unparalleled find. Embrace the Hawaii lifestyle and make this captivating Kaneohe property yours today! Being Sold "As Is" number of bedrooms and square footage do not match tax records. No showings till the first open house Sunday from 2-5 November 24th. Please do not disturb occupants. Call listing agent for more information.
)
[ListOfficeName] => Array
(
[0] => Keller Williams Honolulu
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 6005.00
)
[SqftTotal] => Array
(
[0] => 2256
)
[YearBuilt] => Array
(
[0] => 1984
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => KWPP
)
[ListAgentEmail] => Array
(
[0] => david.cordeiro@kw.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 551-2704
)
[ListAgentFullName] => Array
(
[0] => David Cordeiro
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-17T21:30:01.363
)
[Matrix_Unique_ID] => Array
(
[0] => 18384430
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-11-14T18:41:28.833
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26773307
)
[listing_image] => Array
(
[0] => 26773307
[1] => 26773308
[2] => 26773309
[3] => 26773310
[4] => 26773311
[5] => 26773312
[6] => 26773313
[7] => 26773314
[8] => 26773315
[9] => 26773316
[10] => 26773317
)
)
- BedsTotal: 5
- Full Baths: 2
- Land Area (sf): 6,005
- Living (sf): 2,256
- Year Built: 1984
- Property Condition: Average
- Number of Parking Spaces: 4
- View: Mountain
- Listing Office: Keller Williams Honolulu
- Land Tenure: FS - Fee Simple
