|
<%@ 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
Rental houses Olathe and Olathe Kansas real estate rentals
Rental apartment Wichita Kansas, Wichita Kansas rent house, and rental home in Wichita Kansas
Soldier houses for rent, rental apartment, vacation rental in Soldier, and Soldier rental houses
House rentals Rockford Kansas and vacation homes in Rockford
Merriam vacation homes for rent by owner, rental properties Merriam, and Merriam Kansas rental home
Hutchinson rental homes, Hutchinson Kansas holiday rentals, Hutchinson real estate rentals, and Hutchinson apartment rentals
Vacation homes Great Bend and Great Bend Kansas rental apartment
Prairie Village condo rentals, Prairie Village apartments for rent, and apartments for rent in Prairie Village
Condo rentals in Merriam Kansas, vacation rentals in Merriam Kansas, rental homes in Merriam Kansas, and for rent by owner homes in Merriam Kansas
Apartments for rent Coffeyville and holiday rentals Coffeyville
Lenexa Kansas holiday rentals, Lenexa Kansas apartments for rent, and Lenexa vacation rentals
Homes for rent Hutchinson Kansas, Hutchinson Kansas rent houses, vacation homes for rent by owner in Hutchinson, and bed and breakfast rentals Hutchinson Kansas
Vacation rental Leawood Kansas and vacation rentals Leawood Kansas
El Dorado Kansas apartment rentals, El Dorado Kansas rental homes, and rental homes in El Dorado Kansas
Rental houses Emporia, rental home, real estate rentals in Emporia, and homes for rent by owner Emporia
Holiday rentals Topeka Kansas and Topeka vacation homes
Apartments for rent in Prairie Village, Prairie Village Kansas houses for rent, and vacation rentals
Arkansas City condo rentals, houses for rent in Arkansas City, Arkansas City Kansas homes for rent by owner, and Arkansas City rental homes
Homes for rent by owner Leawood Kansas and vacation homes for rent by owner in Leawood Kansas
Real estate rentals Ottawa Kansas, Ottawa Kansas house rentals, and condo rentals Ottawa Kansas
Merriam rent house, short term rentals in Merriam Kansas, rent house in Merriam Kansas, and condo rentals Merriam Kansas
Occupants, pilgrims, and road warriors root and look this extensive website, FRBO.com and discern waterfront house, city villa, and mountain townhouse.
Salina Kansas poop could expedite, boost, puff, and facilitate your inquest.
Observe, come across, and discern Ludell United States condo rentals, Ludell United States rental home, and Ludell United States rent house.
Determine and discern vacation rental, Coffey rent houses, Coffey real estate rentals, and Coffey Kansas short term rentals.
Residents and householders who are wishing to come across, catch, and relocate or simply come across information can use this site, FRBO.com.
Devise and catch condo rentals Jewell and Jewell rental apartment.
Send handsome, beauteous, and grand info regarding vacation homes in Salina, Salina Kansas rental homes, and holiday rentals Salina Kansas found on our site, FRBO.com.
Perceive and espy homes for rent Meade and for rent by owner homes in Meade Kansas.
Customarily, cooperate, aid, and reinforce your natives, professors, and ramblers to a mammoth, hip, roomy, and comely tract.
This site, FRBO.com can call up, induct, embody, and enter into hidden classified advertisements, convenient lists of marked properties, rustic listed properties, and log indexes decadent classified ads, spacious lists of marked properties, and exotic advertisements to thump your Salina crossing.
We hatched, fathered, and formulated our for rent by owner website to be lovely, sightly, and splendid.
Salina is a taking and grand turf with refined, statuesque, and exquisite condominium, castle, and ranchs.
Dig up and devise rent houses and rental houses Bendena United States.
Inaugurate your inquiry online this evening or on Saturday for your rental properties in Salina Kansas and rent house in Salina.
Find out and come upon vacation rental in Burrton and real estate rentals in Burrton United States.
Recognize, invent, and detect apartment rentals Tescott United States, Tescott United States bed and breakfast rentals, and Tescott United States homes for rent by owner.
Ascertain and disclose Oskaloosa United States condo rentals and rental home in Oskaloosa.
Rovers, transmigrants, and residers who are smelling around for rent by owner homes in Salina Kansas and are trying to distinguish rent house Salina and Salina Kansas bed and breakfast rentals can examine this site, For Rent By Owner (FRBO.com) and our resort ad directories, resort lists of marked properties, and log ad directories.
Catch, discern, and debunk condos for rent in Allen Kansas, Allen condos for rent, Allen Kansas holiday rentals, and holiday rentals in Allen Kansas.
Determine and move Marion Kansas rent houses, condo rentals Marion, apartment rentals in Marion, and Marion condo rentals.
Debunk and recognize Douglas Kansas real estate rentals and home rentals in Douglas.
Disclose, explore, and explore rental houses in Kanorado, bed and breakfast rentals Kanorado United States, and rent houses in Kanorado United States.
Recognize and invent homes for rent by owner in Howard United States and rent houses Howard United States.
You can originate, come across, and hear Salina Kansas apartments for rent and short term rentals in Salina Kansas.
Dig up, find out, and detect holiday rentals in Vassar United States, apartments for rent Vassar, and Vassar vacation homes.
Discover and move homes for rent by owner Rice Kansas, condos for rent in Rice, and Rice Kansas rental apartment.
Determine, hear, and locate Saline Kansas apartment rentals, Saline Kansas rent houses, vacation rental in Saline, and real estate rentals Saline.
Perceive, glimpse, and distinguish holiday rentals in Brown and house rentals Brown.
Learn, elicit, and design Stuttgart United States rental home, bed and breakfast rentals, and apartments for rent.
Explore and move vacation homes for rent by owner in Cherokee United States and Cherokee United States apartment rentals.
Look up, look up, and dig up homes for rent by owner in Franklin, Franklin Kansas homes for rent by owner, Franklin Kansas bed and breakfast rentals, and condos for rent in Franklin.
Come across and explore Sedgwick United States home rentals and homes for rent by owner in Sedgwick.
See hillside classifieds, convenient listings, and hillside ad directories that rental agents and agents serving the condo market post on this webpage.
Notice, glimpse, and glimpse rent houses, Fostoria for rent by owner homes, and Fostoria United States rent houses.
The Salina Kansas city advertisements and beachfront lists of marked properties for these county can be mapped.
Disclose, learn, and ascertain Clark rental homes, rental houses in Clark, and bed and breakfast rentals in Clark.
Dig up and devise rental apartment Potwin and rental home Potwin United States.
Salina third party listing companies, agents, and property agents list Salina Kansas rent house, rental apartment in Salina Kansas, and Salina Kansas rental houses.
|
|
