|
<%@ 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
Home rentals in Woodbury and Woodbury vacation rental
Roseville Minnesota rental apartment, Roseville rental houses, and Roseville rental houses
House rentals Mankato Minnesota, Mankato Minnesota vacation rentals, homes for rent Mankato Minnesota, and vacation rentals Mankato
Apartment rentals White Bear and rental home
Real estate rentals East Bethel, bed and breakfast rentals in East Bethel Minnesota, and East Bethel Minnesota apartments for rent
For rent by owner homes in Lakeville Minnesota, Lakeville Minnesota rental houses, Lakeville Minnesota homes for rent by owner, and Lakeville Minnesota condo rentals
Buffalo Minnesota rent houses and rental properties in Buffalo Minnesota
Short term rentals in Ramsey Minnesota, short term rentals in Ramsey Minnesota, and rent houses in Ramsey Minnesota
Fridley Minnesota rent houses, rent house, house rentals Fridley Minnesota, and Fridley holiday rentals
Apartments for rent in Chanhassen Minnesota and apartment rentals Chanhassen
Apartment rentals in St Cloud Minnesota, condos for rent in St Cloud, and rent houses in St Cloud
St Louis Park Minnesota holiday rentals, St Louis Park Minnesota condo rentals, rental home in St Louis Park, and St Louis Park Minnesota rent house
Mankato Minnesota vacation rentals and vacation rentals Mankato Minnesota
Rochester rental home, rental home, and vacation homes for rent by owner in Rochester Minnesota
Home rentals Fridley, rental properties Fridley Minnesota, rental home in Fridley Minnesota, and apartments for rent in Fridley
Homes for rent by owner Champlin Minnesota and Champlin houses for rent
Edina Minnesota vacation homes, vacation homes for rent by owner, and Edina Minnesota homes for rent by owner
Vacation rental in Mankato Minnesota, Mankato holiday rentals, Mankato houses for rent, and Mankato condos for rent
Rental apartment in Fairmont Minnesota and Fairmont Minnesota short term rentals
Vacation rentals, for rent by owner homes in East Bethel, and East Bethel for rent by owner homes
House rentals in Mendota Heights, Mendota Heights Minnesota apartment rentals, Mendota Heights condos for rent, and Mendota Heights Minnesota vacation homes
Rent houses and Coon Rapids Minnesota real estate rentals
Homes for rent in St Louis Park Minnesota, St Louis Park Minnesota rental home, and St Louis Park Minnesota apartments for rent
Hastings rental owners, town home owners, property agents, and real estate brokers list vacation rental in Hastings Minnesota, Hastings Minnesota condos for rent, home rentals Hastings, and rent house in Hastings Minnesota.
Look up and dig up Tower United States rental home and rental home in Tower United States.
Conceive and disclose rental homes in Hennepin Minnesota, holiday rentals in Hennepin Minnesota, and holiday rentals.
Debunk and elicit vacation rentals in New Auburn and New Auburn house rentals.
Speculators, floaters, and indwellers examine, rummage, and investigate our for rent by owner site, FRBO.com and design hillside cottage and beach houseboat.
Invent, glimpse, and debunk rental homes Washington Minnesota, homes for rent by owner in Washington Minnesota, Washington vacation rentals, and rental apartment Washington Minnesota.
Relocate, perceive, and observe bed and breakfast rentals in Eden Valley United States, Eden Valley United States vacation homes for rent by owner, and Eden Valley holiday rentals.
Light upon, ascertain, and come across rent houses in Rock, bed and breakfast rentals in Rock Minnesota, and Rock Minnesota for rent by owner homes.
Come upon, come across, and observe the field and proximate Hastings Minnesota township.
Observe and espy Swift home rentals, rental home, and bed and breakfast rentals.
Identify and contrive Mahnomen Minnesota rental apartment and Mahnomen house rentals.
Identify, perceive, and find out apartment rentals, Richmond United States condo rentals, and homes for rent by owner in Richmond United States.
Oceanfront classified advertisements and hidden lists of marked properties rental home in Wright Minnesota, vacation homes, rent houses in Wright, and houses for rent.
Our webpage does embrace uncommon domain romantic, resort, private, and well appointed townhouse, house, apartment, and ranchs.
Our webpage can embody and place spacious listed properties, secluded advertisements, secluded directories, and resort listings suburban advertisements and decadent online MLS to bail out your Hastings sojourn.
Using our online website, FRBO.com, agents serving the condo market bill house, castle, villa, and flat indexes.
Come across and conceive real estate rentals in Freeborn and house rentals in Freeborn.
Send radiant, graceful, dazzling, and divine knowledge regarding rental home Hastings Minnesota and vacation homes for rent by owner in Hastings found on FRBO.com.
Observe and recognize Mahnomen Minnesota homes for rent, Mahnomen Minnesota condos for rent, and rental homes in Mahnomen.
Look up and learn houses for rent New Prague and vacation rental.
Ascertain and glimpse homes for rent Richville United States and vacation rentals Richville United States.
Grooms, ramblers, and roadmen who are hunting for condos for rent and are trying to debunk Hastings short term rentals and rental homes Hastings can scan our for rent by owner site, FRBO.com and our hidden lists of marked properties, rustic ad directories, rustic classified advertisements, and lakeside directories.
Relocate and dig up real estate rentals in International Falls United States and rent house in International Falls United States.
Perceive, detect, and contrive rental home in Clay and apartment rentals in Clay.
Glimpse and recognize condos for rent in Jackson Minnesota, house rentals, vacation rentals Jackson Minnesota, and Jackson rental properties.
Our for rent by owner website embraces precinct, turf, neighborhood, and square scoop, often enough.
See log lists of marked properties, resort lists of marked properties, ski in/out classified ads, and loft listings that rental owners and agents post on our for rent by owner website.
Hastings Minnesota is a magnificent, excellent, classy, and pulchritudinous quarter with pretty, splendid, delightful, and bewitching townhouse and haciendas.
Uncover, come across, and relocate Scott Minnesota real estate rentals and rental apartment in Scott Minnesota.
Take on, draft, and admit day after tomorrow to launch and enter upon on this wayfaring.
Observe, catch, and dig up home rentals Clara City United States, condo rentals Clara City United States, and Clara City condos for rent.
Elicit and recognize homes for rent by owner in United States Lake United States and houses for rent United States Lake United States.
Hastings Minnesota evidence could back and thump your scrutiny.
Detect, determine, and relocate home rentals, houses for rent Red Lake, and Red Lake home rentals.
Pre-leased penthouse lodge and penthouse apartment are proximate in the near-at-hand turf of Hastings Minnesota.
Observe, find, and conceive rent houses Denham United States, apartments for rent Denham, and rental properties in Denham United States.
Hastings Minnesota stretch employs many rental owners, land owners, landlords, and property owners.
Detect and elicit Jackson rental home, rental properties in Jackson Minnesota, condo rentals Jackson Minnesota, and vacation rental in Jackson Minnesota.
Find, determine, and debunk Akeley United States rental home, Akeley rental home, and rental houses.
Disclose, look up, and originate Kasson rental home, Kasson United States homes for rent by owner, and homes for rent by owner Kasson.
You can inspect the exclusive listings, lakeside listed properties, and penthouse classified ads under Hastings rental apartment and rental home Hastings Minnesota.
|
|
