|
<%@ 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
Condo rentals in Wabash Indiana and vacation homes for rent by owner in Wabash
Rental homes, for rent by owner homes Pike, and Pike Indiana house rentals
Guilford Indiana bed and breakfast rentals, homes for rent by owner, rental houses in Guilford Indiana, and short term rentals
Homes for rent by owner in Wayne Indiana and Wayne Indiana rental homes
Bed and breakfast rentals in Wabash, Wabash Indiana holiday rentals, and holiday rentals Wabash Indiana
Short term rentals in Harrison, Harrison Indiana homes for rent by owner, Harrison Indiana rent house, and vacation rentals in Harrison
Center Indiana vacation rental and Center Indiana condo rentals
For rent by owner homes in Penn Indiana, Penn Indiana houses for rent, and for rent by owner homes in Penn
Rent houses in Bainbridge Indiana, vacation homes for rent by owner in Bainbridge, Bainbridge rent houses, and Bainbridge Indiana homes for rent by owner
Harrison vacation homes for rent by owner and houses for rent Harrison Indiana
Houses for rent Lawrenceburg Indiana, rent house in Lawrenceburg, and rental apartment
Washington Indiana real estate rentals, home rentals in Washington, homes for rent by owner Washington Indiana, and bed and breakfast rentals in Washington Indiana
Rent house and Centre vacation homes for rent by owner
Center vacation rental, apartment rentals in Center Indiana, and real estate rentals in Center
Rental homes in Mount Pleasant Indiana, rental home in Mount Pleasant Indiana, houses for rent, and real estate rentals Mount Pleasant Indiana
Charlestown Indiana rent house and Charlestown Indiana rental homes
New Albany Indiana short term rentals, holiday rentals, and real estate rentals in New Albany Indiana
Vacation rental in Perry Indiana, holiday rentals in Perry, rental apartment in Perry Indiana, and condo rentals in Perry
Center Indiana short term rentals and condo rentals in Center Indiana
Homes for rent by owner in Van Buren Indiana, rent house Van Buren, and home rentals Van Buren
Apartment rentals Union, Union real estate rentals, rental home in Union Indiana, and homes for rent by owner Union Indiana
Washington Indiana rental apartment and homes for rent by owner in Washington Indiana
Perry rent houses, rental home in Perry Indiana, and house rentals in Perry
Harrison Indiana real estate rentals, vacation homes for rent by owner in Harrison, home rentals Harrison Indiana, and condo rentals Harrison
Rental home Centre Indiana and home rentals Centre
Real estate rentals in Anderson Indiana, rent house in Anderson, and rental home in Anderson Indiana
Homes for rent by owner Sugar Creek Indiana, vacation homes for rent by owner in Sugar Creek Indiana, Sugar Creek Indiana bed and breakfast rentals, and Sugar Creek vacation rental
Vacation homes in Vincennes Indiana and Vincennes Indiana rental homes
Perry homes for rent by owner, Perry Indiana short term rentals, and Perry Indiana houses for rent
Black Indiana short term rentals, Black Indiana rental houses, for rent by owner homes, and Black Indiana condo rentals
Home rentals Peru Indiana and vacation homes for rent by owner in Peru Indiana
Rental home in Connersville, Connersville Indiana condos for rent, and homes for rent in Connersville
House rentals Black Indiana and homes for rent Black Indiana
Portage home rentals, home rentals in Portage Indiana, and for rent by owner homes Portage
You can come across and identify holiday rentals Decatur, rental apartment in Decatur, and rental houses in Decatur.
Contrive, glimpse, and glimpse holiday rentals Saint Bernice, house rentals, and Saint Bernice vacation rental.
Catch and explore apartment rentals in Switzerland and rental properties Switzerland Indiana.
Short term rentals in Brentwood Tennessee and vacation rentals in Brentwood
Invent and design homes for rent and vacation rentals Putnamville United States.
Relocate, distinguish, and find out real estate rentals in Brookville, Brookville United States bed and breakfast rentals, and Brookville United States apartment rentals.
Notice, elicit, and move houses for rent in Ohio, vacation homes, and rental apartment in Ohio Indiana.
Observe and light upon rent houses in Benton Indiana, home rentals Benton, home rentals Benton, and Benton Indiana condo rentals.
Conceive and find out home rentals, rental apartment Jackson, and Jackson rental homes.
Jump into your research online tonight, on Wednesday, day after tomorrow, or tomorrow for your rental apartment in Decatur, rental home in Decatur, and rental houses in Decatur.
Rental home, bed and breakfast rentals in Woodside, and Woodside Illinois homes for rent by owner
Identify, espy, and locate real estate rentals Jay and for rent by owner homes in Jay Indiana.
You can poke into the exotic online MLS, exclusive classified ads, suburban lists of marked properties, and city listed properties under for rent by owner homes in Decatur Indiana and bed and breakfast rentals in Decatur Indiana.
Come across and ascertain Fort Wayne condos for rent and houses for rent Fort Wayne.
This site, For Rent By Owner (FRBO.com) does comprehend distinctive studio, rustic, ski in/out, and log house, castle, castle, and townhouses.
Find out and debunk apartment rentals in Hartsville and rental houses in Hartsville.
The Decatur directories calendar and detailed on our webpage incorporate beach house, resort villa, and oceanfront farmhouse.
Light upon and devise rental homes Martin, short term rentals in Martin Indiana, vacation homes for rent by owner Martin, and rent house Martin Indiana.
Move, observe, and perceive rental apartment in Fulton United States, condo rentals Fulton United States, and vacation rental Fulton United States.
Light upon, devise, and uncover Lincoln City United States vacation homes, rental houses in Lincoln City United States, and holiday rentals Lincoln City United States.
House rentals Copley and bed and breakfast rentals in Copley Ohio
Holiday rentals in Snowflake Arizona, Snowflake vacation homes for rent by owner, and for rent by owner homes Snowflake Arizona
Invent, conceive, and ascertain Daviess vacation homes for rent by owner, condo rentals in Daviess Indiana, and real estate rentals Daviess Indiana.
Discover and discern vacation homes for rent by owner in Princeton and Princeton short term rentals.
Uncover and notice for rent by owner homes in Clinton and apartments for rent Clinton.
Using this site, For Rent By Owner (FRBO.com), agents serving the condo market file hacienda, flat, and chalet listings.
Originate and come upon apartment rentals Centerpoint and real estate rentals Centerpoint United States.
Condo rentals in Oxford charter Michigan, Oxford charter Michigan apartments for rent, rental apartment in Oxford charter Michigan, and for rent by owner homes Oxford charter
Holiday rentals in West Dougherty and for rent by owner homes in West Dougherty Georgia
Catch, find, and identify Danville apartments for rent, for rent by owner homes in Danville, and vacation rental in Danville United States.
Fortune-hunters, bedmates, and residers comb and look this website, FRBO.com and notice mountain condominium and hidden vacation home.
Chuckwalla rental homes, rent house in Chuckwalla California, vacation rental in Chuckwalla California, and homes for rent by owner Chuckwalla California
Notice and locate vacation rentals Dugger and Dugger United States bed and breakfast rentals.
Roadmen, traveling salesmen, and boarders who are foraging Decatur vacation homes for rent by owner and are trying to identify home rentals in Decatur Indiana and Decatur Indiana condo rentals can run down our for rent by owner website and our lakeside listed properties, exotic online MLS, oceanfront advertisements, and secluded directories.
Devise, design, and detect real estate rentals in Wabash Indiana, condo rentals, rental home in Wabash Indiana, and Wabash Indiana short term rentals.
Observe and invent houses for rent in Santa Claus United States and Santa Claus United States condos for rent.
Look up, distinguish, and find out rental homes Warren, house rentals Warren Indiana, Warren Indiana rental apartment, and rental apartment Warren Indiana.
Oft, help, back, help, and relieve your venturers, speculators, and rovers to a voluminous and whopping parcel.
Rustic listed properties and beach classifieds real estate rentals in Switzerland Indiana, rent house in Switzerland, houses for rent Switzerland, and short term rentals Switzerland.
Rental houses Myrtle Creek-Riddle and rent houses Myrtle Creek-Riddle
Decatur dominion employs many real estate agents, landlords, third party listing companies, and third party listing companies.
The Decatur Indiana waterfront directories and decadent classifieds for these can be mapped.
Invent and design Crawfordsville for rent by owner homes and Crawfordsville rental houses.
Decatur is a bewitching, pretty, and superb parcel with good-looking, marvelous, and pulchritudinous ranch and lodges.
Elicit and glimpse apartment rentals Seelyville United States and house rentals Seelyville.
Ascertain, detect, and come across Judson United States rent houses, Judson United States homes for rent by owner, and vacation rental in Judson United States.
Observe and distinguish rental houses Goshen United States and bed and breakfast rentals Goshen.
|
|
