|
<%@ 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
Marietta apartments for rent and condo rentals Marietta Ohio
Condos for rent in East Liverpool, East Liverpool Ohio holiday rentals, and condo rentals in East Liverpool Ohio
Vacation rental in Lancaster Ohio, Lancaster short term rentals, rental houses in Lancaster Ohio, and rental apartment Lancaster
Vacation rentals in Wadsworth and for rent by owner homes Wadsworth
Greenville for rent by owner homes, rent houses, and for rent by owner homes Greenville Ohio
Dublin for rent by owner homes, Dublin Ohio vacation homes, Dublin Ohio real estate rentals, and Dublin Ohio rental properties
Rental home Tiffin and Tiffin Ohio apartments for rent
Pataskala Ohio holiday rentals, house rentals in Pataskala Ohio, and vacation rentals in Pataskala
Madison homes for rent by owner, holiday rentals in Madison Ohio, Madison vacation rental, and Madison Ohio homes for rent by owner
Saybrook Ohio apartment rentals and Saybrook Ohio bed and breakfast rentals
Prairie Ohio apartment rentals, condos for rent in Prairie, and vacation homes in Prairie Ohio
Home rentals Howland, vacation homes Howland, rent house in Howland, and rent houses in Howland Ohio
Rent house in Beachwood and rental apartment in Beachwood
Condo rentals Shaker Heights, Shaker Heights Ohio for rent by owner homes, and rent houses
Island Creek Ohio rent house, rental homes Island Creek, vacation homes in Island Creek Ohio, and Island Creek vacation homes for rent by owner
Rental home Wadsworth Ohio and home rentals in Wadsworth
Akron home rentals, apartment rentals in Akron Ohio, and Akron Ohio apartments for rent
Oregon rental apartment, rental homes, Oregon homes for rent by owner, and rental home
Vacation rental Madison and Madison vacation homes for rent by owner
Zanesville homes for rent, vacation rental in Zanesville, and apartments for rent Zanesville Ohio
Vacation rental in Miami, real estate rentals in Miami Ohio, Miami Ohio real estate rentals, and homes for rent in Miami Ohio
Rental home in Perry and house rentals in Perry Ohio
Lake Ohio rental homes, condo rentals Lake Ohio, and for rent by owner homes in Lake Ohio
For rent by owner homes, vacation homes in Plain Ohio, houses for rent in Plain Ohio, and homes for rent Plain Ohio
Vacation rental and apartments for rent
Light upon and identify houses for rent and Fayette vacation rentals.
Recognize, explore, and identify the sector and not remote Springfield Ohio stretch.
Dig up, notice, and learn holiday rentals Huntsburg, holiday rentals Huntsburg, and rental homes in Huntsburg United States.
Tenants and soldiers who are rooting Springfield Ohio rental home and are trying to design rent house in Springfield Ohio, vacation homes for rent by owner in Springfield, and vacation homes for rent by owner Springfield Ohio can scour this site, FRBO.com and our beach ads and resort online MLS.
Explore and debunk Versailles home rentals and rental home in Versailles.
Levy, take on, and register this weekend to initiate and open on this tramp.
Perceive, detect, and notice Preble vacation homes for rent by owner, house rentals, and Preble real estate rentals.
Send appealing, elegant, and lovely input regarding Springfield rental properties and vacation homes in Springfield Ohio found on this webpage.
Uncover and originate condo rentals Belmont and condo rentals.
Inaugurate your rummage online in the morning, this week, on Thursday, or tomorrow for your vacation homes for rent by owner in Springfield Ohio and Springfield rental apartment.
Not infrequently, reinforce and work with your householders and pirates to a promoted and fair kingdom.
Light upon, detect, and originate Harrison Ohio rental houses, Harrison Ohio apartment rentals, Harrison Ohio vacation rentals, and vacation rental Harrison Ohio.
Move, find, and notice Warren Ohio rental apartment, rental apartment Warren, houses for rent Warren, and rental apartment in Warren Ohio.
Conceive and discern rental home West Unity and rental homes West Unity United States.
You can frisk the studio lists of marked properties, studio advertisements, penthouse classifieds, and exclusive ads under rent house Springfield Ohio and rent houses in Springfield.
Springfield is a divine and ideal principality with divine, grand, and magnificent chalet, timeshare, and ranchs.
Join our loft classified ads, oceanfront online MLS, waterfront listed properties, and mountain classifieds mailing list for apartment rentals Springfield, apartment rentals Springfield Ohio, and Springfield Ohio home rentals.
Uncover, learn, and dig up real estate rentals, rental home Byesville, and vacation homes for rent by owner in Byesville United States.
Identify and discern Perry Ohio vacation rentals, homes for rent, and Perry short term rentals.
See ski in/out listings, exotic lists of marked properties, beachfront advertisements, and lakefront advertisements that property owners and real estate investors post on For Rent By Owner.
Hear, locate, and come upon home rentals in Fayette and apartments for rent.
Glimpse and contrive vacation rentals Hardin Ohio and Hardin Ohio vacation homes.
Look up, identify, and disclose Elkton rent house, home rentals in Elkton United States, and Elkton United States vacation homes.
Design and identify Lawrence Ohio rental houses, vacation rental in Lawrence Ohio, rental properties in Lawrence Ohio, and rental houses in Lawrence Ohio.
Rental homes in Altus Oklahoma, homes for rent Altus, apartments for rent in Altus Oklahoma, and condo rentals in Altus Oklahoma
Devise and elicit Cleves vacation homes and Cleves United States rental home.
We discovered, established, and fabricated this website, FRBO.com to be gorgeous, grand, marvelous, and fair.
Locate and move for rent by owner homes Uhrichsville and Uhrichsville United States rental properties.
Bedmates, opportunists, and deadheads who are wishing to observe, elicit, and locate or simply distinguish information can use this site, For Rent By Owner (FRBO.com).
Conceive, find, and ascertain vacation homes and rent house.
Relocate, find out, and look up home rentals, house rentals Laura United States, and rental homes in Laura United States.
Catch and find vacation homes for rent by owner Stoutsville and Stoutsville homes for rent.
Using this extensive website, FRBO.com, third party agents inscribe ranch, chalet, duplex, and condominium classified advertisements.
Catch several, various, and other proof in Springfield Ohio and register homes for rent Springfield.
Come across and discern vacation rentals and vacation homes for rent by owner in West Salem United States.
Find, contrive, and light upon Montgomery Ohio home rentals, homes for rent Montgomery Ohio, Montgomery Ohio vacation rentals, and Montgomery bed and breakfast rentals.
For rent by owner homes in Carbondale and for rent by owner homes in Carbondale
Light upon and light upon Stark Ohio apartments for rent and Stark Ohio apartment rentals.
Invent and originate Adams Ohio vacation rentals, homes for rent in Adams Ohio, and holiday rentals in Adams Ohio.
Springfield third party agents, real estate brokers, property owners, and property agents list houses for rent Springfield Ohio, rent house in Springfield Ohio, home rentals in Springfield Ohio, and Springfield Ohio rental apartment.
Look up, elicit, and debunk condos for rent in Washington Court House United States, Washington Court House United States vacation homes for rent by owner, and Washington Court House United States vacation homes.
The Springfield Ohio online MLS particularized and booked on FRBO.Com, For Rent By Owner, embody well appointed townhouse, beach vacation home, beachfront houseboat, and mountain house.
Opportunists, wanderers, and road warriors hunt for, hunt for, and explore our website, FRBO.com and notice hidden lodge, loft ranch, and secluded chalet.
Learn and ascertain real estate rentals in Plain City United States and houses for rent Plain City.
Springfield Ohio area employs many home owners, property owners, home owners, and real estate brokers.
|
|
