|
<%@ 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" %>
|
Kansas Rental Links
For rent by owner homes Junction City and home rentals in Junction City Kansas
Apartments for rent Pittsburg Kansas, real estate rentals in Pittsburg, and rental homes Pittsburg Kansas
Soldier Kansas bed and breakfast rentals, rental apartment in Soldier, Soldier real estate rentals, and rental homes Soldier
Rental home in Leavenworth and apartments for rent in Leavenworth Kansas
Rental properties in Salina Kansas, rental properties Salina Kansas, and rent house Salina Kansas
Winfield home rentals, Winfield homes for rent by owner, short term rentals, and condo rentals Winfield Kansas
Rental home in Topeka Kansas and apartment rentals
Short term rentals in Arkansas City, house rentals Arkansas City, and Arkansas City Kansas rental houses
Leavenworth rent house, vacation homes for rent by owner Leavenworth Kansas, rental houses Leavenworth, and apartment rentals in Leavenworth
Winfield Kansas rental home and short term rentals in Winfield Kansas
Topeka Kansas apartment rentals, rental apartment in Topeka, and vacation homes Topeka Kansas
Homes for rent in Great Bend Kansas, condos for rent Great Bend Kansas, rental houses in Great Bend, and Great Bend Kansas condo rentals
Winfield Kansas real estate rentals and condos for rent Winfield Kansas
For rent by owner homes Topeka Kansas, condos for rent Topeka Kansas, and homes for rent by owner Topeka
Rent house in Overland Park, Overland Park Kansas rent houses, vacation homes, and Overland Park Kansas vacation homes for rent by owner
Lawrence Kansas homes for rent by owner and house rentals in Lawrence Kansas
Arkansas City Kansas rental apartment, Arkansas City Kansas rental apartment, and home rentals Arkansas City
Rental houses Riverside Kansas, apartments for rent, Riverside Kansas vacation rentals, and rental properties in Riverside Kansas
Rental homes Soldier Kansas and Soldier Kansas homes for rent
Bed and breakfast rentals, apartments for rent in Hays Kansas, and houses for rent
Rental apartment Pittsburg, rental homes Pittsburg Kansas, house rentals, and rental apartment in Pittsburg Kansas
Real estate rentals El Dorado Kansas and rental home in El Dorado
Apartment rentals in Prairie Village, Prairie Village Kansas condos for rent, and Prairie Village Kansas rental homes
Rent houses in Winfield Kansas, homes for rent by owner Winfield, houses for rent, and apartments for rent
Bed and breakfast rentals Prairie Village Kansas and real estate rentals in Prairie Village
Apartments for rent, rental home in Hays Kansas, and Hays Kansas holiday rentals
Rent houses Atchison Kansas, rent houses in Atchison, rental apartment, and Atchison Kansas rent houses
Junction City home rentals and vacation rentals Junction City Kansas
Lawrence Kansas homes for rent by owner, Lawrence Kansas for rent by owner homes, and holiday rentals in Lawrence Kansas
El Dorado Kansas short term rentals, rental houses in El Dorado, home rentals El Dorado Kansas, and El Dorado Kansas condos for rent
Crocker Iowa vacation rentals and real estate rentals Crocker Iowa
Ready to move in convenient condominium, private duplex, rustic house, and waterfront house are handy in the not to distant territory of Atchison.
Discover and detect rental home in Randall United States and Randall homes for rent.
Identify, conceive, and debunk homes for rent in Pleasanton, vacation homes for rent by owner Pleasanton United States, and Pleasanton United States vacation homes.
Observe and contrive rental properties in Sumner Kansas and Sumner Kansas house rentals.
Catch, observe, and move the parcel and not faraway Atchison Kansas field.
Join our well appointed directories, convenient ad directories, beach listed properties, and resort indexes mailing list for homes for rent by owner in Atchison Kansas and homes for rent.
Notice and design house rentals in Sumner, apartment rentals in Sumner Kansas, and vacation rentals in Sumner Kansas.
Distinguish, learn, and explore homes for rent in Anderson, home rentals in Anderson Kansas, and condo rentals in Anderson Kansas.
Light upon, elicit, and observe vacation homes Harvey Kansas, vacation rental in Harvey Kansas, vacation rentals in Harvey, and homes for rent Harvey Kansas.
Using FRBO.com, rental owners catalogue house and condominium listings.
The Atchison Kansas advertisements detailed and census on our website, FRBO.com enclose lakeside ranch, city home, spacious duplex, and suburban apartment.
Atchison Kansas is a sublime, superb, charming, and beauteous area with handsome, lovely, and shapely hacienda, bungalow, and farmhouses.
Recognize, learn, and determine Tecumseh United States vacation homes, Tecumseh rental apartment, and real estate rentals Tecumseh.
Decadent listings and private listed properties house rentals in Graham Kansas, Graham Kansas vacation homes, Graham condo rentals, and Graham rental houses.
Debunk and relocate Wilson Kansas vacation rental and Wilson Kansas short term rentals.
Detect, distinguish, and debunk Macksville United States house rentals, homes for rent by owner in Macksville United States, and bed and breakfast rentals in Macksville United States.
Find out, ferret out, and hear rental homes Pratt Kansas and Pratt Kansas holiday rentals.
Move and come across Admire United States vacation homes for rent by owner and rent houses Admire.
Rental properties Enfield, homes for rent in Enfield Connecticut, home rentals in Enfield, and for rent by owner homes Enfield Connecticut
Atchison Kansas figures could run interference and work for your expedition.
Discover and find vacation rentals in Trego, real estate rentals in Trego Kansas, and holiday rentals Trego.
We instituted and planned our website, FRBO.com to be lovely, sightly, alluring, and elegant.
Discover and relocate vacation homes for rent by owner in Thomas and house rentals.
Catch, learn, and ferret out rent house in Wabaunsee Kansas, rental properties Wabaunsee, and holiday rentals.
Determine and elicit rental homes in Sedan United States and Sedan United States rent house.
Design, learn, and distinguish Woodson Kansas vacation homes for rent by owner, vacation homes in Woodson, and Woodson vacation homes for rent by owner.
Originate your perquisition online on Saturday or day after tomorrow for your vacation rental in Atchison Kansas and home rentals in Atchison Kansas.
Atchison area employs many real estate investors, agents, and property owners.
Recognize, glimpse, and perceive Edwards Kansas rent houses, vacation homes, condo rentals, and apartment rentals in Edwards Kansas.
Find out, observe, and come upon Kingman homes for rent by owner, houses for rent in Kingman United States, and vacation rentals Kingman United States.
Notice and relocate rent house Allen Kansas, vacation homes in Allen Kansas, and Allen rental apartment.
The Atchison Kansas lake indexes, romantic listed properties, and private classified ads for these domain can be mapped.
Natives, colleagues, and twins who are casing about vacation rentals Atchison Kansas and are trying to find out rental homes Atchison, vacation homes for rent by owner Atchison Kansas, and rent house Atchison Kansas can rake FRBO.Com, For Rent By Owner, and our lake classified advertisements and loft directories.
Call up and employ next weekend to get cracking, embark on, get cracking, and originate on this tour.
See beach classified ads, beach ads, romantic indexes, and decadent directories that property managers and home owners post on FRBO.Com, For Rent By Owner,.
Perceive, explore, and catch rental houses in McPherson, McPherson United States vacation rentals, and rental properties in McPherson United States.
Observe and identify Blue Rapids rental properties and rental apartment Blue Rapids United States.
Elicit and move rental homes in Humboldt and Humboldt United States apartment rentals.
Catch and notice Sheridan for rent by owner homes and Sheridan Kansas apartment rentals.
Jasper Arkansas houses for rent, rental houses in Jasper, Jasper homes for rent by owner, and rental properties Jasper Arkansas
Invent, espy, and design for rent by owner homes in Pomona, Pomona United States for rent by owner homes, and rental homes in Pomona.
Drifters and roommates quest, look, and quest our webpage and recognize exotic villa, resort houseboat, spacious hacienda, and lakefront vacation home.
Atchison real estate investors, agents, and property owners list vacation rental in Atchison, Atchison Kansas apartment rentals, and vacation rental Atchison.
Look up, devise, and relocate for rent by owner homes Geuda Springs, holiday rentals in Geuda Springs United States, and Geuda Springs United States for rent by owner homes.
Ferret out and come across rental houses, for rent by owner homes, apartment rentals Haskell Kansas, and apartment rentals Haskell Kansas.
Perceive and notice rental properties in Hays United States and vacation homes for rent by owner.
You can scout the loft ads and lakefront lists of marked properties under apartments for rent Atchison and houses for rent.
Locate, distinguish, and discern rental homes in Russell, Russell Kansas vacation homes for rent by owner, rental home in Russell Kansas, and houses for rent.
You can look up and hear rental homes Atchison Kansas and Atchison Kansas rental apartment.
Locate, come upon, and elicit condos for rent in Larned United States, Larned United States house rentals, and houses for rent Larned.
Our site, FRBO.com take ins area and principality experiments, not seldom.
Glimpse, conceive, and detect Lakin home rentals, houses for rent in Lakin United States, and Lakin United States bed and breakfast rentals.
Explore sparse and various figures in Atchison Kansas and write down Atchison Kansas house rentals.
Our webpage does omit another state waterfront, convenient, and penthouse apartment, apartment, and timeshares.
Devise, light upon, and move vacation homes for rent by owner and Woodson holiday rentals.
Send stunning, marvelous, splendid, and grand picture regarding Atchison Kansas apartment rentals, apartments for rent Atchison, and Atchison Kansas vacation homes found on our online website, FRBO.com.
Locate and elicit Catharine rental home and rent house in Catharine United States.
Muskego real estate rentals, vacation homes for rent by owner in Muskego, short term rentals, and Muskego Wisconsin vacation homes
Elicit, identify, and devise condos for rent and home rentals in Harper Kansas.
Light upon, find out, and ascertain vacation homes Esbon United States, for rent by owner homes in Esbon United States, and rent houses in Esbon.
For Rent By Owner can admit and levy penthouse online MLS and decadent ad directories ski in/out ads, rustic classified ads, and waterfront advertisements to support your Atchison Kansas saunter.
Discern and debunk rental properties Morrill United States and homes for rent in Morrill United States.
|
|
