|
<%@ 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
Vacation homes Oakhurst-North Fork and Oakhurst-North Fork California apartments for rent
Vacation homes Lodi California, Lodi for rent by owner homes, and Lodi California rent houses
San Jose apartment rentals, vacation homes San Jose, rent house San Jose California, and homes for rent San Jose California
Home rentals in Santa Ynez Valley California and Santa Ynez Valley California rental homes
Home rentals Reedley, Reedley California for rent by owner homes, and rent house in Reedley California
Greenfield California real estate rentals, for rent by owner homes Greenfield, apartments for rent Greenfield, and houses for rent
Rental homes El Centro and El Centro California condos for rent
Condo rentals Salida, Salida rental houses, and houses for rent in Salida California
Condo rentals Bishop, Bishop for rent by owner homes, Bishop California homes for rent, and Bishop bed and breakfast rentals
Vacation homes for rent by owner in San Rafael and short term rentals in San Rafael California
Garberville California rental homes, Garberville California rental home, and holiday rentals Garberville
Chowchilla California rental homes, for rent by owner homes in Chowchilla California, holiday rentals in Chowchilla California, and Chowchilla California vacation rental
Ferret out, detect, and find out real estate rentals Buena Park, rent houses in Buena Park United States, and rental apartment.
Originate and discern rental home in Lake California, Lake California rental apartment, and Lake rental properties.
Dig up, observe, and learn Lassen California apartments for rent, rent house, and rental homes in Lassen California.
Identify and distinguish homes for rent by owner and condo rentals Imperial.
The East Yolo convenient listings and lakefront listings for these can be mapped.
Ferret out and originate rental houses in Los Alamitos United States and vacation rental in Los Alamitos United States.
Ferret out, espy, and locate apartments for rent in Modoc and Modoc home rentals.
Our online website, FRBO.com can join up and sign on exclusive lists of marked properties and beachfront indexes exclusive listings, mountain classified advertisements, ski in/out directories, and private classified ads to further your East Yolo progress.
The East Yolo California advertisements recorded and tabulated on our website, FRBO.com take in convenient villa, hidden townhouse, and beachfront lodge.
East Yolo California is a alluring and angelic county with angelic, cute, and ravishing home, castle, flat, and townhouses.
Explore special and various evidence in East Yolo California and inventory rental homes in East Yolo California.
Find out, notice, and ascertain real estate rentals Callahan, homes for rent Callahan, and Callahan vacation homes.
Perceive and catch houses for rent Inverness United States and Inverness rent house.
East Yolo area employs many real estate investors and land owners.
Find out and contrive rent house in Brentwood and Brentwood United States condos for rent.
Hear and uncover Crestline condos for rent and rent houses in Crestline.
Levy and attract on Saturday to enter upon and open on this venture.
Originate and locate house rentals in Santa Barbara, real estate rentals, and Santa Barbara California vacation homes for rent by owner.
Find out, identify, and discern bed and breakfast rentals Santa Clara and rental houses in Santa Clara California.
|
|
