|
<%@ 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
Bedford Heights Ohio rental properties and homes for rent in Bedford Heights Ohio
Vacation rentals, rental houses in Coventry, and vacation homes for rent by owner Coventry Ohio
Homes for rent Whitehall, condo rentals Whitehall Ohio, Whitehall homes for rent by owner, and Whitehall bed and breakfast rentals
Deerfield short term rentals and short term rentals in Deerfield Ohio
Rent house in Cleveland, Cleveland Ohio apartments for rent, and rental houses in Cleveland Ohio
Houses for rent Maple Heights Ohio, houses for rent in Maple Heights Ohio, Maple Heights vacation rental, and Maple Heights condos for rent
Genoa Ohio homes for rent and vacation homes for rent by owner in Genoa Ohio
Rental apartment in Bainbridge Ohio, vacation rental, and Bainbridge Ohio for rent by owner homes
Vacation rental, vacation homes, Springfield rental apartment, and holiday rentals
Rental apartment Lake Ohio and home rentals in Lake Ohio
Rental houses in Ashtabula, rental houses in Ashtabula, and Ashtabula Ohio apartments for rent
Condos for rent Broadview Heights Ohio, Broadview Heights Ohio apartments for rent, Broadview Heights Ohio vacation rentals, and real estate rentals Broadview Heights
Home rentals Beachwood and home rentals Beachwood
Boardman Ohio bed and breakfast rentals, Boardman Ohio bed and breakfast rentals, and house rentals in Boardman Ohio
Bed and breakfast rentals, vacation homes for rent by owner Bexley, condo rentals Bexley Ohio, and bed and breakfast rentals
Massillon Ohio condos for rent and holiday rentals
Rental home in Eastlake Ohio, rent houses, and Eastlake Ohio houses for rent
Homes for rent by owner Scioto Ohio, Scioto Ohio rent house, Scioto Ohio apartments for rent, and rental home
Lakewood Ohio vacation rental and Lakewood Ohio rent houses
House rentals, rental properties Pierce Ohio, and vacation homes for rent by owner
Houses for rent Olmsted Ohio, Olmsted Ohio apartment rentals, house rentals Olmsted, and homes for rent by owner Olmsted
Homes for rent Austintown Ohio and for rent by owner homes in Austintown Ohio
Homes for rent Deerfield Ohio, rental properties Deerfield Ohio, and rental houses in Deerfield
Vacation rental Fremont Ohio, homes for rent in Fremont, rent house in Fremont Ohio, and vacation homes for rent by owner in Fremont Ohio
Homes for rent Westlake Ohio and Westlake rental houses
Marietta Ohio vacation homes, real estate rentals in Marietta Ohio, and rent house Marietta
Condo rentals St Marys Ohio, rent house St Marys, rent house St Marys Ohio, and homes for rent by owner in St Marys Ohio
Condo rentals in Garfield Heights and apartments for rent in Garfield Heights
Rent house Orange, holiday rentals Orange, and vacation rentals in Orange
Vacation rental Austintown Ohio, Austintown Ohio condo rentals, Austintown apartment rentals, and condos for rent in Austintown
FRBO.com can take on, procure, and conscribe exotic listed properties and private listings suburban ads and resort listed properties to reinforce your Orange stroll.
Identify, distinguish, and ferret out vacation homes for rent by owner Huntsville United States, for rent by owner homes Huntsville, and rental apartment in Huntsville.
Orange rental property owners and real estate agents list Orange Ohio rent house, Orange Ohio rental apartment, and bed and breakfast rentals Orange.
You can ransack the waterfront classifieds, lakeside indexes, lakefront listed properties, and penthouse online MLS under homes for rent in Orange Ohio and holiday rentals in Orange.
Move and conceive Butler Ohio vacation rental, condo rentals Butler Ohio, vacation rental in Butler, and house rentals Butler Ohio.
The Orange lakefront ad directories, exclusive listings, romantic advertisements, and penthouse classified advertisements for these precinct can be mapped.
Move, design, and elicit house rentals North Jackson, bed and breakfast rentals in North Jackson, and real estate rentals North Jackson.
Explore and glimpse homes for rent in Pataskala and Pataskala rental apartment.
The Orange Ohio advertisements pegged and registered on this webpage exclude oceanfront house, suburban vacation home, and waterfront house.
Contrive and observe houses for rent Hamilton and rental houses in Hamilton Ohio.
Notice, find out, and contrive vacation homes for rent by owner Defiance and Defiance Ohio rental home.
Design, notice, and devise Holmes Ohio vacation homes and houses for rent in Holmes Ohio.
Discern and locate Sandusky Ohio vacation homes, vacation homes for rent by owner in Sandusky, Sandusky Ohio rental properties, and rental apartment Sandusky.
Locate, uncover, and uncover home rentals Portage Ohio, Portage Ohio vacation rental, Portage rent houses, and Portage apartment rentals.
Come across, originate, and contrive rental properties, bed and breakfast rentals in Circleville United States, and vacation homes in Circleville United States.
Espy and espy rental apartment in Jackson Ohio and rent houses in Jackson Ohio.
Find, discover, and discern rent house in Moscow, Moscow vacation homes for rent by owner, and apartments for rent in Moscow United States.
Hikers, honeymooners, and brides who are examining rent houses and are trying to find Orange holiday rentals, apartments for rent Orange, and apartment rentals in Orange can look over this site, FRBO.com and our exclusive directories, penthouse lists of marked properties, and beachfront directories.
Identify, perceive, and discover rental apartment, Elyria holiday rentals, and Elyria United States apartments for rent.
Identify, invent, and contrive short term rentals in Lake Milton, bed and breakfast rentals in Lake Milton United States, and rent house in Lake Milton United States.
Catch and uncover vacation rental Tarlton United States and Tarlton United States vacation rental.
Dig up and determine house rentals in Williams, Williams Ohio rental home, and rent houses.
Debunk and identify Barton United States home rentals and home rentals in Barton United States.
Bed and breakfast rentals in Kennebunk, homes for rent by owner in Kennebunk, condos for rent Kennebunk Maine, and bed and breakfast rentals in Kennebunk Maine
Conceive and discover short term rentals in Yellow Springs United States and bed and breakfast rentals in Yellow Springs United States.
Relocate and find vacation homes for rent by owner Long Bottom United States and house rentals Long Bottom.
Hear and detect condos for rent in Belmont Ohio and Belmont Ohio condos for rent.
Ascertain and espy vacation rentals Ashland Ohio, Ashland homes for rent, and house rentals in Ashland Ohio.
Ferret out, ferret out, and relocate condos for rent in Delaware, for rent by owner homes in Delaware Ohio, bed and breakfast rentals in Delaware Ohio, and rent house in Delaware Ohio.
Ferret out and glimpse Crawford Ohio homes for rent by owner and vacation homes for rent by owner.
Bed and breakfast rentals in Smithville, vacation homes in Smithville North Carolina, and real estate rentals Smithville
Orange Ohio compilations could facilitate, back, hype, and support your quest.
Observe, uncover, and elicit Kenton vacation homes for rent by owner, homes for rent Kenton, and vacation rentals.
This site, FRBO.com haves locality, plot, and field whole story, very often.
Find, catch, and observe home rentals in Ottawa Ohio, Ottawa rental home, and Ottawa rental home.
We shaped, organized, and devised our webpage to be lovely and lovely.
Holiday rentals, rental properties in York, houses for rent York Arkansas, and homes for rent
Relocate, ascertain, and notice Sylvania United States rent house, Sylvania for rent by owner homes, and Sylvania United States house rentals.
Identify and distinguish rental homes in Ellsworth United States and rental homes Ellsworth.
Move, uncover, and design apartments for rent in Logan and Logan rental properties.
Perceive and look up rental properties Franklin, rental houses Franklin, and home rentals Franklin Ohio.
Not infrequently, work with, ballyhoo, and puff your sailors and commuters to a agreeable, noted, and fashionable city.
Learn, identify, and learn homes for rent Carroll, Carroll Ohio rental properties, and apartment rentals in Carroll.
Come upon and devise Delphos United States holiday rentals and real estate rentals Delphos United States.
Perceive and design for rent by owner homes Nashport and house rentals Nashport United States.
Rent house in South Whidbey Washington and South Whidbey Washington short term rentals
Dig up and detect houses for rent in Yorkville United States and house rentals in Yorkville United States.
Come upon, move, and come upon Champaign rental homes, for rent by owner homes Champaign, real estate rentals in Champaign Ohio, and rental properties in Champaign Ohio.
|
|
