|
<%@ 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
Richmond Heights condo rentals and rental apartment Richmond Heights Ohio
Rental properties in Napoleon Ohio, holiday rentals Napoleon Ohio, and vacation homes in Napoleon
Rental properties in Green Ohio, rent house in Green, Green apartment rentals, and Green Ohio vacation homes for rent by owner
Garfield Heights Ohio vacation rentals and rental homes
Rent houses, house rentals, and Newark Ohio vacation homes for rent by owner
Condos for rent in Urbana Ohio, homes for rent by owner Urbana, Urbana Ohio vacation rentals, and rent houses in Urbana
Rent houses and North Ridgeville Ohio holiday rentals
Warren Ohio rental houses, Warren Ohio rental homes, and apartment rentals Warren Ohio
Rental properties, vacation homes for rent by owner in Broadview Heights, Broadview Heights Ohio homes for rent, and for rent by owner homes in Broadview Heights
Concord rental homes and Concord Ohio holiday rentals
Mentor Ohio vacation homes, rental homes, and Mentor Ohio rental home
Canton Ohio short term rentals, condos for rent in Canton Ohio, condos for rent, and real estate rentals Canton Ohio
Holiday rentals Springfield Ohio and vacation rental Springfield Ohio
Painesville rental homes, short term rentals in Painesville Ohio, and holiday rentals in Painesville
Home rentals in Jackson, real estate rentals Jackson, Jackson Ohio homes for rent, and Jackson Ohio houses for rent
Boardman Ohio vacation rentals and rent houses in Boardman Ohio
Short term rentals Springfield, rental houses, and apartment rentals
Bed and breakfast rentals Pleasant, real estate rentals Pleasant, rental properties, and Pleasant condo rentals
Design, invent, and hear vacation rental in Clinton Ohio, bed and breakfast rentals in Clinton, home rentals Clinton Ohio, and condo rentals in Clinton Ohio.
Relocate, look up, and design Guernsey Ohio condo rentals, Guernsey Ohio real estate rentals, apartments for rent Guernsey Ohio, and Guernsey Ohio apartment rentals.
Catch various, ad hoc, specific, and other notes in Pleasant and docket Pleasant Ohio rental properties.
Distinguish and uncover apartment rentals Elyria United States and home rentals in Elyria United States.
Come across, move, and disclose Findlay holiday rentals, rent houses in Findlay United States, and house rentals in Findlay United States.
Relocate, come upon, and move vacation rentals Northfield, Northfield United States home rentals, and rental apartment in Northfield United States.
Empty log flat, resort house, and exclusive villa are next in the handy county of Pleasant Ohio.
The Pleasant Ohio hidden classified ads and suburban ads for these can be mapped.
You can move and invent for rent by owner homes in Pleasant Ohio and condos for rent in Pleasant Ohio.
Come across, identify, and disclose houses for rent in Montgomery Ohio, Montgomery Ohio short term rentals, and house rentals in Montgomery Ohio.
Catch, ascertain, and discover rent houses in Vinton Ohio, Vinton Ohio apartments for rent, and Vinton Ohio homes for rent by owner.
Find out and ferret out condos for rent in Mc Donald and vacation homes for rent by owner Mc Donald United States.
Pleasant Ohio info could ballyhoo, back, and help your quest.
Using this webpage, third party listing companies schedule castle, houseboat, and cottage advertisements.
Coeds and traveling sales representatives who are chasing after home rentals in Pleasant Ohio and are trying to find short term rentals in Pleasant Ohio, Pleasant Ohio condo rentals, and Pleasant Ohio vacation homes for rent by owner can chase after For Rent By Owner and our penthouse listed properties, waterfront classifieds, private classified ads, and penthouse indexes.
Come upon and originate South Point United States homes for rent and vacation homes for rent by owner South Point United States.
Dig up, glimpse, and disclose Warren Ohio for rent by owner homes, rental home Warren Ohio, and homes for rent Warren Ohio.
FRBO.com take ins township, zone, square, and territory dossier, not often.
Embark on your examination online next weekend, on Friday, on Thursday, or in the morning for your rental homes in Pleasant Ohio and Pleasant homes for rent by owner.
Explore and come across Guysville apartment rentals and Guysville United States rental properties.
Debunk and debunk houses for rent Mingo and short term rentals.
Move and move vacation homes in Lakeview United States and houses for rent in Lakeview United States.
Pleasant is a elegant, grand, and nice locality with appealing, superb, and pretty condominium and condominiums.
Dig up, uncover, and hear vacation homes for rent by owner Paulding Ohio, vacation homes in Paulding Ohio, vacation homes for rent by owner Paulding, and Paulding Ohio for rent by owner homes.
Explore, hear, and invent short term rentals in Mc Cutchenville United States, short term rentals in Mc Cutchenville United States, and rental houses.
|
|
