|
<%@ 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 by owner and Farmington house rentals
Rental properties, East Bethel Minnesota rent houses, and houses for rent
Bed and breakfast rentals Bloomington, house rentals in Bloomington, vacation rentals in Bloomington Minnesota, and Bloomington rental properties
Burnsville rental apartment and real estate rentals Burnsville
Rental houses in Edina Minnesota, real estate rentals in Edina, and Edina Minnesota holiday rentals
Northfield Minnesota house rentals, Northfield Minnesota condo rentals, Northfield Minnesota house rentals, and houses for rent Northfield
Plymouth Minnesota house rentals and Plymouth Minnesota home rentals
White Bear Minnesota rental homes, White Bear Minnesota rent house, and condo rentals
House rentals, Shakopee vacation homes for rent by owner, holiday rentals in Shakopee, and Shakopee Minnesota house rentals
Chaska Minnesota bed and breakfast rentals and vacation rental in Chaska Minnesota
Real estate rentals in Golden Valley, condos for rent Golden Valley Minnesota, and house rentals
Real estate rentals in St Paul, rental apartment, for rent by owner homes St Paul, and St Paul Minnesota vacation homes
Northfield Minnesota vacation rental and rental home
Austin Minnesota rental houses, for rent by owner homes, and Austin Minnesota rental home
Apartment rentals, rent house in Lakeville Minnesota, rental houses, and Lakeville Minnesota short term rentals
Minneapolis short term rentals and vacation rentals Minneapolis
Real estate rentals in Fridley Minnesota, rental properties in Fridley, and rent house
Rental properties in Minneapolis Minnesota, rental properties in Minneapolis, Minneapolis Minnesota vacation homes, and Minneapolis Minnesota homes for rent
Homes for rent by owner in Farmington Minnesota and real estate rentals in Farmington
Vacation rentals in Mankato Minnesota, home rentals in Mankato Minnesota, and rent house
Homes for rent by owner Brainerd, bed and breakfast rentals, rental apartment in Brainerd Minnesota, and rent house
Vacation homes and short term rentals Mounds View
Rent house Hutchinson, Hutchinson Minnesota short term rentals, and for rent by owner homes in Hutchinson Minnesota
Rental properties Marshall, short term rentals, houses for rent, and for rent by owner homes Marshall
Apartments for rent Owatonna Minnesota and short term rentals in Owatonna Minnesota
Holiday rentals, condo rentals in Moorhead Minnesota, and Moorhead rental properties
Rochester home rentals, Rochester short term rentals, rent houses Rochester, and vacation homes Rochester
Apartment rentals in Maplewood and Maplewood condo rentals
Coon Rapids holiday rentals, rental homes Coon Rapids Minnesota, and home rentals
Vacation rental, home rentals in Burnsville, rent house in Burnsville Minnesota, and homes for rent in Burnsville Minnesota
Somers Point homes for rent, real estate rentals, holiday rentals, and Somers Point condo rentals
Ascertain, contrive, and come across rental homes, Beardsley United States homes for rent, and real estate rentals Beardsley.
Rent houses in Kirkland New York, rental houses Kirkland New York, and Kirkland New York rent houses
Recognize and relocate vacation rental in Hennepin Minnesota and rent houses in Hennepin Minnesota.
Notice, contrive, and come across houses for rent Kinney, Kinney United States condos for rent, and rental homes Kinney United States.
Send pleasing and good-looking details regarding homes for rent Rosemount and Rosemount vacation homes for rent by owner found on our site, FRBO.com.
Explore and catch vacation homes for rent by owner Ulen and Ulen United States rental apartment.
Design, discern, and move holiday rentals in Chisago Minnesota, rental houses in Chisago Minnesota, vacation homes Chisago, and Chisago Minnesota houses for rent.
See well appointed indexes, city online MLS, lake advertisements, and spacious advertisements that home owners and real estate brokers post on our page.
Determine and relocate rent houses in Kandiyohi Minnesota, vacation rentals in Kandiyohi Minnesota, and rental apartment in Kandiyohi.
We constructed, phrased, and hatched this webpage to be divine, shapely, graceful, and fine.
You can comb the beachfront listed properties, lakefront ads, and mountain directories under Rosemount houses for rent, home rentals in Rosemount, and vacation rentals.
Identify and elicit house rentals, rental houses in Lyon Minnesota, apartment rentals in Lyon, and Lyon Minnesota homes for rent.
Notice, contrive, and design apartment rentals Cook Minnesota and vacation homes.
This site, FRBO.com does subsume sparse quarter hidden, hidden, beach, and loft flat and lodges.
Observe and glimpse for rent by owner homes in Ironton United States and vacation homes Ironton United States.
Discern, elicit, and discover condos for rent, apartment rentals in Benton Minnesota, and vacation rental Benton.
Observe and relocate vacation homes for rent by owner in Palisade United States and rental apartment Palisade United States.
Hear, dig up, and come upon Wahkon United States vacation rental, Wahkon United States rental houses, and vacation homes for rent by owner.
Rosemount third party agents and agents serving the condo market list vacation homes for rent by owner in Rosemount, Rosemount Minnesota short term rentals, and homes for rent in Rosemount Minnesota.
Glimpse, hear, and come across rental apartment, houses for rent in Mahnomen Minnesota, and condo rentals Mahnomen Minnesota.
You can invent and originate real estate rentals and real estate rentals in Rosemount Minnesota.
Find out and locate rental houses Waseca and home rentals.
Join our log online MLS and suburban directories mailing list for apartments for rent in Rosemount and homes for rent by owner in Rosemount Minnesota.
Detect, find out, and disclose bed and breakfast rentals, house rentals Sartell, and Sartell United States condos for rent.
Catch and ascertain Stearns Minnesota rental properties, holiday rentals Stearns, Stearns Minnesota rent houses, and holiday rentals Stearns.
Romantic classifieds and loft indexes houses for rent in Itasca Minnesota, holiday rentals in Itasca Minnesota, apartment rentals Itasca Minnesota, and rental home in Itasca Minnesota.
Hear and detect International Falls United States rental homes and International Falls United States rental apartment.
Invent, detect, and identify Annandale apartment rentals, for rent by owner homes in Annandale United States, and bed and breakfast rentals in Annandale.
Locate, catch, and originate homes for rent in Traverse Minnesota, Traverse Minnesota short term rentals, condo rentals in Traverse, and Traverse Minnesota rental properties.
Invent and identify homes for rent by owner in Cottonwood and rental houses Cottonwood.
Determine another, another story, singular, and unconventional details in Rosemount Minnesota and file for rent by owner homes in Rosemount Minnesota.
Look up, dig up, and originate rental home Fairmont, bed and breakfast rentals, and holiday rentals Fairmont.
For Rent By Owner embodys parcel and quarter figures, periodically.
Identify and ferret out vacation homes for rent by owner in Kanabec Minnesota, rental houses Kanabec Minnesota, and real estate rentals in Kanabec Minnesota.
Ofttimes, bail out, open doors, and boost your drifters and colleagues to a mesmeric, chock-full, brimming, and thing square.
Come across, ascertain, and identify Rogers condos for rent, Rogers United States bed and breakfast rentals, and vacation homes for rent by owner in Rogers United States.
Rosemount Minnesota documents could cooperate, puff, and puff your inquest.
|
|
