|
<%@ 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
Hollister California house rentals and rental properties in Hollister California
Palo Verde apartment rentals, homes for rent Palo Verde, and home rentals Palo Verde California
Houses for rent in South El Dorado California, rental properties in South El Dorado, holiday rentals South El Dorado California, and for rent by owner homes
San Diego California vacation homes for rent by owner and house rentals in San Diego California
Vacation homes for rent by owner Roseville, homes for rent by owner, and rent houses in Roseville California
Rent houses in Gilroy California, bed and breakfast rentals Gilroy California, rental properties in Gilroy California, and for rent by owner homes in Gilroy
East San Gabriel Valley rent houses and East San Gabriel Valley for rent by owner homes
Newhall California homes for rent, Newhall vacation rentals, and Newhall California rental properties
Vacation homes in Fort Bragg, Fort Bragg California vacation rental, Fort Bragg California vacation homes, and real estate rentals in Fort Bragg California
Fairfield-Suisun City California rental properties and bed and breakfast rentals Fairfield-Suisun City
For rent by owner homes in Rosedale California, vacation rental in Rosedale California, and Rosedale California apartments for rent
Vacation homes for rent by owner in Orland California, Orland condos for rent, condo rentals, and rent houses in Orland California
Houses for rent in Turlock California and rental houses
Meiners Oaks-Ojai California short term rentals, home rentals, and Meiners Oaks-Ojai condo rentals
Homes for rent in Compton California, Compton California condo rentals, vacation rental in Compton California, and Compton houses for rent
Conceive and come upon rental homes, Fresno California rent house, Fresno California holiday rentals, and rental houses in Fresno.
Come across, uncover, and contrive short term rentals in San Benito California and for rent by owner homes in San Benito.
Identify and come across home rentals in San Luis Obispo and condos for rent San Luis Obispo California.
South El Dorado condo owners, landlords, condo owners, and rental property owners list vacation rentals South El Dorado California, holiday rentals South El Dorado California, and rental apartment in South El Dorado California.
South El Dorado California is a splendid, admirable, and admirable plot with fascinating, good-looking, fascinating, and well-formed chalet, hacienda, and vacation homes.
You can distinguish, disclose, and relocate holiday rentals in South El Dorado, South El Dorado California condos for rent, and short term rentals South El Dorado.
Elicit, identify, and ferret out house rentals, holiday rentals Paskenta, and Paskenta bed and breakfast rentals.
Learn and notice vacation homes in Sonoma California, real estate rentals Sonoma, and rental houses Sonoma.
Notice and ferret out Menifee United States rental home and rental apartment in Menifee.
Resort indexes and secluded online MLS house rentals in Madera, apartments for rent in Madera California, homes for rent by owner Madera, and short term rentals in Madera California.
Sisters and traveling saleswomen scour and grub For Rent By Owner and ascertain exotic house and hillside duplex.
South El Dorado California results could reinforce, bail out, run interference, and run interference your frisking.
Originate and move rental home Imperial California and vacation rentals in Imperial.
Notice and conceive houses for rent San Luis Obispo California, homes for rent in San Luis Obispo, and rent houses San Luis Obispo.
Using this site, For Rent By Owner (FRBO.com), property agents classify townhouse and condominium directories.
Engage and interest next weekend to jump into and enter upon on this march.
Catch, hear, and contrive homes for rent by owner Yorkville, vacation rentals, and vacation rental.
Perceive, discern, and contrive rent house in Rackerby United States, for rent by owner homes Rackerby United States, and for rent by owner homes in Rackerby United States.
Come upon, discover, and dig up rent houses, Napa California rental properties, and Napa California vacation homes.
Ferret out, contrive, and ferret out rental homes in Ontario United States, Ontario United States apartment rentals, and rental homes in Ontario.
Observe and find out Trinity California rental properties and Trinity California apartment rentals.
|
|
