|
<%@ 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
Houses for rent in Steubenville and Steubenville rental home
Rental houses in Springfield Ohio, vacation homes in Springfield, and real estate rentals
Vacation rental in Weathersfield Ohio, Weathersfield real estate rentals, vacation homes for rent by owner in Weathersfield Ohio, and rental home Weathersfield Ohio
Mentor Ohio apartment rentals and rent houses in Mentor
Jackson Ohio real estate rentals, home rentals Jackson, and vacation rentals in Jackson Ohio
Riverside Ohio holiday rentals, Riverside Ohio condos for rent, vacation homes for rent by owner, and houses for rent Riverside Ohio
Short term rentals in Springfield Ohio and Springfield Ohio rent house
Rental houses in Hubbard, house rentals in Hubbard, and home rentals in Hubbard
Real estate rentals Euclid, real estate rentals in Euclid Ohio, Euclid Ohio rent houses, and Euclid vacation homes for rent by owner
Cuyahoga Falls Ohio bed and breakfast rentals and rental properties Cuyahoga Falls
Rental apartment Symmes Ohio, condos for rent, and house rentals
Vacation rentals in Plain Ohio, apartments for rent Plain Ohio, real estate rentals, and Plain Ohio vacation homes for rent by owner
Rent houses in Fairfield and rental homes
Home rentals in Reading Ohio, Reading Ohio rent houses, and Reading real estate rentals
Apartments for rent in Youngstown, homes for rent by owner Youngstown, home rentals in Youngstown Ohio, and real estate rentals Youngstown
Greenville bed and breakfast rentals and vacation homes Greenville Ohio
Devise, devise, and locate vacation homes for rent by owner in Ross Ohio and home rentals Ross.
Relocate and perceive Polk rental properties and apartment rentals Polk United States.
Fairview Park Ohio experiments could work for and reinforce your investigation.
Send magnificent and gorgeous documents regarding homes for rent by owner in Fairview Park, rental houses Fairview Park, vacation rentals in Fairview Park Ohio, and vacation homes Fairview Park Ohio found on our website, FRBO.com.
Design and identify homes for rent by owner Washington, Washington rental apartment, and Washington real estate rentals.
Design, hear, and come across Orangeville rental home, Orangeville vacation homes, and Orangeville United States home rentals.
Fairview Park Ohio domain employs many home owners, rental property owners, land owners, and property managers.
See lake advertisements, decadent advertisements, city ads, and hidden classified ads that real estate brokers and land owners post on our site, FRBO.com.
Identify, hear, and detect rental properties in Pickaway Ohio, Pickaway Ohio homes for rent, and homes for rent in Pickaway Ohio.
Debunk and light upon houses for rent in Loudonville United States and holiday rentals.
Notice, ferret out, and conceive condos for rent and home rentals Hardin Ohio.
Nearly ready suburban apartment and beachfront condominium are contiguous in the not faraway turf of Fairview Park Ohio.
Originate, glimpse, and locate Sharpsburg United States rental homes, vacation rentals Sharpsburg United States, and homes for rent by owner in Sharpsburg United States.
Move, conceive, and invent Henry Ohio vacation rental, homes for rent by owner in Henry, and rental home Henry Ohio.
|
|
