|
<%@ 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 apartments for rent in Lorain
Rental houses in Olmsted, holiday rentals, and vacation homes in Olmsted
Rental homes Bedford Heights, apartment rentals, house rentals in Bedford Heights Ohio, and Bedford Heights Ohio rent houses
Mill Ohio apartment rentals and holiday rentals in Mill Ohio
Rent house, Akron Ohio condo rentals, and apartment rentals in Akron Ohio
Prairie Ohio rental houses, Prairie Ohio real estate rentals, vacation rental, and Prairie Ohio rental apartment
Condo rentals and Willowick Ohio homes for rent
Short term rentals Steubenville Ohio, Steubenville Ohio vacation homes, and apartments for rent Steubenville Ohio
Medina Ohio houses for rent, rental properties, rental houses Medina Ohio, and condo rentals in Medina Ohio
Rental homes in Defiance Ohio and holiday rentals in Defiance Ohio
Mad River Ohio house rentals, vacation rental in Mad River Ohio, and Mad River house rentals
Real estate rentals, rental houses in North Olmsted Ohio, North Olmsted Ohio homes for rent, and North Olmsted homes for rent
Holiday rentals in Symmes Ohio and vacation homes in Symmes Ohio
Houses for rent in Parma Heights, for rent by owner homes, and short term rentals in Parma Heights Ohio
Holiday rentals in Anderson Ohio, rental home Anderson, Anderson Ohio rental home, and vacation homes for rent by owner in Anderson
Painesville Ohio real estate rentals and Painesville house rentals
Home rentals, rent house Avon Lake Ohio, and rent houses in Avon Lake Ohio
For rent by owner homes in Franklin Ohio, vacation homes for rent by owner, condo rentals in Franklin, and Franklin Ohio vacation rental
Fremont house rentals and Fremont apartment rentals
Genoa Ohio house rentals, Genoa Ohio rental home, and Genoa short term rentals
Circleville Ohio vacation homes for rent by owner, Circleville Ohio apartments for rent, vacation homes for rent by owner in Circleville Ohio, and Circleville Ohio vacation homes for rent by owner
Short term rentals and rental apartment
Apartment rentals North Royalton, North Royalton short term rentals, and North Royalton Ohio rental properties
Our webpage does take in various quarter penthouse, private, hillside, and decadent townhouse, hacienda, flat, and houseboats.
North Royalton Ohio testimony could aid and help your inquest.
Explore and ascertain vacation rental North Bloomfield United States and rental home North Bloomfield United States.
Dig up and observe apartments for rent and bed and breakfast rentals Adams Ohio.
Disclose and come across Lake Ohio rent house, real estate rentals in Lake Ohio, and rental home Lake Ohio.
Discern, originate, and look up rental homes Dover United States, homes for rent by owner in Dover United States, and vacation rental in Dover.
Habitually, expedite, assist, and bail out your counterparts, schoolmates, and entrepreneurs to a super colossal, charming, colossal, and agreeable section.
Explore, locate, and discover Middleburg home rentals, Middleburg vacation rentals, and bed and breakfast rentals in Middleburg.
Recognize and move rental houses Lorain, Lorain vacation rental, home rentals in Lorain Ohio, and rental houses in Lorain.
North Royalton Ohio is a pretty, enticing, fascinating, and beauteous turf with exquisite, delicate, and nice castle, flat, lodge, and townhouses.
North Royalton property managers, agents serving the condo market, real estate investors, and agents list houses for rent in North Royalton Ohio, North Royalton for rent by owner homes, holiday rentals in North Royalton Ohio, and North Royalton Ohio homes for rent.
Elicit, discover, and explore rental apartment Morrow, rental homes in Morrow, and Morrow condo rentals.
Find out, identify, and find apartment rentals and houses for rent.
Waterfront ad directories and spacious online MLS vacation homes, houses for rent in Knox Ohio, rental apartment Knox Ohio, and apartments for rent in Knox.
Catch, invent, and design Hamilton Ohio houses for rent, Hamilton Ohio holiday rentals, and Hamilton Ohio for rent by owner homes.
Espy, discover, and contrive rent house Montezuma, vacation homes in Montezuma United States, and Montezuma homes for rent.
Distinguish and locate rental properties in Athens Ohio, Athens Ohio apartment rentals, and Athens vacation homes.
Observe, determine, and hear vacation homes for rent by owner Erie Ohio and for rent by owner homes Erie.
Notice and originate houses for rent Navarre and condos for rent Navarre United States.
Hear and detect vacation homes in Brown, vacation rentals Brown Ohio, and vacation rental Brown.
Locate, design, and recognize condo rentals in Casstown, homes for rent in Casstown United States, and for rent by owner homes Casstown United States.
Determine discrete, singular, particular, and another story picture in North Royalton and catalogue rental apartment in North Royalton Ohio.
Send gorgeous and classy memorandums regarding North Royalton Ohio vacation rental, North Royalton Ohio holiday rentals, and North Royalton Ohio homes for rent by owner found on FRBO.Com, For Rent By Owner,.
The North Royalton Ohio studio ads, romantic ad directories, loft ads, and studio indexes for these can be mapped.
|
|
