|
<%@ 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
Homes for rent Scioto Ohio and Scioto houses for rent
Vacation homes for rent by owner in Perrysburg Ohio, Perrysburg Ohio vacation rentals, and Perrysburg bed and breakfast rentals
Brooklyn Ohio short term rentals, Brooklyn rental apartment, Brooklyn Ohio real estate rentals, and rental houses Brooklyn
Greenville Ohio apartments for rent and Greenville home rentals
Streetsboro Ohio real estate rentals, vacation rental in Streetsboro Ohio, and Streetsboro home rentals
Hubbard Ohio rent houses, Hubbard Ohio home rentals, rental properties Hubbard Ohio, and Hubbard Ohio rent houses
Apartments for rent Vandalia and Vandalia Ohio holiday rentals
Short term rentals in Bucyrus Ohio, Bucyrus Ohio house rentals, and homes for rent by owner in Bucyrus Ohio
Anderson Ohio for rent by owner homes, Anderson Ohio holiday rentals, vacation rentals in Anderson Ohio, and homes for rent by owner in Anderson
Vacation rental Perry Ohio and rent house
Houses for rent in East Liverpool Ohio, homes for rent in East Liverpool Ohio, and holiday rentals East Liverpool Ohio
Rent houses, rental properties in Circleville Ohio, rental homes, and Circleville Ohio vacation homes
Apartments for rent Olmsted and Olmsted Ohio rental properties
Rental apartment in Richmond Heights Ohio, rental homes in Richmond Heights, and Richmond Heights rental home
Rent houses Mifflin Ohio, Mifflin Ohio rental homes, condo rentals in Mifflin, and Mifflin real estate rentals
Sycamore apartments for rent and Sycamore Ohio vacation homes
Norton apartment rentals, rent house Norton, and houses for rent in Norton
Move, move, and design houses for rent Amelia United States, Amelia United States vacation rental, and for rent by owner homes Amelia.
Identify, disclose, and glimpse Henry vacation homes, home rentals, and for rent by owner homes in Henry Ohio.
Observe, elicit, and recognize the turf and immediate Geneva township.
The Geneva Ohio log classified advertisements, well appointed listed properties, well appointed advertisements, and decadent classified ads for these square can be mapped.
Originate and elicit Minford rental apartment and rental apartment in Minford United States.
Our site, FRBO.com holds city and stretch poop sheet, oft.
Discern, detect, and come across vacation homes Ottawa and real estate rentals Ottawa.
See resort classifieds and loft online MLS that landlords and property managers post on our page.
You can scrutinize the secluded listings, well appointed listed properties, beachfront lists of marked properties, and lake classified ads under vacation homes and apartments for rent.
Perceive and observe real estate rentals Huntsburg United States and Huntsburg United States bed and breakfast rentals.
Learn, espy, and identify rent house, Saint Marys United States rental properties, and Saint Marys condo rentals.
Initiate and recruit tomorrow afternoon to initiate, tear into, embark on, and launch on this pilgrimage.
Conceive and identify Maximo United States short term rentals and vacation rental Maximo.
Ferret out and uncover rental apartment in Monroe Ohio and real estate rentals Monroe.
Look up and ascertain for rent by owner homes in Seneca and vacation rentals in Seneca Ohio.
Using FRBO.com, property owners peg townhouse, timeshare, bungalow, and bungalow online MLS.
Design and catch homes for rent by owner in Fayette Ohio, Fayette Ohio homes for rent by owner, and rental apartment in Fayette Ohio.
The Geneva indexes run down and particularized on FRBO.com incorporate hidden farmhouse and lake bungalow.
Come upon, find out, and relocate bed and breakfast rentals Clermont, homes for rent by owner in Clermont, and homes for rent Clermont Ohio.
Tourists, drifters, and itinerants who are wishing to come across, hear, and design or simply relocate information can use this extensive website, FRBO.com.
Open your scrutiny online tonight, tomorrow afternoon, day after tomorrow, or on Friday for your Geneva Ohio home rentals and apartment rentals Geneva.
|
|
