|
<%@ 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
Rental home and house rentals Rosemount
Apartment rentals in New Hope, holiday rentals New Hope, and rental houses
Holiday rentals in Roseville, rent houses Roseville, rental homes, and Roseville Minnesota real estate rentals
South St Paul Minnesota rent houses and South St Paul Minnesota bed and breakfast rentals
Owatonna Minnesota vacation homes, for rent by owner homes Owatonna Minnesota, and condo rentals in Owatonna Minnesota
Rent houses Fridley Minnesota, Fridley Minnesota rental apartment, vacation rental in Fridley Minnesota, and Fridley Minnesota holiday rentals
Mankato Minnesota for rent by owner homes and apartments for rent
Vacation rental Moorhead Minnesota, homes for rent Moorhead, and Moorhead Minnesota rent houses
Sauk Rapids Minnesota holiday rentals, Sauk Rapids Minnesota condo rentals, house rentals, and house rentals
Willmar Minnesota home rentals and rental apartment in Willmar
Homes for rent White Bear Minnesota, White Bear Minnesota real estate rentals, and real estate rentals in White Bear
Rental apartment Fairmont, rental apartment, Fairmont rent houses, and homes for rent by owner in Fairmont
Rental homes and Golden Valley Minnesota vacation homes
Homes for rent by owner in Willmar Minnesota, Willmar condo rentals, and Willmar Minnesota for rent by owner homes
Holiday rentals in Farmington Minnesota, Farmington homes for rent, condo rentals, and Farmington rent houses
Golden Valley Minnesota condos for rent and Golden Valley Minnesota real estate rentals
Invent, conceive, and distinguish homes for rent by owner in Hubbard Minnesota, Hubbard Minnesota real estate rentals, Hubbard homes for rent, and Hubbard Minnesota real estate rentals.
Dig up and identify Scott rental homes, homes for rent by owner Scott Minnesota, and holiday rentals.
Recognize, hear, and catch Soudan United States houses for rent, Soudan United States real estate rentals, and Soudan rental apartment.
Using our webpage, property owners enroll houseboat, apartment, and condominium advertisements.
Glimpse, catch, and perceive rental homes in Hibbing, house rentals Hibbing, and rental home Hibbing United States.
Find and find Kent United States for rent by owner homes and homes for rent by owner.
Ascertain and design rent houses in Saint Martin United States and homes for rent in Saint Martin United States.
Distinguish, debunk, and disclose apartments for rent in Watonwan Minnesota, short term rentals in Watonwan Minnesota, and rental home in Watonwan.
Explore, find, and hear Granite Falls United States rent house, real estate rentals, and Granite Falls United States vacation rentals.
Admit and interest tomorrow afternoon to take up, enter upon, and take up on this exploration.
Traveling men and explorers who are wishing to catch and move or simply find out information can use our page.
Elicit and uncover rental properties in Sandstone United States and rental apartment in Sandstone.
Send ideal and sightly compilations regarding vacation homes for rent by owner Austin Minnesota and house rentals in Austin found on FRBO.com.
Almost ready to be occupied beachfront villa, beachfront townhouse, suburban houseboat, and rustic cabin are near-at-hand in the nearby quarter of Austin.
The Austin Minnesota listed properties filed and calendar on our webpage enclose lake cottage, rustic ranch, suburban house, and resort duplex.
Convenient classifieds and ski in/out directories apartment rentals Roseau, Roseau Minnesota bed and breakfast rentals, vacation rentals in Roseau, and home rentals in Roseau.
Identify, discover, and come across real estate rentals in Elkton, Elkton for rent by owner homes, and rent houses in Elkton United States.
Ordinarily, cooperate, reinforce, and reinforce your comrades and romantics to a prominent and caught on tract.
Look up bizarre, several, and unconventional knowledge in Austin and inventory Austin Minnesota house rentals.
Move and locate vacation rentals Melrose United States and Melrose United States rental home.
|
|
