Search Open Houses Buyer's Rebate Sell for 2% Sell for $3,500 Statistics Help Tools Saved Searches Testimonials Blog Contact

Oahu Real Estate Logo

20% Rebate for Buyers
$3,500 Flat Fee for Sellers
2% Full Service for Sellers


47-751 Hui Ulili Street Kaneohe HI 96744

This property is in escrow, but the seller is still showing it and looking for backup offers.

$1,450,000 | OahuRE Rebate $7,250 | Active Under Contract

Price dropped on 01-26-2024. Original price was $1,500,000

Listed on 12-28-2023

6 Bedrooms, 4 Full Baths, 0 Half Baths, 2 Parking Spaces

3,244 Square Feet Living * 6,982 Square Feet Land * $35 Total Association Fees

Sell for a $3,500 Flat Fee or 2% With Full Service.

Learn How to Eliminate the Buyer’s Agent Commission..

Contact Us for a Showing and a 20% Commission Rebate.

Property Last Viewed: 04/28/2024 08:31 AM, Total Views Today: 1, Total Views: 331, Viewed History

Save This Property to Receive Automatic Email Updates When the Status Changes

Comparables by Square Feet

Short Cuts

Update the default down payment and interest rate.



OahuRE.com Notes About This Property

View all new listings in the Club View Estate neighborhood since this property was listed.

The last sale on September 2, 2020, used a VA loan, so it should be assumable at a lower interest rate.

Listed previously on July 29, 2020 for $1,145,000. View Details

Listed previously on August 24, 2006 for $724,500. View Details

Listed previously on April 21, 2006 for $799,000. View Details

Listed previously on June 19, 2005 for $725,000. View Details

Listed previously on November 13, 1999 for $378,000. View Details

Listed previously on December 6, 1998 for $499,500. View Details

Fell out of escrow or Temporarily Withdrawn 2 times. View Details

Price Decreased 16 times. View Details

Temporarily Withdrawn 1 time. View Details

Withdrawn 1 time. View Details

Expired 1 time. View Details

Price trends for Club View Estate.

There were 11 homes sold in the last 2 years in the Club View Estate neighborhood.


47-751 Hui Ulili Street

Details * Showing Request * Top * 1 * Next

Click on any photo to view next photo.

47-751 Hui Ulili Street

Details * Showing Request * Top * 2 * Previous * Next

Learn More About Our Selling Options

47-751 Hui Ulili Street

Details * Showing Request * Top * 3 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 4 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 5 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 6 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 7 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 8 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 9 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 10 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 11 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 12 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 13 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 14 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 15 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 16 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 17 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 18 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 19 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 20 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 21 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 22 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 23 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 24 * Previous * Next

47-751 Hui Ulili Street

Details * Showing Request * Top * 25 * Previous

Older Photos From A Previous Listing

47-751 Hui Ulili Street

47-751 Hui Ulili Street

View additional older photos

Property Details

Top of Page * Showing Request * Questions?


MLS#: 202328423 * Questions?
Status: Active Under Contract See History
Price: $1,450,000
Rebate: $ 7,250 from OahuRE.com.
Monthly: $ 8,757.49 Update the default down payment and interest rate
  Monthly payment estimate for $ 1,450,000 price, 10% down, 6.60% interest rate, 30 year loan, $ 388 taxes, and $ 35 fees. Insurance not included.
Beds: 6   Baths: 4   Half: 0  Parking Spaces: 2
Living Sq Ft: 3,244
Land Sq Ft: 6,982
Land Tenure: FS - Fee Simple
Address: 47-751 Hui Ulili Street Kaneohe HI 96744
Region: Kaneohe - Activity
Neighborhood: Club View Estate - Activity * Club View Estate Stats
Street: Hui Ulili - Activity * Hui Ulili Street Stats
Showing: Showing Request

Top of Page * Showing Request * Questions?

Original: $1,500,000
Change: $-50,000    -3.33%
Parcel#: 1-4-7-052-055-0000
Link: Tax Info/Plat Map/Parcel Map/Sketch
Days: 33 days in Active or In Escrow Showing
Date: Listed: 12-28-2023
Date: Status Change: 01-30-2024
Year Built: 1970 Remodeled: 2020
View: Mountain
Frontage:
Monthly Tax: $388 Year: 2023
Land: FS - Fee Simple
Condition: Excellent, Above Average

Top of Page * Showing Request * Questions?

Description:

2.25% assumable rate available to approved VA buyers! Welcome to the epitome of versatile living in this stunning 6-bedroom, 4-bathroom, two-story home with picturesque mountain views and refreshing cool breezes. The updated residence is a perfect blend of modern comfort and flexibility, offering separate units that make it an ideal investment opportunity or an exceptional space for extended family living. Upon entering the main residence, you are greeted by a spacious and bright living area, featuring an open floor plan that seamlessly connects the living, dining, and kitchen areas. The modern kitchen is a chef's delight, boasting sleek countertops, ample cabinet space, and state-of-the-art appliances. Large windows throughout the home showcase enchanting mountain views and invite in plenty of natural light, creating an inviting and tranquil atmosphere. The main residence includes four generously sized bedrooms, each offering comfort and privacy, along with access to well-appointed bathrooms.

 
 
Inclusions: Ceiling Fan, Dishwasher, Disposal, Dryer, Range Hood, Range/Oven, Refrigerator, Washer, Water Heater

Amenities: Bedroom on 1st Floor, Full Bath on 1st Floor, Patio/Deck

Utilities: Public Water, Water Construction: Double Wall Lot Features: Clear Floor: Laminate Disclosures: None Land Recorded: Land Court Furnished:

Possession: At Closing Terms: Cash, Conventional, VA Sale Conditions: None

Top of Page * Showing Request * Questions?

Sold Price:
Concession:
Closed:
Sold Ratio:
Days Sold:
Land: $779,700
Building: $651,600  
Assessed Total: $1,431,300  
Assessed Ratio: 101.31%
Pool: None
Location: Corner
Parking: 2 Car, Carport, Driveway

Top of Page * Showing Request * Questions?

District Locator: DOE Locator to Confirm District
Area Total: 6,982
Acres: 0.1603
Topography: Level
Building Style: Detach Single Family
Building:
New Const: No

Top of Page * Showing Request * Questions?

Maint. Fee: $0
Assoc. Fee: $35
Other Fee: $0
Includes:
Total Fees: $35
Exemption: 100000
Other: 0
Lanai Sq Ft: 0
Garage Sq Ft: 400
Avg Sq Ft Living: $446.98
Avg Sq Ft Land: $207.68
Security:
Rental Income: $0
Stories: Two CPR: No
Zoning: 05 - R-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: Asphalt Shingle
Set-Backs: Of Record Roads: Paved Rd
Easements: None

Top of Page * Showing Request * Questions?

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 Keller Williams Honolulu (808) 681-9594

Top of Page * Showing Request * Questions?


Core Logic Logo

Property History from MLS

Date MLS# Change Old Value New Value List Price Sold Price Assessed Total Land Building
01-30-2024 202328423 Active Under Contract Active In Escrow Showing $1,450,000 $0 $1,431,300 $779,700 $651,600
01-26-2024 202328423 Price Decrease $1,500,000 $1,450,000 $1,450,000 $0 $1,431,300 $779,700 $651,600
12-28-2023 202328423 New Listing $1,500,000 Active $1,450,000 $0 $1,431,300 $779,700 $651,600
09-02-2020 202014702 Sold In Escrow Showing Sold $1,145,000 $1,155,000 $918,400 $545,800 $372,600
08-04-2020 202014702 In Escrow Showing Active In Escrow Showing $1,145,000 $1,155,000 $918,400 $545,800 $372,600
07-29-2020 202014702 New Listing Active Active $1,145,000 $1,155,000 $918,400 $545,800 $372,600
10-23-2006 2615869 Sold In Escrow Showing Sold $699,500 $685,000 $850,200 $514,600 $335,600
09-11-2006 2615869 Active Continue to Show Active In Escrow Showing $699,500 $685,000 $850,200 $514,600 $335,600
09-07-2006 2615869 Price Decrease $724,500 $699,500 $699,500 $685,000 $850,200 $514,600 $335,600
08-24-2006 2615869 New Listing $724,500 Active $699,500 $685,000 $850,200 $514,600 $335,600
08-22-2006 2607798 Withdrawn Active Cancelled $725,000 $0 $850,200 $514,600 $335,600
08-13-2006 2607798 Price Decrease $739,000 $725,000 $725,000 $0 $850,200 $514,600 $335,600
08-08-2006 2607798 Price Decrease $749,000 $739,000 $725,000 $0 $850,200 $514,600 $335,600
07-14-2006 2607798 Price Decrease $759,000 $749,000 $725,000 $0 $850,200 $514,600 $335,600
06-23-2006 2607798 Price Decrease $765,000 $759,000 $725,000 $0 $850,200 $514,600 $335,600
05-27-2006 2607798 Price Decrease $780,000 $765,000 $725,000 $0 $850,200 $514,600 $335,600
05-10-2006 2607798 Price Decrease $799,000 $780,000 $725,000 $0 $850,200 $514,600 $335,600
04-22-2006 2607798 New Listing $799,000 Active $725,000 $0 $850,200 $514,600 $335,600
08-01-2005 2509541 Sold $799,000 Sold $725,000 $740,000 $654,600 $362,700 $291,900
07-27-2005 2509541 Pending In Escrow Showing In Escrow Not Showing $725,000 $740,000 $654,600 $362,700 $291,900
06-20-2005 2509541 Back On Market In Escrow Showing Active $725,000 $740,000 $654,600 $362,700 $291,900
06-20-2005 2509541 Temporarily Withdrawn Active Active $725,000 $740,000 $654,600 $362,700 $291,900
06-20-2005 2509541 New Listing Active Active $725,000 $740,000 $654,600 $362,700 $291,900
10-11-2000 9908250 Sold Active Sold $339,000 $329,000 $432,300 $181,400 $250,900
10-11-2000 9908250 Price Decrease $339,000 $329,000 $339,000 $329,000 $432,300 $181,400 $250,900
09-14-2000 9908250 Pending Active In Escrow Not Showing $339,000 $329,000 $432,300 $181,400 $250,900
06-02-2000 9908250 Price Decrease $349,000 $339,000 $339,000 $329,000 $432,300 $181,400 $250,900
04-27-2000 9908250 Price Decrease $358,000 $349,000 $339,000 $329,000 $432,300 $181,400 $250,900
04-18-2000 9908250 Back On Market $358,000 Active $339,000 $329,000 $432,300 $181,400 $250,900
04-14-2000 9908250 Pending Active In Escrow Not Showing $339,000 $329,000 $432,300 $181,400 $250,900
03-09-2000 9908250 Price Decrease $378,000 $358,000 $339,000 $329,000 $432,300 $181,400 $250,900
11-16-1999 9908250 New Listing $378,000 Active $339,000 $329,000 $432,300 $181,400 $250,900
10-30-1999 9823143 Expired Active Expired $379,000 $0 $432,300 $181,400 $250,900
10-04-1999 9823143 Price Decrease $399,900 $379,000 $379,000 $0 $432,300 $181,400 $250,900
04-24-1999 9823143 Price Decrease $399,990 $399,900 $379,000 $0 $432,300 $181,400 $250,900
04-12-1999 9823143 Price Decrease $479,000 $399,990 $379,000 $0 $432,300 $181,400 $250,900
01-25-1999 9823143 Price Decrease $499,500 $436,000 $379,000 $0 $432,300 $181,400 $250,900
01-06-1999 9823143 Price Increase $436,000 $479,000 $379,000 $0 $432,300 $181,400 $250,900
12-06-1998 9823143 New Listing $436,000 Active $379,000 $0 $432,300 $181,400 $250,900

Top of Page * Showing Request * Questions?


Comparables

Instant Comparables

Comparables with Options

Multiple Comparable Options

Going more years back returns closer matches.

Last 6 Months Sold

Last 1 Year Sold

Last 2 Years Sold

Last 3 Years Sold

Similar Properties Sorted by Smallest Price Difference First

Listings in Club View Estate 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?


City and County Public Information Links

City and County Logo

Tax Info including a Plat Map PDF and GIS Parcel Map

Department of Planning & Permitting General Information

Department of Planning & Permitting All Permits

Dept. of Emergency Management Public Safety Info

Tax Records and Property History in this Neighborhood

Tax Records and Property History on this Street

Building Sketch

Top of Page * Showing Request * Questions?


Sex Offender Information

Attorney General Logo

View a map of Sex Offenders for this Zip Code

Top of Page * Showing Request * Questions?


Daily Watch List

Add to Daily Watch List by Parcel Number

Top of Page * Showing Request * Questions?



Google Maps

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 Club View Estate Neighborhood Boundary

View Tax Records

All Neighborhood Boundaries in the Kaneohe Region

Neighborhood Boundaries

View Full Size in Google Maps

Top of Page * Showing Request * Questions?



Elementary Schools, Middle Schools, High Schools, Charter Schools, Private Schools, Preschools

School Map

Top of Page * Showing Request * Questions?



View Directions on Google Maps to nearest Beach Access

View Beach Access Points All Over Oahu including Street View, Directions, and Facilities Info

Beach Access Map

Top of Page * Showing Request * Questions?



Google Earth

Neighborhoods Near Club View Estate Shown on Google Earth
 
Googe Earth View

Top of Page * Showing Request * Questions?



Google Traffic Maps

Example Traffic Map

Top of Page * Showing Request * Questions?



Estimated Monthly Mortgage Payment

View OahuRE Mortgage and Interest Savings Calculator

Save $72,666.79 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
$8,554$8,787$9,022$9,261$9,501$9,744$9,990$10,238$10,741
3.5% Down
$8,255$8,479$8,707$8,936$9,169$9,403$9,640$9,880$10,365
10% Down
$7,699$7,908$8,120$8,334$8,551$8,770$8,991$9,214$9,667
20% Down
$6,843$7,030$7,218$7,408$7,601$7,796$7,992$8,190$8,593
30% Down
$5,988$6,151$6,316$6,482$6,651$6,821$6,993$7,167$7,519
40% Down
$5,132$5,272$5,413$5,556$5,701$5,847$5,994$6,143$6,445
50% Down
$4,277$4,393$4,511$4,630$4,751$4,872$4,995$5,119$5,370

Top of Page * Showing Request * Questions?



Crime Mapping

Last 7 days of crime (you can then change it to go back further)

Top of Page * Showing Request * Questions?



Yelp

Popular Yelp Links Sorted by Review Count Near 47-751 Hui Ulili Street

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 04.28.24. Information is deemed reliable but not guaranteed. Copyright: 2024 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

Our Privacy Policy