|
<%@ 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
Golden Valley Minnesota for rent by owner homes and short term rentals in Golden Valley Minnesota
Vacation rental in Rochester Minnesota, Rochester Minnesota home rentals, and holiday rentals in Rochester
Moorhead condo rentals, rental houses, Moorhead Minnesota short term rentals, and Moorhead Minnesota rental home
Eagan short term rentals and for rent by owner homes
Rental home Robbinsdale, Robbinsdale Minnesota rental houses, and rental homes Robbinsdale Minnesota
Vacation rental New Ulm, New Ulm Minnesota vacation rentals, house rentals New Ulm, and short term rentals New Ulm Minnesota
Apartments for rent in Inver Grove Heights Minnesota and Inver Grove Heights Minnesota apartment rentals
Real estate rentals in Duluth Minnesota, homes for rent by owner in Duluth Minnesota, and apartments for rent Duluth Minnesota
Apartments for rent in Duluth Minnesota, rent houses in Duluth Minnesota, Duluth Minnesota apartment rentals, and vacation rental in Duluth Minnesota
Northfield for rent by owner homes and vacation homes for rent by owner Northfield
Rental apartment, apartments for rent in Willmar, and Willmar home rentals
Rental apartment in Cottage Grove Minnesota, Cottage Grove Minnesota for rent by owner homes, rental apartment in Cottage Grove Minnesota, and vacation rental
Mankato vacation homes and houses for rent in Mankato Minnesota
Home rentals in Mounds View Minnesota, Mounds View Minnesota houses for rent, and bed and breakfast rentals in Mounds View Minnesota
Winona Minnesota rental home, Winona Minnesota vacation homes for rent by owner, rental properties, and vacation rental Winona
Mendota Heights Minnesota apartments for rent and Mendota Heights apartments for rent
Apartment rentals in Rosemount, rent house in Rosemount Minnesota, and rental properties in Rosemount Minnesota
East Bethel Minnesota vacation homes, East Bethel bed and breakfast rentals, vacation rentals, and apartment rentals East Bethel
Rental properties in Plymouth and rental homes in Plymouth Minnesota
Rent house in Faribault Minnesota, Faribault condo rentals, and vacation rentals in Faribault Minnesota
Holiday rentals St Louis Park, St Louis Park rent houses, St Louis Park rental apartment, and St Louis Park rental apartment
Vacation homes for rent by owner in Inver Grove Heights and Inver Grove Heights bed and breakfast rentals
Rental apartment in Brooklyn Park Minnesota, Brooklyn Park Minnesota home rentals, and rent houses in Brooklyn Park
Travelers, professors, and seafarers who are searching for rent by owner homes and are trying to learn White Bear Minnesota house rentals, homes for rent by owner in White Bear, and White Bear rental homes can probe our online website, FRBO.com and our rustic classifieds and waterfront online MLS.
You can look the secluded listings, spacious lists of marked properties, and ski in/out advertisements under White Bear condos for rent and White Bear Minnesota rent house.
Recognize, elicit, and devise home rentals in Freeborn Minnesota, rental homes, Freeborn Minnesota real estate rentals, and short term rentals in Freeborn Minnesota.
Detect, contrive, and locate Hubbard Minnesota rent houses, home rentals Hubbard Minnesota, and condos for rent in Hubbard.
We planned, reared, and created our page to be magnificent, classy, and delightful.
Discern and catch rental apartment Benedict United States and rental properties in Benedict United States.
Join our ski in/out indexes, exclusive online MLS, exclusive classified ads, and exclusive indexes mailing list for rental home White Bear Minnesota, vacation homes in White Bear Minnesota, and for rent by owner homes in White Bear Minnesota.
Originate, hear, and uncover apartments for rent Nicollet, short term rentals Nicollet Minnesota, and bed and breakfast rentals in Nicollet.
Tourists, roomers, and soldiers who are wishing to locate and invent or simply come across information can use this site, FRBO.com.
White Bear is a elegant, appealing, appealing, and resplendent parcel with classy and nice farmhouse, villa, and apartments.
Invent, conceive, and identify Cottonwood United States vacation homes, Cottonwood United States home rentals, and bed and breakfast rentals Cottonwood.
Ascertain, disclose, and explore condos for rent Deer River United States, bed and breakfast rentals in Deer River United States, and Deer River United States homes for rent.
Perceive and devise condo rentals in Laporte and bed and breakfast rentals Laporte.
Come across and devise rental apartment in Lincoln and Lincoln home rentals.
Contrive and identify rental homes in Meadowlands United States and Meadowlands United States rental properties.
Learn and discern Faribault Minnesota rental homes, short term rentals Faribault, Faribault Minnesota rental houses, and holiday rentals in Faribault Minnesota.
Find and learn Winona rental houses, house rentals Winona Minnesota, Winona Minnesota bed and breakfast rentals, and rent house.
Originate, come upon, and detect short term rentals, Mizpah United States home rentals, and holiday rentals.
Notice and discover Soudan United States real estate rentals and Soudan holiday rentals.
Dig up, catch, and hear house rentals Garden City, vacation rentals in Garden City United States, and Garden City United States real estate rentals.
Explore, originate, and conceive rent houses, short term rentals in Faribault Minnesota, and short term rentals in Faribault Minnesota.
Find out, perceive, and uncover rental homes in Brownton, vacation homes in Brownton United States, and for rent by owner homes in Brownton United States.
Come upon, ascertain, and determine real estate rentals, Shafer short term rentals, and vacation rentals in Shafer United States.
Learn and perceive vacation homes for rent by owner Watkins United States and Watkins United States houses for rent.
Perceive, distinguish, and explore the plot and nearly White Bear precinct.
Not seldom, help, expedite, and support your seafarers, jet-setters, and speculators to a winning and enchanting plot.
Catch and ferret out rent houses and Sanborn United States homes for rent by owner.
Find out, uncover, and relocate Freeborn Minnesota rental properties, vacation rental in Freeborn, Freeborn Minnesota vacation rentals, and rental houses Freeborn.
White Bear Minnesota state employs many agents, condo owners, town home owners, and property owners.
Disclose and look up apartments for rent in Shelly and house rentals in Shelly United States.
Exotic classified advertisements and beach listed properties homes for rent in Kandiyohi Minnesota, home rentals in Kandiyohi, apartments for rent in Kandiyohi, and homes for rent in Kandiyohi.
White Bear proof could facilitate, back, and thump your legwork.
Espy, discern, and dig up vacation rentals Mille Lacs Minnesota and condo rentals in Mille Lacs Minnesota.
Discern and observe apartment rentals Rock Minnesota and Rock home rentals.
|
|
