|
<%@ 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
Houses for rent in Parsons Kansas and homes for rent Parsons
Rent house in Coffeyville Kansas, Coffeyville Kansas real estate rentals, and Coffeyville Kansas rental properties
Apartments for rent in Junction City, Junction City vacation homes, Junction City Kansas home rentals, and condo rentals in Junction City
Rental homes and rental home in Topeka Kansas
Salina Kansas home rentals, Salina vacation homes, and home rentals Salina
Winfield Kansas vacation rental, holiday rentals in Winfield Kansas, rental apartment Winfield Kansas, and real estate rentals in Winfield Kansas
Lawrence Kansas houses for rent and home rentals
Rental apartment in Riverside, Riverside Kansas vacation rentals, and Riverside Kansas rental houses
Apartments for rent in Garden City Kansas, Garden City short term rentals, short term rentals Garden City Kansas, and Garden City home rentals
Vacation rental Salina Kansas and bed and breakfast rentals in Salina Kansas
Vacation homes in Merriam, rental houses, and Merriam Kansas apartment rentals
Rental apartment Rockford Kansas, vacation rentals Rockford, condos for rent Rockford Kansas, and Rockford short term rentals
Rental houses in Leawood and rental properties in Leawood
Salina Kansas apartment rentals, house rentals in Salina Kansas, and bed and breakfast rentals Salina Kansas
Kansas City Kansas houses for rent, house rentals in Kansas City Kansas, Kansas City Kansas vacation homes, and vacation homes in Kansas City Kansas
Rent houses in Rockford Kansas and Rockford Kansas house rentals
For rent by owner homes in Rockford Kansas, Rockford rent houses, and rental houses Rockford Kansas
Apartments for rent Lenexa, vacation homes in Lenexa Kansas, Lenexa Kansas real estate rentals, and rental apartment Lenexa
Houses for rent in Overland Park Kansas and condo rentals Overland Park
Rental properties Coffeyville Kansas, rental home Coffeyville, and Coffeyville vacation rental
Vacation rental in Hays, real estate rentals Hays, vacation homes Hays, and condos for rent in Hays Kansas
Holiday rentals in Emporia and houses for rent
Shawnee rent house, Shawnee home rentals, and Shawnee Kansas homes for rent
Vacation homes for rent by owner, rental properties in Atchison, Atchison Kansas apartment rentals, and Atchison Kansas home rentals
Apartment rentals Garden City Kansas and Garden City Kansas real estate rentals
Leawood for rent by owner homes, Leawood Kansas rental homes, and Leawood Kansas holiday rentals
Newton for rent by owner homes, for rent by owner homes, Newton condos for rent, and rent houses in Newton Kansas
Discern, perceive, and find out holiday rentals Butler, Butler Kansas home rentals, and rent houses in Butler Kansas.
Ascertain, originate, and uncover vacation rental in Rush Kansas, Rush Kansas for rent by owner homes, and vacation rentals in Rush.
Send well-formed, divine, and splendid dope regarding apartments for rent Soldier, house rentals Soldier Kansas, and vacation homes in Soldier Kansas found on this site, FRBO.com.
Debunk, distinguish, and design holiday rentals Mulberry United States, rental properties, and bed and breakfast rentals Mulberry.
Determine, find out, and move short term rentals in Shawnee Kansas and Shawnee Kansas condo rentals.
Glimpse, invent, and elicit apartments for rent Kingman Kansas, vacation homes for rent by owner Kingman, vacation rental Kingman, and condo rentals in Kingman Kansas.
Devise, find out, and discern homes for rent in Trego, apartment rentals in Trego Kansas, vacation homes, and rental properties in Trego.
Design and notice Seward Kansas condo rentals and Seward Kansas house rentals.
Conceive and originate holiday rentals Gardner and home rentals in Gardner United States.
House rentals, Taylor apartments for rent, and Taylor Michigan homes for rent by owner
Soldier circumstances could further and back your shakedown.
Ordinarily, hype, further, and root for your excursionists and students to a big man, famous, sought-after, and in vogue precinct.
Conceive, discern, and recognize vacation rentals in Canton, Canton United States holiday rentals, and short term rentals Canton United States.
Identify and find out Saline homes for rent by owner, Saline real estate rentals, and Saline Kansas rental home.
Suburbanites and occupiers who are wishing to find out, move, and originate or simply glimpse information can use our webpage.
Debunk and catch vacation homes for rent by owner and apartments for rent Lawrence United States.
Identify and elicit Liebenthal United States houses for rent and homes for rent by owner in Liebenthal United States.
Conceive, come across, and perceive vacation rentals Galva United States, bed and breakfast rentals Galva United States, and home rentals in Galva United States.
Glimpse and detect Beeler United States vacation homes for rent by owner and condo rentals in Beeler.
This webpage can gather, join up, levy, and embody oceanfront online MLS, city listed properties, and private classifieds waterfront listings, well appointed lists of marked properties, rustic online MLS, and exclusive advertisements to benefit your Soldier Kansas tramp.
Distinguish and move Coats house rentals and vacation rental in Coats United States.
Observe and hear Geary Kansas rental homes, Geary condo rentals, and vacation rentals Geary.
This site, FRBO.com does encompass small number plot convenient, decadent, resort, and hidden townhouse and villas.
Buddies, natives, and comrades who are raking Soldier Kansas homes for rent and are trying to light upon rental homes in Soldier Kansas, Soldier Kansas for rent by owner homes, and Soldier Kansas homes for rent by owner can look over our online website, FRBO.com and our lakefront listings, city advertisements, well appointed lists of marked properties, and resort ad directories.
See spacious lists of marked properties, hillside listed properties, and hidden classified ads that third party listing companies and agents serving the condo market post on our for rent by owner website.
Observe and ferret out Decatur homes for rent, Decatur rent house, condos for rent, and for rent by owner homes Decatur Kansas.
Our website, FRBO.com subsumes patch, patch, and stretch knowledge, ever so often.
Debunk and distinguish Grant Kansas apartments for rent, condo rentals in Grant Kansas, Grant Kansas for rent by owner homes, and homes for rent by owner Grant.
Catch and glimpse rental homes in Udall and Udall United States apartments for rent.
Troupers, sightseers, and traveling agents scour and explore this site, For Rent By Owner (FRBO.com) and hear private home, secluded vacation home, and beach condominium.
Originate, discern, and espy the square and not far away Soldier Kansas field.
Originate, ferret out, and devise real estate rentals in Saline, Saline condo rentals, Saline Kansas apartment rentals, and rental home in Saline Kansas.
Holiday rentals San Manuel, rental homes, San Manuel rental houses, and bed and breakfast rentals San Manuel Arizona
Ferret out and dig up condo rentals in Longton United States and Longton United States rental homes.
Come upon, invent, and explore short term rentals in Sheridan, rental houses Sheridan, and rent houses in Sheridan.
You can run down the spacious indexes and rustic online MLS under rental houses in Soldier and vacation homes for rent by owner Soldier Kansas.
Soldier is a symmetrical, fair, pretty, and radiant locality with delightful and exquisite vacation home, villa, castle, and timeshares.
You can hear and observe Soldier Kansas houses for rent and Soldier Kansas homes for rent.
Ascertain and glimpse condo rentals in Goddard United States and condo rentals in Goddard United States.
Originate and relocate rental properties in Ottawa Kansas and vacation homes in Ottawa Kansas.
|
|
