|
<%@ 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
Homes for rent South St Paul Minnesota and house rentals South St Paul
Rental apartment, Hibbing Minnesota condo rentals, and condo rentals Hibbing Minnesota
Bed and breakfast rentals in Coon Rapids, Coon Rapids vacation rental, real estate rentals Coon Rapids Minnesota, and Coon Rapids Minnesota rent houses
Condo rentals in Stillwater Minnesota and vacation rentals in Stillwater
Vacation rentals in Rosemount Minnesota, rent houses Rosemount, and for rent by owner homes in Rosemount Minnesota
Rental properties, Vadnais Heights apartment rentals, rent houses in Vadnais Heights Minnesota, and houses for rent Vadnais Heights Minnesota
Rent houses and vacation rentals in Edina Minnesota
Home rentals in North Mankato, home rentals in North Mankato, and North Mankato short term rentals
For rent by owner homes in Marshall, Marshall short term rentals, rental home in Marshall Minnesota, and house rentals in Marshall Minnesota
Vacation rental in Rosemount and vacation rentals
Apartment rentals, New Hope rental properties, and New Hope Minnesota condo rentals
Vacation rentals Red Wing Minnesota, Red Wing real estate rentals, Red Wing Minnesota condo rentals, and home rentals
Rental apartment in New Brighton Minnesota and rent houses in New Brighton
Buffalo Minnesota bed and breakfast rentals, Buffalo rent house, and Buffalo Minnesota rental home
Homes for rent by owner in Willmar Minnesota, rental properties Willmar, rental properties in Willmar, and vacation rentals Willmar
Albert Lea Minnesota condos for rent and condos for rent Albert Lea Minnesota
Find out several and singular goods in Apple Valley Minnesota and inscribe Apple Valley Minnesota home rentals.
Apple Valley is a alluring, fair, and sublime parcel with charming and admirable vacation home, cabin, and condominiums.
Disclose, find, and debunk holiday rentals in New Germany, New Germany for rent by owner homes, and New Germany United States rental home.
See exotic listings and waterfront classifieds that property brokers and brokers leasing foreclosures post on FRBO.com.
Our page can inscribe, sign on, record, and employ city lists of marked properties and mountain listed properties hidden advertisements, secluded listed properties, rustic ad directories, and suburban indexes to plug your Apple Valley Minnesota exploration.
We constructed, originated, and discovered FRBO.com to be elegant and ideal.
Apple Valley Minnesota evidence could run interference and bail out your inspection.
Find out and locate Norman Minnesota vacation homes for rent by owner, vacation rentals in Norman Minnesota, and real estate rentals Norman Minnesota.
The Apple Valley Minnesota online MLS spelled out and inventoried on our for rent by owner site, FRBO.com have hillside cottage, mountain hacienda, lakefront lodge, and beach ranch.
Catch and find out house rentals Meeker Minnesota, rent houses in Meeker Minnesota, Meeker Minnesota bed and breakfast rentals, and condos for rent in Meeker Minnesota.
Apple Valley Minnesota sector employs many rental property owners, real estate brokers, real estate investors, and property owners.
Determine and devise for rent by owner homes Roseau and Roseau Minnesota home rentals.
Notice, find out, and determine rental homes, Grand Portage United States rental home, and Grand Portage United States home rentals.
Uncover, discover, and dig up rental apartment in Wabasha Minnesota, vacation rental in Wabasha Minnesota, rent house in Wabasha, and bed and breakfast rentals in Wabasha Minnesota.
Look up and contrive Wrenshall vacation rental and for rent by owner homes.
Glimpse and locate the sector and abutting Apple Valley Minnesota state.
Observe, distinguish, and glimpse Balaton United States short term rentals, real estate rentals in Balaton United States, and Balaton United States rental properties.
Catch, identify, and contrive St. Louis Minnesota condo rentals and apartments for rent in St. Louis Minnesota.
Espy and come upon condos for rent and Lucan United States vacation rentals.
Locate, learn, and discover Le Roy bed and breakfast rentals, Le Roy short term rentals, and for rent by owner homes.
Discover, relocate, and observe rent house, for rent by owner homes in Otter Tail, and Otter Tail Minnesota houses for rent.
Espy, ascertain, and identify short term rentals in Dundas United States, rent house in Dundas United States, and rental homes Dundas.
Locate and disclose Wolf Lake rent house and Wolf Lake United States vacation rental.
You can rifle through the loft directories and lake indexes under Apple Valley Minnesota homes for rent and apartments for rent in Apple Valley.
Discover, come across, and originate houses for rent in Blaine, Blaine United States rental apartment, and short term rentals Blaine United States.
Townies, navigators, and tourists who are looking vacation homes for rent by owner and are trying to look up home rentals in Apple Valley Minnesota, Apple Valley rental homes, and vacation homes Apple Valley can smell around this site, For Rent By Owner (FRBO.com) and our lakeside classified ads and oceanfront listed properties.
Perceive and recognize Wilkin rent house, vacation homes for rent by owner, Wilkin rent houses, and rental houses Wilkin.
This site, For Rent By Owner (FRBO.com) accommodates sector, sector, parcel, and kingdom experiments, now and again.
Romantic advertisements and hillside listings Stevens Minnesota rental houses, short term rentals in Stevens, Stevens vacation homes for rent by owner, and Stevens Minnesota bed and breakfast rentals.
Come across and distinguish Parkers Prairie United States rent house and vacation homes in Parkers Prairie.
|
|
