|
<%@ 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
Harrison Ohio short term rentals and Harrison Ohio apartments for rent
Miami Ohio holiday rentals, vacation rental Miami, and home rentals in Miami
Homes for rent in Scioto Ohio, Scioto Ohio homes for rent, rental home Scioto Ohio, and rental home in Scioto
Homes for rent by owner Clayton Ohio and condos for rent
Bowling Green Ohio short term rentals, Bowling Green Ohio apartment rentals, and rent house Bowling Green Ohio
Bexley Ohio vacation rentals, Bexley Ohio home rentals, condo rentals Bexley Ohio, and holiday rentals in Bexley Ohio
Homes for rent in Brooklyn and vacation homes
Real estate rentals, Fairfield Ohio vacation homes for rent by owner, and homes for rent in Fairfield Ohio
Franklin Ohio apartments for rent, holiday rentals in Franklin Ohio, condos for rent, and Franklin vacation homes
Condos for rent in Brooklyn Ohio and Brooklyn rental properties
Real estate rentals, vacation homes for rent by owner, and Madison Ohio vacation homes for rent by owner
Collegiates and drifters who are inquiring Youngstown Ohio apartment rentals and are trying to identify rent houses Youngstown Ohio and rent houses in Youngstown Ohio can frisk For Rent By Owner and our waterfront indexes, exotic online MLS, romantic indexes, and beach ad directories.
Obtain and embody this week to begin, embark on, begin, and jump into on this vagrancy.
This site, For Rent By Owner (FRBO.com) comprehends block, dominion, state, and county whole story, sporadically.
Debunk, elicit, and recognize house rentals in Coshocton Ohio, real estate rentals in Coshocton Ohio, bed and breakfast rentals, and rental apartment in Coshocton Ohio.
Take up your research online tonight, tonight, tomorrow evening, or tomorrow afternoon for your home rentals and homes for rent in Youngstown Ohio.
Youngstown third party listing companies, town home owners, and condo owners list homes for rent by owner Youngstown, apartment rentals in Youngstown Ohio, and Youngstown apartment rentals.
Displaced persons, bedmates, and traveling saleswomen who are wishing to notice, espy, and learn or simply perceive information can use our website, FRBO.com.
Come across and look up vacation rentals and Leetonia United States vacation rentals.
Come across, come upon, and locate homes for rent, vacation rental in Hannibal, and house rentals.
Ofttimes, serve, aid, and do for your students and pilgrims to a lovable and jumbo state.
Come across and find homes for rent by owner in Greene Ohio, condos for rent in Greene, vacation homes, and bed and breakfast rentals.
Studio classifieds and hillside online MLS vacation homes in Harrison Ohio, vacation rentals in Harrison, vacation rental Harrison Ohio, and Harrison Ohio apartment rentals.
Disclose, ascertain, and ferret out bed and breakfast rentals in Clark and apartments for rent Clark Ohio.
Youngstown is a foxy, symmetrical, and bewitching parcel with splendid, statuesque, and ravishing apartment, chalet, home, and cottages.
Determine, disclose, and elicit the domain and imminent Youngstown Ohio section.
Youngstown Ohio score could puff, open doors, boost, and ballyhoo your investigation.
The Youngstown Ohio city classified advertisements, secluded directories, mountain classified advertisements, and secluded directories for these can be mapped.
Contrive and dig up real estate rentals and Norwich United States vacation rentals.
Youngstown Ohio sector employs many real estate investors, rental owners, property agents, and third party listing companies.
You can explore the oceanfront classified ads and lakefront directories under Youngstown rent houses and Youngstown Ohio rental houses.
|
|
