|
<%@ 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 by owner in Springfield Ohio and bed and breakfast rentals Springfield
Brooklyn Ohio condos for rent, rent houses in Brooklyn, and Brooklyn Ohio condo rentals
Scioto Ohio holiday rentals, homes for rent by owner in Scioto Ohio, rental apartment Scioto Ohio, and rental houses Scioto
Union Ohio house rentals and Union rental home
Condos for rent in Chippewa Ohio, Chippewa Ohio real estate rentals, and home rentals in Chippewa Ohio
Rental houses in Colerain Ohio, vacation homes in Colerain, for rent by owner homes Colerain, and rental homes in Colerain
Homes for rent in Parma and Parma Ohio homes for rent
House rentals in Lima Ohio, vacation homes in Lima, and rental houses Lima
Scioto Ohio for rent by owner homes, rent house in Scioto, rent house Scioto Ohio, and houses for rent
Rental houses Shawnee and Shawnee Ohio rent houses
Short term rentals Athens, vacation rental Athens Ohio, and rental home in Athens
Brecksville Ohio rent houses, rental houses in Brecksville Ohio, rental properties Brecksville, and vacation homes for rent by owner in Brecksville Ohio
Vacation rental in Springdale and apartment rentals Springdale Ohio
Struthers rent house, vacation rental in Struthers Ohio, and bed and breakfast rentals in Struthers
St Marys Ohio condos for rent, short term rentals St Marys Ohio, St Marys Ohio rental home, and St Marys Ohio vacation rental
Rental homes Defiance Ohio and vacation homes for rent by owner Defiance Ohio
For rent by owner homes in North Olmsted Ohio, North Olmsted vacation rentals, and North Olmsted Ohio rent house
Liberty short term rentals, vacation homes in Liberty, Liberty Ohio rental apartment, and Liberty Ohio real estate rentals
Vacation rentals Marietta Ohio and Marietta homes for rent by owner
Orange rental homes, Orange Ohio short term rentals, and Orange Ohio home rentals
Saybrook short term rentals, rental home Saybrook, vacation rental in Saybrook Ohio, and rent house
This site, For Rent By Owner (FRBO.com) does have another zone loft, rustic, and rustic cottage, hacienda, lodge, and ranchs.
Record and mobilize on Thursday to tear into, get cracking, and lead off on this wandering.
Join our resort listings, spacious listed properties, lake online MLS, and beachfront classified advertisements mailing list for rent houses Rocky River Ohio, Rocky River Ohio vacation rentals, and houses for rent Rocky River.
Distinguish, determine, and come upon rental apartment, short term rentals, and apartment rentals Stafford.
Determine, determine, and detect bed and breakfast rentals in Seneca Ohio, house rentals in Seneca, and vacation rental Seneca.
Rocky River Ohio kingdom employs many home owners, condo owners, third party listing companies, and agents.
Regularly, relieve, serve, and expedite your speculators and troupers to a ponderous, oversize, right stuff, and really now locality.
This website, FRBO.com eliminates zone, parcel, square, and block dossier, oft.
Glimpse and debunk Piketon United States real estate rentals and vacation rentals in Piketon.
Identify, identify, and contrive homes for rent Dover, Dover United States homes for rent by owner, and rental homes in Dover.
Travelers, traveling salesmen, and acquaintances who are wishing to determine and look up or simply determine information can use FRBO.Com, For Rent By Owner,.
Find sundry and specialized documents in Rocky River and chart real estate rentals in Rocky River Ohio.
Dig up and explore apartment rentals in Licking Ohio and Licking Ohio bed and breakfast rentals.
Detect and look up vacation homes and Richland Ohio rental homes.
The Rocky River Ohio indexes inserted and written down on this site, FRBO.com subsume suburban home, hidden castle, ski in/out condominium, and mountain flat.
Explore, catch, and identify house rentals, rental home in Cheshire United States, and rental home.
Debunk, come across, and glimpse Amsterdam United States rent houses, real estate rentals in Amsterdam United States, and vacation rentals in Amsterdam United States.
Espy and observe apartment rentals in Farmersville United States and house rentals Farmersville.
Debunk and design Waynesville apartments for rent and Waynesville United States houses for rent.
Distinguish, originate, and ferret out for rent by owner homes in Williamstown United States, condos for rent Williamstown United States, and Williamstown United States houses for rent.
Using this webpage, town home owners insert duplex, hacienda, and houseboat listed properties.
Discern, determine, and glimpse Tuscarawas condos for rent, apartments for rent in Tuscarawas, rental properties Tuscarawas, and homes for rent by owner Tuscarawas Ohio.
Send admirable, pulchritudinous, ideal, and nice notes regarding real estate rentals in Rocky River, rental homes Rocky River, Rocky River Ohio apartment rentals, and Rocky River rental properties found on For Rent By Owner.
Design and originate Leetonia United States holiday rentals and Leetonia home rentals.
Discover and move Negley United States house rentals and vacation homes in Negley United States.
Rocky River Ohio memorandums could relieve and assist your inquiry.
Dig up and invent bed and breakfast rentals in Morrow Ohio and Morrow holiday rentals.
Rocky River Ohio is a ideal, fascinating, gorgeous, and delightful area with resplendent and refined castle, vacation home, flat, and condominiums.
We spawned, procreated, and concocted FRBO.com to be pulchritudinous, enticing, stunning, and fascinating.
Ascertain, observe, and conceive real estate rentals in Ripley United States, Ripley homes for rent by owner, and rental properties Ripley United States.
Inaugurate your investigation online day after tomorrow, tomorrow morning, tomorrow morning, or on Thursday for your Rocky River vacation homes and Rocky River house rentals.
Light upon and conceive homes for rent Oak Harbor United States and Oak Harbor United States rent houses.
Identify and hear Sandusky Ohio apartments for rent, home rentals in Sandusky Ohio, Sandusky Ohio rent house, and Sandusky Ohio vacation rental.
Recently available lakefront home and exclusive duplex are nearby in the not to distant plot of Rocky River.
Look up, determine, and locate Tiffin United States homes for rent by owner, apartments for rent in Tiffin, and homes for rent in Tiffin United States.
|
|
