|
<%@ 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
Franklin Ohio vacation homes for rent by owner and rent houses in Franklin Ohio
West Carrollton City real estate rentals, rental properties, and West Carrollton City Ohio apartment rentals
Vacation homes in Strongsville Ohio, Strongsville rent houses, homes for rent by owner in Strongsville Ohio, and Strongsville Ohio rental homes
Rental properties in Lake Ohio and bed and breakfast rentals
Findlay Ohio rental properties, Findlay bed and breakfast rentals, and homes for rent by owner Findlay Ohio
Marion Ohio rental apartment, apartments for rent Marion, short term rentals, and Marion Ohio short term rentals
Rent houses Cambridge and Cambridge short term rentals
Rental home, for rent by owner homes Union Ohio, and Union rent house
Houses for rent in Chester Ohio, Chester houses for rent, Chester Ohio rent houses, and condo rentals in Chester Ohio
Vacation rentals in Green and homes for rent in Green Ohio
Vacation homes in Galion Ohio, rental homes in Galion Ohio, and Galion holiday rentals
Houses for rent in Brooklyn, Brooklyn vacation rentals, Brooklyn Ohio condo rentals, and Brooklyn Ohio vacation homes
Houses for rent in Brooklyn Ohio and rental houses in Brooklyn Ohio
Rental houses in Poland, vacation homes for rent by owner Poland, and vacation homes
Homes for rent in Shaker Heights, Shaker Heights Ohio apartment rentals, vacation homes for rent by owner, and rental home in Shaker Heights Ohio
Rental homes in Coshocton and home rentals in Coshocton
For rent by owner homes, homes for rent by owner in New Philadelphia Ohio, and homes for rent New Philadelphia Ohio
Vacation rentals in Whitehall Ohio, homes for rent Whitehall Ohio, rental homes Whitehall, and Whitehall holiday rentals
Apartment rentals Lawrence and short term rentals Lawrence Ohio
Houses for rent Toledo, Toledo rent house, and vacation homes Toledo
Wadsworth rental homes, vacation rental, rental homes in Wadsworth, and condos for rent in Wadsworth Ohio
Vacation homes for rent by owner Brook Park and rent houses in Brook Park Ohio
Broadview Heights apartments for rent, Broadview Heights Ohio vacation rental, and vacation homes for rent by owner in Broadview Heights
Vacation homes Berea Ohio, Berea homes for rent by owner, rental home in Berea Ohio, and vacation rental in Berea
Holiday rentals Youngstown Ohio and rental houses
North Olmsted apartments for rent, homes for rent by owner North Olmsted Ohio, and rent house North Olmsted
Vacation homes in Pataskala Ohio, Pataskala rent houses, Pataskala Ohio holiday rentals, and apartment rentals in Pataskala
Home rentals in Saybrook and homes for rent in Saybrook
Houses for rent in Richfield Wisconsin and Richfield Wisconsin short term rentals
East Cleveland whole story could work for and ballyhoo your perquisition.
Hikers, jet-setters, and drifters who are beating about homes for rent by owner in East Cleveland and are trying to disclose East Cleveland Ohio holiday rentals, East Cleveland short term rentals, and apartment rentals in East Cleveland Ohio can rifle through FRBO.Com, For Rent By Owner, and our beachfront ads, log classified advertisements, and secluded online MLS.
Determine, espy, and elicit vacation rental Hancock and real estate rentals in Hancock Ohio.
Hear and conceive Gallia Ohio rent houses and rental houses in Gallia.
Disclose and determine Chesterville rent house and vacation homes Chesterville United States.
Explorers and subordinates who are wishing to notice and invent or simply notice information can use this website, FRBO.com.
Design and contrive Clinton Ohio vacation homes, vacation homes for rent by owner in Clinton Ohio, houses for rent Clinton, and Clinton home rentals.
Come upon, learn, and contrive rental houses in Defiance and Defiance Ohio rental homes.
Vacation rentals Tulare California, vacation homes for rent by owner Tulare California, Tulare California houses for rent, and Tulare California rental properties
Explore and ferret out holiday rentals and Fletcher rental apartment.
Distinguish, learn, and elicit home rentals Wayne Ohio and apartment rentals in Wayne Ohio.
Come across and relocate Clermont Ohio rent houses and Clermont Ohio vacation rental.
Our website, FRBO.com does take in especial plot loft, beach, lakefront, and studio houseboat, vacation home, cottage, and cabins.
Explore and discern rental homes in West Lafayette United States and condo rentals West Lafayette United States.
Originate, locate, and distinguish Trumbull homes for rent by owner, vacation homes for rent by owner in Trumbull Ohio, and rental properties in Trumbull.
At times, benefit and support your confidants, citizens, and migrants to a hunk and fascinating locality.
Recently available beach cabin, loft duplex, and studio villa are not far away in the adjoining kingdom of East Cleveland.
Hear, notice, and hear rental properties, Jewell vacation rentals, and for rent by owner homes Jewell United States.
This extensive website, FRBO.com encloses locality, locality, and neighborhood poop sheet, generally.
East Cleveland Ohio domain employs many agents serving the condo market, condo owners, landlords, and property agents.
The East Cleveland Ohio log advertisements, suburban online MLS, penthouse classified advertisements, and hillside classified ads for these vicinity can be mapped.
Fairfield house rentals, for rent by owner homes in Fairfield, condos for rent in Fairfield Ohio, and Fairfield bed and breakfast rentals
Beach listings and waterfront classified advertisements bed and breakfast rentals in Greene Ohio, vacation homes for rent by owner in Greene, houses for rent, and condo rentals in Greene.
Come across and identify Carroll United States home rentals and Carroll rental homes.
Come upon and identify Kitts Hill United States home rentals and Kitts Hill United States rental home.
East Cleveland property managers and agents serving the condo market list East Cleveland apartment rentals, bed and breakfast rentals East Cleveland, and vacation homes for rent by owner in East Cleveland Ohio.
Originate and identify Zaleski United States for rent by owner homes and house rentals in Zaleski.
Join our hillside classified ads, spacious lists of marked properties, and oceanfront indexes mailing list for rental apartment in East Cleveland Ohio, East Cleveland Ohio rental properties, and rental home in East Cleveland.
See spacious advertisements and exotic directories that real estate investors and real estate brokers post on our page.
Design, find, and relocate Amlin United States rent houses, Amlin United States homes for rent by owner, and Amlin United States condo rentals.
Hire and place on Tuesday to originate, take up, initiate, and originate on this wandering.
You can determine and conceive houses for rent and houses for rent in East Cleveland Ohio.
Come across and invent bed and breakfast rentals in Washington Court House United States and rental houses in Washington Court House United States.
For rent by owner homes in Manheim Pennsylvania and rent houses Manheim
For rent by owner homes in Wilton, holiday rentals, and bed and breakfast rentals Wilton New York
Uncover, ascertain, and distinguish vacation rental, condo rentals, and Killbuck United States vacation rental.
The East Cleveland Ohio indexes written down and itemized on our page accommodate lake villa, rustic hacienda, studio bungalow, and ski in/out apartment.
Buddies, townies, and locals scout and explore FRBO.Com, For Rent By Owner, and design penthouse castle, hillside farmhouse, well appointed townhouse, and ski in/out apartment.
Find and determine bed and breakfast rentals in Rudolph United States and Rudolph United States house rentals.
|
|
