Please provide the following information and Jessica Vela will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.jessicasellscentralca.com/agent/19055/jessica-vela/property/link/tulare/237534/6428-W-Oriole-Ave/Visalia/https://www.jessicasellscentralca.com/images/props/tulare/full/237534.jpgLondon Properties Visalia Real Estate | 6428 W Oriole Ave
Nearly 3,000 sqft of Spanish-style elegance with Smart Home features in Northwest Visalia featuring 5 beds, 4 baths and OWNED SOLAR with little to no electric bill! Set on a generous corner lot with striking custom cement work front and back. The first floor shines with engineered flooring, a split layout & gourmet kitchen with granite counters & stainless steel appliances. Upstairs, enjoy a private bedroom & full bath plus a large loft complete with a jaw dropping MOVIE THEATER! This beautifully upgraded home is designed for modern living featuring fully equipped smart-home features throughout. Enjoy the convenience of a smart lock on both the main entry and garage door, a smart thermostat for effortless climate control, and a smart garage system that offers security and ease at your fingertips. Outside, expansive outdoor living awaits with fruit trees, garden areas, a separate private terrace & side yard. This amazing home also Includes a water heater-and a 3-car garage. A rare blend of style, space & efficiency in a highly desirable location. Schedule your showing today!
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2013
Year Built Source
Assessor
Days On Market
66
Cumulative Days On Market
66
County
Tulare
New Construction
No
Stories
2
Directions to Property
From 198 take Akers exit head north on Akers, west on Riggin, south on Denton. Home is on the corner of Denton and Oriole.
Foundation Details
Slab
Roof
Tile
Heating
Central
Cooling
Ceiling Fan(s), Central Air
Laundry Features
Laundry Room
Other Structures
Shed(s)
Interior Features
Ceiling Fan(s), Granite Counters, Kitchen Island
# of Main Level Bathrooms
2
Bathrooms Total (Integer)
4
Full Baths
3.5
Full Baths
3
Half Baths
1
Appliances
Dishwasher, Double Oven, Gas Oven
Fireplace Y/N
No
Flooring
Carpet, Wood
Spa
No
Patio and Porch Features
Patio
Utilities
Natural Gas Connected
Water Source
Public
Sewer
Public Sewer
Green Energy Efficient
Water Heater
Garage
Yes
# of Garage Spaces
3.0
APN
777 700 250 00
Lot Features
Corner Lot
Lot Dimensions
Irregular
Additional Parcels Y/N
No
Road Surface Type
Asphalt
HOA
No
72873
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 664050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 733950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2704 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3204 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` = 1688527 OR `props-main`.`id` = 1686038 OR `props-main`.`id` = 1686066 OR `props-main`.`id` = 1685884 OR `props-main`.`id` = 1668427 OR `props-main`.`id` = 1671874 OR `props-main`.`id` = 1689108 OR `props-main`.`id` = 1678055 OR `props-main`.`id` = 1690423 OR `props-main`.`id` = 1653061 OR `props-main`.`id` = 1681740 OR `props-main`.`id` = 1656391 OR `props-main`.`id` = 1694313 OR `props-main`.`id` = 1695245 OR `props-main`.`id` = 1695794 OR `props-main`.`id` = 1692428 OR `props-main`.`id` = 1696145 OR `props-main`.`id` = 1686195 OR `props-main`.`id` = 1687055 OR `props-main`.`id` = 1681833 OR `props-main`.`id` = 1681831 OR `props-main`.`id` = 1666495 OR `props-main`.`id` = 1676624 OR `props-main`.`id` = 1684201 OR `props-main`.`id` = 1684375 OR `props-main`.`id` = 1694366 OR `props-main`.`id` = 1689463 OR `props-main`.`id` = 1689661 OR `props-main`.`id` = 1664023 OR `props-main`.`id` = 1693407 OR `props-main`.`id` = 1694555 OR `props-main`.`id` = 1668864 OR `props-main`.`id` = 1689917 OR `props-main`.`id` = 1686098 OR `props-main`.`id` = 1692511 OR `props-main`.`id` = 1692512 OR `props-main`.`id` = 1692513 OR `props-main`.`id` = 1677934 OR `props-main`.`id` = 1677921 OR `props-main`.`id` = 1677924 OR `props-main`.`id` = 1677928 OR `props-main`.`id` = 1694477 OR `props-main`.`id` = 1694475 OR `props-main`.`id` = 1694478 OR `props-main`.`id` = 1648195 OR `props-main`.`id` = 1695329 OR `props-main`.`id` = 1691257 OR `props-main`.`id` = 1691256 OR `props-main`.`id` = 1691270 OR `props-main`.`id` = 929721 OR `props-main`.`id` = 1664698 OR `props-main`.`id` = 1695568 OR `props-main`.`id` = 1690638 OR `props-main`.`id` = 1696046 OR `props-main`.`id` = 1692211 OR `props-main`.`id` = 1686839 OR `props-main`.`id` = 1690334 OR `props-main`.`id` = 1686742 OR `props-main`.`id` = 1671529 OR `props-main`.`id` = 1671562 OR `props-main`.`id` = 1681742 OR `props-main`.`id` = 1681741 OR `props-main`.`id` = 1696039 OR `props-main`.`id` = 1696237)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare237534' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-28' 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 Jessica Vela, London Properties - Hanford
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.
