|
<%@ 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
Homes for rent in Salina Kansas and vacation rentals Salina Kansas
Rent houses in Atchison Kansas, Atchison real estate rentals, and Atchison Kansas rental home
Merriam short term rentals, Merriam Kansas homes for rent, rent houses in Merriam, and apartment rentals in Merriam
Apartment rentals Lawrence and rental home
Soldier rental properties, vacation homes Soldier, and rent house in Soldier Kansas
Condos for rent Soldier Kansas, vacation homes, real estate rentals in Soldier, and Soldier home rentals
Newton Kansas condo rentals and Newton Kansas rental properties
Holiday rentals Garden City, rent houses Garden City Kansas, and Garden City apartment rentals
Rockford Kansas bed and breakfast rentals, rent houses, Rockford Kansas home rentals, and houses for rent Rockford
Junction City rent house and Junction City homes for rent by owner
Rental home in Shawnee, rent house, and Shawnee Kansas homes for rent
Emporia Kansas rental properties, Emporia Kansas vacation rental, apartments for rent Emporia Kansas, and vacation homes Emporia
Liberal Kansas homes for rent and condos for rent Liberal Kansas
Vacation rental Arkansas City Kansas, Arkansas City Kansas rental apartment, and Arkansas City Kansas for rent by owner homes
Leawood Kansas rental homes, Leawood houses for rent, bed and breakfast rentals in Leawood, and rental homes in Leawood Kansas
We performed and coined FRBO.com to be elegant, pleasing, and fine.
Send divine and delicate compilations regarding rental home Wichita, rent house in Wichita Kansas, Wichita Kansas rental apartment, and Wichita Kansas rental properties found on this extensive website, FRBO.com.
Our webpage seats state, parcel, dominion, and block knowledge, sometimes.
Uncover sparse, extraordinary, unique, and original experiments in Wichita Kansas and file Wichita Kansas vacation homes.
Hear, find, and debunk real estate rentals, rental home in Plevna, and vacation rental Plevna.
See studio classifieds and penthouse listings that property owners and property managers post on this webpage.
Wichita Kansas knowledge could aid, help, and plug your investigation.
Originate and identify vacation homes for rent by owner Emmett and rent house Emmett United States.
Wichita real estate agents and land owners list condo rentals in Wichita Kansas and house rentals.
Glimpse and distinguish Clay Center United States houses for rent and homes for rent by owner in Clay Center United States.
Discover and recognize Rexford United States apartments for rent and Rexford United States rent house.
Find, distinguish, and dig up vacation homes Greeley, Greeley for rent by owner homes, and rent houses.
Fortune-hunters and habitants scour, chase after, and study FRBO.com and debunk romantic farmhouse, loft house, and lakeside duplex.
Devise and relocate rental homes Miami Kansas and Miami Kansas real estate rentals.
Recognize and look up Marshall vacation homes, Marshall Kansas home rentals, and vacation rental in Marshall.
You can study the oceanfront lists of marked properties, loft classified advertisements, beach ad directories, and penthouse ad directories under Wichita Kansas houses for rent and Wichita Kansas vacation rentals.
Get, get, and assign this evening to take up and enter upon on this voyage.
Identify and find out Silver Lake United States rental home and rental houses Silver Lake.
Identify, light upon, and explore Healy rental home, holiday rentals in Healy, and rent house in Healy United States.
The Wichita Kansas beach lists of marked properties, hillside indexes, hillside classifieds, and rustic classified advertisements for these can be mapped.
Glimpse and determine homes for rent by owner Morrill and Morrill United States bed and breakfast rentals.
Hear, come across, and light upon rental apartment Troy United States, vacation rentals in Troy, and home rentals Troy.
Move, find out, and look up Gorham vacation homes, rental houses Gorham, and home rentals in Gorham United States.
Catch, relocate, and debunk houses for rent Hamilton, vacation homes for rent by owner in Hamilton Kansas, vacation homes in Hamilton Kansas, and house rentals Hamilton.
Relocate and originate vacation rentals Sumner and for rent by owner homes in Sumner.
Hear, ascertain, and discover rent houses Mayfield United States, apartment rentals Mayfield United States, and holiday rentals in Mayfield.
Lakeside indexes and studio indexes Seward vacation rentals, Seward bed and breakfast rentals, rental properties in Seward Kansas, and condo rentals in Seward Kansas.
|
|
