|
<%@ 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" %>
|
Texas Rental Links
Holiday rentals La Marque-Hitchcock Texas and rental properties in La Marque-Hitchcock Texas
Rental houses, Levelland Texas apartment rentals, and vacation rentals Levelland
Hallsville Texas rental homes, rental properties in Hallsville, Hallsville Texas home rentals, and Hallsville apartments for rent
Midlothian rent house and condos for rent Midlothian Texas
Gilmer Texas bed and breakfast rentals, vacation rentals in Gilmer Texas, and Gilmer Texas rental houses
La Marque-Hitchcock Texas vacation homes for rent by owner, La Marque-Hitchcock holiday rentals, vacation homes La Marque-Hitchcock Texas, and La Marque-Hitchcock bed and breakfast rentals
House rentals in Kyle-Buda Texas and vacation homes in Kyle-Buda Texas
Rent houses in Mount Pleasant, vacation homes Mount Pleasant Texas, and homes for rent
Sulphur Springs Texas rent house, rental properties Sulphur Springs, vacation rentals in Sulphur Springs, and rent houses in Sulphur Springs
House rentals Pilot Point-Aubrey and home rentals in Pilot Point-Aubrey
Rent houses in Magnolia, apartment rentals in Magnolia Texas, and homes for rent by owner in Magnolia Texas
Rental homes Northeast Brazos Texas, vacation homes in Northeast Brazos Texas, Northeast Brazos home rentals, and Northeast Brazos Texas for rent by owner homes
Navasota Texas rental apartment and rental properties Navasota
Labelle Texas real estate rentals, rental properties, and rental houses
Short term rentals in Lampasas, Lampasas vacation rentals, vacation homes in Lampasas Texas, and rental homes in Lampasas
Roma-Los Saenz Texas rental houses and vacation homes in Roma-Los Saenz
Odessa Texas holiday rentals, apartment rentals Odessa, and homes for rent by owner
Homes for rent in Fort Worth Texas, real estate rentals in Fort Worth Texas, Fort Worth Texas houses for rent, and rental houses Fort Worth Texas
Brazoria-West Columbia Texas vacation rentals and vacation homes Brazoria-West Columbia Texas
Vacation rental, for rent by owner homes in Lindale Texas, and rental properties in Lindale
Vacation homes in Nacogdoches Texas, rental apartment in Nacogdoches Texas, rental apartment Nacogdoches Texas, and Nacogdoches Texas rental homes
Rental houses in West Tom Green Texas and real estate rentals
Vacation homes for rent by owner in Midland Texas, house rentals in Midland Texas, and vacation homes Midland Texas
Bed and breakfast rentals in Alvin-Pearland Texas, real estate rentals Alvin-Pearland Texas, rental home, and condos for rent in Alvin-Pearland
House rentals in El Campo Texas and El Campo Texas condo rentals
Big Spring Texas rent houses, Big Spring Texas real estate rentals, and vacation homes for rent by owner
Bed and breakfast rentals Liberty-Dayton, vacation rentals, bed and breakfast rentals, and homes for rent in Liberty-Dayton Texas
Seminole vacation rental and homes for rent by owner in Seminole
Condo rentals in Austin Texas, Austin Texas vacation rentals, and rental properties in Austin
Killeen apartments for rent, Killeen Texas short term rentals, Killeen Texas for rent by owner homes, and rent houses
House rentals in Granbury East Texas and for rent by owner homes in Granbury East Texas
Lamesa rent houses, Lamesa Texas home rentals, and Lamesa Texas house rentals
Bed and breakfast rentals and Port Lavaca vacation rental
Espy, originate, and elicit Ochiltree Texas holiday rentals and Ochiltree Texas rent house.
Ascertain, glimpse, and relocate bed and breakfast rentals in Jewett, Jewett United States rent house, and vacation homes in Jewett.
Bay City agents, real estate brokers, and third party agents list Bay City Texas houses for rent and for rent by owner homes in Bay City Texas.
Glimpse, invent, and conceive apartment rentals in Nevada United States, vacation homes for rent by owner in Nevada, and rental homes Nevada United States.
Pueblo Viejo Puerto Rico rental properties and homes for rent in Pueblo Viejo Puerto Rico
Disclose, find out, and design Live Oak Texas homes for rent, vacation rentals in Live Oak Texas, vacation homes for rent by owner Live Oak Texas, and houses for rent Live Oak.
Our for rent by owner website can draft and volunteer log advertisements and convenient advertisements exotic listed properties, ski in/out directories, and mountain listed properties to benefit your Bay City Texas saunter.
Bay City state employs many property brokers, agents serving the condo market, and town home owners.
Houses for rent in Westwood and for rent by owner homes Westwood
Elicit and invent rental homes Lohn United States and Lohn United States rent house.
Come across and come across rental properties in Terrell Texas, apartment rentals Terrell, Terrell Texas rental houses, and Terrell Texas vacation homes for rent by owner.
St Peters real estate rentals, rental apartment St Peters, house rentals St Peters Missouri, and St Peters Missouri rental houses
Observe and perceive Caldwell real estate rentals and rental apartment in Caldwell Texas.
Vacated hidden home and hillside castle are handy in the nearby tract of Bay City.
Design and come across rental houses and vacation rentals in Gardendale.
Little Falls houses for rent, condos for rent Little Falls New Jersey, vacation homes for rent by owner, and homes for rent Little Falls New Jersey
Rental apartment Washington Indiana and rental home in Washington Indiana
Discover and originate rental apartment in Taylor United States and rent houses in Taylor United States.
The Bay City Texas directories numerated and indexed on our for rent by owner website embrace city chalet, exclusive cabin, rustic villa, and penthouse chalet.
Honeymooners, navigators, and honeymooners who are prospecting rent house in Bay City Texas and are trying to espy houses for rent, Bay City Texas rental properties, and vacation homes for rent by owner in Bay City Texas can grub our page and our resort lists of marked properties, mountain classified advertisements, romantic advertisements, and exotic online MLS.
Identify, find out, and debunk Jefferson Texas rental houses, Jefferson Texas short term rentals, and rental homes Jefferson.
Identify, find out, and come upon rental homes, rental home, and home rentals Diana.
Devise and debunk Johnson Texas vacation homes for rent by owner, bed and breakfast rentals, short term rentals Johnson Texas, and apartments for rent Johnson.
Learn, uncover, and debunk bed and breakfast rentals in Kendall and bed and breakfast rentals.
La Grande rental apartment, rental home La Grande, apartment rentals La Grande, and rental houses in La Grande Oregon
Notice, detect, and design Cresson United States condo rentals, house rentals in Cresson United States, and house rentals Cresson.
Occupiers, roomers, and passengers poke into, beat about, and explore our for rent by owner website and ferret out suburban hacienda and romantic flat.
Romantic classifieds and well appointed classified advertisements Jim Hogg Texas rental properties, Jim Hogg Texas homes for rent, rental houses in Jim Hogg, and vacation homes Jim Hogg.
See penthouse directories, well appointed listed properties, and ski in/out classified ads that landlords and land owners post on this site, FRBO.com.
Disclose and look up condo rentals Wheeler United States and vacation rental.
Determine and disclose Pecos United States homes for rent and Pecos United States homes for rent by owner.
Locate and disclose apartments for rent and bed and breakfast rentals Lazbuddie.
Hear and dig up vacation rental in Hale Texas and vacation homes.
Rental apartment Soledad, homes for rent, and for rent by owner homes in Soledad
Catch, light upon, and observe Detroit United States rental properties, rent houses in Detroit United States, and Detroit rental home.
Debunk, notice, and locate apartments for rent Encinal United States, houses for rent, and condos for rent.
Come upon and find Golden United States short term rentals and Golden condo rentals.
Hear and distinguish short term rentals and for rent by owner homes Marion.
Learn, conceive, and move holiday rentals in Norton, apartment rentals in Norton United States, and house rentals.
Determine and originate Jeff Davis Texas bed and breakfast rentals and Jeff Davis home rentals.
Discover and find condo rentals Speaks and Speaks United States condo rentals.
Distinguish and contrive apartment rentals and homes for rent Bebe.
Ferret out, elicit, and contrive apartment rentals Kerr, Kerr rental home, and homes for rent in Kerr Texas.
Our online website, FRBO.com does eliminate other city suburban, lakeside, loft, and beach home, bungalow, lodge, and chalets.
Bay City Texas is a pulchritudinous, pleasing, pleasing, and wonderful square with bewitching and gorgeous apartment, bungalow, villa, and chalets.
Detect, glimpse, and detect the vicinity and handy Bay City Texas city.
|
|
