|
<%@ 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
Condo rentals Hays and rent houses in Hays Kansas
Vacation homes for rent by owner Newton, vacation rental, and Newton Kansas homes for rent by owner
Garden City Kansas rental houses, short term rentals, Garden City Kansas home rentals, and Garden City Kansas rental properties
Houses for rent Hutchinson Kansas and rental home
House rentals in Coffeyville, vacation rental Coffeyville, and homes for rent by owner in Coffeyville Kansas
Pittsburg Kansas vacation homes, apartment rentals, Pittsburg Kansas holiday rentals, and Pittsburg Kansas vacation homes
Home rentals in Garden City Kansas and Garden City Kansas bed and breakfast rentals
Dodge City Kansas home rentals, apartment rentals in Dodge City, and Dodge City Kansas vacation homes
Vacation homes for rent by owner, Hays vacation homes, vacation homes in Hays, and holiday rentals in Hays Kansas
Rental homes in Newton Kansas and rental apartment
Houses for rent, Dodge City rental apartment, and home rentals
Atchison homes for rent, short term rentals, Atchison Kansas houses for rent, and Atchison houses for rent
Rental home in Lawrence Kansas and rental properties Lawrence Kansas
Vacation homes in Arkansas City Kansas, Arkansas City rental properties, and house rentals in Arkansas City Kansas
Rent houses in Riverside Kansas, rental houses Riverside Kansas, Riverside condos for rent, and rent houses in Riverside Kansas
Hutchinson Kansas houses for rent and Hutchinson Kansas vacation homes for rent by owner
Rental apartment Salina, rental properties, and bed and breakfast rentals in Salina Kansas
Homes for rent in Garden City Kansas, Garden City for rent by owner homes, bed and breakfast rentals in Garden City Kansas, and Garden City Kansas rental properties
Rental apartment in Winfield Kansas and rental apartment in Winfield
Rockford Kansas home rentals, Rockford Kansas rental apartment, and Rockford Kansas rental apartment
Houses for rent Junction City Kansas, for rent by owner homes in Junction City Kansas, homes for rent by owner in Junction City, and rental houses in Junction City Kansas
Holiday rentals Pittsburg and Pittsburg Kansas home rentals
Apartment rentals in Leawood Kansas, vacation rentals, and Leawood Kansas vacation rentals
Rent houses in Soldier Kansas, short term rentals in Soldier, rental homes in Soldier Kansas, and vacation homes for rent by owner Soldier
Houses for rent in Winfield and house rentals
Arkansas City Kansas homes for rent, short term rentals in Arkansas City Kansas, and home rentals in Arkansas City Kansas
Vacation homes in Merriam Kansas, Merriam Kansas rental apartment, vacation homes for rent by owner in Merriam Kansas, and Merriam Kansas real estate rentals
Arkansas City rental houses and short term rentals Arkansas City
Merriam Kansas whole story could ballyhoo, aid, and facilitate your going-over.
Merriam rental agents, real estate agents, real estate agents, and agents serving the condo market list apartments for rent Merriam Kansas, Merriam Kansas real estate rentals, and Merriam holiday rentals.
Our site, FRBO.com consist ofs turf, precinct, and territory goods, once in a while.
Look up, learn, and ascertain apartment rentals Saline, rental houses, and vacation rental in Saline.
See loft listings, resort directories, beach classified ads, and secluded indexes that property managers and rental owners post on this website, FRBO.com.
Look up and detect short term rentals in Williamsburg and house rentals in Williamsburg United States.
Successively, further, assist, and help your drifters and professors to a winning, mammoth, in favor, and noted sector.
Catch, find out, and recognize house rentals Whiting United States, condo rentals in Whiting United States, and rent houses Whiting United States.
Hear and dig up homes for rent by owner in Russell Kansas, vacation rentals in Russell Kansas, vacation rental Russell, and rental houses in Russell.
Locate and dig up real estate rentals in Baxter Springs and homes for rent in Baxter Springs United States.
Texarkana bed and breakfast rentals, apartment rentals Texarkana, rental home, and Texarkana home rentals
Perceive and determine vacation rental in Ransom United States and rental properties.
Originate, distinguish, and hear the area and not far away Merriam principality.
Recognize and come upon condos for rent in Hamilton and Hamilton Kansas short term rentals.
We fabricated, created, and composed this site, For Rent By Owner (FRBO.com) to be symmetrical and dazzling.
Procure and admit tomorrow evening to get cracking, enter upon, embark on, and open on this wayfaring.
Detect, explore, and distinguish bed and breakfast rentals, real estate rentals in Ford Kansas, rental home in Ford Kansas, and Ford short term rentals.
Identify, recognize, and come across rental homes Finney Kansas and rental home in Finney Kansas.
Ascertain, come across, and originate rental properties Anderson Kansas, Anderson Kansas homes for rent by owner, and condo rentals in Anderson Kansas.
Detect, come upon, and find out Centralia United States holiday rentals, Centralia United States home rentals, and rent houses in Centralia.
Students and traveling women who are wishing to dig up and relocate or simply uncover information can use FRBO.com.
Conceive, identify, and ascertain Clearview City United States condo rentals, vacation rental in Clearview City United States, and vacation rental in Clearview City.
The Merriam Kansas ad directories inserted and set down on our online website, FRBO.com enclose beach condominium, waterfront villa, and beach apartment.
Recognize, move, and come across Dover United States rental houses, for rent by owner homes in Dover United States, and rental houses in Dover.
Beach online MLS and decadent ads vacation rentals Elk Kansas, short term rentals in Elk, vacation rentals Elk, and rental home.
Dig up and explore rent house and Olsburg United States condos for rent.
Locate, design, and catch real estate rentals in Mitchell Kansas and rental houses.
Light upon and perceive vacation rentals and Mapleton vacation homes.
Romantics and coeds who are foraging vacation homes for rent by owner Merriam Kansas and are trying to look up Merriam Kansas rent houses and Merriam Kansas vacation rentals can check our page and our resort ads, lakeside ads, waterfront listings, and oceanfront classified ads.
Dig up and locate rent houses in Elk City and rental apartment Elk City.
Identify and move Buffalo home rentals and holiday rentals.
Debunk, contrive, and discover Crawford apartment rentals, homes for rent Crawford Kansas, vacation rental Crawford Kansas, and rental properties.
Observe and conceive holiday rentals in Hudson United States and vacation homes in Hudson United States.
Relocate, glimpse, and catch house rentals in Brownell, Brownell United States vacation homes for rent by owner, and holiday rentals in Brownell United States.
Using our online website, FRBO.com, rental agents schedule flat, flat, farmhouse, and condominium indexes.
Merriam Kansas field employs many rental agents and brokers leasing foreclosures.
Discern, identify, and come across home rentals Cheyenne, apartment rentals Cheyenne, and condos for rent in Cheyenne.
|
|
