- 0
- 4
- Overview
- Description
- Property Details
- Location
- HOA Management
- Facts & Features
- Getting Around
- Nearby Homes
Street View
Listed by: Randy A. Wright (310) 927-6818 DRE #01410916 | Christie's International Real Estate SoCal (424) 249-7162
$1,750,000
Monthly Est:$8,710
3 Beds
4 Baths3 full baths + 1 half bath
4,541sqft
402 Herradura, Warren, MI 48312
$1,750,000
$8,710/moEst:
Get Pre-Approved
Condominium
Built in -
$1,836/mo HOA
-- sqft lot
$385/sq.ft
Description
Epic Puerto Vallarta, Mexico Remodeled Oceanfront Masterpiece. Steps from Los Muertos Beach, Puerto Vallarta's Most Celebrated Shore. Life doesn't get better than this. Perched just steps above Los Muertos Beach in the heart of Puerto Vallarta's iconic Romantic Zone, this stunning remodeled oceanfront home delivers jetliner views of the Pacific and the effortless indoor-outdoor lifestyle you've always imagined. Step inside and be immediately captivated by soaring high-volume ceilings and a dramatic floor-to-ceiling wall of glass that frames unobstructed ocean views from every angle. The open-concept living and dining area flows seamlessly onto a sprawling entertainer's de...
Continue Reading- Houzeo last checked: 13 minutes ago
- Listing updated: June 18, 2026 at 11:43 pm
- Source: California Regional MLS-CA | MLS#: 26753523
Part of
Property Details
Status
Active
Type
Condominium
No. of Stories
4
County
City
Neighborhood
--
Year Built
-
HOA Fees
$1836/mo
Finished Area
4,541 sqft
Lot Size
-- sqft lot
Basement Area
- sqft
MLS Name
California Regional MLS
MLS Number
26753523
MLS Status
Active
Days on Market
152
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
HOA Management
N/A
HOA Fees
$1,836/ Monthly
Amenities
Amenities and services may be covered by one or multiple associations and service providers.
Gas
Maintenance
Pool
Insurance
Spa
Electricity
Water
Security Guard
Disclaimer: Amenities are based on third-party information and may vary; buyers must independently verify all amenities, as information is deemed reliable but not guaranteed.
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 3
Bathrooms: 4
Interior
Window Features
Blinds, Skylights
Interior Features
Ceiling Fans, Separate Formal Dining Room, Furnished, Walk In Closets
Sewer
Other
Heating
None
Appliances
Barbecue, Disposal, Microwave, Refrigerator, Dryer, Washer
Construction
Year Built
-
Home type
Condominium
Property Condition
Updated Remodeled
Utilities & Energy
Association Amenities
Electricity, Gas, Maintenance Grounds, Insurance, Pool, Spa Hot Tub, Security, Water
Fireplace Features
None
Parking Features
Community Structure
Laundry Features
Laundry Closet
Security Features
Security Gate, Gated Community, Twenty Four Hour Security, Smoke Detectors
Pool Features
Community, Tile, Association
Other Features
Community Features
Gated, Pool
Price History
| Date | Event | Price |
|---|---|---|
05/06/2026 Source: | Price Decreased | $1,995,500 -11.31% $439/sqft |
04/20/2026 Source: | Price Increased | $2,250,000 +28.57% $495/sqft |
04/20/2026 Source: | Price Decreased | $1,750,000 -12.30% $385/sqft |
04/20/2026 Source: | Listed for Sale | $1,995,500 $439/sqft |
Nearby Homes
Find Homes by Property Features in Warren, MI
Based on information from California Regional Multiple Listing Service, Inc. as of Sep 19, 2026, 04:00PM and /or other sources. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information being provided is for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. © 2026 California Regional Multiple Listing Service. All Rights Reserved.
Advertising Broker: William Johnson DRE #01463271 | William Johnson Brokerage
Love this home?
Here's 4 things you can do
Your local real estate expert. Speak directly with agent about the home & pricing.
Book your private tour
as early as Today at 02:30 PM
Rates starting from 6.3%. Secure financing early to move quickly when you're ready.
Fastest way to get your offer in. Speak directly with agent to negotiate the offer.
Houzeo Corp. holds real estate brokerage licenses in Alabama (License No. 000157023 - 0) and Texas (License No. 9013396)
TREC: Info About Brokerage Services, Consumer Protection Notice.
§ 442‑H New York Standard Operating Procedure.
New York State Fair Housing Notice.
