$2,199,999
2,164
SQ FT
$1,017
SQ/FT
4688 Wildwood Park Ct
@ Mayfair Park ave - Not Listed, Fremont
- 4 Bed
- 2 Bath
- 2 Park
- 2,164 sqft
- Fremont
-
Tucked away in a private cul de sac with stunning views, this fully remodeled modern luxury home delivers the perfect blend of style, comfort, and functionality. Designed with no expense spared, the home features Taj Mahal quartzite countertops, European style cabinetry, engineered hardwood floors, top of the line stainless steel appliances, and high end designer finishes throughout. The open concept layout is filled with natural light and ideal for both entertaining and everyday living. Major upgrades include a brand new Bosch HVAC system, brand new roof, and fully permitted renovations for added peace of mind. Step outside to an expansive backyard with incredible ADU potential. The oversized corner lot offers easy side access, extra privacy, and endless possibilities for a guest house, rental unit, home office, or multigenerational living. Conveniently located near parks, shopping, dining, commuter routes, and highly rated Irvington High School, this move in ready property offers luxury living today with future income potential tomorrow. Step outside to an expansive backyard with incredible ADU potential. The oversized corner lot offers easy side access, extra privacy, and endless possibilities for a guest house, rental unit, home office, or multigenerational living. Conveniently located near parks, shopping, dining, and commuter routes, this move in ready property offers luxury living today with future income potential tomorrow.
- Current Status
- New
- Original Price
- $2,199,999
- List Price
- $2,199,999
- On Market Date
- May 6, 2026
- Property Type
- Detached
- D/N/S
- Not Listed
- Zip Code
- 94538
- MLS ID
- 41133617
- APN
- Year Built
- 2026
- Stories in Building
- 1
- Possession
- Close Of Escrow
- Data Source
- MAXEBRDI
- Origin MLS System
- BAY EAST
Robertson High (Continuation) School
Public 9-12 Continuation
Students: 176 Distance: 0.2mi
Vista Alternative School
Public 7-12 Alternative
Students: 34 Distance: 0.2mi
Harvey Green Elementary School
Public K-6 Elementary
Students: 517 Distance: 0.3mi
Irvington High School
Public 9-12 Secondary
Students: 2294 Distance: 0.6mi
Steven Millard Elementary School
Public K-6 Elementary
Students: 577 Distance: 0.6mi
E. M. Grimmer Elementary School
Public K-6 Elementary
Students: 481 Distance: 0.7mi
- Bed
- 4
- Bath
- 2
- Parking
- 2
- Attached
- SQ FT
- 2,164
- SQ FT Source
- Public Records
- Lot SQ FT
- 9,694.0
- Lot Acres
- 0.22 Acres
- Pool Info
- Other
- Kitchen
- Microwave, Range, Refrigerator, Kitchen Island, Range/Oven Built-in, Updated Kitchen
- Cooling
- Central Air, Other
- Disclosures
- Other - Call/See Agent
- Entry Level
- Exterior Details
- Back Yard, Front Yard
- Flooring
- Hardwood
- Foundation
- Fire Place
- Electric
- Heating
- Forced Air
- Laundry
- 220 Volt Outlet, Hookups Only, Other
- Main Level
- 4 Bedrooms, 2 Baths
- Views
- Hills
- Possession
- Close Of Escrow
- Basement
- Crawl Space
- Architectural Style
- Ranch, Modern/High Tech
- Non-Master Bathroom Includes
- Bidet, Stall Shower, Tile
- Additional Miscellaneous Features
- Back Yard, Front Yard
- Location
- Cul-De-Sac
- Roof
- Other
- Water and Sewer
- Public
- Fee
- Unavailable
MLS and other Information regarding properties for sale as shown in Theo have been obtained from various sources such as sellers, public records, agents and other third parties. This information may relate to the condition of the property, permitted or unpermitted uses, zoning, square footage, lot size/acreage or other matters affecting value or desirability. Unless otherwise indicated in writing, neither brokers, agents nor Theo have verified, or will verify, such information. If any such information is important to buyer in determining whether to buy, the price to pay or intended use of the property, buyer is urged to conduct their own investigation with qualified professionals, satisfy themselves with respect to that information, and to rely solely on the results of that investigation.
School data provided by GreatSchools. School service boundaries are intended to be used as reference only. To verify enrollment eligibility for a property, contact the school directly.

