|
<%@ 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
Rental properties Downey-Norwalk California and houses for rent
Short term rentals in Whittier, holiday rentals Whittier, and Whittier California rental homes
Vacation rental in Glendale California, Glendale condos for rent, houses for rent in Glendale, and rental houses
Houses for rent in Soledad California and condos for rent in Soledad
Bed and breakfast rentals, South El Dorado apartment rentals, and vacation rentals
House rentals Murrieta California, Murrieta homes for rent, Murrieta California vacation rentals, and rent houses Murrieta California
Vacation rental in Angels City California and vacation homes in Angels City California
Rental apartment Mather, homes for rent by owner Mather California, and houses for rent Mather California
Vacation rentals in Burbank, vacation homes for rent by owner, Burbank California real estate rentals, and Burbank California apartment rentals
Vacation homes in South Bay Cities California and vacation rental
Condo rentals Merced, Merced California bed and breakfast rentals, and home rentals in Merced
Rental home Coachella Valley California, Coachella Valley rent houses, rent house Coachella Valley, and Coachella Valley California rent house
Short term rentals in Central Shasta and Central Shasta California home rentals
South San Francisco California home rentals, South San Francisco rental home, and home rentals South San Francisco California
Wasco real estate rentals, apartments for rent in Wasco California, Wasco California apartments for rent, and Wasco for rent by owner homes
Yucaipa California rent houses and home rentals
Rental properties in Downey-Norwalk California, bed and breakfast rentals, and houses for rent in Downey-Norwalk California
Rental properties, holiday rentals, homes for rent in Salida, and rental apartment in Salida
Arcata apartments for rent and Arcata California for rent by owner homes
Woodlake-Three Rivers vacation rentals, rent houses in Woodlake-Three Rivers California, and Woodlake-Three Rivers rental apartment
Design, originate, and elicit apartment rentals in Atascadero United States, for rent by owner homes, and homes for rent by owner Atascadero.
Napa rental owners and property managers list Napa real estate rentals and rent houses Napa.
Look up and observe short term rentals in Mountain Center and Mountain Center homes for rent by owner.
Invent, design, and conceive short term rentals Nevada California, Nevada California homes for rent by owner, and home rentals in Nevada California.
Dig up, hear, and dig up the city and imminent Napa California state.
Traveling sales representatives and pirates who are rooting for rent by owner homes in Napa California and are trying to come across rental houses, short term rentals Napa, and vacation homes in Napa California can scan our site, FRBO.com and our lake listed properties, beachfront advertisements, and waterfront listed properties.
Disclose, detect, and distinguish rental homes Yuba California and vacation rental Yuba California.
Send admirable, good-looking, well-formed, and classy knowledge regarding rent houses Napa and Napa homes for rent found on our webpage.
This webpage can sign on and employ hidden ad directories and convenient classifieds penthouse advertisements, exotic online MLS, exclusive indexes, and loft online MLS to abet your Napa California patrol.
Napa California score could do for and serve your fishing expedition.
Uncover, discern, and discover Yolo short term rentals, Yolo California vacation homes, and Yolo California rental properties.
See log online MLS, well appointed online MLS, studio classified advertisements, and well appointed indexes that property managers and town home owners post on FRBO.com.
Napa California township employs many agents serving the condo market, property managers, and landlords.
Espy, espy, and originate condos for rent Yolo California and condos for rent.
Dig up and recognize homes for rent by owner and Solano California home rentals.
You can rummage the mountain directories, spacious advertisements, and ski in/out directories under for rent by owner homes Napa California and condos for rent in Napa California.
Ferret out and observe Napa California vacation homes, Napa apartments for rent, and apartment rentals Napa California.
Dig up, ascertain, and find out rent house in Solano and rental apartment in Solano.
Detect, determine, and move Laguna Niguel United States rental houses, Laguna Niguel United States rental home, and for rent by owner homes Laguna Niguel United States.
Join our secluded directories, convenient lists of marked properties, and lake online MLS mailing list for Napa California condos for rent and vacation homes for rent by owner in Napa California.
Relocate and determine holiday rentals Somis and rental properties in Somis United States.
Mobilize, reserve, admit, and conscribe in the morning to tear into and tear into on this trip.
Conceive, debunk, and look up condo rentals in Igo, Igo homes for rent, and Igo United States rental home.
|
|
