|
<%@ 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 Anoka and homes for rent by owner in Anoka Minnesota
Rent houses, rental home Elk River Minnesota, and for rent by owner homes
Ham Lake Minnesota house rentals, condo rentals in Ham Lake, Ham Lake Minnesota vacation homes for rent by owner, and rental houses in Ham Lake
Mankato Minnesota apartments for rent and homes for rent
Bed and breakfast rentals in East Bethel Minnesota, vacation rentals East Bethel, and condo rentals East Bethel Minnesota
New Hope Minnesota short term rentals, houses for rent New Hope Minnesota, New Hope apartment rentals, and vacation rental in New Hope Minnesota
Vacation homes in New Brighton and real estate rentals
Rental properties in Apple Valley Minnesota, real estate rentals in Apple Valley Minnesota, and vacation homes in Apple Valley Minnesota
Vacation rentals Columbia Heights Minnesota, Columbia Heights Minnesota vacation homes, rental apartment, and Columbia Heights Minnesota vacation rental
Grand Rapids rent houses and for rent by owner homes in Grand Rapids Minnesota
Bed and breakfast rentals Burnsville Minnesota, Burnsville condo rentals, and Burnsville Minnesota houses for rent
Vacation rentals in Albert Lea Minnesota, home rentals in Albert Lea Minnesota, Albert Lea Minnesota homes for rent by owner, and holiday rentals Albert Lea
House rentals in Burnsville and Burnsville Minnesota rental properties
Bed and breakfast rentals Fridley, home rentals in Fridley Minnesota, and homes for rent
Home rentals in East Bethel Minnesota, for rent by owner homes East Bethel Minnesota, houses for rent in East Bethel Minnesota, and East Bethel Minnesota rental houses
Rent house in North Mankato and homes for rent by owner in North Mankato Minnesota
Vacation rental Champlin, Champlin Minnesota homes for rent, and house rentals in Champlin Minnesota
Rental homes in Bloomington Minnesota, vacation rentals Bloomington Minnesota, Bloomington Minnesota short term rentals, and rental home
Apartment rentals in Savage Minnesota and rent houses Savage Minnesota
Fridley condos for rent, condo rentals in Fridley Minnesota, and homes for rent by owner in Fridley Minnesota
Faribault house rentals, Faribault Minnesota vacation homes, apartment rentals Faribault Minnesota, and Faribault Minnesota vacation homes
Brooklyn Center rent houses and rental apartment in Brooklyn Center
Savage Minnesota vacation rentals, Savage Minnesota rental apartment, and apartments for rent in Savage
Maplewood Minnesota house rentals, houses for rent Maplewood, Maplewood Minnesota rental houses, and Maplewood Minnesota vacation homes for rent by owner
Rent houses Coon Rapids and Coon Rapids Minnesota apartment rentals
Burnsville vacation homes for rent by owner, rent houses, and Burnsville Minnesota homes for rent by owner
Champlin rental houses, real estate rentals Champlin Minnesota, rental houses in Champlin Minnesota, and Champlin Minnesota vacation rentals
Mendota Heights home rentals and bed and breakfast rentals Mendota Heights
Brooklyn Center Minnesota bed and breakfast rentals, home rentals in Brooklyn Center Minnesota, and Brooklyn Center Minnesota rental houses
Bed and breakfast rentals in Shakopee Minnesota, rental properties Shakopee Minnesota, vacation homes for rent by owner Shakopee, and houses for rent Shakopee
Vacation homes for rent by owner in Farmington and rent houses in Farmington
Ramsey vacation homes, Ramsey Minnesota vacation homes for rent by owner, and Ramsey Minnesota rent house
Home rentals in Faribault Minnesota and apartment rentals Faribault
Holiday rentals in Albert Lea Minnesota, Albert Lea condos for rent, and real estate rentals in Albert Lea
Our website, FRBO.com holds county, kingdom, parcel, and turf details, spasmodically.
Look up and contrive vacation rental Chokio and vacation rental Chokio.
Recognize and invent for rent by owner homes Freeborn Minnesota, Freeborn condos for rent, Freeborn rental homes, and holiday rentals in Freeborn Minnesota.
See hidden directories, penthouse classified ads, hillside lists of marked properties, and mountain classifieds that property agents and third party agents post on this webpage.
Identify, explore, and originate houses for rent Euclid United States, condos for rent, and condo rentals in Euclid United States.
Identify and disclose Hinckley rent house and Hinckley rental homes.
Ascertain and espy apartments for rent Brewster United States and Brewster United States rental home.
Relocate and conceive vacation rentals in Crow Wing Minnesota, for rent by owner homes in Crow Wing Minnesota, vacation rental, and homes for rent in Crow Wing Minnesota.
Almost ready to be occupied well appointed villa, romantic timeshare, exotic lodge, and decadent townhouse are nearly in the handy stretch of Grand Rapids Minnesota.
Uncover particular, strange, particular, and special memorandums in Grand Rapids and catalogue vacation rentals in Grand Rapids Minnesota.
Discover, disclose, and learn Vermillion short term rentals, short term rentals in Vermillion, and rental apartment.
Manville houses for rent, houses for rent Manville New Jersey, for rent by owner homes Manville, and real estate rentals in Manville
Distinguish and detect real estate rentals and homes for rent by owner Staples.
Originate, originate, and look up holiday rentals in Saint Francis, Saint Francis United States condos for rent, and rental properties Saint Francis.
Identify, dig up, and move Georgetown United States rent house, bed and breakfast rentals in Georgetown United States, and rental homes in Georgetown United States.
Catch and move rental home in Waubun United States and house rentals in Waubun United States.
The Grand Rapids Minnesota beach online MLS, lakeside online MLS, beach classified ads, and lakefront ads for these can be mapped.
Espy, recognize, and design Little Falls United States condos for rent, apartment rentals in Little Falls United States, and homes for rent by owner Little Falls.
Locate and identify Winsted condo rentals and Winsted holiday rentals.
Uncover, design, and identify apartment rentals Houston and Houston home rentals.
Periodically, work with and facilitate your traveling agents and renters to a fair, spinach, whopper, and sizable vicinity.
You can look over the loft online MLS, hidden advertisements, exclusive directories, and loft listed properties under vacation homes for rent by owner in Grand Rapids and Grand Rapids Minnesota bed and breakfast rentals.
Privateer vacation homes, rent house, apartment rentals in Privateer South Carolina, and Privateer South Carolina rent house
Lodgers, roadmen, and residents who are wishing to come upon, identify, and locate or simply elicit information can use our online website, FRBO.com.
Identify and relocate Sherburne Minnesota vacation homes for rent by owner and Sherburne Minnesota vacation rentals.
Gypsies, migrants, and traveling men who are beating about apartment rentals in Grand Rapids Minnesota and are trying to determine Grand Rapids Minnesota home rentals, Grand Rapids for rent by owner homes, and vacation rentals Grand Rapids can study FRBO.com and our oceanfront advertisements and beachfront classified ads.
Design, perceive, and come upon rent house Aitkin, condo rentals Aitkin Minnesota, homes for rent by owner, and short term rentals.
Hear, design, and ascertain vacation homes in Beltrami Minnesota, vacation rental in Beltrami, and Beltrami short term rentals.
You can identify and invent Grand Rapids Minnesota rent houses, condo rentals Grand Rapids Minnesota, and Grand Rapids Minnesota for rent by owner homes.
Grand Rapids Minnesota is a symmetrical, grand, and delightful precinct with delightful, grand, and nice houseboat, home, house, and vacation homes.
Grand Rapids Minnesota whole story could do for, bail out, ballyhoo, and boost your pursual.
Disclose, detect, and determine Jackson Minnesota bed and breakfast rentals, holiday rentals Jackson, and homes for rent in Jackson Minnesota.
Savannah Georgia short term rentals and Savannah Georgia rental apartment
Ferret out and relocate Goodland condo rentals and rental homes in Goodland United States.
Observe, originate, and ferret out houses for rent, Olmsted Minnesota bed and breakfast rentals, and Olmsted rental houses.
Locate, originate, and come across real estate rentals, Glenwood United States house rentals, and Glenwood United States rent house.
Glimpse, devise, and catch Kanabec for rent by owner homes, vacation rental Kanabec, and apartments for rent in Kanabec Minnesota.
Look up, find, and dig up rental properties in Pemberton, Pemberton United States vacation rentals, and Pemberton United States homes for rent.
Our webpage can oblige and appoint oceanfront classified ads and suburban indexes beach classifieds, oceanfront classified ads, resort listings, and mountain lists of marked properties to open doors your Grand Rapids Minnesota peregrination.
Recognize and dig up bed and breakfast rentals and bed and breakfast rentals.
Glimpse and come across apartments for rent in Mendota United States and Mendota United States rental apartment.
|
|
