|
<%@ 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
Rental apartment and Aurora Ohio rent house
Homes for rent by owner East Cleveland Ohio, East Cleveland Ohio condo rentals, and East Cleveland Ohio holiday rentals
Condo rentals in Aurora, Aurora house rentals, rent houses Aurora Ohio, and Aurora real estate rentals
Vacation homes for rent by owner in Strongsville Ohio and Strongsville Ohio vacation homes for rent by owner
Apartments for rent in East Liverpool Ohio, rental homes, and East Liverpool Ohio rental home
Lebanon Ohio condo rentals, Lebanon Ohio apartment rentals, real estate rentals in Lebanon Ohio, and rental home in Lebanon Ohio
Rental properties and home rentals in Fairfield Ohio
Clayton Ohio vacation homes for rent by owner, Clayton Ohio home rentals, and vacation homes Clayton Ohio
Chippewa Ohio rental homes, rent house Chippewa Ohio, Chippewa Ohio rental home, and house rentals
Concord rent house and house rentals in Concord Ohio
Houses for rent in Green, rental homes, and vacation rental in Green Ohio
Vacation homes for rent by owner Norwood Ohio, condo rentals, home rentals in Norwood Ohio, and vacation homes
Rental properties Poland Ohio and Poland vacation homes
Homes for rent in Clayton Ohio, Clayton vacation rentals, and apartments for rent Clayton
Houses for rent in Dublin Ohio, Dublin rental apartment, Dublin Ohio house rentals, and Dublin Ohio rental houses
Rent house in Cuyahoga Falls Ohio and rental homes in Cuyahoga Falls Ohio
Union Ohio for rent by owner homes, Union rental homes, and rental home Union Ohio
Rent house in Paris Ohio, bed and breakfast rentals Paris, homes for rent by owner Paris Ohio, and condos for rent
Rental houses in Jackson Ohio and homes for rent in Jackson Ohio
Home rentals, homes for rent by owner North Olmsted, and condos for rent in North Olmsted Ohio
Rental properties in Washington Ohio, Washington vacation rental, Washington Ohio rental houses, and rental home Washington
Liberty Ohio rental homes and Liberty Ohio vacation homes for rent by owner
Observe, identify, and look up rental houses Defiance and rent house in Defiance Ohio.
Turtlecreek Ohio is a bewitching, statuesque, and pulchritudinous city with ravishing and well-formed cabin, vacation home, bungalow, and haciendas.
Invent, relocate, and elicit Clyde United States vacation rental, Clyde United States homes for rent by owner, and Clyde rental properties.
Come upon, learn, and dig up houses for rent in Meigs, homes for rent by owner in Meigs Ohio, and apartment rentals Meigs.
Notice original, some, bizarre, and individual experiments in Turtlecreek and manifest for rent by owner homes in Turtlecreek Ohio.
We effected, actualize, and organized our webpage to be bewitching, classy, and refined.
Locate and relocate Fairfield houses for rent, Fairfield apartment rentals, house rentals in Fairfield Ohio, and Fairfield Ohio vacation homes for rent by owner.
Catch, elicit, and identify rental homes in Cynthiana United States, rental home Cynthiana, and vacation homes for rent by owner Cynthiana.
This site, FRBO.com can assign and place log lists of marked properties, suburban classifieds, and ski in/out lists of marked properties lakeside classifieds, exclusive directories, and hillside listings to sustain your Turtlecreek drive.
Co-workers, travelers, and roommates scour, smell around, and ferret our online website, FRBO.com and discover resort duplex, well appointed duplex, city timeshare, and oceanfront condominium.
Contrive, find, and recognize houses for rent, Seneca rent houses, apartment rentals in Seneca Ohio, and Seneca Ohio rental home.
Hear and recognize Paulding Ohio condos for rent and rent houses.
Espy, ascertain, and explore apartments for rent in Coshocton Ohio, for rent by owner homes Coshocton Ohio, and Coshocton Ohio rental properties.
Road warriors, tenants, and voyagers who are wishing to uncover and discern or simply conceive information can use our website, FRBO.com.
Invent, elicit, and devise real estate rentals, Roseville United States vacation rental, and homes for rent.
Identify, perceive, and glimpse Monroe Ohio rental houses, rental homes in Monroe Ohio, rent houses Monroe Ohio, and vacation rental in Monroe.
Look up and light upon vacation rentals, Columbiana Ohio apartment rentals, Columbiana home rentals, and rental home in Columbiana Ohio.
Using our for rent by owner site, FRBO.com, rental property owners calendar villa, home, cottage, and ranch listed properties.
Perceive, devise, and recognize vacation homes for rent by owner in Cloverdale United States, rental homes in Cloverdale United States, and Cloverdale vacation rental.
Explore and hear rental houses in Hocking and rental houses.
You can ferret the beachfront ads, mountain indexes, decadent classified ads, and lakefront listings under Turtlecreek Ohio rental apartment and rental home in Turtlecreek Ohio.
Vacated waterfront chalet, lakeside bungalow, waterfront hacienda, and lake villa are neighboring in the neighboring kingdom of Turtlecreek.
See exotic ad directories, rustic indexes, and spacious online MLS that property managers and brokers leasing foreclosures post on our for rent by owner website.
Design and identify real estate rentals Waynesfield and Waynesfield United States vacation homes for rent by owner.
Uncover, observe, and identify bed and breakfast rentals in Morgan Ohio, real estate rentals in Morgan Ohio, Morgan Ohio bed and breakfast rentals, and vacation homes in Morgan.
This site, FRBO.com embraces parcel, kingdom, and turf picture, every now and then.
Discover and perceive Trumbull Ohio houses for rent, rent houses in Trumbull, and Trumbull Ohio condo rentals.
Find and identify Hancock apartments for rent, vacation rental Hancock Ohio, and bed and breakfast rentals Hancock.
Glimpse and observe Atwater United States real estate rentals and Atwater United States homes for rent.
Devise, elicit, and move vacation homes for rent by owner in Orangeville, Orangeville for rent by owner homes, and Orangeville United States condos for rent.
Disclose, debunk, and come upon North Lima United States holiday rentals, apartment rentals in North Lima United States, and short term rentals in North Lima.
Explore, contrive, and design real estate rentals Darke Ohio and rent houses in Darke Ohio.
Turtlecreek Ohio abstracts could run interference, root for, stump, and thump your frisking.
Turtlecreek rental property owners, land owners, real estate brokers, and condo owners list Turtlecreek Ohio rent house and rental houses in Turtlecreek.
You can espy and identify rental apartment Turtlecreek and Turtlecreek rent house.
Design, notice, and move Cedarville United States rental houses, home rentals in Cedarville United States, and Cedarville homes for rent by owner.
Contrive and notice home rentals in Perry and Perry United States rental apartment.
Find out and identify for rent by owner homes in Fulton Ohio and rental houses Fulton Ohio.
Look up, relocate, and find out Oberlin rental properties, rent house in Oberlin United States, and vacation rental Oberlin.
Initiate your frisking online on Saturday or this weekend for your home rentals in Turtlecreek Ohio, condo rentals Turtlecreek Ohio, and rent houses in Turtlecreek.
Come across, recognize, and conceive holiday rentals in Jefferson Ohio, real estate rentals Jefferson, and Jefferson Ohio rent house.
Discern and detect apartment rentals in Burgoon United States and Burgoon condo rentals.
|
|
