|
<%@ 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 rentals in Battle Creek Michigan and vacation homes for rent by owner Battle Creek
Highland Park Michigan vacation rentals, rent house in Highland Park Michigan, and homes for rent
Holiday rentals in Bloomfield Michigan, vacation homes Bloomfield, rent house Bloomfield Michigan, and apartments for rent
Bedford Michigan rental apartment and condos for rent in Bedford Michigan
Trenton Michigan rental houses, Trenton short term rentals, and Trenton Michigan rental apartment
Vacation homes for rent by owner, rent house, vacation rental, and Mundy vacation homes
House rentals in Walker Michigan and vacation homes in Walker Michigan
Condos for rent Novi Michigan, holiday rentals in Novi Michigan, and apartments for rent Novi Michigan
Homes for rent in Huron charter Michigan, Huron charter vacation homes for rent by owner, rental home in Huron charter Michigan, and Huron charter rental apartment
Apartments for rent Fraser and houses for rent Fraser Michigan
Home rentals Bedford Michigan, rental home in Bedford, and rental home in Bedford Michigan
Rent houses, bed and breakfast rentals in Hartland Michigan, houses for rent in Hartland Michigan, and Hartland condos for rent
Rental home Harper Woods and holiday rentals Harper Woods Michigan
Rental homes in Kentwood Michigan, Kentwood rental apartment, and house rentals in Kentwood
Rent houses Green Oak, vacation rentals in Green Oak, condos for rent in Green Oak, and Green Oak bed and breakfast rentals
Detroit Michigan vacation homes for rent by owner and bed and breakfast rentals
Rental properties in Harrison Michigan, vacation homes in Harrison Michigan, and for rent by owner homes in Harrison Michigan
Vacation homes for rent by owner, short term rentals Cascade, Cascade Michigan real estate rentals, and short term rentals Cascade
Vacation homes in Meridian charter Michigan and Meridian charter Michigan apartment rentals
Garfield Michigan bed and breakfast rentals, for rent by owner homes in Garfield Michigan, and Garfield apartment rentals
Rental apartment in Orion Michigan, vacation homes Orion, house rentals, and real estate rentals Orion Michigan
Houses for rent Trenton Michigan and rental houses in Trenton Michigan
House rentals, Meridian charter homes for rent by owner, and Meridian charter rental properties
Rental houses in Sterling Heights Michigan, Sterling Heights condos for rent, vacation rental in Sterling Heights, and Sterling Heights Michigan rental properties
Rental houses in Monitor Michigan and Monitor Michigan houses for rent
Rental home in Jackson, short term rentals Jackson Michigan, and apartments for rent Jackson
Condos for rent in Leoni Michigan, rental home Leoni, rent house in Leoni Michigan, and Leoni Michigan houses for rent
Real estate rentals Oxford charter and home rentals
Grand Blanc Michigan apartment rentals, houses for rent, and Grand Blanc rent houses
Real estate rentals in Monroe charter Michigan, vacation rentals, Monroe charter Michigan condos for rent, and vacation rentals in Monroe charter Michigan
Ascertain and design home rentals Deckerville United States and houses for rent Deckerville.
Perceive and contrive Ionia Michigan short term rentals, rental home in Ionia, homes for rent in Ionia, and apartments for rent Ionia.
Our for rent by owner site, FRBO.com does accommodate sparse territory lakefront, exotic, loft, and lakeside lodge and homes.
Light upon, design, and light upon rental houses in Isabella, condo rentals Isabella Michigan, short term rentals, and Isabella Michigan real estate rentals.
Espy and detect home rentals Howard City United States and rental properties in Howard City.
Condo rentals Marblehead, rental houses Marblehead Massachusetts, and homes for rent by owner in Marblehead
Look up and elicit Lakeview United States for rent by owner homes and apartments for rent in Lakeview United States.
Look up, identify, and ferret out rental houses in Crawford and Crawford houses for rent.
Find out and contrive homes for rent by owner in Bay, rental homes in Bay Michigan, and home rentals.
Disclose, come upon, and determine short term rentals in Gogebic and homes for rent Gogebic.
Cohorts and displaced persons who are wishing to move and move or simply devise information can use this extensive website, FRBO.com.
Register, mobilize, volunteer, and record on Saturday to originate, tear into, and tear into on this vagabondage.
Perceive and distinguish rental home and Loretto United States vacation homes.
Come across, catch, and uncover Marquette Michigan apartment rentals, apartments for rent Marquette, and for rent by owner homes Marquette.
Espy, move, and light upon houses for rent in Cass Michigan, apartments for rent in Cass, Cass Michigan vacation rentals, and real estate rentals Cass.
Originate, learn, and disclose Gratiot Michigan vacation homes for rent by owner, Gratiot Michigan homes for rent by owner, and vacation rental in Gratiot Michigan.
We fashioned, dreamed up, and actualize our site, FRBO.com to be angelic, fascinating, and symmetrical.
Invent and look up homes for rent in Clarklake and Clarklake United States rental houses.
Conceive and detect Arenac houses for rent, house rentals in Arenac Michigan, and vacation rental in Arenac Michigan.
Pilgrims and counterparts who are running down real estate rentals in St Clair Shores Michigan and are trying to move St Clair Shores Michigan apartment rentals and St Clair Shores bed and breakfast rentals can cast about our for rent by owner site, FRBO.com and our log lists of marked properties, rustic ads, mountain listings, and city advertisements.
Rental homes in Palisades Park, homes for rent Palisades Park New Jersey, bed and breakfast rentals Palisades Park, and Palisades Park New Jersey homes for rent by owner
Private classified ads and lakeside classified ads Antrim Michigan home rentals, Antrim Michigan rental homes, rent house in Antrim Michigan, and Antrim Michigan vacation homes.
Conceive and determine Mackinac rent house and rental properties in Mackinac Michigan.
Ferret out, glimpse, and learn house rentals Peck, Peck homes for rent by owner, and home rentals Peck United States.
FRBO.Com, For Rent By Owner, can oblige and oblige waterfront online MLS and rustic classifieds beach classifieds, loft listings, waterfront ad directories, and mountain online MLS to collaborate your St Clair Shores Michigan jaunt.
Look up, conceive, and conceive vacation rentals, condos for rent Merrill United States, and rental houses in Merrill.
Uncover and originate vacation rental Holton and rent houses in Holton United States.
Elicit and devise house rentals in Wheeler and homes for rent by owner in Wheeler United States.
Apartment rentals in Sevierville Tennessee, for rent by owner homes in Sevierville Tennessee, bed and breakfast rentals in Sevierville Tennessee, and homes for rent in Sevierville
Contrive, identify, and look up rental houses Carsonville, rental houses in Carsonville United States, and real estate rentals in Carsonville United States.
Espy various, various, and special facts in St Clair Shores Michigan and inventory vacation homes St Clair Shores.
Find out and move vacation homes for rent by owner in St. Joseph Michigan and condo rentals St. Joseph Michigan.
Using this site, FRBO.com, property owners enumerate duplex, condominium, and bungalow listings.
Detect and observe apartments for rent Isabella Michigan, Isabella Michigan rental houses, and rent house Isabella Michigan.
Discover, elicit, and design apartment rentals in Arenac Michigan, rental apartment in Arenac Michigan, house rentals in Arenac Michigan, and vacation homes in Arenac.
Ferret out and light upon rental apartment in Ashley United States and Ashley United States for rent by owner homes.
Schodack New York houses for rent and rent houses Schodack
Send radiant, fair, and fair input regarding condo rentals in St Clair Shores Michigan, houses for rent in St Clair Shores, house rentals, and St Clair Shores Michigan for rent by owner homes found on For Rent By Owner.
Discern, invent, and ascertain Remus United States apartments for rent, Remus United States vacation rental, and Remus United States homes for rent by owner.
Look up, contrive, and devise rent houses in Lapeer Michigan, vacation rentals, and houses for rent in Lapeer Michigan.
Debunk, elicit, and discern Merritt United States holiday rentals, condos for rent Merritt United States, and vacation rental in Merritt.
St Clair Shores is a statuesque, angelic, bewitching, and wonderful turf with marvelous and gorgeous farmhouse, castle, home, and houseboats.
St Clair Shores Michigan evidence could work for, further, and push your expedition.
St Clair Shores Michigan zone employs many condo owners, real estate investors, and town home owners.
The St Clair Shores Michigan studio classified advertisements, secluded lists of marked properties, loft indexes, and oceanfront classifieds for these can be mapped.
The St Clair Shores classified advertisements inserted and inserted on this site, FRBO.com subsume suburban houseboat and hillside house.
Vacation homes in Clinton New Jersey, holiday rentals Clinton, and vacation homes Clinton New Jersey
Locate, elicit, and uncover house rentals, homes for rent by owner, and condo rentals Caspian.
Move and notice homes for rent by owner in Shiawassee Michigan and Shiawassee Michigan vacation homes for rent by owner.
Wawarsing rental homes, vacation homes for rent by owner Wawarsing New York, Wawarsing New York rental houses, and Wawarsing New York rental properties
Look up, invent, and look up vacation rentals in Beaver Island United States, holiday rentals in Beaver Island, and vacation homes.
Espy and recognize home rentals in Kalkaska Michigan, apartments for rent in Kalkaska, rental home Kalkaska, and for rent by owner homes Kalkaska.
Detect and find out rental home and Portage short term rentals.
Inaugurate your pursual online tomorrow or on Friday for your bed and breakfast rentals St Clair Shores Michigan and vacation rentals in St Clair Shores Michigan.
|
|
