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/tulare/238147/1209-N-N-Gem-St/Tulare/https://www.londonproperties.com/images/props/tulare/full/238147.jpgLondon Properties Tulare Real Estate | 1209 N N Gem St
Beautifully remodeled 3-bedroom, 2-bath home offering 1,819 sq ft of comfortable living in one of Tulare's established neighborhoods near Adventist Health Hospital. Fully updated in 2018, this home features a new roof, modern kitchen with granite countertops, stainless steel appliances, and stylish cabinetry. The open floor plan connects the kitchen, dining, and living areas for easy entertaining. Bathrooms have been tastefully refreshed, and newer flooring flows throughout the home. Spacious primary suite, dual-pane windows, and great natural light add to the appeal. Enjoy the private backyard with mature landscaping and covered patio-perfect for relaxing or gatherings. Convenient location near parks, schools, shopping, and quick freeway access. Move-in ready and beautifully maintained!
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1978
Year Built Source
Public Records
Days On Market
69
Cumulative Days On Market
69
County
Tulare
Property Condition
Updated/Remodeled
New Construction
No
Stories
1
Current Use
Single Family, Residential
Directions to Property
From Highway 99 (northbound or southbound)
Exit: Take Exit 85 - Cross Avenue
1. Head west on E Cross Avenue for about 1.2 miles toward downtown Tulare.
2. Turn right (north) onto N
Construction Materials
Stucco
Foundation Details
Slab
Roof
Composition
Heating
Active Solar, Central, Fireplace(s), Forced Air, Natural Gas, Solar
Ceiling Fan(s), Entrance Foyer, Low Flow Plumbing Fixtures, Open Floorplan
Bathrooms Total (Integer)
2
Full Baths
2.0
Full Baths
2
Appliances
Disposal, Exhaust Fan, Free-Standing Range, Gas Oven, Gas Range, Gas Water Heater, Microwave, Oven, Range, Vented Exhaust Fan, Water Heater
Fireplace Y/N
Yes
Fireplace Features
Living Room
Flooring
Carpet, Vinyl
Common Walls
No Common Walls
Spa
No
Utilities
Cable Connected, Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached, Garage Door Opener, Garage Faces Front, RV Access/Parking
Garage
Yes
Attached Garage
Yes
# of Garage Spaces
2.0
APN
170 050 060 000
Lot Features
Back Yard, Fencing, Front Yard, Irregular Lot, Landscaped, Level, Near Public Transit, Sprinklers In Front
Lot Dimensions
irregular
Horse Property
No
Additional Parcels Y/N
No
View
Neighborhood
Waterfront Y/N
No
Road Surface Type
Paved
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 379050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 418950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1569 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2069 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` = 1693561 OR `props-main`.`id` = 1701785 OR `props-main`.`id` = 1657781 OR `props-main`.`id` = 1695159 OR `props-main`.`id` = 1701658 OR `props-main`.`id` = 1694790 OR `props-main`.`id` = 1691823 OR `props-main`.`id` = 1701738 OR `props-main`.`id` = 1696346 OR `props-main`.`id` = 1685563 OR `props-main`.`id` = 1685702 OR `props-main`.`id` = 1698634 OR `props-main`.`id` = 1684725 OR `props-main`.`id` = 1698616 OR `props-main`.`id` = 1666539 OR `props-main`.`id` = 1698594 OR `props-main`.`id` = 1687298 OR `props-main`.`id` = 1689432 OR `props-main`.`id` = 1698849 OR `props-main`.`id` = 1697940 OR `props-main`.`id` = 1698959 OR `props-main`.`id` = 1648159 OR `props-main`.`id` = 1694065 OR `props-main`.`id` = 1686171 OR `props-main`.`id` = 1700912 OR `props-main`.`id` = 1667549 OR `props-main`.`id` = 1697313 OR `props-main`.`id` = 1697879 OR `props-main`.`id` = 1699011 OR `props-main`.`id` = 1701698 OR `props-main`.`id` = 1696919 OR `props-main`.`id` = 1700135 OR `props-main`.`id` = 1685817 OR `props-main`.`id` = 1698728 OR `props-main`.`id` = 1696889 OR `props-main`.`id` = 1693940 OR `props-main`.`id` = 1696785 OR `props-main`.`id` = 1685766 OR `props-main`.`id` = 1681801 OR `props-main`.`id` = 1651113 OR `props-main`.`id` = 1701353 OR `props-main`.`id` = 1683997 OR `props-main`.`id` = 1692257 OR `props-main`.`id` = 1700834 OR `props-main`.`id` = 1700835 OR `props-main`.`id` = 1698149 OR `props-main`.`id` = 1701245 OR `props-main`.`id` = 1694598 OR `props-main`.`id` = 1701338 OR `props-main`.`id` = 1694599 OR `props-main`.`id` = 1660481 OR `props-main`.`id` = 1657630 OR `props-main`.`id` = 1660958 OR `props-main`.`id` = 1648117 OR `props-main`.`id` = 1685715 OR `props-main`.`id` = 1643854 OR `props-main`.`id` = 1694740 OR `props-main`.`id` = 1677929 OR `props-main`.`id` = 1636938 OR `props-main`.`id` = 1657603 OR `props-main`.`id` = 1690627 OR `props-main`.`id` = 1698877 OR `props-main`.`id` = 1701502 OR `props-main`.`id` = 1701806 OR `props-main`.`id` = 1701808 OR `props-main`.`id` = 1701810 OR `props-main`.`id` = 1701505 OR `props-main`.`id` = 1701807 OR `props-main`.`id` = 1701811 OR `props-main`.`id` = 1701812 OR `props-main`.`id` = 1684795 OR `props-main`.`id` = 1648079 OR `props-main`.`id` = 1697046 OR `props-main`.`id` = 1694653 OR `props-main`.`id` = 1695290 OR `props-main`.`id` = 1695293 OR `props-main`.`id` = 1695294 OR `props-main`.`id` = 1692037 OR `props-main`.`id` = 1695266 OR `props-main`.`id` = 1701804 OR `props-main`.`id` = 1688392 OR `props-main`.`id` = 1697295 OR `props-main`.`id` = 1698599 OR `props-main`.`id` = 1701650 OR `props-main`.`id` = 1688342 OR `props-main`.`id` = 1689107)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare238147' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-08' 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();
8
Similar Properties
$409,900
3
2
1,668
0.14
3039 Britannia St
Tulare, CA 93274
$405,860
3
3
1,790
0.08
2065 Roussanne Ave #Sor27
Tulare, CA 93274
$395,790
3
3
1,662
0.07
2785 Ruby Port St #Sor21
Tulare, CA 93274
$389,900
4
2
1,918
0.29
339 S Silva St
Tulare, CA 93274
Courtesy of Justina Arjona, RE/MAX Success
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.
