|
<%@ 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" %>
|
Minnesota Rental Links
Short term rentals and Worthington Minnesota condo rentals
Homes for rent by owner Fridley, rent houses in Fridley, and Fridley Minnesota vacation rentals
Vacation homes for rent by owner in Austin Minnesota, vacation homes in Austin, apartments for rent in Austin, and vacation rental in Austin Minnesota
Fairmont Minnesota holiday rentals and Fairmont Minnesota vacation homes for rent by owner
Apartment rentals Worthington Minnesota, homes for rent by owner in Worthington Minnesota, and Worthington Minnesota vacation homes
Condo rentals in Marshall Minnesota, Marshall rental properties, Marshall Minnesota condos for rent, and for rent by owner homes in Marshall
Homes for rent in Roseville Minnesota and rental houses
Rental properties in Chaska Minnesota, Chaska rental houses, and rental apartment in Chaska Minnesota
Apartment rentals, Willmar Minnesota rental homes, Willmar vacation rental, and holiday rentals in Willmar Minnesota
House rentals and bed and breakfast rentals in Brooklyn Center Minnesota
Rental homes Vadnais Heights Minnesota, Vadnais Heights Minnesota homes for rent, and house rentals in Vadnais Heights Minnesota
Vacation rental, real estate rentals in Anoka Minnesota, rental home Anoka, and Anoka Minnesota homes for rent by owner
Condos for rent in Mounds View and condo rentals Mounds View
Bed and breakfast rentals in Red Wing Minnesota, Red Wing Minnesota home rentals, and Red Wing homes for rent
Real estate rentals, short term rentals Roseville Minnesota, home rentals in Roseville Minnesota, and real estate rentals Roseville Minnesota
Home rentals in Rochester Minnesota and houses for rent Rochester Minnesota
Short term rentals Elk River Minnesota, Elk River condo rentals, and Elk River Minnesota short term rentals
Hutchinson Minnesota short term rentals, Hutchinson Minnesota apartments for rent, bed and breakfast rentals in Hutchinson Minnesota, and house rentals Hutchinson
Apartments for rent in East Bethel Minnesota and East Bethel Minnesota short term rentals
Uncover, invent, and contrive holiday rentals, condo rentals Peterson, and rental properties in Peterson United States.
Invent and learn house rentals and condos for rent Foley United States.
Come across, identify, and contrive rent house Meeker Minnesota, Meeker Minnesota homes for rent by owner, and apartments for rent.
Ferret out, catch, and contrive rental homes, vacation rentals in Hubbard Minnesota, rental properties in Hubbard Minnesota, and Hubbard rent houses.
Identify and recognize apartment rentals St. Louis, St. Louis rental homes, St. Louis Minnesota houses for rent, and for rent by owner homes.
Espy and invent vacation homes in Maple Plain United States and Maple Plain United States rental home.
Disclose and disclose rental apartment in Yellow Medicine Minnesota and Yellow Medicine Minnesota rental homes.
Discover, come across, and uncover Roseau Minnesota home rentals and rental properties in Roseau Minnesota.
Observe and observe Scott home rentals and rental homes in Scott Minnesota.
Distinguish strange and startling brass tacks in Faribault and tabulate vacation rental.
See ski in/out classified ads, exotic online MLS, and romantic classified advertisements that rental agents and property brokers post on our page.
This website, FRBO.com does comprise startling beachfront, lakefront, and rustic hacienda, condominium, timeshare, and haciendas.
Faribault Minnesota whole story could sustain, aid, support, and help your going-over.
Recognize and recognize Wabasha vacation homes for rent by owner, for rent by owner homes in Wabasha Minnesota, and condos for rent Wabasha Minnesota.
Espy and identify Ogema United States rent house and homes for rent in Ogema United States.
Discover, explore, and ferret out Wrenshall United States rental home, short term rentals in Wrenshall United States, and apartment rentals in Wrenshall United States.
Observe and observe real estate rentals in Saint Louis Park and vacation rental.
You can seek the decadent directories and beachfront advertisements under rental houses, Faribault Minnesota vacation rentals, and Faribault Minnesota vacation homes for rent by owner.
Locate and catch holiday rentals in Nicollet and Nicollet apartments for rent.
Invent, ascertain, and identify Makinen vacation rental, Makinen rental apartment, and Makinen United States short term rentals.
Our page eliminates domain, square, and state reports, periodically.
Hear and hear vacation rentals Hines United States and house rentals Hines.
Recognize, uncover, and perceive Pipestone United States apartments for rent, rental properties in Pipestone United States, and Pipestone United States condos for rent.
Detect and invent Houston Minnesota rent house, house rentals in Houston, and rental home in Houston Minnesota.
Observe, relocate, and disclose home rentals in Virginia, Virginia United States rental home, and Virginia United States condos for rent.
Schoolmates, commuters, and pioneers frisk and scout FRBO.com and catch romantic flat and lakeside home.
|
|
