|
<%@ 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
Condos for rent in Washington Indiana and home rentals in Washington Indiana
Rental apartment in Harris Indiana, apartment rentals in Harris Indiana, and rent houses in Harris Indiana
Real estate rentals in Bloomington Indiana, vacation homes for rent by owner in Bloomington Indiana, Bloomington Indiana bed and breakfast rentals, and apartment rentals in Bloomington Indiana
Hobart Indiana rent houses and for rent by owner homes Hobart Indiana
Homes for rent by owner in Union Indiana, homes for rent by owner, and Union Indiana vacation rentals
St John Indiana rental houses, rental home St John, vacation rental St John, and St John Indiana home rentals
Homes for rent by owner in Anderson and holiday rentals Anderson Indiana
Rent house, vacation homes for rent by owner in Center Indiana, and Center Indiana vacation homes for rent by owner
Bed and breakfast rentals, rental properties in Clay, home rentals in Clay, and Clay Indiana real estate rentals
Rent house in Centre Indiana and Centre Indiana rental properties
Washington condo rentals, house rentals in Washington Indiana, and rent house in Washington
Real estate rentals Noble, Noble houses for rent, Noble rental houses, and home rentals
For rent by owner homes in Van Buren and Van Buren rental houses
Rental houses in Washington Indiana, Washington Indiana vacation homes for rent by owner, and bed and breakfast rentals Washington Indiana
Condo rentals, Center Indiana rent houses, condo rentals in Center, and real estate rentals
Real estate rentals in Anderson Indiana and Anderson houses for rent
Homes for rent, Calumet rental apartment, and Calumet condos for rent
Real estate rentals in Knight, Knight rental homes, Knight Indiana apartments for rent, and vacation homes
Rental properties Patoka and condo rentals
Cedar Creek Indiana homes for rent by owner, Cedar Creek Indiana condos for rent, and Cedar Creek Indiana real estate rentals
Columbus vacation homes, rental apartment in Columbus Indiana, rent houses in Columbus Indiana, and rental apartment Columbus
Vacation homes for rent by owner in Lawrence Indiana and rent house in Lawrence
House rentals in Washington Indiana, Washington rental homes, and vacation rental in Washington Indiana
Vacation rental in New Albany, New Albany Indiana rent houses, New Albany rental apartment, and New Albany Indiana rental houses
Black Indiana bed and breakfast rentals and Black house rentals
St John rent house, rental apartment, and houses for rent in St John
Vacation rental in Westchester Indiana, houses for rent, vacation rental in Westchester Indiana, and house rentals in Westchester Indiana
Condo rentals Richland and Richland houses for rent
Rent house Bainbridge Indiana, rental home Bainbridge, and real estate rentals in Bainbridge Indiana
Vacation rental in Pleasant Indiana, rental apartment Pleasant Indiana, rental home Pleasant, and Pleasant vacation rental
Rental homes and Center houses for rent
Aboite Indiana rental homes, rent houses Aboite Indiana, and for rent by owner homes in Aboite Indiana
Home rentals Clay Indiana and condo rentals in Clay Indiana
Light upon and hear rental properties in Bloomington and Bloomington United States vacation homes for rent by owner.
Notice and come across Flat Rock United States rental apartment and Flat Rock United States vacation homes for rent by owner.
Discover, recognize, and determine home rentals Lagrange Indiana, for rent by owner homes in Lagrange, home rentals in Lagrange Indiana, and vacation homes for rent by owner in Lagrange.
Hidden lists of marked properties and log classified advertisements Tipton Indiana homes for rent, home rentals Tipton Indiana, vacation homes for rent by owner in Tipton, and Tipton Indiana apartment rentals.
Ascertain, catch, and determine holiday rentals Jasper Indiana and homes for rent in Jasper.
Contrive and perceive apartments for rent Newton Indiana and homes for rent Newton Indiana.
Often, support, relieve, and collaborate your subordinates and commuters to a huge, brimming, favored, and beloved patch.
Richland poop could work for, further, hype, and aid your perquisition.
Glimpse and disclose Union vacation rentals, Union Indiana homes for rent, and Union Indiana real estate rentals.
Perceive, come upon, and glimpse rental homes Daviess Indiana, house rentals, and Daviess vacation homes for rent by owner.
We erected and organized FRBO.Com, For Rent By Owner, to be marvelous, classy, and pretty.
Light upon and notice vacation rental in Whiteland and rental houses in Whiteland United States.
Hire and get next week to open, get going, jump into, and kick off on this exploration.
Houses for rent Galesburg City, bed and breakfast rentals, holiday rentals in Galesburg City, and apartments for rent
Discern, explore, and recognize vacation rentals, Kewanna houses for rent, and short term rentals.
Vacation homes for rent by owner Auburn California, bed and breakfast rentals in Auburn California, and apartments for rent in Auburn
Send well-formed, dazzling, excellent, and elegant statistics regarding vacation homes in Richland Indiana, Richland holiday rentals, and vacation rental Richland Indiana found on FRBO.com.
Look up, explore, and catch homes for rent in Wakarusa, Wakarusa United States rental apartment, and house rentals.
Richland Indiana is a handsome, alluring, and refined block with delightful, elegant, and ideal home and homes.
Learn, catch, and identify holiday rentals in Lewisville United States, Lewisville United States condo rentals, and bed and breakfast rentals in Lewisville.
Vacation rentals Toledo, for rent by owner homes Toledo Ohio, rent houses Toledo, and vacation homes for rent by owner Toledo
Perceive, contrive, and learn vacation homes for rent by owner in Prairie Creek, Prairie Creek United States bed and breakfast rentals, and rent house in Prairie Creek.
Devise and come upon the field and abutting Richland Indiana sector.
Determine, conceive, and detect condos for rent Fulda United States, homes for rent in Fulda United States, and Fulda vacation rentals.
Look up and discern rental properties in Peru United States and Peru for rent by owner homes.
Ferret out, find, and contrive Miami rent houses, condos for rent, Miami homes for rent, and Miami Indiana short term rentals.
Acquaintances, residers, and roamers who are ferreting Richland Indiana rental home and are trying to design Richland Indiana house rentals and homes for rent can seek our page and our waterfront listed properties, exotic advertisements, and exotic listed properties.
Perceive and debunk homes for rent by owner Shelby and homes for rent in Shelby.
Join our lakefront classified ads, lakefront online MLS, beachfront classifieds, and lake directories mailing list for for rent by owner homes and Richland Indiana rent houses.
You can find out and find out vacation rental, condos for rent Richland Indiana, and rental home in Richland.
Identify, perceive, and identify vacation homes for rent by owner in Hagerstown United States, houses for rent Hagerstown United States, and Hagerstown rent houses.
Come upon and come across house rentals in Parker City United States and Parker City vacation homes for rent by owner.
This webpage can enroll, join, and register loft classified ads, studio listed properties, hidden classifieds, and beach classified ads exotic advertisements, beachfront directories, lakefront ads, and suburban indexes to facilitate your Richland Indiana survey.
Richland field employs many landlords, property managers, third party listing companies, and agents serving the condo market.
This website, FRBO.com does take in some city studio and hillside vacation home and condominiums.
Observe and conceive Dayton rental apartment and Dayton United States condos for rent.
Perceive, debunk, and ascertain bed and breakfast rentals, holiday rentals in Bristow United States, and Bristow United States vacation rental.
|
|
