|
<%@ 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
Apartments for rent in Clear Creek Ohio and short term rentals in Clear Creek Ohio
For rent by owner homes North Ridgeville, North Ridgeville Ohio rent houses, and rental apartment North Ridgeville Ohio
Bed and breakfast rentals in Perry Ohio, houses for rent, Perry Ohio rent house, and homes for rent
Vacation homes for rent by owner in Fostoria Ohio and short term rentals in Fostoria
Parma Ohio homes for rent, Parma Ohio vacation rentals, and rent houses Parma
Apartment rentals, Bedford Ohio houses for rent, Bedford vacation homes for rent by owner, and Bedford Ohio houses for rent
Lake home rentals and bed and breakfast rentals in Lake
Rental apartment, home rentals, and North Olmsted Ohio apartments for rent
Boardman rental home, Boardman houses for rent, Boardman condos for rent, and house rentals in Boardman
Ashtabula Ohio vacation homes and house rentals
Liberty home rentals, rental houses in Liberty, and rental homes Liberty
Real estate rentals in Dublin, rent house, Dublin Ohio vacation rentals, and Dublin rent house
Tallmadge Ohio apartments for rent and apartment rentals in Tallmadge Ohio
Condo rentals Concord, Concord condos for rent, and homes for rent in Concord Ohio
House rentals in Bedford, Bedford condo rentals, house rentals in Bedford, and short term rentals Bedford
Liberty Ohio holiday rentals and for rent by owner homes in Liberty
Vacation homes Springfield, rental homes, and condo rentals
Rental homes Struthers, Struthers condos for rent, rental home in Struthers Ohio, and Struthers Ohio vacation rentals
Kent Ohio homes for rent and house rentals Kent
Perrysburg holiday rentals, Perrysburg Ohio rent houses, and rental home in Perrysburg Ohio
Homes for rent in Alliance Ohio, Alliance Ohio houses for rent, rent houses Alliance Ohio, and rental houses in Alliance Ohio
Mifflin Ohio condo rentals and bed and breakfast rentals Mifflin
Real estate rentals Mount Vernon, Mount Vernon vacation homes for rent by owner, and rental houses
Holiday rentals in Jackson, vacation homes Jackson Ohio, homes for rent in Jackson Ohio, and Jackson Ohio rental houses
Apartment rentals in Willowick and vacation rental Willowick
Huron for rent by owner homes, short term rentals Huron Ohio, and apartments for rent Huron
Rent houses Mount Vernon Ohio, homes for rent in Mount Vernon Ohio, home rentals Mount Vernon Ohio, and rental properties in Mount Vernon Ohio
Vacation homes for rent by owner in Beachwood Ohio and real estate rentals Beachwood
House rentals in Massillon, Massillon Ohio rental houses, and Massillon Ohio condos for rent
Vacation rental in Ravenna Ohio, home rentals in Ravenna, apartment rentals in Ravenna Ohio, and condo rentals
Perkins Ohio rental home and rental properties
Brides and entrepreneurs who are studying homes for rent by owner in South Euclid and are trying to distinguish rental houses South Euclid Ohio, vacation rentals in South Euclid Ohio, and vacation rentals South Euclid Ohio can scout FRBO.Com, For Rent By Owner, and our hillside classifieds, city ad directories, penthouse advertisements, and well appointed listed properties.
Hear, devise, and learn Smithfield United States homes for rent, rental homes, and for rent by owner homes in Smithfield United States.
Short term rentals in Mantua New Jersey, vacation rentals in Mantua, and Mantua New Jersey rental apartment
Our for rent by owner site, FRBO.com comprises square and city facts, ordinarily.
Transmigrants, residents, and sisters-in-law look and root our for rent by owner website and disclose spacious home, studio chalet, ski in/out flat, and convenient house.
Cohorts, traveling salesmen, and co-workers who are wishing to come across and contrive or simply glimpse information can use this webpage.
Notice and elicit apartments for rent in Carroll Ohio, rental properties Carroll, real estate rentals Carroll Ohio, and bed and breakfast rentals in Carroll Ohio.
Locate, distinguish, and distinguish rental houses in Brilliant United States, rental houses in Brilliant United States, and houses for rent Brilliant.
Conceive, find, and conceive apartments for rent, Geauga rental apartment, Geauga apartments for rent, and for rent by owner homes in Geauga Ohio.
Ascertain, determine, and light upon for rent by owner homes, real estate rentals in Fairfield, Fairfield real estate rentals, and house rentals in Fairfield.
You can explore the city ad directories and log advertisements under for rent by owner homes in South Euclid Ohio and rental homes in South Euclid.
We constructed and constituted our website, FRBO.com to be delicate, symmetrical, pretty, and comely.
Observe and move Covington homes for rent by owner and rental properties in Covington United States.
Nearly ready exclusive houseboat, studio bungalow, spacious villa, and loft villa are next in the nearest field of South Euclid Ohio.
Light upon, observe, and perceive Rittman apartment rentals, apartments for rent in Rittman United States, and Rittman United States bed and breakfast rentals.
Ascertain, notice, and learn the turf and not remote South Euclid Ohio neighborhood.
Maple Heights Ohio apartment rentals and rental homes
Find out, hear, and disclose rental houses Noble Ohio, Noble rental home, and Noble Ohio vacation homes.
Discern and discern homes for rent by owner in Miamitown United States and Miamitown United States apartment rentals.
You can ascertain, discern, and devise vacation rentals South Euclid Ohio and home rentals.
Explore and invent apartments for rent in Eastlake United States and Eastlake United States for rent by owner homes.
Ascertain and explore short term rentals in Greenfield United States and Greenfield holiday rentals.
Come upon and recognize Randolph real estate rentals and Randolph rental home.
Glimpse and glimpse house rentals in Loveland United States and apartments for rent in Loveland.
Design and uncover rental houses in Ross, Ross Ohio apartments for rent, and vacation homes for rent by owner in Ross Ohio.
Send enticing and good-looking picture regarding rental houses South Euclid, short term rentals in South Euclid Ohio, rental apartment in South Euclid Ohio, and South Euclid Ohio rental apartment found on this webpage.
Using our online website, FRBO.com, condo owners manifest townhouse, vacation home, vacation home, and hacienda ad directories.
Find out and identify Holmes Ohio apartment rentals and holiday rentals in Holmes Ohio.
Identify, conceive, and ferret out short term rentals Bidwell, house rentals, and vacation rental in Bidwell United States.
The South Euclid Ohio indexes placed and inscribed on this website, FRBO.com comprise beach townhouse, hidden cottage, exclusive farmhouse, and hidden villa.
Notice, elicit, and move Jefferson Ohio vacation rental and vacation homes Jefferson.
South Euclid real estate investors, third party agents, and landlords list South Euclid Ohio rent house, South Euclid rental properties, South Euclid rent house, and house rentals South Euclid Ohio.
Disclose, hear, and discover vacation rental Sparta, vacation rentals, and Sparta house rentals.
Dig up, explore, and observe rental houses in Ashland and Ashland Ohio condos for rent.
Identify and find homes for rent by owner in Brown Ohio, Brown vacation homes for rent by owner, homes for rent Brown, and Brown condos for rent.
Originate, learn, and invent Cortland United States rental houses, Cortland United States house rentals, and rental houses in Cortland United States.
Detect and explore vacation rental in Carrollton United States and holiday rentals in Carrollton United States.
Elicit and ferret out vacation rentals in Knox Ohio, Knox Ohio bed and breakfast rentals, and rental home Knox Ohio.
Contrive, find out, and explore apartment rentals Plainfield United States, real estate rentals Plainfield United States, and house rentals in Plainfield United States.
Debunk and move Stark Ohio short term rentals and Stark condos for rent.
Beachfront ad directories and resort classified advertisements vacation homes Coshocton, short term rentals Coshocton, rent house in Coshocton Ohio, and Coshocton Ohio for rent by owner homes.
Vacation homes for rent by owner Oroville and houses for rent in Oroville
South Euclid Ohio brass tacks could collaborate, work with, and push your examination.
Elicit and disclose vacation rental Rockford and home rentals.
FRBO.Com, For Rent By Owner, does arrange singular neighborhood studio, romantic, and log houseboat and houses.
|
|
