---
listing_id: ME226138742
status: Active
price: 660000
beds: 4
baths_full: 4
baths_half: 0
sqft_living: 3292
sqft_lot: 12001
lot_acres: 0.275
year_built: 
property_type: Residential
property_subtype: 
address: "1605 W Longview Ave"
city: Stockton
state: CA
zip: 95207
county: "San Joaquin County"
lat: 38.000406
lng: -121.3294706
days_on_market: 3
hoa_fee: 
hoa_frequency: 
garage_spaces: 2
list_agent: "Miquesha Willis"
list_office: "LPT Realty"
list_agent_phone: "(209) 717-3000"
list_agent_license: 02247170
mls_source: REMTRO
modified: 2026-11-19
transaction_type: buy
---

Home | San Joaquin County | Stockton | 95207 | 1605 W Longview Ave

1605 W Longview Ave, Stockton, CA 95207

MLS: ME226138742 | Status: Active | Price: $660,000
Beds/Baths: 4 / 4
Property Type: Residential

Quick Facts

Beds Baths Sq Ft Acres Lot Yr Built
4 4 3,292 0.275 –

Remarks

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

MLS Listing Information

Field Value
MLS # ME226138742
MLS Source MetroList Services, Inc.
Days on Site 3

Features

Interior Features

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

Exterior Features

Feature Details
Roof Composition
Foundation Raised, Slab, Concrete Perimeter and Slab
Pool Cover, Gunite, Pool - Yes, Sweep
Style Contemporary

Parking, School, and Other Information

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

Contact Information

Miquesha Willis
LPT Realty
License #: 02247170
Phone: (209) 717-3000

Property Units

# Buildings # Leased Units # Total Units
0 – –

School Ratings

School data provided by GreatSchools.org

Nearby Schools

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

Nearby Homes

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

Disclosures

©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.