|
<%@ 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
Washington rent house and real estate rentals Washington Indiana
Center Indiana homes for rent by owner, Center Indiana vacation homes, and rental home Center Indiana
Anderson Indiana house rentals, Anderson Indiana rental apartment, vacation rentals Anderson Indiana, and holiday rentals Anderson Indiana
Condo rentals Peru and Peru Indiana apartment rentals
Condo rentals Portage Indiana, home rentals Portage, and rental home Portage
Rental home Union Indiana, vacation rentals in Union Indiana, real estate rentals Union Indiana, and Union Indiana condos for rent
Clay Indiana real estate rentals and Clay holiday rentals
Pleasant Indiana apartments for rent, Pleasant apartment rentals, and house rentals in Pleasant Indiana
Ohio Indiana bed and breakfast rentals, Ohio condo rentals, rental apartment in Ohio Indiana, and Ohio Indiana apartment rentals
Apartment rentals in Boon and for rent by owner homes Boon
House rentals in Wabash, vacation rental in Wabash, and Wabash vacation rental
Bed and breakfast rentals, vacation homes for rent by owner in Delaware, Delaware Indiana rental apartment, and Delaware Indiana real estate rentals
Condo rentals in Pleasant Indiana and Pleasant Indiana homes for rent by owner
Vacation rentals in Center Indiana, Center Indiana vacation rental, and rent houses in Center
Rent houses, house rentals in Washington Indiana, holiday rentals Washington, and Washington Indiana short term rentals
Vacation homes for rent by owner and for rent by owner homes Connersville Indiana
Jeffersonville Indiana rental apartment, Jeffersonville Indiana rental houses, and Jeffersonville Indiana home rentals
Condo rentals Washington, home rentals Washington Indiana, vacation rental in Washington, and vacation rental Washington Indiana
Madison Indiana homes for rent and homes for rent by owner in Madison
Lawrence Indiana short term rentals, Lawrence rental apartment, and rental homes in Lawrence
Coolspring rental homes, homes for rent in Coolspring Indiana, vacation rental, and Coolspring Indiana condo rentals
City lists of marked properties and penthouse lists of marked properties Tipton Indiana rental apartment, vacation homes for rent by owner Tipton, rent house in Tipton, and Tipton apartment rentals.
Journeyers, co-workers, and rovers search for , grub, and look FRBO.Com, For Rent By Owner, and detect secluded ranch, loft ranch, and penthouse home.
Observe, identify, and recognize bed and breakfast rentals, rent houses, and Huntertown United States vacation rental.
Conceive, light upon, and locate Oakland City house rentals, apartment rentals Oakland City United States, and apartments for rent Oakland City United States.
We fabricated and originated FRBO.com to be pleasing and pretty.
Locate and originate Madison United States holiday rentals and rental houses.
Get going your hunt online next weekend, now, or this week for your apartment rentals in Centre and homes for rent Centre Indiana.
Ferret out, find out, and ascertain rental homes Markle, Markle United States holiday rentals, and Markle United States rental home.
Relocate, debunk, and glimpse bed and breakfast rentals and Brown Indiana homes for rent by owner.
Originate and detect homes for rent by owner Kosciusko Indiana, homes for rent by owner Kosciusko Indiana, and Kosciusko Indiana houses for rent.
Debunk and originate rental properties Morgan Indiana, condo rentals in Morgan, holiday rentals in Morgan Indiana, and rental home in Morgan.
Not seldom, collaborate and puff your professors, fraternity members, and fortune-hunters to a really now, monster, strapping, and full tract.
Our for rent by owner site, FRBO.com does comprehend individual principality convenient, exotic, studio, and studio flat, castle, and houseboats.
Dig up, perceive, and catch Fulton Indiana short term rentals and Fulton Indiana vacation homes.
Distinguish another story and specific poop sheet in Centre and spell out Centre rental apartment.
Centre Indiana compilations could facilitate, stump, push, and benefit your going-over.
Move and notice homes for rent by owner in Whitestown United States and rent houses in Whitestown United States.
Move and glimpse houses for rent in Hemlock and bed and breakfast rentals in Hemlock.
Conceive, observe, and perceive rent house Hagerstown, for rent by owner homes Hagerstown United States, and Hagerstown United States rental apartment.
Elicit, observe, and discern Greene real estate rentals, homes for rent by owner, rent house in Greene Indiana, and Greene Indiana rental homes.
You can identify, explore, and recognize homes for rent in Centre Indiana and short term rentals Centre Indiana.
Notice, detect, and locate short term rentals in Spencer Indiana, Spencer Indiana house rentals, and holiday rentals in Spencer Indiana.
Centre real estate brokers, real estate brokers, and brokers leasing foreclosures list Centre Indiana vacation homes for rent by owner and Centre Indiana condo rentals.
Move and identify rent houses and Michigan City United States home rentals.
You can comb the lakefront directories and convenient classifieds under houses for rent, rental home Centre, and Centre holiday rentals.
Discern and determine rental homes in Versailles United States and apartment rentals in Versailles United States.
Discern and locate homes for rent by owner in Beverly Shores and holiday rentals in Beverly Shores.
Glimpse and perceive holiday rentals in Randolph Indiana and Randolph Indiana rental properties.
The Centre Indiana penthouse ads, lake classified advertisements, and convenient online MLS for these can be mapped.
Perceive, originate, and contrive apartments for rent La Porte Indiana, bed and breakfast rentals La Porte Indiana, and houses for rent in La Porte Indiana.
Design and notice Bristow apartments for rent and apartment rentals in Bristow United States.
Centre Indiana vicinity employs many third party agents, condo owners, and agents.
|
|
