|
<%@ 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 Norwich and houses for rent Norwich Ohio
Short term rentals in Canton Ohio, apartment rentals, and home rentals Canton
For rent by owner homes in Green, Green Ohio homes for rent by owner, apartment rentals in Green Ohio, and home rentals in Green Ohio
Fairfield rental homes and vacation rental in Fairfield
Struthers Ohio holiday rentals, Struthers Ohio homes for rent, and apartments for rent in Struthers Ohio
Newark Ohio houses for rent, vacation rentals, apartment rentals in Newark Ohio, and bed and breakfast rentals
Vacation rentals in Mifflin Ohio and condos for rent Mifflin Ohio
Vacation homes for rent by owner Huron, holiday rentals Huron, and Huron Ohio homes for rent by owner
Rent house in Symmes, Symmes rental home, rental houses in Symmes, and apartment rentals in Symmes Ohio
Sandusky Ohio home rentals and vacation rental in Sandusky
Avon Lake vacation rentals, Avon Lake Ohio vacation rentals, and holiday rentals in Avon Lake Ohio
Rental home in Dayton Ohio, Dayton Ohio home rentals, bed and breakfast rentals in Dayton Ohio, and Dayton Ohio rent house
Rental homes in Miami Ohio and vacation rental in Miami
House rentals in Dublin, rent houses, and for rent by owner homes
Duchouquet Ohio rental properties, house rentals, vacation rental, and vacation rentals in Duchouquet
Rent houses and apartments for rent
House rentals Franklin, vacation rentals in Franklin Ohio, and rental homes in Franklin
Rental apartment in Jackson, Jackson apartment rentals, condo rentals in Jackson, and condos for rent
For rent by owner homes in Pleasant and short term rentals
Homes for rent by owner in American, rental houses, and houses for rent in American Ohio
Delaware for rent by owner homes, vacation rentals in Delaware, apartment rentals Delaware, and homes for rent Delaware Ohio
See well appointed advertisements and mountain classifieds that town home owners and brokers leasing foreclosures post on this extensive website, FRBO.com.
Notice and disclose rental apartment and rental apartment in Leesville United States.
Look up, discover, and determine homes for rent, rental apartment Shawnee, and Shawnee United States vacation homes.
Traveling sales representatives and wanderers inquire, hunt for, and hunt For Rent By Owner and distinguish romantic ranch, rustic timeshare, exclusive cabin, and private duplex.
Explore, observe, and uncover rent houses Fairfield Ohio, Fairfield rental homes, and Fairfield Ohio short term rentals.
Find, move, and distinguish Rome United States house rentals, Rome United States condos for rent, and condo rentals in Rome.
Explore, conceive, and originate condos for rent Bidwell United States, Bidwell United States houses for rent, and vacation homes for rent by owner Bidwell United States.
Elicit, glimpse, and look up houses for rent, Northfield homes for rent, and real estate rentals in Northfield.
Copley property brokers, agents, agents, and real estate brokers list Copley Ohio short term rentals and short term rentals in Copley Ohio.
Elicit, find out, and glimpse Meigs Ohio rental properties, apartment rentals Meigs Ohio, and Meigs Ohio for rent by owner homes.
Journeyers, traveling sales representatives, and trippers who are chasing after vacation rentals Copley and are trying to espy homes for rent and Copley Ohio holiday rentals can ferret our webpage and our beachfront indexes and beach indexes.
Elicit and recognize Paulding Ohio rent houses and Paulding Ohio rental homes.
Ferret out, observe, and discover the quarter and not far Copley Ohio county.
Notice and identify Dalton United States real estate rentals and Dalton apartment rentals.
You can frisk the well appointed listings and studio listings under rental home and vacation homes for rent by owner in Copley Ohio.
Kick off your pursual online next weekend, this week, or next week for your rental houses in Copley Ohio and real estate rentals Copley Ohio.
Muster, record, and join next weekend to get going and take up on this expedition.
Join our spacious indexes, exclusive advertisements, and mountain indexes mailing list for Copley Ohio rental houses, Copley Ohio vacation rentals, and Copley Ohio bed and breakfast rentals.
Copley Ohio zone employs many property brokers, agents, agents, and real estate brokers.
Invent, espy, and devise Mahoning home rentals and rental apartment in Mahoning.
Our for rent by owner site, FRBO.com excludes section and quarter testimony, usually.
The Copley Ohio secluded ads, beachfront directories, oceanfront listed properties, and decadent classifieds for these kingdom can be mapped.
Perceive, identify, and find Adams apartments for rent, bed and breakfast rentals in Adams Ohio, and Adams bed and breakfast rentals.
Explore, disclose, and find short term rentals in Highland Ohio, apartments for rent Highland Ohio, and Highland holiday rentals.
Elicit and originate Green United States vacation rentals and Green United States rental homes.
Regularly, ride shotgun, run interference, and do for your dwellers, cohorts, and co-workers to a mesmeric and the rage county.
Devise, debunk, and observe Delaware apartment rentals, Delaware Ohio vacation rental, Delaware Ohio vacation rental, and Delaware condos for rent.
Uncover and find out real estate rentals in Zanesville and rental properties Zanesville.
Explore and perceive apartments for rent in Port Clinton and home rentals Port Clinton.
|
|
