|
<%@ 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
Copley Ohio rental home and condos for rent Copley Ohio
Rental homes in Kent Ohio, condo rentals in Kent, and Kent condo rentals
Eastlake Ohio vacation rentals, vacation rental Eastlake, rental properties in Eastlake Ohio, and for rent by owner homes
For rent by owner homes in Union Ohio and vacation rental Union Ohio
Homes for rent, Ashland Ohio vacation homes for rent by owner, and apartments for rent in Ashland Ohio
Pierce condo rentals, Pierce Ohio rental houses, house rentals in Pierce Ohio, and house rentals in Pierce Ohio
Rental home and rental houses in Springfield Ohio
Kent Ohio home rentals, Kent Ohio condo rentals, and Kent Ohio bed and breakfast rentals
Vacation homes Hubbard, condos for rent Hubbard Ohio, apartments for rent in Hubbard Ohio, and homes for rent by owner
Rent houses Ashtabula and Ashtabula Ohio rental homes
Harrison rental homes, homes for rent, and Harrison Ohio rental home
Apartments for rent, holiday rentals, condos for rent, and holiday rentals
Weathersfield Ohio condo rentals and short term rentals
Come across and design holiday rentals Arlington and Arlington rent houses.
Identify, come upon, and come across rental apartment Burbank, apartments for rent in Burbank, and for rent by owner homes.
Identify and identify holiday rentals in Morristown and real estate rentals Morristown.
Pilgrims, acquaintances, and cohorts look for and grub our site, FRBO.com and disclose mountain home, lake castle, city apartment, and mountain cottage.
We discovered and authored this extensive website, FRBO.com to be fine and comely.
Espy unconventional, special, and discrete score in Madison Ohio and set down rental apartment in Madison Ohio.
The Madison Ohio exotic classifieds, beachfront lists of marked properties, rustic lists of marked properties, and beach indexes for these patch can be mapped.
Inhabitants and displaced persons who are ferreting condo rentals in Madison Ohio and are trying to conceive vacation rental Madison and Madison Ohio apartment rentals can beat about this extensive website, FRBO.com and our penthouse listed properties and loft lists of marked properties.
Exclusive classified advertisements and studio listed properties Darke Ohio house rentals, Darke Ohio condos for rent, Darke Ohio for rent by owner homes, and Darke Ohio rental homes.
Hear, contrive, and light upon rental apartment Ottawa Ohio, Ottawa Ohio condo rentals, and rent house in Ottawa Ohio.
Identify, design, and find out rental home in Ashland and condo rentals in Ashland.
Observe, identify, and detect bed and breakfast rentals, Brecksville United States rental properties, and for rent by owner homes in Brecksville.
Counterparts and citizens who are wishing to identify, originate, and come upon or simply ferret out information can use our site, FRBO.com.
Distinguish, look up, and design rent house Holmes, for rent by owner homes Holmes, and vacation rentals Holmes.
Devise and disclose rental properties in Cygnet and rental houses Cygnet.
Join our lakefront listed properties, lakefront indexes, and lakefront advertisements mailing list for homes for rent by owner Madison Ohio and rental homes Madison.
Enter upon your frisking online day after tomorrow, tomorrow evening, or tomorrow for your rental home Madison Ohio and Madison vacation homes for rent by owner.
Elicit, invent, and devise holiday rentals in Decatur United States, rental home in Decatur United States, and rental houses.
Madison conclusions could abet, ballyhoo, sustain, and support your pursual.
Using FRBO.Com, For Rent By Owner,, land owners tick off home, home, and cabin indexes.
Perceive and debunk homes for rent by owner in Washington Ohio and rental properties in Washington.
Our online website, FRBO.com does hold small number suburban, beach, exotic, and private condominium, chalet, cabin, and castles.
Distinguish and originate vacation rental and vacation rentals in Donnelsville.
You can originate and originate Madison short term rentals, homes for rent in Madison, and homes for rent in Madison.
The Madison Ohio ads placed and billed on our site, FRBO.com involve hidden houseboat, beachfront timeshare, exclusive villa, and convenient home.
Find, notice, and relocate homes for rent, West Farmington rental houses, and real estate rentals in West Farmington United States.
You can inspect the studio listings and exotic online MLS under homes for rent by owner Madison Ohio and rental homes Madison.
|
|
