Seller's Agent in 2023
David Troyer
Intero Real Estate Services
(650) 440-5076
16 in this area
339 Total Sales
420 Mansfield Dr Mountain View, CA 94040
Estimated Value: $4,910,000 - $5,371,000
3
Beds
3.5
Baths
3,046
Sq Ft
$1,682/Sq Ft
Est. Value
Highlights
- In Ground Pool
- Primary Bedroom Suite
- Soaking Tub in Primary Bathroom
- Amy Imai Elementary School Rated A
- Fireplace in Primary Bedroom
- Wood Flooring
About This Home
As of June 2023From start to finish, this home boasts custom finishes, spacious rooms, soaring ceilings, rich hardwood floors, expansive glass windows and doors. The home centers around the fabulous great room with extended-height ceilings, a fireplace, built-ins, a casual dining room, the gourmet kitchen with top-of-the-line appliances, and a light-filled formal dining room. The palatial primary suite has a large sitting room or office and a luxurious marble-appointed spa bath. A light-filled bedroom sits off the foyer, and an additional bedroom suite overlooks the front yard. Perfect for guests or recreation, a detached casita has a lovely covered patio, fireplace, and full bath. The resort-style backyard has been expertly designed to include a sparkling pool and elevated spa, pergola-covered entertaining patio, a fire pit patio set amongst the gardens, a lush side patio with water features, and a barbecue center with an adjacent bocce ball court. One of the largest lots in the development!
Last Agent to Sell the Property
Intero Real Estate Services License #01234450 Listed on: 05/25/2023
Home Details
Home Type
- Single Family
Year Built
- Built in 2011
Lot Details
- 10,642 Sq Ft Lot
- Fenced
- Back Yard
HOA Fees
- $60 Monthly HOA Fees
Parking
- 2 Car Attached Garage
- Garage Door Opener
- Off-Street Parking
Home Design
- Slab Foundation
- Concrete Roof
Interior Spaces
- 3,046 Sq Ft Home
- 1-Story Property
- High Ceiling
- Two Way Fireplace
- Gas Fireplace
- Formal Entry
- Living Room with Fireplace
- 3 Fireplaces
- Formal Dining Room
Kitchen
- Breakfast Bar
- Built-In Oven
- Gas Cooktop
- Range Hood
- Dishwasher
- Kitchen Island
- Granite Countertops
Flooring
- Wood
- Tile
Bedrooms and Bathrooms
- 3 Bedrooms
- Fireplace in Primary Bedroom
- Primary Bedroom Suite
- Walk-In Closet
- Marble Bathroom Countertops
- Dual Sinks
- Soaking Tub in Primary Bathroom
- Bathtub with Shower
- Oversized Bathtub in Primary Bathroom
- Walk-in Shower
Laundry
- Laundry Room
- Washer and Dryer
Pool
- In Ground Pool
- Spa
Outdoor Features
- Balcony
- Fire Pit
- Barbecue Area
Additional Features
- 258 SF Accessory Dwelling Unit
- Forced Air Heating and Cooling System
Community Details
- Association fees include maintenance - road
- Grant Road Maintenance Assoc Association
Listing and Financial Details
- Assessor Parcel Number 197-22-053
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
May 25, 2023
Closed on
Jun 28, 2023
Sold by
Ahrens Gilbert and Ahrens Kimberly
Bought by
Altinbuken Lehmann Family Living Trust
Seller's Agent
David Troyer
Intero Real Estate Services
Buyer's Agent
Dominic Nicoli
Intero Real Estate Services
List Price
$4,398,000
Sold Price
$4,550,000
Premium/Discount to List
$152,000
3.46%
Views
118
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$562,995
Avg. Annual Appreciation
4.78%
Original Mortgage
$3,000,000
Outstanding Balance
$2,922,961
Interest Rate
6.39%
Mortgage Type
New Conventional
Estimated Equity
$2,201,807
Purchase Details
Listed on
Oct 18, 2012
Closed on
Oct 16, 2012
Sold by
Summerhill Grant Road Llc
Bought by
Ahrens Gilbert and Ahrens Kimberly
Seller's Agent
Natalie Viviani
Summerhill Brokerage, Inc.
Buyer's Agent
Abigail Ahrens
The Abigail Company
List Price
$2,342,595
Sold Price
$2,342,595
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.41%
Original Mortgage
$1,874,076
Interest Rate
2.75%
Mortgage Type
New Conventional
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
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Altinbuken Lehmann Family Living Trust | $4,550,000 | First American Title | |
| Ahrens Gilbert | $2,342,750 | First American Title Company |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Altinbuken Lehmann Family Living Trust | $3,000,000 | |
| Previous Owner | Ahrens Gilbert | $1,874,076 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 06/30/2023 06/30/23 | Sold | $4,550,000 | +3.5% | $1,494 / Sq Ft | |
| 05/31/2023 05/31/23 | Pending | -- | -- | -- | |
| 05/25/2023 05/25/23 | For Sale | $4,398,000 | +87.7% | $1,444 / Sq Ft | |
| 10/22/2012 10/22/12 | Sold | $2,342,595 | 0.0% | $804 / Sq Ft | View Prior Sale |
| 10/20/2012 10/20/12 | Pending | -- | -- | -- | |
| 10/18/2012 10/18/12 | For Sale | $2,342,595 | -- | $804 / Sq Ft |
Source: MLSListings
Tax History Compared to Growth
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 | $53,966 | $4,733,820 | $4,161,600 | $572,220 |
| 2024 | $53,966 | $4,641,000 | $4,080,000 | $561,000 |
| 2023 | $33,742 | $2,866,973 | $1,574,198 | $1,292,775 |
| 2022 | $33,653 | $2,810,759 | $1,543,332 | $1,267,427 |
| 2021 | $32,825 | $2,755,647 | $1,513,071 | $1,242,576 |
| 2020 | $32,872 | $2,727,392 | $1,497,557 | $1,229,835 |
| 2019 | $31,469 | $2,673,915 | $1,468,194 | $1,205,721 |
| 2018 | $31,111 | $2,621,486 | $1,439,406 | $1,182,080 |
| 2017 | $29,808 | $2,570,085 | $1,411,183 | $1,158,902 |
| 2016 | $29,182 | $2,519,692 | $1,383,513 | $1,136,179 |
| 2015 | $28,338 | $2,481,845 | $1,362,732 | $1,119,113 |
| 2014 | $28,076 | $2,433,230 | $1,336,038 | $1,097,192 |
Source: Public Records
Agents Affiliated with this Home
-
David Troyer
-
Dominic Nicoli
Buyer's Agent in 2023
Dominic Nicoli
Intero Real Estate Services
(408) 892-3122
1 in this area
146 Total Sales
-
Thomas Tognoli
Buyer Co-Listing Agent in 2023
Thomas Tognoli
Intero Real Estate Services
(408) 807-8185
1 in this area
34 Total Sales
-
Natalie Viviani
N
Seller's Agent in 2012
Natalie Viviani
Summerhill Brokerage, Inc.
(650) 533-5752
1 in this area
23 Total Sales
-
Abigail Ahrens
Buyer's Agent in 2012
Abigail Ahrens
The Abigail Company
(650) 303-6773
1 in this area
19 Total Sales
Map
Source: MLSListings
MLS Number: ML81929549
APN: 197-22-053
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Property Information © 2025 MLSListings Inc. All rights reserved. Listing information is deemed reliable but not guaranteed. Certain information contained herein is derived from information which is the licensed property of, and copyrighted by, MLSListings Inc. The viewer acknowledges ownership and validity of its copyright. Information provided is for personal, non-commercial use by a viewer with a bona fide interest in the purchase or sale of real estate of the type being offered via this website or other electronic means. The viewer is prohibited from copying, redistributing or retransmitting any of the data or information provided by MLSListing, Inc.
Nearby Homes
- 1225 Altamead Dr
- 3575 Wellesley Ct
- 1280 Grant Rd
- 999 Hayman Place
- 800 Rebecca Privada
- 1440 Oakhurst Ave
- 191 E El Camino Real Unit 138
- 915 Berry Ave
- 1021 Golf Ct
- 1033 Crestview Dr Unit 207
- 1033 Crestview Dr Unit 216
- 894 Grape Ave
- 829 Moraga Dr
- 1677 Middleton Ave
- 1264 Brookings Ln
- 1276 Montclaire Way
- 717 Ehrhorn Ave
- 457 Carneros Ave
- 1122 Vasquez Ave
- 1007 Blair Ave