20% Rebate for Buyers
$3,500 Flat Fee for Sellers
2% Full Service for Sellers
This property is in escrow, but the seller is still showing it and looking for backup offers.
Property Last Viewed: 03/22/2023 07:37 AM, Total Views Today: 1, Total Views: 937, Viewed History
Save This Property to Receive Automatic Email Updates When the Status Changes
Update the default down payment and interest rate.
View all new listings in the Hawaii Loa Ridge neighborhood since this property was listed.
Fell out of escrow or Temporarily Withdrawn 1 time. View Details
Price Decreased 1 time. View Details
Price trends for Hawaii Loa Ridge.
There were 49 homes sold in the last 2 years in the Hawaii Loa Ridge neighborhood.
Details * Showing Request * Top * 1 * Next
Click on any photo to view next photo.
Details * Showing Request * Top * 2 * Previous * Next
Details * Showing Request * Top * 3 * Previous * Next
Details * Showing Request * Top * 4 * Previous * Next
Details * Showing Request * Top * 5 * Previous * Next
Details * Showing Request * Top * 6 * Previous * Next
Details * Showing Request * Top * 7 * Previous * Next
Details * Showing Request * Top * 8 * Previous * Next
Details * Showing Request * Top * 9 * Previous * Next
Details * Showing Request * Top * 10 * Previous * Next
Details * Showing Request * Top * 11 * Previous * Next
Details * Showing Request * Top * 12 * Previous * Next
Details * Showing Request * Top * 13 * Previous * Next
Details * Showing Request * Top * 14 * Previous * Next
Details * Showing Request * Top * 15 * Previous * Next
Details * Showing Request * Top * 16 * Previous * Next
Details * Showing Request * Top * 17 * Previous * Next
Details * Showing Request * Top * 18 * Previous * Next
Details * Showing Request * Top * 19 * Previous * Next
Details * Showing Request * Top * 20 * Previous * Next
Details * Showing Request * Top * 21 * Previous * Next
Details * Showing Request * Top * 22 * Previous * Next
Details * Showing Request * Top * 23 * Previous * Next
Details * Showing Request * Top * 24 * Previous * Next
Details * Showing Request * Top * 25 * Previous
Top of Page * Showing Request * Questions?
MLS#: | 202220837 * Questions? |
Status: | Active Under Contract See History |
Price: | $4,285,000 |
Rebate: | $ 21,425 from OahuRE.com. |
Monthly: | $ 25,842.87 Update the default down payment and interest rate |
Monthly payment estimate for $ 4,285,000 price, 10% down, 6.60% interest rate, 30 year loan, $ 907 taxes, and $ 306 fees. Insurance not included. | |
Beds: | 5 Baths: 4 Half: 1 Parking Spaces: 2 |
Living Sq Ft: | 3,989 |
Land Sq Ft: | 19,238 |
Land Tenure: | FS - Fee Simple |
Address: | 410 Lelekepue Place Honolulu HI 96821 |
Region: | Diamond Head - Activity |
Neighborhood: | Hawaii Loa Ridge - Activity * Hawaii Loa Ridge Stats |
Street: | Lelekepue - Activity * Lelekepue Place Stats |
Showing: | Showing Request |
Original: | $4,485,000 |
Change: | $-200,000 -4.46% |
Parcel#: | 1-3-7-016-029-0000 |
Link: | Tax Info/Plat Map/Parcel Map/Sketch |
Days: | 109 days in Active or In Escrow Showing |
Date: | Listed: 10-17-2022 |
Date: | Status Change: 02-23-2023 |
Year Built: | 2009 Remodeled: |
View: | Coastline, Mountain, Ocean, Sunset |
Frontage: | Preservation |
Monthly Tax: | $907 Year: 2022 |
Land: | FS - Fee Simple |
Condition: | Excellent |
Description: | |
Welcome to prestigious HAWAII LOA RIDGE, a gated premier luxury community in Honolulu. This 5 bedroom, 4.5 bath residence sits on a large, private 19,238 sq. ft. rim lot at the end of a quiet cul-de-sac with BREATHTAKING OCEAN, MOUNTAIN AND KOKO HEAD VIEWS. Fun, whimsical interior spaces are accented with a playful and vibrant color scheme - A Must See! This unique home features 2 bedrooms, 2 full baths plus an office on the main level and 3 bedrooms, 2 full baths on second level. Enjoy soaring living room ceilings, gourmet kitchen with two sinks, SubZero refrigerator, Wolf gas stove/oven, and walk-in pantry. Impressive circular driveway surrounds a lovely pool and deck perfect for entertaining and gazing at dazzling sunsets. The master suite with walls of windows and endless ocean views connect to a secluded balcony. The spa-like bath offers dual sinks, jacuzzi soaking tub, walk-in shower and closet. Amenities include 24 hr. security, tennis courts, parks and clubhouse. Don't miss this dramatic and bold one-of-a-kind property! |
|
Inclusions:
AC Central, AC Split, Auto Garage Door Opener, Blinds, Cable TV, Dishwasher, Disposal, Dryer, Lawn Sprinkler, Range/Oven, Refrigerator, Smoke Detector, Solar Heater, Washer
Amenities: Bedroom on 1st Floor, Entry, Full Bath on 1st Floor, Patio/Deck, Wall/Fence Utilities: Connected, Gas, Internet, Public Water, Sewer Fee, Underground Electricity, Water Construction: Double Wall, Masonry/Stucco, Slab Lot Features: Rim Lot Floor: Marble/Granite, W/W Carpet Disclosures: Property Disclosure Stmt, See Remarks Land Recorded: Regular System Furnished: Partial Possession: At Closing Terms: Cash, Conventional Sale Conditions: None |
|
Sold Price: | |
Concession: | |
Closed: | |
Sold Ratio: | |
Days Sold: | |
Land: | $2,185,800 |
Building: | $1,064,000 |
Assessed Total: | $3,249,800 |
Assessed Ratio: | 131.85% |
Pool: | In Ground, Tile |
Location: | Cul-De-Sac |
Parking: | 3 Car+, Driveway, Garage, Street |
District Locator: | DOE Locator to Confirm District |
Area Total: | 19,238 |
Acres: | 0.4416 |
Topography: | Gentle Slope, Level |
Building Style: | Detach Single Family |
Building: | |
New Const: | No |
Maint. Fee: | $0 |
Assoc. Fee: | $306 |
Other Fee: | $0 |
Includes: | |
Total Fees: | $306 |
Exemption: | 140000 |
Other: | 1,030 |
Lanai Sq Ft: | 1,060 |
Garage Sq Ft: | 492 |
Avg Sq Ft Living: | $1,074.20 |
Avg Sq Ft Land: | $222.74 |
Security: | Gated Community |
Rental Income: | $0 |
Stories: | Three+ CPR: No |
Zoning: | 04 - R-7.5 Residential District |
Flood Zone: | Zone D * Check if this property is in a Flood Zone |
Tsunami Zone: | Check if this property is in a Tsunami Zone * Tsunami Info * Oahu Tsunami Map |
Roofing: | Tile |
Set-Backs: | Of Record Roads: Paved Rd, Private Rd |
Easements: | Drainage, Sewer |
Links: | |
Google Maps * Supermarkets * Schools * Private Schools * Hospitals * Restaurants * Gyms * Shopping * Attractions * Beaches * Churches * Tax Info including a Plat Map PDF and GIS Parcel Map and Building Sketch | |
Commuting: | |
Waikiki * Downtown * Ala Moana * Airport * Kapolei * Hawaii Kai * Kailua Town * Windward Mall * Waikele * North Shore | |
Barbers Point * Camp Smith * Fort Shafter * Hickam * Lualualei * K-Bay Marine * Pearl Harbor * Schofield * Tripler * Wheeler * VA Mortgage Info | |
Closing Cost Calculators: | |
Buyer's Closing Cost Calculator to estimate the buyer's closing cost. | |
Seller's Closing Cost Calculator to estimate the seller's closing cost. |
Listing courtesy of Hawaii Life (800) 370-3848
Top of Page * Showing Request * Questions?
Property History from MLS |
|||||||||
Date | MLS# | Change | Old Value | New Value | List Price | Sold Price | Assessed Total | Land | Building |
02-23-2023 | 202220837 | Active Under Contract | Active | In Escrow Showing | $4,285,000 | $0 | $3,249,800 | $2,185,800 | $1,064,000 |
02-02-2023 | 202220837 | Price Decrease | $4,485,000 | $4,285,000 | $4,285,000 | $0 | $3,249,800 | $2,185,800 | $1,064,000 |
11-09-2022 | 202220837 | Back On Market | In Escrow Showing | Active | $4,285,000 | $0 | $3,249,800 | $2,185,800 | $1,064,000 |
10-21-2022 | 202220837 | In Escrow Showing | Active | In Escrow Showing | $4,285,000 | $0 | $3,249,800 | $2,185,800 | $1,064,000 |
10-17-2022 | 202220837 | New Listing | Active | Active | $4,285,000 | $0 | $3,249,800 | $2,185,800 | $1,064,000 |
Top of Page * Showing Request * Questions?
Going more years back returns closer matches.
Similar Properties Sorted by Smallest Price Difference First
Listings in Hawaii Loa Ridge Neighborhood
View listings near this one sorted by the closest listing on the top: 1 Mile, 2 Miles, 3 Miles, 4 Miles, 5 Miles
Top of Page * Showing Request * Questions?
View a map of Sex Offenders for this Zip Code
Top of Page * Showing Request * Questions?
Add to Daily Watch List by Parcel Number
Top of Page * Showing Request * Questions?
View this property's location * Top of Page
View Nearby Schools on Google Maps - Preschools, Elementary Schools, Middle Schools, or High Schools
View Nearby Parks, Farmer's Markets, and Best Restaurants on Google Maps
Directions from this property to nearest Grocery Store, Hospital, Gas Station, Beach Park, and Park
View Hawaii Loa Ridge Neighborhood Boundary
All Neighborhood Boundaries in the Diamond Head Region
Top of Page * Showing Request * Questions?
Elementary Schools, Middle Schools, High Schools, Charter Schools, Private Schools, Preschools
Top of Page * Showing Request * Questions?
View Beach Access Points All Over Oahu including Street View, Directions, and Facilities Info
Top of Page * Showing Request * Questions?
|
|
Neighborhoods Near Hawaii Loa Ridge Shown on Google Earth | |
![]() |
Top of Page * Showing Request * Questions?
Top of Page * Showing Request * Questions?
View OahuRE Mortgage and Interest Savings Calculator
Save $75,532.10 of interest charges by adding an extra payment of $100 per month. View details from the link above.
Rate: |
5.85% | 6.10% | 6.35% | 6.60% | 6.85% | 7.10% | 7.35% | 7.60% | 8.10% |
0% Down |
$25,279 | $25,967 | $26,663 | $27,367 | $28,078 | $28,797 | $29,522 | $30,255 | $31,741 |
3.5% Down |
$24,394 | $25,058 | $25,730 | $26,409 | $27,095 | $27,789 | $28,489 | $29,196 | $30,630 |
10% Down |
$22,751 | $23,370 | $23,997 | $24,630 | $25,270 | $25,917 | $26,570 | $27,230 | $28,567 |
20% Down |
$20,223 | $20,774 | $21,330 | $21,893 | $22,462 | $23,037 | $23,618 | $24,204 | $25,393 |
30% Down |
$17,695 | $18,177 | $18,664 | $19,157 | $19,655 | $20,158 | $20,666 | $21,179 | $22,219 |
40% Down |
$15,167 | $15,580 | $15,998 | $16,420 | $16,847 | $17,278 | $17,713 | $18,153 | $19,045 |
50% Down |
$12,639 | $12,983 | $13,331 | $13,683 | $14,039 | $14,398 | $14,761 | $15,128 | $15,871 |
Top of Page * Showing Request * Questions?
Last 7 days of crime (you can then change it to go back further)
Top of Page * Showing Request * Questions?
Most Popular, Restaurants, Shopping, Arts & Entertainment, Active Life Activities
Top of Page * Showing Request * Questions?
Active means currently for sale. Active Under Contract means in escrow but still showing and looking for offers. Pending means in escrow and not looking for offers. Hold means the property is temporarily off the market. Cancelled means it is off the market. |
Buyer's rebate is 20% of our commission when we represent the buyer. Based on the information from the Multiple Listing Service of HiCentral MLS, Ltd. Active listings last updated on 03.22.23. Information is deemed reliable but not guaranteed. Copyright: 2023 by HiCentral MLS, Ltd. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. 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 and we offer you are 20% rebate on our commission. 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. The offer of compensation to cooperating participants is made only to the Participants and MLS Subscribers of HICMLS or Participants and MLS Subscribers of other Reciprocating Boards as set forth in that certain Multiple Listing Service Reciprocal Agreement, as amended from time to time, which is incorporated herein by reference |