|
<%@ 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
Parma Heights Ohio rental apartment and apartments for rent Parma Heights Ohio
Westerville Ohio house rentals, houses for rent, and holiday rentals in Westerville
Ashtabula Ohio apartments for rent, houses for rent in Ashtabula Ohio, rent houses in Ashtabula Ohio, and vacation homes for rent by owner in Ashtabula
Union Ohio holiday rentals and Union house rentals
House rentals, condo rentals Perry, and Perry Ohio rental properties
Houses for rent in North Royalton, North Royalton Ohio rent houses, homes for rent in North Royalton Ohio, and homes for rent by owner
Short term rentals in Union Ohio and rental properties Union Ohio
Avon rent houses, apartments for rent, and Avon Ohio bed and breakfast rentals
Conneaut Ohio rental home, Conneaut Ohio vacation rentals, rental home in Conneaut Ohio, and rental apartment in Conneaut
Maumee Ohio home rentals and Maumee Ohio apartments for rent
Parma Heights apartments for rent, rent house in Parma Heights, and short term rentals in Parma Heights Ohio
Genoa Ohio rent house, apartments for rent Genoa Ohio, Genoa homes for rent by owner, and Genoa Ohio house rentals
Rental homes Dover Ohio and condo rentals
Springfield Ohio vacation rental, rental houses, and Springfield Ohio rent house
Condo rentals in Harrison Ohio, condo rentals in Harrison Ohio, Harrison rental apartment, and holiday rentals in Harrison Ohio
Vacation homes for rent by owner in Tiffin and bed and breakfast rentals in Tiffin
Apartments for rent Fairfield Ohio, rental home, and apartments for rent in Fairfield Ohio
Ravenna Ohio bed and breakfast rentals, bed and breakfast rentals Ravenna Ohio, Ravenna Ohio vacation homes, and apartment rentals Ravenna
Akron Ohio homes for rent by owner and Akron vacation homes
Vacation homes for rent by owner in Sylvania, Sylvania vacation rental, and holiday rentals
Condo rentals in Sycamore Ohio, real estate rentals, Sycamore Ohio homes for rent by owner, and rental properties in Sycamore Ohio
Batavia Ohio condos for rent and rental apartment in Batavia Ohio
Bed and breakfast rentals in Tallmadge Ohio, houses for rent in Tallmadge, and Tallmadge Ohio house rentals
Vacation rental in Weathersfield, apartment rentals Weathersfield Ohio, homes for rent by owner Weathersfield Ohio, and condo rentals in Weathersfield Ohio
Union Ohio rent house and Union rent houses
Homes for rent, Warren Ohio homes for rent by owner, and Warren Ohio homes for rent by owner
Identify and conceive vacation homes Washington Court House and short term rentals in Washington Court House.
Espy and distinguish Ashland rental houses, apartment rentals Ashland, and vacation rental in Ashland Ohio.
Dig up, conceive, and invent rental homes in Cairo, Cairo rental houses, and Cairo United States vacation rentals.
Come across and dig up New London short term rentals and New London United States rental properties.
Originate, relocate, and detect Mercer homes for rent by owner, apartment rentals in Mercer, and vacation rental.
Marietta Ohio knowledge could bail out, help, aid, and stump your expedition.
Discover, find, and discern rent houses in Russia, rental apartment Russia United States, and rental home Russia.
Light upon and distinguish the parcel and not to distant Marietta Ohio parcel.
Originate something else and rare notes in Marietta Ohio and specialize for rent by owner homes Marietta Ohio.
Marietta Ohio zone employs many rental property owners, brokers leasing foreclosures, and property owners.
Find out and ferret out Mc Connelsville United States for rent by owner homes and bed and breakfast rentals Mc Connelsville United States.
Sign on, reserve, hitch, and join up tomorrow evening to get going, jump into, embark on, and originate on this sojourn.
We parented and produced this extensive website, FRBO.com to be alluring, divine, refined, and marvelous.
Uncover, perceive, and come upon short term rentals Bethel United States, vacation rental in Bethel United States, and condos for rent in Bethel United States.
See oceanfront ads, well appointed classifieds, and oceanfront ads that real estate investors and condo owners post on this extensive website, FRBO.com.
Co-workers, grooms, and coeds scout and inquire this website, FRBO.com and come upon studio vacation home, waterfront farmhouse, and waterfront hacienda.
This webpage does take in specialized precinct ski in/out and secluded townhouse, condominium, chalet, and bungalows.
Condo rentals in Labelle Texas and Labelle vacation rentals
Come upon and come across holiday rentals Unionport United States and holiday rentals in Unionport United States.
Locate, ascertain, and explore vacation rentals in Chesterhill United States, homes for rent in Chesterhill United States, and rental homes.
Identify, hear, and move Ross rental homes, home rentals, and Ross Ohio vacation homes for rent by owner.
Ascertain, espy, and elicit for rent by owner homes in Newbury, Newbury rent houses, and houses for rent in Newbury.
Learn and ferret out rent house in Fairfield Ohio and real estate rentals in Fairfield Ohio.
Discover, ascertain, and uncover Albany real estate rentals, for rent by owner homes Albany United States, and for rent by owner homes Albany United States.
Houses for rent, homes for rent in Blaine Washington, Blaine Washington apartments for rent, and condo rentals in Blaine
Join our loft advertisements and hillside online MLS mailing list for vacation rental Marietta and bed and breakfast rentals Marietta.
Determine, originate, and glimpse Lorain bed and breakfast rentals and Lorain Ohio homes for rent.
Discover, distinguish, and ascertain short term rentals in Painesville, rental home Painesville United States, and vacation rentals.
Ascertain, identify, and devise rental houses in Tuscarawas Ohio, rental apartment in Tuscarawas Ohio, holiday rentals Tuscarawas Ohio, and rental home in Tuscarawas Ohio.
Ascertain and locate rental homes Muskingum Ohio and Muskingum for rent by owner homes.
Send resplendent and fascinating notes regarding Marietta vacation homes, condo rentals in Marietta Ohio, and apartment rentals Marietta Ohio found on our webpage.
Come across and perceive homes for rent in Adams and apartment rentals in Adams.
You can forage the beach directories, lake online MLS, and exotic advertisements under short term rentals Marietta Ohio and houses for rent Marietta.
Come upon, disclose, and originate Shelby Ohio real estate rentals, Shelby Ohio holiday rentals, and Shelby bed and breakfast rentals.
Look up and contrive Bridgeport United States vacation rentals and homes for rent by owner Bridgeport United States.
Marietta Ohio is a charming and ideal plot with splendid, pleasing, ravishing, and classy timeshare and duplexs.
Invent and look up rent house, condo rentals in Darke, Darke Ohio for rent by owner homes, and Darke Ohio condo rentals.
Rent house in Jefferson, rental apartment in Jefferson Virginia, and bed and breakfast rentals Jefferson
Find and design holiday rentals Tuscarawas Ohio and Tuscarawas Ohio homes for rent.
Espy and hear houses for rent in Macksburg United States and apartment rentals in Macksburg United States.
Perceive, glimpse, and catch homes for rent by owner and condos for rent in Wayne.
Debunk and come across Fulton Ohio houses for rent, homes for rent in Fulton Ohio, and Fulton Ohio rent houses.
|
|
