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,750 SqFt ($545/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 Hayward Highlands

* Sale Pending *

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, featurng 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 backd rop 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 big 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 modern 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: Pending
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

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: 2750
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

Click Thumbnail Images To View Full Size
house_viewhouse_viewunknownunknownunknown
unknownkitchenunknownliving_roomliving_room
living_roomunknownkitchenkitchenkitchen
kitchenkitchenbedroombedroomunknown
bathroomkitchenunknownunknownunknown
bedroombedroombathroombedroombedroom
bathroombathroomliving_roomliving_roomunknown
porchhouse_viewhouse_viewhouse_viewunknown
unknownunknownunknownunknownunknown
unknownunknownunknown

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.