Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/metrolist/226023778/4668-Jema-Drive-Dr/Merced/https://www.londonproperties.com/images/props/metrolist/full/226023778.jpgLondon Properties Merced Real Estate | 4668 Jema Drive Dr
The four-bedroom Cumberland floor plan is ideal for any lifestyle. Relax or entertain in the airy great room, which flows into a large kitchen with a center island and a walk-in pantry. You'll find two secondary bedrooms flanking a bath toward the front of the home, with a third across the foyer. The serene primary suite is located at the back of the residence, showcasing a private bath with dual vanities and a walk-in shower. For the best in modern living, choose the Cumberland!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Property Condition
New Construction
Year Built Details
New
Year Built Source
Builder
Remodeled/Updated
No
Stories
1
Home Warranty
No
Directions to Property
From M Street, turn west onto Jema Drive. Sales office located at 4634 Jema Drive
Cross Street
Valerie Way
County
Merced
Special Listing Conditions
None
Builder Name
Century Communities
Builder Model
Cumberland
Main Level
Bedroom(s), Living Room, Dining Room, Family Room, Full Bath(s), Garage, Kitchen, Street Entrance
Construction Materials
Stucco, Frame, Wood
Foundation
Concrete, Slab
Roof
Composition
Heating
Central, Heat Pump
Cooling
Central, Heat Pump
Laundry Features
Electric, Upper Floor, Hookups Only, Inside Room
Property Faces
Northeast
Full Bathrooms
2
Bath Features
Tub w/Shower Over, Quartz
Flooring
Carpet, Vinyl
Appliances
Dishwasher, Disposal, Microwave, Tankless Water Heater, Free Standing Electric Oven
Auto Sprinkler Front, Landscape Front, Low Maintenance
APN
224 330 061 000
Fencing
Back Yard, Wood
Horse Property
No
Zoning Description
Residential
Subdivision
Sundial at Bellevue Ranch
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Merced
Elementary School District
Merced City
Middle or Junior School District
Merced City
Senior High School District
Merced Union High
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 495719.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 547900.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1635 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2135 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` = 1705311 OR `props-main`.`id` = 1685606 OR `props-main`.`id` = 1698211 OR `props-main`.`id` = 1702750 OR `props-main`.`id` = 1702741 OR `props-main`.`id` = 1708427 OR `props-main`.`id` = 1702577 OR `props-main`.`id` = 1702568 OR `props-main`.`id` = 1705622 OR `props-main`.`id` = 1705703 OR `props-main`.`id` = 1704802 OR `props-main`.`id` = 1707000 OR `props-main`.`id` = 1698176 OR `props-main`.`id` = 1703877 OR `props-main`.`id` = 1708190 OR `props-main`.`id` = 204765 OR `props-main`.`id` = 1708196 OR `props-main`.`id` = 1702162 OR `props-main`.`id` = 1709467 OR `props-main`.`id` = 1709442 OR `props-main`.`id` = 1712101 OR `props-main`.`id` = 1689954 OR `props-main`.`id` = 1711218 OR `props-main`.`id` = 1709672 OR `props-main`.`id` = 1706672 OR `props-main`.`id` = 1712818 OR `props-main`.`id` = 1706679 OR `props-main`.`id` = 1703717 OR `props-main`.`id` = 1703858 OR `props-main`.`id` = 1706057 OR `props-main`.`id` = 1704869 OR `props-main`.`id` = 1704889 OR `props-main`.`id` = 1704915 OR `props-main`.`id` = 1705344 OR `props-main`.`id` = 1701912 OR `props-main`.`id` = 1701908 OR `props-main`.`id` = 1705282 OR `props-main`.`id` = 1709925 OR `props-main`.`id` = 1694386 OR `props-main`.`id` = 1689536 OR `props-main`.`id` = 1702926 OR `props-main`.`id` = 1685384 OR `props-main`.`id` = 1683766 OR `props-main`.`id` = 1683771 OR `props-main`.`id` = 1704369 OR `props-main`.`id` = 1711312 OR `props-main`.`id` = 1703392 OR `props-main`.`id` = 1704849 OR `props-main`.`id` = 1694943 OR `props-main`.`id` = 1704838 OR `props-main`.`id` = 1712713 OR `props-main`.`id` = 1702711 OR `props-main`.`id` = 1702684 OR `props-main`.`id` = 1702695 OR `props-main`.`id` = 1712543 OR `props-main`.`id` = 1706816 OR `props-main`.`id` = 1703184 OR `props-main`.`id` = 1702578 OR `props-main`.`id` = 1712710 OR `props-main`.`id` = 1705259 OR `props-main`.`id` = 1705596 OR `props-main`.`id` = 1705601 OR `props-main`.`id` = 1704350 OR `props-main`.`id` = 1709853 OR `props-main`.`id` = 1712821 OR `props-main`.`id` = 1712822 OR `props-main`.`id` = 1711333 OR `props-main`.`id` = 1704899 OR `props-main`.`id` = 1704926 OR `props-main`.`id` = 1708144 OR `props-main`.`id` = 1708145 OR `props-main`.`id` = 1708146 OR `props-main`.`id` = 1666278 OR `props-main`.`id` = 1701226 OR `props-main`.`id` = 1701225 OR `props-main`.`id` = 1706107 OR `props-main`.`id` = 1706773 OR `props-main`.`id` = 1706127 OR `props-main`.`id` = 1706126 OR `props-main`.`id` = 1706108 OR `props-main`.`id` = 1711149 OR `props-main`.`id` = 1701227 OR `props-main`.`id` = 1701229 OR `props-main`.`id` = 1708147 OR `props-main`.`id` = 1709924 OR `props-main`.`id` = 1710118 OR `props-main`.`id` = 1629281 OR `props-main`.`id` = 1600784 OR `props-main`.`id` = 1701369 OR `props-main`.`id` = 1709529 OR `props-main`.`id` = 1710262 OR `props-main`.`id` = 1684427 OR `props-main`.`id` = 1701451 OR `props-main`.`id` = 1712583 OR `props-main`.`id` = 1687778 OR `props-main`.`id` = 1641188)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226023778' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-02' 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();
6
Similar Properties
$507,283
4
2
1,960
0.17
714 Skyler Ct
Merced, CA 95348
$499,995
5
4
1,891
0.05
246 Montage
Merced, CA 95348
$497,500
4
3
1,956
0.13
3482 Paseo Verde Ave
Merced, CA 95348
$496,487
4
3
1,810
0.18
786 Skyler Ct
Merced, CA 95348
Courtesy of Wesley Bennett, BMC Realty Advisors, Inc. IDX provided by Reliance Marketing
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.
