Please provide the following information and Araceli Garcia will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.araceligarciarealtor.com/agent/16801/araceli-garcia/property/link/crmls/MC25133656/345-Sullivan-Dr/Merced/https://www.araceligarciarealtor.com/images/props/crmls/full/MC25133656.jpgLondon Properties Merced Real Estate | 345 Sullivan Dr
Listing Agent: Filiberto Villanueva, Realty Executives Of Northern California
Imagine life in this beautifully updated 4-bedroom, 2.5-bath home, designed for both comfort and elegance. Every detail has been carefully considered. Step inside and be greeted by a seamless flow of upgraded light fixtures that illuminate every corner, creating a contemporary ambiance throughout. The heart of this home is its open-concept kitchen, a chef's dream with gleaming granite countertops and top-of-the-line stainless steel appliances and a dedicated coffee bar perfect for your morning routine. Unwind in the spacious living room, anchored by a sleek, built-in modern fireplace. or effortlessly transition to your private outdoor space - a newly laid stamped concrete patio, perfect for enjoying your favorite beverage. The impressive two-car garage, featuring sleek epoxy floors, adds to the home's exceptional appeal. With its thoughtful upgrades and move-in ready status, 345 Sullivan Dr offers an incredible opportunity to start living your best life. Don't miss out - schedule your visit today''
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2022
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
2
Levels
Two
Number Of Units Total
1
Entry Level
1
Entry Location
South
Price Per Square Foot
$239
Days On Market
131
Cumulative Days On Market
131
County Or Parish
Merced
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Fence Y/N
Yes
Heating Y/N
Yes
Directions
N. on G St, left on Cardella Rd, left on Bancroft Dr, Right on Shafer Ave, left on Korbel Ave to Sullivan Dr
Architectural Style
Contemporary
Room Type
All Bedrooms Up, Family Room, Kitchen, Laundry, Walk-In Closet
Heating
Central
Cooling
Central Air, ENERGY STAR Qualified Equipment
Laundry Y/N
Yes
Laundry Features
In Closet, Inside
Roof
Shingle
Construction Materials
Stucco
Window Features
Double Pane Windows, ENERGY STAR Qualified Windows
Foundation Details
Slab
Property Condition
Turnkey
Main Level Bedrooms
2
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Bathrooms Half
1
Main Level Bathrooms
2
Room Kitchen Features
Granite Counters, Kitchen Island
Eating Area
Breakfast Counter / Bar, In Kitchen
Appliances Y/N
Yes
Appliances
Dishwasher, Gas Oven, Gas Cooktop, Microwave
Room Bathroom Features
Bathtub, Shower, Shower in Tub, Double sinks in bath(s), Exhaust fan(s), Granite Counters
Interior Features
Ceiling Fan(s), Granite Counters, High Ceilings, Open Floorplan, Pantry
Flooring
Carpet, Tile
Common Walls
No Common Walls
Fireplace Y/N
No
Fireplace Features
None
Pool Features
None
Pool Private Y/N
No
Spa Y/N
No
Spa Features
None
Patio Y/N
Yes
Patio And Porch Features
None
Electric
220 Volts
Utilities
Sewer Connected
Water Source
Public
Sewer
Public Sewer
Parking Total
1.00
Attached Garage Y/N
Yes
Garage Spaces
1.00
Lot Features
Landscaped, Irregular Lot, Sprinklers In Front
Lot Size Area
2380.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
City Lights
Sprinklers Y/N
Yes
Fencing
Wood
Common Interest
None
Parcel Number
230120018000
Additional Parcels Y/N
No
Zoning
P-D
Community Features
Curbs
Senior Community Y/N
No
Association Y/N
No
High School District
Merced City
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
62
Tax Census Tract
10.07
72871
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 394250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 435750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1487 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1987 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` = 1694328 OR `props-main`.`id` = 1694332 OR `props-main`.`id` = 1694334 OR `props-main`.`id` = 1684373 OR `props-main`.`id` = 1684370 OR `props-main`.`id` = 1686079 OR `props-main`.`id` = 1691912 OR `props-main`.`id` = 93375 OR `props-main`.`id` = 1686717 OR `props-main`.`id` = 1694945 OR `props-main`.`id` = 1695821 OR `props-main`.`id` = 1693419 OR `props-main`.`id` = 1696071 OR `props-main`.`id` = 1695361 OR `props-main`.`id` = 1637274 OR `props-main`.`id` = 1695368 OR `props-main`.`id` = 1688618 OR `props-main`.`id` = 1689807 OR `props-main`.`id` = 1667441 OR `props-main`.`id` = 1667401 OR `props-main`.`id` = 1687805 OR `props-main`.`id` = 1690905 OR `props-main`.`id` = 1690919 OR `props-main`.`id` = 223289 OR `props-main`.`id` = 223288 OR `props-main`.`id` = 1675048 OR `props-main`.`id` = 1659390 OR `props-main`.`id` = 1659386 OR `props-main`.`id` = 1659394 OR `props-main`.`id` = 1693860 OR `props-main`.`id` = 1682982 OR `props-main`.`id` = 1685606 OR `props-main`.`id` = 1668036 OR `props-main`.`id` = 1695391 OR `props-main`.`id` = 1693903 OR `props-main`.`id` = 1691854 OR `props-main`.`id` = 1671252 OR `props-main`.`id` = 1671258 OR `props-main`.`id` = 202390 OR `props-main`.`id` = 342849 OR `props-main`.`id` = 1654695 OR `props-main`.`id` = 1695509 OR `props-main`.`id` = 1688495 OR `props-main`.`id` = 1688489 OR `props-main`.`id` = 1688492 OR `props-main`.`id` = 1666642 OR `props-main`.`id` = 1692984 OR `props-main`.`id` = 1693858 OR `props-main`.`id` = 1692357 OR `props-main`.`id` = 1686794 OR `props-main`.`id` = 1685713 OR `props-main`.`id` = 206435 OR `props-main`.`id` = 1692668 OR `props-main`.`id` = 1622703 OR `props-main`.`id` = 1691417 OR `props-main`.`id` = 1691347 OR `props-main`.`id` = 1686975 OR `props-main`.`id` = 1678643 OR `props-main`.`id` = 1687101 OR `props-main`.`id` = 1679616 OR `props-main`.`id` = 1651652 OR `props-main`.`id` = 1681413 OR `props-main`.`id` = 204765 OR `props-main`.`id` = 360956 OR `props-main`.`id` = 1664281 OR `props-main`.`id` = 1689954 OR `props-main`.`id` = 1685969 OR `props-main`.`id` = 1685977 OR `props-main`.`id` = 1694399 OR `props-main`.`id` = 1669733 OR `props-main`.`id` = 1669885 OR `props-main`.`id` = 1622834 OR `props-main`.`id` = 1668860 OR `props-main`.`id` = 1668868 OR `props-main`.`id` = 1683028 OR `props-main`.`id` = 1695367 OR `props-main`.`id` = 1695357 OR `props-main`.`id` = 1656184 OR `props-main`.`id` = 1676633 OR `props-main`.`id` = 1676678 OR `props-main`.`id` = 1676655 OR `props-main`.`id` = 1684707 OR `props-main`.`id` = 1683876 OR `props-main`.`id` = 1694386 OR `props-main`.`id` = 1689536 OR `props-main`.`id` = 1685384 OR `props-main`.`id` = 1683766 OR `props-main`.`id` = 1683771 OR `props-main`.`id` = 1691662 OR `props-main`.`id` = 1693408 OR `props-main`.`id` = 1689130 OR `props-main`.`id` = 1683576 OR `props-main`.`id` = 1693788 OR `props-main`.`id` = 1694943 OR `props-main`.`id` = 1695597 OR `props-main`.`id` = 1695572 OR `props-main`.`id` = 1694398 OR `props-main`.`id` = 1695710 OR `props-main`.`id` = 1685831 OR `props-main`.`id` = 1673969 OR `props-main`.`id` = 1695786 OR `props-main`.`id` = 1695428 OR `props-main`.`id` = 1695809 OR `props-main`.`id` = 1690556 OR `props-main`.`id` = 1694040 OR `props-main`.`id` = 1692266 OR `props-main`.`id` = 1695822 OR `props-main`.`id` = 1666278 OR `props-main`.`id` = 1695808 OR `props-main`.`id` = 1695462 OR `props-main`.`id` = 1695811 OR `props-main`.`id` = 1696087 OR `props-main`.`id` = 1682095 OR `props-main`.`id` = 1684983 OR `props-main`.`id` = 1684986 OR `props-main`.`id` = 1684988 OR `props-main`.`id` = 1691838 OR `props-main`.`id` = 1629281 OR `props-main`.`id` = 1600784 OR `props-main`.`id` = 1685542 OR `props-main`.`id` = 1684427 OR `props-main`.`id` = 1684010 OR `props-main`.`id` = 1684416 OR `props-main`.`id` = 1638859 OR `props-main`.`id` = 1692819 OR `props-main`.`id` = 1675090 OR `props-main`.`id` = 1675106 OR `props-main`.`id` = 1687778)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25133656' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-30' 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();
2
Similar Properties
$435,000
4
3
1,787
0.17
310 Buena Vista Ct
Merced, CA 95348
$395,000
4
3
1,637
0.06
1338 Hermosa Dr
Merced, CA 95348
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.