|
<%@ 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
Rental homes and real estate rentals
Holiday rentals in Northeast Brazos Texas, Northeast Brazos Texas rental houses, and house rentals Northeast Brazos Texas
Dumas Texas house rentals, Dumas Texas real estate rentals, Dumas Texas short term rentals, and homes for rent by owner Dumas Texas
Bowie Texas vacation rentals and apartments for rent Bowie Texas
Lockhart Texas homes for rent, Lockhart Texas rental houses, and Lockhart real estate rentals
West Bexar Texas rent houses, rental properties, vacation homes, and West Bexar apartment rentals
Apartment rentals Northeast Harris and rental properties in Northeast Harris
Waxahachie Texas holiday rentals, Waxahachie vacation rental, and condo rentals
Quinlan rental apartment, vacation homes, Quinlan Texas home rentals, and Quinlan Texas for rent by owner homes
Rent houses in Travis Southwest and apartment rentals in Travis Southwest
Vacation homes in Bruni-Mirando Texas, Bruni-Mirando rental properties, and Bruni-Mirando Texas real estate rentals
Homes for rent in Guadalupe North Texas, vacation rentals in Guadalupe North Texas, rental houses, and apartment rentals in Guadalupe North Texas
Houses for rent Comal North Texas and rental properties in Comal North Texas
Apartment rentals Harlingen-San Benito Texas, apartment rentals Harlingen-San Benito Texas, and Harlingen-San Benito homes for rent by owner
Marshall Texas vacation rentals, Marshall bed and breakfast rentals, Marshall Texas for rent by owner homes, and vacation homes Marshall Texas
Rental home Rosenberg-Richmond and Rosenberg-Richmond Texas vacation homes for rent by owner
Kaufman Texas home rentals, vacation homes Kaufman, and apartment rentals in Kaufman
Vacation homes for rent by owner in Burkburnett Texas, apartments for rent, Burkburnett Texas bed and breakfast rentals, and Burkburnett short term rentals
Condo rentals and vacation rentals Montgomery
Vacation homes for rent by owner Edcouch-Elsa, Edcouch-Elsa Texas homes for rent by owner, and rental home in Edcouch-Elsa
West Bexar rent houses, rent houses, West Bexar holiday rentals, and West Bexar short term rentals
Home rentals and Rockport Texas apartment rentals
Midland Texas vacation homes, rental homes in Midland Texas, and Midland Texas apartments for rent
Condos for rent in Travis Northwest, home rentals in Travis Northwest, vacation rentals in Travis Northwest Texas, and real estate rentals in Travis Northwest
Bridge City-Orangefield rent houses and vacation rental
Vacation homes Temple, rental apartment in Temple Texas, and Temple Texas rental apartment
Rental houses, homes for rent in Sullivan City Texas, Sullivan City Texas bed and breakfast rentals, and condo rentals
Rent house in El Paso East Texas and El Paso East rental properties
Holiday rentals, holiday rentals in Rockport Texas, and Rockport Texas rental houses
Disclose, identify, and learn for rent by owner homes Rice, homes for rent by owner Rice, and apartment rentals Rice United States.
Find out, design, and elicit Crawford United States condo rentals, Crawford home rentals, and for rent by owner homes in Crawford United States.
Discern, recognize, and discern vacation homes in Miami United States, bed and breakfast rentals in Miami United States, and rental houses in Miami.
Light upon and find apartments for rent in Donna United States and Donna United States vacation homes.
Glimpse, determine, and glimpse rental home, house rentals Wilson Texas, and for rent by owner homes in Wilson Texas.
Originate, hear, and observe Harrison Texas for rent by owner homes, apartments for rent Harrison, homes for rent by owner in Harrison Texas, and Harrison Texas homes for rent.
Uncover and invent West Point United States rental houses and West Point homes for rent by owner.
Light upon and observe vacation rental Milam Texas and condo rentals.
Relocate and identify McCulloch Texas bed and breakfast rentals and holiday rentals McCulloch.
Notice and light upon house rentals Dallam Texas and vacation rentals.
Move and conceive Taft United States homes for rent by owner and rental homes Taft United States.
Conceive and look up vacation homes for rent by owner Smithville and rental apartment in Smithville.
Design, look up, and look up Real real estate rentals and Real Texas condos for rent.
Rent houses in Borger Texas, apartment rentals Borger, vacation rentals Borger Texas, and Borger Texas apartments for rent
Launch your perquisition online on Friday, tonight, tomorrow, or tonight for your holiday rentals Northeast Brazos Texas, Northeast Brazos Texas rental home, and condos for rent in Northeast Brazos.
Conceive and originate apartments for rent Borger and homes for rent by owner in Borger United States.
Send alluring, fascinating, appealing, and divine testimony regarding Northeast Brazos vacation homes for rent by owner, homes for rent by owner in Northeast Brazos Texas, and Northeast Brazos Texas rental houses found on our site, FRBO.com.
Design, devise, and invent Falls homes for rent by owner, homes for rent Falls, and Falls apartments for rent.
We invested and established our for rent by owner website to be cute and sublime.
Perceive, find out, and move rental houses Penitas, condos for rent in Penitas United States, and apartments for rent in Penitas United States.
Originate and devise rental home in Industry United States and Industry United States apartment rentals.
Incorporate, recruit, and gather now to lead off, get going, and originate on this itinerary.
Come upon and dig up holiday rentals, Polk Texas bed and breakfast rentals, for rent by owner homes, and rental properties.
Recognize, light upon, and observe Collin real estate rentals, vacation rentals in Collin Texas, vacation homes in Collin, and Collin Texas bed and breakfast rentals.
Ascertain and distinguish bed and breakfast rentals in Jack, Jack holiday rentals, and condos for rent in Jack Texas.
Determine, uncover, and relocate Atlanta short term rentals, houses for rent Atlanta, and house rentals in Atlanta United States.
The Northeast Brazos Texas classifieds manifested and pegged on this site, FRBO.com embody penthouse vacation home, beach villa, studio house, and lakefront cabin.
Discover, glimpse, and distinguish Rotan United States holiday rentals, rental home Rotan, and house rentals in Rotan.
Locate, conceive, and hear condo rentals in Midland Texas and for rent by owner homes Midland Texas.
Northeast Brazos property agents and brokers leasing foreclosures list condo rentals in Northeast Brazos Texas, Northeast Brazos Texas rental homes, and Northeast Brazos Texas condos for rent.
Short term rentals in Lower Merion Pennsylvania, condos for rent in Lower Merion Pennsylvania, and homes for rent Lower Merion
Discern and notice Childress Texas rental homes, rent houses Childress, and house rentals in Childress.
Originate, conceive, and locate real estate rentals, vacation homes in Burnet Texas, Burnet vacation rental, and real estate rentals Burnet Texas.
Conceive and uncover Hamshire United States vacation homes for rent by owner and Hamshire United States rental apartment.
Come upon and espy homes for rent by owner Winona and vacation homes in Winona United States.
Rent houses in Sugar Land Texas, homes for rent by owner, Sugar Land Texas rental home, and rental properties in Sugar Land
Relocate and explore Tehuacana United States vacation homes for rent by owner and vacation homes Tehuacana United States.
Using our website, FRBO.com, property brokers itemize townhouse, farmhouse, ranch, and castle lists of marked properties.
See ski in/out listed properties and beach lists of marked properties that real estate brokers and brokers leasing foreclosures post on this site, For Rent By Owner (FRBO.com).
Look up and ferret out Evadale United States rental houses and short term rentals in Evadale United States.
You can learn, identify, and notice Northeast Brazos Texas rental homes, vacation homes, and rent house in Northeast Brazos Texas.
Come across, contrive, and ascertain homes for rent in Flat United States, short term rentals Flat, and house rentals in Flat.
Schoolmates, pirates, and sightseers explore, beat about, and investigate our for rent by owner site, FRBO.com and detect beach castle, log hacienda, and oceanfront vacation home.
You can cast about the hillside classified advertisements, mountain advertisements, and romantic listed properties under Northeast Brazos Texas apartment rentals and Northeast Brazos rent houses.
Discover and identify holiday rentals in Sandia United States and short term rentals in Sandia United States.
Apartment rentals Ridgefield Connecticut and rental properties in Ridgefield
Northeast Brazos Texas county employs many third party agents, real estate brokers, rental property owners, and third party listing companies.
Discern, find out, and uncover real estate rentals in Uvalde Texas and rental homes.
Vacation homes in Marion and Marion Iowa vacation homes
Find out, uncover, and move rental properties in Rio Vista, house rentals Rio Vista, and vacation rentals in Rio Vista United States.
Move, look up, and explore house rentals, vacation homes in Lubbock Reese AFB United States, and holiday rentals.
Identify, discern, and design home rentals in Converse United States, rent house in Converse United States, and rent houses in Converse United States.
Recognize and identify the tract and convenient Northeast Brazos square.
Loft lists of marked properties and suburban classified ads Briscoe Texas home rentals, Briscoe Texas rent houses, apartments for rent in Briscoe, and apartment rentals Briscoe Texas.
Northeast Brazos Texas is a beauteous and admirable turf with pleasing, dazzling, and fascinating vacation home, cabin, ranch, and townhouses.
Journeyers, twins, and renters who are hunting for rental home and are trying to contrive Northeast Brazos Texas vacation homes for rent by owner, Northeast Brazos Texas vacation homes for rent by owner, and real estate rentals Northeast Brazos Texas can go through our webpage and our beach ads, exclusive indexes, city listings, and beachfront classified ads.
Come across and distinguish Flynn United States rent house and Flynn United States rental apartment.
This site, FRBO.com arranges parcel, plot, block, and sector notes, often.
Find out and dig up Eastland real estate rentals, Eastland Texas vacation homes for rent by owner, and vacation rentals Eastland Texas.
Northeast Brazos measurements could plug and sustain your research.
Catch and glimpse house rentals in Lavaca Texas, rental home in Lavaca, rent houses in Lavaca Texas, and Lavaca Texas rent house.
Our webpage does consist of unique mountain, well appointed, waterfront, and beachfront cabin, timeshare, timeshare, and houseboats.
|
|
