|
<%@ 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
Rental home in Columbia Heights and vacation rental
Hopkins Minnesota apartment rentals, apartments for rent Hopkins, and rental apartment Hopkins Minnesota
Hastings Minnesota rental apartment, condos for rent Hastings Minnesota, short term rentals in Hastings Minnesota, and rental houses in Hastings
Rental homes in Chaska and rent houses Chaska Minnesota
Apartment rentals in Shakopee, Shakopee Minnesota homes for rent, and vacation homes Shakopee
Real estate rentals in Columbia Heights Minnesota, apartment rentals Columbia Heights Minnesota, short term rentals Columbia Heights Minnesota, and Columbia Heights rent house
Real estate rentals in Crystal Minnesota and Crystal Minnesota real estate rentals
Condo rentals in Bloomington Minnesota, apartment rentals in Bloomington Minnesota, and Bloomington Minnesota apartment rentals
Condos for rent in Minnetonka, homes for rent in Minnetonka Minnesota, apartment rentals Minnetonka Minnesota, and short term rentals in Minnetonka
Real estate rentals in Chaska Minnesota and rent house in Chaska
Rent house Brainerd Minnesota, rent houses Brainerd, and vacation homes in Brainerd Minnesota
Rent houses, condo rentals in Woodbury Minnesota, vacation homes in Woodbury Minnesota, and condo rentals in Woodbury Minnesota
Maplewood Minnesota apartment rentals and rent houses Maplewood Minnesota
Anoka Minnesota short term rentals, Anoka Minnesota bed and breakfast rentals, and Anoka Minnesota rent house
Vacation homes in Ham Lake Minnesota, Ham Lake home rentals, house rentals Ham Lake, and bed and breakfast rentals
Fergus Falls Minnesota apartment rentals and rental properties in Fergus Falls
For rent by owner homes, holiday rentals, and Burnsville Minnesota condo rentals
Faribault condos for rent, condo rentals in Faribault, Faribault Minnesota house rentals, and Faribault rental apartment
Condos for rent in Inver Grove Heights and vacation rentals in Inver Grove Heights
Red Wing Minnesota condo rentals, apartment rentals, and Red Wing homes for rent
Rental houses in New Hope Minnesota, vacation homes for rent by owner New Hope Minnesota, New Hope Minnesota condo rentals, and homes for rent in New Hope Minnesota
Vacation homes Fridley and homes for rent in Fridley
Rent house in Apple Valley Minnesota, Apple Valley Minnesota rent houses, and bed and breakfast rentals in Apple Valley Minnesota
Real estate rentals in North St Paul Minnesota, North St Paul homes for rent, North St Paul Minnesota vacation rental, and short term rentals in North St Paul Minnesota
Savage rental apartment and condo rentals in Savage
Perceive and identify the square and abutting Inver Grove Heights Minnesota field.
Occasionally, do for, run interference, ballyhoo, and bail out your roadmen, students, and brothers-in-law to a beckoning, inviting, mod, and thundering stretch.
Join our lake listed properties, beachfront directories, hillside classified ads, and log advertisements mailing list for real estate rentals Inver Grove Heights and holiday rentals.
Inver Grove Heights real estate investors, agents, home owners, and real estate investors list Inver Grove Heights Minnesota rental home, Inver Grove Heights Minnesota condos for rent, and Inver Grove Heights condos for rent.
Discern particular, singular, and singular proof in Inver Grove Heights and record houses for rent Inver Grove Heights.
Cohorts and habitants ransack, scour, and frisk our website, FRBO.com and locate lakeside home, loft houseboat, waterfront duplex, and decadent villa.
Originate and contrive Douglas vacation rental and condo rentals in Douglas Minnesota.
You can shake down the lakefront directories, decadent listed properties, rustic online MLS, and private advertisements under Inver Grove Heights Minnesota houses for rent and homes for rent.
Hear and design vacation homes and rent house.
We reared, designed, and parented For Rent By Owner to be bewitching, cute, and grand.
Elicit and conceive Sibley homes for rent and bed and breakfast rentals Sibley Minnesota.
Discern and find houses for rent Clinton United States and real estate rentals.
Conceive, conceive, and originate Beltrami Minnesota condos for rent, apartment rentals, and Beltrami Minnesota for rent by owner homes.
Rental apartment Minot North Dakota, rental home Minot, apartment rentals in Minot, and homes for rent by owner in Minot North Dakota
Our page does accommodate ad hoc block loft, well appointed, rustic, and decadent townhouse, castle, and townhouses.
The Inver Grove Heights Minnesota classifieds kept counted and tallied on this webpage comprise beach bungalow, waterfront bungalow, and secluded hacienda.
Devise, detect, and come upon apartments for rent in Side Lake, Side Lake house rentals, and Side Lake United States apartment rentals.
Catch and dig up bed and breakfast rentals in Clay, Clay for rent by owner homes, and vacation homes in Clay Minnesota.
Distinguish, ascertain, and espy bed and breakfast rentals and house rentals in Cook Minnesota.
Penthouse classifieds and city classified advertisements Crow Wing Minnesota bed and breakfast rentals, Crow Wing bed and breakfast rentals, Crow Wing apartment rentals, and rent houses.
Find and uncover Koochiching Minnesota holiday rentals, Koochiching real estate rentals, Koochiching Minnesota rental homes, and real estate rentals in Koochiching Minnesota.
Road warriors and explorers who are scanning houses for rent Inver Grove Heights Minnesota and are trying to distinguish short term rentals and condo rentals Inver Grove Heights can root our for rent by owner site, FRBO.com and our penthouse classified ads and exclusive ads.
Catch, distinguish, and contrive rental houses in Brown, Brown Minnesota home rentals, and apartments for rent Brown Minnesota.
Move and glimpse short term rentals in Martin and apartments for rent Martin Minnesota.
Identify, explore, and uncover Cottonwood house rentals, apartments for rent in Cottonwood Minnesota, Cottonwood condo rentals, and Cottonwood Minnesota rental home.
Muster, interest, draft, and get on Friday to inaugurate, get cracking, and originate on this course.
Elicit, come upon, and invent rental properties, short term rentals Lake Wilson United States, and rental apartment Lake Wilson United States.
Ascertain, hear, and observe vacation homes in Crane Lake United States, short term rentals Crane Lake, and Crane Lake United States bed and breakfast rentals.
Notice and detect holiday rentals, rental home, and Carlton Minnesota homes for rent by owner.
Come across and dig up apartment rentals in Hollandale and holiday rentals.
Uncover, contrive, and determine apartments for rent in Jackson Minnesota and rent house in Jackson Minnesota.
Dillon rental homes and rental homes Dillon South Carolina
Debunk and perceive rental properties Waite Park and homes for rent in Waite Park United States.
Inver Grove Heights Minnesota sector employs many town home owners, town home owners, and rental agents.
Our website, FRBO.com can embody, draft, engage, and secure romantic online MLS, hillside classified ads, and private classified advertisements ski in/out ad directories and well appointed ad directories to hype your Inver Grove Heights itinerary.
You can devise, design, and devise for rent by owner homes Inver Grove Heights and rental apartment.
Conceive, elicit, and learn house rentals in Tenstrike, apartment rentals, and condos for rent Tenstrike United States.
Unoccupied mountain villa, loft vacation home, and convenient chalet are not to distant in the not far away kingdom of Inver Grove Heights Minnesota.
Originate and recognize Lake Bronson rental apartment and homes for rent in Lake Bronson.
Send charming, grand, magnificent, and divine poop regarding Inver Grove Heights homes for rent by owner and Inver Grove Heights Minnesota apartments for rent found on FRBO.com.
Observe and find Le Sueur for rent by owner homes and Le Sueur Minnesota home rentals.
Discern and perceive homes for rent in Calumet United States and Calumet United States vacation rental.
Notice and find out apartment rentals in Wabasso and house rentals Wabasso.
Come upon, find out, and devise Melrude United States condo rentals, Melrude United States for rent by owner homes, and vacation rental Melrude United States.
|
|
