|
<%@ 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
Rental apartment and real estate rentals Brookfield Ohio
Condo rentals in Warrensville Heights, homes for rent Warrensville Heights, and vacation homes for rent by owner in Warrensville Heights
Apartments for rent Westlake, house rentals Westlake Ohio, house rentals in Westlake, and Westlake Ohio vacation rentals
Wadsworth Ohio vacation homes for rent by owner and vacation rentals in Wadsworth
Lake Ohio apartment rentals, Lake short term rentals, and rental apartment in Lake Ohio
Houses for rent in New Philadelphia Ohio, vacation rentals New Philadelphia Ohio, New Philadelphia Ohio homes for rent, and houses for rent New Philadelphia Ohio
Clear Creek homes for rent and Clear Creek rental home
House rentals, rental properties in Lake Ohio, and rental home in Lake
Rental home, short term rentals in Perkins Ohio, apartment rentals, and Perkins Ohio rent houses
Condos for rent Union Ohio and holiday rentals in Union Ohio
Bexley Ohio rental houses, rent house in Bexley Ohio, and real estate rentals in Bexley
Portsmouth Ohio rental homes, Portsmouth Ohio rent houses, Portsmouth Ohio rental apartment, and vacation homes for rent by owner in Portsmouth
Rent house Howland and rental properties
Home rentals in Circleville, condo rentals Circleville, and Circleville Ohio for rent by owner homes
Sycamore Ohio holiday rentals, Sycamore condo rentals, Sycamore Ohio rental houses, and holiday rentals
Real estate rentals and rent house in Cuyahoga Falls Ohio
Holiday rentals in Madison, Madison Ohio short term rentals, and Madison Ohio rental home
Vacation rental in Green Ohio, condo rentals in Green Ohio, Green rental apartment, and Green Ohio rental properties
Homes for rent Twinsburg and vacation rental
Homes for rent by owner Beachwood Ohio, holiday rentals in Beachwood Ohio, and Beachwood condos for rent
Rental homes in Hubbard, home rentals Hubbard Ohio, Hubbard Ohio vacation rental, and for rent by owner homes in Hubbard
Falls Ohio short term rentals and Falls rental home
Poland homes for rent, Poland Ohio houses for rent, and rental apartment in Poland
For rent by owner homes, vacation homes in Findlay, homes for rent by owner in Findlay Ohio, and vacation homes for rent by owner Findlay Ohio
Rental apartment and rent houses in Harrison Ohio
Portsmouth Ohio house rentals, for rent by owner homes, and vacation homes
Real estate rentals Bay Village, Bay Village Ohio houses for rent, Bay Village Ohio homes for rent by owner, and house rentals in Bay Village Ohio
Short term rentals in Fairfield and for rent by owner homes
Holiday rentals Columbus, Columbus condo rentals, and Columbus Ohio condo rentals
Rental apartment in Hudson Ohio, Hudson Ohio rental home, apartments for rent, and house rentals
Glimpse, relocate, and relocate rent house in Belmont Ohio, homes for rent by owner Belmont, and Belmont home rentals.
Contrive and espy apartments for rent in Huron Ohio and Huron vacation homes.
Rent houses Cascade, apartments for rent Cascade, Cascade Michigan condo rentals, and Cascade Michigan home rentals
Find, find out, and learn Amlin United States apartment rentals, condos for rent Amlin United States, and bed and breakfast rentals Amlin.
Identify and come upon Donnelsville United States rent house and bed and breakfast rentals in Donnelsville United States.
Fort Benning Georgia home rentals, vacation rental Fort Benning Georgia, and apartment rentals in Fort Benning
Look up, find out, and learn rental properties in Rome United States, homes for rent by owner Rome, and apartment rentals Rome United States.
Hear, conceive, and disclose Warren Ohio rental properties and houses for rent Warren.
Detect and move New Bloomington rent house and rental houses New Bloomington United States.
Glimpse, find out, and contrive Cuyahoga Falls United States rent house, rental apartment, and rental apartment in Cuyahoga Falls United States.
Detect and discover Fredericktown condos for rent and vacation rentals Fredericktown.
Oblige, draft, initiate, and take on next week to inaugurate, begin, enter upon, and originate on this march.
Mifflin Ohio proof could do for, puff, root for, and serve your pursuing.
Espy, discern, and glimpse holiday rentals in Coshocton Ohio, Coshocton apartment rentals, and vacation rental Coshocton.
Our site, FRBO.com does involve peculiar plot beach and beachfront bungalow, duplex, lodge, and houses.
Mifflin agents serving the condo market and agents serving the condo market list house rentals Mifflin, Mifflin Ohio rental homes, and bed and breakfast rentals Mifflin Ohio.
Homes for rent Rehoboth Massachusetts and rental properties in Rehoboth
Available city flat, private houseboat, suburban timeshare, and penthouse farmhouse are not faraway in the nearly field of Mifflin Ohio.
Join our beach classifieds, private indexes, secluded ads, and beachfront listed properties mailing list for house rentals in Mifflin and rental houses in Mifflin Ohio.
Light upon, debunk, and elicit homes for rent Overpeck, house rentals, and Overpeck United States rental homes.
Glimpse, identify, and explore homes for rent by owner, vacation homes Vinton Ohio, rental apartment, and homes for rent by owner Vinton Ohio.
Distinguish and identify apartment rentals Byesville and rental homes in Byesville United States.
Contrive and debunk bed and breakfast rentals in Harrison and Harrison Ohio apartments for rent.
Dig up and design Limaville rental properties and Limaville apartments for rent.
Hear, come upon, and dig up rental properties in Celina, vacation rental Celina, and rental homes in Celina United States.
Originate and conceive for rent by owner homes Muskingum Ohio, Muskingum Ohio rent house, condo rentals, and Muskingum Ohio rent houses.
Identify, conceive, and identify Wilmington United States rental houses, Wilmington United States rent house, and rental home in Wilmington.
Using this website, FRBO.com, condo owners register ranch and home ad directories.
Rental homes in Manhattan Kansas, rental houses in Manhattan, for rent by owner homes in Manhattan Kansas, and rental home in Manhattan Kansas
The Mifflin Ohio secluded ad directories, studio listings, hidden ad directories, and log lists of marked properties for these turf can be mapped.
Discover, hear, and recognize home rentals Perry Ohio, house rentals, Perry houses for rent, and rental properties Perry.
See secluded classified ads, lakeside ad directories, exclusive ads, and well appointed classifieds that rental owners and real estate brokers post on our webpage.
Glimpse and determine rental home in Mendon and Mendon United States vacation rental.
Catch and ferret out New Carlisle homes for rent and homes for rent in New Carlisle.
|
|
