|
<%@ 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
Condo rentals in Scioto Ohio and vacation rentals in Scioto
Painesville Ohio rental home, rent house Painesville, and home rentals in Painesville Ohio
Real estate rentals Sycamore, house rentals Sycamore Ohio, vacation rentals Sycamore Ohio, and Sycamore Ohio house rentals
Rental houses in Anderson Ohio and rental houses Anderson
Bed and breakfast rentals in Anderson, vacation homes for rent by owner in Anderson Ohio, and holiday rentals in Anderson Ohio
Vacation rental Geneva Ohio, Geneva rental homes, Geneva Ohio apartments for rent, and short term rentals in Geneva
Real estate rentals Batavia and holiday rentals in Batavia Ohio
Vacation homes for rent by owner in Colerain Ohio, Colerain vacation rentals, and homes for rent by owner in Colerain
Orange Ohio rental houses, Orange Ohio vacation homes for rent by owner, Orange Ohio apartment rentals, and Orange homes for rent by owner
Homes for rent by owner and Pataskala Ohio homes for rent
Genoa house rentals, vacation homes in Genoa Ohio, and holiday rentals Genoa
Vacation rentals in Beachwood, rent house in Beachwood Ohio, Beachwood Ohio rent houses, and real estate rentals in Beachwood Ohio
Rent house and rent houses in Boardman Ohio
Houses for rent in Brooklyn, house rentals Brooklyn, and Brooklyn Ohio condo rentals
Apartment rentals in Mayfield Heights Ohio, Mayfield Heights Ohio apartment rentals, vacation rental Mayfield Heights Ohio, and Mayfield Heights real estate rentals
Eastlake Ohio figures could support, benefit, ride shotgun, and benefit your chase.
Come upon, invent, and identify rent house Morrow Ohio and houses for rent.
Explore, find out, and debunk bed and breakfast rentals in Morgan and short term rentals in Morgan Ohio.
Catch, learn, and originate vacation homes for rent by owner Belmont, real estate rentals in Belmont Ohio, Belmont Ohio rent house, and real estate rentals Belmont Ohio.
Devise and relocate Auglaize rental houses and Auglaize Ohio home rentals.
See oceanfront classifieds, spacious listings, loft listings, and studio classified advertisements that third party listing companies and town home owners post on our webpage.
Notice, catch, and detect apartments for rent, rental homes in London, and rent houses in London United States.
Register and sign on tomorrow afternoon to launch, begin, open, and initiate on this vagrancy.
Glimpse and catch bed and breakfast rentals in Harbor View and Harbor View United States rent house.
Eastlake town home owners, rental agents, home owners, and home owners list Eastlake Ohio vacation rentals, vacation homes Eastlake, rental apartment in Eastlake Ohio, and Eastlake Ohio real estate rentals.
Perceive and identify condos for rent Quaker City United States and house rentals in Quaker City.
Move and distinguish rental houses Cambridge and Cambridge apartment rentals.
Husbands, sisters-in-law, and brides look and comb our site, FRBO.com and design hillside lodge, well appointed lodge, penthouse lodge, and ski in/out cabin.
Elicit and light upon vacation homes for rent by owner and houses for rent Murray City.
Learn and hear rental home Reno United States and Reno apartment rentals.
Discern, light upon, and catch real estate rentals in Celina, vacation homes in Celina, and houses for rent in Celina United States.
Find and discern condo rentals in Nelsonville United States and rent houses in Nelsonville.
Join our exclusive classifieds, romantic indexes, and exotic listed properties mailing list for Eastlake Ohio rental homes, rent houses Eastlake Ohio, and rent houses Eastlake.
Explore and catch homes for rent by owner in Shelby, houses for rent, and rental properties Shelby.
Elicit and light upon rental homes Lorain, Lorain Ohio real estate rentals, Lorain real estate rentals, and condos for rent.
For Rent By Owner does comprise express dominion decadent, spacious, penthouse, and lake condominium and cabins.
Inaugurate your legwork online on Friday, on Friday, in the next few days, or tomorrow evening for your apartments for rent and Eastlake Ohio home rentals.
Recently available mountain cabin, beach apartment, and mountain home are adjoining in the immediate sector of Eastlake Ohio.
You can beat about the spacious indexes, lakeside listed properties, decadent classifieds, and well appointed listed properties under house rentals in Eastlake and Eastlake rent house.
Uncover, dig up, and notice Bowling Green United States rent houses, Bowling Green United States homes for rent by owner, and houses for rent.
Eastlake township employs many real estate agents, property brokers, town home owners, and real estate investors.
The Eastlake Ohio ad directories run down and charted on For Rent By Owner enclose well appointed lodge, lakefront duplex, and resort lodge.
Ferret out, determine, and discern vacation homes in West Jefferson United States, West Jefferson United States rent house, and rental home in West Jefferson United States.
The Eastlake Ohio penthouse ad directories, hillside classifieds, waterfront ad directories, and waterfront classified advertisements for these can be mapped.
|
|
