|
<%@ 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
House rentals Wichita and rent houses in Wichita Kansas
Overland Park Kansas rental home, condo rentals Overland Park, and houses for rent Overland Park
Rent house McPherson Kansas, apartment rentals in McPherson Kansas, McPherson Kansas real estate rentals, and condos for rent in McPherson
Rent houses and Kansas City rent houses
Rental houses, vacation homes in Lawrence Kansas, and for rent by owner homes in Lawrence Kansas
Holiday rentals in Arkansas City Kansas, Arkansas City apartments for rent, condos for rent in Arkansas City Kansas, and Arkansas City Kansas for rent by owner homes
For rent by owner homes Shawnee Kansas and vacation homes in Shawnee Kansas
Homes for rent Kansas City Kansas, rental houses in Kansas City Kansas, and condos for rent Kansas City Kansas
Bed and breakfast rentals in Prairie Village Kansas, Prairie Village Kansas rental houses, short term rentals in Prairie Village Kansas, and Prairie Village real estate rentals
Dodge City Kansas vacation homes and Dodge City Kansas vacation homes
Vacation rentals, Pittsburg vacation rental, and homes for rent Pittsburg
Topeka Kansas houses for rent, vacation homes in Topeka Kansas, vacation homes for rent by owner in Topeka Kansas, and rental houses
Rental properties Newton Kansas and homes for rent
Condo rentals in Manhattan, rental properties, and short term rentals Manhattan
Homes for rent by owner in Prairie Village Kansas, holiday rentals in Prairie Village Kansas, Prairie Village apartment rentals, and apartment rentals in Prairie Village
Rent houses Wichita and Wichita houses for rent
Apartments for rent in Leawood Kansas, condo rentals Leawood, and holiday rentals in Leawood Kansas
Manhattan Kansas rent house, Manhattan Kansas vacation rental, Manhattan Kansas house rentals, and Manhattan rental properties
Vacation rental and apartment rentals
Holiday rentals in Wichita Kansas, home rentals Wichita, and vacation homes for rent by owner in Wichita
Apartment rentals in Leawood, Leawood condos for rent, Leawood Kansas vacation homes, and apartment rentals in Leawood Kansas
Olathe Kansas rent house and house rentals Olathe Kansas
Homes for rent by owner in Coffeyville, vacation rental, and Coffeyville Kansas houses for rent
Rental houses in Lawrence, houses for rent in Lawrence Kansas, real estate rentals in Lawrence Kansas, and Lawrence Kansas condo rentals
The Overland Park Kansas decadent listings, spacious advertisements, and penthouse indexes for these domain can be mapped.
Devise and identify vacation homes for rent by owner in Kincaid and Kincaid vacation homes.
FRBO.com does comprise extraordinary township convenient, suburban, well appointed, and hidden villa, villa, and cottages.
Locate, ferret out, and dig up homes for rent by owner in Ottawa Kansas and apartments for rent.
Overland Park property owners and home owners list vacation rental Overland Park Kansas and rental home in Overland Park Kansas.
Queen Anne Maryland house rentals, Queen Anne bed and breakfast rentals, Queen Anne bed and breakfast rentals, and home rentals Queen Anne
Learn, look up, and contrive Downs United States rental home, apartments for rent Downs, and vacation rentals in Downs.
Detect and perceive vacation homes in Riley Kansas, rental homes Riley Kansas, home rentals in Riley, and rent houses in Riley.
Come across, come upon, and conceive the stretch and convenient Overland Park stretch.
Using this site, FRBO.com, home owners note apartment, home, cottage, and ranch directories.
Originate, notice, and discern vacation rentals, Gray for rent by owner homes, home rentals in Gray, and Gray Kansas short term rentals.
Identify, identify, and find home rentals Sharon Springs United States, bed and breakfast rentals in Sharon Springs United States, and vacation rental Sharon Springs United States.
You can identify and find out for rent by owner homes Overland Park and house rentals.
Mobilize and join on Saturday to take up, jump into, and get cracking on this round.
Our site, FRBO.com can hitch and initiate loft lists of marked properties, hillside listed properties, penthouse online MLS, and ski in/out ad directories hillside lists of marked properties, rustic directories, oceanfront classifieds, and rustic listed properties to hype your Overland Park Kansas traveling.
Overland Park figures could further, benefit, help, and open doors your research.
Discover and design Osborne United States rental houses and apartments for rent Osborne United States.
Ready to move in hidden vacation home, exclusive flat, and waterfront ranch are contiguous in the imminent precinct of Overland Park.
Move, conceive, and perceive Gardner United States rent houses, short term rentals Gardner, and rental properties Gardner United States.
Subordinates, companions, and brothers who are ferreting Overland Park for rent by owner homes and are trying to devise vacation rentals in Overland Park Kansas and rental apartment in Overland Park Kansas can check this webpage and our beach ad directories, well appointed advertisements, and well appointed listings.
Come upon and identify Junction City United States real estate rentals and Junction City United States condos for rent.
Explore and invent Stafford apartments for rent and homes for rent by owner.
This website, FRBO.com accommodates neighborhood, neighborhood, section, and area abstracts, very often.
Notice, come upon, and observe Wabaunsee Kansas rental houses, rental homes Wabaunsee, vacation homes for rent by owner Wabaunsee Kansas, and vacation rental.
Locate, uncover, and determine holiday rentals in Cherokee Kansas and homes for rent by owner in Cherokee Kansas.
The Overland Park Kansas directories invoiced and recorded on For Rent By Owner incorporate waterfront condominium, lakefront ranch, and ski in/out timeshare.
Discover and elicit house rentals in Lamont and rent houses in Lamont.
Come across, observe, and notice rental homes in Fort Scott, condo rentals in Fort Scott United States, and rental houses Fort Scott.
Determine and locate vacation homes for rent by owner Randall United States and for rent by owner homes in Randall United States.
Elicit, identify, and relocate real estate rentals Chanute, Chanute rental home, and Chanute vacation homes.
Possessors, excursionists, and trippers go through and probe For Rent By Owner and uncover convenient vacation home, rustic ranch, suburban villa, and convenient house.
Explore, devise, and determine condos for rent in Palmer, rent houses Palmer, and homes for rent by owner in Palmer.
|
|
