Courtesy of Teresa Kleinen, Better Homes and Gardens Real - [email protected]
Why wait to build when you can enjoy the benefits of a nearly new home with fully paid solar and a $5,000 seller credit toward the buyer's closing costs or interest rate buy-down with an acceptable offer? Situated on a quiet cul-de-sac, this 2021 DR Horton Lincoln floor plan offers approximately 2,554 square feet of thoughtfully designed living space with 5 bedrooms and 3.5 bathrooms.A standout feature is the private downstairs living quarters with its own separate entrance and full bathroom, providing exceptional flexibility for multigenerational living, extended guests, a private home office, or additional privacy.The heart of the home is the bright, open-concept kitchen featuring quartz countertops, shaker-style cabinetry, a large center island with seating, a walk-in pantry, and stainless-steel appliances. The seamless flow into the dining and living areas creates an inviting space for everyday living and effortless entertaining.Upstairs, a spacious loft offers endless possibilities as a second family room, media space, playroom, or home office. The primary suite provides a relaxing retreat with dual vanities, a generous walk-in closet, and abundant natural light. Three additional bedrooms, a full bathroom, and a conveniently located upstairs laundry room complete the second floor.With contemporary finishes, a flexible floor plan, energy-efficient paid solar, and a location in one of South Merced's desirable neighborhoods, this home is designed to fit today's lifestyle while offering exceptional value.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2021
Region
Urban
# of Stories
Two
Price Per Square Foot
$190
Price Per Acre
$4,224,739
Days On London
82
Cumulative Days On London
82
County
Merced
Reports Available
NHD
REO / Bank Owned
No
Cross Street Address
La Habra
Directions
from campus parkway go straight to Mission Ave, Turn right on La Habra and then right on Shafer Trail
Heating & Cooling
Central Heat & Cool
Laundry
Utility Room, On Upper Level
Roofing
Composition
Foundation
Concrete
Detached Structures
Shed
Kitchen
Disposal, Dishwasher, Microwave, Breakfast Bar
Dining Room Features
Family Room/Area
Primary Bedroom Level
Upper
Bath Features
Tub/Shower, Shower
Flooring
Carpet, Tile
Exterior
Wood
Pool
No
Pool
No
Patio Features
Uncovered
Yard
Sprinklers Front, Sprinklers Auto
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Energy Efficiency
Dual Pane Windows, Tankless Water Heater
Solar
Yes
Solar Type
Owned Free and Clear
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
Site Amenities
Cul De Sac
APN
259 310 020 000
School District
Merced
School Type 1
High School
School Name 1
Merced
School Type 2
Junior High School
School Name 2
Merced
School Type 3
Grade School
School Name 3
Merced
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 460750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 509250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2304 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2804 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1750372 OR `props-main`.`id` = 1750373 OR `props-main`.`id` = 1667395 OR `props-main`.`id` = 1667390 OR `props-main`.`id` = 1750374 OR `props-main`.`id` = 1667389 OR `props-main`.`id` = 1667396 OR `props-main`.`id` = 1750371 OR `props-main`.`id` = 1754978 OR `props-main`.`id` = 1731157 OR `props-main`.`id` = 1750377 OR `props-main`.`id` = 1667912 OR `props-main`.`id` = 1667929 OR `props-main`.`id` = 1750380 OR `props-main`.`id` = 1750379 OR `props-main`.`id` = 1667931 OR `props-main`.`id` = 1667930 OR `props-main`.`id` = 1750378 OR `props-main`.`id` = 1750355 OR `props-main`.`id` = 1704658 OR `props-main`.`id` = 1759074 OR `props-main`.`id` = 1739617 OR `props-main`.`id` = 1739624 OR `props-main`.`id` = 1739574 OR `props-main`.`id` = 1743979 OR `props-main`.`id` = 1728573 OR `props-main`.`id` = 1737393 OR `props-main`.`id` = 1736196 OR `props-main`.`id` = 1762260 OR `props-main`.`id` = 1730583 OR `props-main`.`id` = 1730586 OR `props-main`.`id` = 1730692 OR `props-main`.`id` = 1764142 OR `props-main`.`id` = 1739300 OR `props-main`.`id` = 1731971 OR `props-main`.`id` = 1731976 OR `props-main`.`id` = 1748619 OR `props-main`.`id` = 1763848 OR `props-main`.`id` = 1755765 OR `props-main`.`id` = 1755749 OR `props-main`.`id` = 1733029 OR `props-main`.`id` = 1715753 OR `props-main`.`id` = 1742832 OR `props-main`.`id` = 1715746 OR `props-main`.`id` = 1715759 OR `props-main`.`id` = 279647 OR `props-main`.`id` = 1725764 OR `props-main`.`id` = 1754374 OR `props-main`.`id` = 1754388 OR `props-main`.`id` = 1754377 OR `props-main`.`id` = 1763526 OR `props-main`.`id` = 1763605 OR `props-main`.`id` = 1763323 OR `props-main`.`id` = 1753557 OR `props-main`.`id` = 1761128 OR `props-main`.`id` = 1761125 OR `props-main`.`id` = 1709192 OR `props-main`.`id` = 1760321 OR `props-main`.`id` = 1745418 OR `props-main`.`id` = 1750434 OR `props-main`.`id` = 1738363 OR `props-main`.`id` = 1747597 OR `props-main`.`id` = 1738341 OR `props-main`.`id` = 1747695 OR `props-main`.`id` = 1762534 OR `props-main`.`id` = 1755638 OR `props-main`.`id` = 1708287 OR `props-main`.`id` = 1755177 OR `props-main`.`id` = 1759130 OR `props-main`.`id` = 1744294 OR `props-main`.`id` = 1747521 OR `props-main`.`id` = 1737937 OR `props-main`.`id` = 1750479 OR `props-main`.`id` = 1764274 OR `props-main`.`id` = 1702508 OR `props-main`.`id` = 1749244 OR `props-main`.`id` = 1764301 OR `props-main`.`id` = 1710117 OR `props-main`.`id` = 1747733 OR `props-main`.`id` = 1750518 OR `props-main`.`id` = 1764082 OR `props-main`.`id` = 1764128 OR `props-main`.`id` = 1753455 OR `props-main`.`id` = 1754697 OR `props-main`.`id` = 1752512 OR `props-main`.`id` = 1746124 OR `props-main`.`id` = 1746130 OR `props-main`.`id` = 1705935 OR `props-main`.`id` = 1716724 OR `props-main`.`id` = 1749924 OR `props-main`.`id` = 1742786 OR `props-main`.`id` = 1753397 OR `props-main`.`id` = 1728831 OR `props-main`.`id` = 1701206 OR `props-main`.`id` = 1746162 OR `props-main`.`id` = 1764461 OR `props-main`.`id` = 1746412 OR `props-main`.`id` = 1732942 OR `props-main`.`id` = 1755173 OR `props-main`.`id` = 1737274 OR `props-main`.`id` = 1701468 OR `props-main`.`id` = 1748981 OR `props-main`.`id` = 1754595 OR `props-main`.`id` = 1758229 OR `props-main`.`id` = 1760741 OR `props-main`.`id` = 1723794 OR `props-main`.`id` = 1740678 OR `props-main`.`id` = 1725535 OR `props-main`.`id` = 1725536 OR `props-main`.`id` = 1041230 OR `props-main`.`id` = 1753086 OR `props-main`.`id` = 1693713 OR `props-main`.`id` = 1693694 OR `props-main`.`id` = 1750438 OR `props-main`.`id` = 1760812 OR `props-main`.`id` = 1741942 OR `props-main`.`id` = 1756128 OR `props-main`.`id` = 1706026 OR `props-main`.`id` = 1692454 OR `props-main`.`id` = 1692435 OR `props-main`.`id` = 1755946 OR `props-main`.`id` = 1760758 OR `props-main`.`id` = 1750407 OR `props-main`.`id` = 1723296 OR `props-main`.`id` = 1750514 OR `props-main`.`id` = 1757384 OR `props-main`.`id` = 1729890 OR `props-main`.`id` = 1723264 OR `props-main`.`id` = 1708251 OR `props-main`.`id` = 1759559 OR `props-main`.`id` = 1750122 OR `props-main`.`id` = 1751552 OR `props-main`.`id` = 1751628 OR `props-main`.`id` = 1739248 OR `props-main`.`id` = 1739112 OR `props-main`.`id` = 1735184 OR `props-main`.`id` = 1724054 OR `props-main`.`id` = 1734972 OR `props-main`.`id` = 1718502 OR `props-main`.`id` = 1704870 OR `props-main`.`id` = 1704891 OR `props-main`.`id` = 1704917 OR `props-main`.`id` = 1753076 OR `props-main`.`id` = 1757068)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649018' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-20' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
0
Last modified 2 hours ago Fresno MLS last checked for updates 10 minutes ago
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
