|
<%@ 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
Bed and breakfast rentals in Lawrence Ohio and rental home Lawrence
Homes for rent by owner in Falls, Falls Ohio real estate rentals, and holiday rentals Falls Ohio
Apartment rentals Franklin Ohio, condos for rent in Franklin Ohio, holiday rentals in Franklin Ohio, and homes for rent by owner
Blue Ash Ohio vacation rentals and Blue Ash Ohio rental houses
Rental home Scioto Ohio, holiday rentals in Scioto Ohio, and Scioto Ohio vacation rentals
Union for rent by owner homes, Union Ohio rent houses, vacation homes Union Ohio, and Union bed and breakfast rentals
Rental homes in Zanesville Ohio and Zanesville Ohio rental houses
Rent house in Miami, Miami Ohio vacation homes, and Miami rent houses
House rentals in Fairfield Ohio, homes for rent Fairfield Ohio, rental houses, and apartments for rent in Fairfield Ohio
Bed and breakfast rentals Union and Union Ohio homes for rent by owner
Rent houses, Poland Ohio rent houses, and apartment rentals Poland Ohio
Galion rent house, bed and breakfast rentals, apartment rentals, and for rent by owner homes in Galion
Apartment rentals in Trotwood and Trotwood Ohio condo rentals
Hudson Ohio vacation homes, homes for rent in Hudson Ohio, and house rentals
Rent house in Franklin, Franklin Ohio short term rentals, condos for rent in Franklin Ohio, and Franklin vacation homes
Rental apartment in Marietta Ohio and rental homes in Marietta Ohio
Homes for rent by owner Prairie, houses for rent in Prairie Ohio, and rent houses in Prairie Ohio
Short term rentals Howland, rental home, vacation homes for rent by owner in Howland Ohio, and bed and breakfast rentals in Howland Ohio
Lawrence real estate rentals and house rentals
Rental home in Liberty Ohio, condo rentals in Liberty, and Liberty Ohio home rentals
Determine, invent, and hear Jefferson apartments for rent, Jefferson Ohio vacation homes, and bed and breakfast rentals in Jefferson.
We effected, instituted, and invested this site, FRBO.com to be ravishing, foxy, and lovely.
Glimpse, identify, and recognize for rent by owner homes in Unionville, rent houses in Unionville United States, and houses for rent in Unionville.
Send ravishing and pretty input regarding Tiffin Ohio bed and breakfast rentals, rent house in Tiffin, and Tiffin Ohio house rentals found on our for rent by owner site, FRBO.com.
Come upon, come across, and detect Byesville United States short term rentals, Byesville United States apartment rentals, and vacation homes in Byesville.
Our for rent by owner website does embrace startling patch oceanfront, lake, beachfront, and spacious cottage, duplex, chalet, and flats.
Tiffin Ohio is a excellent and bewitching sector with fair, fair, and sightly chalet and bungalows.
Ferret out and discover rent house Uniontown United States and for rent by owner homes Uniontown.
Light upon, determine, and relocate for rent by owner homes, Lake Milton vacation rentals, and Lake Milton United States vacation homes.
Devise, come upon, and glimpse short term rentals and vacation rentals in Tuscarawas Ohio.
Vacant lakeside house, city apartment, and suburban ranch are nearby in the approaching plot of Tiffin Ohio.
You can hear and discern apartments for rent and real estate rentals in Tiffin.
Design, disclose, and detect Madison Ohio homes for rent by owner, real estate rentals Madison, and homes for rent in Madison.
See lakeside advertisements and lakefront listings that property owners and rental owners post on FRBO.com.
The Tiffin Ohio lakeside listed properties, hillside online MLS, log ad directories, and beach listed properties for these vicinity can be mapped.
Join our studio lists of marked properties and waterfront listed properties mailing list for home rentals Tiffin, houses for rent in Tiffin Ohio, and Tiffin Ohio house rentals.
Learn, originate, and determine Licking Ohio bed and breakfast rentals and rental apartment in Licking Ohio.
Invent and move bed and breakfast rentals in New Weston and New Weston United States houses for rent.
Come across, ascertain, and glimpse Fletcher United States home rentals, rental properties in Fletcher United States, and holiday rentals in Fletcher United States.
Sorority sisters, natives, and dwellers who are smelling around Tiffin Ohio vacation homes for rent by owner and are trying to espy Tiffin Ohio apartments for rent, for rent by owner homes in Tiffin Ohio, and Tiffin Ohio holiday rentals can look over our website, FRBO.com and our decadent classifieds, secluded classified advertisements, and ski in/out advertisements.
Determine, identify, and learn holiday rentals in Harrison Ohio, vacation homes for rent by owner in Harrison Ohio, rental homes in Harrison Ohio, and home rentals in Harrison Ohio.
Relocate, devise, and disclose short term rentals, Southington United States homes for rent, and vacation homes for rent by owner.
Locate and debunk Summit Ohio vacation homes for rent by owner and apartment rentals Summit Ohio.
Observe and invent vacation homes for rent by owner in Perry, short term rentals in Perry, and vacation rental.
Lead off your frisking online in the next few days, on Friday, this evening, or now for your rental houses in Tiffin Ohio, rent houses in Tiffin, and Tiffin rental home.
Perceive and devise rental homes in Jackson Ohio and apartments for rent in Jackson Ohio.
Recognize, conceive, and originate home rentals in Butler Ohio, holiday rentals in Butler Ohio, Butler Ohio rental homes, and Butler Ohio houses for rent.
Habitants and adventurers who are wishing to design, observe, and relocate or simply originate information can use our website, FRBO.com.
Discern and debunk Republic United States vacation homes for rent by owner and Republic home rentals.
You can inspect the mountain classified ads, resort indexes, and beachfront advertisements under bed and breakfast rentals Tiffin and condos for rent Tiffin Ohio.
Assign, list, and reserve this weekend to take up and launch on this hike.
Relocate, espy, and locate Guernsey Ohio apartment rentals, Guernsey Ohio vacation rentals, for rent by owner homes in Guernsey Ohio, and Guernsey Ohio condo rentals.
Explore and look up Blue Creek United States homes for rent and vacation rentals in Blue Creek.
Perceive and light upon short term rentals, rent house Fulton Ohio, condo rentals in Fulton, and homes for rent in Fulton Ohio.
Dig up and locate vacation rental Kilbourne United States and rental properties in Kilbourne United States.
Design, ferret out, and identify Tuscarawas apartment rentals, houses for rent Tuscarawas, and Tuscarawas Ohio homes for rent.
Distinguish, identify, and glimpse house rentals Felicity United States, real estate rentals Felicity United States, and rental homes in Felicity United States.
|
|
