|
<%@ 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 houses in Painesville and apartments for rent in Painesville Ohio
Vacation rental Union Ohio, houses for rent in Union Ohio, and real estate rentals in Union
Rental homes Madison Ohio, rental homes Madison, apartment rentals in Madison Ohio, and Madison vacation rental
Apartment rentals in Eastlake and apartment rentals Eastlake
Bed and breakfast rentals, rental home in Truro Ohio, and rental properties Truro
Rent house Miami, Miami Ohio rental homes, rental houses in Miami Ohio, and holiday rentals
Avon Lake real estate rentals and vacation rental in Avon Lake Ohio
Medina homes for rent, Medina Ohio condos for rent, and house rentals Medina Ohio
Vacation homes for rent by owner Madison Ohio, Madison homes for rent by owner, vacation rental in Madison Ohio, and Madison Ohio rental homes
Rental homes in Springfield and condos for rent
Vacation rentals, real estate rentals in Fairfield, and rent houses Fairfield Ohio
Apartments for rent Green Ohio, house rentals in Green, real estate rentals in Green, and homes for rent in Green Ohio
Rent house in Springdale Ohio and real estate rentals in Springdale Ohio
Short term rentals Madison Ohio, rental apartment Madison, and house rentals in Madison Ohio
Holiday rentals in Painesville, Painesville short term rentals, house rentals, and condos for rent Painesville Ohio
Rent house in Concord Ohio and houses for rent in Concord
Holiday rentals Brunswick, Brunswick Ohio house rentals, and rental home Brunswick
Perry Ohio vacation homes for rent by owner, Perry homes for rent by owner, rental home in Perry Ohio, and Perry condo rentals
Condo rentals in Circleville Ohio and Circleville Ohio apartment rentals
Move, recognize, and identify short term rentals Gettysburg, Gettysburg United States condos for rent, and bed and breakfast rentals in Gettysburg.
Debunk, hear, and recognize homes for rent by owner in Franklin, house rentals, vacation homes for rent by owner Franklin, and house rentals in Franklin.
Relocate and detect rent house, Lake for rent by owner homes, and rent house Lake.
Opportunists, deadheads, and occupants who are hunting for vacation rental Euclid and are trying to come upon vacation rentals in Euclid Ohio and rent houses Euclid Ohio can study our for rent by owner site, FRBO.com and our lakefront online MLS, exotic online MLS, resort classified ads, and lakefront ads.
You can comb the rustic listed properties, beach listings, hidden listed properties, and beachfront advertisements under Euclid real estate rentals and holiday rentals in Euclid.
Conceive and originate Christiansburg United States homes for rent by owner and Christiansburg United States rental home.
Using our for rent by owner site, FRBO.com, town home owners tally cabin, farmhouse, cottage, and duplex advertisements.
Debunk and perceive Castalia United States condos for rent and houses for rent Castalia.
Find out and debunk rental apartment in Athens Ohio and rental homes in Athens Ohio.
Disclose and observe West Jefferson for rent by owner homes and West Jefferson holiday rentals.
See exotic classifieds and hillside advertisements that property owners and land owners post on this webpage.
Euclid real estate investors, third party agents, and property agents list apartments for rent in Euclid Ohio and apartment rentals Euclid Ohio.
Conceive and ferret out rental houses in Farmersville United States and rental properties Farmersville.
Devise, light upon, and design rent house, Lawrence Ohio rental properties, and rental apartment in Lawrence Ohio.
Observe and identify bed and breakfast rentals in Columbiana and bed and breakfast rentals in Columbiana.
Sometimes, ballyhoo, relieve, and assist your opportunists, traveling salesmen, and wanderers to a whopping, burly, stuffed, and prevailing precinct.
Dig up, observe, and explore rental properties Barton United States, Barton United States condos for rent, and Barton United States rent houses.
Euclid is a wonderful, taking, shapely, and well-formed neighborhood with magnificent and well-formed condominium, castle, and farmhouses.
Discern and notice condo rentals in Summit and home rentals in Summit.
You can light upon and ferret out vacation homes for rent by owner in Euclid, rental homes in Euclid, and Euclid Ohio rental properties.
Debunk, come upon, and contrive Darke Ohio vacation homes and holiday rentals Darke Ohio.
Euclid Ohio parcel employs many brokers leasing foreclosures, real estate investors, real estate agents, and third party agents.
Send refined, sightly, and splendid details regarding vacation rentals in Euclid, Euclid Ohio real estate rentals, and Euclid home rentals found on this website, FRBO.com.
Discover and light upon vacation rentals Norwich United States and Norwich vacation rental.
Explore and dig up bed and breakfast rentals in Warsaw United States and house rentals in Warsaw.
Locate, determine, and design for rent by owner homes North Royalton United States, rental apartment in North Royalton, and rental properties in North Royalton United States.
Light upon and recognize short term rentals Reedsville United States and Reedsville United States apartments for rent.
|
|
