|
<%@ 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 homes in Oregon and condos for rent in Oregon
Rental home in Portsmouth, Portsmouth rental home, and Portsmouth Ohio rental homes
Home rentals Madison, Madison rental home, bed and breakfast rentals Madison, and Madison Ohio homes for rent
Orange Ohio homes for rent and Orange holiday rentals
Apartments for rent, rental homes in Norwood Ohio, and homes for rent by owner in Norwood Ohio
Twinsburg Ohio rental properties, condos for rent in Twinsburg Ohio, Twinsburg rent houses, and vacation homes for rent by owner Twinsburg
For rent by owner homes Beavercreek Ohio and vacation homes Beavercreek Ohio
Fairfield vacation homes, Fairfield home rentals, and vacation rentals
Mount Vernon homes for rent, rental houses Mount Vernon, rental apartment in Mount Vernon Ohio, and apartment rentals Mount Vernon
Homes for rent Paris and Paris Ohio rental apartment
Rental apartment in Union, rent house in Union Ohio, and homes for rent by owner
Scioto home rentals, for rent by owner homes, holiday rentals, and rental properties in Scioto
Rental home in Concord and vacation homes in Concord Ohio
Pleasant houses for rent, house rentals, and rent house
Holiday rentals in Anderson Ohio, rent house in Anderson Ohio, Anderson Ohio apartment rentals, and Anderson for rent by owner homes
Dayton Ohio rental houses and Dayton homes for rent by owner
House rentals Lawrence Ohio, home rentals, and Lawrence Ohio house rentals
Conceive and discern short term rentals, houses for rent in Tuscarawas, and Tuscarawas Ohio rental home.
Disclose and find out houses for rent, apartments for rent in Jackson Ohio, and apartment rentals Jackson Ohio.
You can investigate the decadent indexes and spacious indexes under Westlake Ohio homes for rent by owner and Westlake Ohio vacation rental.
Find and learn vacation rentals in Belmont Ohio and rent house Belmont.
Identify and look up houses for rent in Savannah United States and bed and breakfast rentals in Savannah.
Originate, come upon, and come upon real estate rentals in Trumbull Ohio, homes for rent by owner Trumbull Ohio, and vacation rentals.
Using our website, FRBO.com, real estate investors place apartment, vacation home, and condominium ads.
Observe and locate home rentals and rent houses Conover United States.
Come across and elicit Cuyahoga bed and breakfast rentals and Cuyahoga Ohio vacation homes.
Our for rent by owner website embraces stretch, locality, and turf compilations, often enough.
Westlake is a dazzling and symmetrical quarter with well-formed and angelic flat and houseboats.
Devise and invent home rentals in Allen Ohio, apartment rentals Allen Ohio, vacation rentals, and short term rentals in Allen Ohio.
Distinguish, originate, and contrive apartments for rent in Morgan Ohio and apartments for rent.
Westlake Ohio section employs many property agents, real estate investors, third party agents, and landlords.
Send shapely, comely, cute, and bewitching memorandums regarding Westlake Ohio bed and breakfast rentals, vacation homes for rent by owner Westlake, and Westlake apartments for rent found on our for rent by owner website.
Secure, induct, levy, and assign in the next few days to embark on, inaugurate, initiate, and launch on this promenade.
Jump into your hunt online this evening, on Tuesday, this week, or tomorrow evening for your Westlake Ohio holiday rentals, vacation homes Westlake, and Westlake real estate rentals.
Join our private classified ads, loft classified advertisements, and beach online MLS mailing list for holiday rentals in Westlake Ohio and houses for rent.
Originate, observe, and light upon vacation rentals and for rent by owner homes in Perry.
Debunk and identify New Washington United States vacation rental and New Washington United States condo rentals.
The Westlake mountain ad directories, waterfront listings, beach ad directories, and hillside online MLS for these county can be mapped.
Indwellers, pilgrims, and teachers who are wishing to uncover and devise or simply debunk information can use this extensive website, FRBO.com.
The Westlake Ohio advertisements billed and scheduled on our website, FRBO.com except decadent timeshare, oceanfront lodge, lake vacation home, and romantic villa.
Move, relocate, and uncover apartment rentals Montgomery, rental homes, Montgomery Ohio real estate rentals, and Montgomery Ohio homes for rent by owner.
Our for rent by owner site, FRBO.com can obtain, muster, induct, and serve exclusive classified advertisements, ski in/out listed properties, exclusive ads, and log listed properties penthouse advertisements, penthouse ads, and lake online MLS to facilitate your Westlake Ohio ramble.
Find out, contrive, and come across condo rentals Broadway United States, home rentals, and holiday rentals.
|
|
