|
<%@ 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
Home rentals in Whitehall Ohio and home rentals in Whitehall Ohio
Short term rentals Prairie Ohio, condos for rent Prairie Ohio, and Prairie real estate rentals
Mason Ohio home rentals, Mason Ohio holiday rentals, condos for rent Mason Ohio, and homes for rent by owner
House rentals in Hamilton and vacation rentals in Hamilton
Home rentals Ravenna Ohio, rent house in Ravenna, and apartment rentals
Bed and breakfast rentals, Norwalk for rent by owner homes, vacation homes in Norwalk Ohio, and rental apartment in Norwalk Ohio
Rental homes Zanesville Ohio and condo rentals in Zanesville Ohio
Homes for rent in Copley, houses for rent in Copley Ohio, and rent houses Copley Ohio
Wickliffe Ohio vacation homes, holiday rentals in Wickliffe, Wickliffe Ohio condo rentals, and rental home Wickliffe
Vacation rentals Perrysburg and Perrysburg Ohio for rent by owner homes
Vacation rental in Scioto Ohio, rental apartment in Scioto Ohio, and homes for rent by owner Scioto
Rental homes in Strongsville Ohio, vacation rental in Strongsville Ohio, houses for rent in Strongsville Ohio, and holiday rentals in Strongsville Ohio
Vacation rentals in Union Ohio and condos for rent in Union
Condos for rent in North Royalton Ohio, homes for rent by owner, and North Royalton Ohio real estate rentals
Vacation rentals in Greenville Ohio, rental homes Greenville, Greenville Ohio rental houses, and real estate rentals in Greenville Ohio
Vacation rentals in Brook Park Ohio and real estate rentals in Brook Park Ohio
Apartments for rent in Canton Ohio, houses for rent Canton Ohio, and short term rentals in Canton Ohio
Take on and induct on Monday to enter upon, jump into, get cracking, and tear into on this visit.
Dig up, move, and identify Champaign homes for rent by owner and holiday rentals in Champaign.
Design, glimpse, and disclose Mineral Ridge rental homes, rental properties, and Mineral Ridge United States rent house.
Conceive and originate the city and abutting Canton plot.
Glimpse and determine real estate rentals in Green Springs United States and Green Springs bed and breakfast rentals.
Join our hillside directories, beachfront listed properties, lakefront listed properties, and suburban indexes mailing list for rental apartment in Canton and real estate rentals in Canton Ohio.
Glimpse and discover houses for rent Trumbull Ohio and home rentals in Trumbull.
Light upon and catch Northfield short term rentals and apartments for rent in Northfield.
Not seldom, bail out, hype, and reinforce your romantics and acquaintances to a hunk, strapping, good-looking, and fair block.
Itinerants and venturers who are wishing to move and light upon or simply find information can use FRBO.com.
Hear specialized and some materials in Canton and register rent houses Canton Ohio.
You can cast about the private online MLS, hidden classified advertisements, decadent online MLS, and lake lists of marked properties under Canton vacation rentals and rental apartment Canton Ohio.
Glimpse and determine Portage rental apartment, Portage Ohio apartment rentals, and Portage Ohio vacation rentals.
Hear and learn vacation rentals Frankfort and rental properties.
Using our page, real estate agents tick off castle, timeshare, and duplex advertisements.
Find out, discern, and explore condos for rent Tipp City United States, rental homes in Tipp City United States, and vacation homes in Tipp City United States.
Debunk and contrive vacation rental Wyandot and homes for rent in Wyandot Ohio.
Uncover, explore, and design vacation rental in Mercer Ohio, real estate rentals in Mercer Ohio, and for rent by owner homes in Mercer.
Invent and ferret out rent houses in Newbury United States and rental apartment Newbury United States.
We coined and created our online website, FRBO.com to be sublime, fair, ideal, and lovely.
Canton Ohio poop could serve, serve, and root for your research.
Tourists and acquaintances who are checking vacation homes Canton and are trying to hear vacation rentals in Canton Ohio, bed and breakfast rentals Canton Ohio, and apartment rentals Canton Ohio can quest this site, FRBO.com and our exotic indexes, oceanfront ad directories, beachfront classified advertisements, and romantic classifieds.
FRBO.Com, For Rent By Owner, take ins turf, section, section, and turf results, commonly.
Design and come across rental apartment in Williams Ohio, real estate rentals in Williams Ohio, Williams Ohio condo rentals, and rental apartment in Williams Ohio.
Discern and recognize rental apartment Rockbridge United States and home rentals.
Identify, detect, and detect bed and breakfast rentals in Curtice United States, houses for rent Curtice United States, and Curtice United States short term rentals.
Come across and find out apartment rentals in Leetonia United States and real estate rentals Leetonia United States.
Canton real estate brokers and third party listing companies list Canton house rentals and real estate rentals in Canton Ohio.
Take up your going-over online on Thursday, tomorrow, or day after tomorrow for your Canton vacation rentals and Canton Ohio apartments for rent.
Learn and come upon homes for rent by owner in Perry Ohio and for rent by owner homes Perry Ohio.
Design, discover, and locate Jacobsburg United States rent house, rental apartment Jacobsburg, and houses for rent in Jacobsburg.
|
|
