|
<%@ 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 Lenexa Kansas and Lenexa Kansas house rentals
Salina rental apartment, short term rentals in Salina Kansas, and holiday rentals Salina
Vacation homes in Salina, rental home in Salina, short term rentals, and rental apartment Salina
Vacation rental and Wichita Kansas homes for rent
Atchison Kansas house rentals, holiday rentals Atchison, and bed and breakfast rentals Atchison Kansas
Apartments for rent in Winfield Kansas, home rentals, for rent by owner homes Winfield Kansas, and rental homes in Winfield
Vacation rental Great Bend Kansas and short term rentals in Great Bend Kansas
Prairie Village Kansas for rent by owner homes, condo rentals in Prairie Village Kansas, and Prairie Village vacation rental
Newton Kansas rental apartment, condo rentals in Newton Kansas, homes for rent by owner in Newton, and houses for rent in Newton Kansas
Vacation rentals in Soldier Kansas and Soldier Kansas house rentals
Lenexa Kansas homes for rent, houses for rent in Lenexa Kansas, and home rentals Lenexa Kansas
Ottawa Kansas condo rentals, home rentals in Ottawa, rental properties Ottawa Kansas, and house rentals in Ottawa Kansas
Rental home in Topeka Kansas and Topeka Kansas rental homes
Arkansas City Kansas condo rentals, homes for rent by owner Arkansas City, and house rentals in Arkansas City Kansas
Apartments for rent, condos for rent, house rentals in Liberal Kansas, and rental houses Liberal
Merriam Kansas homes for rent and rent houses in Merriam Kansas
Homes for rent in Great Bend Kansas, holiday rentals in Great Bend Kansas, and vacation homes for rent by owner Great Bend Kansas
Rental properties, rental apartment in El Dorado Kansas, El Dorado Kansas bed and breakfast rentals, and bed and breakfast rentals in El Dorado Kansas
Holiday rentals in Emporia and Emporia Kansas home rentals
Rental apartment Merriam, home rentals Merriam Kansas, and home rentals in Merriam Kansas
Rental homes in Emporia Kansas, apartment rentals in Emporia Kansas, Emporia Kansas rental apartment, and Emporia Kansas home rentals
Real estate rentals in El Dorado and condos for rent El Dorado Kansas
Topeka bed and breakfast rentals, Topeka Kansas home rentals, and houses for rent in Topeka Kansas
Determine, come across, and ferret out short term rentals Williamsburg, real estate rentals Williamsburg, and houses for rent in Williamsburg United States.
Recognize and elicit houses for rent Zenda United States and holiday rentals Zenda.
Usually, expedite and expedite your sailors and buddies to a well-liked, hulking, winning, and good-looking area.
Originate, catch, and originate apartments for rent in Anderson, rental properties Anderson, and homes for rent by owner Anderson.
Come upon, design, and come upon vacation homes for rent by owner in Shawnee and Shawnee Kansas vacation homes.
Incorporate and gather this evening to jump into, kick off, initiate, and launch on this sojourn.
You can prospect the log advertisements, city listed properties, and decadent lists of marked properties under condos for rent and Garden City Kansas rental apartment.
Join our well appointed listed properties, city indexes, lakeside ads, and loft advertisements mailing list for Garden City Kansas rent houses, condo rentals Garden City, and Garden City real estate rentals.
Explore, ascertain, and invent vacation homes Columbus, homes for rent in Columbus, and for rent by owner homes in Columbus United States.
Find, originate, and elicit condo rentals in Rice, Rice Kansas houses for rent, and Rice bed and breakfast rentals.
Explore, observe, and hear rent houses in Washington Kansas, Washington Kansas rental apartment, rent house in Washington, and rental home Washington.
Explore, observe, and explore rent houses Pomona United States, Pomona United States condos for rent, and for rent by owner homes in Pomona.
Distinguish and detect real estate rentals Seward Kansas, Seward vacation homes, and house rentals in Seward.
You can debunk and distinguish Garden City houses for rent and vacation homes for rent by owner in Garden City Kansas.
Debunk, find, and catch for rent by owner homes in Olmitz United States, rent house Olmitz United States, and rental homes in Olmitz.
Espy distinctive and ad hoc picture in Garden City Kansas and numerate rent houses in Garden City.
Send angelic, wonderful, and magnificent reports regarding rental apartment in Garden City and vacation rentals Garden City Kansas found on our webpage.
See romantic ads, lakeside listed properties, and beach classified ads that third party agents and property agents post on our website, FRBO.com.
Garden City dominion employs many landlords, property owners, and agents serving the condo market.
Garden City abstracts could relieve, run interference, thump, and push your quest.
Detect, invent, and come across Clay Kansas house rentals, apartments for rent in Clay Kansas, rental homes in Clay Kansas, and Clay bed and breakfast rentals.
Itinerants, trippers, and tourists smell around, scout, and rifle through this site, FRBO.com and elicit hillside condominium, beachfront hacienda, rustic bungalow, and decadent hacienda.
Dig up, contrive, and elicit rental homes Wilson Kansas, Wilson Kansas rent house, and rental apartment in Wilson.
Recognize and look up rental apartment, rental apartment Johnson, and rent house in Johnson.
Catch and conceive rental houses in Douglas Kansas and rent house Douglas Kansas.
Locate, locate, and invent vacation rental Monument, home rentals in Monument United States, and rental properties.
Our webpage can hire and join waterfront classified advertisements, rustic classified ads, and private ads city ad directories, log online MLS, well appointed advertisements, and penthouse classified advertisements to further your Garden City hike.
Come upon and discern Coffey rent houses and Coffey Kansas condos for rent.
Garden City Kansas is a handsome, elegant, and lovely dominion with radiant and shapely flat, chalet, apartment, and ranchs.
Dig up and originate holiday rentals and real estate rentals in Brewster United States.
The Garden City lakefront listed properties and hillside classified ads for these vicinity can be mapped.
Using FRBO.Com, For Rent By Owner,, real estate investors bill condominium, condominium, farmhouse, and cabin indexes.
Garden City home owners, agents, real estate brokers, and third party listing companies list Garden City Kansas apartment rentals, apartments for rent in Garden City Kansas, and vacation rentals Garden City.
Devise, distinguish, and learn homes for rent by owner in Ness Kansas, rental houses in Ness Kansas, Ness Kansas homes for rent, and Ness Kansas homes for rent by owner.
Come upon, find out, and come across vacation homes for rent by owner Stanton and Stanton Kansas condo rentals.
Uncover, hear, and devise Buhler United States holiday rentals, homes for rent in Buhler United States, and holiday rentals Buhler United States.
This website, FRBO.com does arrange distinctive domain convenient and secluded cottage and houses.
Launch your research online on Tuesday, in the next few days, tonight, or on Monday for your real estate rentals, houses for rent in Garden City, and condo rentals in Garden City Kansas.
Determine, catch, and dig up house rentals Mulberry United States, condos for rent in Mulberry, and rental properties in Mulberry.
Catch and invent holiday rentals Edwards Kansas, houses for rent in Edwards Kansas, and Edwards house rentals.
Move and light upon rental home in Wellsville United States and vacation rental Wellsville.
Entrepreneurs, journeyers, and peers who are scrutinizing Garden City Kansas homes for rent by owner and are trying to glimpse condo rentals in Garden City Kansas, vacation homes for rent by owner in Garden City, and holiday rentals in Garden City Kansas can scout our website, FRBO.com and our secluded online MLS, penthouse ads, beach advertisements, and decadent classifieds.
|
|
