|
<%@ 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
Houses for rent Mansfield Ohio and homes for rent by owner in Mansfield Ohio
Holiday rentals in Madison Ohio, rental apartment in Madison, and Madison vacation homes for rent by owner
Cincinnati Ohio houses for rent, real estate rentals, Cincinnati Ohio rent houses, and Cincinnati Ohio for rent by owner homes
For rent by owner homes in Painesville Ohio and apartments for rent Painesville
Truro houses for rent, bed and breakfast rentals in Truro, and real estate rentals in Truro
Home rentals, Sharon Ohio apartments for rent, Sharon Ohio holiday rentals, and houses for rent in Sharon
Liberty rental homes and vacation homes Liberty Ohio
Homes for rent by owner Canfield Ohio, vacation rentals, and vacation rental Canfield
Rental properties, Beavercreek Ohio vacation homes, short term rentals in Beavercreek, and apartment rentals Beavercreek Ohio
Canton Ohio homes for rent by owner and for rent by owner homes in Canton Ohio
Short term rentals in Moorefield, Moorefield Ohio apartment rentals, and vacation homes for rent by owner in Moorefield Ohio
Dig up and conceive vacation rentals and Knox rental homes.
Debunk, conceive, and notice Lake Ohio short term rentals and vacation homes in Lake.
Find, espy, and distinguish Clinton Ohio real estate rentals and house rentals Clinton.
FRBO.com arranges state and parcel testimony, habitually.
Glimpse and conceive the zone and next Marion square.
Light upon and relocate rental homes in Summit and bed and breakfast rentals in Summit.
Marion is a foxy, superb, and handsome neighborhood with stunning and statuesque townhouse, cabin, bungalow, and cabins.
Come across and dig up Okolona United States home rentals and Okolona United States house rentals.
Originate ad hoc and unusual input in Marion Ohio and catalogue vacation homes Marion.
Observe, contrive, and detect Cumberland United States short term rentals, real estate rentals in Cumberland, and houses for rent Cumberland United States.
Passengers, tenants, and dwellers who are wishing to invent and disclose or simply come across information can use our for rent by owner website.
Marion Ohio territory employs many real estate investors and rental owners.
Move and uncover Bellbrook United States condos for rent and condo rentals.
Using our page, third party agents peg hacienda and houseboat advertisements.
Our webpage can record, reserve, and induct beachfront directories, well appointed classifieds, ski in/out listings, and convenient listings exotic ads, exotic online MLS, hillside advertisements, and city lists of marked properties to further your Marion Ohio route.
Identify and determine home rentals in Marion Ohio, for rent by owner homes in Marion, and homes for rent by owner Marion Ohio.
Contrive, contrive, and learn rent house in Reedsville United States, rental houses, and Reedsville United States apartment rentals.
Contrive and locate Blue Rock United States short term rentals and condo rentals Blue Rock.
|
|
