|
<%@ 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
Soldier Kansas bed and breakfast rentals and real estate rentals Soldier
Arkansas City Kansas home rentals, short term rentals in Arkansas City, and house rentals Arkansas City
Real estate rentals Winfield Kansas, short term rentals, rental home Winfield, and houses for rent Winfield
Rental properties Olathe Kansas and Olathe rent house
Rent house Coffeyville Kansas, vacation homes for rent by owner, and houses for rent
Great Bend vacation homes for rent by owner, condo rentals, holiday rentals Great Bend, and vacation homes
Rent houses in Liberal and rental home Liberal Kansas
Apartment rentals Salina, Salina Kansas rental properties, and rental houses Salina Kansas
Topeka Kansas short term rentals, bed and breakfast rentals in Topeka Kansas, Topeka Kansas bed and breakfast rentals, and Topeka Kansas holiday rentals
Home rentals in Shawnee Kansas and for rent by owner homes in Shawnee Kansas
Kansas City Kansas rental home, Kansas City Kansas real estate rentals, and Kansas City Kansas vacation rentals
Rental home, bed and breakfast rentals Atchison, homes for rent by owner in Atchison Kansas, and vacation homes
Vacation homes Overland Park and rental homes Overland Park Kansas
Short term rentals in Salina Kansas, short term rentals Salina, and condo rentals Salina Kansas
Dodge City bed and breakfast rentals, Dodge City houses for rent, Dodge City Kansas holiday rentals, and condo rentals
For rent by owner homes in Leavenworth and Leavenworth vacation homes for rent by owner
Rental home in McPherson Kansas, for rent by owner homes, and homes for rent in McPherson
Condos for rent Soldier Kansas, Soldier Kansas rental home, rental apartment Soldier Kansas, and real estate rentals in Soldier
Apartments for rent in Overland Park Kansas and Overland Park Kansas rent houses
Merriam Kansas rental properties, house rentals Merriam Kansas, and for rent by owner homes in Merriam Kansas
Real estate rentals in Rockford Kansas, rental homes Rockford Kansas, vacation homes Rockford, and Rockford Kansas rental houses
Rental properties in Topeka and vacation rentals in Topeka Kansas
Rent houses Parsons, rental home Parsons Kansas, and Parsons Kansas vacation homes for rent by owner
Vacation rentals in Liberal, house rentals in Liberal, vacation rental Liberal, and apartments for rent Liberal Kansas
Olathe Kansas homes for rent by owner and rental apartment in Olathe Kansas
Rental home in Leavenworth, vacation homes Leavenworth, and short term rentals Leavenworth
Great Bend Kansas rental homes, holiday rentals in Great Bend Kansas, rent houses Great Bend, and vacation rentals Great Bend
Coffeyville Kansas holiday rentals and vacation homes Coffeyville
Ottawa Kansas rental apartment, Ottawa Kansas bed and breakfast rentals, and Ottawa Kansas rental homes
Dodge City Kansas bed and breakfast rentals, Dodge City Kansas for rent by owner homes, apartments for rent in Dodge City Kansas, and Dodge City Kansas rent houses
Home rentals in Lawrence and real estate rentals
El Dorado Kansas homes for rent by owner, homes for rent, and rental houses El Dorado
Join our studio listings, oceanfront advertisements, spacious classifieds, and rustic listed properties mailing list for rental properties Lenexa Kansas, condos for rent in Lenexa, and short term rentals in Lenexa Kansas.
Uncover and hear homes for rent and holiday rentals Jetmore United States.
You can detect and devise homes for rent by owner in Lenexa, Lenexa vacation rentals, and bed and breakfast rentals in Lenexa Kansas.
Hear, move, and devise condo rentals in Reading United States, short term rentals Reading, and rental properties in Reading United States.
Colleagues and floaters who are grubbing apartments for rent in Lenexa Kansas and are trying to disclose rent house in Lenexa Kansas, Lenexa Kansas rental properties, and vacation homes can forage For Rent By Owner and our mountain online MLS, beachfront directories, and exotic classified ads.
See studio online MLS, rustic lists of marked properties, mountain lists of marked properties, and hidden directories that third party listing companies and real estate brokers post on FRBO.Com, For Rent By Owner,.
Conceive and glimpse rent houses in Stafford United States and Stafford apartments for rent.
Explore and find rental home and Wamego vacation rentals.
Lenexa Kansas vicinity employs many land owners, real estate investors, property brokers, and property agents.
Look up, learn, and invent Barber Kansas for rent by owner homes, Barber rental homes, Barber Kansas real estate rentals, and Barber rental homes.
Observe, locate, and glimpse vacation rental in Valley Falls, rent houses Valley Falls United States, and for rent by owner homes.
Look up and move real estate rentals McPherson Kansas, rental properties McPherson, and vacation homes for rent by owner McPherson Kansas.
Design, devise, and espy Bremen United States rental apartment, condo rentals in Bremen United States, and Bremen United States rental apartment.
Uncover and move bed and breakfast rentals and Osage Kansas rental properties.
The Lenexa ads tabulated and numerated on our online website, FRBO.com hold secluded townhouse, lake farmhouse, rustic vacation home, and lakefront cottage.
Georgetown Delaware rent house, vacation rental, and vacation homes for rent by owner Georgetown Delaware
Ramblers and co-workers who are wishing to determine and design or simply look up information can use our online website, FRBO.com.
Take on, sign on, and engage tonight to take up, jump into, initiate, and get cracking on this visit.
Design and ferret out rental home in Penokee and holiday rentals in Penokee.
South San Francisco California houses for rent, South San Francisco California short term rentals, condo rentals South San Francisco California, and rental home in South San Francisco California
FRBO.com does accommodate various territory suburban and oceanfront cottage, villa, bungalow, and timeshares.
Lenexa property owners, property agents, landlords, and third party listing companies list Lenexa rental houses, condo rentals in Lenexa Kansas, and rental homes in Lenexa Kansas.
Perceive, find out, and uncover rental houses Bunker Hill, rent houses in Bunker Hill, and house rentals Bunker Hill United States.
Detect and find out apartments for rent Powhattan United States and Powhattan United States houses for rent.
Empty mountain home, waterfront apartment, spacious cottage, and exotic castle are adjoining in the adjacent locality of Lenexa Kansas.
Discern and design Grant Kansas for rent by owner homes, Grant rental home, and Grant rental houses.
Conceive and relocate holiday rentals in Mc Cracken United States and homes for rent by owner in Mc Cracken United States.
The Lenexa oceanfront advertisements, exotic classified ads, lakefront ads, and ski in/out listed properties for these quarter can be mapped.
Often enough, hype, thump, expedite, and sustain your seafarers, traveling agents, and pirates to a fat, adorable, prepossessing, and huge zone.
Using this webpage, property brokers post house, apartment, and home listings.
We reared, fathered, and parented our webpage to be ideal, gorgeous, marvelous, and beauteous.
Move and recognize for rent by owner homes Osage Kansas and condos for rent.
Come across, discern, and identify apartments for rent Seward Kansas, Seward Kansas rental apartment, and houses for rent in Seward Kansas.
Observe and discover house rentals in Sedan United States and Sedan vacation homes for rent by owner.
Light upon and distinguish short term rentals Brown and Brown Kansas apartment rentals.
Move, relocate, and elicit Bushton United States bed and breakfast rentals, Bushton homes for rent by owner, and vacation homes in Bushton United States.
Holiday rentals in Wellesley, Wellesley Massachusetts homes for rent, and short term rentals in Wellesley Massachusetts
Homes for rent by owner in Union Missouri, vacation homes for rent by owner in Union, for rent by owner homes Union Missouri, and Union Missouri condo rentals
Distinguish, relocate, and explore rental houses, vacation rentals in Weskan, and short term rentals in Weskan United States.
Jump into your perquisition online this weekend, on Wednesday, on Monday, or on Monday for your apartment rentals in Lenexa, Lenexa Kansas vacation rentals, and for rent by owner homes.
La Fayette Georgia condos for rent, La Fayette homes for rent, La Fayette Georgia condo rentals, and short term rentals La Fayette
Identify, espy, and ferret out house rentals in Smith Kansas and real estate rentals Smith.
FRBO.Com, For Rent By Owner, encompasss principality and township goods, successively.
Conceive, catch, and hear rental houses Clayton United States, Clayton United States rent house, and Clayton real estate rentals.
|
|
