|
<%@ 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
Real estate rentals Lincoln charter and homes for rent by owner Lincoln charter
House rentals in Kalamazoo, rental homes, and Kalamazoo Michigan vacation rentals
Homes for rent in Allen Park Michigan, condo rentals Allen Park, Allen Park Michigan vacation homes, and house rentals Allen Park
Rental properties in Ypsilanti Michigan and Ypsilanti Michigan rental properties
Bed and breakfast rentals Vienna, home rentals Vienna, and Vienna Michigan bed and breakfast rentals
House rentals in Wyoming Michigan, vacation homes for rent by owner in Wyoming Michigan, home rentals, and Wyoming Michigan vacation rental
Clinton houses for rent and vacation rentals in Clinton Michigan
Big Rapids Michigan rental apartment, vacation rental Big Rapids, and Big Rapids for rent by owner homes
House rentals Fenton Michigan, vacation rentals in Fenton, vacation rental in Fenton, and homes for rent by owner Fenton
Genesee Michigan vacation rentals and Genesee vacation homes
For rent by owner homes in Muskegon Heights, condo rentals in Muskegon Heights Michigan, and Muskegon Heights Michigan real estate rentals
Condo rentals, vacation homes Coldwater, condo rentals Coldwater, and Coldwater Michigan rent house
Wyandotte Michigan rental properties and houses for rent in Wyandotte Michigan
Homes for rent by owner Thomas, Thomas Michigan bed and breakfast rentals, and Thomas Michigan apartments for rent
Rental apartment in Hazel Park, Hazel Park Michigan short term rentals, rental homes Hazel Park Michigan, and homes for rent by owner in Hazel Park Michigan
St Clair Shores Michigan homes for rent by owner and rental properties St Clair Shores
Short term rentals Grand Rapids charter, homes for rent in Grand Rapids charter Michigan, and apartments for rent in Grand Rapids charter Michigan
Homes for rent, Monroe charter Michigan holiday rentals, Monroe charter Michigan house rentals, and vacation homes
Southgate Michigan real estate rentals and Southgate Michigan for rent by owner homes
Canton Michigan home rentals, condo rentals in Canton Michigan, and vacation rentals in Canton Michigan
Real estate rentals in Shelby charter Michigan, holiday rentals in Shelby charter Michigan, Shelby charter bed and breakfast rentals, and rental homes Shelby charter
Vacation rentals Ypsilanti Michigan and Ypsilanti Michigan rental houses
Homes for rent Huron charter, apartment rentals Huron charter, and rental home Huron charter
Farmington Michigan condo rentals, Farmington vacation rentals, Farmington rental properties, and home rentals Farmington
Vacation homes in Highland Park Michigan and houses for rent in Highland Park Michigan
Muskegon apartment rentals, Muskegon Michigan rental houses, and house rentals in Muskegon
Kentwood Michigan vacation rentals, Kentwood Michigan homes for rent by owner, homes for rent by owner in Kentwood Michigan, and vacation homes for rent by owner in Kentwood
Midland short term rentals and Midland homes for rent by owner
Ecorse Michigan homes for rent by owner, vacation rentals in Ecorse Michigan, and Ecorse Michigan homes for rent by owner
Homes for rent in Birmingham, Birmingham Michigan rental properties, Birmingham Michigan vacation rental, and Birmingham Michigan house rentals
Rental properties Thomas and Thomas Michigan homes for rent by owner
For rent by owner homes Madison Heights, vacation homes for rent by owner in Madison Heights, and Madison Heights Michigan vacation homes for rent by owner
Rental homes East Grand Rapids Michigan and rental home
Come upon, look up, and design home rentals Coldwater United States, holiday rentals, and rental homes in Coldwater.
Determine and contrive Oakland United States rental houses and rental properties Oakland.
Sisters-in-law and journeyers who are inspecting rental houses in Spring Lake Michigan and are trying to come across Spring Lake Michigan rental apartment, apartments for rent Spring Lake, and Spring Lake condos for rent can ferret our for rent by owner site, FRBO.com and our resort indexes, waterfront indexes, and romantic ad directories.
Find and ascertain homes for rent in Adrian and Adrian rental properties.
Design another story, several, and some facts in Spring Lake and calendar Spring Lake Michigan home rentals.
Perceive and design house rentals in Milford United States and rent houses in Milford.
Design, disclose, and come across short term rentals in Presque Isle and condo rentals in Presque Isle.
Condo rentals, Capital homes for rent by owner, rental home, and homes for rent
Ascertain and notice short term rentals in Wayne Michigan and Wayne Michigan home rentals.
Identify and originate homes for rent by owner in Amasa United States and Amasa condo rentals.
Glimpse and come across real estate rentals Carsonville and Carsonville United States vacation homes for rent by owner.
Observe and perceive rental properties Otsego and house rentals in Otsego.
Catch, devise, and elicit apartments for rent, house rentals in St. Joseph Michigan, and St. Joseph Michigan vacation homes for rent by owner.
Find out and find Cornell apartments for rent and Cornell rental home.
Look up, learn, and notice rental houses, holiday rentals in Cheboygan, Cheboygan Michigan for rent by owner homes, and rent houses in Cheboygan.
York condo rentals, York houses for rent, house rentals in York, and York Illinois rental home
Bed and breakfast rentals in Navasota Texas and rental houses in Navasota
Invent, discover, and light upon rental properties in Hillsdale Michigan and for rent by owner homes in Hillsdale Michigan.
Using our for rent by owner website, brokers leasing foreclosures register farmhouse, house, vacation home, and home lists of marked properties.
Valley Center California holiday rentals, Valley Center California rental apartment, short term rentals in Valley Center California, and Valley Center California homes for rent by owner
Spring Lake dominion employs many town home owners, third party listing companies, brokers leasing foreclosures, and home owners.
Spring Lake Michigan is a gorgeous, shapely, magnificent, and exquisite state with fine, sublime, nice, and well-formed bungalow and farmhouses.
Observe and debunk home rentals in Allen Park United States and Allen Park United States vacation rentals.
Design and observe holiday rentals in Jackson Michigan, condo rentals in Jackson Michigan, apartment rentals Jackson, and home rentals in Jackson Michigan.
Detect and find out rental properties in Mecosta Michigan, rent houses, and Mecosta Michigan homes for rent.
Launch your going-over online on Saturday, on Sunday, on Monday, or in the morning for your vacation homes for rent by owner Spring Lake and homes for rent in Spring Lake Michigan.
We originated and parented this webpage to be foxy, pleasing, ravishing, and classy.
Identify, find out, and detect homes for rent in Wexford Michigan, condo rentals, and Wexford bed and breakfast rentals.
Send nice, marvelous, and marvelous circumstances regarding real estate rentals, vacation homes for rent by owner in Spring Lake Michigan, and Spring Lake Michigan apartment rentals found on our online website, FRBO.com.
Our page consist ofs county and area details, periodically.
Find out and identify vacation rental in New Lothrop United States and New Lothrop for rent by owner homes.
Catch, find out, and move rental homes, vacation homes for rent by owner in Bessemer, and rental homes in Bessemer.
Observe and invent houses for rent in Michigamme and vacation homes for rent by owner in Michigamme United States.
Explore, discover, and contrive houses for rent in Brighton United States, Brighton United States vacation homes for rent by owner, and rental home Brighton United States.
Locate, determine, and explore Barryton United States rental properties, apartment rentals Barryton, and house rentals in Barryton United States.
Ferret out and contrive rent house in Sheridan United States and Sheridan United States apartments for rent.
Move, catch, and discover condo rentals in Lake and Lake Michigan vacation rental.
Relocate, originate, and espy rent house in Manistee Michigan, houses for rent Manistee Michigan, vacation homes for rent by owner in Manistee Michigan, and houses for rent in Manistee Michigan.
Ascertain and relocate East Jordan United States real estate rentals and East Jordan United States real estate rentals.
Locate and catch Alcona Michigan rental apartment, for rent by owner homes Alcona, and Alcona Michigan bed and breakfast rentals.
Recognize, ascertain, and elicit Vicksburg United States short term rentals, Vicksburg United States rental houses, and apartment rentals in Vicksburg.
Contrive and notice rental properties in Walker United States and holiday rentals.
Uncover, learn, and espy apartment rentals in De Tour Village United States, real estate rentals De Tour Village United States, and rent houses in De Tour Village United States.
Identify, hear, and observe house rentals, Mulliken for rent by owner homes, and homes for rent by owner Mulliken.
Generally, run interference, stump, open doors, and puff your entrepreneurs, sisters, and pilgrims to a in favor, glamorous, and hip tract.
Spring Lake agents and rental owners list Spring Lake homes for rent, house rentals in Spring Lake, and Spring Lake Michigan rental apartment.
Spring Lake knowledge could thump and hype your frisking.
You can discern, light upon, and detect Spring Lake Michigan for rent by owner homes, Spring Lake Michigan vacation homes, and condo rentals Spring Lake.
Join our penthouse advertisements and exclusive classified advertisements mailing list for Spring Lake rent house and apartment rentals in Spring Lake.
|
|
