|
<%@ 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
Euclid vacation homes for rent by owner and Euclid Ohio bed and breakfast rentals
Cincinnati Ohio rent house, Cincinnati Ohio rental apartment, and vacation rental in Cincinnati Ohio
Rental properties in Avon, Avon Ohio rent house, Avon bed and breakfast rentals, and vacation rental in Avon Ohio
Rental properties and Hudson rent house
Rental properties Garfield Heights, vacation homes Garfield Heights Ohio, and for rent by owner homes in Garfield Heights
American for rent by owner homes, American Ohio bed and breakfast rentals, holiday rentals American Ohio, and rental homes in American Ohio
Houses for rent Athens and Athens Ohio rent houses
Steubenville house rentals, house rentals Steubenville, and holiday rentals in Steubenville Ohio
Geneva Ohio apartments for rent, for rent by owner homes in Geneva Ohio, vacation rental Geneva, and real estate rentals in Geneva Ohio
Harrison Ohio vacation homes for rent by owner and Harrison Ohio rental apartment
Home rentals Batavia Ohio, Batavia Ohio vacation homes, and bed and breakfast rentals in Batavia
Bed and breakfast rentals, rental home in Duchouquet, Duchouquet Ohio vacation rentals, and Duchouquet rental home
Lake Ohio rental apartment and houses for rent in Lake
Lake Ohio houses for rent, rental properties Lake Ohio, and rent houses Lake
Rental apartment Marion, condo rentals, bed and breakfast rentals Marion Ohio, and rental properties in Marion Ohio
Perry Ohio vacation rentals and house rentals in Perry
Lorain Ohio rent house, Lorain Ohio rent houses, and holiday rentals Lorain
Hubbard Ohio rent house, rental properties Hubbard, Hubbard Ohio rent house, and rental apartment in Hubbard
Warrensville Heights Ohio holiday rentals and vacation rental Warrensville Heights Ohio
Rental home in Boardman Ohio, Boardman Ohio vacation homes, and condo rentals in Boardman Ohio
Fremont Ohio houses for rent, Fremont Ohio holiday rentals, Fremont Ohio rental houses, and Fremont house rentals
Norton Ohio holiday rentals and homes for rent in Norton Ohio
For rent by owner homes, Sharon Ohio for rent by owner homes, and short term rentals in Sharon
Findlay house rentals, bed and breakfast rentals, Findlay Ohio rent house, and Findlay Ohio homes for rent by owner
Homes for rent by owner in Dover and Dover Ohio vacation rental
House rentals in Brecksville, rental apartment in Brecksville Ohio, and apartments for rent in Brecksville Ohio
Union Ohio rent house, rental houses in Union Ohio, homes for rent in Union Ohio, and Union Ohio apartments for rent
Austintown rent house and vacation homes for rent by owner
Detect, ascertain, and espy Highland rental apartment, Highland Ohio rental homes, real estate rentals in Highland Ohio, and for rent by owner homes in Highland Ohio.
Debunk and locate vacation homes for rent by owner Ashtabula Ohio, Ashtabula Ohio house rentals, and homes for rent in Ashtabula Ohio.
Learn, contrive, and identify Avon house rentals, vacation homes for rent by owner in Avon United States, and Avon United States vacation rentals.
Assign and enter day after tomorrow to initiate, originate, originate, and get going on this voyage.
Moraine Illinois rental apartment and rental home Moraine Illinois
Locate, find out, and espy rental homes in Carroll Ohio, Carroll Ohio rental home, and Carroll Ohio holiday rentals.
Explorers and pioneers who are wishing to explore, ferret out, and conceive or simply observe information can use our for rent by owner website.
Mason Ohio is a sightly and charming domain with dazzling, sublime, and ravishing flat, hacienda, and vacation homes.
Mason knowledge could reinforce, hype, collaborate, and push your rummage.
Move, discern, and originate vacation homes, vacation homes for rent by owner in Fayette Ohio, Fayette bed and breakfast rentals, and vacation rentals Fayette Ohio.
This website, FRBO.com does omit sundry quarter romantic, decadent, ski in/out, and secluded cottage, ranch, and houseboats.
Light upon and distinguish rental apartment in Ashland and apartments for rent.
Discover, glimpse, and look up Conesville United States holiday rentals, Conesville United States vacation rental, and home rentals Conesville United States.
Locate and come upon short term rentals in Auglaize Ohio, real estate rentals in Auglaize Ohio, and vacation homes for rent by owner.
Glimpse and come across vacation rental Loudonville and rent house in Loudonville United States.
Jacksonville Texas homes for rent, apartment rentals, Jacksonville Texas rent house, and vacation rentals in Jacksonville Texas
Relocate original, sparse, startling, and uncommon evidence in Mason Ohio and enumerate bed and breakfast rentals in Mason Ohio.
Identify and relocate real estate rentals in Logan Ohio, Logan Ohio rental home, rental homes, and rental properties in Logan Ohio.
Notice and discern Knox Ohio house rentals, house rentals in Knox Ohio, and vacation rental in Knox Ohio.
The Mason Ohio log ad directories, lake online MLS, and log lists of marked properties for these can be mapped.
Determine, glimpse, and distinguish Mechanicsburg vacation rentals, Mechanicsburg United States rental home, and vacation rentals Mechanicsburg.
Notice, ascertain, and devise Harrisburg United States homes for rent by owner, bed and breakfast rentals Harrisburg United States, and apartment rentals Harrisburg.
Distinguish and disclose Warren condos for rent and rent house Warren Ohio.
Find out, disclose, and come across Scioto apartments for rent, Scioto Ohio vacation homes, and Scioto Ohio rental apartment.
Light upon and notice Ney United States home rentals and rental properties in Ney.
The Mason classified ads enumerated and inscribed on our for rent by owner site, FRBO.com incorporate lakefront home and secluded vacation home.
Using our for rent by owner site, FRBO.com, property agents chronicle villa, lodge, ranch, and townhouse online MLS.
Find and uncover vacation rentals Wadsworth and rental homes in Wadsworth.
You can run down the exotic listed properties and well appointed ad directories under rental houses Mason and real estate rentals in Mason Ohio.
Contrive, glimpse, and move vacation rental in Rickenbacker AFB, for rent by owner homes, and Rickenbacker AFB United States for rent by owner homes.
Lawrence Kansas vacation homes, Lawrence Kansas vacation rental, home rentals in Lawrence, and vacation rentals
Catch and hear condo rentals in Bethel United States and Bethel United States homes for rent.
|
|
