The results of your search can be seen on the map and below in a list. Your search returned 2 results with up to 20 shown on map. Map results change with the results below. Click next to view the next set of results.
Your Search Results
Showing page 1 of 1 pages
SELECT MLS_LISTING_ID AS mls_listing_id, latitude, longitude, concat(STREET_NUMBER, " ", STREET_NAME, " ", STREET_TYPE, " ", STREET_DIRECTION, ", ", CITY, " ", MLS_STATE_ID) AS address, street_name, city, zip_code, mls_state_id, sale_price, bedrooms, baths_half, baths_full, building_square_footage, LEFT(remarks, 185) AS remarks, subdivision, property_type_code, photo_url, photo_quantity FROM mlsData WHERE mls_id !="" AND city = "Alturas" AND property_type_code = "V" ORDER BY sale_price, building_square_footage DESC LIMIT 0, 20
$253,000.00
Vacant Land
Bed, Bath
0 Sq. Ft.
11.5+/-AC CITRUS GROVE W/200' FRONTGE ON CENTRAL AVE. PROFITABLE HAMLIN GROVE. LANDUSAGE: RCC&RCCR. WELL ON SITE. POTENTIAL FOR DEV. DIR: HWY60,S ON ALTURAS RD,TURNS INTO CENTRAL AVE,PR...
View Details »
$389,935.00
Vacant Land
Bed, Bath
0 Sq. Ft.
65 ACRES COMPRISED OF 2 PARCELS WITH 2 WELLS AND 3 PHASE ELEC. & POLE BARN.GREAT FARMLAND. 2 OTHER PARCELS OF 120 ACRES EACH & CONTIGUOUS ARE ALSO AVAILABLE. PROPERTY IS IN ALTURUS WITH...
View Details »
Showing page 1 of 1 pages
