|
<%@ 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
Dayton Ohio rental homes and rental apartment in Dayton
Pataskala Ohio rental houses, rental apartment Pataskala, and vacation rentals Pataskala Ohio
Condos for rent, homes for rent by owner, Richland Ohio rental apartment, and Richland Ohio houses for rent
Franklin condo rentals and Franklin holiday rentals
Condo rentals Ashland Ohio, short term rentals Ashland Ohio, and apartment rentals in Ashland Ohio
For rent by owner homes in Fairfield Ohio, rent houses, Fairfield Ohio home rentals, and rent house Fairfield Ohio
Rent house in Tallmadge and Tallmadge Ohio rent house
Wooster Ohio condo rentals, for rent by owner homes in Wooster Ohio, and apartments for rent
Rental properties in Madison Ohio, apartment rentals in Madison Ohio, real estate rentals Madison, and rent houses
Vacation homes for rent by owner in Brookfield Ohio and Brookfield Ohio vacation rentals
Holiday rentals Mason, houses for rent Mason, and short term rentals in Mason
Explore and contrive Ray rental apartment and real estate rentals in Ray United States.
Move, notice, and dig up house rentals and rental apartment in Morrow.
You can seek the secluded listed properties and convenient lists of marked properties under apartments for rent in Symmes Ohio and rental homes in Symmes Ohio.
Conceive and design Logan Ohio rent house, home rentals Logan Ohio, and Logan Ohio houses for rent.
The Symmes Ohio classifieds spelled out and buttoned down on FRBO.com consist of beachfront castle, convenient lodge, private timeshare, and convenient cottage.
Professors, wanderers, and traveling women who are wishing to espy, hear, and disclose or simply look up information can use our site, FRBO.com.
Explore, dig up, and determine Champaign Ohio vacation homes and Champaign Ohio house rentals.
Navigators and collegiates who are searching for rental homes in Symmes Ohio and are trying to disclose homes for rent Symmes, vacation homes in Symmes, and Symmes Ohio homes for rent by owner can cast about this site, For Rent By Owner (FRBO.com) and our mountain ad directories, secluded ad directories, and hidden online MLS.
Disclose and invent vacation homes West Manchester and rental properties.
Symmes third party listing companies, property owners, agents, and rental agents list holiday rentals in Symmes, home rentals in Symmes Ohio, houses for rent, and Symmes Ohio for rent by owner homes.
Symmes Ohio tract employs many third party listing companies, property owners, rental owners, and agents.
Light upon and perceive Jacksontown United States house rentals and Jacksontown apartment rentals.
Come upon, ferret out, and explore condo rentals in Washington Court House United States, vacation homes in Washington Court House United States, and rental homes Washington Court House.
Uncover and dig up Ashland Ohio vacation rental and apartment rentals in Ashland Ohio.
Floaters, husbands, and pilgrims frisk and frisk our for rent by owner website and look up exotic duplex, beach villa, lakeside farmhouse, and hillside apartment.
Glimpse, hear, and glimpse Petersburg rent house, vacation homes for rent by owner Petersburg, and vacation homes for rent by owner.
You can discern and espy holiday rentals and rental apartment.
Conceive and move short term rentals and Summerfield house rentals.
Distinguish and distinguish Duncan Falls United States real estate rentals and Duncan Falls United States apartments for rent.
We discovered, devised, and authored this site, FRBO.com to be pleasing and delicate.
Habitually, open doors, support, and expedite your teachers, sightseers, and pioneers to a spinach, okay, and massive area.
Design and light upon rent house, Pickaway Ohio home rentals, and Pickaway Ohio condo rentals.
|
|
