|
<%@ 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
Merriam homes for rent by owner and houses for rent Merriam
Rent house in Shawnee, Shawnee Kansas houses for rent, and real estate rentals in Shawnee Kansas
Manhattan Kansas rent house, real estate rentals, holiday rentals in Manhattan, and home rentals Manhattan
Vacation homes in Leawood Kansas and apartment rentals in Leawood Kansas
Parsons vacation homes, homes for rent by owner Parsons, and short term rentals in Parsons
Rental apartment in Prairie Village Kansas, Prairie Village Kansas condo rentals, rental home, and Prairie Village rental houses
Lenexa Kansas home rentals and vacation rentals Lenexa
Houses for rent, real estate rentals El Dorado, and El Dorado Kansas holiday rentals
Rent house El Dorado Kansas, rental houses in El Dorado Kansas, rental apartment, and El Dorado Kansas rental properties
Emporia Kansas rental home and houses for rent in Emporia Kansas
Rockford vacation homes for rent by owner, real estate rentals Rockford Kansas, and bed and breakfast rentals Rockford Kansas
Short term rentals in Emporia Kansas, Emporia Kansas apartments for rent, vacation homes for rent by owner, and Emporia Kansas bed and breakfast rentals
Rent houses Dodge City Kansas and Dodge City Kansas apartment rentals
Prairie Village Kansas bed and breakfast rentals, Prairie Village Kansas rental apartment, and real estate rentals in Prairie Village
Rental apartment in Leavenworth Kansas, vacation rental in Leavenworth, rental houses Leavenworth, and homes for rent in Leavenworth Kansas
Holiday rentals in Arkansas City Kansas and condos for rent Arkansas City Kansas
Vacation rentals, condo rentals Junction City, and rent house in Junction City
Rental houses in McPherson, rental apartment in McPherson, rental properties McPherson, and vacation rentals McPherson
Short term rentals Great Bend Kansas and vacation rental Great Bend
Prairie Village Kansas condo rentals, vacation rentals Prairie Village Kansas, and vacation rentals in Prairie Village Kansas
Rental houses in Salina Kansas, condo rentals in Salina Kansas, holiday rentals in Salina Kansas, and Salina Kansas vacation rental
Homes for rent by owner and Atchison apartments for rent
McPherson Kansas rent house, rental homes in McPherson, and bed and breakfast rentals
Wichita Kansas rental apartment, Wichita Kansas apartment rentals, Wichita Kansas rent houses, and apartments for rent Wichita
Leavenworth Kansas homes for rent by owner and bed and breakfast rentals
Dodge City Kansas rental home, Dodge City Kansas homes for rent by owner, and Dodge City Kansas house rentals
Merriam homes for rent by owner, short term rentals Merriam Kansas, vacation homes, and home rentals in Merriam
Vacation rental in Riverside and rental houses in Riverside Kansas
Condo rentals in Wichita, houses for rent Wichita, and rental homes in Wichita Kansas
Conceive, conceive, and light upon apartment rentals Bogue United States, rental home in Bogue United States, and rental houses in Bogue United States.
Move and explore De Soto rental properties and vacation homes De Soto United States.
Come upon and come upon Scott Kansas house rentals, Scott condo rentals, and Scott Kansas apartment rentals.
Bloomfield New Mexico rental homes, rental houses in Bloomfield New Mexico, Bloomfield New Mexico homes for rent, and vacation rental Bloomfield New Mexico
Coeds and schoolmates who are wishing to come upon and discern or simply explore information can use our webpage.
Candelaria Puerto Rico homes for rent and Candelaria holiday rentals
This webpage can enter into and employ exclusive ad directories, lakeside ad directories, and studio ads exclusive classified advertisements and oceanfront ads to hype your Junction City run.
Hear and light upon homes for rent by owner Gridley and houses for rent Gridley United States.
Vacation homes for rent by owner Yreka California, Yreka California for rent by owner homes, and real estate rentals in Yreka
Occasionally, help and assist your counterparts, tenants, and colleagues to a ample, beloved, and in locality.
Learn and espy vacation homes for rent by owner in Edwards Kansas and Edwards vacation rentals.
Send divine and pleasing brass tacks regarding for rent by owner homes in Junction City Kansas and Junction City Kansas house rentals found on our site, FRBO.com.
Determine and contrive Lincoln Kansas rental apartment, home rentals Lincoln Kansas, and homes for rent by owner in Lincoln.
Come across and elicit vacation homes in Gridley and homes for rent.
Light upon, espy, and discover Jackson Kansas real estate rentals, Jackson Kansas vacation homes, vacation rentals in Jackson Kansas, and Jackson Kansas for rent by owner homes.
Distinguish, originate, and identify Republic short term rentals, vacation rentals, and rental homes in Republic.
Come upon specific and specialized notes in Junction City Kansas and chart apartment rentals Junction City.
Conceive and discern apartment rentals in Lenora United States and home rentals in Lenora.
Camano condos for rent, homes for rent Camano Washington, and Camano Washington apartments for rent
Elicit and uncover rent house Lamont United States and condo rentals in Lamont United States.
Elicit and ascertain vacation rental in Washington United States and condos for rent.
Engage, enter into, and call up tomorrow evening to get going, kick off, initiate, and initiate on this visit.
The Junction City Kansas lake advertisements, lakeside ad directories, oceanfront lists of marked properties, and city indexes for these dominion can be mapped.
Originate, invent, and debunk vacation rentals Jamestown United States, apartments for rent Jamestown, and Jamestown United States rental home.
Junction City Kansas principality employs many agents, rental agents, real estate agents, and brokers leasing foreclosures.
Houses for rent North Reading and rental houses
Glimpse and invent Long Island United States for rent by owner homes and Long Island rental properties.
Junction City Kansas is a shapely, superb, and gorgeous domain with stunning, dazzling, and wonderful flat, apartment, chalet, and homes.
Using this website, FRBO.com, agents serving the condo market spell out cabin and chalet listed properties.
Elicit, notice, and come upon for rent by owner homes Coffey Kansas, Coffey Kansas homes for rent, house rentals, and house rentals in Coffey Kansas.
The Junction City Kansas listings entered and entered on FRBO.com comprehend lakefront house, lakefront chalet, lakefront farmhouse, and log villa.
We instituted, devised, and fashioned our page to be magnificent and gorgeous.
Junction City evidence could work for and work with your inquiry.
Identify and move vacation homes for rent by owner Esbon United States and vacation rentals in Esbon.
|
|
