Contact Kim Barron
Contacting Kim Barron
  • All fields are required.
Schedule A Showing
Schedule a Showing.
  • All fields are required.
Check this box to Register with us:
Request more information
  • MLS#: 219144315DA ( Single Family Residence )
  • Street Address: 41905 Trent Place
  • Viewed: 2
  • Price: $710,000
  • Price sqft: $258
  • Waterfront: Yes
  • Wateraccess: Yes
  • Year Built: 2004
  • Bldg sqft: 2751
  • Bedrooms: 4
  • Total Baths: 3
  • Full Baths: 3
  • Garage / Parking Spaces: 4
  • Days On Market: 16
  • Additional Information
  • County: RIVERSIDE
  • City: Indio
  • Zipcode: 92203
  • Subdivision: Generations
  • District: Desert Sands Unified
  • High School: SHAHIL
  • Provided by: Bennion Deville Homes
  • Contact: Rosalie Rosalie
  • California Regional MLS IDX
  • DMCA Notice
  • Description
    ''Welcome to Generations your private desert Oasis.This 2,751 Sq ft single story masterpiece, built in 2004, offers 4 bedrooms and 3 baths on a generous 9,583 Sq ft lot. One of the first finest communities in Shadow Hills with no Mello Roos taxes. First time ever on market! Original Owners.Move In Ready with thoughtful furnishings in place,optional for the right buyer. Rare west facing views capture breathtaking mountain sunsets over a private, wash lined 'park' setting peaceful, private and truly one of a kind.Out back: A stunning 33 foot saltwater Pebble Tech pool and spa, with two waterfalls edged by natural boulders your ultimate desert sanctuary. The built in barbecue station invites effortless evenings with friends & entertaining.While your citrus orchard gifts fresh oranges, tangelos, grapefruit, and lemons.Inside: An open airy layout with a chef's delight kitchen,Quartz countertops & elegant 17 inch tile paired with rich engineered wood floors, and many custom upgrades everywhere you look. The master suite is pure luxury with a fully remodeled spa shower, oversized tub, and a custom built closet that spoils you. Dual paned tinted windows, lush mature landscaping, textured concrete driveway, and soft outdoor lighting tie it all together with every detail done right..This is truly a desert paradise. Conveniently located just minutes from the City of Festivals: Coachella, Stagecoach, National Date Festival, you're in the heart of it all without the noise. Literarily close to it all from golf, concerts, shopping & Dinning. Perfect for those looking for a vacation home here in the desert or everyday desert lifestyle living.Once you step inside this house, you'll know. This is home. If you've been holding off for the perfect one, a quiet, loaded, no tax headaches then this is it!Come see it. Call today.
Request More Information
  • All fields are required.
Features
Appliances
  1. Gas Cooktop
  2. Refrigerator
  3. Gas Oven
  4. Dishwasher
Association Amenities
  1. Pet Rules
  2. Management
  3. Security
  4. Maintenance Grounds
Association Fee
  1. 142.00
Association Fee Frequency
  1. Monthly
Carport Spaces
  1. 0.00
Cooling
  1. Gas
  2. Central Air
Country
  1. US
Eating Area
  1. In Living Room
  2. Breakfast Counter / Bar
  3. Dining Room
Electric
  1. 220 Volts in Garage
  2. 220 Volts
Exclusions
  1. All personal Items. All Furnishings are negotiable
  2. if interested as turn key ready or if not will be removed by closing date. A list of furnishings will be provided upon request.
Fencing
  1. Block
Fireplace Features
  1. Gas
  2. Living Room
Flooring
  1. Tile
  2. Wood
Garage Spaces
  1. 2.00
Heating
  1. Fireplace(s)
  2. Central
High School
  1. SHAHIL
Highschool
  1. Shadow Hills
Inclusions
  1. All Furnishings are negotiable as turn key ready if desired
  2. if not will be removed from property by closing date. A list of furnishings will be provided upon request. * All Kitchen appliances will stay with property.
Interior Features
  1. Furnished
  2. Block Walls
  3. High Ceilings
  4. Recessed Lighting
  5. Open Floorplan
  6. Wired for Sound
Laundry Features
  1. Individual Room
Living Area Source
  1. Assessor
Lockboxtype
  1. Supra
Lot Features
  1. Landscaped
  2. Level
  3. Sprinklers Timer
  4. Park Nearby
  5. Front Yard
  6. Sprinkler System
  7. Back Yard
Parcel Number
  1. 692210011
Parking Features
  1. Permit Required
  2. Driveway
  3. Garage Door Opener
  4. Street
Patio And Porch Features
  1. Covered
  2. Concrete
Pool Features
  1. In Ground
  2. Pebble
  3. Waterfall
  4. Private
  5. Electric Heat
  6. Salt Water
Postalcodeplus4
  1. 3170
Property Type
  1. Single Family Residence
Property Condition
  1. Updated/Remodeled
Roof
  1. Tile
School District
  1. Desert Sands Unified
Security Features
  1. Card/Code Access
  2. Closed Circuit Camera(s)
  3. Wired for Alarm System
  4. Security Lights
  5. Gated Community
Spa Features
  1. In Ground
  2. Heated
Subdivision Name Other
  1. Generations
Uncovered Spaces
  1. 2.00
Utilities
  1. Cable Available
View
  1. Mountain(s)
  2. Orchard
  3. Pool
Window Features
  1. Double Pane Windows
  2. Drapes
  3. Screens
  4. Blinds
Year Built
  1. 2004
Year Built Source
  1. Assessor
Zoning
  1. R-1