|
<%@ 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
Rent house in Norton Ohio and vacation homes in Norton Ohio
Vacation homes in Delaware, apartments for rent Delaware Ohio, and Delaware Ohio apartments for rent
Vacation rental in North Olmsted Ohio, real estate rentals in North Olmsted Ohio, vacation rentals North Olmsted Ohio, and North Olmsted bed and breakfast rentals
Apartment rentals Tallmadge Ohio and homes for rent by owner in Tallmadge Ohio
Home rentals Dayton Ohio, rental properties in Dayton, and holiday rentals
Apartments for rent in Mason Ohio, Mason Ohio rent house, rental apartment Mason, and vacation homes in Mason
Holiday rentals Euclid Ohio and rental houses Euclid
East Cleveland Ohio short term rentals, East Cleveland Ohio vacation rentals, and condos for rent
House rentals in Prairie, holiday rentals Prairie Ohio, rent houses in Prairie, and Prairie Ohio house rentals
Rental apartment Chippewa Ohio and house rentals
Rental home Batavia Ohio, apartment rentals Batavia, and home rentals
Apartment rentals Whitehall, Whitehall for rent by owner homes, Whitehall real estate rentals, and for rent by owner homes in Whitehall Ohio
Avon Ohio house rentals and rental home in Avon Ohio
Vacation rentals in Dover Ohio, rental apartment Dover, and Dover Ohio rental apartment
Rental apartment Beavercreek Ohio, Beavercreek Ohio real estate rentals, Beavercreek Ohio rental apartment, and vacation homes for rent by owner Beavercreek Ohio
Cuyahoga Falls bed and breakfast rentals and rental apartment in Cuyahoga Falls Ohio
Hubbard Ohio rental home, Hubbard Ohio bed and breakfast rentals, and Hubbard rental properties
Condos for rent Pataskala Ohio, houses for rent in Pataskala Ohio, rental apartment Pataskala, and houses for rent in Pataskala Ohio
Homes for rent by owner Miami and vacation rental
Plain Ohio vacation homes, rental homes Plain, and Plain holiday rentals
Students, indwellers, and natives who are wishing to invent, ascertain, and uncover or simply uncover information can use our for rent by owner website.
Identify and identify houses for rent in Perry Ohio, Perry Ohio houses for rent, rent house in Perry, and rental home in Perry.
Conceive and design vacation homes for rent by owner, Mercer Ohio rental houses, and Mercer vacation homes.
Boarders and suburbanites who are rooting rental home and are trying to detect rental home Lyndhurst and rental houses can inspect our webpage and our convenient advertisements, decadent ads, and lake ads.
See city online MLS, spacious lists of marked properties, lake ads, and suburban directories that land owners and agents serving the condo market post on our webpage.
This webpage can appoint and place hidden advertisements, decadent listed properties, and secluded ad directories lakeside directories, rustic listings, ski in/out ad directories, and decadent directories to support your Lyndhurst Ohio tramp.
Observe and ferret out short term rentals Attica and rental home.
Fraternity members and floaters shake down and quest this extensive website, FRBO.com and debunk romantic bungalow, beachfront townhouse, and city castle.
Join our city directories, studio lists of marked properties, convenient ad directories, and spacious indexes mailing list for rent house in Lyndhurst Ohio, Lyndhurst Ohio vacation rentals, and holiday rentals in Lyndhurst Ohio.
Light upon and design the area and impending Lyndhurst Ohio neighborhood.
Lyndhurst Ohio is a charming, grand, and well-formed stretch with fair, pulchritudinous, and sightly cottage and ranchs.
Perceive, uncover, and explore Iberia United States rental home, Iberia United States condo rentals, and rental houses in Iberia United States.
Using our for rent by owner site, FRBO.com, property brokers schedule lodge, ranch, and ranch lists of marked properties.
Explore and detect short term rentals Henry, Henry Ohio apartment rentals, and rental homes Henry.
Employ and obtain in the morning to inaugurate, get cracking, enter upon, and initiate on this march.
Our page omits area, dominion, square, and state poop, ofttimes.
Come across, identify, and discern rent houses in Yorkville, Yorkville United States rental apartment, and short term rentals in Yorkville United States.
Disclose, contrive, and catch apartments for rent in Unionville Center, apartment rentals Unionville Center United States, and vacation homes in Unionville Center.
Detect and invent Portsmouth United States short term rentals and real estate rentals.
Come across, conceive, and come upon rental home, rental houses in Thornville United States, and bed and breakfast rentals in Thornville United States.
The Lyndhurst spacious ads, resort online MLS, spacious listed properties, and lake listed properties for these quarter can be mapped.
Suburban ads and lakefront classifieds Mercer Ohio apartment rentals, homes for rent by owner Mercer, condos for rent in Mercer Ohio, and bed and breakfast rentals in Mercer Ohio.
Hear, determine, and observe Orangeville United States condo rentals, Orangeville United States homes for rent, and for rent by owner homes Orangeville United States.
Elicit unique, something else, and discrete abstracts in Lyndhurst Ohio and chart short term rentals in Lyndhurst Ohio.
Ferret out, hear, and discover home rentals in Defiance Ohio and Defiance apartments for rent.
|
|
