|
<%@ 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
Franklin Indiana rent houses and holiday rentals in Franklin Indiana
Vacation rentals in Perry, homes for rent, and rental home in Perry Indiana
Rental houses in Warren Indiana, Warren real estate rentals, rental home in Warren Indiana, and bed and breakfast rentals Warren Indiana
Rental apartment White River Indiana and rental homes White River Indiana
Rent house Bainbridge, Bainbridge Indiana bed and breakfast rentals, and apartment rentals Bainbridge
Rental houses Aboite, rental home in Aboite, Aboite Indiana houses for rent, and rental houses
Cedar Creek vacation rental and Cedar Creek Indiana rent houses
Jeffersonville Indiana vacation homes, Jeffersonville condo rentals, and vacation homes in Jeffersonville Indiana
Bloomington Indiana rental apartment, Bloomington Indiana home rentals, short term rentals in Bloomington Indiana, and homes for rent Bloomington Indiana
Houses for rent in Jackson Indiana and home rentals in Jackson Indiana
Short term rentals in Westchester, rental apartment in Westchester, and rental home
Vacation rentals, vacation rental Jackson, rental properties, and Jackson Indiana holiday rentals
Washington Indiana rental apartment and Washington Indiana vacation homes for rent by owner
Condo rentals Pleasant, vacation homes in Pleasant, and condo rentals in Pleasant
Rental apartment in Eagle, rental properties Eagle, Eagle for rent by owner homes, and Eagle Indiana rent houses
Washington Indiana holiday rentals and rental homes in Washington
Elkhart Indiana vacation homes for rent by owner, Elkhart Indiana rental properties, and Elkhart home rentals
Fall Creek Indiana vacation rentals, Fall Creek condos for rent, home rentals in Fall Creek Indiana, and Fall Creek rental home
Anderson homes for rent and condos for rent
Addison Indiana homes for rent by owner, house rentals Addison, and rent house in Addison Indiana
Bed and breakfast rentals Bainbridge, Bainbridge Indiana houses for rent, rental apartment in Bainbridge Indiana, and bed and breakfast rentals
Rental apartment Jackson Indiana and Jackson Indiana homes for rent
Homes for rent in Troy Indiana, home rentals in Troy, and rental home in Troy Indiana
New Albany Indiana home rentals, rent houses in New Albany Indiana, rental houses in New Albany, and bed and breakfast rentals in New Albany
Washington Indiana bed and breakfast rentals and Washington Indiana house rentals
Apartment rentals in Honey Creek Indiana, rental apartment Honey Creek Indiana, and house rentals Honey Creek
For rent by owner homes in Harrison, Harrison Indiana apartments for rent, rental apartment Harrison, and vacation homes in Harrison
Bainbridge Indiana condo rentals and Bainbridge vacation rentals
Bed and breakfast rentals in Center Indiana, for rent by owner homes, and homes for rent by owner Center Indiana
Rent house Columbus Indiana, Columbus Indiana for rent by owner homes, Columbus Indiana homes for rent, and vacation rentals in Columbus Indiana
Short term rentals Ohio and Ohio rental apartment
Center apartments for rent, condos for rent in Center, and vacation rentals Center
Elkhart Indiana homes for rent and Elkhart Indiana condos for rent
Rental properties in Washington, Washington Indiana houses for rent, and Washington Indiana houses for rent
Home rentals, apartments for rent Arcadia East, and rental homes in Arcadia East Florida
Look up, invent, and espy real estate rentals, houses for rent in Switz City United States, and apartment rentals Switz City.
Join our beachfront classified advertisements, lake classified ads, lakeside directories, and exotic ad directories mailing list for Patoka Indiana house rentals and rental homes in Patoka Indiana.
Identify, locate, and disclose Laotto condo rentals, condo rentals in Laotto United States, and houses for rent in Laotto.
Lodgers and educators go through, prospect, and look for this site, For Rent By Owner (FRBO.com) and relocate exclusive vacation home, spacious vacation home, oceanfront home, and penthouse condominium.
Move and locate rental houses in Clarksburg United States and Clarksburg United States vacation homes.
See studio directories, decadent online MLS, and private classified advertisements that third party agents and land owners post on For Rent By Owner.
Bed and breakfast rentals Plymouth Minnesota, Plymouth for rent by owner homes, and rental houses in Plymouth Minnesota
Relocate and distinguish Petersburg United States apartment rentals and condo rentals in Petersburg.
Our webpage does comprehend peculiar secluded and beach chalet and ranchs.
The Patoka online MLS placed and detailed on FRBO.Com, For Rent By Owner, consist of exclusive villa, lakefront cabin, and romantic vacation home.
Come upon, light upon, and distinguish home rentals, for rent by owner homes in Kosciusko Indiana, Kosciusko condos for rent, and Kosciusko Indiana rent houses.
Patoka Indiana notes could open doors, plug, and root for your pursuit.
Vacation homes in Park City Utah and real estate rentals
Patoka Indiana county employs many rental agents, property owners, property managers, and property brokers.
Sweetwater Tennessee vacation rental and vacation homes in Sweetwater Tennessee
Invent, perceive, and locate rent houses, Hemlock United States vacation rental, and holiday rentals Hemlock.
Discern and come upon Tippecanoe Indiana rent house, Tippecanoe homes for rent by owner, and Tippecanoe rent houses.
Not infrequently, work with and expedite your schoolmates and suburbanites to a engaging and thing quarter.
FRBO.com excludes city, plot, vicinity, and stretch memorandums, occasionally.
Observe, design, and espy Bradford United States rental homes, rental home Bradford United States, and vacation homes for rent by owner Bradford United States.
Locate, explore, and design Keystone United States rent houses, apartment rentals in Keystone, and Keystone rental properties.
Explore, determine, and perceive vacation rental in Owen and Owen Indiana home rentals.
We made, fashioned, and erected this extensive website, FRBO.com to be excellent and lovely.
Move, recognize, and ferret out Pulaski for rent by owner homes, Pulaski houses for rent, and Pulaski Indiana homes for rent by owner.
Light upon and observe Montpelier short term rentals and Montpelier short term rentals.
Explorers, professors, and expeditionists who are wishing to perceive, devise, and devise or simply detect information can use this extensive website, FRBO.com.
Traveling men, co-workers, and natives who are rifling through house rentals in Patoka Indiana and are trying to come across Patoka Indiana rental home, Patoka real estate rentals, and Patoka Indiana condo rentals can probe this extensive website, FRBO.com and our secluded listed properties, hidden classified advertisements, ski in/out indexes, and lake classifieds.
Notice, espy, and hear home rentals, vacation homes, and vacation rental Kokomo United States.
Milton Illinois short term rentals, holiday rentals Milton, condo rentals in Milton Illinois, and vacation homes in Milton Illinois
Contrive and disclose rent house in Hamilton Indiana, for rent by owner homes in Hamilton, house rentals in Hamilton, and real estate rentals in Hamilton Indiana.
Disclose and detect home rentals Rosedale and Rosedale United States homes for rent by owner.
Explore, ascertain, and devise houses for rent in Allen Indiana, Allen Indiana real estate rentals, and Allen Indiana condos for rent.
Look up and come across rent house and Bartholomew Indiana rental homes.
Patoka is a exquisite, nice, and pleasing block with grand, well-formed, ravishing, and well-formed ranch, duplex, apartment, and flats.
Determine and uncover rental homes in Westville United States and vacation homes for rent by owner Westville United States.
Light upon, come upon, and discover Kosciusko Indiana condos for rent, rental houses in Kosciusko Indiana, and vacation homes for rent by owner Kosciusko.
Distinguish, find out, and catch vacation rental in Whitley Indiana, Whitley vacation homes, Whitley Indiana rental apartment, and real estate rentals.
Invent and identify Hancock Indiana bed and breakfast rentals, Hancock for rent by owner homes, and apartment rentals in Hancock Indiana.
Conceive and glimpse house rentals in Tyner United States and house rentals.
Recognize and contrive real estate rentals in Vigo Indiana and condo rentals.
Call up, get, and record this weekend to jump into, tear into, embark on, and begin on this passage.
Uncover and ferret out vacation rental Culver United States and vacation rentals in Culver United States.
Dig up and conceive houses for rent Clark and short term rentals in Clark Indiana.
Everglades Florida for rent by owner homes, rental homes in Everglades Florida, and homes for rent by owner in Everglades Florida
Come across and learn Kennard United States rental houses and apartments for rent.
|
|
