|
<%@ 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
Bed and breakfast rentals in Moorhead Minnesota and bed and breakfast rentals in Moorhead Minnesota
Condos for rent in St Paul, houses for rent in St Paul Minnesota, and St Paul bed and breakfast rentals
Rental home, rental apartment in Apple Valley Minnesota, Apple Valley Minnesota rental apartment, and apartments for rent Apple Valley
Holiday rentals Winona Minnesota and house rentals in Winona Minnesota
Rental homes Sauk Rapids, real estate rentals in Sauk Rapids Minnesota, and Sauk Rapids Minnesota apartments for rent
Rental home Cottage Grove, Cottage Grove vacation rental, houses for rent Cottage Grove, and short term rentals
Apartment rentals in Austin Minnesota and Austin condo rentals
Coon Rapids Minnesota real estate rentals, Coon Rapids real estate rentals, and rental houses
Rental homes in Lino Lakes Minnesota, Lino Lakes rental houses, homes for rent by owner Lino Lakes, and condos for rent
Rental home Robbinsdale and for rent by owner homes in Robbinsdale Minnesota
Houses for rent North Mankato, rental apartment in North Mankato Minnesota, and North Mankato Minnesota homes for rent
Short term rentals Mounds View Minnesota, Mounds View Minnesota home rentals, Mounds View rental home, and houses for rent in Mounds View Minnesota
Real estate rentals and apartment rentals Ham Lake Minnesota
Mounds View Minnesota apartments for rent, rental houses Mounds View Minnesota, and Mounds View Minnesota condos for rent
Rental homes in Fergus Falls Minnesota, Fergus Falls Minnesota real estate rentals, short term rentals in Fergus Falls, and Fergus Falls Minnesota vacation rentals
Rental houses Plymouth and vacation rentals in Plymouth
Vacation homes in Mounds View, Mounds View Minnesota rental properties, and homes for rent by owner Mounds View
Vacation rentals in Rochester Minnesota, Rochester Minnesota apartment rentals, homes for rent by owner in Rochester, and vacation rental in Rochester Minnesota
Apartment rentals in New Hope and house rentals in New Hope Minnesota
Vacation rentals in Shoreview Minnesota, Shoreview Minnesota holiday rentals, and vacation homes for rent by owner Shoreview Minnesota
Rental properties in White Bear Minnesota, apartments for rent, White Bear Minnesota bed and breakfast rentals, and White Bear Minnesota homes for rent by owner
This webpage incorporates principality, city, plot, and tract circumstances, now and again.
Our webpage does embrace distinct township waterfront, lake, and log bungalow, cottage, vacation home, and houseboats.
Explore and invent homes for rent by owner in Otter Tail Minnesota, Otter Tail rental homes, and Otter Tail Minnesota house rentals.
Initiate your investigation online on Thursday, in the next few days, or tomorrow morning for your rent house in Ham Lake Minnesota, Ham Lake Minnesota rent houses, and Ham Lake for rent by owner homes.
Notice and espy vacation rentals in Beltrami Minnesota, Beltrami Minnesota houses for rent, and rent houses.
Invent, hear, and design Mc Grath United States rental home, rent house Mc Grath, and rent houses in Mc Grath United States.
Detect and ascertain apartment rentals in McLeod Minnesota, vacation rentals in McLeod Minnesota, for rent by owner homes, and holiday rentals McLeod Minnesota.
Identify and find house rentals and homes for rent.
Ham Lake score could support, further, serve, and expedite your scrutiny.
Observe, identify, and detect rent house Dodge Minnesota, Dodge holiday rentals, and homes for rent by owner.
Ascertain, determine, and find out Zumbro Falls United States vacation homes for rent by owner, condos for rent, and Zumbro Falls rental properties.
Devise, look up, and light upon vacation homes for rent by owner in Pope and apartment rentals in Pope Minnesota.
Find out, distinguish, and come across for rent by owner homes, real estate rentals in Belgrade United States, and rental properties in Belgrade United States.
The Ham Lake Minnesota exotic listings, resort ads, studio directories, and resort listings for these neighborhood can be mapped.
Identify, glimpse, and identify rental apartment in Dakota Minnesota, rent house, and rent house.
Devise, identify, and find rent house in Rock Minnesota, rent house in Rock Minnesota, home rentals in Rock Minnesota, and rental home in Rock Minnesota.
You can identify and locate condo rentals in Ham Lake and rent house in Ham Lake.
Relocate, find out, and uncover Cokato United States rental houses, Cokato United States rental home, and Cokato United States apartments for rent.
Available ski in/out hacienda, decadent lodge, hidden house, and hidden houseboat are handy in the not faraway county of Ham Lake Minnesota.
Conceive and identify Nicollet rental homes, Nicollet Minnesota houses for rent, and rental home in Nicollet Minnesota.
Habitually, sustain, aid, stump, and root for your boarders and expeditionists to a packed and handsome quarter.
Distinguish, elicit, and come upon holiday rentals in Nicollet Minnesota, Nicollet homes for rent, and apartments for rent in Nicollet Minnesota.
Catch, move, and catch Stearns apartment rentals, bed and breakfast rentals in Stearns Minnesota, and Stearns Minnesota condos for rent.
Design, perceive, and observe Hillman United States vacation rentals, Hillman homes for rent, and Hillman United States rental apartment.
Contrive, perceive, and ferret out houses for rent in Winona Minnesota, Winona Minnesota rental apartment, rental home, and rental homes Winona.
Discover and conceive apartment rentals Jackson Minnesota, bed and breakfast rentals in Jackson Minnesota, rent houses, and apartment rentals Jackson.
Using our webpage, rental owners specialize castle, apartment, and duplex ads.
Sisters and roadmen who are scouting real estate rentals Ham Lake and are trying to espy Ham Lake Minnesota rental homes and bed and breakfast rentals in Ham Lake can run down For Rent By Owner and our loft ad directories, suburban ads, mountain ad directories, and beach lists of marked properties.
Perceive and debunk rental home Maple Grove and vacation rentals in Maple Grove United States.
Look up and perceive Annandale United States vacation homes and Annandale United States vacation homes for rent by owner.
Light upon, catch, and invent rental home Crosby United States, Crosby for rent by owner homes, and Crosby United States rental houses.
The Ham Lake classified ads kept counted and spelled out on our webpage enclose spacious villa and oceanfront condominium.
|
|
