NOT LISTED FOR SALE

41680 Front Hall Rd Bermuda Dunes, CA 92203

Estimated Value: $720,940 - $838,000

4 Beds
3 Baths
2,477 Sq Ft
$312/Sq Ft Est. Value

Last Sold June 20, 2025

Last sale price $780,000 $315 Per Sq Ft

Est. 1% decrease in value since last sale

Current estimated payment $4,747/month

118 Days on Market

Highlights

  • Pebble Pool Finish
  • Open Floorplan
  • Contemporary Architecture
  • James Monroe Elementary School Rated A-
  • Mountain View
  • Cathedral Ceiling

About This Home

As of June 2025

Discover this Modern Interior with 4-Bedrooms and 3-Bath Home is Designed with clean lines and an open floor plan that maximizes natural light and spacious living areas. Upon entering, you're greeted by an Expansive Great Room with High Ceilings and Porcelain Tile Floors throughout! The Great Room flows seamlessly into the Dining Room and a Gourmet Kitchen. The Kitchen features Beautiful Stainless Steel Appliances, Quartz Countertops, a Large Center Island, Custom White Shaker Cabinetry, Water Softner, and a Coffee Bar! Sliding Glass Doors open to the Outdoor Living Area, creating an ideal space for entertaining.The Primary Suite is a Luxurious Retreat, offering a Spacious Custom Shower, Dual Vanities, and a large walk-in closet with Custom Built Ins. Three additional Bedrooms are spacious, with ample closet space, and two additional Bathrooms are Modern with Stunning Finishes.The Backyard is an Entertainer's Dream, with a Sparkling Pool surrounded by a Spacious Patio for lounging. Includes a Spa and Firepit for Ultimate in Relaxation. The Outdoor Kitchen/BBQ and Dining Area are perfect for al fresco meals. The Landscaping is Lush and Low-Maintenance, with a Mix of Tropical and Contemporary Plants that includes a Raised Organic Planter Boxes for that Modern Farmer. This Home has it all, Call Today for a Private Showing!

Last Agent to Sell the Property

Lucas Coronel

Hacienda Agency, Inc. License #01327183 Listed on: 02/13/2025

Last Buyer's Agent

Shannon Guiragossian

eXp Realty of Southern California, Inc License #01969644

eXp Realty of Southern California, Inc

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,645

Year Built

  • Built in 2001

Lot Details

  • 8,276 Sq Ft Lot
  • Block Wall Fence
  • Landscaped
  • Rectangular Lot
  • Sprinklers on Timer
  • Private Yard
  • Lawn
  • Back and Front Yard

HOA Fees

  • $32 Monthly HOA Fees

Home Design

  • Contemporary Architecture
  • Modern Architecture
  • Slab Foundation
  • Tile Roof
  • Stucco Exterior

Interior Spaces

  • 2,477 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Partially Furnished
  • Bar
  • Cathedral Ceiling
  • Recessed Lighting
  • Electric Fireplace
  • Gas Fireplace
  • Double Door Entry
  • French Doors
  • Sliding Doors
  • Family Room with Fireplace
  • Great Room
  • Formal Dining Room
  • Utility Room
  • Tile Flooring
  • Mountain Views

Kitchen

  • Breakfast Area or Nook
  • Breakfast Bar
  • Gas Range
  • Range Hood
  • Recirculated Exhaust Fan
  • Microwave
  • Water Line To Refrigerator
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Double Vanity

Laundry

  • Laundry Room
  • Dryer
  • Washer

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Driveway

Pool

  • Pebble Pool Finish
  • In Ground Pool
  • Heated Spa
  • In Ground Spa
  • Gunite Pool
  • Outdoor Pool
  • Saltwater Pool
  • Ceramic Spa Tile
  • Gunite Spa
  • Pool Tile

Outdoor Features

  • Built-In Barbecue

Utilities

  • Two cooling system units
  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Property is located within a water district
  • Gas Water Heater
  • Sewer in Street

Community Details

  • Planned Unit Development

Listing and Financial Details

  • Assessor Parcel Number 607193016

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,645

Year Built

Built in 2001

Lot Details

0

HOA Fees

$32 per month

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Property Attached/Detached: No
  • Levels: One
  • Building Number Of Stories: 1
  • Building Style: Contemporary, Modern
  • Included In Sale: Furniture
  • List Price per Sq Ft: 322.93
  • Lp Sp Ratio: 0.9800
  • View Type: Mountain(s)
  • Water District Name: Myoma Water Co.
  • Year Built: 2001
  • Listing I D: 219124755
  • Listing Member Address: 77-935 Calle Tampico, Ste 201, La Quinta, CA 92253
  • Listing Member Fax: (760) 564-9874
  • Listing Office Address: 77-935 Calle Tampico, Ste 201, La Quinta, CA 92253
  • Listing Office Fax: (760) 564-9874
  • Selling Office Address: 10620 Treena St Ste 230, Gina Saad, San Diego, CA 92131
  • Land Type: Fee
  • Subdivision: Not Applicable
  • Special Features: None

Interior Features

  • Appliances: Dryer, Gas Range, Microwave Oven, Exhaust Fan, Water Line to Refrigerator, Washer, Refrigerator, Disposal, Dishwasher
  • Fireplace: Yes
  • Fireplace Location: Family Room
  • Interior Amenities: Cathedral Ceiling(s), Recessed Lighting, Open Floorplan, High Ceilings (9 Ft+)
  • Range Hood: Yes
  • Fireplace Features: Electric, Gas
  • Flooring: Tile
  • Bedroom Features: All Bedrooms Down, Walk In Closet
  • Total Bedrooms: 4
  • Bathroom Features: Double Vanity(s)
  • Total Bathrooms: 3.00
  • Full Bathrooms: 2
  • Three Quarter Bathrooms: 1
  • Eating Areas: Breakfast Counter/Bar, Living/Dining Combo, Kitchen Island, Formal Dining Room, Breakfast Nook
  • Kitchen Features: Island, Quartz Counters
  • Laundry: Laundry Area
  • Estimated Sq Ft: 2477.00

Exterior Features

  • Construction: Stucco
  • Roofing: Tile
  • Built-in BBQ: Gas
  • Fencing: Block, Fenced
  • Foundation: Slab
  • Pool: Yes
  • Pool Construction: Gunite, Tile, Pebble, In Ground
  • Pool Description: Salt Water, Private, In Ground, Gunite
  • Pool Location: Private
  • Planned Unit Development: Yes
  • Spa Hot Tub: Yes
  • Spa Hot Tub Construction: Gunite, Pebble, Tile, In Ground
  • Spa Hot Tub Description: Heated - Gas, Private
  • View: Yes

Garage/Parking

  • Garage: Yes
  • Garage Description: Attached
  • Parking: Garage Door Opener, Driveway
  • Total Garage Spaces: 2.00
  • Total Parking Spaces: 4.00
  • Total Uncovered Assigned Spaces: 2.00

Utilities

  • Cooling Type: Air Conditioning, Electric, Dual, Central Air
  • Heating: Central, Forced Air, Fireplace(s)
  • Heating Fuel: Natural Gas
  • Sewer: In Street on Bond
  • Water: In Street, Water District
  • Water Heater Feature: Gas

Association/Amenities

  • Community Features: Curbs, Street Lighting
  • Association #1 Frequency: Monthly

Condo/Co-op/Association

  • HOA Information: Yes
  • HOA Fee 1: 32.00
  • Total Monthly Association Fees: 32.00

Lot Info

  • Sprinklers: Yes
  • Assessor Parcel Number: 607193016
  • Irrigation: Sprinkler System, Sprinkler Timer
  • Lot Description: Back Yard, Yard, Street Public, Single Lot, Rectangular Lot, Landscaped, Lawn, Front Yard
  • Lot Size: 8276.00

Rental Info

  • Furnished: Partially
  • Land Lease Type: Fee Simple

Tax Info

  • Mello Roos: Unknown

Multi Family

  • Total Fireplaces: 1

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 15, 2021
Closed on
Nov 26, 2021
Sold by
Coronel Maria Hazany
Bought by
Coronel Esequiel
Seller's Agent
Nguyen Pham
Professional R.E. Center, Inc.
Buyer's Agent
Lucas Coronel
Hacienda Agency, Inc.
List Price
$535,000
Sold Price
$525,000
Premium/Discount to List
-$10,000
-1.87%
Current Estimated Value
$772,235

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$247,235
Avg. Annual Appreciation
10.66%
Original Mortgage
$472,500
Outstanding Balance
$435,354
Interest Rate
3.09%
Mortgage Type
New Conventional
Estimated Equity
$336,881

Purchase Details

Listed on
Aug 15, 2021
Closed on
Nov 24, 2021
Sold by
Tran Kenny T and Thi Thu
Bought by
Coronet Esequiel
Seller's Agent
Nguyen Pham
Professional R.E. Center, Inc.
Buyer's Agent
Lucas Coronel
Hacienda Agency, Inc.
List Price
$535,000
Sold Price
$525,000
Premium/Discount to List
-$10,000
-1.87%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$472,500
Outstanding Balance
$435,354
Interest Rate
3.09%
Mortgage Type
New Conventional
Estimated Equity
$336,881

Purchase Details

Listed on
Feb 20, 2019
Closed on
Jun 25, 2019
Sold by
Enos William A and Enos Karen L
Bought by
Tran Kenny T and Pham Thi Thu Tham
Seller's Agent
Michelle Lin
Smart Realty Group
Buyer's Agent
Nguyen Pham
Professional R.E. Center, Inc.
List Price
$399,000
Sold Price
$390,000
Premium/Discount to List
-$9,000
-2.26%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
13.42%
Original Mortgage
$292,500
Interest Rate
3.82%
Mortgage Type
New Conventional

Purchase Details

Closed on
Feb 15, 2017
Sold by
Enos William A and Enos Karen L
Bought by
Enos William A and Enos Karen L

Purchase Details

Listed on
Aug 23, 2013
Closed on
Sep 19, 2013
Sold by
Aloha Nui Inc
Bought by
Enos William A and Enos Karen L
Seller's Agent
BOB WASSON
BOB WASSON, BROKER
List Price
$299,900
Sold Price
$295,000
Premium/Discount to List
-$4,900
-1.63%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
8.39%
Original Mortgage
$7,547
Interest Rate
4.36%
Mortgage Type
Unknown

Purchase Details

Listed on
Aug 23, 2013
Closed on
Aug 15, 2013
Sold by
Courtney Clarence Lee and Courtney Lola Mae
Bought by
Aloha Nui Inc
Seller's Agent
BOB WASSON
BOB WASSON, BROKER
List Price
$299,900
Sold Price
$295,000
Premium/Discount to List
-$4,900
-1.63%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$7,547
Interest Rate
4.36%
Mortgage Type
Unknown

Purchase Details

Closed on
Sep 21, 2005
Sold by
The Clarence Lee & Lola Mae Courtney Liv
Bought by
Courtney Clarence Lee and Courtney Lola Mae

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$242,000
Interest Rate
5.63%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 29, 2004
Sold by
Courtney Clarence L and Courtney Lola
Bought by
Courtney Clarence Lee and Courtney Lola Mae

Purchase Details

Closed on
Dec 29, 2000
Sold by
Kaufman & Broad Of Southern Ca Inc
Bought by
Courtney Clarence L and Courtney Lola

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$212,050
Interest Rate
7.41%
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Coronel Esequiel -- Lawyers Title
Coronet Esequiel $525,000 Lawyers Title
Tran Kenny T $390,000 Ticor Title Riverside
Enos William A -- None Available
Enos William A $295,000 Title 365
Aloha Nui Inc $250,200 Accommodation
Courtney Clarence Lee -- Stewart Title Of California
Courtney Clarence Lee -- --
Courtney Clarence L $219,000 First American Title Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Coronel Esequiel $472,500
Closed Coronet Esequiel $472,500
Previous Owner Tran Kenny T $260,000
Previous Owner Tran Kenny T $292,500
Previous Owner Aloha Nui Inc $7,547
Previous Owner Aloha Nui Inc $250,200
Previous Owner Courtney Clarence Lee $101,000
Previous Owner Courtney Clarence Lee $242,000
Previous Owner Courtney Clarence Lee $29,918
Previous Owner Courtney Clarence Lee $20,000
Previous Owner Courtney Clarence L $222,500
Previous Owner Courtney Clarence L $217,000
Previous Owner Courtney Clarence L $212,050
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/20/2025 06/20/25 Sold $780,000 -2.5% $315 / Sq Ft
06/11/2025 06/11/25 Pending -- -- --
05/13/2025 05/13/25 Price Changed $799,900 -1.8% $323 / Sq Ft
04/03/2025 04/03/25 Price Changed $814,900 -1.8% $329 / Sq Ft
02/13/2025 02/13/25 For Sale $829,900 +58.1% $335 / Sq Ft
12/02/2021 12/02/21 Sold $525,000 -1.9% $212 / Sq Ft
10/06/2021 10/06/21 Pending -- -- --
08/15/2021 08/15/21 For Sale $535,000 +37.2% $216 / Sq Ft
07/26/2019 07/26/19 Sold $390,000 -2.3% $157 / Sq Ft
06/21/2019 06/21/19 Pending -- -- --
06/08/2019 06/08/19 For Sale $399,000 0.0% $161 / Sq Ft
06/03/2019 06/03/19 Pending -- -- --
04/07/2019 04/07/19 Price Changed $399,000 -2.4% $161 / Sq Ft
03/04/2019 03/04/19 Price Changed $409,000 -4.7% $165 / Sq Ft
02/20/2019 02/20/19 For Sale $429,000 +45.4% $173 / Sq Ft
10/11/2013 10/11/13 Sold $295,000 -1.6% $119 / Sq Ft
09/16/2013 09/16/13 Pending -- -- --
08/23/2013 08/23/13 For Sale $299,900 -- $121 / Sq Ft
Source: California Desert Association of REALTORS®

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $7,645 $604,257 $106,120 $498,137
2024 $7,645 $592,410 $104,040 $488,370
2023 $7,645 $535,500 $102,000 $433,500
2022 $6,849 $525,000 $100,000 $425,000
2021 $5,223 $394,040 $22,733 $371,307
2020 $5,130 $390,000 $22,500 $367,500
2019 $4,246 $324,172 $87,908 $236,264
2018 $4,169 $317,817 $86,186 $231,631
2017 $4,106 $311,587 $84,497 $227,090
2016 $4,029 $305,479 $82,841 $222,638
2015 $4,041 $300,893 $81,598 $219,295
2014 $3,977 $295,000 $80,000 $215,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: California Desert Association of REALTORS®

MLS Number: 219124755

California Desert Association of REALTORS®

APN: 607-193-016