Associate Ted  Dehesa image
  1. Ted Dehesa, Broker,REALTOR®
  2. San Diego Realty & Mortgage Company
  3. Serving San Diego & South Riverside Counties-CA BRE #01057261
  4. Office: 858.382.9971
  5. Fax: 858.748.9526
  6. teddydehesa@yahoo.com
51650 Avenida Bermudas, La Quinta, CA 92253
  • MLS#: 219002999DA ( Single Family )
  • Street Address: 51650 Avenida Bermudas
  • Viewed: 133
  • Price: $545,000
  • Price sqft: $229
  • Waterfront: No
  • Year Built: 1941
  • Bldg sqft: 2375
  • Bedrooms: 5
  • Total Baths: 2
  • Full Baths: 2
  • Garage / Parking Spaces: 6
  • Days On Market: 671
  • Additional Information
  • County: RIVERSIDE
  • City: La Quinta
  • Zipcode: 92253
  • Subdivision: Not Applicable 1
  • District: Desert Sands Unified
  • Provided by: HomeSmart Professionals
  • California Regional MLS IDX
  • DMCA Notice
  • Description
    WORK LIVE PLAY in this MIXED USE property governed by Village Commercial Codes in Old Town La Quinta. Built in 1941 and quite unique in its characteristics, the VC permitted uses from the City of LQ allow for myriad choices of essential day to day neighborhood goods and services, tourism and visitor based retail and entertainment opportunities and the facilities necessary for the operational demands of such uses. With a fireplace in one of the bedrooms/offices, outside private stairs providing access to upstairs, inside winding hallway staircase, this property has it all (Square footage did not autofill; buyer to confirm square footage.) Must comply with Village Codes (Cannot be used as a single family residence unless other retail/commercial is on site as well and additional sf is added.) Please send attached PEAD to Listing Agent before entering property. Thank you.
Property Location and Similar Properties

Request More Information
  • All fields are required.
Contact Ted Dehesa

Contacting Ted Dehesa
  • All fields are required.
Schedule A Showing

Schedule a Showing.
  • All fields are required.
Check this box to Register with us:
Features
Carport Spaces
  1. 0.00
Cooling
  1. Central Air
Days On Market
  1. 1495
Fireplace Features
  1. See Remarks
Flooring
  1. Laminate
Garage Spaces
  1. 0.00
Heating
  1. Central
  2. Fireplace(s)
Inclusions
  1. Refrigerator
  2. stove
Levels
  1. Two
Lockboxtype
  1. Supra
Lot Features
  1. Sprinkler System
  2. Sprinklers Timer
Parcel Number
  1. 770182003
Parking Features
  1. Driveway
  2. Street
Photo Count
  1. 39
Postalcodeplus4
  1. 6108
Property Type
  1. Single Family
Rvparkingdimensions
  1. 0x0
School District
  1. Desert Sands Unified
Subdivision Name Other
  1. Not Applicable-313 ()
Uncovered Spaces
  1. 6.00
View
  1. Mountain(s)
Views
  1. 133
Virtual Tour Url
  1. http://www.cpgtours.com/tour.php?br=0&id=42635
Year Built
  1. 1941
Year Built Source
  1. Assessor
 Associate Ted  Dehesa image
  1. Ted Dehesa, Broker,REALTOR®
  2. San Diego Realty & Mortgage Company
  3. Serving San Diego & South Riverside Counties-CA BRE #01057261
  4. Office: 858.382.9971
  5. Fax: 858.748.9526
  6. teddydehesa@yahoo.com