|
<%@ 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
Akron holiday rentals and condo rentals Akron
Bed and breakfast rentals Willoughby, rental properties in Willoughby Ohio, and house rentals in Willoughby
Home rentals in Oxford Ohio, for rent by owner homes in Oxford, Oxford rental home, and condo rentals Oxford
Sharon Ohio real estate rentals and Sharon Ohio homes for rent by owner
Rent house in Eastlake Ohio, Eastlake Ohio homes for rent by owner, and home rentals in Eastlake Ohio
Rental properties in Lake Ohio, houses for rent in Lake Ohio, homes for rent in Lake Ohio, and rent house
Rental apartment Strongsville and for rent by owner homes
Apartments for rent Dover Ohio, condos for rent, and houses for rent Dover Ohio
Bay Village Ohio rental home, rental apartment in Bay Village Ohio, Bay Village Ohio rental apartment, and vacation homes for rent by owner in Bay Village
Apartments for rent Springfield Ohio and real estate rentals in Springfield Ohio
Lyndhurst Ohio rental properties, Lyndhurst Ohio condos for rent, and rent house in Lyndhurst Ohio
Apartment rentals in Tallmadge Ohio, rental home in Tallmadge Ohio, condos for rent Tallmadge Ohio, and home rentals Tallmadge
Condo rentals Chippewa Ohio and Chippewa home rentals
Tiffin house rentals, Tiffin Ohio holiday rentals, and Tiffin Ohio bed and breakfast rentals
Rental properties, real estate rentals Norwalk, Norwalk Ohio home rentals, and Norwalk Ohio apartments for rent
Rental properties Madison Ohio and vacation rental in Madison Ohio
Rental home Green Ohio, rent houses in Green Ohio, and real estate rentals in Green Ohio
Bed and breakfast rentals in Poland, rental apartment in Poland Ohio, vacation homes Poland, and rental houses
Condo rentals and condo rentals in Anderson Ohio
Holiday rentals in South Euclid Ohio, South Euclid Ohio condo rentals, and South Euclid Ohio vacation rentals
Rental home, condo rentals in East Liverpool Ohio, house rentals in East Liverpool Ohio, and vacation rentals in East Liverpool Ohio
Napoleon Ohio real estate rentals and Napoleon Ohio rent houses
Concord Ohio rental houses, Concord Ohio rental properties, and rent houses in Concord Ohio
Brook Park Ohio condo rentals, Brook Park Ohio vacation rentals, Brook Park Ohio homes for rent, and Brook Park for rent by owner homes
Garfield Heights Ohio real estate rentals and condos for rent in Garfield Heights Ohio
Upper Ohio rental home, homes for rent in Upper Ohio, and vacation rentals
The Weathersfield indexes enumerated and buttoned down on this website, FRBO.com accommodate loft timeshare, exotic lodge, exclusive duplex, and mountain villa.
Detect and move rental houses Pomeroy United States and bed and breakfast rentals Pomeroy.
Discover, detect, and observe Gypsum houses for rent, bed and breakfast rentals, and Gypsum vacation homes.
Invent, conceive, and uncover vacation rental Mc Comb, Mc Comb United States real estate rentals, and vacation homes for rent by owner in Mc Comb United States.
Explorers and passengers who are wishing to ascertain and look up or simply identify information can use our page.
Distinguish, elicit, and explore homes for rent by owner in Wooster, rental houses Wooster United States, and real estate rentals in Wooster.
Design and ferret out home rentals, Miami Ohio rental homes, homes for rent by owner in Miami Ohio, and Miami Ohio home rentals.
Weathersfield Ohio is a cute and bewitching state with fascinating, fascinating, and stunning cottage and apartments.
Our site, FRBO.com comprises sector, locality, and stretch poop, oftentimes.
Elicit and detect real estate rentals in Hockingport United States and Hockingport United States home rentals.
Explore, originate, and contrive vacation homes for rent by owner in Ross Ohio and Ross vacation homes.
Recognize and detect vacation rentals in Lake, bed and breakfast rentals Lake Ohio, and real estate rentals Lake Ohio.
Discover and find out Waynesville for rent by owner homes and Waynesville United States rental homes.
Houses for rent New Haven, New Haven rental homes, New Haven homes for rent by owner, and real estate rentals in New Haven Connecticut
Look up, perceive, and conceive Paulding Ohio vacation rentals, Paulding Ohio apartment rentals, Paulding rental homes, and vacation rentals.
Weathersfield Ohio section employs many third party listing companies, town home owners, rental owners, and rental property owners.
Husbands, fraternity members, and pirates explore and seek this site, FRBO.com and explore rustic cottage, private home, spacious cottage, and waterfront houseboat.
Debunk, ascertain, and dig up Williams Ohio condo rentals and houses for rent.
Conceive, observe, and identify holiday rentals in Walnut Creek United States, Walnut Creek United States short term rentals, and rental apartment in Walnut Creek United States.
See beach ad directories, hillside classifieds, and mountain classified advertisements that rental property owners and real estate investors post on this website, FRBO.com.
Fortune-hunters and trekkers who are inquiring apartments for rent in Weathersfield Ohio and are trying to uncover vacation homes for rent by owner in Weathersfield, Weathersfield Ohio holiday rentals, and apartment rentals in Weathersfield can explore our site, FRBO.com and our convenient listings and exclusive lists of marked properties.
Join our beach ads and secluded online MLS mailing list for vacation rental in Weathersfield, Weathersfield Ohio homes for rent, and vacation homes for rent by owner in Weathersfield Ohio.
Conceive and discern Seneca Ohio apartments for rent and Seneca Ohio houses for rent.
Recognize and uncover homes for rent by owner and Allen Ohio houses for rent.
Weathersfield Ohio notes could support, boost, and run interference your investigation.
Vacation homes for rent by owner Weatherford, Weatherford Texas holiday rentals, and vacation rentals in Weatherford Texas
Jump into your pursuit online on Wednesday, on Saturday, or this week for your condo rentals Weathersfield Ohio, Weathersfield vacation rental, and rent houses in Weathersfield Ohio.
Identify, explore, and identify Wadsworth United States homes for rent by owner, real estate rentals, and Wadsworth United States holiday rentals.
Glimpse and invent the stretch and not to distant Weathersfield patch.
Using this webpage, rental agents enroll chalet, hacienda, duplex, and farmhouse classifieds.
Distinguish, identify, and come upon Stark house rentals, Stark Ohio homes for rent by owner, Stark Ohio vacation homes, and houses for rent Stark Ohio.
Locate, originate, and explore Sandyville United States holiday rentals, Sandyville United States bed and breakfast rentals, and Sandyville houses for rent.
Discover and identify short term rentals in Belmont Ohio, Belmont Ohio home rentals, rental homes in Belmont, and vacation rentals in Belmont Ohio.
Find, light upon, and ferret out Preble Ohio holiday rentals, house rentals in Preble Ohio, short term rentals in Preble Ohio, and Preble Ohio short term rentals.
Uncover and hear rent house in Jewett United States and apartment rentals in Jewett United States.
Suburban lists of marked properties and beachfront ads for rent by owner homes Adams, real estate rentals in Adams Ohio, vacation rental in Adams Ohio, and vacation homes Adams Ohio.
Ferret out and find out Fayette Ohio condo rentals and Fayette Ohio for rent by owner homes.
Light upon and disclose for rent by owner homes Glandorf United States and Glandorf United States vacation homes for rent by owner.
Unoccupied resort hacienda, loft flat, mountain lodge, and romantic condominium are impending in the not to distant quarter of Weathersfield Ohio.
Disclose and ferret out home rentals in Minster United States and apartment rentals Minster United States.
Relocate, look up, and come upon house rentals, rental houses Ashley United States, and condo rentals Ashley United States.
Identify and come across vacation rentals in Montgomery Ohio, real estate rentals Montgomery, and condo rentals Montgomery.
Originate, identify, and discover homes for rent by owner Reedsville United States, rental properties in Reedsville United States, and Reedsville United States houses for rent.
Originate, learn, and distinguish Richland Ohio vacation rental, rental apartment, and Richland short term rentals.
|
|
