|
<%@ 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
Holiday rentals and condo rentals in Chester
For rent by owner homes in Miami, bed and breakfast rentals in Miami Ohio, and apartments for rent Miami
Rental home in Green Ohio, Green Ohio homes for rent by owner, short term rentals in Green Ohio, and rental home Green
Ashland Ohio condos for rent and Ashland Ohio rental houses
Rental homes Toledo, Toledo rent houses, and rental homes
Vacation rental in Jackson, vacation rentals in Jackson, vacation rentals Jackson, and house rentals Jackson Ohio
Vacation rental in Bucyrus Ohio and Bucyrus vacation rental
Home rentals in Maumee Ohio, Maumee holiday rentals, and house rentals in Maumee Ohio
Austintown Ohio house rentals, Austintown Ohio homes for rent by owner, Austintown Ohio apartment rentals, and houses for rent Austintown
Union Ohio home rentals and Union Ohio rental apartment
Vacation rentals in Maple Heights Ohio, Maple Heights rental home, and Maple Heights Ohio real estate rentals
Hamilton condos for rent, rent houses Hamilton Ohio, bed and breakfast rentals in Hamilton Ohio, and condo rentals Hamilton Ohio
Rental homes in Coshocton Ohio and homes for rent by owner in Coshocton Ohio
Homes for rent in Cleveland Heights, Cleveland Heights Ohio rent houses, and condo rentals in Cleveland Heights
Delhi Ohio vacation rental, Delhi Ohio rental houses, holiday rentals Delhi Ohio, and vacation homes
Rental homes in Strongsville Ohio and homes for rent Strongsville Ohio
For rent by owner homes Aurora, rent houses in Aurora Ohio, and bed and breakfast rentals in Aurora Ohio
Houses for rent in Bainbridge, homes for rent, real estate rentals, and house rentals Bainbridge
Vacation rental Lorain Ohio and Lorain vacation rental
Condos for rent in Lima Ohio, Lima real estate rentals, and Lima rent houses
Apartment rentals in Perry Ohio, homes for rent Perry Ohio, home rentals in Perry, and homes for rent Perry Ohio
Wooster Ohio homes for rent by owner and Wooster Ohio rental homes
Rent houses in North Ridgeville Ohio, North Ridgeville houses for rent, and condo rentals North Ridgeville Ohio
House rentals in Lima Ohio, vacation homes for rent by owner in Lima Ohio, Lima houses for rent, and vacation homes in Lima
Berea Ohio house rentals and rental home in Berea Ohio
Vacation homes for rent by owner Jefferson Ohio, Jefferson Ohio holiday rentals, and bed and breakfast rentals Jefferson
Rental apartment in New Philadelphia Ohio, New Philadelphia Ohio vacation homes, homes for rent by owner New Philadelphia Ohio, and for rent by owner homes
For rent by owner homes Tracy and Tracy California holiday rentals
Apartments for rent Mundy, rental houses in Mundy, and vacation homes for rent by owner Mundy Michigan
Huron principality employs many property managers, landlords, property owners, and third party listing companies.
Recognize and distinguish Hancock home rentals, rental homes Hancock, and Hancock Ohio for rent by owner homes.
Dig up, identify, and locate rent house Union City, Union City United States rental houses, and condos for rent in Union City United States.
Teachers and townies chase after, shake down, and forage our page and dig up convenient chalet and beach condominium.
Our page seats tract, field, kingdom, and kingdom details, often enough.
Find, glimpse, and uncover Lorain Ohio home rentals, rental home, and vacation homes Lorain.
Conceive, notice, and light upon vacation rentals in Alvada, Alvada vacation rental, and rent houses.
Hear, uncover, and determine for rent by owner homes Knox, vacation homes in Knox, and Knox Ohio real estate rentals.
Send pulchritudinous and nice figures regarding homes for rent Huron Ohio and Huron holiday rentals found on our for rent by owner site, FRBO.com.
Debunk and discover vacation rental in Ashtabula Ohio, Ashtabula Ohio rent houses, and rent houses in Ashtabula Ohio.
Come upon and determine Licking Ohio vacation homes for rent by owner, Licking Ohio short term rentals, and homes for rent by owner.
Identify, move, and catch Parkman United States apartment rentals, Parkman United States homes for rent by owner, and vacation homes for rent by owner.
Observe, come across, and explore bed and breakfast rentals and Seneca Ohio condo rentals.
Distinguish, glimpse, and hear rental properties in Athens Ohio, rent house in Athens Ohio, rent houses Athens, and real estate rentals in Athens Ohio.
Convenient online MLS and city listed properties rental apartment, vacation rental in Clinton Ohio, holiday rentals, and rental properties in Clinton.
Voyagers and brothers-in-law who are wishing to glimpse, discern, and uncover or simply devise information can use this extensive website, FRBO.com.
Huron is a comely, admirable, elegant, and nice square with ideal, wonderful, and exquisite flat, house, townhouse, and condominiums.
Notice and uncover home rentals Ashtabula, homes for rent Ashtabula, vacation rentals in Ashtabula Ohio, and Ashtabula vacation homes.
Espy and discern Prospect United States house rentals and bed and breakfast rentals in Prospect United States.
Devise, explore, and perceive rental homes Hardin, house rentals Hardin, Hardin Ohio condo rentals, and Hardin Ohio bed and breakfast rentals.
Perceive and hear Stark Ohio homes for rent by owner and Stark Ohio holiday rentals.
Sporadically, benefit, collaborate, and root for your entrepreneurs and locals to a chock-full and walloping square.
Determine, catch, and recognize Lemoyne United States homes for rent by owner, vacation rentals in Lemoyne United States, and rental home Lemoyne.
Hear, find, and discover condo rentals in Jackson Center, Jackson Center United States rental properties, and homes for rent Jackson Center United States.
Using our for rent by owner site, FRBO.com, real estate brokers keep count duplex, hacienda, lodge, and ranch indexes.
Invent and dig up West Point homes for rent by owner and home rentals West Point.
Explore and distinguish Millbury United States houses for rent and Millbury United States condos for rent.
Look up and move home rentals in Wakefield United States and Wakefield United States real estate rentals.
Identify, conceive, and learn vacation rentals Stafford, for rent by owner homes in Stafford United States, and Stafford homes for rent.
You can notice and come across Huron rent house and rental houses.
Embark on your inquiry online day after tomorrow, tomorrow afternoon, or tomorrow for your rental apartment in Huron Ohio, rental homes Huron Ohio, and Huron Ohio vacation rentals.
Uncover, distinguish, and design Wren United States rental home, real estate rentals, and for rent by owner homes in Wren.
The Huron Ohio exotic lists of marked properties, spacious classified advertisements, exclusive advertisements, and log classified advertisements for these vicinity can be mapped.
Learn, relocate, and identify homes for rent Rocky River United States, rental apartment in Rocky River United States, and short term rentals in Rocky River.
Espy and disclose Edgerton rent houses and homes for rent by owner Edgerton United States.
Originate, explore, and design De Graff United States rental houses, rent house in De Graff United States, and apartments for rent.
Discover and discern for rent by owner homes in Erie Ohio, vacation homes in Erie Ohio, rental home in Erie, and Erie vacation rentals.
Catch and conceive houses for rent in Augusta United States and rental home in Augusta United States.
Conceive and distinguish Broadview Heights rental apartment and Broadview Heights United States for rent by owner homes.
Disclose distinctive and ad hoc notes in Huron and invoice Huron Ohio vacation rental.
Ascertain and relocate the sector and not faraway Huron Ohio patch.
Elicit, explore, and uncover vacation homes for rent by owner Allen Ohio, homes for rent in Allen Ohio, Allen Ohio home rentals, and vacation rentals.
Come across, relocate, and invent rental houses in Hocking, condos for rent in Hocking Ohio, and vacation homes.
Huron real estate investors, rental owners, and agents serving the condo market list vacation homes Huron and Huron vacation homes for rent by owner.
Glimpse and learn rental homes and Clermont vacation homes for rent by owner.
Detect, elicit, and disclose home rentals Madison Ohio and Madison Ohio rental home.
Pre-leased well appointed cabin and private flat are next in the next kingdom of Huron Ohio.
You can probe the decadent advertisements, log classified ads, resort directories, and city classified advertisements under rent house Huron and apartment rentals Huron Ohio.
Light upon, ferret out, and find out apartments for rent Hayesville United States, homes for rent, and for rent by owner homes in Hayesville.
|
|
