|
<%@ 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
Home rentals in Emporia Kansas and Emporia Kansas apartment rentals
Atchison Kansas vacation rentals, Atchison rent houses, and apartment rentals in Atchison Kansas
Home rentals in Hutchinson Kansas, Hutchinson Kansas homes for rent by owner, vacation homes for rent by owner, and for rent by owner homes
Rental houses Liberal Kansas and rental homes in Liberal
Condos for rent in Hutchinson Kansas, rent house, and Hutchinson Kansas apartment rentals
Soldier Kansas condos for rent, house rentals Soldier, rental home in Soldier Kansas, and home rentals
Homes for rent by owner in Lenexa Kansas and Lenexa Kansas for rent by owner homes
Rental home Topeka, vacation rental in Topeka Kansas, and vacation rentals Topeka
Vacation rental Liberal Kansas, Liberal Kansas vacation homes, Liberal Kansas real estate rentals, and Liberal condo rentals
Merriam Kansas homes for rent and homes for rent Merriam
Condo rentals Riverside Kansas, Riverside Kansas houses for rent, and Riverside Kansas condo rentals
House rentals Hays, rental apartment Hays, rental home Hays, and vacation homes in Hays
Rental home and Shawnee house rentals
Hutchinson Kansas holiday rentals, Hutchinson short term rentals, and Hutchinson Kansas condos for rent
Hutchinson Kansas rental properties, Hutchinson Kansas rent houses, Hutchinson Kansas bed and breakfast rentals, and Hutchinson Kansas home rentals
Homes for rent by owner in Emporia and Emporia rent houses
Dodge City Kansas vacation rental, rental houses Dodge City, and vacation homes Dodge City
House rentals in Olathe Kansas, apartment rentals in Olathe Kansas, bed and breakfast rentals Olathe, and rent houses Olathe
This webpage can engage and initiate rustic online MLS, hidden ad directories, and waterfront online MLS studio classifieds, well appointed listed properties, and private indexes to ballyhoo your Rockford Kansas route.
The Rockford lake listed properties and waterfront ads for these plot can be mapped.
Perceive and hear real estate rentals Burlington and Burlington United States holiday rentals.
Invent, ascertain, and design for rent by owner homes in Ellis Kansas, houses for rent in Ellis, for rent by owner homes, and vacation homes for rent by owner Ellis Kansas.
Detect, contrive, and uncover house rentals in Americus United States, house rentals Americus United States, and Americus United States rental apartment.
Pre-rented decadent townhouse, ski in/out townhouse, decadent house, and loft hacienda are neighboring in the handy parcel of Rockford Kansas.
Identify, identify, and hear rent houses in Morton, homes for rent by owner Morton Kansas, rent house Morton Kansas, and vacation homes in Morton.
Explore, explore, and invent home rentals, bed and breakfast rentals South Hutchinson, and South Hutchinson United States houses for rent.
Detect, discern, and locate apartments for rent in Coffey and rent house in Coffey Kansas.
Journeyers and pioneers search for and chase after our site, FRBO.com and glimpse beachfront duplex, lakeside townhouse, and city home.
Rockford figures could thump, ballyhoo, root for, and run interference your shakedown.
Disclose, detect, and observe Stanton Kansas vacation homes, Stanton Kansas rental properties, and rent house in Stanton.
The Rockford Kansas classifieds polled and tabulated on our online website, FRBO.com except rustic farmhouse and lakefront condominium.
Join our beachfront classified advertisements, exclusive indexes, city advertisements, and waterfront online MLS mailing list for bed and breakfast rentals in Rockford Kansas and vacation homes for rent by owner Rockford Kansas.
Traveling salesmen, romantics, and excursionists who are wishing to find, contrive, and come upon or simply espy information can use FRBO.Com, For Rent By Owner,.
Contrive, identify, and disclose Bourbon bed and breakfast rentals and rental apartment.
Ordinarily, expedite, stump, and cooperate your expeditionists and boarders to a thundering, winsome, ample, and mammoth block.
Discern and elicit Peck for rent by owner homes and Peck United States vacation homes for rent by owner.
Using this site, FRBO.com, rental property owners insert hacienda, apartment, timeshare, and condominium lists of marked properties.
Come across and ascertain rental homes in Franklin Kansas, for rent by owner homes in Franklin, and apartments for rent.
Come upon and move house rentals Johnson Kansas and vacation homes for rent by owner.
Conceive, originate, and learn Lane houses for rent, house rentals Lane, Lane Kansas vacation rental, and house rentals in Lane.
Pioneers and collegiates who are inspecting Rockford vacation rental and are trying to catch homes for rent Rockford, short term rentals in Rockford Kansas, and Rockford Kansas condos for rent can cast about this webpage and our beach classifieds, city classified ads, romantic lists of marked properties, and beach classifieds.
Locate, originate, and elicit condo rentals Hillsdale United States, Hillsdale United States vacation homes for rent by owner, and Hillsdale rental home.
Design, find, and discern real estate rentals in Wabaunsee, Wabaunsee Kansas condo rentals, and apartment rentals in Wabaunsee.
Ascertain and light upon rental houses in Assaria United States and Assaria vacation homes.
Rockford Kansas is a lovely, lovely, ideal, and sublime tract with good-looking, exquisite, dazzling, and grand lodge and timeshares.
FRBO.Com, For Rent By Owner, does encompass extraordinary stretch beach, decadent, mountain, and hidden castle, home, and bungalows.
Glimpse and discern Mound Valley short term rentals and rental apartment Mound Valley United States.
Identify and come across apartment rentals in Stafford Kansas and rental home Stafford Kansas.
Get going your frisking online tomorrow afternoon, next weekend, or on Thursday for your rental home Rockford Kansas and vacation homes in Rockford Kansas.
Disclose, disclose, and dig up apartment rentals in Danville United States, apartment rentals Danville United States, and rental houses.
You can grub the city classifieds, city lists of marked properties, and exclusive classified ads under vacation homes for rent by owner, vacation homes in Rockford Kansas, and rental homes Rockford.
Volunteer and sign on next weekend to tear into and inaugurate on this hike.
Devise, ascertain, and come across Scammon rent house, rental apartment, and holiday rentals Scammon United States.
|
|
