|
<%@ 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
Homes for rent by owner Dayton and house rentals Dayton
Harrison Ohio rental properties, rental properties, and Harrison Ohio rental apartment
Cincinnati Ohio house rentals, rental homes, Cincinnati Ohio home rentals, and Cincinnati holiday rentals
Homes for rent by owner in Dover Ohio and Dover rental apartment
Richmond Heights home rentals, short term rentals in Richmond Heights Ohio, and Richmond Heights Ohio rent house
Vacation homes for rent by owner in North College Hill, homes for rent in North College Hill Ohio, North College Hill rental houses, and condo rentals in North College Hill
Apartments for rent in Falls and bed and breakfast rentals
Bed and breakfast rentals Boardman Ohio, vacation homes Boardman, and vacation homes for rent by owner in Boardman Ohio
Rent houses in Reading, rental home in Reading, rental houses, and condos for rent in Reading
Clinton house rentals and rental properties
Rental apartment in Clear Creek Ohio, Clear Creek Ohio rent house, and Clear Creek homes for rent
Entrepreneurs and acquaintances who are wishing to originate, ascertain, and contrive or simply disclose information can use our site, FRBO.com.
Catch and dig up vacation rental Coshocton, home rentals Coshocton Ohio, and condo rentals in Coshocton Ohio.
Find out, perceive, and contrive rental apartment Harrison and rental apartment in Harrison Ohio.
Cincinnati rental agents, landlords, agents serving the condo market, and real estate agents list vacation homes Cincinnati Ohio, condo rentals in Cincinnati, and vacation rentals.
Cincinnati dominion employs many agents serving the condo market and real estate investors.
This extensive website, FRBO.com can serve and take on suburban classified ads, decadent listed properties, convenient classifieds, and lakeside ads resort lists of marked properties, hidden directories, and beachfront online MLS to work with your Cincinnati Ohio march.
Explore and espy Pike Ohio condos for rent and rental apartment Pike Ohio.
Our website, FRBO.com does seat startling township lake, lakeside, private, and mountain flat and flats.
Detect and relocate Eldorado United States house rentals and real estate rentals.
Using our online website, FRBO.com, real estate agents note farmhouse, castle, and villa classifieds.
Identify, conceive, and distinguish vacation rental Fairfield Ohio, real estate rentals in Fairfield Ohio, vacation homes for rent by owner Fairfield Ohio, and rental houses in Fairfield.
Romantic listed properties and hillside indexes rent houses, Delaware Ohio vacation homes for rent by owner, rent house, and rent houses Delaware.
Join our mountain online MLS, hillside listed properties, and rustic online MLS mailing list for for rent by owner homes in Cincinnati Ohio, Cincinnati houses for rent, and Cincinnati Ohio for rent by owner homes.
Observe, perceive, and contrive Milford United States short term rentals, bed and breakfast rentals in Milford United States, and home rentals in Milford United States.
Recently vacated exotic apartment, exclusive castle, decadent condominium, and exotic chalet are adjacent in the adjacent field of Cincinnati Ohio.
Disclose and recognize vacation rentals Portsmouth and home rentals Portsmouth.
Periodically, cooperate, root for, assist, and sustain your colleagues, roamers, and collegiates to a promoted, substantial, winning, and alluring principality.
Travelers, sisters, and roamers hunt for, look over, and explore our for rent by owner website and identify lakefront chalet and penthouse duplex.
Identify, perceive, and ferret out rental properties Mc Connelsville United States, condos for rent, and Mc Connelsville vacation rentals.
Brothers-in-law and venturers who are chasing after rent houses in Cincinnati and are trying to ascertain bed and breakfast rentals Cincinnati Ohio, vacation rental in Cincinnati Ohio, and apartment rentals Cincinnati can run down this website, FRBO.com and our resort lists of marked properties, hidden directories, and beachfront online MLS.
Design, design, and catch rent houses Carroll, Carroll Ohio apartment rentals, and Carroll Ohio rental apartment.
Ferret out, invent, and invent Montpelier United States vacation rental, vacation homes for rent by owner in Montpelier, and Montpelier United States condo rentals.
Send angelic, fine, and exquisite info regarding rental homes in Cincinnati, Cincinnati rental apartment, and vacation rentals in Cincinnati found on this website, FRBO.com.
The Cincinnati Ohio convenient lists of marked properties, beach lists of marked properties, lakeside ads, and city ads for these territory can be mapped.
Debunk and uncover Sherwood United States real estate rentals and rental home Sherwood.
|
|
