NOT LISTED FOR SALE

Estimated Value: $1,556,000 - $1,674,000

4 Beds
3.5 Baths
3,940 Sq Ft
$406/Sq Ft Est. Value

Last Sold November 07, 2023

Last sale price $1,485,000 $377 Per Sq Ft

Est. 8% increase in value since last sale

Current estimated payment $10,821/month

76 Days on Market

Highlights

  • Waterfront Community
  • Gated Community
  • Property is near a lake
  • Pebble Pool Finish
  • Lake View
  • Wood Flooring

About This Home

As of November 2023

Introducing a million-dollar masterpiece: 2507 West Lake Van Ness Circle, a luxurious lakefront estate that has undergone a meticulous and lavish remodel. This one-of-a-kind property is the epitome of opulence, perfect for those with discerning tastes seeking the ultimate dream home.Nestled in Fresno's most prestigious and desirable area, this private community offers an exclusive lifestyle centered around the picturesque lake. Wake up each morning to the breathtaking views, transporting you to a state of serenity and tranquility.Spanning an impressive 3,940 square feet, this estate boasts four spacious bedrooms and three exquisitely designed bathrooms. Every detail has been carefully curated to create a haven of sophistication and elegance.For those seeking relaxation, the patio transforms into a haven of tranquility, where poolside lounging becomes a luxurious affair. Immerse yourself in the cool waters of the pool, basking in the warmth of the sun, and feel the worries of the day melt away.This home also offers an exceptional surround sound music system throughout the entire house, ensuring that your living spaces are filled with your favorite tunes, enhancing the ambiance of every room. Additionally, a Creston entertainment system adds another layer of convenience and luxury, allowing you to control your home's entertainment and security systems with ease.

Last Agent to Sell the Property

Juan Cordero Escalante

Envision Realty, Inc. License #02152649 Listed on: 07/26/2023

Co-Listed By

J. Francisco Alvarez

Envision Realty, Inc. License #01871610

Last Buyer's Agent

Mohamad Mansour

Universal Realty Services, Inc License #01934065

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $18,837

Year Built

  • Built in 1994

Lot Details

  • 0.31 Acre Lot
  • Lot Dimensions are 80x170
  • Cul-De-Sac
  • Front and Back Yard Sprinklers
  • Property is zoned RS3

HOA Fees

  • $500 Monthly HOA Fees

Home Design

  • Mediterranean Architecture
  • Concrete Foundation
  • Tile Roof
  • Stucco

Interior Spaces

  • 3,940 Sq Ft Home
  • 2-Story Property
  • 2 Fireplaces
  • Self Contained Fireplace Unit Or Insert
  • Double Pane Windows
  • Family Room
  • Living Room
  • Formal Dining Room
  • Home Office
  • Lake Views
  • Laundry on lower level

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Microwave
  • Dishwasher
  • Wine Refrigerator
  • Disposal

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 3.5 Bathrooms
  • Jetted Tub in Primary Bathroom
  • Separate Shower

Pool

  • Pebble Pool Finish
  • In Ground Pool
  • Pool Water Feature

Outdoor Features

  • Property is near a lake
  • Covered patio or porch

Additional Features

  • Ground Level Unit
  • Central Heating and Cooling System

Community Details

Recreation

  • Waterfront Community

Security

  • Security Guard
  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$18,837

Year Built

Built in 1994

Lot Details

0

HOA Fees

$500 per month

Listing Details

  • Type: Residential
  • Property Sub Type: Single Family Residence
  • Style: Mediterranean
  • Price Per Square Foot: 376.90
  • Year Built Exception: 0
  • Number Of Stories: Two
  • Unit Description: Ground Floor
  • Special Features: None
  • Stories: 2
  • Year Built: 1994

Interior Features

  • Fireplace Type: Gas Insert
  • Number Of Fireplaces: 2
  • Flooring: Tile, Hardwood
  • Bathrooms: 3.25
  • Bedrooms: 4
  • Bathroom Features: Shower, Jetted Tub
  • Dining Room Features: Formal, Living Room/Area, Family Room/Area
  • Kitchen: Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry, Refrigerator, Wine Refrigerator
  • Laundry: Utility Room, On Lower Level
  • Extra Rooms: Office
  • Basement: None
  • Square Footage: 3940.00

Exterior Features

  • Yard: Sprinklers Front, Sprinklers Back, Sprinklers Auto
  • Roofing: Tile
  • Pool Type: In Ground
  • Exterior: Stucco
  • Foundation: Concrete
  • Patio: Covered, Concrete
  • Pool: Yes
  • Pool Features: Pebble, Water Feature

Utilities

  • Heating And Cooling: Central Heat & Cool
  • Gas And Electric: Public Utilities
  • Sewer/Water: Public Water

Condo/Co-op/Association

  • Association: Fresno MLS
  • Frequency: monthly
  • HOA Fees: 500.00

Association/Amenities

  • Site Amenities: Cul De Sac, Lakeview, Water Front
  • Association Park Amenities: Security Guard, Lake/Pond, Gated Community

Lot Info

  • Acres: 0.3122
  • Lot Dimensions: 80X170
  • Lot Measurement: Square Feet
  • Lot Size Sq Ft: 13600.00
  • Price Per Acre: 4756566.30

Green Features

  • Energy Efficiency: Dual Pane Windows

Building Info

  • Year Built: 1994

MLS Schools

  • School District 2: Fresno Unified
  • School Type: High School
  • School Name: Bullard
  • School Type: Junior High School
  • School Name: Tenaya
  • School Type: Grade School
  • School Name: Forkner

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jun 11, 2025
Sold by
Alhalemi Mohamed
Bought by
Mohamed And Khadega Alhalemi Living Trust and Alhalemi
Current Estimated Value
$1,598,464

Purchase Details

Listed on
Jul 26, 2023
Closed on
Oct 31, 2023
Sold by
Marquez Jaime A
Bought by
Alhalemi Mohamed
Seller's Agent
Juan Cordero Escalante
Envision Realty, Inc.
Buyer's Agent
Mohamad Mansour
Universal Realty Services, Inc
List Price
$1,699,999
Sold Price
$1,485,000
Premium/Discount to List
-$214,999
-12.65%
Views
340

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.59%
Original Mortgage
$1,113,750
Interest Rate
7.19%
Mortgage Type
New Conventional

Purchase Details

Closed on
May 26, 2016
Sold by
Marquez Jaime
Bought by
Marquez Jaime A

Purchase Details

Closed on
Dec 17, 2004
Sold by
Marquez Jaime
Bought by
Marquez Jaime

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$640,000
Interest Rate
5.5%
Mortgage Type
Purchase Money Mortgage
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
Mohamed And Khadega Alhalemi Living Trust -- None Listed On Document
Alhalemi Mohamed $1,485,000 Placer Title Company
Alhalemi Mohamed -- Placer Title Company
Marquez Jaime A -- None Available
Marquez Jaime -- Fidelity National Title Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Alhalemi Mohamed $1,113,750
Previous Owner Marouez Jaime A $500,000
Previous Owner Marquez Jaime L $250,000
Previous Owner Marquez Jaime $640,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/07/2023 11/07/23 Sold $1,485,000 -4.2% $377 / Sq Ft
10/10/2023 10/10/23 Pending -- -- --
09/20/2023 09/20/23 Price Changed $1,550,000 -8.8% $393 / Sq Ft
09/07/2023 09/07/23 For Sale $1,699,999 +14.5% $431 / Sq Ft
09/05/2023 09/05/23 Off Market $1,485,000 -- --
08/01/2023 08/01/23 For Sale $1,699,999 +14.5% $431 / Sq Ft
07/31/2023 07/31/23 Off Market $1,485,000 -- --
07/26/2023 07/26/23 For Sale $1,699,999 -- $431 / Sq Ft
Source: Fresno MLS

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 $18,837 $1,514,700 $510,000 $1,004,700
2023 $18,837 $1,110,416 $383,905 $726,511
2022 $13,904 $1,088,644 $376,378 $712,266
2021 $13,521 $1,067,299 $368,999 $698,300
2020 $13,463 $1,056,356 $365,216 $691,140
2019 $12,941 $1,035,644 $358,055 $677,589
2018 $12,659 $1,015,338 $351,035 $664,303
2017 $12,441 $995,430 $344,152 $651,278
2016 $12,027 $975,912 $337,404 $638,508
2015 $11,843 $961,254 $332,336 $628,918
2014 $11,620 $942,425 $325,826 $616,599
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Fresno MLS

MLS Number: 597701

Fresno MLS

APN: 500-300-05S