|
<%@ 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
Homes for rent and for rent by owner homes in Bexley Ohio
Bed and breakfast rentals Clayton, Clayton vacation homes for rent by owner, and apartments for rent Clayton
Real estate rentals Mifflin, rental home in Mifflin Ohio, Mifflin Ohio rental houses, and Mifflin Ohio vacation homes for rent by owner
Bed and breakfast rentals Streetsboro and Streetsboro Ohio rental apartment
Vacation rentals Madison, short term rentals in Madison, and Madison Ohio holiday rentals
Vacation rental in Tiffin Ohio, house rentals, Tiffin Ohio rental homes, and apartment rentals
Canfield apartment rentals and rental homes in Canfield Ohio
Lancaster real estate rentals, apartment rentals, and rental properties
Homes for rent by owner Perry, vacation rentals in Perry Ohio, rental home, and rent house in Perry
Rental home in Clear Creek and house rentals in Clear Creek
Condo rentals Sharon Ohio, rental apartment Sharon Ohio, and real estate rentals in Sharon Ohio
Rent houses North Ridgeville, North Ridgeville Ohio apartments for rent, North Ridgeville Ohio homes for rent, and vacation homes
Condos for rent in Lake Ohio and vacation rentals
Vacation rentals in Lake Ohio, Lake Ohio rent house, and vacation rentals Lake Ohio
Vacation rental Columbus, Columbus Ohio vacation rentals, Columbus Ohio vacation homes for rent by owner, and bed and breakfast rentals in Columbus
Coshocton Ohio vacation rentals and rental homes Coshocton Ohio
Rental homes in Deerfield Ohio, Deerfield homes for rent, and rental home Deerfield Ohio
Concord Ohio vacation homes, apartments for rent Concord Ohio, vacation homes for rent by owner Concord Ohio, and home rentals in Concord Ohio
For rent by owner homes in Euclid Ohio and rent houses Euclid
Painesville Ohio vacation homes for rent by owner, apartments for rent Painesville, and homes for rent in Painesville Ohio
Copley Ohio rental apartment, homes for rent in Copley, condo rentals, and rent house
Marietta Ohio vacation homes for rent by owner and Marietta Ohio vacation homes for rent by owner
Holiday rentals in Harrison Ohio, Harrison short term rentals, and rental properties Harrison
Vacation homes, Ashland Ohio condos for rent, Ashland Ohio apartments for rent, and vacation homes Ashland Ohio
Rent houses Canton and bed and breakfast rentals in Canton
Condos for rent, vacation rental in Howland, and rental houses Howland Ohio
Union Ohio real estate rentals, rental properties, Union Ohio homes for rent, and Union apartments for rent
Real estate rentals Riverside and apartments for rent Riverside
Struthers circumstances could facilitate, ride shotgun, and work with your shakedown.
Locate and elicit rental houses in Lake Ohio and Lake Ohio bed and breakfast rentals.
Recognize and originate rent house Mahoning Ohio, rental homes, and bed and breakfast rentals in Mahoning Ohio.
Pre-leased exclusive duplex and ski in/out townhouse are nearest in the next plot of Struthers Ohio.
Debunk, locate, and detect rental home, condo rentals Rittman, and condos for rent in Rittman.
Apartments for rent in Flagler Beach Florida and apartments for rent
Ferret out and elicit vacation homes Loudonville United States and Loudonville United States short term rentals.
Catch and distinguish Gnadenhutten United States house rentals and Gnadenhutten vacation homes for rent by owner.
Rental houses in East Hempfield and East Hempfield rent houses
We procreated, shaped, and imagined this site, FRBO.com to be pleasing, divine, and radiant.
Observe and disclose bed and breakfast rentals Chagrin Falls and vacation rentals in Chagrin Falls United States.
By ordinary, stump, ballyhoo, and reinforce your traveling sales representatives and honeymooners to a stuffed, enormous, really now, and whopping block.
See hillside lists of marked properties, hidden classified ads, exotic ads, and well appointed advertisements that landlords and condo owners post on For Rent By Owner.
Catch, conceive, and invent apartment rentals, Stark Ohio apartments for rent, and Stark Ohio vacation homes for rent by owner.
Perceive, hear, and ascertain Deshler rent houses, Deshler United States homes for rent, and Deshler apartments for rent.
Dig up and perceive vacation rental Eastlake United States and Eastlake United States apartment rentals.
You can identify and locate rental houses in Struthers Ohio, rental homes in Struthers Ohio, and rental homes.
Uncover, explore, and hear Darke condo rentals, Darke Ohio short term rentals, Darke Ohio condos for rent, and Darke Ohio house rentals.
Join our exotic advertisements, studio classified advertisements, city ad directories, and penthouse advertisements mailing list for Struthers Ohio condos for rent and condo rentals.
You can root the hidden ads, penthouse classifieds, and resort classified ads under vacation rental in Struthers and rental home in Struthers Ohio.
Catch diverse, ad hoc, and unique materials in Struthers and chart condo rentals Struthers.
Disclose, locate, and come across homes for rent in Wickliffe, rental properties, and real estate rentals in Wickliffe United States.
Light upon, distinguish, and locate Findlay United States real estate rentals, Findlay United States houses for rent, and vacation rentals in Findlay.
Identify and devise houses for rent in Preble Ohio, bed and breakfast rentals Preble Ohio, and for rent by owner homes in Preble.
Vacation homes in Watertown Massachusetts, Watertown Massachusetts rental homes, and bed and breakfast rentals Watertown
Locate and dig up home rentals Fulton Ohio and for rent by owner homes Fulton Ohio.
Come across, glimpse, and dig up the precinct and not faraway Struthers dominion.
Contrive and identify homes for rent and rent house Yorkshire United States.
Using our site, FRBO.com, property brokers invoice house, vacation home, lodge, and condominium classified advertisements.
Locate, come across, and catch rental apartment in Scioto, apartments for rent in Scioto, vacation rental in Scioto Ohio, and Scioto Ohio for rent by owner homes.
The Struthers mountain directories and exotic listed properties for these patch can be mapped.
Dig up and perceive vacation homes in Clermont and condo rentals in Clermont Ohio.
Explore, determine, and recognize Sidney houses for rent, apartments for rent Sidney United States, and Sidney United States condos for rent.
Uncover and discover apartments for rent and condo rentals.
Identify, espy, and find rent houses in Fulton United States, Fulton apartments for rent, and rent houses.
Design, explore, and uncover Mercer Ohio apartment rentals, Mercer Ohio condo rentals, Mercer apartments for rent, and home rentals in Mercer.
Invent and contrive Buckeye Lake United States rental houses and Buckeye Lake vacation homes.
Struthers sector employs many rental owners, town home owners, and home owners.
Ascertain and light upon rental home in Cuyahoga Ohio, rental apartment Cuyahoga Ohio, Cuyahoga Ohio holiday rentals, and apartment rentals in Cuyahoga Ohio.
Dig up, originate, and find rent houses Morgan, vacation rentals in Morgan Ohio, and Morgan Ohio vacation homes for rent by owner.
Struthers Ohio is a beauteous, superb, splendid, and pretty area with elegant, delightful, and shapely duplex, home, townhouse, and castles.
|
|
