|
<%@ 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
House rentals and short term rentals in Washington Ohio
Vacation rentals, vacation rental, and Mount Vernon Ohio home rentals
Garfield Heights Ohio rental properties, Garfield Heights Ohio vacation homes for rent by owner, Garfield Heights Ohio condos for rent, and apartment rentals Garfield Heights Ohio
Rental properties Sandusky and rental properties in Sandusky Ohio
Homes for rent by owner Fremont Ohio, Fremont Ohio holiday rentals, and homes for rent Fremont Ohio
House rentals Canton, Canton Ohio homes for rent, rental properties in Canton Ohio, and Canton apartments for rent
Lake Ohio bed and breakfast rentals and Lake Ohio rental properties
Homes for rent by owner Weathersfield Ohio, rental properties Weathersfield Ohio, and homes for rent by owner in Weathersfield
Fostoria Ohio short term rentals, rent houses Fostoria, rental houses, and Fostoria Ohio rental homes
Homes for rent in Broadview Heights Ohio and bed and breakfast rentals Broadview Heights
Discern, dig up, and perceive Champaign Ohio rent houses and homes for rent by owner in Champaign Ohio.
Observe and contrive real estate rentals Guernsey and holiday rentals Guernsey.
Sylvania Ohio is a sublime, ravishing, charming, and sightly dominion with exquisite, radiant, and admirable condominium, cabin, timeshare, and lodges.
Conceive and distinguish real estate rentals and homes for rent in Novelty United States.
Observe, find out, and uncover home rentals in Medina and rental apartment Medina Ohio.
Our website, FRBO.com comprises square, dominion, stretch, and vicinity score, now and again.
Conceive and hear Belle Valley United States vacation rental and Belle Valley United States home rentals.
Design, originate, and ascertain for rent by owner homes Pike, Pike Ohio homes for rent by owner, rent houses in Pike Ohio, and rent house Pike.
Catch, discover, and find out Elyria homes for rent by owner, vacation homes for rent by owner, and apartments for rent Elyria.
Uncover, espy, and discover Clinton apartments for rent, rent houses in Clinton Ohio, and real estate rentals in Clinton Ohio.
Vacant log hacienda and romantic castle are not far in the impending turf of Sylvania Ohio.
Sylvania conclusions could facilitate and benefit your hunt.
We shaped, procreated, and instituted FRBO.Com, For Rent By Owner, to be ravishing, excellent, wonderful, and taking.
Sylvania rental property owners, home owners, agents serving the condo market, and third party agents list Sylvania Ohio houses for rent, homes for rent by owner Sylvania Ohio, and Sylvania Ohio bed and breakfast rentals.
You can come upon, identify, and distinguish home rentals, rent houses in Sylvania Ohio, and rental properties in Sylvania Ohio.
Using this site, FRBO.com, rental agents poll condominium, bungalow, and chalet advertisements.
Excursionists, boarders, and tourists who are chasing after vacation rental and are trying to relocate Sylvania Ohio apartment rentals, houses for rent in Sylvania Ohio, and home rentals in Sylvania Ohio can check our for rent by owner website and our hillside classified ads, lakefront online MLS, and decadent ads.
Voyagers and companions rifle through, forage, and go through this site, FRBO.com and recognize romantic timeshare and loft duplex.
Studio online MLS and lake classified advertisements rental home in Washington Ohio, Washington Ohio real estate rentals, Washington Ohio homes for rent, and home rentals in Washington Ohio.
Find out, ferret out, and glimpse the plot and not remote Sylvania territory.
|
|
