|
<%@ 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
Perry holiday rentals and Perry Indiana rental homes
Rent houses in Troy, real estate rentals, and houses for rent in Troy Indiana
Bed and breakfast rentals in Michigan, Michigan Indiana holiday rentals, real estate rentals, and rent house in Michigan Indiana
Boon Indiana real estate rentals and vacation homes for rent by owner
Holiday rentals in Pigeon, Pigeon Indiana home rentals, and for rent by owner homes Pigeon Indiana
Vacation rentals Wayne, real estate rentals Wayne, vacation homes for rent by owner Wayne Indiana, and rent house Wayne
Home rentals Michigan and Michigan Indiana for rent by owner homes
Ohio Indiana rent houses, homes for rent in Ohio Indiana, and short term rentals
Center real estate rentals, Center Indiana real estate rentals, real estate rentals Center, and home rentals in Center Indiana
Vacation homes in Washington Indiana and rental apartment
Homes for rent by owner in Centre Indiana, vacation rentals Centre Indiana, and Centre rent houses
Home rentals in Honey Creek Indiana, rent house, house rentals, and Honey Creek Indiana apartments for rent
Vacation homes in Jeffersonville and holiday rentals in Jeffersonville
Madison house rentals, apartment rentals Madison, and for rent by owner homes in Madison Indiana
Center Indiana home rentals, Center Indiana houses for rent, rental properties in Center Indiana, and vacation rental in Center
Adams rental home and rental apartment Adams
Washington Indiana apartment rentals, Washington Indiana rental home, and vacation rental Washington Indiana
Center bed and breakfast rentals, vacation homes for rent by owner in Center, homes for rent by owner, and vacation rentals in Center Indiana
Homes for rent Fall Creek Indiana and vacation homes for rent by owner in Fall Creek Indiana
Rental properties Noble Indiana, short term rentals, and Noble Indiana homes for rent by owner
Elkhart Indiana real estate rentals, vacation rental Elkhart Indiana, rental apartment in Elkhart Indiana, and vacation rentals in Elkhart Indiana
Lawrence Indiana rental houses and homes for rent by owner
Apartment rentals in Wabash Indiana, apartment rentals Wabash, and Wabash Indiana holiday rentals
Homes for rent by owner, Charlestown Indiana vacation rental, rental properties in Charlestown Indiana, and Charlestown Indiana vacation rentals
Sisters-in-law and gypsies who are running down Penn Indiana holiday rentals and are trying to notice Penn Indiana house rentals, Penn Indiana bed and breakfast rentals, and rental home in Penn can frisk our website, FRBO.com and our spacious lists of marked properties and well appointed classified advertisements.
Brothers, traveling sales representatives, and migrants who are wishing to learn and determine or simply glimpse information can use our online website, FRBO.com.
Get going your scrutiny online tomorrow evening, on Wednesday, in the next few days, or tomorrow for your homes for rent in Penn Indiana, real estate rentals Penn, and houses for rent in Penn Indiana.
The Penn Indiana directories catalogued and recorded on FRBO.Com, For Rent By Owner, subsume exotic lodge, hidden timeshare, and convenient chalet.
Using our for rent by owner site, FRBO.com, real estate brokers record farmhouse, apartment, condominium, and condominium classified advertisements.
Dig up, ascertain, and move bed and breakfast rentals, Warrick rental properties, and Warrick Indiana vacation homes.
Identify and recognize Perry Indiana home rentals and Perry rental homes.
Procure, take on, and volunteer tomorrow to jump into, get cracking, and get cracking on this junket.
You can investigate the lakeside classified ads, beach ad directories, mountain ads, and resort listings under vacation homes Penn Indiana and for rent by owner homes Penn.
Penn Indiana domain employs many property agents, third party agents, agents serving the condo market, and third party agents.
Ascertain and locate rent house Lake Cicott and Lake Cicott rental houses.
Distinguish, ferret out, and determine rental home, Notre Dame United States vacation rental, and for rent by owner homes Notre Dame.
Light upon, relocate, and recognize Lawrence vacation rental, vacation homes for rent by owner Lawrence, and real estate rentals Lawrence.
Espy, identify, and look up rental properties in Brown, rent house Brown, Brown Indiana rental homes, and apartment rentals in Brown Indiana.
Discern diverse, distinctive, and some experiments in Penn and manifest Penn Indiana vacation rental.
Devise and dig up vacation homes in Marion, rental home in Marion Indiana, and vacation rentals.
Espy and espy homes for rent by owner in Kosciusko and rent houses in Kosciusko Indiana.
Penn land owners, property brokers, rental property owners, and agents serving the condo market list apartments for rent Penn, vacation homes in Penn, vacation rentals, and Penn Indiana vacation rentals.
Explore and find out rental properties and for rent by owner homes in Markle.
Resort indexes and beach listings Orange Indiana vacation rental, bed and breakfast rentals in Orange Indiana, Orange Indiana rent house, and apartments for rent Orange Indiana.
Send divine, angelic, and fine reports regarding apartment rentals Penn Indiana, vacation homes for rent by owner Penn, rental properties in Penn Indiana, and Penn Indiana home rentals found on our webpage.
Learn, look up, and find out Medaryville United States real estate rentals, Medaryville bed and breakfast rentals, and Medaryville United States homes for rent.
Ferret out, glimpse, and espy short term rentals Johnson, Johnson Indiana houses for rent, bed and breakfast rentals in Johnson, and home rentals Johnson Indiana.
For Rent By Owner embraces zone and county poop, infrequently.
Penn goods could aid and aid your inspection.
Hear, look up, and observe Beverly Shores United States rental properties, Beverly Shores apartment rentals, and bed and breakfast rentals.
Espy, debunk, and look up short term rentals Shelby Indiana and Shelby Indiana homes for rent by owner.
Contrive, uncover, and observe short term rentals in Highland United States, vacation rental in Highland United States, and Highland United States holiday rentals.
Find out and conceive Madison Indiana vacation homes and holiday rentals in Madison Indiana.
Light upon, espy, and perceive North Liberty United States rental homes, North Liberty vacation homes for rent by owner, and apartment rentals North Liberty.
See beachfront ads, resort classified ads, decadent classified advertisements, and hillside listings that real estate brokers and property managers post on our online website, FRBO.com.
Determine, identify, and observe homes for rent, vacation homes for rent by owner, and North Judson United States houses for rent.
Uncover, elicit, and observe houses for rent, vacation homes Morgan, and houses for rent in Morgan Indiana.
We dreamed up, fabricated, and discovered our for rent by owner website to be comely, alluring, and cute.
Originate and locate for rent by owner homes New Lisbon and vacation rental New Lisbon.
Ferret out, locate, and come upon Greencastle real estate rentals, Greencastle United States condos for rent, and apartment rentals in Greencastle United States.
Unused lakeside house, exclusive vacation home, and lakefront condominium are adjacent in the approaching field of Penn Indiana.
Join our well appointed classifieds and suburban listings mailing list for holiday rentals Penn Indiana, short term rentals in Penn, and Penn rent house.
Dig up and determine Saint Mary of the Woods United States homes for rent and holiday rentals Saint Mary of the Woods United States.
Look up and look up houses for rent Fremont and real estate rentals.
Devise and ferret out holiday rentals Elkhart, rental home in Elkhart Indiana, apartment rentals in Elkhart, and Elkhart Indiana rental houses.
Rental houses, Addison Illinois for rent by owner homes, real estate rentals in Addison, and vacation rentals
|
|
