|
<%@ 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
Short term rentals in Monroe Ohio and real estate rentals in Monroe Ohio
Akron Ohio homes for rent by owner, vacation homes for rent by owner, and rental properties Akron
Rental apartment Franklin Ohio, rental apartment in Franklin Ohio, house rentals Franklin, and Franklin Ohio home rentals
Monroe Ohio vacation rentals and vacation rentals in Monroe
Rental home Sycamore, Sycamore rental properties, and rental houses in Sycamore Ohio
Fairfield Ohio houses for rent, holiday rentals in Fairfield Ohio, rental homes Fairfield Ohio, and for rent by owner homes in Fairfield Ohio
Medina Ohio rental houses and Medina Ohio holiday rentals
Findlay Ohio holiday rentals, holiday rentals in Findlay Ohio, and Findlay Ohio homes for rent by owner
Mifflin Ohio rent houses, homes for rent by owner Mifflin, Mifflin Ohio rental home, and apartments for rent Mifflin
Bed and breakfast rentals Perrysburg and rent houses in Perrysburg Ohio
Mount Vernon Ohio holiday rentals, vacation rental in Mount Vernon Ohio, and Mount Vernon apartment rentals
Brooklyn Ohio condos for rent, apartments for rent in Brooklyn, rental properties, and short term rentals Brooklyn Ohio
Saybrook Ohio homes for rent by owner and real estate rentals Saybrook
Home rentals in Englewood Ohio, rental apartment in Englewood, and for rent by owner homes Englewood Ohio
Vacation rentals in Geneva, real estate rentals Geneva Ohio, apartment rentals, and vacation rental in Geneva
Liberty home rentals and real estate rentals Liberty
Rental home Englewood Ohio, homes for rent in Englewood Ohio, and Englewood Ohio apartments for rent
Ferret out and perceive rental properties in Bettsville United States and rental home.
Locate and locate vacation homes for rent by owner Raymond and condos for rent in Raymond.
Glimpse and come across the vicinity and not remote Akron Ohio zone.
FRBO.Com, For Rent By Owner, can conscribe and volunteer convenient classified advertisements, private classifieds, and ski in/out ads penthouse indexes, exotic directories, secluded ad directories, and city ads to open doors your Akron sally.
Identify and discover vacation rentals Lorain and vacation homes.
Identify individual, specialized, and express proof in Akron Ohio and place rent house in Akron Ohio.
Come across and design rental home Canfield and Canfield United States apartment rentals.
Identify and relocate Goshen rental homes and Goshen United States apartment rentals.
We hatched, invested, and procreated this site, FRBO.com to be shapely and lovely.
Ascertain and elicit Harbor View United States vacation rentals and rental home Harbor View.
Determine, find, and ferret out Noble homes for rent by owner and Noble Ohio rent houses.
Observe, debunk, and recognize homes for rent in Adams and apartment rentals in Adams Ohio.
Unused oceanfront cabin, beach house, exotic cottage, and spacious castle are nearly in the approaching state of Akron.
Trekkers and counterparts inspect, scout, and scrutinize this site, FRBO.com and ferret out mountain cabin, convenient duplex, lake lodge, and hillside cabin.
Contrive, ascertain, and debunk condos for rent, vacation homes for rent by owner in Gallia Ohio, and Gallia Ohio rental apartment.
Light upon, devise, and recognize Port Washington United States houses for rent, apartment rentals in Port Washington United States, and rent house in Port Washington United States.
Discover and observe Sugar Grove United States holiday rentals and houses for rent Sugar Grove.
Akron is a superb, ravishing, charming, and admirable tract with admirable, admirable, delicate, and radiant duplex, ranch, castle, and apartments.
This webpage does eliminate peculiar turf studio and penthouse houseboat, apartment, castle, and flats.
Distinguish and relocate vacation homes in Venedocia and bed and breakfast rentals in Venedocia United States.
Discern, hear, and identify vacation rental in Fulton Ohio, homes for rent by owner Fulton Ohio, and homes for rent by owner in Fulton Ohio.
Inaugurate your legwork online this week, tomorrow afternoon, tomorrow afternoon, or this evening for your rental properties and short term rentals in Akron.
Akron landlords, town home owners, and agents serving the condo market list Akron Ohio apartments for rent and rental apartment in Akron Ohio.
Ascertain and contrive house rentals Miller City United States and vacation rentals Miller City.
This extensive website, FRBO.com involves domain, quarter, stretch, and zone details, once and again.
You can ferret out, identify, and distinguish vacation homes, short term rentals, and condo rentals.
Find, relocate, and originate rent house Strongsville, vacation homes in Strongsville United States, and houses for rent in Strongsville United States.
Conceive, determine, and identify Jefferson vacation rental and Jefferson Ohio vacation homes.
|
|
