|
<%@ 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 rentals Eden Prairie and holiday rentals Eden Prairie
Rental home in Faribault Minnesota, rental houses in Faribault Minnesota, and rent houses in Faribault Minnesota
Homes for rent by owner Brainerd Minnesota, rent house in Brainerd, condo rentals in Brainerd Minnesota, and rental homes Brainerd
Columbia Heights Minnesota condos for rent and Columbia Heights Minnesota condo rentals
Homes for rent by owner in Mounds View Minnesota, rental houses in Mounds View Minnesota, and Mounds View Minnesota real estate rentals
South St Paul Minnesota houses for rent, rent houses, rental home, and homes for rent in South St Paul Minnesota
Holiday rentals in Winona Minnesota and holiday rentals in Winona Minnesota
Apartment rentals in Cottage Grove, condo rentals in Cottage Grove, and for rent by owner homes in Cottage Grove
Sauk Rapids condos for rent, Sauk Rapids Minnesota apartment rentals, homes for rent by owner Sauk Rapids, and vacation homes in Sauk Rapids Minnesota
Albert Lea Minnesota homes for rent and house rentals Albert Lea
Real estate rentals in Bloomington Minnesota, Bloomington rental homes, and Bloomington Minnesota homes for rent
Short term rentals in East Bethel, short term rentals in East Bethel Minnesota, homes for rent East Bethel, and East Bethel Minnesota rental apartment
Mankato apartment rentals and rental properties Mankato Minnesota
Prior Lake apartments for rent, house rentals Prior Lake, and Prior Lake Minnesota holiday rentals
Vacation rentals, real estate rentals East Bethel, East Bethel Minnesota homes for rent, and rental homes
Bemidji Minnesota bed and breakfast rentals and short term rentals
Rent houses Chaska Minnesota, bed and breakfast rentals in Chaska Minnesota, and real estate rentals in Chaska Minnesota
New Brighton Minnesota rental properties, home rentals in New Brighton Minnesota, vacation homes New Brighton Minnesota, and rental houses
Condo rentals in Fridley Minnesota and rental home in Fridley Minnesota
House rentals Maple Grove, Maple Grove Minnesota homes for rent by owner, and Maple Grove holiday rentals
House rentals in Eden Prairie Minnesota, Eden Prairie Minnesota condo rentals, condos for rent Eden Prairie Minnesota, and rent house
House rentals Eden Prairie Minnesota and short term rentals in Eden Prairie Minnesota
Vacation homes Bloomington, rental apartment Bloomington Minnesota, and Bloomington rental properties
Bed and breakfast rentals in New Hope, homes for rent by owner in New Hope Minnesota, condos for rent New Hope Minnesota, and New Hope Minnesota holiday rentals
Bed and breakfast rentals Mankato and Mankato vacation rental
Rent houses, rental homes, and real estate rentals in Brainerd Minnesota
Brooklyn Park Minnesota houses for rent, Brooklyn Park Minnesota houses for rent, house rentals in Brooklyn Park Minnesota, and rental home in Brooklyn Park Minnesota
Rent houses Rosemount Minnesota and rent house Rosemount Minnesota
Beachwood New Jersey homes for rent by owner and rent houses
Find, relocate, and relocate Nobles Minnesota home rentals, houses for rent in Nobles Minnesota, rent houses in Nobles, and Nobles Minnesota short term rentals.
Explore and determine house rentals in Winona Minnesota and Winona home rentals.
Come across, ascertain, and hear rental homes in Marshall, Marshall Minnesota rental houses, and Marshall Minnesota condos for rent.
Find out and design homes for rent Carlton, rental houses in Carlton Minnesota, and vacation homes for rent by owner in Carlton Minnesota.
Dig up, come upon, and ascertain rental home Mizpah United States, Mizpah United States for rent by owner homes, and rent house in Mizpah United States.
Using our for rent by owner website, property owners tick off houseboat and home lists of marked properties.
FRBO.com does comprise particular turf city, well appointed, and decadent apartment, houseboat, cottage, and ranchs.
Join our loft ads, waterfront ad directories, spacious listings, and romantic indexes mailing list for home rentals in North Mankato Minnesota and home rentals North Mankato.
Observe, contrive, and catch Lafayette United States real estate rentals, vacation rental in Lafayette United States, and Lafayette United States condo rentals.
Hear, elicit, and espy house rentals in Rushmore United States, homes for rent by owner, and Rushmore United States vacation rentals.
Devise and devise Mahnomen Minnesota rental apartment and vacation homes Mahnomen Minnesota.
Icard North Carolina bed and breakfast rentals, Icard holiday rentals, homes for rent Icard North Carolina, and Icard rental apartment
Discern and detect Cottonwood rent house, rental apartment Cottonwood Minnesota, and Cottonwood Minnesota holiday rentals.
Homes for rent by owner Fruita Colorado, Fruita Colorado vacation rentals, and Fruita Colorado real estate rentals
Come across, look up, and originate houses for rent Blue Earth Minnesota and Blue Earth Minnesota house rentals.
Ascertain, conceive, and discern rental homes in New Germany United States, rent house in New Germany United States, and New Germany United States homes for rent by owner.
Find novel, unique, and something else circumstances in North Mankato Minnesota and chart homes for rent in North Mankato Minnesota.
Identify and hear Scott Minnesota vacation homes, Scott short term rentals, rental properties in Scott Minnesota, and real estate rentals Scott Minnesota.
List and register tomorrow to open and launch on this round.
You can debunk, recognize, and come upon North Mankato Minnesota bed and breakfast rentals, rent house North Mankato, and rent house North Mankato.
Move, determine, and find out condos for rent Henriette United States, home rentals in Henriette, and Henriette United States real estate rentals.
Perceive, observe, and uncover rent house in Crow Wing Minnesota, real estate rentals in Crow Wing Minnesota, Crow Wing Minnesota condo rentals, and apartment rentals Crow Wing.
Espy and find out condo rentals in Villard United States and Villard United States apartment rentals.
Uncover and look up short term rentals Tintah and Tintah United States homes for rent by owner.
Look up and move rental home in Goodhue, Goodhue vacation rental, Goodhue Minnesota vacation homes for rent by owner, and Goodhue vacation rental.
Secluded classified advertisements and romantic lists of marked properties holiday rentals in Grant Minnesota, apartment rentals in Grant Minnesota, condos for rent, and Grant vacation rental.
North Mankato square employs many rental property owners, real estate brokers, and land owners.
Stratford Connecticut rental properties, Stratford Connecticut rent house, Stratford Connecticut vacation homes for rent by owner, and condos for rent
Send pleasing, radiant, and stunning goods regarding North Mankato vacation rental, North Mankato Minnesota rental homes, and condo rentals in North Mankato Minnesota found on this website, FRBO.com.
North Mankato reports could serve, puff, and sustain your research.
|
|
