Home | San Joaquin County | Stockton | 95207 | 1605 W Longview Ave
MLS: ME226138742 | Status: Active | Price: $660,000
Beds/Baths: 4 / 4
Property Type: Residential
| Beds | Baths | Sq Ft | Acres Lot | Yr Built |
|---|---|---|---|---|
| 4 | 4 | 3,292 | 0.275 | – |
Welcome to this stunning and extensively updated 3,292 sq. ft. residence nestled on an expansive 12,000 sq. ft. lot in a quiet, well-kept, and neighborly tree-lined community in Stockton! Framed by inviting curb appeal, manicured landscaping, a wide driveway, and mature shade trees, this 4-bedroom, 4-bathroom home shines with numerous major renovations completed within the past one to two years, including a new roof, new gutters, an AC condenser replaced within the last two years, and a new tankless water heater. The thoughtful main-level layout features 3 bedrooms, 3 bathrooms, a spacious family room, a formal dining area, hardwood and tile flooring, an indoor laundry room, and a bright kitchen with freshly painted white cabinets, double ovens, and a gas cooktop. The luxurious primary suite is a true retreat, featuring a fully upgraded spa-like bathroom complete with heated flooring, a freestanding soaking tub beneath an elegant chandelier, and a walk-in glass shower. A fantastic private-entry upper-level studio, complete with its own kitchenette, walk-in closet, full bathroom, and flexible living space. While the studio kitchen and bathroom are fully functional and ready for use, they also offer a wonderful opportunity for the new owner to add their own cosmetic touches a
| Field | Value |
|---|---|
| MLS # | ME226138742 |
| MLS Source | MetroList Services, Inc. |
| Days on Site | 3 |
| Feature | Details |
|---|---|
| Bedrooms | Remodeled |
| Bathrooms | Updated Bath(s) |
| Kitchen | Countertop - Granite, Hookups - Gas, Hookups - Ice Maker, Island, Pantry Cabinet, Updated |
| Appliances | Cooktop - Gas, Garbage Disposal, Oven - Double, Oven - Electric, Oven Range - Built-In, Oven Range - Electric |
| Dining Room | Breakfast Nook, Formal Area |
| Fireplace | Electric, Family Room, Insert |
| Flooring | Carpet, Tile, Wood |
| Laundry | 220 Volt Outlet, Cabinets, Laundry Area |
| Cooling | Ceiling Fan, Central Forced Air |
| Heating | Central Forced Air, Fireplace Insert |
| Feature | Details |
|---|---|
| Roof | Composition |
| Foundation | Raised, Slab, Concrete Perimeter and Slab |
| Pool | Cover, Gunite, Pool - Yes, Sweep |
| Style | Contemporary |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Covered Parking, Detached, Garage: 2 Car(s) |
| Elementary District | Lincoln Unified |
| High School District | Lincoln Unified |
| Sewer | Other |
| Zoning | R1 |
Miquesha Willis
LPT Realty
License #: 02247170
Phone: (209) 717-3000
| # Buildings | # Leased Units | # Total Units |
|---|---|---|
| 0 | – | – |
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| Village Oaks High | public | 9-12 | 0.20 mi | 2 |
| Lincoln Unified Preschool | public | UG | 0.30 mi | N/A |
| Flora Arca Mata School | public | K-8 | 0.42 mi | 6 |
| Middle College High School | public | 9-12 | 0.64 mi | 10 |
| Sierra Middle School | public | 7-8 | 0.74 mi | 5 |
| Tully C. Knoles School | public | K-8 | 0.85 mi | 3 |
| Lincoln High School | public | 9-12 | 0.90 mi | 7 |
| Lincoln Elementary School | public | K-6 | 0.94 mi | 6 |
| Adams Elementary School | public | K-8 | 1.00 mi | 2 |
| Maxine Hong Kingston Elementary School | public | K-8 | 1.16 mi | 3 |
| Stagg Senior High School | public | 9-12 | 1.21 mi | 3 |
| Walton Development Center | public | K-12 | 1.29 mi | N/A |
| Kohl Open Elementary School | public | K-8 | 1.36 mi | 4 |
| John R. Williams School | public | K-6 | 1.50 mi | 4 |
| Claudia Landeen School | public | K-8 | 1.58 mi | 4 |
| Colonial Heights School | public | K-8 | 1.61 mi | 3 |
| Primary Years Academy | public | K-6 | 1.65 mi | 6 |
| Pulliam Elementary School | public | K-8 | 1.66 mi | 3 |
| Special Education Preschool Dis | public | KG | 1.67 mi | N/A |
| Cleveland Elementary School | public | K-8 | 1.97 mi | 7 |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 5042 Gadwall Cir | $545,000 | 4 | 3 | 3,050 | PendingDoNotShow |
| 2409 Beverly Pl | $564,900 | 3 | 1/1 | 1,810 | PendingDoNotShow |
| 6582 Brook Hollow Cir | $777,500 | 5 | 3/1 | 3,319 | Active |
| 420 W Pearl Ave | $659,900 | 3 | 2 | 2,234 | PendingDoNotShow |
©2026 MetroList Services, Inc. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MetroList Services, Inc.
Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.
This listing information is up-to-date as of November 19, 2026. For the most current information, please contact Miquesha Willis, (209) 717-3000.