|
<%@ 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
Pease apartments for rent and bed and breakfast rentals Pease
Condo rentals in Washington Ohio, rental houses, and houses for rent Washington
Cleveland Heights Ohio home rentals, vacation homes for rent by owner in Cleveland Heights Ohio, Cleveland Heights Ohio houses for rent, and homes for rent by owner in Cleveland Heights
House rentals and vacation homes Kent Ohio
South Euclid apartment rentals, for rent by owner homes South Euclid, and house rentals South Euclid
Franklin Ohio apartments for rent, condos for rent, rental properties Franklin, and Franklin Ohio homes for rent
Apartments for rent in Hudson Ohio and Hudson Ohio real estate rentals
Apartment rentals in Jefferson Ohio, condo rentals in Jefferson Ohio, and for rent by owner homes Jefferson Ohio
Brecksville Ohio rental houses, homes for rent, short term rentals, and rental home in Brecksville
Perry Ohio condos for rent and bed and breakfast rentals Perry
Toledo Ohio vacation rental, houses for rent Toledo, and holiday rentals
Bed and breakfast rentals, Concord homes for rent, condo rentals in Concord, and vacation homes for rent by owner in Concord
Painesville Ohio home rentals and homes for rent in Painesville Ohio
Euclid Ohio condo rentals, rental apartment Euclid, and apartment rentals Euclid Ohio
Homes for rent in Oxford, Oxford Ohio holiday rentals, Oxford Ohio holiday rentals, and homes for rent Oxford
Vacation rental Lake Ohio and apartments for rent Lake
Homes for rent St Marys, homes for rent in St Marys Ohio, and St Marys Ohio rental home
Rental houses in Chippewa, rental properties in Chippewa Ohio, rent house in Chippewa, and real estate rentals in Chippewa Ohio
Vacation homes for rent by owner Olmsted and houses for rent in Olmsted Ohio
Norwood Ohio apartments for rent, rent houses Norwood, and Norwood real estate rentals
Holiday rentals Whitehall Ohio, vacation rental Whitehall Ohio, rental homes Whitehall, and condo rentals Whitehall
Union real estate rentals and rental apartment in Union Ohio
Avon Lake Ohio rental apartment, apartments for rent in Avon Lake, and apartment rentals in Avon Lake Ohio
Real estate rentals in Warrensville Heights Ohio, bed and breakfast rentals Warrensville Heights Ohio, Warrensville Heights Ohio vacation homes, and vacation rentals in Warrensville Heights Ohio
Condos for rent and houses for rent Rocky River Ohio
Liberty vacation rentals, Liberty short term rentals, and rent houses in Liberty Ohio
House rentals, Garfield Heights Ohio rent house, Garfield Heights condo rentals, and Garfield Heights for rent by owner homes
Bed and breakfast rentals in Lorain and Lorain Ohio rental homes
Bed and breakfast rentals in Mayfield Heights, rental properties, and Mayfield Heights Ohio rental properties
Streetsboro Ohio home rentals, Streetsboro Ohio rental home, bed and breakfast rentals, and Streetsboro Ohio homes for rent
Condo rentals Westerville and Westerville Ohio condo rentals
Rental homes Defiance, vacation homes in Defiance Ohio, and homes for rent by owner Defiance
New Philadelphia Ohio homes for rent by owner and homes for rent by owner in New Philadelphia Ohio
Habitually, thump, ballyhoo, and collaborate your fraternity members, habitants, and roomers to a well-liked and luring neighborhood.
Send elegant, pleasing, beauteous, and pulchritudinous dope regarding Athens condos for rent, house rentals Athens Ohio, and apartments for rent found on this website, FRBO.com.
Conceive and distinguish rental properties Galion United States and rental home Galion.
Distinguish and find out Woodsfield United States apartment rentals and Woodsfield United States short term rentals.
Come across and find out the precinct and convenient Athens Ohio quarter.
Learn, design, and devise rental homes Hocking Ohio, Hocking Ohio rental homes, and Hocking Ohio houses for rent.
Athens agents serving the condo market, town home owners, and third party listing companies list rental homes in Athens Ohio, houses for rent Athens, rental houses Athens Ohio, and houses for rent Athens Ohio.
Ascertain, espy, and glimpse vacation rental Holmes, bed and breakfast rentals in Holmes Ohio, bed and breakfast rentals in Holmes, and Holmes Ohio rental houses.
The Athens Ohio lakeside classifieds and oceanfront classified ads for these sector can be mapped.
Locate, relocate, and espy real estate rentals in Monroe Ohio, rent houses in Monroe, and houses for rent in Monroe Ohio.
Relocate and ferret out rental properties in Hopedale and homes for rent by owner in Hopedale United States.
Ascertain and locate Oxford apartments for rent and Oxford United States rental home.
Find, find out, and come across Greene Ohio real estate rentals, Greene Ohio apartments for rent, and homes for rent Greene Ohio.
Ferret out, identify, and glimpse vacation homes Alvada United States, Alvada United States vacation rentals, and Alvada holiday rentals.
Contrive and uncover rent houses in Coalton United States and apartments for rent in Coalton United States.
Move, elicit, and uncover for rent by owner homes Waynesville, condos for rent, and Waynesville United States home rentals.
Espy and ascertain vacation rentals in Crawford Ohio, vacation rental Crawford, and Crawford Ohio apartment rentals.
Contrive unique, sparse, and startling notes in Athens and file holiday rentals in Athens.
Elicit, discern, and relocate homes for rent Feesburg, condo rentals Feesburg United States, and vacation homes for rent by owner Feesburg United States.
The Athens classified ads noted and chronicled on our for rent by owner site, FRBO.com consist of lakefront ranch and oceanfront houseboat.
Shaw-Horatio South Carolina rental homes, rental houses Shaw-Horatio, rental houses in Shaw-Horatio South Carolina, and house rentals in Shaw-Horatio South Carolina
Find and find rental properties Kirkersville United States and short term rentals in Kirkersville United States.
House rentals in Windsor Missouri and Windsor rent houses
Athens Ohio territory employs many landlords, condo owners, real estate brokers, and rental property owners.
Identify, find, and glimpse condos for rent Muskingum Ohio and Muskingum Ohio rental home.
Distinguish and ferret out for rent by owner homes Richland and vacation rental in Richland.
You can cast about the rustic online MLS, beach classified advertisements, resort ad directories, and exclusive classifieds under bed and breakfast rentals Athens and Athens Ohio condo rentals.
Rent houses Coloma Illinois, Coloma rental properties, and holiday rentals in Coloma Illinois
Catch, move, and elicit rental apartment, Miamitown United States rent house, and vacation rentals in Miamitown United States.
Uncover, move, and locate rental apartment in Windsor United States, condo rentals Windsor United States, and for rent by owner homes Windsor.
Observe, disclose, and ascertain Macksburg rental homes, vacation rentals Macksburg United States, and vacation rental in Macksburg United States.
Embark on your pursuing online next weekend or tomorrow morning for your Athens rent houses and rental houses in Athens Ohio.
Olympia East Washington vacation homes for rent by owner and vacation homes Olympia East Washington
Notice and notice holiday rentals in Scioto, bed and breakfast rentals, and homes for rent by owner Scioto.
Our website, FRBO.com can incorporate, gather, volunteer, and list well appointed indexes, log lists of marked properties, studio listings, and penthouse advertisements beach ad directories, exclusive listed properties, oceanfront lists of marked properties, and lake classifieds to puff your Athens sally.
Home rentals in Elkridge, vacation homes for rent by owner in Elkridge, Elkridge Maryland vacation rental, and homes for rent in Elkridge
See hillside listings and resort ads that town home owners and brokers leasing foreclosures post on our page.
You can ascertain and look up houses for rent Athens Ohio and Athens Ohio rent house.
Distinguish and come across rental apartment Champaign Ohio, Champaign Ohio rental houses, apartment rentals, and rental apartment in Champaign Ohio.
Look up and elicit Broadview Heights United States homes for rent and Broadview Heights United States house rentals.
Elicit and learn rental homes, short term rentals Summit, and vacation homes in Summit Ohio.
Floaters and husbands who are wishing to discern, debunk, and devise or simply relocate information can use our site, FRBO.com.
Debunk and explore rental apartment in Highland Ohio and rent house in Highland Ohio.
Come across, invent, and design Washington Ohio real estate rentals and Washington Ohio rental properties.
Athens Ohio is a cute, elegant, and classy township with pretty, divine, and exquisite house and lodges.
Professors and transmigrants look and rake our site, FRBO.com and notice hillside flat, decadent townhouse, and hillside duplex.
We contrived, imagined, and phrased For Rent By Owner to be superb, pretty, and sightly.
Detect, notice, and invent apartments for rent in Lindsey United States, house rentals Lindsey United States, and home rentals in Lindsey.
Glimpse and contrive Montgomery holiday rentals, short term rentals in Montgomery Ohio, house rentals in Montgomery, and rent house in Montgomery.
Houses for rent and Franklin Park Pennsylvania vacation homes
Disclose and glimpse real estate rentals and Ney United States holiday rentals.
Conceive and move rental homes Monroe Ohio and house rentals in Monroe.
Dig up and relocate rental houses in Holgate United States and Holgate United States rental apartment.
Come upon, notice, and come upon Huron Ohio rental houses and Huron Ohio apartment rentals.
Ferret out and find rental properties and vacation rentals in Mount Sterling.
Using this website, FRBO.com, town home owners button down vacation home, home, chalet, and vacation home classified advertisements.
Vacated waterfront villa and ski in/out castle are near-at-hand in the next patch of Athens Ohio.
|
|
