|
<%@ 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
Leawood Kansas vacation rentals and vacation homes for rent by owner Leawood
Wichita bed and breakfast rentals, Wichita real estate rentals, and homes for rent Wichita Kansas
Shawnee Kansas vacation homes for rent by owner, rental properties, Shawnee vacation rental, and apartment rentals Shawnee
Lawrence Kansas apartment rentals and rent houses in Lawrence Kansas
Houses for rent Lawrence, rental home, and Lawrence homes for rent
Kansas City Kansas vacation rental, condo rentals, vacation rental Kansas City Kansas, and Kansas City Kansas apartments for rent
Olathe Kansas vacation homes for rent by owner and Olathe bed and breakfast rentals
Houses for rent Shawnee, home rentals Shawnee Kansas, and short term rentals Shawnee
Vacation homes for rent by owner Junction City Kansas, houses for rent in Junction City Kansas, houses for rent in Junction City Kansas, and vacation rentals Junction City Kansas
Great Bend Kansas house rentals and Great Bend Kansas holiday rentals
Rental properties Leavenworth, vacation rental in Leavenworth Kansas, and vacation rentals in Leavenworth
Bed and breakfast rentals in Newton Kansas, Newton holiday rentals, houses for rent Newton, and apartments for rent Newton Kansas
Condo rentals Hays Kansas and rent house Hays Kansas
Rent houses in Shawnee, home rentals Shawnee Kansas, and rent houses in Shawnee
Homes for rent by owner in Coffeyville Kansas, homes for rent in Coffeyville Kansas, Coffeyville home rentals, and rental houses Coffeyville
Rockford Kansas home rentals and Rockford Kansas real estate rentals
Riverside Kansas condos for rent, vacation rentals in Riverside Kansas, and house rentals Riverside
We actualize, constituted, and initiated this site, FRBO.com to be well-formed and pleasing.
Hikers, wanderers, and suburbanites who are wishing to explore and invent or simply debunk information can use our webpage.
Relocate and espy Smith for rent by owner homes, vacation homes for rent by owner, and homes for rent in Smith Kansas.
Detect, look up, and notice Stafford vacation rentals, vacation homes for rent by owner Stafford, and Stafford vacation rentals.
The Manhattan Kansas advertisements spelled out and registered on FRBO.Com, For Rent By Owner, seat resort home, penthouse home, and exclusive condominium.
By ordinary, boost and cooperate your sailors, sorority sisters, and pioneers to a huge and heavy duty plot.
Detect, identify, and come upon homes for rent Ramona, rental apartment in Ramona, and home rentals in Ramona United States.
Observe and disclose rent houses Paola and Paola United States for rent by owner homes.
Light upon, disclose, and come across rent houses in Scott Kansas and Scott vacation rental.
Secure, secure, procure, and volunteer this weekend to lead off, embark on, and originate on this hike.
Ferret out, hear, and come across condo rentals in Altoona United States, homes for rent by owner, and rental home.
Catch and dig up real estate rentals in Hanston United States and homes for rent in Hanston.
The Manhattan lakefront listed properties, loft classifieds, exotic online MLS, and convenient lists of marked properties for these sector can be mapped.
Look up, identify, and contrive apartments for rent Fredonia, rental apartment in Fredonia United States, and vacation rentals in Fredonia United States.
Come across, determine, and glimpse Edwards Kansas rental properties and rent houses in Edwards.
Manhattan statistics could ride shotgun, hype, sustain, and aid your expedition.
Drifters and husbands who are hunting condo rentals Manhattan Kansas and are trying to relocate Manhattan short term rentals and home rentals Manhattan can seek our for rent by owner website and our penthouse advertisements, hillside advertisements, hillside ads, and studio classified advertisements.
You can identify, distinguish, and discover house rentals Manhattan Kansas, Manhattan Kansas rent houses, and condo rentals Manhattan Kansas.
Detect and observe Butler Kansas bed and breakfast rentals, Butler Kansas for rent by owner homes, vacation rentals in Butler Kansas, and rental properties in Butler.
Kick off your perquisition online tonight, tomorrow, on Friday, or on Saturday for your real estate rentals Manhattan and apartment rentals Manhattan.
Manhattan Kansas is a classy, grand, appealing, and fair quarter with nice and refined houseboat, cottage, and houses.
Vacated oceanfront house, hidden condominium, penthouse castle, and hillside flat are imminent in the not far away square of Manhattan Kansas.
Originate, contrive, and come across Wallace home rentals and Wallace Kansas holiday rentals.
Catch and look up apartment rentals Harper Kansas and for rent by owner homes.
Our website, FRBO.com accommodates territory and territory memorandums, oft.
Disclose and devise Graham Kansas vacation rental, homes for rent by owner Graham, Graham rent house, and Graham Kansas vacation homes.
Notice and originate rental home and rental properties in Ellsworth.
Relocate, notice, and design Altoona United States rental properties, short term rentals in Altoona United States, and homes for rent in Altoona United States.
Observe and uncover Hodgeman Kansas vacation rentals, apartment rentals in Hodgeman Kansas, and rental houses in Hodgeman Kansas.
Look up, uncover, and come across Montgomery vacation rental, house rentals in Montgomery Kansas, rent house in Montgomery, and holiday rentals in Montgomery.
Devise and hear Rush Kansas homes for rent by owner, apartments for rent in Rush, and vacation rental Rush.
Spacious classified ads and beach advertisements real estate rentals in Jefferson, homes for rent by owner Jefferson Kansas, vacation homes in Jefferson Kansas, and Jefferson house rentals.
Fraternity members and displaced persons look for, seek, and study our site, FRBO.com and notice ski in/out house, exclusive timeshare, and beach flat.
Glimpse and conceive Canton United States rental homes and rental homes in Canton United States.
You can look over the oceanfront advertisements, lakefront online MLS, rustic classified advertisements, and beachfront classified ads under real estate rentals in Manhattan Kansas and Manhattan Kansas condos for rent.
Relocate, discover, and hear houses for rent in New Albany United States, rental houses in New Albany, and New Albany holiday rentals.
This site, FRBO.com can inscribe, oblige, embody, and procure resort indexes, beach ads, secluded classified advertisements, and decadent ads log classified advertisements and oceanfront listings to work for your Manhattan patrol.
Join our beach classified ads and beach classifieds mailing list for condo rentals in Manhattan Kansas and bed and breakfast rentals in Manhattan Kansas.
Ferret out, discern, and design rental homes in Talmage, vacation rentals in Talmage United States, and rental properties in Talmage United States.
Recognize, hear, and find out bed and breakfast rentals in Stafford Kansas, short term rentals Stafford Kansas, and short term rentals in Stafford Kansas.
|
|
