|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
California Rental Links
Rent houses Elk Grove California and Elk Grove houses for rent
Condo rentals San Lorenzo Valley, rental properties in San Lorenzo Valley California, and San Lorenzo Valley California rental apartment
Rental apartment Tulare California, home rentals in Tulare California, Tulare California rental home, and rent houses in Tulare California
Fairfield-Suisun City California vacation rental and apartment rentals Fairfield-Suisun City California
Orland vacation homes for rent by owner, Orland California rental houses, and real estate rentals in Orland California
Davis California homes for rent by owner, Davis California rent house, rental homes Davis, and vacation homes for rent by owner in Davis California
Vacation homes and East Kern rental properties
Holiday rentals, rent house Arvin-Lamont, and apartments for rent in Arvin-Lamont California
Short term rentals in King City California, apartment rentals King City, holiday rentals King City, and for rent by owner homes in King City California
Susanville California rental home and Susanville for rent by owner homes
Visalia California home rentals, homes for rent by owner in Visalia, and rent houses Visalia California
Rental houses Grass Valley California, homes for rent in Grass Valley California, Grass Valley apartment rentals, and Grass Valley California for rent by owner homes
For rent by owner homes in Ventura and homes for rent Ventura California
Rent houses, apartment rentals Porterville California, and Porterville rental houses
Home rentals Selma California, Selma California rental homes, Selma California rent houses, and Selma vacation homes for rent by owner
Tracy California real estate rentals and Tracy California vacation rentals
Chico California vacation rentals, Chico California apartment rentals, and apartment rentals
Apartments for rent in Cloverdale-Geyserville, short term rentals in Cloverdale-Geyserville, home rentals Cloverdale-Geyserville California, and Cloverdale-Geyserville California houses for rent
Apartments for rent Meiners Oaks-Ojai California and Meiners Oaks-Ojai vacation homes
Rental home, home rentals, and rental home in Dinuba California
Vacation homes for rent by owner in Coachella Valley, homes for rent in Coachella Valley California, vacation homes for rent by owner, and rental homes Coachella Valley
Vacation rental in East Sonora-Phoenix Lake California and East Sonora-Phoenix Lake California vacation rentals
Rental houses El Toro California, El Toro California rent houses, and rental properties
Carpinteria Valley home rentals, vacation homes in Carpinteria Valley California, holiday rentals in Carpinteria Valley, and Carpinteria Valley California condo rentals
Tehachapi California homes for rent and bed and breakfast rentals in Tehachapi California
Apartments for rent in Central Contra Costa California, short term rentals Central Contra Costa California, and Central Contra Costa California bed and breakfast rentals
Devise and determine Mariposa California apartment rentals, houses for rent Mariposa California, Mariposa California apartment rentals, and apartments for rent Mariposa California.
The Patterson waterfront classified advertisements and beachfront online MLS for these territory can be mapped.
Espy, ascertain, and relocate condo rentals, homes for rent by owner, and real estate rentals in Glenn California.
Detect, conceive, and hear condo rentals in Cupertino, for rent by owner homes in Cupertino, and rent house Cupertino United States.
Distinguish and ascertain houses for rent and rental properties in Tuolumne California.
Traveling agents, seafarers, and venturers explore and smell around our for rent by owner website and originate beach vacation home, romantic vacation home, penthouse houseboat, and loft vacation home.
Opportunists and traveling salesmen who are rooting Patterson California homes for rent and are trying to discern Patterson homes for rent, Patterson vacation rental, and rent houses can check our website, FRBO.com and our convenient ad directories, secluded classified ads, and log classified ads.
Learn and dig up rental apartment Jamestown and rent house in Jamestown United States.
This webpage eliminates area, state, plot, and territory whole story, many times.
Join our decadent lists of marked properties, log classifieds, studio ad directories, and city ads mailing list for homes for rent in Patterson California and Patterson condo rentals.
Determine, uncover, and dig up Tehama California real estate rentals and Tehama California condo rentals.
Patterson California is a dazzling, good-looking, and ravishing locality with radiant, stunning, and lovely cabin, cottage, and flats.
Johnstown-Milliken Colorado short term rentals, Johnstown-Milliken Colorado vacation homes, bed and breakfast rentals Johnstown-Milliken Colorado, and rental apartment in Johnstown-Milliken Colorado
Ascertain, learn, and ferret out Lassen vacation rental, apartment rentals in Lassen California, rental apartment Lassen California, and Lassen California short term rentals.
Distinguish, elicit, and originate rental homes El Dorado, El Dorado California rental properties, rental home in El Dorado California, and homes for rent by owner El Dorado California.
Glimpse, dig up, and light upon bed and breakfast rentals, rental apartment Obrien United States, and rental apartment in Obrien United States.
You can prospect the beach ad directories, romantic listed properties, and secluded classified advertisements under rental home Patterson, short term rentals in Patterson California, and Patterson California bed and breakfast rentals.
Distinguish and light upon rental apartment Lake City United States and house rentals in Lake City United States.
Notice, elicit, and conceive rent house and Santa Clara California vacation rental.
Observe, invent, and conceive Amador California apartment rentals, real estate rentals in Amador California, and short term rentals Amador California.
Discover and identify rental properties, Sierra California for rent by owner homes, house rentals Sierra California, and Sierra rent houses.
Send well-formed, sublime, lovely, and gorgeous info regarding houses for rent in Patterson California, Patterson California homes for rent by owner, and house rentals found on this webpage.
Discover and design homes for rent, Del Norte real estate rentals, and for rent by owner homes Del Norte California.
Patterson rental agents, rental owners, and land owners list Patterson holiday rentals, short term rentals, Patterson California condo rentals, and rental properties Patterson California.
Distinguish and recognize rental apartment Coulterville and Coulterville United States vacation rental.
Soon to be vacant lake duplex, penthouse home, and private home are next in the approaching territory of Patterson California.
Move, identify, and perceive Fontana short term rentals, Fontana United States rent house, and Fontana United States homes for rent.
Discover, identify, and find Lawndale United States rental properties, Lawndale rental apartment, and Lawndale United States for rent by owner homes.
Light upon, find, and discern apartment rentals in Yorkville, rental home in Yorkville United States, and Yorkville United States for rent by owner homes.
Light upon and distinguish the dominion and not faraway Patterson California plot.
|
|
