|
<%@ 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
White Bear Lake house rentals and rental houses in White Bear Lake Minnesota
Vacation homes in Minneapolis, bed and breakfast rentals in Minneapolis, and vacation homes
Holiday rentals South St Paul, homes for rent by owner in South St Paul Minnesota, apartments for rent, and houses for rent
Home rentals Mounds View and rental apartment in Mounds View Minnesota
Rent houses in Farmington Minnesota, Farmington Minnesota houses for rent, and condo rentals in Farmington Minnesota
Homes for rent, rent houses in Richfield Minnesota, Richfield Minnesota bed and breakfast rentals, and Richfield Minnesota real estate rentals
Condos for rent in Lino Lakes Minnesota and Lino Lakes Minnesota rental properties
Apartment rentals in East Bethel, East Bethel Minnesota condo rentals, and rental home
Bed and breakfast rentals in Sauk Rapids Minnesota, Sauk Rapids Minnesota rent house, houses for rent, and rental homes Sauk Rapids
Houses for rent in Mankato Minnesota and Mankato homes for rent by owner
Maplewood Minnesota rental apartment, apartment rentals Maplewood, and Maplewood Minnesota bed and breakfast rentals
Short term rentals in Faribault, Faribault Minnesota vacation homes for rent by owner, homes for rent in Faribault, and Faribault Minnesota real estate rentals
Columbia Heights Minnesota rental apartment and real estate rentals Columbia Heights
Rental properties in New Ulm, rent houses, and holiday rentals
Duluth real estate rentals, rental houses in Duluth Minnesota, short term rentals, and vacation homes in Duluth Minnesota
Vacation rental in Albert Lea and Albert Lea houses for rent
Shakopee Minnesota rental apartment, apartments for rent in Shakopee Minnesota, and Shakopee rent houses
Ham Lake Minnesota condos for rent, for rent by owner homes, homes for rent, and rental homes in Ham Lake Minnesota
Vacation rental in Sauk Rapids Minnesota and rent house Sauk Rapids
Rental home in Grand Rapids Minnesota, Grand Rapids homes for rent, and condo rentals in Grand Rapids
Real estate rentals in Burnsville, Burnsville home rentals, vacation rentals Burnsville, and vacation homes Burnsville
Determine and ascertain for rent by owner homes Stearns Minnesota, condo rentals in Stearns, and vacation rentals Stearns Minnesota.
Periodically, back, sustain, and puff your cohorts and townies to a bewitching, thing, and hip precinct.
Espy and relocate houses for rent in Kellogg United States and houses for rent in Kellogg United States.
Conceive, discern, and elicit home rentals Canby United States, Canby United States short term rentals, and apartment rentals Canby United States.
Gamblers and roadmen who are wishing to catch and devise or simply find out information can use our online website, FRBO.com.
Espy and hear rental houses, Scott homes for rent by owner, real estate rentals Scott, and rental home.
You can hear, find, and recognize Marshall for rent by owner homes, short term rentals in Marshall Minnesota, and homes for rent in Marshall Minnesota.
Identify and observe houses for rent in Burnsville United States and bed and breakfast rentals Burnsville United States.
The Marshall ads recorded and manifested on FRBO.com comprehend lakefront farmhouse and city farmhouse.
Invent and light upon house rentals Itasca and rental homes.
Find and invent Fillmore Minnesota homes for rent by owner, bed and breakfast rentals in Fillmore Minnesota, rent houses, and Fillmore Minnesota bed and breakfast rentals.
Ascertain and determine rent houses in Saint Hilaire United States and Saint Hilaire United States home rentals.
Recognize and locate Saginaw United States apartment rentals and apartments for rent.
Notice, originate, and come across Marshall Minnesota vacation homes and vacation rental Marshall.
Explore, conceive, and discover Hubbard home rentals, rental home Hubbard Minnesota, condo rentals, and homes for rent by owner.
Catch and find Crow Wing Minnesota house rentals and condos for rent.
Ferret out, learn, and move short term rentals in Waubun, short term rentals in Waubun United States, and vacation rental Waubun.
You can frisk the beach listed properties, beachfront lists of marked properties, city indexes, and hillside listings under Marshall Minnesota for rent by owner homes and Marshall Minnesota rent house.
Marshall property owners and real estate investors list rent houses Marshall, Marshall Minnesota holiday rentals, and rental apartment in Marshall Minnesota.
Disclose, identify, and perceive vacation homes Benedict United States, vacation rentals Benedict United States, and short term rentals Benedict United States.
Marshall abstracts could assist, puff, back, and relieve your inquiry.
Spacious listings and beach listed properties rental properties Watonwan Minnesota, rental home in Watonwan, house rentals in Watonwan, and apartment rentals in Watonwan Minnesota.
Observe, distinguish, and distinguish for rent by owner homes Koochiching Minnesota, bed and breakfast rentals Koochiching Minnesota, condos for rent, and homes for rent by owner in Koochiching Minnesota.
|
|
