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/641329/31144-James-Ave/Madera/https://www.londonproperties.com/images/props/fresno/full/641329.jpgLondon Properties Madera Real Estate | 31144 James Ave
Escape to the tranquility of country living in this beautifully home offering 3 bedrooms 3 bath home. It also has a separate office space or can be a 4th Bedroom. Nestled on a sprawling 2.29 acre lot. The home is 2,370 comfortable living space for those seeking peace and quiet. The property is ideal for large animals like horses making it a dream for animal lovers.divbr/divdivStep inside and discover a recently remodeled kitchen, featuring modern appliances and stylish finishes. Open floor plan concept and has new flooring in the living room and kitchen. The expansive lot provides plenty of space for outdoor activity, gardening or simply enjoying the serene surroundings./div
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1995
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$293
Price Per Acre
$303,493
Days On Market
0
Cumulative Days On Market
0
County
Madera
Reports Available
Prelim Title Report
Special Features
Isolated Bedroom, Horses Allowed
REO / Bank Owned
No
Cross Street Address
Road 31
Directions
From Hwy 145 turn right on to Rd 31 then left to James Ave.
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
F/S Range/Oven, Gas Appliances
Primary Bedroom Level
Lower
Bath Features
Tub/Shower
Extra Rooms
Den/Study
# of Fireplaces
1
Fireplace Type
Gas Insert
Exterior
Stucco, Stone
Pool
No
Pool
No
Patio Features
Covered
Yard
Fenced, Mature Landscape
Gas & Electric
Propane
Sewer / Water
Septic Tank, Private Well
Solar
Yes
Solar Type
Lease
Parking Features
Potential RV Parking, Carport
Carport Spaces
1
APN
035 434 005 000
School District
Madera Unified
School Type 1
High School
School Name 1
Madera South
School Type 2
Junior High School
School Name 2
Martin Luther King
School Type 3
Grade School
School Name 3
Millview
Seller Will Consider
Government, Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 660250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 729750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2120 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2620 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` = 1674118 OR `props-main`.`id` = 1693051 OR `props-main`.`id` = 1699070 OR `props-main`.`id` = 1698199 OR `props-main`.`id` = 1627559 OR `props-main`.`id` = 1688076 OR `props-main`.`id` = 1693543 OR `props-main`.`id` = 1688062 OR `props-main`.`id` = 1688069 OR `props-main`.`id` = 1687431 OR `props-main`.`id` = 1648819 OR `props-main`.`id` = 1673959 OR `props-main`.`id` = 1682056 OR `props-main`.`id` = 1697156)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno641329' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-23' 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();
1
Similar Properties
$715,000
4
3
2,286
2.00
31395 Avenue 17
Madera, CA 93636
Courtesy of Ana Champion, HomeSmart PV and Associates - [email protected] Last modified 5 hours 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.
