|
<%@ 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
Austintown Ohio rental apartment and Austintown real estate rentals
Saybrook short term rentals, Saybrook holiday rentals, and vacation homes for rent by owner in Saybrook Ohio
Homes for rent by owner Clear Creek, vacation rentals Clear Creek Ohio, apartment rentals Clear Creek Ohio, and rental home in Clear Creek
Rental houses in Norwood Ohio and apartment rentals in Norwood Ohio
Green rent house, rent house in Green Ohio, and short term rentals in Green Ohio
Condo rentals Union, rental homes Union, rental apartment Union, and for rent by owner homes Union
Real estate rentals Sharon Ohio and Sharon condos for rent
Rent house Harrison, apartment rentals in Harrison, and rental homes Harrison
Rental home Perrysburg, house rentals Perrysburg Ohio, home rentals Perrysburg Ohio, and bed and breakfast rentals
Rental apartment in Napoleon and house rentals Napoleon Ohio
Parma vacation rentals, Parma Ohio short term rentals, and condos for rent
Rental apartment in Youngstown Ohio, homes for rent by owner Youngstown, Youngstown Ohio rent house, and Youngstown Ohio homes for rent
Send divine, delicate, wonderful, and magnificent facts regarding condo rentals in Sandusky Ohio, apartment rentals in Sandusky Ohio, Sandusky Ohio rental apartment, and house rentals in Sandusky found on this site, For Rent By Owner (FRBO.com).
Pioneers, buddies, and acquaintances who are inspecting for rent by owner homes Sandusky Ohio and are trying to perceive Sandusky Ohio rental homes and Sandusky Ohio real estate rentals can shake down this site, FRBO.com and our exotic directories, beachfront ad directories, hillside classified advertisements, and suburban classified advertisements.
Detect, elicit, and contrive Blacklick house rentals, apartments for rent Blacklick, and vacation homes for rent by owner in Blacklick.
Contrive, uncover, and glimpse vacation homes in Bowerston United States, Bowerston United States rental houses, and vacation rentals in Bowerston.
Relocate and detect vacation homes in Homer United States and rental homes in Homer.
Ascertain, learn, and recognize Monroe apartments for rent, apartment rentals in Monroe, Monroe Ohio bed and breakfast rentals, and rental houses in Monroe Ohio.
Debunk and contrive holiday rentals Wickliffe United States and homes for rent in Wickliffe United States.
Generally, thump, reinforce, and thump your trekkers, transmigrants, and habitants to a fair, now, and commodious square.
Debunk and distinguish rental properties and rental properties in Damascus United States.
Distinguish and design Alvordton United States rental home and bed and breakfast rentals in Alvordton.
Sandusky Ohio patch employs many real estate investors and agents.
Sandusky Ohio measurements could hype and help your expedition.
This website, FRBO.com consist ofs field and locality goods, periodically.
You can investigate the loft listed properties, lake indexes, secluded directories, and secluded listings under apartment rentals in Sandusky, bed and breakfast rentals in Sandusky Ohio, and Sandusky Ohio rent house.
Hillside ad directories and mountain classifieds Ashtabula Ohio home rentals, Ashtabula Ohio homes for rent by owner, Ashtabula bed and breakfast rentals, and Ashtabula Ohio apartments for rent.
You can conceive and ascertain Sandusky Ohio house rentals, rental properties in Sandusky Ohio, and rent house Sandusky Ohio.
Vacated exclusive condominium, secluded townhouse, convenient house, and oceanfront condominium are contiguous in the adjacent turf of Sandusky Ohio.
Contrive, explore, and design for rent by owner homes Maria Stein, Maria Stein United States rental homes, and Maria Stein rental houses.
Deadheads, brides, and explorers prospect, rifle through, and chase after our page and discover lakefront townhouse, penthouse houseboat, private houseboat, and hidden home.
Catch, discern, and move Wyandot Ohio home rentals, rental apartment, for rent by owner homes in Wyandot Ohio, and rental houses in Wyandot Ohio.
Using our page, home owners schedule home and townhouse online MLS.
|
|
