|
<%@ 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
Rental houses and rental homes in Patoka Indiana
Vacation rental, Henry for rent by owner homes, and Henry Indiana vacation homes
Rental home Peru Indiana, Peru Indiana rent houses, vacation homes in Peru Indiana, and Peru Indiana homes for rent
Pipe Creek Indiana apartments for rent and rent house in Pipe Creek Indiana
Pigeon for rent by owner homes, houses for rent, and homes for rent by owner Pigeon Indiana
Apartments for rent in Black Indiana, short term rentals Black Indiana, holiday rentals in Black, and rental houses in Black Indiana
House rentals Guilford and Guilford Indiana vacation rental
Jeffersonville bed and breakfast rentals, houses for rent in Jeffersonville, and vacation homes for rent by owner
House rentals Franklin Indiana, homes for rent Franklin, homes for rent by owner in Franklin Indiana, and condos for rent
House rentals in Wayne and homes for rent Wayne
Homes for rent Center Indiana, apartments for rent Center Indiana, and vacation homes
Rental properties in Center Indiana, Center Indiana real estate rentals, Center for rent by owner homes, and Center rent house
Perry Indiana rental home and vacation rentals Perry Indiana
Washington Indiana condos for rent, rental properties in Washington, and vacation rental in Washington Indiana
Van Buren Indiana for rent by owner homes, Van Buren Indiana house rentals, bed and breakfast rentals in Van Buren Indiana, and Van Buren rental homes
Vacation rental in Boon Indiana and rental properties in Boon Indiana
Rental properties in Wayne, bed and breakfast rentals in Wayne Indiana, and Wayne Indiana vacation homes
Holiday rentals Franklin, Franklin Indiana rent houses, holiday rentals in Franklin, and Franklin apartment rentals
Guilford rent houses and holiday rentals in Guilford Indiana
White River Indiana for rent by owner homes, White River house rentals, and homes for rent by owner in White River Indiana
Patoka Indiana homes for rent, Patoka homes for rent by owner, Patoka real estate rentals, and rental houses in Patoka Indiana
For rent by owner homes Peru and Peru rental properties
Center Indiana rental apartment, Center rental homes, and rental home in Center Indiana
St John Indiana house rentals, short term rentals, St John Indiana vacation rentals, and vacation homes for rent by owner in St John Indiana
Condo rentals and house rentals in Center Indiana
Rental houses in Harrison Indiana, Harrison Indiana real estate rentals, and vacation homes in Harrison
Washington Indiana apartment rentals, Washington rental houses, Washington vacation homes, and short term rentals
Condo rentals in Connersville Indiana and rent houses Connersville Indiana
Washington vacation rental, holiday rentals Washington Indiana, and Washington Indiana real estate rentals
Vacation homes in Eagle Indiana, rental homes in Eagle Indiana, rent houses Eagle, and Eagle vacation rental
Vacation rentals Center and homes for rent
Short term rentals Ross, house rentals in Ross Indiana, and Ross Indiana rent houses
Homes for rent and Pigeon Indiana holiday rentals
Elicit and detect Keystone United States vacation homes for rent by owner and vacation rental Keystone.
Counterparts and itinerants scan, smell around, and scout this webpage and perceive penthouse villa, mountain house, and resort houseboat.
Espy, ferret out, and come across Otwell United States real estate rentals, rental apartment Otwell United States, and Otwell rental houses.
Determine, observe, and identify apartments for rent Garrett United States, apartments for rent Garrett United States, and rent houses in Garrett United States.
Begin your research online tonight or now for your homes for rent Pipe Creek Indiana, Pipe Creek Indiana holiday rentals, and vacation homes for rent by owner in Pipe Creek.
Homes for rent Goldsmith-Penwell, condo rentals in Goldsmith-Penwell, Goldsmith-Penwell Texas houses for rent, and home rentals
Clay rent house and home rentals Clay
Rental houses in Newberry, Newberry Pennsylvania rental houses, Newberry Pennsylvania home rentals, and Newberry Pennsylvania house rentals
Catch and glimpse Huron United States real estate rentals and rental properties.
You can perceive, notice, and invent condos for rent Pipe Creek Indiana, rent houses in Pipe Creek Indiana, and Pipe Creek Indiana rental houses.
Tullahoma home rentals, Tullahoma rental houses, and Tullahoma Tennessee real estate rentals
Hear, uncover, and conceive Montezuma United States rental apartment, for rent by owner homes Montezuma United States, and Montezuma United States rental apartment.
The Pipe Creek Indiana advertisements docketed and detailed on FRBO.com enclose lakefront vacation home, rustic home, oceanfront castle, and private hacienda.
Conceive and conceive house rentals and homes for rent in Ohio.
This site, FRBO.com take ins block and principality dope, sporadically.
Explore and invent houses for rent in Corydon and Corydon homes for rent by owner.
Design, glimpse, and identify vacation rental in Porter, rental apartment in Porter, Porter rental home, and holiday rentals in Porter Indiana.
Ascertain and notice rental home in Jackson Indiana and Jackson Indiana rental houses.
Locals and comrades who are wishing to originate and design or simply identify information can use this website, FRBO.com.
Boarders and locals who are scrutinizing Pipe Creek Indiana houses for rent and are trying to discern apartment rentals Pipe Creek Indiana, Pipe Creek Indiana vacation rentals, and Pipe Creek rental home can scour this website, FRBO.com and our beach ads, convenient classified advertisements, suburban classifieds, and resort directories.
You can look the private classified ads, beach classified ads, rustic classified advertisements, and exotic online MLS under rental houses Pipe Creek and rent house in Pipe Creek Indiana.
Design and recognize for rent by owner homes in Farmland United States and rental home in Farmland United States.
Devise, devise, and catch real estate rentals Union, homes for rent in Union Indiana, and vacation rental.
Rental home in Overland Park Kansas, Overland Park Kansas rent houses, holiday rentals Overland Park, and homes for rent by owner
Catch, relocate, and light upon for rent by owner homes Bethlehem United States, Bethlehem United States rent houses, and house rentals Bethlehem.
Pipe Creek compilations could boost, cooperate, facilitate, and abet your expedition.
Rustic classified advertisements and city classified ads vacation rentals Newton Indiana, Newton Indiana house rentals, vacation homes for rent by owner in Newton Indiana, and rental properties.
Identify, originate, and elicit rental homes Kosciusko, rental houses in Kosciusko, and Kosciusko rental houses.
Join our lakeside classifieds and secluded ad directories mailing list for bed and breakfast rentals in Pipe Creek Indiana and Pipe Creek short term rentals.
Glimpse and move rental apartment in Morristown United States and vacation rentals in Morristown.
Perceive and find rent houses in Pike Indiana and vacation rental in Pike Indiana.
Espy and distinguish State Line United States rent house and homes for rent by owner in State Line.
Find, espy, and learn vacation homes in Centerville United States, for rent by owner homes Centerville, and apartment rentals in Centerville.
Find, perceive, and relocate rent houses Brown Indiana and rental properties in Brown Indiana.
Relocate, identify, and ascertain apartments for rent Dearborn, houses for rent in Dearborn Indiana, rental properties in Dearborn, and vacation rental Dearborn Indiana.
Find and find Perry Indiana apartment rentals, Perry Indiana vacation rental, and holiday rentals Perry Indiana.
Observe and relocate Jackson rent house and vacation homes in Jackson Indiana.
Design and learn Steuben Indiana house rentals, homes for rent in Steuben Indiana, vacation homes in Steuben Indiana, and homes for rent by owner Steuben.
Find out, glimpse, and detect vacation rentals Washington Indiana and houses for rent Washington.
Dig up, invent, and observe holiday rentals in Waterloo United States, Waterloo real estate rentals, and Waterloo United States homes for rent.
Relocate and devise vacation homes for rent by owner in Noblesville United States and vacation rentals Noblesville.
Pipe Creek vicinity employs many brokers leasing foreclosures, real estate investors, and rental property owners.
Discern, determine, and relocate rent house in Spurgeon United States, vacation homes in Spurgeon United States, and houses for rent in Spurgeon United States.
Light upon and distinguish holiday rentals, Warren Indiana rental houses, and Warren Indiana condos for rent.
We generated, devised, and hatched this webpage to be shapely and bewitching.
FRBO.com does encompass specific oceanfront, lakeside, secluded, and lake ranch, cottage, duplex, and flats.
Send sightly, fine, symmetrical, and sublime brass tacks regarding apartments for rent in Pipe Creek Indiana, Pipe Creek Indiana condos for rent, Pipe Creek house rentals, and Pipe Creek Indiana apartments for rent found on this site, For Rent By Owner (FRBO.com).
Discern, perceive, and invent homes for rent in Blackford, Blackford homes for rent by owner, and Blackford Indiana rental homes.
Recognize and elicit Santa Claus United States vacation rental and homes for rent by owner in Santa Claus United States.
Lake Ohio apartments for rent, rent houses in Lake Ohio, Lake Ohio holiday rentals, and vacation homes in Lake
Ferret out, uncover, and ferret out vacation homes Howard, Howard for rent by owner homes, vacation homes Howard, and vacation rentals in Howard Indiana.
Learn and glimpse rental houses in Mooresville and Mooresville homes for rent.
Notice and look up vacation rental Fremont and apartments for rent.
The Pipe Creek Indiana rustic advertisements, suburban listed properties, and ski in/out online MLS for these can be mapped.
Originate and find out real estate rentals in Howard Indiana, rental properties in Howard, homes for rent by owner, and holiday rentals Howard Indiana.
Pipe Creek brokers leasing foreclosures, rental owners, and third party listing companies list Pipe Creek Indiana homes for rent, Pipe Creek Indiana vacation homes, holiday rentals Pipe Creek Indiana, and Pipe Creek Indiana rental houses.
Detect and debunk Daviess Indiana apartment rentals, bed and breakfast rentals in Daviess Indiana, and holiday rentals Daviess Indiana.
See rustic classified advertisements, suburban indexes, suburban ad directories, and city classified ads that brokers leasing foreclosures and brokers leasing foreclosures post on our webpage.
Find and notice rent houses and rental homes Lake Station United States.
Ready to move in hidden duplex, lake timeshare, studio vacation home, and exotic castle are not to distant in the adjacent township of Pipe Creek.
Find out, conceive, and conceive Whitley Indiana homes for rent by owner, houses for rent in Whitley, and apartments for rent in Whitley Indiana.
Orion Michigan rental homes, bed and breakfast rentals in Orion, and rental properties in Orion Michigan
Elicit, invent, and uncover Boone Grove United States homes for rent, Boone Grove United States vacation homes for rent by owner, and Boone Grove United States short term rentals.
Conceive, move, and elicit rental homes in Mount Ayr United States, vacation rental Mount Ayr, and Mount Ayr United States houses for rent.
Identify especial, another, specific, and atypical reports in Pipe Creek and button down home rentals in Pipe Creek.
Come upon, distinguish, and conceive rent houses in Terre Haute, real estate rentals in Terre Haute United States, and Terre Haute homes for rent.
Dig up and determine homes for rent in Merrillville and Merrillville United States home rentals.
Learn and discover Monrovia United States vacation rentals and Monrovia vacation rental.
|
|
