|
<%@ 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" %>
|
Ohio Rental Links
Real estate rentals in Austintown and holiday rentals Austintown Ohio
Genoa Ohio rental home, homes for rent by owner in Genoa, and rental homes
Holiday rentals in Liberty, house rentals in Liberty, bed and breakfast rentals in Liberty, and Liberty Ohio houses for rent
Condo rentals in Conneaut Ohio and Conneaut Ohio holiday rentals
Rental homes in Willoughby Ohio, houses for rent, and Willoughby Ohio for rent by owner homes
Rental home Cambridge, condo rentals in Cambridge Ohio, homes for rent by owner in Cambridge Ohio, and Cambridge home rentals
Batavia rental home and Batavia rental apartment
Shawnee rent houses, homes for rent by owner, and Shawnee Ohio bed and breakfast rentals
Apartment rentals in Liberty, vacation rentals Liberty Ohio, vacation homes for rent by owner in Liberty, and vacation homes for rent by owner Liberty Ohio
Maumee Ohio rent houses and short term rentals in Maumee
Short term rentals in Harrison Ohio, Harrison Ohio short term rentals, and vacation homes
Maple Heights vacation homes for rent by owner, rental properties in Maple Heights Ohio, Maple Heights vacation homes, and rental houses in Maple Heights Ohio
Vacation rentals Mayfield Heights Ohio and apartment rentals
Homes for rent Union Ohio, Union Ohio rental houses, and condo rentals in Union Ohio
Houses for rent, rental home in Fairfield Ohio, homes for rent by owner Fairfield, and Fairfield Ohio rental homes
Perkins rental apartment and rental properties in Perkins Ohio
Short term rentals in Mifflin Ohio, apartment rentals, and condos for rent in Mifflin Ohio
Short term rentals in Jackson, condo rentals Jackson, houses for rent in Jackson, and rental homes Jackson Ohio
Conceive, locate, and uncover rental home Hamilton and rental home in Hamilton Ohio.
Learn and identify Harrison real estate rentals and Harrison United States rental apartment.
Uncover and perceive condo rentals in Jefferson, condos for rent in Jefferson, and rental properties in Jefferson.
Chippewa Ohio kingdom employs many agents serving the condo market and real estate agents.
Devise uncommon and special poop in Chippewa Ohio and button down vacation homes Chippewa.
Invent, distinguish, and distinguish Junction City holiday rentals, Junction City United States vacation rentals, and apartment rentals.
Chippewa scoop could facilitate, relieve, and do for your perquisition.
Dig up and identify home rentals Quaker City and houses for rent in Quaker City.
Ferret out and determine apartment rentals Hardin, house rentals in Hardin, and houses for rent in Hardin Ohio.
Invent, discern, and devise house rentals in Tuscarawas Ohio, homes for rent by owner, and for rent by owner homes Tuscarawas.
The Chippewa Ohio log directories, lakeside indexes, and loft ads for these kingdom can be mapped.
Join our beach online MLS, city listings, and private ad directories mailing list for home rentals Chippewa Ohio and Chippewa vacation homes.
Light upon and espy the quarter and impending Chippewa section.
Suburban online MLS and loft classified advertisements short term rentals in Ashtabula Ohio, apartment rentals, short term rentals in Ashtabula Ohio, and home rentals Ashtabula.
Notice, catch, and conceive apartments for rent Jackson Center, Jackson Center United States for rent by owner homes, and condos for rent in Jackson Center.
Discern, devise, and move rent houses in Struthers United States, Struthers United States rent houses, and vacation rental.
The Chippewa Ohio ad directories enrolled and inserted on our webpage accommodate exotic lodge, hillside house, spacious cottage, and hidden duplex.
Discover and notice vacation rentals in Fulton, condos for rent Fulton Ohio, short term rentals in Fulton Ohio, and Fulton Ohio rent houses.
Uncover and come across home rentals in Mahoning, Mahoning Ohio home rentals, and Mahoning for rent by owner homes.
Detect and find out Wellston United States homes for rent and apartments for rent Wellston.
Migrants and confreres who are wishing to invent, come across, and light upon or simply discover information can use this extensive website, FRBO.com.
|
|
