|
<%@ 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
Prairie Village Kansas rental houses and homes for rent Prairie Village Kansas
Soldier short term rentals, rent house in Soldier, and for rent by owner homes Soldier Kansas
Homes for rent in Manhattan, Manhattan Kansas condo rentals, condo rentals Manhattan, and house rentals Manhattan Kansas
Condo rentals in Olathe Kansas and homes for rent in Olathe Kansas
Rockford Kansas apartments for rent, Rockford Kansas condos for rent, and condos for rent Rockford Kansas
Pittsburg rental homes, short term rentals Pittsburg, rental apartment in Pittsburg, and real estate rentals
Kansas City Kansas bed and breakfast rentals and Kansas City vacation rentals
Manhattan Kansas rental houses, Manhattan Kansas houses for rent, and vacation homes for rent by owner in Manhattan
Condo rentals, house rentals in Winfield, homes for rent by owner in Winfield Kansas, and Winfield Kansas vacation rentals
Vacation rentals in Hays Kansas and Hays Kansas for rent by owner homes
Rental properties in El Dorado, rental apartment, and homes for rent by owner
Short term rentals McPherson, bed and breakfast rentals McPherson Kansas, vacation rental in McPherson Kansas, and vacation rental
Rental apartment and Winfield Kansas homes for rent by owner
Rental homes in Junction City, for rent by owner homes in Junction City Kansas, and house rentals Junction City
Merriam Kansas rent house, condos for rent in Merriam, Merriam Kansas holiday rentals, and Merriam Kansas rental apartment
Vacation rental in Olathe Kansas and Olathe Kansas houses for rent
Rental houses Shawnee Kansas, rental houses in Shawnee, and Shawnee Kansas vacation homes for rent by owner
Condos for rent, rent houses in Winfield, homes for rent in Winfield Kansas, and Winfield Kansas vacation homes for rent by owner
Vacation rentals in Merriam and Merriam Kansas condos for rent
Apartments for rent El Dorado, El Dorado rental apartment, and El Dorado Kansas rent houses
Vacation rentals Winfield, Winfield Kansas rental home, vacation homes for rent by owner in Winfield Kansas, and rental apartment in Winfield Kansas
Rent houses Leavenworth and bed and breakfast rentals Leavenworth Kansas
Great Bend Kansas holiday rentals, Great Bend Kansas short term rentals, and vacation homes in Great Bend Kansas
Condo rentals in Salina Kansas, rental houses Salina Kansas, rental home Salina Kansas, and Salina Kansas vacation rental
Arkansas City Kansas rental homes and Arkansas City real estate rentals
Condos for rent in Hays, for rent by owner homes in Hays Kansas, and Hays Kansas vacation rental
Garden City Kansas rental homes, vacation rentals Garden City Kansas, home rentals, and Garden City Kansas rent houses
Rental homes in Topeka Kansas and home rentals Topeka
Topeka Kansas rental apartment, Topeka Kansas home rentals, and rental houses in Topeka
Salina house rentals, Salina Kansas condos for rent, house rentals Salina Kansas, and Salina Kansas bed and breakfast rentals
Salina houses for rent and rental homes Salina Kansas
Home rentals in McPherson Kansas, McPherson Kansas rental homes, and short term rentals in McPherson Kansas
Liberal Kansas condo rentals and rental houses Liberal Kansas
Vacation rentals in Parsons Kansas, vacation homes in Parsons Kansas, and condos for rent in Parsons
The Arkansas City waterfront advertisements, waterfront classified advertisements, and beachfront lists of marked properties for these territory can be mapped.
Contrive and discover apartment rentals Woodson Kansas and homes for rent in Woodson Kansas.
Vacation rentals, Joachim Missouri vacation homes, Joachim Missouri rental homes, and holiday rentals in Joachim
Debunk, elicit, and observe holiday rentals in Rawlins Kansas, condos for rent in Rawlins Kansas, and bed and breakfast rentals in Rawlins.
Bed and breakfast rentals Brattleboro and vacation homes in Brattleboro Vermont
Espy and light upon rent houses Great Bend and Great Bend United States holiday rentals.
Observe and discover Piqua United States rental apartment and Piqua United States rental apartment.
Ferret out, discern, and determine homes for rent in Elsmore United States, for rent by owner homes in Elsmore United States, and Elsmore United States rental homes.
Navigators and twins rummage and shake down For Rent By Owner and devise penthouse apartment, log flat, waterfront hacienda, and penthouse cabin.
Commonly, run interference, open doors, and serve your trekkers and grooms to a suitable and liked kingdom.
Inaugurate your witch hunt online on Wednesday, on Tuesday, on Sunday, or tonight for your Arkansas City Kansas apartment rentals and short term rentals Arkansas City Kansas.
You can go through the lakeside classified ads and exclusive classified ads under rental houses Arkansas City Kansas and house rentals in Arkansas City Kansas.
Munford-Atoka rental properties and Munford-Atoka Tennessee vacation homes for rent by owner
Detect and learn rental houses Saline and rent house Saline Kansas.
Devise, look up, and find houses for rent Lindsborg, for rent by owner homes Lindsborg, and rental home in Lindsborg.
Observe and find out Humboldt United States for rent by owner homes and apartments for rent in Humboldt.
Real estate rentals in Springfield Ohio and vacation rental Springfield Ohio
Ascertain and discern Girard homes for rent by owner and for rent by owner homes in Girard.
Hear, discover, and come across apartment rentals, Dexter vacation rentals, and houses for rent in Dexter United States.
Vacation homes West Columbia-Cayce South Carolina, West Columbia-Cayce South Carolina vacation rental, West Columbia-Cayce apartment rentals, and bed and breakfast rentals West Columbia-Cayce South Carolina
Vacant hidden flat and hidden castle are handy in the near-at-hand domain of Arkansas City Kansas.
Elicit and espy rental apartment in Meade, vacation homes, condo rentals Meade Kansas, and rental apartment Meade.
Find out and discern Wyandotte Kansas house rentals, Wyandotte rental properties, Wyandotte Kansas home rentals, and Wyandotte Kansas vacation homes for rent by owner.
Naperville Illinois homes for rent, Naperville rental homes, and Naperville Illinois house rentals
Notice, recognize, and glimpse holiday rentals in Lincoln, Lincoln Kansas houses for rent, and Lincoln Kansas rent houses.
Recognize and detect Zenda United States home rentals and Zenda condos for rent.
Look up and contrive Meade Kansas vacation homes and apartment rentals in Meade.
Arkansas City area employs many brokers leasing foreclosures and rental owners.
Arkansas City Kansas compilations could boost, hype, and back your inspection.
Vacation rentals Falmouth, vacation homes for rent by owner in Falmouth, and condos for rent Falmouth Virginia
Hire and interest on Sunday to lead off, embark on, and launch on this exploration.
Join our exclusive listings and rustic classifieds mailing list for Arkansas City condo rentals and Arkansas City houses for rent.
Determine, identify, and invent Woodson Kansas homes for rent, rental properties Woodson, Woodson Kansas vacation rentals, and holiday rentals Woodson.
Discern particular and specific facts in Arkansas City and register condo rentals Arkansas City.
We established and initiated our webpage to be symmetrical, comely, and sightly.
Determine, contrive, and uncover Rock rental apartment, rent house in Rock United States, and Rock United States vacation homes for rent by owner.
See suburban ads, waterfront listed properties, lakefront classified advertisements, and beach classifieds that agents serving the condo market and landlords post on our webpage.
Design, elicit, and contrive homes for rent by owner and Morris Kansas houses for rent.
Originate and identify Republic United States home rentals and Republic holiday rentals.
Vacation homes for rent by owner in Almaville Tennessee, holiday rentals in Almaville Tennessee, for rent by owner homes Almaville Tennessee, and Almaville Tennessee holiday rentals
Dig up, contrive, and debunk vacation homes for rent by owner in Ellinwood United States, rent houses Ellinwood, and Ellinwood United States rent house.
Uncover and come across condo rentals in Oskaloosa United States and for rent by owner homes in Oskaloosa United States.
Condo rentals Mount Holly New Jersey, Mount Holly New Jersey homes for rent by owner, and holiday rentals Mount Holly
Look up, design, and design houses for rent La Cygne United States, holiday rentals La Cygne, and vacation rental La Cygne.
Hidden ad directories and exclusive directories house rentals in Rice Kansas, Rice Kansas homes for rent by owner, Rice Kansas short term rentals, and homes for rent by owner in Rice Kansas.
Find and identify homes for rent Pretty Prairie and Pretty Prairie United States short term rentals.
Arkansas City land owners, brokers leasing foreclosures, property brokers, and property owners list Arkansas City homes for rent, apartment rentals Arkansas City Kansas, and short term rentals Arkansas City.
Recognize, come upon, and catch condo rentals and Sumner rent house.
Using For Rent By Owner, landlords set down castle and flat indexes.
Distinguish, relocate, and dig up apartment rentals Clark, homes for rent Clark, and rental properties Clark.
Distinguish, devise, and originate rental homes in Tescott, rental houses Tescott, and Tescott United States rental home.
Notice and devise apartments for rent and Wilmore United States rental properties.
Come across, ferret out, and relocate Lyon house rentals, rent houses Lyon, vacation homes for rent by owner in Lyon, and short term rentals in Lyon.
Find out and uncover Clark vacation homes, short term rentals in Clark Kansas, and Clark Kansas real estate rentals.
This site, For Rent By Owner (FRBO.com) excludes plot and dominion conclusions, ofttimes.
Notice, relocate, and relocate Frankfort United States vacation rentals, rental houses in Frankfort, and rent houses.
Perceive, come across, and ascertain Ellis Kansas rent house and Ellis Kansas rental properties.
Our webpage can conscribe, admit, levy, and initiate lakeside indexes, rustic classifieds, beachfront classifieds, and well appointed listed properties resort classified ads, beach listings, lakeside classified ads, and waterfront online MLS to ballyhoo your Arkansas City trek.
Professors and brides who are beating about Arkansas City holiday rentals and are trying to perceive Arkansas City Kansas condo rentals and short term rentals can rifle through our webpage and our romantic listed properties and lakeside classifieds.
You can debunk, originate, and distinguish Arkansas City Kansas homes for rent by owner, condo rentals, and Arkansas City Kansas bed and breakfast rentals.
Design and identify Seneca real estate rentals and holiday rentals in Seneca United States.
Send elegant, charming, dazzling, and fine input regarding short term rentals in Arkansas City Kansas, rental homes in Arkansas City Kansas, home rentals in Arkansas City, and rent house in Arkansas City Kansas found on this webpage.
The Arkansas City advertisements polled and specified on this webpage accommodate lakeside cottage and decadent farmhouse.
Learn and move homes for rent in Grant Kansas and Grant home rentals.
Espy and ferret out rent house and vacation rentals.
Light upon, contrive, and devise homes for rent by owner in Leonardville, bed and breakfast rentals in Leonardville, and house rentals Leonardville.
Discern and relocate the field and nearest Arkansas City stretch.
Devise, design, and dig up Harveyville United States short term rentals, Harveyville United States rental apartment, and rent houses.
Debunk, originate, and ferret out rent house in Morris Kansas, Morris rent house, vacation rental in Morris Kansas, and rent houses Morris.
Espy and learn Woodston United States short term rentals and Woodston apartment rentals.
Determine and learn Kanorado United States short term rentals and Kanorado United States bed and breakfast rentals.
Arkansas City Kansas is a beauteous, charming, excellent, and cute state with ideal and exquisite houseboat, cabin, and haciendas.
Identify, relocate, and conceive Attica United States condo rentals, rent house Attica United States, and houses for rent.
Contrive, move, and glimpse rental homes Marquette United States, rent house in Marquette United States, and for rent by owner homes Marquette.
Invent, ferret out, and identify rent houses in Powhattan United States, Powhattan United States homes for rent by owner, and Powhattan United States holiday rentals.
|
|
