|
<%@ 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 in Stow and home rentals Stow
Aurora Ohio rental properties, apartment rentals in Aurora, and Aurora apartment rentals
Home rentals in Maple Heights Ohio, Maple Heights Ohio vacation homes, bed and breakfast rentals Maple Heights Ohio, and for rent by owner homes in Maple Heights Ohio
Vacation homes in Kent Ohio and homes for rent by owner in Kent Ohio
Vacation rentals in Newark Ohio, rental houses Newark Ohio, and Newark houses for rent
Rent houses Fremont Ohio, Fremont Ohio homes for rent by owner, vacation homes for rent by owner Fremont Ohio, and vacation rentals Fremont Ohio
Vacation rental Greenville Ohio and rental home Greenville
North Royalton Ohio vacation rentals, homes for rent North Royalton Ohio, and North Royalton Ohio apartment rentals
Parma Heights Ohio vacation homes for rent by owner, Parma Heights Ohio apartments for rent, apartments for rent in Parma Heights, and Parma Heights Ohio vacation rental
Anderson Ohio vacation rentals and rental houses in Anderson Ohio
Short term rentals in Weathersfield Ohio, vacation rentals in Weathersfield Ohio, and vacation rental in Weathersfield
Newark apartment rentals, short term rentals in Newark Ohio, homes for rent by owner in Newark Ohio, and rental home
Rental apartment in Chester Ohio and Chester Ohio house rentals
Apartment rentals in Bath, vacation homes in Bath Ohio, and Bath Ohio short term rentals
Madison bed and breakfast rentals, for rent by owner homes in Madison, Madison vacation rentals, and real estate rentals Madison Ohio
Wadsworth Ohio rental homes and houses for rent
Rent house Canton Ohio, homes for rent in Canton Ohio, and condos for rent
Rent house, home rentals Saybrook, Saybrook Ohio rental apartment, and condo rentals
Perceive, ferret out, and light upon homes for rent Ashtabula Ohio and houses for rent in Ashtabula.
Road warriors, hikers, and buddies who are wishing to glimpse, catch, and espy or simply dig up information can use our site, FRBO.com.
Disclose and observe Green Springs short term rentals and short term rentals in Green Springs United States.
Relocate and catch rental homes and real estate rentals Sebring United States.
Using our webpage, landlords write down lodge, timeshare, villa, and flat classifieds.
We fabricated, organized, and fabricated this extensive website, FRBO.com to be handsome and graceful.
Espy, learn, and originate Vanlue United States houses for rent, rental apartment, and Vanlue apartments for rent.
Determine unusual, uncommon, and several testimony in Parma Heights Ohio and record condos for rent in Parma Heights.
Our for rent by owner website can draft, oblige, enroll, and incorporate log indexes and private advertisements lakeside directories, beach ads, suburban listed properties, and well appointed classifieds to stump your Parma Heights Ohio trek.
Conceive, light upon, and locate homes for rent in Vinton and houses for rent Vinton Ohio.
Contrive, discover, and hear vacation rentals Raymond United States, Raymond United States for rent by owner homes, and condo rentals Raymond United States.
Discover and move rental home in New Bremen United States and New Bremen United States for rent by owner homes.
Elicit, find out, and glimpse Summit Station United States short term rentals, for rent by owner homes in Summit Station United States, and bed and breakfast rentals.
You can ferret the beach directories, mountain ads, waterfront classified advertisements, and exclusive listed properties under apartments for rent in Parma Heights, Parma Heights Ohio apartments for rent, and vacation rentals in Parma Heights.
Identify, glimpse, and detect Holmes Ohio vacation homes for rent by owner, Holmes rental houses, Holmes Ohio apartment rentals, and vacation rental Holmes.
Elicit, explore, and light upon Cuyahoga Falls houses for rent, Cuyahoga Falls United States apartments for rent, and real estate rentals in Cuyahoga Falls.
Discern and detect rental apartment in Morrow, Morrow Ohio apartment rentals, bed and breakfast rentals Morrow, and apartment rentals.
Parma Heights Ohio is a pulchritudinous and handsome city with symmetrical, superb, and statuesque chalet, home, farmhouse, and ranchs.
Identify, design, and find out Meigs rental houses, Meigs Ohio rent houses, apartment rentals in Meigs Ohio, and Meigs Ohio apartments for rent.
Glimpse, find out, and move Avon Lake rent houses, real estate rentals in Avon Lake United States, and vacation rental Avon Lake United States.
You can hear and look up condos for rent in Parma Heights Ohio, house rentals in Parma Heights Ohio, and Parma Heights rental home.
|
|
