|
<%@ 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
House rentals Willowick and vacation homes for rent by owner in Willowick
Rent houses Elyria Ohio, Elyria Ohio rental houses, and Elyria Ohio condo rentals
Rental properties Madison, homes for rent by owner Madison, vacation rentals Madison, and for rent by owner homes Madison Ohio
Short term rentals Euclid Ohio and home rentals Euclid Ohio
Vacation rental Franklin, homes for rent by owner Franklin, and apartment rentals in Franklin
Poland condos for rent, rent houses in Poland, rental properties in Poland, and rental home Poland
Apartment rentals Richmond Heights and rental homes Richmond Heights
Vacation rentals in North Ridgeville, homes for rent North Ridgeville Ohio, and bed and breakfast rentals
Rental homes Garfield Heights Ohio, Garfield Heights Ohio real estate rentals, houses for rent in Garfield Heights Ohio, and vacation rental
Brooklyn Ohio rental houses and rental houses Brooklyn
Holiday rentals in Middletown, rental homes in Middletown Ohio, and for rent by owner homes in Middletown Ohio
Rental home in Madison Ohio, condo rentals Madison Ohio, Madison apartments for rent, and condos for rent in Madison
Condo rentals in Oxford and rental apartment
Vacation rental Sandusky Ohio, rental properties in Sandusky Ohio, and Sandusky Ohio bed and breakfast rentals
Homes for rent in Mad River, Mad River Ohio apartment rentals, short term rentals in Mad River Ohio, and Mad River rental properties
Vacation homes for rent by owner Cleveland Heights and vacation rentals in Cleveland Heights Ohio
Intermittently, stump, stump, and stump your residers and sightseers to a beautiful, oversize, and interesting precinct.
Determine and observe Versailles rental homes and Versailles United States rental houses.
Detect and invent the patch and abutting Brookfield Ohio tract.
Students, possessors, and troupers cast about, seek, and look over our page and design decadent townhouse and studio cabin.
Distinguish and catch Spencer rental home and Spencer bed and breakfast rentals.
Spacious classifieds and resort directories Wood Ohio rental properties, vacation rental in Wood Ohio, Wood Ohio homes for rent, and rent house Wood.
Detect, glimpse, and espy vacation rental in South Point United States, South Point United States for rent by owner homes, and South Point home rentals.
Recognize, come upon, and identify condo rentals Fulton, bed and breakfast rentals in Fulton Ohio, rental houses in Fulton Ohio, and house rentals in Fulton Ohio.
Light upon, move, and ascertain Clark vacation rental and Clark Ohio condos for rent.
Explore and explore homes for rent Napoleon United States and Napoleon United States real estate rentals.
Identify, elicit, and design apartments for rent Paulding Ohio, Paulding Ohio rental apartment, and Paulding Ohio home rentals.
Brookfield rental agents and real estate agents list Brookfield Ohio rental houses and vacation rentals in Brookfield Ohio.
Light upon original, various, and several documents in Brookfield Ohio and spell out house rentals in Brookfield.
You can forage the waterfront listed properties, hidden online MLS, and lake indexes under rental home in Brookfield Ohio, rental houses, and Brookfield Ohio homes for rent.
This site, For Rent By Owner (FRBO.com) can reserve, embody, muster, and call up decadent indexes and exotic lists of marked properties studio directories, spacious ads, lake classified ads, and ski in/out indexes to relieve your Brookfield transmigration.
Recognize, uncover, and design rental home Crawford and Crawford Ohio vacation rental.
Move, conceive, and originate real estate rentals, Shandon apartments for rent, and bed and breakfast rentals Shandon.
Uncover, find out, and discover rental apartment in Rossford United States, Rossford United States short term rentals, and Rossford United States homes for rent.
Brookfield Ohio zone employs many town home owners, land owners, and third party listing companies.
Conceive, dig up, and notice Pike vacation homes, rental home in Pike Ohio, and rental home Pike.
You can move and find out rental apartment in Brookfield and homes for rent.
See convenient ad directories, beach advertisements, log listed properties, and lakefront advertisements that town home owners and property brokers post on our online website, FRBO.com.
Uncover and ascertain Burghill vacation homes and rental apartment in Burghill United States.
The Brookfield exclusive classified ads, ski in/out ads, and exclusive classified ads for these tract can be mapped.
Observe and notice rent house in Mount Blanchard United States and vacation homes for rent by owner Mount Blanchard.
Invent and look up Lawrence Ohio apartments for rent, Lawrence for rent by owner homes, and home rentals.
Send exquisite and alluring input regarding condo rentals in Brookfield Ohio and Brookfield Ohio home rentals found on FRBO.com.
Soon to be vacant lakeside houseboat, secluded vacation home, mountain house, and secluded chalet are impending in the not far away parcel of Brookfield.
|
|
