Please stand by!
USDAProperties.com is verifying property eligibility...

 

 

 

$1,499,999   Price Analysis
USDAProperties Agent Contact Page  Agent Details  share icon     map icon  QR
28004 Whitestone Ct
Hayward, CA 94542
4 bed 4 bath 2,724 SqFt ($550/SqFt)
9,256SqFt lot. Built 1969
Listed 2024-06-12, Taxes $8,254
Ⓧ USDA Ineligible
due to price & location

near Hayward

Welcome to this luxurious contemporary retreat in the prestigious Haywa rd Highlands

* No Longer For Sale *
Your browser will attempt to redirect you to the city level in a few seconds.

Where panoramic Bay and canyon views await you. This meticulously renovated home harmoniously blends modern elegance with comfortable living. The heart of the residence is the state-of-the-art chef's kitchen, featuring a Thermador refrigerator with wine chiller, Monogram collection stove, microwave, dishwasher, as well as a convenient pot filler. A stunning 9-foot bi-fold window opens onto the front deck, offering spectacular Bay views. Designed for those who love to entertain, the home's fluid indoor-outdoor flow creates an ideal space for gatherings.

The 6-foot sliding glass door leads from the living room to a sprawling deck, set against the backdrop of multi-level entertaining areas in the backyard. With the main primary suite upstairs, this versatile layout also includes a potential fifth bedroom across the hall. The primary suite upstairs is a true sanctuary, featuring an oversized bathroom with a walk-in shower and a open walk-in closet. Downstairs, you will find another primary suite and two guest bedrooms, each with beautifully updated bathrooms. Plus a large family room leading out to the lower level backyard. Come experience the ultimate in mdern living.


Presented by Kerissa Calvo at
Fohl Realty & Investments.
Listing Agent Photo

Property MLS #41062870 from BayEast

Bedrooms: 4

Total Rooms: 7

Dishwasher
Double Oven
Gas Range
Microwave
Refrigerator
Gas Water Heater
Laundry Features: In Garage

Cooling Features: Central Air
Fireplace Features: Living Room
Heating Features: Forced Air
Heating: Yes
Number of Fireplaces: 1

Full Bathrooms: 3
1/2 Bathrooms: 1

Flooring: Hardwood, Tile, Carpet

Back Yard
Front Yard
Side Yard
Landscape Back
Landscape Front

Lot Description: Corner Lot
Lot Size Acres: 0.2124885
Lot Size Square Feet: 9256

Garage Spaces: 2
Parking Features: Attached, Int Access From Garage, Garage Door Opener

Calculated Total Monthly Association Fees: 0

Source Listing Status: Closed
County: Alameda
Cross Street: Round Hill Dr
Directions: Hayward Blvd>Farm Hill Dr>Round Hill Dr>Whitestone
Source Property Type: Residential
Source Neighborhood: Highlands
Parcel Number: 81D190250
Subdivision: Highlands
Property Subtype: Detached
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$468,978 + $200,990
$669,968
$8,254
2021$459,786 + $197,051
$656,837
$8,186
2020$455,073 + $195,031
$650,104
$8,094
2019$446,153 + $191,208
$637,361
$8,160
2018$437,408 + $187,460
$624,868
$7,651
2017$428,833 + $183,785
$612,618
$7,471
2016$420,425 + $180,182
$600,607
$7,051
2015$414,111 + $177,476
$591,587
$6,907
2014$406,000 + $174,000
$580,000
$6,554
2013$413,000 + $177,000
$590,000
$6,717
2012$364,000 + $156,000
$520,000
$5,963
2010$392,000 + $168,000
$560,000
$5,699
2009$350,000 + $150,000
$500,000
$6,784
2008$546,000 + $234,000
$780,000
$8,766
2007$510,000 + $382,500
$892,500
$9,412

Sold 2024-07-22
$1,750,000
BayEast
Listed 2024-06-12
$1,499,999
BayEast
Sold 2013-07-08
$580,000
ContraCosta
Listed 2013-05-16
$565,000
ContraCosta
Sold 2005-12-15
$875,000
ContraCosta
Listing removed 2005-09-20
$898,500
ContraCosta
Listed 2005-09-06
$898,500
ContraCosta
Listing removed 2005-09-06
$899,500
ContraCosta
Listing removed 2005-09-06
$899,500
ContraCosta
Listed 2005-09-06
$898,500
ContraCosta
Listed 2005-08-21
$899,500
ContraCosta
Listed 2005-08-21
$899,500
ContraCosta

Total Square Feet Living: 2724
Year Built: 1969
Construction Materials: Stucco
Levels: One Story
Property Age: 55
Property Condition: Existing
Roof: Composition Shingles
Levels or Stories: 1
Architectural Style: Contemporary

Electric: No Solar

Stonebrae Elementary School is a public elementary school located approximately 1.1 miles away.
directions icon Map directions

Hayward High School is a public high school located approximately 2.2 miles away.
directions icon Map directions

Bret Harte Middle School is a public middle school located approximately 2.5 miles away.
directions icon Map directions

Liber Academy of Hayward is a private elementary, middle and high school located approximately 1.2 miles away.
directions icon Map directions

The property loan eligibility may be subject to additional requirements beyond geographical location including but not limited to the condition of the property. Speak with a real estate professional to find out more about the eligibility of a specific property.