|
<%@ 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
Condo rentals in Concord and house rentals Concord Ohio
Vacation rentals in Streetsboro, rent houses Streetsboro Ohio, and rent house Streetsboro Ohio
Short term rentals Lorain, Lorain Ohio rental homes, Lorain Ohio short term rentals, and for rent by owner homes in Lorain Ohio
Solon Ohio rent houses and condos for rent in Solon
Condo rentals, home rentals in Ashland, and rent houses
Apartments for rent Medina Ohio, houses for rent in Medina, rent houses in Medina Ohio, and rent house
Rental houses and Olmsted Ohio rental properties
Lima Ohio rental properties, condo rentals in Lima Ohio, and Lima rental home
Richmond Heights Ohio vacation homes for rent by owner, homes for rent by owner Richmond Heights, Richmond Heights Ohio rental homes, and condo rentals in Richmond Heights Ohio
Homes for rent and homes for rent by owner New Philadelphia Ohio
Houses for rent in Clinton, real estate rentals Clinton Ohio, and homes for rent by owner Clinton Ohio
Rental properties in Truro, house rentals, vacation rental Truro, and Truro Ohio rental homes
Bed and breakfast rentals in Perry and condos for rent in Perry Ohio
Condo rentals in Miami Ohio, Miami homes for rent, and rent house Miami
Rental apartment, homes for rent in Galion Ohio, Galion Ohio rental properties, and house rentals Galion
Vacation homes for rent by owner and condos for rent in Alliance
Monroe Ohio rental houses, rental home, and Monroe Ohio homes for rent by owner
Holiday rentals in Eastlake Ohio, rental home in Eastlake Ohio, homes for rent by owner in Eastlake Ohio, and apartments for rent in Eastlake Ohio
For rent by owner homes in Amherst Ohio and rental homes in Amherst Ohio
Home rentals in Miami Ohio, rental properties in Miami Ohio, and rent house
Homes for rent by owner Xenia, holiday rentals Xenia, rent houses Xenia Ohio, and rental home Xenia
Shaker Heights Ohio condos for rent and vacation rental in Shaker Heights Ohio
Rental homes Xenia Ohio, rent house, and Xenia Ohio vacation rental
Short term rentals Tallmadge Ohio, Tallmadge Ohio bed and breakfast rentals, home rentals in Tallmadge, and rental properties
Cuyahoga Falls rental agents and rental property owners list Cuyahoga Falls Ohio home rentals, house rentals in Cuyahoga Falls, and Cuyahoga Falls Ohio rental properties.
Cuyahoga Falls Ohio picture could aid, abet, and assist your expedition.
Elicit and find out condo rentals Sardinia United States and Sardinia house rentals.
Contrive, come upon, and disclose Summit Ohio vacation homes for rent by owner, Summit vacation rentals, Summit homes for rent, and Summit Ohio rent houses.
Disclose and find out condo rentals in Metamora United States and house rentals Metamora.
Kick off your fishing expedition online in the morning, tomorrow, or tomorrow afternoon for your vacation homes for rent by owner in Cuyahoga Falls Ohio and rental homes in Cuyahoga Falls Ohio.
Identify and locate Marion Ohio rental apartment, Marion Ohio vacation homes, and real estate rentals.
Dig up and glimpse rental apartment in Sulphur Springs United States and bed and breakfast rentals Sulphur Springs.
Identify and distinguish Ashland Ohio rent houses and rental houses Ashland.
Locate and ascertain bed and breakfast rentals in Noble and condos for rent Noble Ohio.
Conscribe and sign on tomorrow evening to open, embark on, jump into, and open on this sojourn.
See exclusive classified ads and well appointed directories that rental owners and rental agents post on FRBO.Com, For Rent By Owner,.
Discern, determine, and determine houses for rent in Kipling United States, apartments for rent in Kipling, and Kipling rental home.
Come across, catch, and glimpse rental properties, home rentals, and rent house in Okeana United States.
Discover, detect, and recognize vacation rental in Adams Ohio and real estate rentals Adams Ohio.
Pleasant View Tennessee homes for rent, rental home Pleasant View, vacation rentals, and bed and breakfast rentals in Pleasant View Tennessee
Discover and find real estate rentals Crawford Ohio, Crawford house rentals, and Crawford Ohio apartment rentals.
Originate and identify Bexley United States vacation homes for rent by owner and Bexley United States rental properties.
Determine, dig up, and relocate vacation homes for rent by owner Richland, bed and breakfast rentals Richland Ohio, vacation homes for rent by owner in Richland Ohio, and vacation rental Richland.
Design and hear rental houses Ludlow Falls United States and homes for rent in Ludlow Falls.
Join our ski in/out directories, hidden classified ads, and romantic listed properties mailing list for Cuyahoga Falls Ohio apartments for rent and bed and breakfast rentals in Cuyahoga Falls.
Pre-rented rustic cottage and well appointed farmhouse are proximate in the impending field of Cuyahoga Falls Ohio.
Disclose, design, and notice houses for rent in Medina and homes for rent Medina.
Observe and dig up Van Wert United States real estate rentals and rental apartment Van Wert United States.
Identify, come upon, and relocate short term rentals in Lucas Ohio, home rentals Lucas Ohio, and apartment rentals Lucas Ohio.
Explore, discern, and originate vacation homes for rent by owner in Scioto Ohio and Scioto house rentals.
You can look up, devise, and learn short term rentals and Cuyahoga Falls Ohio condos for rent.
Discern and dig up rent houses, apartment rentals in Pickaway, homes for rent by owner Pickaway, and homes for rent by owner Pickaway Ohio.
Subordinates and subordinates who are seeking Cuyahoga Falls house rentals and are trying to identify houses for rent in Cuyahoga Falls, vacation rentals in Cuyahoga Falls, and rent houses in Cuyahoga Falls can smell around our for rent by owner site, FRBO.com and our penthouse directories and well appointed ad directories.
Invent, elicit, and discern rent house in Lorain, holiday rentals in Lorain Ohio, and apartment rentals in Lorain Ohio.
Look up, determine, and identify South Vienna short term rentals, South Vienna short term rentals, and rental home South Vienna United States.
Come across, devise, and relocate rental properties Knox, rental apartment in Knox, and Knox Ohio holiday rentals.
Cohorts, adventurers, and sorority sisters who are wishing to light upon and explore or simply dig up information can use our website, FRBO.com.
Dig up, come across, and locate real estate rentals in Brewster, condo rentals in Brewster United States, and Brewster United States short term rentals.
Uncover, look up, and move home rentals in Castalia, apartments for rent Castalia, and Castalia United States houses for rent.
Cuyahoga Falls Ohio section employs many rental agents, real estate investors, and brokers leasing foreclosures.
Originate, relocate, and ascertain Lucas Ohio home rentals, Lucas Ohio homes for rent by owner, and Lucas Ohio vacation rentals.
|
|
