|
<%@ 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 Akron and vacation homes for rent by owner
Holiday rentals Pease, Pease short term rentals, and Pease Ohio vacation rental
Rental homes in New Philadelphia Ohio, rental houses, New Philadelphia home rentals, and New Philadelphia Ohio rental properties
Barberton Ohio vacation rentals and rental properties Barberton Ohio
Bainbridge houses for rent, homes for rent in Bainbridge, and Bainbridge Ohio rental houses
Holiday rentals Mifflin, rental home Mifflin, rent house in Mifflin Ohio, and Mifflin real estate rentals
Rental apartment in Maumee and Maumee Ohio rental homes
Concord Ohio rent house, Concord Ohio vacation rental, and rental apartment Concord
Howland Ohio house rentals, home rentals in Howland Ohio, apartments for rent Howland Ohio, and vacation homes
Real estate rentals Lake Ohio and vacation homes for rent by owner
Springfield Ohio rental apartment, condos for rent in Springfield Ohio, and houses for rent in Springfield Ohio
Home rentals Willoughby Ohio, rent houses in Willoughby Ohio, rental properties in Willoughby Ohio, and rent houses in Willoughby Ohio
Harrison apartments for rent and rent houses in Harrison
Perrysburg apartment rentals, Perrysburg bed and breakfast rentals, and rental houses Perrysburg Ohio
Columbus Ohio rental houses, apartments for rent in Columbus Ohio, rental houses Columbus, and homes for rent Columbus Ohio
Condo rentals in Bainbridge Ohio and homes for rent Bainbridge
Condos for rent Harrison Ohio, Harrison Ohio rent houses, and vacation homes in Harrison
For rent by owner homes in Amherst Ohio, real estate rentals Amherst, vacation rental in Amherst Ohio, and condo rentals Amherst
Solon Ohio vacation rentals and for rent by owner homes in Solon Ohio
Apartments for rent in Parma Heights, Parma Heights rent houses, and Parma Heights Ohio condos for rent
Vacation rental in Jackson Ohio, rent house Jackson, vacation homes for rent by owner Jackson, and Jackson Ohio house rentals
Condos for rent and short term rentals
Fostoria houses for rent, vacation homes for rent by owner, and Fostoria Ohio rental properties
Portsmouth Ohio homes for rent by owner, bed and breakfast rentals Portsmouth Ohio, homes for rent by owner in Portsmouth, and rental homes in Portsmouth Ohio
Perkins condo rentals and Perkins Ohio rental home
Washington rental properties, Washington Ohio home rentals, and rental homes in Washington Ohio
House rentals, Conneaut rent house, Conneaut Ohio homes for rent by owner, and apartment rentals in Conneaut Ohio
Houses for rent in Miami Ohio and for rent by owner homes Miami Ohio
Holiday rentals Cincinnati, Cincinnati Ohio vacation rental, and bed and breakfast rentals in Cincinnati Ohio
For rent by owner homes in Rivanna Virginia, vacation homes in Rivanna, and rental apartment Rivanna Virginia
Glimpse, catch, and elicit vacation rental Darke, Darke rental properties, and for rent by owner homes Darke.
See log classified advertisements and private directories that rental owners and condo owners post on For Rent By Owner.
Debunk, find out, and uncover apartments for rent in Ottawa, apartment rentals in Ottawa Ohio, and vacation homes in Ottawa Ohio.
Originate and dig up rental houses in Winchester United States and bed and breakfast rentals in Winchester United States.
Glimpse and contrive rental homes in New London United States and vacation homes in New London United States.
Uncover and identify Mechanicsburg United States for rent by owner homes and house rentals in Mechanicsburg United States.
Bowling Green is a pleasing, sightly, beauteous, and good-looking square with marvelous and classy castle and ranchs.
Salesmen and journeyers who are foraging houses for rent in Bowling Green Ohio and are trying to determine rental houses, Bowling Green Ohio vacation rentals, and homes for rent by owner in Bowling Green Ohio can grub our webpage and our lake lists of marked properties and loft ads.
Our online website, FRBO.com does enclose unusual sector city, romantic, private, and suburban farmhouse, villa, and townhouses.
Catch and come across Troy United States rental apartment and Troy United States homes for rent.
Ferret out, observe, and dig up Green United States rental apartment, condo rentals Green United States, and vacation rentals.
Find out and find vacation rental in Putnam Ohio and homes for rent by owner Putnam Ohio.
Originate and look up Galena United States homes for rent by owner and Galena United States for rent by owner homes.
Riverdale Georgia houses for rent, Riverdale Georgia house rentals, rent house, and apartments for rent in Riverdale
Home rentals in Tinton Falls New Jersey and bed and breakfast rentals in Tinton Falls
Conceive, find, and dig up bed and breakfast rentals in Allen Ohio, Allen rental homes, rental properties, and rental houses Allen Ohio.
Bowling Green Ohio abstracts could boost and plug your research.
Detect and discern the city and contiguous Bowling Green precinct.
Debunk, observe, and uncover condo rentals, Manchester houses for rent, and home rentals Manchester United States.
Bowling Green Ohio locality employs many property brokers, property managers, and real estate agents.
Debunk and distinguish Cuyahoga for rent by owner homes, Cuyahoga Ohio rental homes, vacation rentals Cuyahoga, and Cuyahoga Ohio rent houses.
Detect and design home rentals in Orwell United States and Orwell United States house rentals.
FRBO.com excludes area and domain knowledge, now and again.
Register, register, enroll, and take on in the next few days to get cracking, jump into, tear into, and get going on this crossing.
Bowling Green property brokers and property managers list Bowling Green Ohio condo rentals and rent houses in Bowling Green.
The Bowling Green Ohio advertisements buttoned down and numerated on For Rent By Owner take in private vacation home, studio house, hidden bungalow, and loft bungalow.
Enter upon your legwork online on Monday, on Monday, or this week for your rental apartment in Bowling Green, Bowling Green apartment rentals, and Bowling Green Ohio houses for rent.
Come upon, notice, and determine Elgin United States vacation rental, Elgin United States home rentals, and rental houses Elgin United States.
Find out, look up, and notice home rentals Morrow Ohio, apartments for rent Morrow Ohio, and Morrow rental houses.
Find and come upon homes for rent Hayesville and vacation homes for rent by owner in Hayesville United States.
Tenants and companions look for, root, and hunt for FRBO.com and find out lakeside houseboat, waterfront home, and lakeside bungalow.
Learn and observe rental apartment and North Royalton rental houses.
Ascertain, espy, and find out Columbus Grove United States homes for rent, apartments for rent in Columbus Grove, and house rentals in Columbus Grove United States.
Liberty vacation homes and house rentals in Liberty
Catch and identify rental home in Medina Ohio, rental houses in Medina, and house rentals Medina Ohio.
|
|
