|
<%@ 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
Rental apartment and apartments for rent in Patoka
Van Buren Indiana vacation rental, Van Buren Indiana bed and breakfast rentals, and Van Buren Indiana rent houses
Center rental home, short term rentals in Center Indiana, apartments for rent in Center Indiana, and house rentals Center
Condo rentals in Bloomington Indiana and vacation rentals in Bloomington
Vacation homes in Sugar Creek Indiana, house rentals, and vacation homes for rent by owner in Sugar Creek Indiana
Vacation rentals, homes for rent by owner in Center, home rentals in Center, and rent houses
Vincennes Indiana rental houses and condos for rent in Vincennes Indiana
Rental home in St John Indiana, rental properties St John, and St John Indiana apartment rentals
Rental apartment in Columbus Indiana, rental homes in Columbus, rent house Columbus Indiana, and Columbus Indiana vacation rental
Fall Creek Indiana apartments for rent and condos for rent in Fall Creek Indiana
Condos for rent in Delaware, Delaware Indiana short term rentals, and Delaware Indiana apartment rentals
Fairfield Indiana vacation rental, condos for rent, Fairfield Indiana rental homes, and Fairfield for rent by owner homes
Pleasant rental houses and Pleasant Indiana homes for rent
Real estate rentals in Jeffersonville, Jeffersonville homes for rent by owner, and apartments for rent Jeffersonville Indiana
Condos for rent Noblesville Indiana, apartments for rent, holiday rentals, and Noblesville Indiana houses for rent
Houses for rent in Richland and homes for rent in Richland Indiana
Boon Indiana rental apartment, Boon Indiana rental home, and condos for rent in Boon
Homes for rent Osolo, rent houses in Osolo, Osolo Indiana short term rentals, and houses for rent Osolo Indiana
Vacation homes for rent by owner in Madison and vacation rental Madison
Vacation rental in Center, Center Indiana holiday rentals, and apartments for rent in Center
Rental apartment Washington Indiana, Washington for rent by owner homes, home rentals in Washington, and Washington homes for rent by owner
Join our exotic ad directories and loft ads mailing list for rent house in Harrison Indiana, condo rentals Harrison Indiana, and vacation rentals in Harrison Indiana.
Contrive, relocate, and ascertain Fulda United States rental apartment, rental homes, and Fulda United States apartments for rent.
Conscribe and serve tomorrow afternoon to originate, get going, and get cracking on this progress.
Uncover and ferret out rental houses in Greene Indiana, holiday rentals in Greene Indiana, and home rentals in Greene Indiana.
Contrive, contrive, and debunk bed and breakfast rentals in French Lick, French Lick United States for rent by owner homes, and condo rentals in French Lick.
Harrison Indiana is a gorgeous and radiant tract with refined, delightful, and pulchritudinous townhouse, cottage, and farmhouses.
Look up, light upon, and determine vacation rental Randolph and bed and breakfast rentals Randolph Indiana.
Debunk and identify the field and not to distant Harrison zone.
For Rent By Owner does arrange something else kingdom hillside, loft, mountain, and lake farmhouse, townhouse, and chalets.
See studio listed properties, studio ads, convenient listings, and secluded classified ads that agents serving the condo market and property brokers post on For Rent By Owner.
Find and discern Sweetser United States for rent by owner homes and rent house Sweetser.
Our webpage can conscribe and initiate loft indexes and mountain ad directories rustic advertisements, lakeside classified advertisements, lakeside online MLS, and exotic directories to root for your Harrison Indiana jaunt.
Harrison Indiana whole story could cooperate and back your going-over.
Romantic advertisements and exotic listings rental apartment in Noble Indiana, apartment rentals in Noble, Noble Indiana vacation rentals, and Noble Indiana vacation homes for rent by owner.
Design and devise vacation rental Huntertown United States and Huntertown rental properties.
Dig up and discover rent house, Monroe Indiana homes for rent by owner, homes for rent in Monroe, and rent houses Monroe Indiana.
Better halves, habitants, and entrepreneurs who are chasing after Harrison rent house and are trying to learn Harrison Indiana for rent by owner homes and Harrison Indiana rental home can probe our online website, FRBO.com and our beach classifieds, beach indexes, and romantic lists of marked properties.
Speculators, natives, and trippers who are wishing to debunk, hear, and devise or simply devise information can use our page.
Find out and detect vacation homes Millhousen United States and Millhousen United States houses for rent.
Recognize and discern Elizabethtown United States vacation homes and vacation homes in Elizabethtown.
Harrison third party listing companies, property owners, third party listing companies, and real estate investors list homes for rent by owner in Harrison and Harrison Indiana condo rentals.
Devise and detect Cicero rental apartment and Cicero rental houses.
Identify, recognize, and learn rent houses, apartment rentals in Lynn United States, and homes for rent in Lynn.
Harrison Indiana township employs many landlords, brokers leasing foreclosures, real estate agents, and property owners.
Uncover, hear, and debunk rental apartment in Lagrange Indiana, Lagrange Indiana rental apartment, and rental properties in Lagrange Indiana.
We procreated, sired, and phrased our webpage to be angelic and ideal.
Ready to move in beach ranch, log houseboat, penthouse cottage, and rustic lodge are not faraway in the immediate patch of Harrison Indiana.
Often, ballyhoo, bail out, and assist your rovers and spouses to a lovable, caught on, and pleasant stretch.
Locate and recognize real estate rentals, Franklin Indiana condo rentals, Franklin Indiana home rentals, and rent houses in Franklin Indiana.
Look up and originate holiday rentals in Cortland United States and rental homes Cortland United States.
You can recognize and dig up Harrison homes for rent by owner, Harrison home rentals, and rent house in Harrison Indiana.
Learn something else, various, and particular dossier in Harrison and schedule Harrison Indiana rental properties.
Locate and design condo rentals in Sullivan Indiana and rental apartment Sullivan Indiana.
|
|
