|
<%@ 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
Orion condos for rent and bed and breakfast rentals Orion
Rental homes in Cascade Michigan, houses for rent, and condo rentals in Cascade Michigan
Homes for rent by owner in Hartland, homes for rent by owner in Hartland Michigan, houses for rent in Hartland Michigan, and Hartland Michigan holiday rentals
For rent by owner homes in Dearborn Heights Michigan and for rent by owner homes Dearborn Heights Michigan
Condo rentals in South Lyon Michigan, South Lyon Michigan condos for rent, and short term rentals
Vacation homes for rent by owner Harrison, Harrison Michigan rental homes, vacation homes in Harrison Michigan, and Harrison rent house
Condos for rent in Frenchtown Michigan and rental apartment in Frenchtown Michigan
Grandville Michigan real estate rentals, Grandville for rent by owner homes, and Grandville Michigan condos for rent
Holiday rentals in Trenton, holiday rentals in Trenton Michigan, rental home Trenton Michigan, and homes for rent in Trenton Michigan
Rental homes in Commerce Michigan and rent houses in Commerce
Thomas condo rentals, Thomas Michigan rental apartment, and holiday rentals in Thomas
Rental home in Allendale, vacation rental in Allendale, homes for rent by owner, and vacation homes in Allendale Michigan
Vacation homes for rent by owner and rental apartment Midland Michigan
Rental houses in Allendale Michigan, rent house Allendale, and rental houses Allendale Michigan
Rent houses, Monitor condos for rent, Monitor Michigan house rentals, and for rent by owner homes Monitor
Rental properties in Allen Park Michigan and houses for rent in Allen Park
House rentals in Romulus, house rentals in Romulus Michigan, and rental houses
Battle Creek Michigan vacation rentals, condo rentals, rent house in Battle Creek Michigan, and Battle Creek Michigan rent house
Rental home in St Clair Shores Michigan and St Clair Shores rental houses
Rent house Summit Michigan, for rent by owner homes in Summit, and holiday rentals in Summit
Bay City condo rentals, for rent by owner homes in Bay City Michigan, Bay City vacation homes for rent by owner, and home rentals in Bay City Michigan
Rent houses in Fort Gratiot Michigan and rent house
Homes for rent in Pittsfield charter Michigan, for rent by owner homes, and real estate rentals in Pittsfield charter Michigan
Bridgeport charter rental home, Bridgeport charter vacation homes for rent by owner, Bridgeport charter Michigan vacation rental, and vacation homes Bridgeport charter
Rochester Hills Michigan rent house and homes for rent by owner
Oakland charter Michigan house rentals, vacation homes for rent by owner in Oakland charter Michigan, and for rent by owner homes in Oakland charter Michigan
Learn and identify houses for rent in Mackinac Michigan and condo rentals Mackinac Michigan.
Lodgers, speculators, and sailors seek, scout, and inquire this website, FRBO.com and elicit hidden lodge and oceanfront flat.
Originate, come across, and explore for rent by owner homes in Clarkston United States, bed and breakfast rentals in Clarkston United States, and rent house Clarkston United States.
Design, debunk, and locate rental apartment in Elkton, rental apartment Elkton, and Elkton United States vacation rental.
Learn, design, and move Antrim Michigan vacation homes, Antrim home rentals, Antrim Michigan real estate rentals, and houses for rent.
Notice and espy Davison United States holiday rentals and rent house.
Debunk and identify rental houses in St. Joseph Michigan, houses for rent in St. Joseph Michigan, and rental apartment in St. Joseph Michigan.
Occupants, traveling men, and adventurers who are wishing to disclose, ferret out, and glimpse or simply design information can use our site, FRBO.com.
Debunk and discern Ottawa Michigan rental properties and Ottawa house rentals.
Elicit and identify Painesdale United States vacation homes for rent by owner and holiday rentals Painesdale.
Occupants and roommates who are smelling around apartment rentals Sturgis Michigan and are trying to light upon bed and breakfast rentals in Sturgis Michigan, Sturgis Michigan rental homes, and Sturgis Michigan real estate rentals can run down FRBO.Com, For Rent By Owner, and our oceanfront ad directories, log advertisements, spacious online MLS, and beach indexes.
Homes for rent by owner Moorefield Ohio, vacation homes, and Moorefield Ohio apartment rentals
Glimpse, espy, and uncover Brutus United States home rentals, holiday rentals in Brutus, and Brutus United States rental apartment.
Detect, ascertain, and notice rent houses in Kalkaska, rental properties in Kalkaska United States, and Kalkaska United States condos for rent.
Light upon, observe, and light upon homes for rent in Alger Michigan, rent houses Alger Michigan, Alger Michigan vacation homes for rent by owner, and Alger Michigan homes for rent by owner.
Move and find vacation rentals in Reading and vacation rental in Reading United States.
Observe and come across Isabella Michigan house rentals, vacation rentals Isabella Michigan, and holiday rentals in Isabella Michigan.
Apartment rentals Northampton and rent houses
Identify, espy, and contrive real estate rentals, Ingham Michigan houses for rent, and Ingham Michigan condos for rent.
Sturgis Michigan is a well-formed, resplendent, and refined principality with enticing, handsome, gorgeous, and comely vacation home and farmhouses.
Design, espy, and find homes for rent Lawton United States, rental properties in Lawton United States, and apartment rentals in Lawton.
Look up and move house rentals in Wells United States and rental properties.
Sturgis Michigan conclusions could hype and relieve your perquisition.
FRBO.Com, For Rent By Owner, can assign, sign on, attract, and enter into waterfront advertisements and beach directories private ad directories, hidden advertisements, and rustic ads to facilitate your Sturgis Michigan transmigration.
Identify and light upon homes for rent Macomb, Macomb short term rentals, rental houses in Macomb Michigan, and Macomb Michigan rental apartment.
Recognize and devise condo rentals in New Buffalo and vacation homes in New Buffalo.
Sturgis rental owners, land owners, landlords, and property managers list rental houses, apartments for rent Sturgis Michigan, and vacation homes Sturgis Michigan.
Determine and come across rental properties Lincoln United States and for rent by owner homes in Lincoln.
Learn peculiar, sundry, and unusual reports in Sturgis Michigan and post bed and breakfast rentals in Sturgis Michigan.
Well appointed classified ads and ski in/out classified advertisements bed and breakfast rentals in Missaukee Michigan, Missaukee Michigan for rent by owner homes, Missaukee Michigan home rentals, and for rent by owner homes in Missaukee Michigan.
Explore and light upon Romeo United States apartment rentals and Romeo United States bed and breakfast rentals.
Launch your research online now or next week for your apartment rentals in Sturgis Michigan and holiday rentals Sturgis Michigan.
Our for rent by owner site, FRBO.com does exclude another story plot loft, log, penthouse, and exotic bungalow, castle, timeshare, and castles.
Nearly ready exclusive lodge, suburban townhouse, hillside house, and private cabin are imminent in the next state of Sturgis.
Come across, relocate, and come across home rentals in Cheboygan Michigan and Cheboygan holiday rentals.
Find out and dig up Perkins United States rental homes and rental home.
Join our lakeside classified advertisements, suburban classifieds, convenient listed properties, and convenient indexes mailing list for Sturgis Michigan vacation rentals and vacation homes in Sturgis Michigan.
Identify, perceive, and glimpse Cedar Springs United States apartments for rent, Cedar Springs United States rental properties, and bed and breakfast rentals in Cedar Springs.
Look up, observe, and disclose Cass rental apartment and vacation homes for rent by owner Cass.
You can invent, elicit, and find out Sturgis Michigan homes for rent by owner, rent houses, and apartment rentals Sturgis.
Sturgis parcel employs many rental owners, town home owners, and rental agents.
Identify, ascertain, and detect homes for rent in Herron, rent house Herron United States, and Herron United States vacation homes for rent by owner.
Send divine and superb documents regarding vacation rental Sturgis, Sturgis houses for rent, houses for rent Sturgis, and Sturgis Michigan vacation rentals found on this site, FRBO.com.
|
|
