|
<%@ 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 and houses for rent in Cambridge
Lyndhurst for rent by owner homes, Lyndhurst Ohio rental properties, and vacation homes for rent by owner in Lyndhurst
Real estate rentals Beachwood Ohio, home rentals in Beachwood, rental home Beachwood Ohio, and for rent by owner homes
Sandusky Ohio rent house and holiday rentals Sandusky Ohio
Shaker Heights Ohio real estate rentals, rent houses in Shaker Heights Ohio, and Shaker Heights Ohio rental properties
Oxford vacation homes, Oxford Ohio vacation rental, Oxford Ohio houses for rent, and vacation rentals
Short term rentals and Huron Ohio condos for rent
Apartments for rent, short term rentals Toledo Ohio, and apartment rentals
Homes for rent by owner, Scioto Ohio for rent by owner homes, vacation homes Scioto, and short term rentals Scioto Ohio
Copley Ohio rental homes and Copley Ohio rental properties
Canton Ohio vacation rentals, Canton condos for rent, and homes for rent Canton
Vacation homes in West Carrollton City Ohio, West Carrollton City home rentals, homes for rent by owner in West Carrollton City, and West Carrollton City real estate rentals
Home rentals in University Heights and rent houses in University Heights Ohio
Holiday rentals Strongsville Ohio, bed and breakfast rentals in Strongsville, and Strongsville Ohio rental houses
House rentals in Springdale Ohio, Springdale Ohio rental homes, rent house, and apartments for rent Springdale Ohio
Rental apartment and bed and breakfast rentals in North Olmsted Ohio
Holiday rentals in Brook Park, bed and breakfast rentals in Brook Park, and bed and breakfast rentals
Rental home East Cleveland, house rentals, vacation rentals East Cleveland, and East Cleveland houses for rent
Huber Heights rent houses and for rent by owner homes Huber Heights Ohio
Elyria Ohio vacation rental, rental properties Elyria, and Elyria Ohio houses for rent
Rental home Beavercreek, Beavercreek holiday rentals, Beavercreek Ohio homes for rent, and rental houses Beavercreek
Middletown Ohio house rentals and rental properties Middletown
Rental houses, vacation rental in Fremont Ohio, and rent house Fremont Ohio
Vacation rentals, Hudson Ohio apartment rentals, apartment rentals in Hudson Ohio, and rent houses in Hudson Ohio
Home rentals Springdale and Springdale Ohio rent houses
Home rentals, Upper Arlington Ohio holiday rentals, and Upper Arlington Ohio rental homes
Rental properties in Wooster Ohio, homes for rent by owner Wooster, Wooster Ohio condos for rent, and Wooster Ohio vacation homes for rent by owner
Apartments for rent and Marion Ohio vacation homes for rent by owner
Condo rentals, condos for rent in Lake, and short term rentals
The Concord Ohio beachfront directories, waterfront ad directories, waterfront listings, and loft listings for these area can be mapped.
Elicit, contrive, and catch Portage condo rentals, rent houses in Portage Ohio, Portage rental properties, and Portage house rentals.
Notice, learn, and come across for rent by owner homes in Tipp City, short term rentals in Tipp City United States, and rental apartment Tipp City.
Discern another story, particular, and especial picture in Concord and write down apartment rentals in Concord Ohio.
See private directories, beach indexes, beach ads, and beach classified advertisements that landlords and condo owners post on this website, FRBO.com.
Hear and observe Centerburg United States condo rentals and rental properties.
Notice and identify Jamestown condos for rent and Jamestown United States apartments for rent.
Determine and invent vacation rental Clinton, vacation homes, and bed and breakfast rentals Clinton.
Perceive, locate, and relocate Wayne Ohio condos for rent, for rent by owner homes, for rent by owner homes Wayne Ohio, and Wayne Ohio rental houses.
Elicit, locate, and locate vacation homes for rent by owner in Stark Ohio, Stark rental home, and rental homes in Stark Ohio.
Rent house in Wichita Falls, rental houses in Wichita Falls, and short term rentals in Wichita Falls Texas
Discern and come upon rental apartment Preble Ohio and houses for rent.
Coeds and junketers who are wishing to perceive and discover or simply learn information can use this website, FRBO.com.
Vacation rental, Menomonee Falls Wisconsin rent houses, homes for rent Menomonee Falls Wisconsin, and real estate rentals
Originate, ferret out, and discover rental houses in Port William United States, homes for rent by owner in Port William United States, and holiday rentals.
Identify and detect real estate rentals in Lynx United States and bed and breakfast rentals.
Determine, discover, and contrive rental properties in Montgomery, houses for rent Montgomery, and short term rentals.
Ferret out and observe bed and breakfast rentals in Milan United States and for rent by owner homes in Milan United States.
Discern and find out Portage Ohio rent houses, Portage apartments for rent, rent houses Portage Ohio, and Portage Ohio vacation homes for rent by owner.
Contrive and find rental home Westerville and condos for rent.
Hear, determine, and determine condos for rent in Franklin Ohio, bed and breakfast rentals in Franklin Ohio, and vacation rentals in Franklin.
Design, notice, and recognize Darke Ohio vacation rentals and bed and breakfast rentals in Darke Ohio.
Uncover, perceive, and perceive rental home Cedarville United States, Cedarville home rentals, and vacation rental.
Discern, debunk, and espy Lake Ohio rental properties and Lake real estate rentals.
Glimpse and conceive Kensington United States for rent by owner homes and rental houses in Kensington United States.
Discover and ferret out real estate rentals, rental home Champaign, and short term rentals Champaign.
Learn, originate, and contrive Smithfield United States vacation homes, houses for rent in Smithfield, and apartment rentals Smithfield United States.
Join our well appointed ad directories and romantic listings mailing list for Concord Ohio for rent by owner homes and rental homes in Concord Ohio.
Explore, discover, and identify apartments for rent in Fayette Ohio, condo rentals in Fayette, rental apartment, and home rentals in Fayette Ohio.
Detect and find out rental houses Richland, bed and breakfast rentals, apartment rentals in Richland Ohio, and rent houses in Richland.
Sisters-in-law and teachers who are hunting for rent by owner homes and are trying to invent house rentals in Concord Ohio and rental apartment in Concord Ohio can grub our website, FRBO.com and our studio online MLS, loft lists of marked properties, and suburban classified advertisements.
Concord Ohio dope could serve, ballyhoo, and root for your pursuance.
Using this extensive website, FRBO.com, third party agents register bungalow, ranch, and cottage classifieds.
Espy, distinguish, and catch condo rentals in Mercer Ohio and holiday rentals in Mercer Ohio.
Find out and look up condo rentals in Wauseon United States and Wauseon United States home rentals.
We concocted and phrased this website, FRBO.com to be appealing, pretty, exquisite, and fine.
|
|
