Rob Brown
Realty Concepts, Ltd.
(559) 821-2616
67 Total Sales
3 in Downtown Turlock
$358,000 Price Range
400 W Main St Turlock, CA 95380
Downtown Turlock NeighborhoodEstimated Value: $361,000 - $432,000
6
Beds
2.5
Baths
3,000
Sq Ft
$133/Sq Ft
Est. Value
Highlights
- Wooded Lot
- Private Yard
- Neighborhood Views
- Main Floor Bedroom
- No HOA
- Den
About This Home
As of February 2025Loads of potential! 3 separate living areas, 3 tenants currently on property. This home actually has another address for the entrance of the top floor (See 109 S. Orange St) There is about 3,000 unverified sq ft: There are 3 separate entrances and living areas. Orange street side entrance is for upstairs: 2 Bed, 1 bath (Bath has been mostly updated - see pictures), covered balcony, full kitchen and breakfast nook, and 2 separate storage rooms. Front Entrance: 2 beds, 1 bath, full kitchen, dining room, and living room. Side entrance off Main st driveway: 1/2 kitchen, full dining, living room, 1 bath, 2 bed. This home has a Total of 6 bedrooms, 2.5 bath, 3 living rooms, 1 den, storage rooms, 1 car garage and a basement. Approximately 3,000 sq ft unverified living space.
Last Agent to Sell the Property
Realty Concepts, Ltd. Brokerage Phone: 559-580-2370 License #02206472 Listed on: 11/08/2024
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Details
Home Type
- Single Family
Year Built
- Built in 1925
Lot Details
- 5,662 Sq Ft Lot
- Level Lot
- Wooded Lot
- Private Yard
- Density is up to 1 Unit/Acre
Parking
- 1 Car Direct Access Garage
- 5 Open Parking Spaces
- Parking Available
- Side Facing Garage
- Single Garage Door
- Driveway
Home Design
- Entry on the 1st floor
- Fixer Upper
Interior Spaces
- 3,000 Sq Ft Home
- 2-Story Property
- Family Room
- Living Room
- Dining Room
- Den
- Neighborhood Views
- Laundry Located Outside
- Unfinished Basement
Kitchen
- Breakfast Area or Nook
- Eat-In Kitchen
Bedrooms and Bathrooms
- 6 Bedrooms | 4 Main Level Bedrooms
Additional Features
- Exterior Lighting
- Urban Location
- Central Air
Listing and Financial Details
- Assessor Parcel Number 050020004
Community Details
Recreation
- Bike Trail
Additional Features
- No Home Owners Association
- Laundry Facilities
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Mar 30, 2026
Sold by
Gonzalez Renteria
Bought by
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$371,000
Interest Rate
6.18%
Mortgage Type
New Conventional
Purchase Details
Closed on
Feb 5, 2026
Sold by
Carlos Curiel
Bought by
Renteria Veronica
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$371,000
Interest Rate
6.18%
Mortgage Type
New Conventional
Purchase Details
Listed on
Nov 8, 2024
Closed on
Dec 6, 2024
Sold by
Ramos Roberto R and Ramos Maria
Bought by
Renteria Veronica Gonzalez and Curiel Roberto Carlos
Seller's Agent
Rob Brown
Realty Concepts, Ltd.
Buyer's Agent
Izabella McIntyre
Bellamia Real Estate Services
List Price
$349,800
Sold Price
$358,000
Premium/Discount to List
$8,200
2.34%
Views
478
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.99%
Original Mortgage
$268,500
Interest Rate
6.72%
Mortgage Type
New Conventional
Purchase Details
Closed on
Jul 29, 2020
Sold by
Ramos Roberto
Bought by
Ramos Roberto Ramirez and Ramos Roberto R
Purchase Details
Closed on
Jul 6, 2010
Sold by
Ramos Maria C
Bought by
Ramos Roberto
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$73,500
Interest Rate
4.79%
Mortgage Type
New Conventional
Purchase Details
Closed on
Jun 18, 2010
Sold by
Martinez Maria Guadalupe
Bought by
Ramos Roberto
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$73,500
Interest Rate
4.79%
Mortgage Type
New Conventional
Purchase Details
Closed on
Oct 4, 2006
Sold by
Martinez Roberto
Bought by
Martinez Maria Guadalupe
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$258,000
Interest Rate
6.39%
Mortgage Type
Stand Alone First
Purchase Details
Closed on
Apr 3, 2006
Sold by
Martinez Roberto
Bought by
Martinez Maria Guadalupe
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$100,000
Interest Rate
6.29%
Mortgage Type
Credit Line Revolving
Purchase Details
Closed on
Mar 10, 2005
Sold by
Martinez Maria Guadalupe R
Bought by
Martinez Roberto
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$121,000
Interest Rate
5.61%
Mortgage Type
New Conventional
Purchase Details
Closed on
Mar 21, 2002
Sold by
Martinez Maria Guadalupe R
Bought by
Martinez Roberto and Martinez Maria Guadalupe R
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$71,049
Interest Rate
6.84%
Purchase Details
Closed on
Oct 10, 2001
Sold by
Martinez Roberto and Martinez Maria Guadalupe R
Bought by
Martinez Maria Guadalupe R
Purchase Details
Closed on
Apr 27, 2001
Sold by
Jones Gary L and Jones Steve
Bought by
Martinez Roberto and Martinez Maria Guadalupe
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Downtown Turlock, CA
-
Rob Brown
-
Justin Eden
Justin Eden
KW College Park
(469) 278-7236
37 Total Sales
1 in Downtown Turlock
$590,000 Price
-
Angeles Lomeli
Angeles Lomeli
Lifestyle Realty
(209) 219-3822
109 Total Sales
1 in Downtown Turlock
$285,000 Price
-
Tammy Burgess
Tammy Burgess
Realty Executives Of Northern California
(209) 354-3553
37 Total Sales
1 in Downtown Turlock
$330,000 Price
-
JoAnn Merenda
JoAnn Merenda
eXp Realty of Northern California, Inc.
(209) 219-3322
54 Total Sales
1 in Downtown Turlock
$460,000 Price
-
Eric Terrero
Eric Terrero
PMZ Real Estate
(209) 554-6059
79 Total Sales
1 in Downtown Turlock
$340,000 Price
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| -- | None Listed On Document | ||
| Renteria Veronica | -- | Chicago Title | |
| Renteria Veronica Gonzalez | $358,000 | Old Republic Title | |
| Ramos Roberto Ramirez | -- | None Available | |
| Ramos Roberto | -- | Stewart Title Of California | |
| Ramos Roberto | $100,000 | Stewart Title Of California | |
| Martinez Maria Guadalupe | -- | Alliance Title Company | |
| Martinez Maria Guadalupe | -- | None Available | |
| Martinez Roberto | -- | Alliance Title Company | |
| Martinez Roberto | -- | Fidelity National Title | |
| Martinez Maria Guadalupe R | -- | -- | |
| Martinez Roberto | $142,500 | Chicago Title Co |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | $371,000 | ||
| Closed | Renteria Veronica Gonzalez | $268,500 | |
| Previous Owner | Ramos Roberto | $75,000 | |
| Previous Owner | Ramos Roberto | $73,500 | |
| Previous Owner | Martinez Maria Guadalupe | $258,000 | |
| Previous Owner | Martinez Maria Guadalupe | $100,000 | |
| Previous Owner | Martinez Roberto | $121,000 | |
| Previous Owner | Martinez Roberto | $71,049 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 02/04/2025 02/04/25 | Sold | $358,000 | +2.3% | $119 / Sq Ft |
| 11/08/2024 11/08/24 | For Sale | $349,800 | -- | $117 / Sq Ft |
Source: California Regional Multiple Listing Service (CRMLS)
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $1,515 | $140,917 | $32,023 | $108,894 |
| 2024 | $1,487 | $138,155 | $31,396 | $106,759 |
| 2023 | $1,484 | $135,447 | $30,781 | $104,666 |
| 2022 | $1,466 | $132,792 | $30,178 | $102,614 |
| 2021 | $1,444 | $130,189 | $29,587 | $100,602 |
| 2020 | $1,434 | $128,855 | $29,284 | $99,571 |
| 2019 | $1,410 | $126,329 | $28,710 | $97,619 |
| 2018 | $1,409 | $123,853 | $28,148 | $95,705 |
| 2017 | $1,376 | $121,426 | $27,597 | $93,829 |
| 2016 | $1,285 | $119,046 | $27,056 | $91,990 |
| 2015 | $1,274 | $117,259 | $26,650 | $90,609 |
| 2014 | $1,261 | $114,963 | $26,128 | $88,835 |
Source: Public Records
Agents Affiliated with this Home
-
Rob Brown
Seller's Agent in 2025
Rob Brown
Realty Concepts, Ltd.
(559) 580-2370
1 in this area
67 Total Sales
-
Izabella McIntyre
IM
Buyer's Agent in 2025
Izabella McIntyre
Bellamia Real Estate Services
(831) 801-3923
1 in this area
6 Total Sales
Map
Source: California Regional Multiple Listing Service (CRMLS)
MLS Number: FR24230250
APN: 050-20-04
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The multiple listing data appearing on this website, or contained in reports produced therefrom, is owned and copyrighted by California Regional Multiple Listing Service, Inc. ("CRMLS") and is protected by all applicable copyright laws. Information provided is for viewer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties the viewer may be interested in purchasing. All listing data, including but not limited to square footage and lot size is believed to be accurate, but the listing Agent, listing Broker and CRMLS and its affiliates do not warrant or guarantee such accuracy. The viewer should independently verify the listed data prior to making any decisions based on such information by personal inspection and/or contacting a real estate professional.
Based on information from California Regional Multiple Listing Service, Inc. and /or other sources. 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
Nearby Homes
- 458 W Olive Ave
- 470 W Olive Ave
- 442 W Olive Ave
- 482 W Olive Ave
- 428 W Olive Ave
- 457 W Main St
- 123 N Orange St
- 400 W Olive Ave
- 443 W Main St
- 475 W Main St
- 457 W Olive Ave Unit 1
- 457 W Olive Ave
- 431 W Main St
- 493 W Main St
- 441 W Olive Ave
- 419 W Main St
- 473 W Olive Ave
- 427 W Olive Ave
- 489 W Olive Ave
- 403 W Main St
Your Personal Tour Guide
Ask me questions while you tour the home.