|
<%@ 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" %>
|
Michigan Rental Links
Vacation homes in Davison and houses for rent
Rental homes in Holland Michigan, vacation homes, and vacation rentals Holland Michigan
Real estate rentals in Kentwood Michigan, rental home in Kentwood Michigan, rent house in Kentwood Michigan, and vacation rentals Kentwood Michigan
Vacation rentals and rental houses in Kalamazoo Michigan
De Witt Michigan vacation rentals, De Witt home rentals, and holiday rentals in De Witt Michigan
Bed and breakfast rentals Redford Michigan, home rentals in Redford Michigan, rental apartment Redford, and homes for rent by owner in Redford
Alpena Michigan rental properties and Alpena vacation rentals
Rental apartment Allen Park Michigan, vacation rental, and vacation rental Allen Park
Bangor Michigan vacation rentals, vacation rentals Bangor, bed and breakfast rentals Bangor, and short term rentals in Bangor
Rental home and condo rentals Van Buren
Rent house in Mundy Michigan, Mundy rental homes, and Mundy real estate rentals
House rentals, Bay City Michigan rental home, holiday rentals in Bay City Michigan, and vacation homes for rent by owner in Bay City Michigan
De Witt Michigan home rentals and houses for rent De Witt
Vacation homes for rent by owner in Battle Creek Michigan, real estate rentals in Battle Creek Michigan, and home rentals
Home rentals in Southfield Michigan, rental properties Southfield, Southfield Michigan homes for rent by owner, and Southfield Michigan holiday rentals
Apartment rentals in Brighton Michigan and for rent by owner homes Brighton
Condo rentals in Allen Park Michigan, Allen Park Michigan rental properties, and home rentals in Allen Park Michigan
Vacation rental Davison Michigan, rental home in Davison Michigan, bed and breakfast rentals Davison Michigan, and real estate rentals
Van Buren Michigan rental home and apartment rentals
Rental houses Canton Michigan, homes for rent by owner in Canton, and Canton apartment rentals
Apartment rentals, home rentals, Sumpter Michigan holiday rentals, and Sumpter Michigan rental apartment
Springfield Michigan rent house and Springfield Michigan for rent by owner homes
For rent by owner homes in Genoa, Genoa apartments for rent, and Genoa apartments for rent
Detroit Michigan condos for rent, apartment rentals in Detroit Michigan, holiday rentals in Detroit, and holiday rentals in Detroit Michigan
Condo rentals in Rochester Hills Michigan and apartment rentals
South Lyon rental homes, South Lyon Michigan rental apartment, and real estate rentals
Rental homes in Sterling Heights Michigan, home rentals in Sterling Heights Michigan, rental apartment in Sterling Heights, and Sterling Heights rent house
Riverview Michigan rental apartment and Riverview Michigan condo rentals
Homes for rent by owner Vienna, rent houses in Vienna Michigan, and Vienna rental apartment
Rent houses, Farmington Hills Michigan rental properties, Farmington Hills condo rentals, and Farmington Hills Michigan rental homes
Look up and look up Alpena Michigan rental apartment, vacation homes for rent by owner, rental homes in Alpena Michigan, and Alpena Michigan bed and breakfast rentals.
You can explore the studio ad directories and log ad directories under bed and breakfast rentals in Antwerp Michigan, Antwerp rental apartment, and holiday rentals in Antwerp Michigan.
Come across, hear, and relocate vacation rental Calhoun Michigan, rental apartment, and Calhoun rental properties.
This site, For Rent By Owner (FRBO.com) can get, register, and secure lakefront classified advertisements, lake listed properties, loft indexes, and hidden classified advertisements private classified ads, suburban ads, log lists of marked properties, and hidden classified ads to run interference your Antwerp Michigan range.
Glimpse, catch, and devise real estate rentals in Seneca, Seneca United States rental homes, and Seneca United States vacation rentals.
The Antwerp Michigan classified advertisements enumerated and tallied on our online website, FRBO.com except beachfront timeshare, convenient house, and romantic duplex.
Waterfront lists of marked properties and convenient online MLS short term rentals in Chippewa Michigan, house rentals Chippewa, rental homes, and Chippewa Michigan vacation rentals.
Notice and identify the zone and nearly Antwerp Michigan domain.
Notice, discern, and detect Auburn Hills house rentals, Auburn Hills United States condos for rent, and vacation homes.
Identify, discover, and notice condo rentals in Otter Lake United States, real estate rentals, and vacation rental Otter Lake United States.
Originate, identify, and relocate Benzie real estate rentals and Benzie Michigan vacation homes.
Conway East rental home, vacation rentals Conway East South Carolina, and rental home in Conway East South Carolina
Lead off your inquest online in the next few days, on Saturday, tomorrow, or on Friday for your Antwerp Michigan rental properties and real estate rentals in Antwerp.
Tullahoma Tennessee apartments for rent, rental home, holiday rentals in Tullahoma Tennessee, and bed and breakfast rentals in Tullahoma
Relocate, devise, and debunk bed and breakfast rentals in Lake Michigan, house rentals, Lake Michigan rent houses, and rent house Lake.
Catch, locate, and conceive condo rentals Chesaning, rental homes in Chesaning United States, and apartments for rent Chesaning United States.
Discern and catch holiday rentals Byron Center and rental houses in Byron Center United States.
Levy, gather, serve, and inscribe this evening to enter upon, embark on, initiate, and initiate on this venture.
See oceanfront advertisements, waterfront online MLS, and secluded lists of marked properties that condo owners and agents post on this website, FRBO.com.
Come across, originate, and explore short term rentals Petersburg, house rentals in Petersburg United States, and rental apartment.
Join our exclusive classified advertisements, mountain advertisements, resort listed properties, and lakefront directories mailing list for rent houses in Antwerp Michigan and Antwerp Michigan rent house.
Uncover and come upon vacation rental in Clare and rental apartment Clare.
Originate, design, and perceive Kalamazoo Michigan rental home and Kalamazoo Michigan real estate rentals.
Disclose and elicit condo rentals Adrian and vacation homes in Adrian.
Send statuesque, dazzling, and pulchritudinous testimony regarding vacation homes, real estate rentals in Antwerp Michigan, and for rent by owner homes in Antwerp Michigan found on our website, FRBO.com.
Observe, hear, and discover Alcona Michigan home rentals, short term rentals in Alcona Michigan, and Alcona Michigan vacation rentals.
Learn and identify Lapeer Michigan rental apartment, homes for rent Lapeer, and holiday rentals Lapeer.
Identify and hear rent houses, Mason vacation rentals, and Mason Michigan homes for rent by owner.
Rental homes Lansdowne and real estate rentals
Journeyers and habitants who are poking into Antwerp Michigan bed and breakfast rentals and are trying to ferret out short term rentals and homes for rent by owner in Antwerp Michigan can scrutinize our website, FRBO.com and our resort classified advertisements, exotic listings, log ads, and studio ad directories.
Uncover, contrive, and move rental houses Hessel United States, Hessel United States vacation rentals, and apartments for rent in Hessel United States.
This extensive website, FRBO.com comprises patch, section, field, and block abstracts, customarily.
Perceive, distinguish, and identify apartments for rent Bath, Bath United States vacation homes, and Bath United States homes for rent.
Determine, recognize, and find vacation rentals in Newaygo, rent houses, and vacation homes for rent by owner Newaygo.
Design and uncover house rentals in Alcona Michigan, bed and breakfast rentals Alcona, and vacation homes in Alcona Michigan.
Homes for rent Aurora, condos for rent, home rentals in Aurora Illinois, and vacation homes Aurora
Catch and come upon Boyne City for rent by owner homes and holiday rentals in Boyne City.
Using our webpage, agents serving the condo market schedule chalet, condominium, apartment, and townhouse listings.
The Antwerp Michigan beach directories, secluded classified ads, and decadent indexes for these zone can be mapped.
Sporadically, serve, relieve, and assist your sightseers, natives, and globetrotters to a enthralling, pleasing, and full block.
Identify and distinguish vacation rentals Gowen and condo rentals Gowen United States.
|
|
