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/fresno/643854/1847-E-Lauren-Ave/Dinuba/https://www.londonproperties.com/images/props/fresno/full/643854.jpgLondon Properties Dinuba Real Estate | 1847 E Lauren Ave
Come take a look at this beautiful home in Dinuba! This 1,706 sq ft, 3 bedroom, 2 bath home features a nice open floor plan with a spacious living area, dining room, and indoor laundry. The home has been recently freshened up with new interior paint, new carpet, and an updated primary shower. Situated on a large 7,956 sq ft lot, additional features include a tile roof and stamped concrete in the front and beneath the backyard patio. Schedule a private showing with your favorite Realtor today.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2007
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$246
Price Per Acre
$2,294,633
Days On London
11
Cumulative Days On London
11
County
Tulare
REO / Bank Owned
No
Cross Street Address
Crawford
Directions
North on Alta to Ave 400, East on Ave 400 to Rd 88/Crawford, North on Rd88/Crawford to Lauren, East on Lauren to residence.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Primary Bedroom Level
Main
# of Fireplaces
1
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
Garage Type
Attached
Garage Spaces
2
APN
013 120 032
School District
Dinuba
School Type 1
High School
School Name 1
Dinuba
School Type 2
Junior High School
School Name 2
Washington
School Type 3
Grade School
School Name 3
Kennedy
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 398050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 439950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1456 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1956 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` = 1711164 OR `props-main`.`id` = 1701568 OR `props-main`.`id` = 1685735 OR `props-main`.`id` = 1685737 OR `props-main`.`id` = 1697271 OR `props-main`.`id` = 1697251 OR `props-main`.`id` = 1698646 OR `props-main`.`id` = 1707942 OR `props-main`.`id` = 1645564 OR `props-main`.`id` = 1710397 OR `props-main`.`id` = 1698540 OR `props-main`.`id` = 1698615 OR `props-main`.`id` = 1701566 OR `props-main`.`id` = 1701565 OR `props-main`.`id` = 1681363 OR `props-main`.`id` = 1689869 OR `props-main`.`id` = 1698664 OR `props-main`.`id` = 1697323 OR `props-main`.`id` = 1698672 OR `props-main`.`id` = 1706821 OR `props-main`.`id` = 1701675 OR `props-main`.`id` = 1694492 OR `props-main`.`id` = 1703897 OR `props-main`.`id` = 246307 OR `props-main`.`id` = 1708315 OR `props-main`.`id` = 1708340 OR `props-main`.`id` = 1683751 OR `props-main`.`id` = 1651549 OR `props-main`.`id` = 1700136 OR `props-main`.`id` = 1681675 OR `props-main`.`id` = 1705268 OR `props-main`.`id` = 1703332 OR `props-main`.`id` = 1698469 OR `props-main`.`id` = 1706029 OR `props-main`.`id` = 1706025 OR `props-main`.`id` = 1706023 OR `props-main`.`id` = 1708245 OR `props-main`.`id` = 1681963 OR `props-main`.`id` = 1676794 OR `props-main`.`id` = 1709581 OR `props-main`.`id` = 1676262)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno643854' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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();
0
Courtesy of Scott Harness, Harness Realty - [email protected] Last modified 6 hours ago Fresno MLS last checked for updates 40 minutes ago
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.
