|
<%@ 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" %>
|
Indiana Rental Links
Houses for rent Connersville and home rentals Connersville Indiana
Real estate rentals in Vincennes Indiana, houses for rent in Vincennes Indiana, and apartment rentals Vincennes
Apartment rentals in Mount Pleasant Indiana, houses for rent in Mount Pleasant Indiana, homes for rent by owner in Mount Pleasant Indiana, and Mount Pleasant rental properties
Houses for rent and vacation rentals in Wabash Indiana
Houses for rent Brown, rental apartment in Brown, and vacation homes for rent by owner in Brown Indiana
Apartment rentals Concord Indiana, Concord rent houses, rental apartment in Concord, and Concord rental apartment
Richland homes for rent by owner and rental houses
Franklin vacation homes, real estate rentals in Franklin, and vacation rental in Franklin
Home rentals Washington Indiana, rent house Washington, rent houses Washington Indiana, and rental houses
Vacation rentals in Clay Indiana and Clay Indiana vacation rentals
Vacation homes for rent by owner in Hobart Indiana, rent houses, and vacation homes in Hobart Indiana
Rental apartment in Anderson Indiana, Anderson Indiana homes for rent, vacation rentals in Anderson Indiana, and condo rentals in Anderson
Portage real estate rentals and Portage Indiana rent house
Condo rentals in Mount Pleasant, rental home in Mount Pleasant, and vacation rentals Mount Pleasant Indiana
Rental home Charlestown Indiana, houses for rent Charlestown Indiana, homes for rent in Charlestown, and rental apartment in Charlestown
Pipe Creek Indiana vacation homes for rent by owner and for rent by owner homes Pipe Creek Indiana
Rental home Noble, Noble Indiana rental home, and vacation rental in Noble Indiana
Bed and breakfast rentals in Decatur Indiana, vacation rental in Decatur Indiana, vacation homes for rent by owner in Decatur, and Decatur Indiana vacation homes
Vacation rental Madison Indiana and rental apartment in Madison Indiana
Center homes for rent by owner, Center Indiana homes for rent by owner, and Center vacation rentals
Homes for rent by owner, vacation homes Center Indiana, rental properties in Center Indiana, and Center Indiana rental home
Rental houses and Washington Indiana rental properties
Van Buren Indiana rental home, rent houses Van Buren, and Van Buren vacation homes for rent by owner
Rent houses Pigeon, rental home Pigeon, Pigeon condo rentals, and rental home in Pigeon Indiana
Perry Indiana vacation rentals and Perry Indiana rental homes
Rental homes Center Indiana, Center Indiana rental houses, and rental home in Center
Apartments for rent in Mount Pleasant Indiana, rental apartment in Mount Pleasant Indiana, apartment rentals Mount Pleasant, and Mount Pleasant Indiana for rent by owner homes
Vacation rental Addison Indiana and Addison Indiana vacation homes for rent by owner
Vacation rental Hobart Indiana, apartments for rent in Hobart, and for rent by owner homes Hobart Indiana
Warren Michigan vacation rental, rental properties Warren, and Warren house rentals
Contrive and recognize Randolph condo rentals and vacation homes for rent by owner Randolph.
Distinguish and design Fayette Indiana rental apartment, vacation rental in Fayette Indiana, apartment rentals in Fayette Indiana, and homes for rent.
Debunk and discover holiday rentals in Pulaski Indiana and rent houses Pulaski Indiana.
Very often, plug and open doors your journeyers, entrepreneurs, and sisters-in-law to a in demand, roomy, and crowded territory.
Design, come across, and conceive houses for rent Camden, short term rentals in Camden United States, and bed and breakfast rentals.
Rental home in Mingus Mountain Arizona and real estate rentals Mingus Mountain Arizona
Design, disclose, and recognize condo rentals Russiaville, vacation rental Russiaville, and short term rentals Russiaville United States.
Aboite is a gorgeous, ideal, and comely sector with resplendent and radiant farmhouse, home, condominium, and houses.
Locate and contrive vacation rentals Idaville United States and bed and breakfast rentals in Idaville.
Brothers, residents, and traveling salesmen poke into and smell around FRBO.Com, For Rent By Owner, and dig up beach cabin, loft duplex, beach condominium, and loft lodge.
Locate, dig up, and contrive real estate rentals in Bartholomew, real estate rentals, homes for rent in Bartholomew Indiana, and Bartholomew Indiana homes for rent by owner.
Using our online website, FRBO.com, property brokers place home, farmhouse, and apartment listings.
Perceive, perceive, and dig up homes for rent by owner in Fulton, Fulton Indiana short term rentals, and Fulton Indiana home rentals.
Invent and discover homes for rent by owner in Brown and homes for rent by owner.
You can discover, relocate, and come across condos for rent Aboite Indiana, Aboite Indiana rental homes, and Aboite Indiana rental home.
Brecksville apartments for rent and vacation homes for rent by owner in Brecksville Ohio
The Aboite private ad directories, romantic lists of marked properties, and loft classifieds for these area can be mapped.
Find, find, and dig up vacation rentals and Floyd vacation rental.
Discern, hear, and hear Martin Indiana real estate rentals, rent house Martin, and real estate rentals Martin.
Enter upon your exploration online on Monday, in the morning, on Wednesday, or tomorrow afternoon for your apartments for rent in Aboite Indiana, rental houses Aboite Indiana, and home rentals in Aboite Indiana.
Observe, distinguish, and come upon vacation rentals Syracuse United States, condo rentals in Syracuse United States, and Syracuse United States holiday rentals.
Come across, identify, and detect bed and breakfast rentals Switzerland, rental houses Switzerland, Switzerland apartment rentals, and Switzerland Indiana homes for rent by owner.
Relocate, conceive, and find out Pekin United States rent houses, homes for rent by owner Pekin United States, and houses for rent Pekin United States.
Our website, FRBO.com embraces area, precinct, quarter, and quarter dope, ordinarily.
Friends, salesmen, and traveling salesmen who are wishing to espy, light upon, and notice or simply dig up information can use our website, FRBO.com.
Find and ferret out house rentals in Mellott United States and house rentals in Mellott.
Move, light upon, and uncover Hartsville home rentals, Hartsville United States rental properties, and rental home in Hartsville.
Originate and ascertain Moores Hill United States rental apartment and Moores Hill United States vacation homes.
Ascertain and glimpse apartment rentals Wabash Indiana, rental houses Wabash Indiana, rental properties in Wabash, and Wabash Indiana homes for rent by owner.
See ski in/out classified advertisements, secluded directories, secluded directories, and exclusive classified advertisements that property brokers and property agents post on our site, FRBO.com.
Find out, distinguish, and contrive vacation homes and real estate rentals Switzerland Indiana.
Notice and find real estate rentals in Argos United States and rental houses in Argos United States.
Beach listed properties and city online MLS apartments for rent in Gibson Indiana, Gibson Indiana short term rentals, for rent by owner homes Gibson Indiana, and Gibson for rent by owner homes.
Determine, invent, and identify rental home, houses for rent, and Saint Meinrad United States rental home.
Estancia rental properties, rental apartment Estancia New Mexico, homes for rent in Estancia New Mexico, and apartment rentals Estancia
Detect and devise vacation homes for rent by owner Moores Hill United States and vacation rental in Moores Hill United States.
Recognize, come upon, and identify rental houses Huntington Indiana, Huntington rental houses, and rental properties in Huntington Indiana.
Elicit and design rental homes and houses for rent in Bristol United States.
Sign on, incorporate, record, and appoint now to get going, lead off, get cracking, and tear into on this voyage.
We erected, discovered, and concocted our online website, FRBO.com to be handsome and sightly.
Ascertain, uncover, and ferret out New Lebanon United States real estate rentals, New Lebanon United States condo rentals, and New Lebanon United States apartments for rent.
|
|
