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/242915/33485-Globe-Dr/Springville/https://www.londonproperties.com/images/props/tulare/full/242915.jpgLondon Properties Springville Real Estate | 33485 Globe Dr
HWY 190 to Globe Dr; right onto Globe Dr/Mountain Rd 161; left onto Pleasant Oak Dr; right onto Tule Oak Dr; left onto Globe Dr/Mountain Rd 172A; turn right and property will be on the right
Ceiling Fan(s), High Ceilings, His and Hers Closets, Kitchen Island, Kitchen Open to Family Room, Living Room Deck Attached, Low Flow Plumbing Fixtures, Open Floorplan, Vaulted Ceiling(s), Pantry
Bathrooms Total (Integer)
2
Full Baths
2.0
Full Baths
2
Appliances
Propane Cooktop, Plumbed For Ice Maker, Built-In Range, Dishwasher, Disposal, Exhaust Fan, Gas Water Heater, Microwave, Refrigerator, Vented Exhaust Fan, Water Heater
200+ Amp Service,220 Volts For Spa,220 Volts in Kitchen,220 Volts in Laundry
Water Source
Well
Sewer
Septic Tank
Parking Features
Attached, Concrete, Garage Door Opener, Garage Faces Front, RV Access/Parking, Workshop in Garage
Garage
Yes
Attached Garage
Yes
# of Garage Spaces
2.0
APN
284 620 022 000
Lot Features
Treed Lot, Front Yard, Landscaped, Level, Pasture, Rectangular Lot, Sprinklers In Front, Sprinklers In Rear, Sprinklers on Side
Lot Dimensions
irregular
Horse Property
Yes
Horse Amenities
1-6 Stalls,Fenced,Pasture
Additional Parcels Y/N
No
View
Hills, Mountain(s), Rural, Trees/Woods
Road Frontage Type
County Road
Road Surface Type
Asphalt, Concrete
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 474999.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 524998.95 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) >= 1825 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2325 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` = 1724535 OR `props-main`.`id` = 1743100 OR `props-main`.`id` = 1720130 OR `props-main`.`id` = 1720129 OR `props-main`.`id` = 1750053 OR `props-main`.`id` = 1751449 OR `props-main`.`id` = 1725943 OR `props-main`.`id` = 1711486 OR `props-main`.`id` = 1748484 OR `props-main`.`id` = 1724561 OR `props-main`.`id` = 1744889 OR `props-main`.`id` = 1725959 OR `props-main`.`id` = 1679299 OR `props-main`.`id` = 1729833 OR `props-main`.`id` = 1720121 OR `props-main`.`id` = 1711483 OR `props-main`.`id` = 1709824 OR `props-main`.`id` = 1739144 OR `props-main`.`id` = 1743702 OR `props-main`.`id` = 1746025 OR `props-main`.`id` = 1725119 OR `props-main`.`id` = 1683503 OR `props-main`.`id` = 1710281 OR `props-main`.`id` = 1748842 OR `props-main`.`id` = 1720159 OR `props-main`.`id` = 1729723 OR `props-main`.`id` = 1746873 OR `props-main`.`id` = 1720027 OR `props-main`.`id` = 1720511 OR `props-main`.`id` = 1749600 OR `props-main`.`id` = 1742510 OR `props-main`.`id` = 1715891)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare242915' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-19' 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 Reggie Jean-Gilles, William L Lyon & Associates In
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.
