NOT LISTED FOR SALE

3977 Castellina Way Manteca, CA 95337

Estimated Value: $1,068,724 - $1,220,000

4 Beds
2.5 Baths
3,260 Sq Ft
$348/Sq Ft Est. Value

Last Sold May 07, 2024

Last sale price $1,149,000 $352 Per Sq Ft

Est. 1% decrease in value since last sale

Current estimated payment $7,287/month

8 Days on Market

Highlights

  • Lake Front
  • Custom Home
  • Clubhouse
  • Sierra High School Rated A-
  • Gated Community
  • Marble Flooring

About This Home

As of May 2024

Welcome to this luxurious, 1 of only 27 custom homes with the best lake view in the prestigious Oakwood Shores gated community featuring stacked-stone highlights and courtyard at the front. Step inside to a grand entry with elegant high ceilings and a sweeping spiral staircase, spacious family room with open beam ceilings, custom stone fireplace and distressed hardwood flooring throughout the family room and chef's kitchen; featuring slab granite counters, tumbled tile back splash, stainless appliances, GE Monogram cooktop & custom hood, built in desk at breakfast nook, custom built hutch in dinning room and many more high end finishes. The master bedroom is located on the main floor with amazing views of the lake. Master bath includes his & her vanities, granite counters, marble flooring, custom shower with tumble tile and plenty of cabinets. Upstairs you will find a large loft with a balcony to enjoy the gorgeous views overlooking the lake. Home also features finished & painted 3-car garage with epoxy floor and extra kitchen setup. Backyard features artificial grass, fire pit area, palm trees, and colored stamped concrete. Move-in ready, your new home awaits you.

Last Listed By

Wida Sayedzada

Welcome Home Realty, Inc. License #01493597 Listed on: 04/12/2024

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $9,674

Year Built

  • Built in 2009 | Remodeled

Lot Details

  • 7,501 Sq Ft Lot
  • Lake Front
  • Fenced For Horses
  • Landscaped
  • Manual Sprinklers System
  • Zoning described as R1

HOA Fees

  • $190 Monthly HOA Fees

Parking

  • 3 Car Garage
  • Inside Entrance
  • Front Facing Garage
  • Garage Door Opener

Home Design

  • Custom Home
  • Concrete Foundation
  • Slab Foundation
  • Frame Construction
  • Tile Roof
  • Concrete Perimeter Foundation
  • Marble or Granite Building Materials
  • Stucco

Interior Spaces

  • 3,260 Sq Ft Home
  • 2-Story Property
  • Beamed Ceilings
  • Cathedral Ceiling
  • Ceiling Fan
  • Gas Log Fireplace
  • Stone Fireplace
  • Double Pane Windows
  • ENERGY STAR Qualified Windows
  • Formal Entry
  • Family Room with Fireplace
  • Combination Dining and Living Room
  • Loft
  • Storage Room
  • Lake Views

Kitchen

  • Breakfast Area or Nook
  • Self-Cleaning Oven
  • Built-In Gas Range
  • Range Hood
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Marble
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom on Main
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • Granite Bathroom Countertops
  • Stone Bathroom Countertops
  • Tile Bathroom Countertop
  • Secondary Bathroom Double Sinks
  • Low Flow Toliet
  • Bathtub with Shower
  • Window or Skylight in Bathroom

Laundry

  • Laundry Room
  • Laundry on main level
  • Sink Near Laundry
  • 220 Volts In Laundry
  • Gas Dryer Hookup

Home Security

  • Security System Owned
  • Security Gate
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Access To Lake
  • Balcony
  • Fire Pit

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Refrigerated and Evaporative Cooling System
  • 220 Volts in Kitchen
  • Water Filtration System
  • Private Water Source
  • Water Heater

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 241-680-15

Community Details

Overview

  • Association fees include management, common areas, pool, recreation facility, road, security
  • Oakwood Shores HOA, Phone Number (209) 507-7850
  • Built by Beck Homes
  • Mandatory home owners association

Amenities

  • Community Barbecue Grill
  • Clubhouse

Recreation

  • Outdoor Game Court
  • Community Playground
  • Community Pool

Building Details

  • Net Lease

Security

  • Security Guard
  • Controlled Access
  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,674

Year Built

Built in 2009 | Remodeled

Lot Details

0

HOA Fees

$190 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Subtype Description: Custom, Detached, Loft
  • Property Subtype 1: Single Family Residence
  • Remodeled Updated: Yes
  • Year Built: 2009
  • Levels: Two
  • Remodeled/Updated Desc: Bath 0-5YR, Kitchen 0-5YR, Bed 0-5YR, Other-Rmks 0-5YR
  • ResoPropertyType: Residential
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 0

Interior Features

  • Appliances: Built-In Gas Range, Hood Over Range, Dishwasher, Disposal, Microwave, Self/Cont Clean Oven
  • Interior Amenities: Cathedral Ceiling, Formal Entry, Open Beam Ceiling
  • Other Equipment: Water Cond Equipment Owned, Water Filter System
  • Fireplace Features: Stone, Family Room, Gas Log, Gas Piped
  • Fireplaces: 1
  • Flooring: Carpet, Tile, Marble, Wood
  • Possible Bedrooms: 5
  • Master Bathroom Features: Closet, Double Sinks, Granite, Stone, Low-Flow Toilet(s), Marble, Walk-In Closet, Window
  • Master Bedroom Features: Ground Floor, Outside Access
  • Total Bathrooms: 3
  • Bathroom Features: Double Sinks, Stone, Tile, Tub w/Shower Over, Marble, Window
  • Dining Room Features: Dining/Living Combo
  • Family Room Features: View, Open Beam Ceiling
  • Kitchen Features: Breakfast Area, Pantry Cabinet, Granite Counter, Island w/Sink
  • Living Room Features: Cathedral/Vaulted, View
  • Room Type: Loft, Master Bathroom, Master Bedroom, Dining Room, Family Room, Storage, Kitchen, Laundry, Living Room
  • Main Level: Living Room, Dining Room, Family Room, Master Bedroom, Full Bath(s), Partial Bath(s), Garage, Kitchen
  • Price Per Square Foot: 352.45
  • Square Footage: 3260.00
  • Window Features: Dual Pane Full

Exterior Features

  • Builder Name: Beck Homes
  • Construction Materials: Stucco, Frame, Wood
  • Disclosures/Documents: Preliminary Title Report
  • Exterior Features: Balcony, Fire Pit
  • Fencing: Fenced
  • Foundation: Concrete, Slab
  • Frontage Type: Lakefront
  • Home Warranty: Yes
  • Horse Property: No
  • Listing Price: 1149000.00
  • Lot Features: Manual Sprinkler F&R, Auto Sprinkler F&R, Curb(s)/Gutter(s), Gated Community, Grass Artificial, Lake Access, Landscape Back, Landscape Front, Low Maintenance
  • New Construction: No
  • Pool: No
  • Property Condition: Updated/Remodeled
  • Road Surface Type: Paved
  • Roof: Tile
  • Spa: No
  • View Description: Lake
  • Land Use: Residential

Garage/Parking

  • Garage Spaces: 3.00
  • Parking Features: Garage Door Opener, Garage Facing Front, Interior Access
  • Driveway/Sidewalks: Gated, Sidewalk/Curb/Gutter

Utilities

  • Security: Carbon Mon Detector, Double Strapped Water Heater, Security System Owned, Smoke Detector, Secured Access, Security Gate, Security Patrol
  • Sewer: In & Connected, Public Sewer
  • Utilities: Public
  • Cooling: Ceiling Fan(s), Central, MultiZone
  • Electric: 220 Volts in Kitchen, 220 Volts in Laundry
  • Heating: Central, Fireplace(s), MultiZone
  • Laundry Features: Cabinets, Laundry Closet, Sink, Electric, Gas Hook-Up, Ground Floor
  • Water Source: Private

Condo/Co-op/Association

  • Association Features: Barbeque, Playground, Pool, Clubhouse, Game Court Exterior
  • Association Fee: 190
  • Association Fee Frequency: Monthly
  • Association Fee Includes: Management, Common Areas, Pool, Recreation Facility, Road, Security
  • Association Name: Oakwood Shores HOA
  • Association Phone: (209) 507-7850
  • Association: Yes
  • Senior Community: No
  • ResoAssociationFeeFrequency: Monthly

Association/Amenities

  • Mandatory Association: Yes

Fee Information

  • Land Lease: No

Schools

  • Senior High School District: Manteca Unified

Lot Info

  • Zoning Description: R1
  • Irrigation: Public District
  • Lot Size Acres: 0.1722
  • Lot Size Sq Ft: 7501.00
  • ResoLotSizeUnits: Acres

Green Features

  • Energy Efficient: Windows

Rental Info

  • Lease Type: Net

Multi Family

Tax Info

  • Assessor Parcel Number: 241-680-15
  • Bonds/Assessments/Taxes: Unknown

MLS Schools

  • School District (County): San Joaquin

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 12, 2024
Closed on
May 6, 2024
Sold by
Sayedzada Wida
Bought by
Hamidi Ziaulhaque and Hamidi Barbi Lei
Seller's Agent
Wida Sayedzada
Welcome Home Realty, Inc.
Buyer's Agent
Chrissy Lew
Home Buyers Realty
List Price
$1,149,000
Sold Price
$1,149,000
Total Days on Market
8
Views
36
Current Estimated Value
$1,134,681

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$14,319
Avg. Annual Appreciation
-1.26%
Original Mortgage
$919,200
Outstanding Balance
$910,449
Interest Rate
6.87%
Mortgage Type
New Conventional
Estimated Equity
$224,232

Purchase Details

Closed on
Oct 27, 2020
Sold by
Singh Jagroop
Bought by
Sayedzada Wida

Home Financials for this Owner

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

Purchase Details

Closed on
Apr 9, 2018
Sold by
Garcia David A
Bought by
Singh Jagroop

Home Financials for this Owner

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

Purchase Details

Closed on
Mar 28, 2018
Sold by
Rina S Grove Lp
Bought by
Singh Jagroop

Home Financials for this Owner

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

Purchase Details

Closed on
Sep 1, 2015
Sold by
Dhaliwal Gurpreet K
Bought by
Singh Jagroop

Home Financials for this Owner

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

Purchase Details

Closed on
May 9, 2011
Sold by
Singh Parminder
Bought by
Dhaliwal Gurpreet K

Purchase Details

Closed on
Oct 13, 2010
Sold by
Oakwood Lt Venture I Llc
Bought by
Dhaliwal Gurpreet K

Home Financials for this Owner

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

Purchase Details

Closed on
Sep 28, 2009
Sold by
Bank Of America Na
Bought by
Oakwood Lt Ventures I Llc

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
Hamidi Ziaulhaque $1,149,000 Wfg National Title Insurance C
Sayedzada Wida $750,000 First American Title Company
Singh Jagroop $490,000 Old Republic Title Company
Singh Jagroop $389,000 Placer Title Company
Singh Jagroop $600,000 First American Title Company
Dhaliwal Gurpreet K -- First American Title Company
Dhaliwal Gurpreet K $422,500 First American Title Company
Oakwood Lt Ventures I Llc -- First American Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Hamidi Ziaulhaque $919,200
Previous Owner Sayedzada Wida $400,000
Previous Owner Sayedzada Wida $440,000
Previous Owner Singh Jagroop $440,000
Previous Owner Singh Jagroop $380,991
Previous Owner Singh Jagroop $250,000
Previous Owner Singh Jagroop $417,000
Previous Owner Dhaliwal Gurpreet K $338,000
Closed Oakwood Lt Ventures I Llc $0
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/07/2024 05/07/24 Sold $1,149,000 0.0% $352 / Sq Ft
04/20/2024 04/20/24 Pending -- -- --
04/12/2024 04/12/24 For Sale $1,149,000 -- $352 / Sq Ft
Source: MetroList

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
2024 $9,674 $795,905 $233,465 $562,440
2023 $9,445 $780,300 $228,888 $551,412
2022 $8,734 $765,000 $224,400 $540,600
2021 $8,641 $750,000 $220,000 $530,000
2020 $7,287 $649,458 $227,310 $422,148
2019 $7,194 $636,724 $222,853 $413,871
2018 $7,102 $624,240 $218,484 $405,756
2017 $7,001 $612,000 $214,200 $397,800
2016 $6,838 $600,000 $210,000 $390,000
2015 $5,231 $450,385 $156,702 $293,683
2014 $4,902 $441,564 $153,633 $287,931
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Similar Homes in Manteca, CA

  • 3853 Castellina Way, Manteca, CA 95337

    $1,049,000

    • 3 Beds
    • 2.5 Baths
    • 2,732 Sq Ft
    • 3853 Castellina Way
    • Manteca, CA

    Welcome to your exclusive, luxurious lakefront home! This gem is in the prestigious Oakwood Shores community of Manteca, CA. Built in 2017, this 2,732 sq. ft. residence features top of the line upgrades. The home includes 3 bedrooms, an additional room, 2.5 bathrooms, Bedrosian tile floors, ceiling fans, Hunter Douglas Palm Beach Plantation Shutters, insulated interior walls for soundproofing and

    Jamie Hood HomeSmart PV & Associates

    Section Image
  • 788 E Willow Ave, Manteca, CA 95337

    $1,200,000

    • 4 Beds
    • 4 Baths
    • 2,088 Sq Ft
    • 788 E Willow Ave
    • Manteca, CA

    Rare Waterfront Opportunity - Welcome to your Delta dream property! Nestled on a prime corner lot, this one-of-a-kind package includes two homes, four lots over half an acre total, four private boat docks, RV/boat storage, a carport, and so much more, all designed for ultimate comfort and outdoor adventure. Main Home is manufactured and was built with 2X6 construction over a full-size garage.

    Kim Medeiros PMZ Real Estate

    Section Image
  • 21915 Oleander Ave, Manteca, CA 95337

    $1,399,000

    • 3 Beds
    • 2 Baths
    • 1,512 Sq Ft
    • 21915 Oleander Ave
    • Manteca, CA

    Country Living with City Convenience! Nestled on 11.5+ acres, this incredible property offers the perfect blend of rural charm and modern comfort. Featuring approx 10 acres of producing Independence variety almond trees, you'll also enjoy room to park your RV and toys, a large garage/workshop to park cars, boats and other equipment, barn and corrals, this property has it all! Fruit trees, room

    Brandon Joaquin RE/MAX Executive

    Section Image
  • 2385 Cava Place, Manteca, CA 95337

    $1,150,000

    • 5 Beds
    • 4.5 Baths
    • 3,939 Sq Ft
    • 2385 Cava Place
    • Manteca, CA

    Beautiful 2018 built, 5-6 Bedroom, 4.5-Bathroom Home features one bedroom downstairs with own bathroom, and an additional another half bathroom, located in Cul-De-Sac with Pool, RV Access & Exceptional Features, conveniently located near the freeway & all essential amenities. Enjoy freshly installed carpet throughout, dual AC units and an updated kitchen with high-end appliances, built-in

    Section Image

Source: MetroList

MLS Number: 224031029

MetroList

APN: 241-680-15