NOT LISTED FOR SALE

40673 Squill Common Unit 21 Fremont, CA 94538

Irvington Neighborhood

Estimated Value: $1,223,000 - $1,402,421

3 Beds
2.5 Baths
1,721 Sq Ft
$293/mo HOA Fee

Last Sold January 14, 2020

Last sale price $915,000 $532 Per Sq Ft

Est. 44% increase in value since last sale

Current estimated payment $8,671/month

85 Days on Market

Highlights

  • New Construction
  • Solar Power System
  • Bonus Room
  • J. Haley Durham Elementary School Rated A-
  • Contemporary Architecture
  • Solid Surface Countertops

About This Home

As of January 2020

This townhome-style two-story home begins with an enclosed private patio entry and joins three bedrooms with a loft and gathering room to suit ever-changing lifestyles. Doors of opportunity open with its ground level living areas that blend a corner gathering room, spacious cafe and open kitchen with a multifunctional island. A versatile upstairs loft is central to an owner’s suite with dual walk-in closets and a pair of secondary bedrooms for special guests, the independent teen or a busy home office. Move-in Ready! Included: Stainless steel Whirlpool refrigerator, upgraded Whirlpool kitchen appliance package, Quartz kitchen countertop, gray slab beech cabinets, tile backsplash upgrade, undermounted rectangular bath sinks, upgraded chrome lighting package, Whirlpool Duet front loaded washer/dryer, recessed lighting upgrade packages, Pulte Smart Home, and more. Please see Sales Consultant for complete list of features and upgrades.

Last Agent to Sell the Property

Suzie Gibbons

Pulte Group License #01834382 Listed on: 08/14/2019

Last Buyer's Agent

Shoaib Mahmud

License #01308392

Property Details

Home Type

  • Condominium

Est. Annual Taxes

  • $11,773

Year Built

  • Built in 2019 | New Construction

Lot Details

  • 10,193

HOA Fees

  • $293 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Home Design

  • Contemporary Architecture
  • Slab Foundation
  • Shingle Roof
  • Stucco

Interior Spaces

  • 2-Story Property
  • Double Pane Windows
  • Low Emissivity Windows
  • Bonus Room

Kitchen

  • Gas Range
  • Microwave
  • Plumbed For Ice Maker
  • Dishwasher
  • Kitchen Island
  • Solid Surface Countertops
  • Disposal

Flooring

  • Carpet
  • Laminate
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Low Flow Toliet

Laundry

  • Dryer
  • Washer

Home Security

  • Smart Home
  • Smart Thermostat

Eco-Friendly Details

  • Solar Power System
  • Solar owned by a third party

Utilities

  • Zoned Cooling
  • Heating System Uses Natural Gas
  • Tankless Water Heater

Community Details

Overview

  • Association fees include common area maintenance, exterior maintenance, hazard insurance, management fee, reserves
  • 67 Units
  • Vintage HOA, Phone Number (855) 403-3852
  • Built by Pulte Homes
  • Irvington Dist. Subdivision, Plan 3B

Security

  • Fire and Smoke Detector
  • Fire Sprinkler System

Property Details

Home Type

Condominium

Est. Annual Taxes

$11,773

Year Built

Built in 2019 | New Construction

Lot Details

0

HOA Fees

$293 per month

Parking

2

Listing Details

  • Stories: 2
  • Year Built: 2019
  • Property Sub Type: Condominium
  • Prop. Type: Residential
  • Subdivision Name: IRVINGTON DIST.
  • Directions: From 680 x/Washington, cont./Fremont, R/Chapel
  • Architectural Style: Contemporary
  • Building Name: Not Listed
  • Carport Y N: No
  • Entry Level: 1
  • Garage Yn: Yes
  • Unit Levels: Two Story, Two
  • New Construction: Yes
  • Efficiency: Low E Glass, Walls Insulated
  • Green Power: Solar
  • ResoPropertyType: Residential
  • ResoBuildingAreaSource: Builder
  • Special Features: NewHome

Interior Features

  • Flooring: Carpet, Laminate, Tile
  • Appliances: Dishwasher, Disposal, Gas Range, Plumbed For Ice Maker, Microwave, Refrigerator, Dryer, Washer, Tankless Water Heater
  • Accessibility Features: None
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Fireplace Features: None
  • Fireplace: No
  • Interior Amenities: Bonus/Plus Room, Counter - Solid Surface, Kitchen Island, Smart Home, Smart Thermostat
  • Window Features: Double Pane Windows
  • Room Kitchen Features: Counter - Solid Surface, Dishwasher, Garbage Disposal, Gas Range/Cooktop, Ice Maker Hookup, Island, Microwave, Refrigerator

Exterior Features

  • Roof: Shingle
  • Lot Features: Other
  • Pool Features: None
  • Pool Private: No
  • Builder Name: Pulte Homes
  • Construction Type: Stucco
  • Exterior Features: Unit Faces Common Area
  • Foundation Details: Slab
  • Property Condition: New Construction

Garage/Parking

  • Garage Spaces: 2
  • Attached Garage: Yes
  • Covered Parking Spaces: 2
  • Parking Features: Attached, Garage, Enclosed, Garage Door Opener

Utilities

  • Heating: Natural Gas
  • Cooling: Zoned
  • Laundry Features: Dryer, Washer
  • Security: Fire Alarm, Fire Sprinkler System
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: Photovoltaics Third-Party Owned
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Amenities: Playground
  • Association Fee: 293
  • Association Fee Frequency: Monthly
  • Association Name: VINTAGE HOA
  • Phone: 855-403-3852
  • Association: Yes
  • ResoAssociationFeeFrequency: Monthly

Fee Information

  • Association Fee Includes: Common Area Maint, Exterior Maintenance, Hazard Insurance, Management Fee, Other, Reserves

Schools

  • Senior High School District: Fremont (510) 657-2350

Green Features

  • Green Water Conservation: Low Flow Toilet

Lot Info

  • ResoLotSizeUnits: Acres

Multi Family

  • Number Of Units In Community: 67

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Nov 30, 2022
Sold by
Chopra Mayank and Chopra Divya
Bought by
Chopra Living Trust
Total Days on Market
85
Current Estimated Value
$1,317,855

Purchase Details

Listed on
Aug 14, 2019
Closed on
Dec 13, 2019
Sold by
Pulte Home Company Llc
Bought by
Chopra Mayank and Guttula Divya
Seller's Agent
Suzie Gibbons
Pulte Group
Buyer's Agent
Shoaib Mahmud
List Price
$994,990
Sold Price
$915,000
Premium/Discount to List
-$79,990
-8.04%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.59%
Original Mortgage
$732,000
Interest Rate
2.75%
Mortgage Type
New Conventional
Source: Public Records

Similar Homes in the area

  • 40742 Greystone Terrace Unit 14, Fremont, CA 94538

    $1,189,000

    • 3 Beds
    • 3 Baths
    • 1,292 Sq Ft
    • 40742 Greystone Terrace
    • Unit 14
    • Fremont, CA

    Move-in-ready tri-level Townhome style unit in Fremont’s coveted Irvington District delivers 1,292 sqft of stylish living with 3 bedrooms and 3 full baths, highlighted by an open-concept living and dining level adjoining an upgraded kitchen with brand-new stainless-steel appliances, granite countertops, handsome cabinetry, updated lighting and laminate flooring throughout; upstairs you’ll find a

    Anil Reddy Patimidi eXp Realty of California

    Section Image
  • 40742 Greystone Terrace Unit 14, Fremont, CA 94538

    $1,199,999

    • 3 Beds
    • 3 Baths
    • 1,292 Sq Ft
    • 40742 Greystone Terrace
    • Unit 14
    • Fremont, CA

    Move-in-ready tri-level Townhome style unit in Fremont’s coveted Irvington District delivers 1,292 sqft of stylish living with 3 bedrooms and 3 full baths, highlighted by an open-concept living and dining level adjoining an upgraded kitchen with brand-new stainless-steel appliances, granite countertops, handsome cabinetry, updated lighting and laminate flooring throughout; upstairs you’ll find a

    Anil Reddy Patimidi eXp Realty of California

    Section Image
  • 5681 Pandorea Terrace, Newark, CA 94560

    $1,049,999

    • 3 Beds
    • 3 Baths
    • 1,503 Sq Ft
    • 5681 Pandorea Terrace
    • Newark, CA

    Welcome to this stunning townhome-style residence located in the secure, gated community of PRIMA in Newark. This spacious 3-bedroom, 3-bath unit offers an abundance of natural light through its many windows and boasts a bright, open floor plan with soaring ceilings throughout. Enjoy the warmth and elegance of brand-new hardwood flooring, an oversized modern kitchen with a large center island,

    Amanda Lau eXp Realty of California

    Section Image
  • 3858 Development Terrace Unit 1005, Fremont, CA 94538

    $1,049,000

    • 2 Beds
    • 2.5 Baths
    • 1,326 Sq Ft
    • 3858 Development Terrace
    • Unit 1005
    • Fremont, CA

    HIGHLY DESIRABLE END UNIT CONDO! COMMUTERS PARADISE! This smart, well-maintained, 2-bedroom, 2.5-bath condo is bright & cheery with a central AC & Ring security system, located close enough to the clubhouse and pool, and is a block from Lila Bringhurst Elementary. The open kitchen on the second floor has a large island, white cabinets, granite countertops, stainless steel GE appliances, and opens

    Basanthi V Bhat Bay Zone Realtors, Inc.

    Section Image
  • 45009 Challenge Common Unit 202, Fremont, CA 94538

    $1,149,000

    • 3 Beds
    • 2 Baths
    • 1,528 Sq Ft
    • 45009 Challenge Common
    • Unit 202
    • Fremont, CA

    Don't miss out on this incredible opportunity to own a stunning condo in the Innovation community! Built by Shea Home in 2020, features open floor plan that connects the bright and modern kitchen, dining area, family room with balcony. The seller invested $30K in premium upgrades, enhancing the home's appeal and value. The attached 2-car garage with solar + EV charger! It's conveniently located

    Kiki Zhou Forerunner RE Investment

    Section Image
  • 45049 Challenge Common Unit 203, Fremont, CA 94538

    $1,110,000

    • 3 Beds
    • 2 Baths
    • 1,479 Sq Ft
    • 45049 Challenge Common
    • Unit 203
    • Fremont, CA

    Welcome to 45049 Challenge Common #203 - a spacious and spectacular 3-bedroom, 2-bathroom condo which was built with an abundance of custom upgrades and has 1,479 sqft of living space, built in 2021. This nearly new home features an open floor plan that seamlessly connects the living, dining, and kitchen areas, perfect for both entertaining and everyday living. The kitchen offers quartz

    Alex Lehr Guide Real Estate

    Section Image
  • 3819 Improvement Terrace Unit 1006, Fremont, CA 94538

    $1,299,999

    • 3 Beds
    • 3.5 Baths
    • 1,780 Sq Ft
    • 3819 Improvement Terrace
    • Unit 1006
    • Fremont, CA

    Stunning 3BR/3.5BA, 1,780 sqft modern condo built in 2020, located in a highly desirable Fremont community with a clubhouse, swimming pool, and beautifully landscaped grounds. This bright and spacious home features durable vinyl flooring in living areas, premium carpet in bedrooms, and elegantly upgraded bathrooms. The open-concept layout includes a gourmet kitchen with manufactured stone

    Azad Aramandla Keller Williams Realty

    Section Image
  • 45158 Tom Blalock St Unit 106, Fremont, CA 94539

    $1,189,000

    • 2 Beds
    • 2 Baths
    • 1,688 Sq Ft
    • 45158 Tom Blalock St
    • Unit 106
    • Fremont, CA

    Welcome to this expansive 1608 sqft. single-level urban oasis, epitomizing elegant, low-maintenance living at its finest! This luxurious 2-bedroom, 2 bathroom unit features a secure entrance and an open-concept layout with 10' ceilings and top-of-the-line upgrades. The chef's eat-in kitchen boasts premium stainless-steel appliances and an oversized 9 ft. island, surrounded by ample cabinetry,

    Kamini Patel

    Section Image
  • 45188 Tom Blalock St Unit 109, Fremont, CA 94539

    $1,345,999

    • 3 Beds
    • 2 Baths
    • 1,891 Sq Ft
    • 45188 Tom Blalock St
    • Unit 109
    • Fremont, CA

    Welcome to Metro Crossing, featuring a condominium with an attached two-car garage and EV charger. This unit offers 3 bedrooms, 2 bathrooms, 1,891 square feet of living space, high ceilings, and an additional room off the garage suitable for an office. The kitchen includes stainless steel appliances, quartz countertops with a tiled backsplash, a pantry, a large waterfall island with storage, and

    Surinder Gill Compass

    Section Image

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
Chopra Living Trust -- --
Chopra Mayank $915,000 First American Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Guttula Divya $722,761
Previous Owner Chopra Mayank $732,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/04/2025 02/04/25 Off Market $915,000 -- --
01/14/2020 01/14/20 Sold $915,000 -6.2% $532 / Sq Ft
11/07/2019 11/07/19 Pending -- -- --
10/09/2019 10/09/19 Price Changed $974,990 -2.0% $567 / Sq Ft
08/14/2019 08/14/19 For Sale $994,990 -- $578 / Sq Ft
Source: Bay East 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
2024 $11,773 $974,053 $294,852 $686,201
2023 $11,463 $961,819 $289,071 $672,748
2022 $11,324 $935,962 $283,404 $659,558
2021 $11,026 $917,479 $277,849 $646,630
2020 $11,473 $938,097 $358,097 $580,000
2019 $5,412 $417,075 $351,075 $66,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Bay East Association of REALTORS®

MLS Number: 40878288

Bay East Association of REALTORS®

APN: 525-1689-041-00