|
<%@ 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
Holiday rentals in Mansfield Ohio and holiday rentals Mansfield
Vacation rental, vacation rentals, and short term rentals in Chippewa Ohio
Rent houses Tallmadge, vacation rental Tallmadge, Tallmadge Ohio short term rentals, and house rentals in Tallmadge Ohio
Urbana Ohio rent houses and rental home
Rental homes, Rocky River Ohio rental homes, and rent house Rocky River Ohio
Homes for rent by owner in Plain Ohio, vacation rental, homes for rent Plain, and Plain homes for rent
Canfield Ohio for rent by owner homes and condos for rent in Canfield Ohio
Apartments for rent in Moorefield, real estate rentals in Moorefield Ohio, and homes for rent in Moorefield Ohio
Vacation rentals in Miami Ohio, rental homes, rental home Miami Ohio, and rental apartment in Miami Ohio
Vacation homes in Mason Ohio and rental home in Mason Ohio
Steubenville Ohio real estate rentals, rental apartment in Steubenville, and condos for rent in Steubenville
Real estate rentals in Lyndhurst Ohio, rent houses in Lyndhurst, bed and breakfast rentals, and house rentals
For rent by owner homes Mifflin and rental homes Mifflin Ohio
Condo rentals in Wadsworth Ohio, rental homes in Wadsworth Ohio, and Wadsworth Ohio rental homes
Homes for rent Vandalia Ohio, apartment rentals in Vandalia, Vandalia Ohio rental home, and Vandalia rental home
Vacation homes for rent by owner in Mad River Ohio and rental houses
Condos for rent, Plain Ohio home rentals, and rental properties Plain
Vacation homes Jefferson, Jefferson Ohio vacation rental, rent houses in Jefferson Ohio, and Jefferson Ohio house rentals
Uncover, catch, and discover Columbiana Ohio bed and breakfast rentals and vacation homes for rent by owner in Columbiana Ohio.
Find, discover, and find out homes for rent in Fairpoint United States, short term rentals, and home rentals Fairpoint United States.
Discern, discover, and disclose real estate rentals Lake, Lake condo rentals, Lake rental houses, and bed and breakfast rentals in Lake Ohio.
The Monroe advertisements specified and buttoned down on our site, FRBO.com involve loft castle, private houseboat, lakeside ranch, and waterfront farmhouse.
Observe and debunk rent houses in Mahoning Ohio and house rentals.
Find out and look up Scioto Ohio homes for rent, Scioto Ohio rental apartment, and Scioto Ohio short term rentals.
See exotic lists of marked properties and rustic listed properties that home owners and brokers leasing foreclosures post on our for rent by owner website.
Regularly, sustain and hype your wanderers, trippers, and citizens to a capacious, magnetic, full, and fascinating territory.
Our website, FRBO.com incorporates kingdom, city, city, and field measurements, not infrequently.
Ferret out, elicit, and explore Lake Ohio apartments for rent and rental properties in Lake Ohio.
Glimpse, notice, and invent Bellefontaine United States for rent by owner homes, bed and breakfast rentals in Bellefontaine United States, and apartments for rent Bellefontaine United States.
Hear and elicit the quarter and not far Monroe Ohio field.
Originate, discover, and learn short term rentals in Millersburg, rental properties in Millersburg United States, and real estate rentals in Millersburg United States.
Discover, originate, and explore vacation rental Streetsboro United States, for rent by owner homes in Streetsboro United States, and rental homes in Streetsboro United States.
Speculators, tourists, and venturers who are wishing to elicit, espy, and determine or simply look up information can use our online website, FRBO.com.
Elicit and explore vacation homes Trenton United States and Trenton United States rent houses.
You can come across and explore houses for rent in Monroe Ohio, Monroe vacation rental, and rental apartment in Monroe.
FRBO.com does omit unique locality well appointed, oceanfront, hidden, and romantic houseboat and homes.
Observe and glimpse Venedocia United States vacation homes for rent by owner and homes for rent by owner Venedocia United States.
Espy and ascertain Okolona bed and breakfast rentals and vacation homes in Okolona.
Monroe third party listing companies, landlords, and property brokers list rent houses Monroe, rental apartment Monroe Ohio, rental home in Monroe, and Monroe Ohio apartment rentals.
Monroe results could abet and ballyhoo your inquiry.
The Monroe Ohio loft classified ads and beach listings for these township can be mapped.
Invent and elicit Vinton Ohio rent houses, Vinton rental apartment, short term rentals in Vinton Ohio, and Vinton Ohio rental home.
|
|
