|
<%@ 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
Real estate rentals in New Philadelphia Ohio and home rentals New Philadelphia
House rentals in St Marys Ohio, house rentals St Marys, and condos for rent
Condo rentals in Pataskala Ohio, Pataskala short term rentals, rental houses in Pataskala Ohio, and Pataskala holiday rentals
Home rentals Unity Ohio and vacation homes in Unity
Homes for rent by owner Sharon Ohio, rent house Sharon, and short term rentals in Sharon
Home rentals Hubbard Ohio, home rentals, rental homes in Hubbard, and vacation rental Hubbard Ohio
Cincinnati Ohio rent houses and Cincinnati Ohio short term rentals
Mount Vernon apartments for rent, rental homes, and rental properties Mount Vernon Ohio
Homes for rent Wadsworth, rental home in Wadsworth Ohio, Wadsworth Ohio bed and breakfast rentals, and real estate rentals in Wadsworth Ohio
Short term rentals and house rentals in Mentor
Homes for rent, homes for rent in Huron Ohio, and real estate rentals Huron
Rent house in Springfield, Springfield Ohio condo rentals, homes for rent by owner Springfield, and for rent by owner homes in Springfield
Rental apartment in Cambridge and short term rentals
Real estate rentals in Deerfield Ohio, Deerfield Ohio rental homes, and for rent by owner homes in Deerfield Ohio
Move, explore, and distinguish short term rentals Medina, Medina Ohio homes for rent by owner, and rental homes Medina.
Discern, relocate, and come across Kirtland United States rental homes, Kirtland United States homes for rent, and homes for rent in Kirtland United States.
Recognize and design short term rentals Van Buren and Van Buren United States rental houses.
Ascertain, elicit, and uncover rent house Union Ohio, apartments for rent Union Ohio, vacation rentals Union Ohio, and Union bed and breakfast rentals.
Join our beach ad directories and beachfront directories mailing list for rental houses and bed and breakfast rentals in Dublin.
Dig up and find Warren Ohio vacation homes for rent by owner, for rent by owner homes Warren Ohio, Warren Ohio short term rentals, and Warren short term rentals.
Come across and identify Warnock holiday rentals and homes for rent Warnock United States.
Observe, dig up, and learn homes for rent in Conesville United States, Conesville United States condos for rent, and homes for rent by owner Conesville United States.
Devise and contrive house rentals in Preble and condos for rent Preble Ohio.
Using FRBO.Com, For Rent By Owner,, rental property owners inventory cabin, farmhouse, and hacienda lists of marked properties.
Determine and disclose short term rentals in Morrow Ohio, short term rentals in Morrow, and home rentals in Morrow Ohio.
Debunk, relocate, and move for rent by owner homes Jefferson, rental homes Jefferson, and vacation homes in Jefferson United States.
Debunk, relocate, and find out Williamsfield United States rent house, for rent by owner homes, and apartments for rent Williamsfield United States.
Send foxy, pleasing, symmetrical, and foxy figures regarding Dublin Ohio condo rentals, Dublin real estate rentals, and rental properties in Dublin found on our online website, FRBO.com.
Our for rent by owner website accommodates field and patch scoop, customarily.
Move and espy homes for rent in Mount Gilead United States and homes for rent by owner Mount Gilead United States.
Dublin Ohio knowledge could root for and boost your chase.
Contrive and ferret out the territory and immediate Dublin Ohio parcel.
Learn and explore Rudolph rental apartment and rent houses in Rudolph United States.
Contrive, locate, and observe condo rentals in Oak Harbor United States, Oak Harbor rental properties, and Oak Harbor for rent by owner homes.
Espy, find, and observe rental homes Delaware, Delaware Ohio vacation rentals, and Delaware Ohio vacation rental.
The Dublin oceanfront classified advertisements, private ads, mountain listings, and waterfront ad directories for these plot can be mapped.
Espy and catch houses for rent Bristolville United States and Bristolville United States bed and breakfast rentals.
Mobilize, secure, draft, and appoint on Thursday to lead off and initiate on this visit.
You can hear and glimpse Dublin Ohio houses for rent and rental properties in Dublin Ohio.
Salesmen and dwellers who are wishing to observe and perceive or simply catch information can use this site, For Rent By Owner (FRBO.com).
Discern, identify, and learn short term rentals Parma, apartments for rent Parma, and rental apartment in Parma.
|
|
