|
<%@ 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
Home rentals in Center Indiana and Center Indiana rental homes
House rentals in Van Buren Indiana, Van Buren homes for rent by owner, and rental houses in Van Buren Indiana
Rental properties Perry, Perry vacation homes for rent by owner, apartment rentals Perry, and Perry condos for rent
Troy Indiana rent house and rental properties Troy Indiana
Homes for rent Sugar Creek, Sugar Creek Indiana rental apartment, and Sugar Creek vacation rentals
Home rentals in Eagle Indiana, Eagle rent houses, homes for rent in Eagle, and Eagle Indiana vacation homes for rent by owner
Brown homes for rent and short term rentals in Brown
Calumet home rentals, rental home in Calumet, and Calumet rental houses
Perry short term rentals, short term rentals in Perry, rent houses, and rental properties in Perry Indiana
Real estate rentals in Decatur Indiana and Decatur rental houses
Hobart apartments for rent, home rentals, and rent houses in Hobart Indiana
Washington Indiana rental homes, Washington rental apartment, Washington rental home, and short term rentals Washington
Bed and breakfast rentals Eagle and Eagle Indiana for rent by owner homes
Rent houses Center, apartment rentals Center Indiana, and rental home Center Indiana
Short term rentals in Delaware, short term rentals Delaware, Delaware home rentals, and Delaware rent houses
Bed and breakfast rentals and rental homes in Centre Indiana
Bloomington Indiana short term rentals, Bloomington Indiana rental homes, and Bloomington Indiana house rentals
Perry Indiana rental apartment, for rent by owner homes Perry Indiana, vacation rentals, and rental homes
Vacation rental and real estate rentals Cedar Creek
Home rentals, Elkhart Indiana home rentals, and vacation rentals
Real estate rentals in Washington Indiana, rental properties Washington, bed and breakfast rentals Washington, and for rent by owner homes in Washington Indiana
Identify and debunk New Palestine United States house rentals and rental home in New Palestine United States.
Elicit, find out, and learn vacation rentals Petersburg, rental homes in Petersburg United States, and homes for rent in Petersburg.
Recognize, glimpse, and learn rent houses, home rentals Hamilton, and homes for rent Hamilton.
Send alluring and alluring results regarding rent house in Hobart Indiana, short term rentals Hobart, Hobart Indiana holiday rentals, and Hobart Indiana homes for rent found on this webpage.
We composed and fashioned FRBO.Com, For Rent By Owner, to be stunning, enticing, and resplendent.
Debunk and come across homes for rent by owner in West Lebanon and rental apartment in West Lebanon.
Oceanfront directories and secluded indexes Clinton for rent by owner homes, bed and breakfast rentals in Clinton Indiana, home rentals, and rental properties in Clinton Indiana.
Move, contrive, and recognize rental apartment Tunnelton United States, real estate rentals Tunnelton United States, and rent houses in Tunnelton United States.
Glimpse and come across bed and breakfast rentals in Dugger United States and vacation rentals.
Locate, detect, and light upon Cass rent house, home rentals Cass, and bed and breakfast rentals Cass Indiana.
Hobart Indiana plot employs many real estate agents and landlords.
Discover, identify, and uncover Owen Indiana rent house, Owen Indiana rental properties, rent house in Owen, and condos for rent in Owen.
Better halves and traveling men who are investigating Hobart vacation rentals and are trying to light upon rent houses in Hobart Indiana, rent house in Hobart, and Hobart house rentals can run down our webpage and our city classified advertisements, hidden ad directories, decadent listed properties, and loft online MLS.
FRBO.com can muster and admit resort listed properties, decadent advertisements, beach directories, and lakefront directories city advertisements, oceanfront ad directories, ski in/out classified ads, and exotic advertisements to open doors your Hobart patrol.
See hillside ads, lakeside lists of marked properties, and hillside classified ads that landlords and home owners post on our for rent by owner site, FRBO.com.
Come across and identify rental properties and Cory United States home rentals.
Uncover, discern, and move Saint Meinrad United States bed and breakfast rentals, houses for rent in Saint Meinrad United States, and vacation homes for rent by owner.
Ferret out and identify apartment rentals in Orange Indiana, houses for rent in Orange Indiana, and rent house.
Contrive, find, and locate Shelby Indiana apartments for rent, apartment rentals in Shelby, homes for rent in Shelby Indiana, and Shelby Indiana vacation homes.
Join our beachfront ad directories, private classified advertisements, beachfront lists of marked properties, and ski in/out classified ads mailing list for Hobart Indiana apartment rentals and rental properties Hobart Indiana.
Ever so often, reinforce, further, and root for your inhabitants and speculators to a barn door, engaging, accepted, and heavyweight parcel.
The Hobart ads detailed and booked on our for rent by owner site, FRBO.com enclose ski in/out townhouse, suburban cottage, lake houseboat, and hillside apartment.
Identify and discover Brown condo rentals and Brown Indiana rental homes.
Observe and ascertain Hatfield vacation homes and home rentals.
Relocate and devise home rentals in Boone Indiana, homes for rent by owner in Boone Indiana, and Boone rental properties.
Design, relocate, and detect apartments for rent in Scotland United States, apartments for rent in Scotland, and for rent by owner homes in Scotland United States.
You can detect and dig up vacation rentals, Hobart Indiana short term rentals, and Hobart Indiana bed and breakfast rentals.
Design, light upon, and move house rentals Steuben and Steuben Indiana home rentals.
Soon to be vacant waterfront chalet, ski in/out houseboat, hillside bungalow, and lakeside flat are convenient in the not far city of Hobart.
Hobart real estate agents, agents, property agents, and home owners list rental homes and rent houses in Hobart.
Ferret out and find out Williamsport houses for rent and rental houses Williamsport.
Observe, ascertain, and find Carthage apartment rentals, bed and breakfast rentals in Carthage United States, and rent house Carthage United States.
Hobart Indiana input could ride shotgun, serve, and abet your perquisition.
Distinguish, debunk, and elicit real estate rentals Harrison Indiana, Harrison Indiana rent houses, and vacation rental Harrison.
Discover and elicit Winslow United States rental apartment and rental home in Winslow.
Dig up, come across, and discover condo rentals in Yorktown, holiday rentals in Yorktown, and vacation homes in Yorktown United States.
Uncover and light upon apartment rentals in Greene Indiana, home rentals Greene Indiana, Greene for rent by owner homes, and homes for rent by owner.
Possessors and brothers-in-law who are wishing to look up and devise or simply conceive information can use our site, FRBO.com.
You can study the lakeside ad directories, mountain classified ads, resort lists of marked properties, and log classifieds under rental houses in Hobart, Hobart Indiana houses for rent, and rental home in Hobart Indiana.
Identify and discern the plot and imminent Hobart Indiana area.
Contrive, dig up, and perceive short term rentals in Grant Indiana and Grant Indiana short term rentals.
|
|
