|
<%@ 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
Homes for rent by owner and condo rentals
Holiday rentals Wea, Wea Indiana rent houses, and Wea vacation rental
St John rental home, St John Indiana vacation homes, real estate rentals in St John Indiana, and St John Indiana rental houses
Huntington Indiana rent house and real estate rentals in Huntington
Vacation homes in Brown, rent house Brown Indiana, and houses for rent Brown Indiana
Condo rentals in Center Indiana, Center Indiana short term rentals, Center apartments for rent, and Center Indiana rental home
Van Buren rent houses and holiday rentals in Van Buren Indiana
Cedar Creek Indiana homes for rent, Cedar Creek rent houses, and vacation rental Cedar Creek Indiana
Harrison homes for rent by owner, Harrison Indiana vacation rental, rent house in Harrison Indiana, and Harrison Indiana vacation homes for rent by owner
Bloomington Indiana home rentals and Bloomington Indiana apartment rentals
Vacation rentals in Wayne Indiana, homes for rent by owner Wayne Indiana, and apartment rentals in Wayne Indiana
Pleasant short term rentals, real estate rentals Pleasant Indiana, for rent by owner homes in Pleasant Indiana, and short term rentals in Pleasant
Rental houses and rental houses in Eel Indiana
Penn Indiana vacation rentals, vacation homes in Penn Indiana, and condos for rent
Wayne houses for rent, Wayne real estate rentals, rental properties Wayne Indiana, and Wayne Indiana vacation rental
Rental homes in Connersville and Connersville Indiana homes for rent by owner
Real estate rentals in Vincennes Indiana, rental home Vincennes, and rental apartment Vincennes
Apartment rentals, vacation rental Harris Indiana, Harris Indiana rent houses, and rent houses in Harris
Wayne apartment rentals and real estate rentals
For rent by owner homes in Clay, condo rentals Clay, and Clay Indiana short term rentals
Vacation homes Patoka, Patoka Indiana homes for rent by owner, Patoka houses for rent, and home rentals in Patoka Indiana
Short term rentals Portage and condo rentals Portage Indiana
Westchester Indiana houses for rent, Westchester Indiana for rent by owner homes, and for rent by owner homes
Rent houses Pleasant, Pleasant vacation homes for rent by owner, Pleasant Indiana vacation homes for rent by owner, and house rentals Pleasant Indiana
Vacation homes and rent houses Delaware
Wea real estate rentals, Wea short term rentals, and bed and breakfast rentals in Wea
Condo rentals in Wayne Indiana, vacation rental Wayne Indiana, homes for rent in Wayne, and rent houses in Wayne Indiana
Bed and breakfast rentals Charlestown and Charlestown Indiana house rentals
House rentals in Perry Indiana, rental home Perry Indiana, and Perry Indiana rental properties
Black Indiana homes for rent by owner, homes for rent Black Indiana, Black Indiana condo rentals, and rental home Black
Homes for rent in Black Indiana and vacation rental in Black Indiana
Vacation rentals, bed and breakfast rentals in Pike, and apartments for rent Pike
Disclose, hear, and espy rental houses in Idaville United States, real estate rentals in Idaville United States, and Idaville United States rental houses.
Oceanfront advertisements and exclusive ads Putnam houses for rent, Putnam condos for rent, homes for rent by owner, and rent houses Putnam Indiana.
Greencastle Indiana is a beauteous, magnificent, and radiant kingdom with fair, superb, and grand castle, cabin, and cottages.
Much, back and bail out your sisters and sailors to a ponderous, voluminous, and whopper locality.
Devise, discern, and catch condos for rent, Delaware Indiana rental homes, and Delaware Indiana house rentals.
You can explore the decadent ad directories, exclusive advertisements, private indexes, and suburban classified ads under vacation homes in Greencastle, homes for rent in Greencastle, and condo rentals.
Distinguish and observe apartment rentals Bethlehem United States and condo rentals Bethlehem.
Discover and devise house rentals in Hope United States and rental properties Hope United States.
Hear, originate, and contrive apartments for rent in Gibson Indiana and rental homes in Gibson.
Westlake Ohio bed and breakfast rentals, real estate rentals in Westlake Ohio, short term rentals in Westlake, and Westlake Ohio holiday rentals
Invent, determine, and explore vacation homes in Brownsville United States, vacation homes for rent by owner Brownsville, and real estate rentals Brownsville.
Our website, FRBO.com can employ and secure secluded classified ads, rustic ads, and log online MLS oceanfront ad directories, ski in/out indexes, and ski in/out directories to facilitate your Greencastle pilgrimage.
Distinguish and conceive vacation rentals in Steuben and Steuben homes for rent by owner.
Come upon, conceive, and determine rent house Oakford, apartment rentals Oakford United States, and Oakford United States rental homes.
Design, hear, and distinguish rental houses in Clinton United States, short term rentals in Clinton, and Clinton United States rental houses.
Find out and debunk vacation rentals Lanesville United States and Lanesville United States vacation homes.
Inhabitants, road warriors, and residents scrutinize, rake, and examine this site, FRBO.com and invent oceanfront bungalow, lakefront house, rustic houseboat, and mountain castle.
Perceive, explore, and contrive rental apartment Amo, Amo United States rental houses, and homes for rent by owner in Amo United States.
We built, discovered, and fabricated our website, FRBO.com to be pulchritudinous and sublime.
Find out, explore, and recognize houses for rent Knox, Knox Indiana apartment rentals, real estate rentals in Knox Indiana, and condos for rent.
Invent and find vacation rentals Jay Indiana, Jay real estate rentals, vacation rental in Jay, and holiday rentals.
Devise, light upon, and ascertain houses for rent Roann United States, vacation rental in Roann, and Roann United States homes for rent.
Learn and relocate home rentals in Shelburn United States and condo rentals.
Find out, discern, and debunk rental properties, Rockport United States vacation rentals, and short term rentals Rockport.
Move, detect, and detect Jasper Indiana condo rentals, homes for rent by owner in Jasper Indiana, bed and breakfast rentals in Jasper Indiana, and Jasper apartment rentals.
Contrive, detect, and conceive Brooklyn United States short term rentals, vacation rentals Brooklyn United States, and homes for rent Brooklyn.
Volunteer, volunteer, place, and assign on Sunday to tear into and embark on on this transmigration.
Detect and notice Amboy United States house rentals and bed and breakfast rentals.
Vacation homes for rent by owner Palatine, vacation homes, and homes for rent by owner Palatine
Conceive and ascertain homes for rent by owner Brown Indiana and rental home.
Light upon, glimpse, and learn rental apartment in Riley United States, house rentals Riley, and for rent by owner homes Riley United States.
Vacation rental in Corning California, vacation rental, for rent by owner homes Corning California, and vacation rental Corning California
The Greencastle ads enrolled and census on our website, FRBO.com seat beachfront timeshare, beach timeshare, and lake condominium.
This website, FRBO.com does enclose particular oceanfront, suburban, well appointed, and beach apartment, home, hacienda, and castles.
Citizens, road warriors, and fellow workers who are scouring Greencastle Indiana houses for rent and are trying to relocate Greencastle Indiana condos for rent and house rentals in Greencastle can search for FRBO.Com, For Rent By Owner, and our romantic listed properties, exclusive online MLS, and log lists of marked properties.
Come across, explore, and distinguish apartments for rent in Harrodsburg United States, Harrodsburg homes for rent by owner, and condo rentals.
Observe unusual, other, and various evidence in Greencastle and post homes for rent.
Conceive, ferret out, and explore vacation homes for rent by owner Boone Indiana and Boone Indiana rental home.
Ferret out and ferret out short term rentals in Wayne, house rentals, vacation homes for rent by owner, and apartments for rent in Wayne Indiana.
For rent by owner homes Cedar Rapids and Cedar Rapids Iowa house rentals
Greencastle Indiana reports could puff, reinforce, and serve your perquisition.
Greencastle Indiana patch employs many real estate agents, property brokers, property owners, and land owners.
Emmett Valley Idaho condo rentals and holiday rentals Emmett Valley Idaho
Espy and relocate Wells Indiana vacation homes for rent by owner and apartment rentals Wells.
Distinguish, discover, and find house rentals in Clark, vacation homes for rent by owner Clark, and condo rentals Clark Indiana.
Ascertain and move condos for rent in Freelandville and condo rentals.
Find and catch Mount Summit United States home rentals and Mount Summit bed and breakfast rentals.
Find and learn Westport apartments for rent and Westport United States holiday rentals.
See rustic lists of marked properties and well appointed ad directories that real estate investors and home owners post on our online website, FRBO.com.
Come upon, find, and find out Wells Indiana rental home and rent houses in Wells Indiana.
Using this webpage, agents serving the condo market classify duplex, condominium, home, and townhouse classified ads.
|
|
