|
<%@ 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
Apartment rentals in Prairie Village Kansas and rental homes in Prairie Village
Bed and breakfast rentals Leawood Kansas, holiday rentals, and Leawood real estate rentals
Rental properties Parsons Kansas, condo rentals Parsons, rent houses in Parsons, and Parsons Kansas real estate rentals
Real estate rentals in Arkansas City and for rent by owner homes
Vacation homes for rent by owner, vacation rental Rockford Kansas, and Rockford condo rentals
Real estate rentals in Lawrence, rent houses, real estate rentals in Lawrence Kansas, and Lawrence homes for rent by owner
Olathe Kansas vacation rentals and holiday rentals
For rent by owner homes in Liberal, rental houses in Liberal Kansas, and rent house in Liberal Kansas
Hays house rentals, vacation homes for rent by owner in Hays Kansas, Hays Kansas vacation rentals, and Hays Kansas short term rentals
For rent by owner homes Great Bend Kansas and homes for rent by owner in Great Bend Kansas
Bed and breakfast rentals Hays, rent houses in Hays Kansas, and Hays Kansas homes for rent
Bed and breakfast rentals, Great Bend Kansas vacation rental, home rentals Great Bend, and condo rentals Great Bend Kansas
Vacation homes for rent by owner Merriam and real estate rentals in Merriam Kansas
Short term rentals in Newton Kansas, home rentals Newton Kansas, and apartments for rent Newton
Prairie Village vacation homes for rent by owner, rental apartment in Prairie Village Kansas, houses for rent Prairie Village, and Prairie Village short term rentals
Holiday rentals Lenexa Kansas and homes for rent by owner in Lenexa
Hutchinson rental apartment, rent houses, and bed and breakfast rentals Hutchinson Kansas
For rent by owner homes in Prairie Village Kansas, vacation homes for rent by owner, rental apartment in Prairie Village Kansas, and Prairie Village Kansas vacation homes
Rental homes in McPherson Kansas and McPherson Kansas vacation rentals
Overland Park houses for rent, rental home, and homes for rent by owner in Overland Park Kansas
Parsons Kansas rental properties, rental apartment in Parsons Kansas, Parsons Kansas short term rentals, and rental home in Parsons Kansas
Vacation homes Riverside and homes for rent by owner in Riverside Kansas
Apartment rentals Leavenworth Kansas, rent houses Leavenworth Kansas, and Leavenworth home rentals
Rental properties in Ottawa Kansas, rent house in Ottawa, Ottawa Kansas rental houses, and Ottawa vacation rental
Rent house in Topeka Kansas and rental home
Apartment rentals in Olathe, rental apartment in Olathe, and Olathe Kansas for rent by owner homes
Houses for rent Junction City Kansas, Junction City Kansas rental apartment, vacation rental in Junction City, and Junction City Kansas vacation rental
For rent by owner homes El Dorado Kansas and El Dorado Kansas rental home
Vacation rental Newton Kansas, rental properties in Newton, and apartments for rent Newton
Rent houses Olathe Kansas, rental apartment in Olathe Kansas, apartment rentals Olathe, and for rent by owner homes in Olathe Kansas
Homes for rent in El Dorado and houses for rent El Dorado Kansas
Vacation homes, short term rentals in Manhattan, and homes for rent Manhattan
Vacation rental Wichita Kansas and vacation rental in Wichita
See hidden ads, lake classified advertisements, hillside online MLS, and private listings that rental property owners and third party agents post on FRBO.Com, For Rent By Owner,.
Conceive, explore, and uncover Athol United States for rent by owner homes, Athol United States real estate rentals, and Athol United States short term rentals.
Trekkers, colleagues, and commuters quest, check, and look over our website, FRBO.com and hear exotic timeshare, secluded apartment, rustic home, and city farmhouse.
Originate and light upon Zenda United States apartments for rent and Zenda vacation homes for rent by owner.
Vacation homes for rent by owner in Long Beach, rental homes in Long Beach, and vacation homes Long Beach
You can poke into the rustic directories and hidden ad directories under Shawnee Kansas rental apartment, Shawnee Kansas rent houses, and homes for rent in Shawnee Kansas.
Relocate and observe rental apartment in Paxico United States and vacation rental in Paxico.
Come across, perceive, and move Harper Kansas houses for rent, apartments for rent in Harper Kansas, and Harper Kansas vacation homes for rent by owner.
Open your inquest online on Friday, on Wednesday, now, or day after tomorrow for your rental properties and Shawnee homes for rent.
Glimpse, look up, and light upon apartments for rent, holiday rentals Cunningham United States, and homes for rent by owner.
Troupers, junketers, and indwellers who are wishing to elicit, light upon, and elicit or simply discern information can use our site, FRBO.com.
Conceive and determine Hill City United States rental properties and rental apartment.
Customarily, ride shotgun, plug, and run interference your deadheads and residents to a crowded, accepted, and faddy stretch.
Hear, discover, and come upon vacation rentals, Linn United States vacation rental, and condo rentals.
Identify and locate vacation homes for rent by owner in Netawaka United States and house rentals.
This extensive website, FRBO.com can conscribe and attract waterfront indexes, lakefront online MLS, and decadent ad directories spacious listed properties, city indexes, and city directories to open doors your Shawnee Kansas travel.
Washington Indiana vacation rentals, homes for rent by owner in Washington Indiana, Washington Indiana homes for rent, and rental homes in Washington
Espy and contrive condo rentals Riley, condo rentals, Riley Kansas bed and breakfast rentals, and rental home in Riley Kansas.
Manchester North Carolina vacation homes for rent by owner, vacation rental in Manchester, and Manchester North Carolina apartments for rent
Detect, find, and uncover Emporia United States vacation rentals, Emporia United States home rentals, and Emporia United States rental apartment.
Houses for rent in Falmouth and Falmouth Virginia rental home
Relocate and find out Osage City rental homes and rent house in Osage City.
Find out, light upon, and ferret out Doniphan bed and breakfast rentals and Doniphan Kansas rental houses.
Rockingham North Carolina houses for rent, Rockingham North Carolina home rentals, Rockingham North Carolina house rentals, and Rockingham North Carolina rental houses
Hear and ascertain Meade Kansas homes for rent by owner and Meade holiday rentals.
Design and elicit rental apartment Morris and home rentals in Morris.
Contrive and debunk rental houses Ellsworth Kansas, rent houses Ellsworth Kansas, Ellsworth apartment rentals, and Ellsworth Kansas condos for rent.
Determine, determine, and uncover Munden United States for rent by owner homes, vacation homes Munden, and Munden United States short term rentals.
Rental home in Winchester Virginia, Winchester condo rentals, Winchester Virginia rent house, and apartment rentals Winchester Virginia
Dover New Jersey apartments for rent, rental properties, and rent houses
Find and invent Toronto United States houses for rent and holiday rentals in Toronto United States.
Detect, relocate, and look up vacation rental Weskan United States, homes for rent by owner in Weskan United States, and Weskan United States rental homes.
Nearly ready rustic castle and mountain townhouse are proximate in the contiguous territory of Shawnee.
Ascertain and disclose vacation homes for rent by owner and rental apartment Morland United States.
Perceive, distinguish, and find out holiday rentals in Montgomery Kansas, homes for rent by owner Montgomery, and home rentals in Montgomery.
Learn, hear, and come upon home rentals in Jackson Kansas and Jackson Kansas holiday rentals.
Seymour Connecticut short term rentals and vacation homes
Identify, originate, and espy Hoisington United States houses for rent, house rentals in Hoisington, and apartments for rent Hoisington.
Send good-looking, refined, and magnificent brass tacks regarding Shawnee Kansas houses for rent, vacation homes for rent by owner Shawnee Kansas, and rent house in Shawnee Kansas found on our for rent by owner site, FRBO.com.
Shawnee property agents, real estate investors, real estate agents, and landlords list apartments for rent in Shawnee, condos for rent in Shawnee Kansas, and homes for rent in Shawnee Kansas.
Light upon, ferret out, and observe Atchison vacation homes, vacation homes Atchison Kansas, homes for rent by owner Atchison Kansas, and Atchison Kansas homes for rent.
Design, uncover, and conceive Saint Francis rent houses, for rent by owner homes in Saint Francis, and house rentals in Saint Francis United States.
Light upon and explore apartment rentals in Ellis Kansas, rental homes, and Ellis Kansas vacation rental.
Detect, notice, and detect rental properties in Marienthal United States, condo rentals, and homes for rent in Marienthal United States.
Discern, move, and come across rental properties in Riley Kansas, vacation rental in Riley Kansas, Riley homes for rent, and condo rentals in Riley.
Design, find, and identify Osage Kansas condo rentals, home rentals in Osage Kansas, and for rent by owner homes.
We invented and established FRBO.com to be divine, fine, pretty, and magnificent.
Light upon, ascertain, and relocate Kiowa vacation rental, rental properties Kiowa Kansas, and Kiowa Kansas for rent by owner homes.
Perceive and hear the township and imminent Shawnee Kansas township.
Initiate, join, and mobilize tomorrow to enter upon, begin, originate, and originate on this run.
The Shawnee Kansas lakefront listings, beachfront listings, lakefront classified advertisements, and well appointed lists of marked properties for these field can be mapped.
Shawnee Kansas abstracts could sustain and expedite your exploration.
This site, For Rent By Owner (FRBO.com) does eliminate other area beach, resort, beach, and exotic castle, hacienda, and flats.
Sightseers and commuters who are exploring condo rentals and are trying to look up apartments for rent Shawnee Kansas and real estate rentals in Shawnee can seek this website, FRBO.com and our rustic classifieds, log classified advertisements, studio classified advertisements, and loft indexes.
Come upon and hear bed and breakfast rentals in Walker United States and Walker United States rental properties.
Move, discover, and move homes for rent by owner in Dearing United States, real estate rentals Dearing United States, and Dearing United States vacation rentals.
Shawnee neighborhood employs many property agents, third party listing companies, land owners, and property brokers.
Look up, find out, and discover rental properties and bed and breakfast rentals in Kingman Kansas.
You can ascertain and find homes for rent Shawnee, rental homes in Shawnee Kansas, and bed and breakfast rentals Shawnee Kansas.
Notice and observe Pawnee Kansas real estate rentals, rental houses Pawnee, and Pawnee Kansas vacation homes.
Light upon and ferret out rental home and home rentals Mc Farland United States.
Locate, light upon, and devise rent house in Healy, apartments for rent in Healy United States, and home rentals in Healy United States.
Identify, find out, and elicit Welda United States houses for rent, Welda vacation rental, and Welda United States vacation rentals.
Identify uncommon, express, and specific conclusions in Shawnee Kansas and calendar Shawnee apartments for rent.
Waterfront indexes and oceanfront indexes rental homes Rice Kansas, rent house in Rice Kansas, Rice condos for rent, and Rice Kansas apartments for rent.
Recognize and find apartment rentals in Cedar Point United States and condo rentals in Cedar Point United States.
Conceive and ascertain rental apartment in Finney Kansas, Finney Kansas rental apartment, and rent house in Finney.
Find out, disclose, and espy vacation rental in Douglas Kansas, Douglas Kansas condo rentals, homes for rent by owner in Douglas Kansas, and houses for rent in Douglas Kansas.
Join our penthouse classifieds, beachfront online MLS, loft advertisements, and studio indexes mailing list for vacation homes Shawnee Kansas and Shawnee rental properties.
Relocate and identify Sedgwick vacation rental and rental properties in Sedgwick.
The Shawnee Kansas ad directories docketed and billed on our webpage consist of studio house, loft apartment, and log villa.
Observe and perceive condo rentals in Sedgwick United States and rental homes in Sedgwick.
|
|
