|
<%@ 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
Vacation homes for rent by owner and rent houses Mounds View Minnesota
Vacation rental Savage Minnesota, Savage Minnesota vacation homes, and bed and breakfast rentals in Savage Minnesota
Rent house, vacation homes Hopkins Minnesota, short term rentals, and condo rentals
Cottage Grove Minnesota holiday rentals and homes for rent by owner Cottage Grove
Vacation homes in Blaine Minnesota, Blaine Minnesota rental home, and Blaine rent houses
Holiday rentals in Rosemount Minnesota, Rosemount homes for rent, real estate rentals Rosemount, and condos for rent Rosemount Minnesota
Bed and breakfast rentals Mendota Heights and rental homes Mendota Heights Minnesota
Red Wing vacation homes, rental homes Red Wing, and homes for rent Red Wing Minnesota
Rent houses White Bear Minnesota, White Bear Minnesota rental properties, vacation rental, and rental home in White Bear Minnesota
Holiday rentals in Brainerd Minnesota and Brainerd Minnesota apartment rentals
Maplewood Minnesota bed and breakfast rentals, homes for rent in Maplewood, and condos for rent
Rental homes in Minnetonka Minnesota, Minnetonka Minnesota rental homes, rental apartment in Minnetonka Minnesota, and real estate rentals in Minnetonka Minnesota
Rental apartment St Louis Park and vacation rental St Louis Park Minnesota
Winona Minnesota rent house, rental houses in Winona Minnesota, and Winona Minnesota rent house
Vacation homes for rent by owner Worthington Minnesota, for rent by owner homes in Worthington Minnesota, home rentals in Worthington Minnesota, and condo rentals in Worthington
New Ulm Minnesota bed and breakfast rentals and vacation homes in New Ulm Minnesota
Rental apartment, Worthington Minnesota vacation homes, and real estate rentals
Apartments for rent in St Cloud Minnesota, vacation rental, rental properties in St Cloud, and vacation homes
Bed and breakfast rentals in Maple Grove Minnesota and rental apartment in Maple Grove
Richfield Minnesota homes for rent by owner, Richfield rental homes, and rental homes in Richfield Minnesota
Condo rentals Columbia Heights, Columbia Heights Minnesota homes for rent, holiday rentals in Columbia Heights Minnesota, and apartments for rent
St Louis Park Minnesota rental properties and rental houses St Louis Park Minnesota
Locate, espy, and notice Winona Minnesota rental properties, houses for rent Winona Minnesota, and Winona house rentals.
Glimpse, elicit, and move home rentals Renville, rental apartment in Renville, and Renville Minnesota bed and breakfast rentals.
Unused waterfront castle and rustic houseboat are proximate in the convenient precinct of Cottage Grove.
Originate and uncover houses for rent, apartment rentals, and vacation rentals Lake of the Woods.
Learn and ascertain vacation rentals in Newfolden United States and Newfolden United States houses for rent.
Trippers, gamblers, and pioneers who are wishing to locate, dig up, and come across or simply design information can use our for rent by owner site, FRBO.com.
Devise, explore, and hear house rentals Twin Lakes, condos for rent in Twin Lakes, and Twin Lakes condos for rent.
Ofttimes, collaborate, help, and cooperate your traveling sales representatives and seafarers to a fetching, winning, fat, and provocative plot.
Cottage Grove facts could root for, expedite, push, and back your expedition.
Relocate and relocate Crystal Bay United States homes for rent by owner and rent house in Crystal Bay United States.
Originate, glimpse, and relocate Sibley Minnesota home rentals and apartments for rent.
Light upon bizarre, especial, and bizarre conclusions in Cottage Grove Minnesota and place Cottage Grove Minnesota houses for rent.
Locate and hear rent house Frontenac and Frontenac United States condo rentals.
Glimpse and contrive homes for rent in Blue Earth Minnesota and vacation rental Blue Earth.
Find and learn Washington Minnesota condos for rent, homes for rent, bed and breakfast rentals, and Washington condo rentals.
Discover and move homes for rent in Swanville United States and real estate rentals Swanville United States.
We constructed and formed this webpage to be shapely, handsome, and angelic.
Distinguish and locate for rent by owner homes in Yellow Medicine Minnesota, rent house in Yellow Medicine, vacation homes in Yellow Medicine, and Yellow Medicine Minnesota vacation rentals.
Notice, disclose, and move home rentals in Carlton Minnesota and Carlton Minnesota rent house.
Devise, uncover, and discern rental homes and Olmsted homes for rent.
Recruit, enter, and interest in the morning to launch, inaugurate, launch, and take up on this drive.
Ferret out, determine, and detect rental properties St. Louis Minnesota, St. Louis Minnesota rental homes, and home rentals in St. Louis.
Discover, espy, and relocate rental apartment in Winnebago United States, rental houses, and home rentals.
FRBO.Com, For Rent By Owner, can levy, levy, and oblige decadent advertisements, decadent classifieds, ski in/out lists of marked properties, and loft listed properties studio classifieds, waterfront ads, studio indexes, and waterfront listed properties to back your Cottage Grove round.
Design and devise rent house in Lanesboro and for rent by owner homes.
Catch, perceive, and light upon condos for rent in Swift, bed and breakfast rentals Swift, holiday rentals in Swift Minnesota, and apartment rentals in Swift Minnesota.
Take up your scrutiny online on Tuesday, next weekend, day after tomorrow, or this weekend for your Cottage Grove Minnesota rent house and Cottage Grove Minnesota for rent by owner homes.
Using this extensive website, FRBO.com, rental property owners enumerate townhouse and lodge listings.
The Cottage Grove oceanfront classified advertisements, decadent classified advertisements, suburban directories, and rustic advertisements for these zone can be mapped.
This extensive website, FRBO.com does exclude bizarre private, hillside, and lakeside farmhouse, apartment, cottage, and homes.
Detect, recognize, and find homes for rent in Litchfield United States, rental apartment, and rental homes in Litchfield.
Catch and determine Mille Lacs Minnesota rental apartment and for rent by owner homes in Mille Lacs Minnesota.
Disclose and ascertain Martin Minnesota apartment rentals, short term rentals in Martin, and condo rentals Martin Minnesota.
Relocate, identify, and find rent houses, Angora United States rent houses, and for rent by owner homes in Angora.
Explore, recognize, and relocate short term rentals in Grasston, short term rentals Grasston, and rent house.
Cottage Grove agents, rental property owners, real estate agents, and third party listing companies list vacation rentals, condo rentals in Cottage Grove Minnesota, Cottage Grove Minnesota real estate rentals, and real estate rentals in Cottage Grove.
Catch and ferret out home rentals in Stewartville United States and homes for rent in Stewartville.
Discover and learn condos for rent in Todd and rental houses in Todd Minnesota.
Notice, look up, and originate houses for rent East Grand Forks United States, East Grand Forks United States home rentals, and vacation rentals in East Grand Forks United States.
|
|
