Seller's Agent in 2025
Bill Sheehan
Sheehan Realty
(925) 373-7200
1 in this area
5 Total Sales
5207 Modena Ct Pleasanton, CA 94588
Stoneridge Neighborhood
2
Beds
2.5
Baths
1,365
Sq Ft
3,039
Sq Ft Lot
Highlights
- In Ground Pool
- Contemporary Architecture
- End Unit
- Donlon Elementary School Rated A
- Park or Greenbelt View
- Corner Lot
About This Home
As of May 2025Look no further. This home has all the advantages of a detached home with the benefits of a low maintenance townhome. This is a beautiful and elegant detached two-story home with two master bedrooms, 2 1/2 bathrooms, and a 2-car garage. This home has been recently painted and has newer carpets with a private landscaped patio back yard. The living room is bright and airy with windows to the private yard. There is a gas fireplace for the cool fall evenings and high ceiling to enhance the spacious living area. A low $ HOA fee provides access to the pool for those warm summer days. The kitchen is adjacent to the dining room with floor to ceiling mirror, chandelier, and lots of natural light. Upstairs the two master bedrooms have walk-in closets, separate tub/showers, individual vanities and spacious walk-in closets. This home is located in the heart of Pleasanton near top rated schools, and short distance to the BART Station, Kaiser, Ironhorse trail, Parks, Tennis Courts, Community Pools, Shopping & Restaurants. There is easy to access to 580 and 680 and a very short drive to the ACE Train. You will fall in love with this home.
Home Details
Home Type
- Single Family
Year Built
- Built in 1997
Lot Details
- 3,039 Sq Ft Lot
- Landscaped
- Corner Lot
- Paved or Partially Paved Lot
- Sprinklers Throughout Yard
- Back Yard Fenced and Front Yard
HOA Fees
- $275 Monthly HOA Fees
Parking
- 2 Car Attached Garage
- Rear-Facing Garage
- Garage Door Opener
- Guest Parking
Home Design
- Contemporary Architecture
- Concrete Foundation
- Slab Foundation
- Ceiling Insulation
- Stucco
Interior Spaces
- 2-Story Property
- Gas Fireplace
- Double Pane Windows
- Low Emissivity Windows
- Living Room with Fireplace
- Dining Area
- Park or Greenbelt Views
Kitchen
- Breakfast Area or Nook
- Eat-In Kitchen
- Gas Range
- Free-Standing Range
- Microwave
- Dishwasher
- Tile Countertops
- Disposal
Flooring
- Carpet
- Linoleum
- Concrete
- Tile
Bedrooms and Bathrooms
- 2 Bedrooms
Laundry
- Laundry in Garage
- Dryer
- Washer
Home Security
- Carbon Monoxide Detectors
- Fire and Smoke Detector
Pool
- In Ground Pool
- Gunite Pool
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- High-Efficiency Water Heater
- Gas Water Heater
Additional Features
- Level Entry For Accessibility
- Energy-Efficient Insulation
- Ground Level
Listing and Financial Details
- Assessor Parcel Number 941280570
Community Details
Overview
- Association fees include common area maintenance, management fee, ground maintenance
- Avila At Hacienda Association, Phone Number (925) 743-3080
- Siena/Hacienda Subdivision
- Greenbelt
Recreation
- Community Pool
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Apr 12, 2025
Closed on
May 15, 2025
Sold by
Family Trust Of Bernie B Tolentino And M and Tolentino Bernie B
Bought by
Swain Ranjana Kumar
Seller's Agent
Bill Sheehan
Sheehan Realty
Buyer's Agent
Bill Sheehan
Sheehan Realty
List Price
$1,000,000
Sold Price
$958,500
Premium/Discount to List
-$41,500
-4.15%
Views
17
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
$29,075
Avg. Annual Appreciation
5.20%
Original Mortgage
$766,400
Outstanding Balance
$761,602
Interest Rate
6.64%
Mortgage Type
New Conventional
Estimated Equity
$225,973
Purchase Details
Closed on
Sep 5, 2002
Sold by
Steiner James J and Steiner Deitra H
Bought by
Tolentino Bernie B and Tolentino Mary L
Purchase Details
Closed on
Apr 9, 1999
Sold by
Steiner Deitra H
Bought by
Steiner James J
Purchase Details
Closed on
Jun 17, 1997
Sold by
Signature Properties Inc
Bought by
Steiner James J and Steiner Deitra H
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$177,350
Interest Rate
7.92%
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 | Type | Sale Price | Title Company |
|---|---|---|---|
| Grant Deed | $958,000 | Old Republic Title Company | |
| Quit Claim Deed | -- | Old Republic Title Company | |
| Grant Deed | $472,500 | Fidelity National Title Co | |
| Interfamily Deed Transfer | -- | Chicago Title Co | |
| Grant Deed | $236,500 | Chicago Title Co |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $766,400 | New Conventional | |
| Previous Owner | $177,350 | No Value Available |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 05/19/2025 05/19/25 | Sold | $958,500 | -4.2% | $702 / Sq Ft |
| 04/27/2025 04/27/25 | Pending | -- | -- | -- |
| 04/12/2025 04/12/25 | For Sale | $1,000,000 | -- | $733 / Sq Ft |
Source: Bay East Association of REALTORS®
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 | $7,939 | $684,273 | $205,354 | $478,919 |
| 2024 | $7,939 | $670,860 | $201,329 | $469,531 |
| 2023 | $7,848 | $657,709 | $197,382 | $460,327 |
| 2022 | $7,436 | $644,815 | $193,513 | $451,302 |
| 2021 | $7,246 | $632,175 | $189,719 | $442,456 |
| 2020 | $7,154 | $625,697 | $187,775 | $437,922 |
| 2019 | $7,241 | $613,431 | $184,094 | $429,337 |
| 2018 | $7,095 | $601,406 | $180,485 | $420,921 |
| 2017 | $6,914 | $589,617 | $176,947 | $412,670 |
| 2016 | $6,382 | $578,060 | $173,479 | $404,581 |
| 2015 | $6,264 | $569,380 | $170,874 | $398,506 |
| 2014 | $6,376 | $558,230 | $167,528 | $390,702 |
Source: Public Records
Agents Affiliated with this Home
-
Bill Sheehan
Map
Source: Bay East Association of REALTORS®
MLS Number: 41093004
APN: 941-2805-070-00
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.
Bay East ©2025. CCAR ©2025. bridgeMLS ©2025. Information Deemed Reliable But Not Guaranteed. This information is being provided by the Bay East MLS, or CCAR MLS, or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website. This information is intended for the personal use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Nearby Homes
- 4052 Ghiotti Ct
- 4068 Ghiotti Ct
- 4251 Lucero Ct
- 5740 Belleza Dr
- 3080 Casadero Ct
- 3099 Casadero Ct
- 4832 Knox Gate Ct
- 4327 Fairlands Dr
- 6033 Ashley Ct
- 4572 Ross Gate Way
- 2474 Tanager Dr
- 5394 Arnold Rd
- 5406 Saffron Way
- 5501 De Marcus Blvd Unit 542
- 5501 De Marcus Blvd Unit 206
- 5501 De Marcus Blvd Unit 401
- 5581 Dublin Blvd
- 5422 Arnold Rd
- 5670 El Dorado Ln
- Residence 1 Plan at Gramercy at Boulevard - Boulevard - Gramercy