NOT LISTED FOR SALE

Estimated Value: $3,873,000 - $5,281,073

5 Beds
6 Baths
6,295 Sq Ft
$717/Sq Ft Est. Value

Last Sold December 29, 2023

Last sale price $4,530,000 $720 Per Sq Ft

Current estimated payment $29,372/month

78 Days on Market

Highlights

  • Pool House
  • Bay View
  • Built-In Refrigerator
  • Terra Linda High School Rated A-
  • Custom Home
  • 1.19 Acre Lot

About This Home

As of December 2023

Inspired by dramatic architectural design and elevated by grand scale, this opulent Mediterranean residence invites the ultimate indoor-outdoor lifestyle. Strategically situated on a premiere Southern Heights Ridge view 1+acre lot, this luxurious hillside mansion offers a unique level of privacy and truly breathtaking SF Bay views from within the home and throughout the magnificent outdoor living areas. 5-bedrooms, 6-bathrooms and pool house complement a gracious 6,000+ square-foot floor plan, ideal for modern living. Over-sized and generously-proportioned rooms are remarkable for both their volume and natural light with nearly every window offering uplifting views of SF Bay, sweeping eastern vistas and the shimmering Bay bridges and shimmering East Bay. Panoramic vistas frame abundant outdoor living and entertainment spaces, elevating this extraordinary residence to a class of its own. A level hardscape of more than 4,000sf, encircled by a lush oasis, creates a commanding perspective and calming sense of place. Ethereal infinity pool, grand fire pit, and lavish dining and lounging areas provide the ultimate entertaining space. An orchard and organic garden below provide an assortment of fruits and vegetables to inspire daily menus during the growing season.

Last Agent to Sell the Property

Andrew Roth

Corcoran Icon Properties License #01373928 Listed on: 10/04/2023

Corcoran Icon Properties

Co-Listed By

Jennifer Pfeiffer

Corcoran Icon Properties License #01339863

Last Buyer's Agent

James Nead

Coldwell Banker Realty License #01988110

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $57,417

Year Built

  • Built in 2005 | Remodeled

Lot Details

  • 1.19 Acre Lot
  • Landscaped
  • Garden

Parking

  • 3 Car Direct Access Garage
  • 9 Open Parking Spaces
  • Garage Door Opener
  • Auto Driveway Gate

Property Views

  • Bay
  • Views of the Bay Bridge
  • Panoramic
  • Bridge
  • City Lights
  • Ridge
  • Mountain
  • Hills

Home Design

  • Custom Home
  • Contemporary Architecture
  • Mediterranean Architecture
  • Tile Roof

Interior Spaces

  • 6,295 Sq Ft Home
  • 2-Story Property
  • Cathedral Ceiling
  • Double Sided Fireplace
  • Great Room
  • Family Room
  • Living Room with Fireplace
  • 2 Fireplaces
  • Combination Dining and Living Room
  • Home Office

Kitchen

  • Double Oven
  • Free-Standing Gas Oven
  • Free-Standing Gas Range
  • Microwave
  • Built-In Refrigerator
  • Dishwasher
  • Wine Refrigerator
  • Kitchen Island
  • Stone Countertops
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Main Floor Bedroom
  • Primary Bedroom Upstairs
  • Walk-In Closet
  • Bathroom on Main Level
  • 6 Full Bathrooms
  • Marble Bathroom Countertops
  • Stone Bathroom Countertops
  • Tile Bathroom Countertop
  • Dual Vanity Sinks in Primary Bathroom
  • Jetted Tub in Primary Bathroom
  • Steam Shower
  • Separate Shower
  • Window or Skylight in Bathroom

Laundry

  • Dryer
  • Washer

Home Security

  • Prewired Security
  • Security Gate
  • Fire and Smoke Detector
  • Fire Suppression System

Pool

  • Pool House
  • Spa

Outdoor Features

  • Balcony
  • Fire Pit

Utilities

  • Central Heating and Cooling System
  • Underground Utilities

Listing and Financial Details

  • Assessor Parcel Number 018-123-08

Home Details

Home Type

Single Family

Est. Annual Taxes

$57,417

Year Built

Built in 2005 | Remodeled

Lot Details

0

Parking

3

Listing Details

  • Interior Amenities: Cathedral Ceiling
  • Type: Residential
  • Property Sub Type: Single Family Residence
  • Subtype Description: Custom, Luxury
  • Directions To Property: Take Via la Cumbre or Altura Way to Bret Harte Road.
  • Lot Size Acres: 1.1938
  • Stories: 2
  • Levels: Two
  • ArchitecturalStyle: Contemporary, Mediterranean
  • Special Features: None

Interior Features

  • Appliances: Built-In Refrigerator, Dishwasher, Disposal, Double Oven, Free Standing Electric Range, Free Standing Gas Oven, Free Standing Gas Range, Microwave, Wine Refrigerator
  • Number Of Fireplaces: 2
  • Bedrooms: 5
  • Master Bathroom Features: Double Sinks, Jetted Tub, Marble, Shower Stall(s), Steam, Stone, Tile, Window
  • Master Bedroom Features: Balcony, Walk-In Closet
  • Full Bathrooms: 6
  • Dining Room Features: Dining/Living Combo
  • Living Room Features: Cathedral/Vaulted, Great Room, View
  • Flooring: See Remarks
  • Price Per Square Foot: 719.62
  • Square Footage: 6295.00
  • Bathrooms: 6
  • Family Room Features: View
  • Fireplace Features: Double Sided, Living Room, See Remarks
  • Kitchen Features: Island, Stone Counter
  • Room Type: Office
  • Lower Level: Bedroom(s), Dining Room, Family Room, Full Bath(s), Garage, Kitchen, Living Room, Street Entrance
  • Main Level: Bedroom(s), Dining Room, Family Room, Full Bath(s), Garage, Kitchen, Living Room, Street Entrance
  • Spa Features: Spa/Hot Tub Built-In

Exterior Features

  • Lot Features: Garden, Landscape Back, Landscape Front, Landscape Misc
  • Property Condition: Updated/Remodeled
  • Roof: Tile
  • ExteriorFeatures: Fire Pit
  • OtherStructures: Other
  • Pool Features: Pool House
  • View: Bay, Bay Bridge, Bridges, City, City Lights, Hills, Mountains, Panoramic, Ridge

Garage/Parking

  • Parking Features: Attached, Garage Door Opener, Interior Access, Private, Uncovered Parking Spaces 2+
  • Total Parking Spaces: 12.00
  • Garage Spaces: 3.00
  • OpenParkingSpaces: 9.00
  • Driveway/Sidewalks: Gated

Utilities

  • Cooling: Central
  • Security Features: Fire Alarm, Fire Suppression System, Secured Access, Security Gate, Security System Prewired
  • Sewer: Public Sewer
  • Utilities: Electric, Natural Gas Available, Natural Gas Connected, Underground Utilities
  • Water Source: Public
  • Heating: Central
  • Laundry Features: Cabinets, Dryer Included, Washer Included

Lot Info

  • Assessor Parcel Number: 018-123-08
  • Lot Size Sq Ft: 52002.00

Building Info

  • Year Built: 2005

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 4, 2023
Closed on
Dec 26, 2023
Sold by
Mahmood Ghazi 1994 Trust and Ahmad Ghazi Revocable Trust
Bought by
Gregg Family Trust and Gregg
Seller's Agent
Andrew Roth
Corcoran Icon Properties
Buyer's Agent
James Nead
Coldwell Banker Realty
List Price
$6,200,000
Sold Price
$4,530,000
Premium/Discount to List
-$1,670,000
-26.94%
Views
118
Current Estimated Value
$4,512,518

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$17,482
Avg. Annual Appreciation
1.49%

Purchase Details

Closed on
Feb 20, 2009
Sold by
Ghazi Mahmood and Ghazi Ahmad
Bought by
Ghazi Mahmood

Purchase Details

Closed on
Mar 19, 2001
Sold by
Ghazi Mahmood Tr and Ahmad Ghazi Ahmad
Bought by
Ghazi Mahmood and Ghazi Ahmad

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,545,000
Interest Rate
6.97%
Mortgage Type
Construction

Purchase Details

Closed on
May 4, 1994
Sold by
Ghazi Mahmood
Bought by
Ghazi Mahmood
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
Gregg Family Trust $4,530,000 Fidelity National Title Compan
Ghazi Mahmood -- None Available
Ghazi Mahmood -- California Land Title Co
Ghazi Mahmood -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Ghazi Mahwood $2,500,000
Previous Owner Ghazi Mahmood $2,000,000
Previous Owner Ghazi Mahmood $900,000
Previous Owner Ghazi Mahmood $1,545,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/29/2023 12/29/23 Sold $4,530,000 -12.9% $720 / Sq Ft
12/21/2023 12/21/23 Pending -- -- --
12/08/2023 12/08/23 Price Changed $5,200,000 -16.1% $826 / Sq Ft
10/04/2023 10/04/23 For Sale $6,200,000 -- $985 / Sq Ft
Source: Bay Area Real Estate Information Services (BAREIS)

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 $57,417 $4,620,600 $1,836,000 $2,784,600
2024 $57,417 $4,530,000 $1,800,000 $2,730,000
2023 $43,181 $3,321,828 $1,027,270 $2,294,558
2022 $40,595 $3,256,702 $1,007,128 $2,249,574
2021 $39,887 $3,192,849 $987,381 $2,205,468
2020 $36,001 $2,856,117 $370,920 $2,485,197
2019 $34,639 $2,800,134 $363,648 $2,436,486
2018 $34,265 $2,745,248 $356,518 $2,388,730
2017 $32,834 $2,691,440 $349,529 $2,341,911
2016 $31,783 $2,638,684 $342,676 $2,296,008
2015 $30,339 $2,599,063 $337,531 $2,261,532
2014 $29,163 $2,548,166 $330,919 $2,217,247
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Bay Area Real Estate Information Services (BAREIS)

MLS Number: 323915715

Bay Area Real Estate Information Services (BAREIS)

APN: 018-123-08