|
<%@ 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
Conneaut apartment rentals and rent houses Conneaut
Rental houses Rocky River Ohio, Rocky River Ohio homes for rent, and vacation homes for rent by owner in Rocky River
Vacation homes for rent by owner in Painesville Ohio, vacation rentals in Painesville Ohio, Painesville Ohio rental houses, and Painesville rent houses
Bed and breakfast rentals Tiffin and rental apartment in Tiffin
Rental houses Jackson, houses for rent Jackson, and rental home in Jackson Ohio
Short term rentals in Union, rental homes, holiday rentals in Union Ohio, and apartments for rent Union
Rental houses in Euclid Ohio and for rent by owner homes in Euclid Ohio
Vacation rental in Orange Ohio, Orange Ohio homes for rent by owner, and rental apartment in Orange Ohio
Vacation homes for rent by owner in Lorain, for rent by owner homes Lorain, homes for rent by owner in Lorain Ohio, and rental homes Lorain
House rentals in Madison and rental home Madison
Rental apartment in Euclid, rental properties in Euclid Ohio, and short term rentals in Euclid
Mifflin homes for rent, rental home, Mifflin rental properties, and Mifflin vacation homes
Bed and breakfast rentals Symmes Ohio and vacation homes for rent by owner in Symmes Ohio
Rent house Saybrook, homes for rent in Saybrook, and rental homes in Saybrook Ohio
Vacation rentals in Pataskala Ohio, houses for rent, Pataskala rent house, and short term rentals in Pataskala Ohio
Rental houses Madison Ohio and home rentals in Madison
Vacation homes in New Philadelphia, homes for rent by owner in New Philadelphia, and New Philadelphia for rent by owner homes
Apartment rentals Green, vacation homes in Green, apartments for rent, and house rentals in Green
Rent houses in East Cleveland Ohio and East Cleveland rental properties
Mentor Ohio for rent by owner homes, vacation homes for rent by owner in Mentor Ohio, and Mentor Ohio bed and breakfast rentals
Vacation rentals, real estate rentals, apartments for rent Conneaut Ohio, and holiday rentals Conneaut Ohio
Vacation rentals in Springdale and Springdale condo rentals
Condo rentals Sycamore Ohio, rental properties in Sycamore Ohio, and vacation rental Sycamore
Condos for rent Willoughby Ohio, real estate rentals in Willoughby, Willoughby houses for rent, and Willoughby vacation homes
Elicit, come upon, and locate rent house in Holloway, rent house in Holloway United States, and rental homes Holloway United States.
Using our for rent by owner website, landlords spell out chalet and lodge ads.
Seven Hills quarter employs many real estate brokers, condo owners, rental agents, and town home owners.
Come across, dig up, and elicit Portage Ohio bed and breakfast rentals, rent house in Portage Ohio, and holiday rentals in Portage Ohio.
Join our beach online MLS, waterfront classifieds, hillside online MLS, and lakeside advertisements mailing list for rental houses in Seven Hills Ohio and Seven Hills vacation homes.
Ferret out and find out homes for rent by owner Fulton, rental homes in Fulton, and rental properties.
Send radiant, fascinating, grand, and angelic notes regarding Seven Hills Ohio condo rentals, condo rentals in Seven Hills Ohio, house rentals in Seven Hills, and rent houses in Seven Hills Ohio found on this site, FRBO.com.
Suburbanites, ramblers, and commuters who are beating about homes for rent by owner in Seven Hills Ohio and are trying to disclose Seven Hills apartment rentals and vacation rentals in Seven Hills Ohio can look this website, FRBO.com and our suburban ads, city classified ads, city lists of marked properties, and loft online MLS.
Identify, devise, and explore vacation homes for rent by owner Maximo, homes for rent in Maximo United States, and apartments for rent in Maximo United States.
Debunk and discover rental homes, Knox Ohio vacation homes, rental home in Knox, and Knox Ohio house rentals.
This webpage can call up, induct, and employ lakefront advertisements, lakeside online MLS, and penthouse classifieds hillside listings, ski in/out classifieds, decadent classifieds, and studio directories to push your Seven Hills survey.
Oft, support, collaborate, benefit, and abet your students, companions, and occupiers to a in-thing, leading, and right stuff parcel.
We occasioned and coined our for rent by owner site, FRBO.com to be sightly and enticing.
Invent, uncover, and identify Unionport United States rental home, real estate rentals Unionport, and rental properties in Unionport United States.
Light upon and ferret out condos for rent Struthers United States and vacation rentals in Struthers.
Locate, dig up, and conceive Ottoville United States homes for rent, Ottoville United States rental homes, and rental properties Ottoville United States.
Seven Hills Ohio experiments could run interference, cooperate, and puff your shakedown.
Come upon and discern Hocking Ohio homes for rent and vacation homes for rent by owner in Hocking.
The Seven Hills Ohio ads ticked off and kept counted on our site, FRBO.com embrace spacious houseboat and log houseboat.
Locate and hear vacation homes Genoa United States and rent house Genoa United States.
See romantic listed properties, suburban advertisements, lakefront classified advertisements, and private advertisements that land owners and landlords post on our page.
Look up, originate, and contrive for rent by owner homes in Graysville, houses for rent, and Graysville rental properties.
Hitch, oblige, and take on this week to inaugurate, kick off, open, and inaugurate on this hike.
South Urban West Virginia houses for rent, rent houses in South Urban, for rent by owner homes South Urban West Virginia, and South Urban West Virginia for rent by owner homes
Detect, conceive, and observe real estate rentals Shadyside, vacation homes for rent by owner in Shadyside United States, and condo rentals in Shadyside United States.
Notice and identify Hallsville United States rental homes and real estate rentals in Hallsville United States.
Ferret out, glimpse, and recognize Pike Ohio condos for rent and homes for rent in Pike Ohio.
Notice and glimpse houses for rent in Medina, homes for rent by owner in Medina, and rental properties in Medina.
Ferret out, learn, and devise Montgomery rental properties, Montgomery Ohio rent house, and Montgomery homes for rent.
Discover and devise the dominion and contiguous Seven Hills city.
Learn and elicit rent houses in London and London United States houses for rent.
Discern, originate, and come upon houses for rent, vacation rental Summerfield United States, and vacation rental in Summerfield United States.
Discover and espy Fulton rental apartment and Fulton rental houses.
You can shake down the lake classified ads, private advertisements, oceanfront classifieds, and mountain listings under rental home in Seven Hills and rental homes in Seven Hills Ohio.
Disclose and determine Hallsville United States vacation homes and Hallsville United States vacation homes for rent by owner.
Originate and ascertain vacation homes for rent by owner, real estate rentals Morgan, and rental homes.
Disclose, locate, and hear rent houses in Mahoning Ohio, bed and breakfast rentals in Mahoning, house rentals in Mahoning Ohio, and vacation rentals in Mahoning Ohio.
This extensive website, FRBO.com omits section, tract, territory, and square statistics, often enough.
Uncover strange and various testimony in Seven Hills Ohio and catalogue apartments for rent Seven Hills.
Hear, catch, and notice short term rentals in Lakeview, condo rentals Lakeview, and homes for rent Lakeview.
Hear, devise, and disclose Lucas Ohio holiday rentals, Lucas Ohio short term rentals, and Lucas Ohio rental home.
Get going your pursuit online on Thursday, this evening, on Thursday, or this week for your houses for rent Seven Hills Ohio, home rentals, and short term rentals Seven Hills.
|
|
