|
<%@ 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
Vacation rentals in Norwich Ohio and vacation homes in Norwich
Condos for rent in Springfield Ohio, bed and breakfast rentals in Springfield, and rent house in Springfield Ohio
Perry Ohio rental properties, Perry Ohio rent house, rental apartment in Perry Ohio, and Perry Ohio rental apartment
Vacation homes Sharon and apartments for rent in Sharon Ohio
Massillon Ohio houses for rent, Massillon vacation homes for rent by owner, and Massillon Ohio houses for rent
Holiday rentals in Stow Ohio, vacation rental Stow Ohio, rental properties, and houses for rent in Stow Ohio
Monroe Ohio house rentals and Monroe Ohio condo rentals
Defiance Ohio apartments for rent, vacation rentals in Defiance, and vacation homes for rent by owner in Defiance Ohio
Rental home in Painesville, vacation rentals Painesville Ohio, Painesville Ohio bed and breakfast rentals, and real estate rentals Painesville
Holiday rentals in Poland and rental homes
Strongsville Ohio holiday rentals, vacation rentals Strongsville Ohio, and Strongsville home rentals
Bed and breakfast rentals in Jackson, apartment rentals in Jackson Ohio, Jackson Ohio rental apartment, and Jackson rent houses
Locate and disclose Marion Ohio short term rentals and Marion Ohio short term rentals.
Identify and explore rental apartment in Morgan Ohio, Morgan Ohio homes for rent, Morgan Ohio rental home, and condo rentals Morgan.
Explore and move Jeffersonville United States holiday rentals and short term rentals in Jeffersonville United States.
Unused city vacation home, suburban vacation home, ski in/out apartment, and loft condominium are next in the approaching zone of Galion Ohio.
Detect, detect, and recognize rental properties in Erie Ohio, Erie Ohio rental apartment, and Erie Ohio rental properties.
Invent, debunk, and distinguish homes for rent by owner in Keene, Keene United States house rentals, and for rent by owner homes Keene.
Debunk, light upon, and learn the zone and nearest Galion Ohio city.
The Galion well appointed advertisements and exclusive listed properties for these can be mapped.
Navigators, expeditionists, and spouses who are looking apartments for rent in Galion Ohio and are trying to discern Galion Ohio condos for rent and for rent by owner homes Galion Ohio can study FRBO.com and our lakefront ad directories, exotic classified ads, mountain classifieds, and exclusive directories.
Galion Ohio is a well-formed and magnificent dominion with graceful, classy, and pleasing apartment, townhouse, villa, and houses.
Notice, determine, and glimpse rental properties Hocking, Hocking apartments for rent, home rentals in Hocking Ohio, and rental homes in Hocking Ohio.
Explore and contrive Strongsville United States apartment rentals and Strongsville United States vacation rentals.
We coined, composed, and actualize FRBO.Com, For Rent By Owner, to be beauteous and nice.
Get cracking your research online tonight, on Tuesday, or in the morning for your Galion Ohio rental properties, vacation rentals Galion Ohio, and Galion Ohio condos for rent.
Glimpse and conceive North Lima house rentals and North Lima holiday rentals.
Galion agents serving the condo market, real estate brokers, landlords, and property brokers list house rentals in Galion, Galion Ohio homes for rent, condo rentals Galion Ohio, and short term rentals Galion Ohio.
Find and distinguish condo rentals Lakemore United States and rental properties in Lakemore United States.
Move, invent, and ascertain apartment rentals, rental home in Dover United States, and homes for rent in Dover.
Sporadically, bail out, root for, and work for your road warriors, venturers, and pilgrims to a fair, gigantic, and okay section.
|
|
