
Las Vegas, NV 89117
This Upgraded Multi-Generational Estate is a Strong Value Opportunity, listed at $1,400,000—positioned well below the $1,552,841 Fair Market Value by 9%. This valuation gap offers $152,841 in Instant Equity for the incoming buyer. Maintaining a Good Condition Rating, the residence features $230,000 in high-end renovations, including a detached guesthouse, onyx kitchen backsplash, and a $80,000 resort-style backyard with a redone spa. Located in a secure gated community, this property is a premier choice for Multi-Generational Families or Owner-Occupants seeking luxury with built-in wealth.
Comparables within 1 miles sold in recently
| Address | Sold Price | Beds | Baths | Sq Ft | $/Sqft | Distance |
|---|---|---|---|---|---|---|
★ 2204 Trident Maple Street Subject | $1,190,000* List Price | 4 | 5 | 3,409 | $324 | - |
A 7908 Clock Tower Court Sold | $985,000 | 5 | 5 | 3,897 | $253 | 0.6 mi |
B 8924 Echo Ridge Drive Sold | $975,000 | 3 | 3 | 2,912 | $335 | 1.0 mi |
C 7808 Foothill Ash Avenue Sold | $1,365,000 | 4 | 4 | 4,704 | $290 | 0.6 mi |
D 7808 Foothill Ash Avenue Sold | $1,365,000 | 5 | 4 | 4,704 | $290 | 0.6 mi |
E 7808 Foothill Ash Avenue Sold | $1,365,000 | 5 | 4 | 4,704 | $290 | 0.6 mi |
F 1516 Castle Wall Street Active | $1,199,888 List Price | 4 | 4 | 3,205 | $374 | 0.6 mi |
* Subject property listed price vs sold prices of comps.
Property is move-in ready.
The property is in move-in ready condition with over $230,000 in recent upgrades, including brand new wood-look tile flooring, a high-end kitchen with an onyx backsplash, and a resort-style backyard with a guesthouse. While the home was built in 1999 and some fixtures—such as the gold-framed shower and specific cabinetry styles—retain a slightly dated aesthetic, the extensive functional improvements like the whole-house reverse osmosis system and well-maintained systems justify a 'good' rating.
Over $230,000 has been invested in high-end interior and exterior renovations, including a gourmet kitchen with onyx backsplash and a whole-house reverse osmosis system.
The property features a detached 1-bedroom guesthouse and a separate living quarters with a private entrance, offering exceptional flexibility for guests or extended family.
The expansive 13,504 sq. ft. lot includes a $80,000 desert-resort oasis featuring a redone spa, built-in BBQ, and mature landscaping for ultimate privacy.
Built in 1999, some original structural components or mechanical systems may require inspection or future replacement despite the extensive cosmetic and functional upgrades.
Located within a gated community, the property is subject to association rules and fees which may restrict certain modifications or usage compared to non-governed lots.
Located in a private, gated community, 2204 Trident Maple has been substantially upgraded in all the right places. The backyard is mature, private, and established: featuring a 1br 1ba guesthouse, and is lined with palms and vibrant bougainvillea, giving it a true desert-resort feel. Over $80k was invested into the back yard, alone. The built-in BBQ includes multiple burners and a black rock grill, the spa has been completely redone, and the landscaping creates a space that is hard to duplicate at today’s costs. More than $150k in upgrades were completed inside to transform the main home, including: brand new tile flooring, custom cabinetry, onyx backsplash in the kitchen, and double built-in ovens. A recently added living quarters w/private entrance includes one bedroom and a full bath. Additional upgrades include a fully paid-off whole-house reverse osmosis water system with alkaline injection, a charcoal filtration system, epoxy garage flooring, and built-in garage cabinetry.
No exterior & parking available.
No sensitive facilities data found.
| Feature | Subject | Average Home |
|---|---|---|
| Beds | 4.0 | 0.0 |
| Baths | 5.0 | 0.0 |
| Square foot | 3,409 | - |
| Lot Size | 13,504 | - |
| Price | $1.19M | $474.8K |
| Price per sq ft | $349 | $257 |
| Built year | 1999 | 0 |
| HOA | $145 | $0 |
| Days on market | 157 | 526 |
Jul 22, 2026
$1,190,000
$1,195,000
+0% Price Increase
Initial Listing
May 29, 2026
$1,195,000
$1,295,000
-8% Price Drop
Initial Listing
Apr 7, 2026
$1,295,000
$1,400,000
-7% Price Drop
Initial Listing
Feb 15, 2026
$1,400,000
Initial Listing