 hawaiihome.cc |
|
| |||||||||||
 his one-of-a-kind North Shore home sits on almost 3 landscaped acres with stunning panoramic views of the Mt Ka'ala mountain range from everywhere on the property. The awe-inspiring mountain views include majestic and verdant greens, blues, and purples and are always changing with the weather and time of day. Ideally situated very close to North Shore beaches, Haleiwa town, and amazingly, only 32 minutes to Honolulu (HNL) Airport at the fastest times of day. With so much land, nearly 3 acres, the possibilities are endless. In addition to the existing 3 bedroom home, this property also has additional Ag structures which include water fixtures, drywall, tile, and electricity. There are also two deeded access points to this almost 3 acre property, from both Kuewa Drive and also Kaamooloa Road. The owners currently have a special area for their two horses to graze. This property is unlike any other on the North Shore with its proximity to NS beaches, Haleiwa town, and Honolulu, and it's well-developed infrastructure and landscaping. Easy to view on short notice. Welcome home to paradise! Seller is currently withdrawing the listing June 8th and plans to re-list at the end of 2023. | |||||||||||
 What will it cost to own? | |||||||||||
| |||||||||||
MLS | Public |  | |||||||||
| Single Family Single Family | Contemporary | Property Type Sub Type | |||||||||
| 66-952 Kuewa Dr | 66-952 Kuewa Dr |  | |||||||||
| na na | Triple K Farms 66952 | ||||||||||
| Waialua HI 96791 | Waialua Hawaii 96791 | ||||||||||
| North Shore Waialua | Haleiwa | ||||||||||
| Haleiwa | Waialua Elem |  | |||||||||
| Waialua | Waianae Int | ||||||||||
| Waialua | Waialua High | ||||||||||
| Nanakuli-Waianae-Complex-Area | Complex | ||||||||||
| Public Schools | Rank | ||||||||||
| Private School | Guide | ||||||||||
| na | Troy K Achiu Troy K Achiu |  Builder | |||||||||
| MLS 202309115 | TMK 1-6-6-29-11-1 | Property ID | |||||||||
| 5 | 4 |  Bedrooms | |||||||||
| 3 | 1 |  Full Baths | |||||||||
| 0 | 0 | Half Baths | |||||||||
| 3 | 1 | Total baths | |||||||||
| 0 | Rooms | ||||||||||
| 20 | na |  Parking | |||||||||
| 2,400 | 1,158 |  Interior sf | |||||||||
| 910 |  Lanai sf | ||||||||||
| Other roofed sf | |||||||||||
| 3,310 | Total sf | ||||||||||
| 500 |  Gar/Cpt sf | ||||||||||
| 124,755 | 267,318 |  Land sf | |||||||||
| $2,700,000 4/17/2023 | Original list | ||||||||||
| Withdrawn | Status | ||||||||||
| $2,700,000 |  List price | ||||||||||
| Fee Simple | Fee Simple | Tenure | |||||||||
| No | Fractional | ||||||||||
| 1930 | 1930 0 | Year built | |||||||||
| 2001 Partial | Remodeled | ||||||||||
| $ 0 $ 0 $ 0 $ 0 Includes: | AOAO fee AOAO other Maint fee AOAO total fees | ||||||||||
| Garden Mountain Sunset |  View | ||||||||||
| Gentle Slope Level Terraced | Topography | ||||||||||
| Clear | Land Features | ||||||||||
| Regular System | Recorded | ||||||||||
| AG-1 Restricted Agricultur | na | Zoning | |||||||||
| Zone - X | Flood | ||||||||||
| Inside | Location | ||||||||||
| City & County | Setbacks | ||||||||||
| Driveway | Easements | ||||||||||
| Above Average | Condition | ||||||||||
| Ceramic Tile Laminate | Flooring | ||||||||||
| Asphalt Shingle | Roof | ||||||||||
| AC Split Ceiling Fan Dryer Lawn Sprinkler Microwave Photovoltaic Range/Oven Refrigerator Solar Heater Washer WTRHTR | Inclusions | ||||||||||
| na | Exclusions | ||||||||||
| None | Pool | ||||||||||
| Key | na | Security | |||||||||
| Bedroom on 1st Floor Entry Landscaped Maids/Guest Qrters Patio/Deck Wall/Fence Workshop | Amenities | ||||||||||
| na | Frontage | ||||||||||
| Detach Single Family Multiple Dwellings Ohana Dwelling Studio Cottage | Contemporary 0 Stories 2 Units | Architecture | |||||||||
| na | Model | ||||||||||
| Paved Rd Unpaved Rd | Road | ||||||||||
| Cable Internet Public Water Telephone Underground Electricity Water | Utilities | ||||||||||
| Above Ground Double Wall Single Wall Wood Frame | Materials | ||||||||||
| One | StoriesType | ||||||||||
| Disclosure Stmt | Disclosures | ||||||||||
| 0 | 7265 | Public Report | |||||||||
| 3 Car+ Boat Carport Driveway | Parking | ||||||||||
| na | AOAO Name | ||||||||||
| na | AOAO Ph | ||||||||||
| na | na | Management Co Name | |||||||||
| na | Management Co Ph | ||||||||||
| na | Buyer Financing | ||||||||||
| na | 1st Mortgagor | ||||||||||
| na | 1st Mortgage | ||||||||||
| na | 2nd Mortgagor | ||||||||||
| na | 2nd Mortgage | ||||||||||
| No/na | Foreclosure/Case# | ||||||||||
| 2022 | 2020 | Property tax year | |||||||||
| $ 604,400 | $ 604,400 | Land assessed | |||||||||
| $ 34,400 | $ 35,500 | Building assessed | |||||||||
| $ 0 | $ 100,000 | Home owner exemption | |||||||||
| $ 638,800 | $ 639,900 | Total assessed RPAD | |||||||||
| $ 157 | $ 222 | Tax per month rates | |||||||||
| 0 | Total rent | ||||||||||
| Building Permits | |||||||||||
| At Closing | Possession | ||||||||||
| None | Special | ||||||||||
| Cash Conventional | Financing | ||||||||||
| None | Furnished | ||||||||||
| No | New development | ||||||||||
| Monthly | Cost to own estimate: | ||||||||||
| $ 157 | Real Property Tax | ||||||||||
| $ 0 | Association Fee | ||||||||||
| $ 0 | Lease Rent | ||||||||||
| $ 157 | Cost to own (ex Mortgage, Ins & Elec) | ||||||||||
| 4/20/2023 | Active | ||||||||||
| na | Price change | ||||||||||
| na | Continue to show | ||||||||||
| na | Pending | ||||||||||
| na | Temp withdrawn | ||||||||||
| na | Back on market | ||||||||||
| 6/8/2023 | Withdrawn | ||||||||||
| 6/8/2023 | Off market | ||||||||||
| 6/8/2023 | Status change | ||||||||||
| 4/20/2023 | Advertise | ||||||||||
| na | Auction | ||||||||||
| HomeSmart Island Homes | Listing Brokerage Firm | ||||||||||
| 4/19/2023 | Photos uploaded | ||||||||||
| na | Supplement Mod | ||||||||||
Hawaii Home + Commercial LLC
1888 Kalakaua Ave C312, Waikiki, Honolulu, HI 96815
DCCA PV License # RB-20174
|
|
|
Principal Broker
Robin Charles Glass (R), MBA, eng.
DCCA PV License # RB-20173
Ph: (808) 358-1774
Fax: (866) 925-1467
Email: glassr@hawaiihome.cc
Robin Charles Glass (R), MBA, eng.
DCCA PV License # RB-20173
Ph: (808) 358-1774
Fax: (866) 925-1467
Email: glassr@hawaiihome.cc
MLS and Public Records Databases synchronized every 15 minutes. Includes information from the Multiple Listing Service of HiCentral MLS, Ltd. IDX information is provided exclusively for consumers` personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the information is deemed reliable but not guaranteed. © 2017 by HiCentral MLS, Ltd.