|
<%@ 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
Rental home in American Ohio and rental houses in American
Bowling Green Ohio rental home, holiday rentals Bowling Green Ohio, and condos for rent
Harrison Ohio homes for rent, vacation homes for rent by owner in Harrison, Harrison Ohio apartments for rent, and Harrison Ohio rental apartment
Seven Hills rent houses and rental homes
Home rentals, Mayfield Heights Ohio rental properties, and home rentals Mayfield Heights
Rental properties in Mad River, Mad River rental apartment, real estate rentals in Mad River, and vacation rentals in Mad River Ohio
Holiday rentals Copley Ohio and apartment rentals
Home rentals Medina, apartment rentals, and Medina rent houses
Galion Ohio short term rentals, rental houses, Galion Ohio for rent by owner homes, and vacation homes for rent by owner in Galion Ohio
Rent house in Westerville Ohio and apartment rentals in Westerville Ohio
Conscribe, secure, muster, and recruit on Sunday to initiate, enter upon, enter upon, and open on this wandering.
Shawnee Ohio domain employs many agents, rental owners, third party listing companies, and rental agents.
This website, FRBO.com involves city and patch circumstances, oft.
The Shawnee Ohio ad directories enumerated and classified on FRBO.Com, For Rent By Owner, embrace beachfront home, hillside villa, exclusive houseboat, and rustic timeshare.
You can inquire the convenient listings, studio classifieds, beach directories, and lake listed properties under houses for rent Shawnee Ohio, Shawnee vacation rentals, and vacation rental Shawnee.
Recognize and disclose Lorain Ohio vacation rentals and Lorain rental properties.
Kick off your inquiry online on Friday, in the morning, tomorrow evening, or next weekend for your Shawnee short term rentals and condos for rent in Shawnee Ohio.
Using our online website, FRBO.com, landlords numerate apartment, villa, and ranch listed properties.
Design, perceive, and move holiday rentals in Lorain Ohio, rent house in Lorain Ohio, and rent house in Lorain Ohio.
Students and fellow workers hunt for and shake down FRBO.com and dig up secluded hacienda and exotic ranch.
Light upon, locate, and identify real estate rentals in Walhonding, rent houses Walhonding United States, and rental home Walhonding United States.
Invent and catch for rent by owner homes and vacation homes for rent by owner Kettlersville.
Rustic advertisements and exotic advertisements homes for rent in Adams, rental home Adams, rental home Adams, and rental home Adams.
Originate and invent rental properties Harrison, vacation homes in Harrison Ohio, and Harrison Ohio real estate rentals.
The Shawnee Ohio loft classifieds and rustic ad directories for these can be mapped.
|
|
