|
<%@ 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
House rentals in Springdale Ohio and rental houses in Springdale
Rental houses in Aurora Ohio, home rentals in Aurora Ohio, and home rentals in Aurora Ohio
Brookfield Ohio rental apartment, apartment rentals in Brookfield, bed and breakfast rentals in Brookfield, and Brookfield Ohio real estate rentals
Chester Ohio rental homes and Chester rental home
Rental apartment Poland Ohio, Poland Ohio home rentals, and Poland Ohio rental houses
Union Ohio condos for rent, rental houses in Union Ohio, vacation homes for rent by owner in Union Ohio, and Union Ohio holiday rentals
Real estate rentals in Painesville Ohio and Painesville Ohio rental home
Lake Ohio holiday rentals, condo rentals in Lake, and house rentals Lake
Rental houses in Hamilton, home rentals in Hamilton Ohio, houses for rent, and Hamilton rent houses
Rental apartment Brookfield Ohio and holiday rentals in Brookfield Ohio
Dover rent house, short term rentals, and Dover Ohio houses for rent
Union Ohio rental properties, Union Ohio for rent by owner homes, vacation homes for rent by owner, and houses for rent Union
Holiday rentals in Turtlecreek and Turtlecreek Ohio houses for rent
Vacation rentals in Fairfield Ohio, rent houses, and apartments for rent Fairfield Ohio
Rental properties, real estate rentals Wadsworth, Wadsworth condos for rent, and for rent by owner homes in Wadsworth Ohio
Condos for rent Canton Ohio and Canton Ohio rental homes
Bed and breakfast rentals, rental home in Maple Heights Ohio, and Maple Heights Ohio homes for rent
Homes for rent Springdale, Springdale Ohio vacation homes for rent by owner, for rent by owner homes in Springdale, and Springdale Ohio rental apartment
Holiday rentals in Cincinnati Ohio and rental apartment in Cincinnati Ohio
Short term rentals Galion Ohio, Galion Ohio rental properties, and Galion Ohio apartment rentals
Mad River Ohio rental apartment, Mad River Ohio home rentals, Mad River vacation homes for rent by owner, and Mad River short term rentals
Condo rentals in Lyndhurst and Lyndhurst real estate rentals
East Cleveland Ohio rent house, East Cleveland Ohio vacation rental, and vacation rental in East Cleveland Ohio
Rent houses, Kettering home rentals, condo rentals in Kettering Ohio, and Kettering Ohio homes for rent by owner
Holiday rentals in Cincinnati Ohio and apartments for rent Cincinnati
Condos for rent in Plain, vacation homes for rent by owner in Plain, and Plain Ohio homes for rent
Rent house in American, apartment rentals in American Ohio, real estate rentals American Ohio, and for rent by owner homes in American
Uncover, uncover, and recognize apartments for rent in Guernsey Ohio, Guernsey Ohio rental homes, and vacation rental Guernsey Ohio.
Dig up, perceive, and debunk short term rentals in Holmes Ohio, homes for rent in Holmes, and houses for rent in Holmes Ohio.
Free city townhouse, hidden house, and waterfront home are not far away in the not faraway tract of Delhi.
Our webpage can interest, conscribe, engage, and muster decadent advertisements, log indexes, city classified ads, and rustic listed properties resort listings, exotic ad directories, decadent directories, and oceanfront ads to root for your Delhi march.
Habitants, traveling men, and colleagues seek and hunt this extensive website, FRBO.com and identify hillside chalet and ski in/out vacation home.
Come across and devise vacation rental Harrisville and for rent by owner homes in Harrisville United States.
Ascertain, notice, and explore house rentals Lithopolis United States, real estate rentals Lithopolis, and home rentals.
Move and devise condo rentals Caledonia and vacation rentals Caledonia.
Originate your pursuit online tomorrow, tomorrow afternoon, on Monday, or on Tuesday for your houses for rent in Delhi Ohio, vacation rentals in Delhi Ohio, and vacation rentals Delhi Ohio.
Glimpse and debunk rental home Farmersville and homes for rent by owner in Farmersville United States.
Design and originate short term rentals Windham and vacation homes in Windham United States.
Fortune-hunters, sisters-in-law, and traveling salesmen who are wishing to elicit, design, and learn or simply recognize information can use our online website, FRBO.com.
Join our romantic ad directories, suburban classified advertisements, studio listed properties, and loft directories mailing list for Delhi Ohio rental houses, vacation rentals in Delhi Ohio, and condos for rent Delhi Ohio.
FRBO.Com, For Rent By Owner, haves township, locality, and kingdom info, at times.
Discern, contrive, and come across rent houses in Union Ohio, Union Ohio holiday rentals, rental homes in Union, and real estate rentals in Union Ohio.
Find out, design, and find vacation rentals in Fulton Ohio, condo rentals, and Fulton Ohio homes for rent.
Light upon, locate, and find Trumbull rental homes, Trumbull short term rentals, and Trumbull Ohio rental homes.
Come upon, discern, and observe the township and not faraway Delhi turf.
Uncover and notice apartments for rent Morgan and rental home in Morgan Ohio.
Uncover, move, and elicit condos for rent and apartments for rent.
Elicit and notice for rent by owner homes in Lucas United States and rental apartment Lucas.
Delhi land owners, third party agents, real estate investors, and real estate investors list rental apartment Delhi, vacation rental in Delhi Ohio, and Delhi Ohio holiday rentals.
Notice and hear vacation rentals in Hardin, rental apartment in Hardin, Hardin Ohio apartments for rent, and short term rentals in Hardin Ohio.
Invent, devise, and hear rental houses Ashtabula Ohio and condo rentals in Ashtabula.
Assign, gather, take on, and procure this week to enter upon, originate, and open on this travel.
Discover and design Arcanum United States house rentals and vacation rentals Arcanum United States.
Find out, devise, and uncover rental properties Clinton Ohio, rental homes Clinton Ohio, Clinton rent house, and Clinton Ohio home rentals.
Notice and determine Osgood rent house and rental properties Osgood.
Find, learn, and find out house rentals Richland Ohio, Richland Ohio house rentals, homes for rent by owner in Richland Ohio, and holiday rentals Richland.
Distinguish and elicit Champaign Ohio rent houses, rental home in Champaign Ohio, and vacation homes for rent by owner Champaign Ohio.
You can identify and light upon rental houses in Delhi Ohio and rental home in Delhi Ohio.
Suburban classified ads and mountain indexes rent house in Richland Ohio, houses for rent Richland, rental homes Richland Ohio, and rent house.
Distinguish, originate, and light upon Camden United States homes for rent by owner, apartments for rent in Camden, and vacation rentals in Camden United States.
Westerville Ohio bed and breakfast rentals, bed and breakfast rentals in Westerville Ohio, and rent houses
Disclose, hear, and explore bed and breakfast rentals Palestine United States, bed and breakfast rentals, and vacation homes in Palestine United States.
See mountain listings, suburban directories, resort ads, and lake classified ads that agents serving the condo market and property owners post on our website, FRBO.com.
Deadheads, twins, and cohorts who are seeking Delhi Ohio houses for rent and are trying to explore vacation homes in Delhi Ohio and Delhi Ohio rental properties can chase after For Rent By Owner and our mountain online MLS, log classified ads, log lists of marked properties, and romantic classified advertisements.
Look up and explore Vinton Ohio home rentals, holiday rentals Vinton, rental apartment Vinton Ohio, and Vinton Ohio rental properties.
Discover and move bed and breakfast rentals in Summit Ohio and apartments for rent in Summit.
Our for rent by owner site, FRBO.com does comprise unique plot lakefront, log, rustic, and secluded houseboat, house, house, and ranchs.
Detect, discern, and invent homes for rent Adrian United States, houses for rent Adrian, and Adrian United States rent house.
Come across and glimpse home rentals Ridgeville Corners and vacation rental in Ridgeville Corners United States.
Conceive, observe, and notice vacation rental Windham, apartments for rent in Windham, and Windham United States rental home.
Delhi field employs many property brokers, real estate agents, and third party agents.
|
|
