Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:00:02.183' ,`MLSNumber` = '45116606' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.477250' ,`Longitude` = '-95.506663' ,`PhotoCount` = '27' ,`PostalCode` = '77459' ,`RoomCount` = '12' ,`ListPrice` = '862445.00' ,`Status` = 'Active' ,`StreetName` = 'Knollwood' ,`StreetNumber` = '10027' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4537' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Model Plan: The LAYTON features 5 bedrooms, 2 down and 3 up, 4 full bath, 2 half bath. Open concept Kitchen and family presents a decorator’s delight. The gourmet kitchen features a corner walk in pantry and a full-function island. Stepping through sliding doors access: large covered patio which presents a sensational place for calm evenings and weekend cook-outs. A perfect sunlit study and the downstairs suite offers privacy and convenience for overnight guests. Step up Media room for family fun movie nights. Your glorious master bedroom features a large backyard view, expansive walk in closet, and a spacious bathroom. The spacious game room creates space for family fun. Color scheme includes Linen cabinets, cool quartz countertops, grey flooring with black hardware and light fixtures. Large cu de sac lot approx.13,536 sqft Pool size yard.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 2' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '10309' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1229' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652986' WHERE `Matrix_Unique_ID` = '206566261' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:42:33.240' ,`MLSNumber` = '83946513' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816035' ,`Longitude` = '-95.844125' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '687000.00' ,`Status` = 'Active' ,`StreetName` = 'San Bernard' ,`StreetNumber` = '6906' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3918' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The front porch welcomes you home each day to your beautiful new home in Cane Island, located in Old Katy.  This home is located at the end of a cul de sac street adjacent to a green space.  The chef\'s kitchen features a large island, two pantries, double convection ovens, and under cabinet lighting.  The White Summit granite countertops make the kitchen light & bright.  Walk out onto the oversized patio from the large sliding glass doors in your family room.  Relax in your private owners retreat, featuring high ceilings, soaker tub, large shower & double vanity sinks.  The home has a second bedroom on the first floor with an in-suite bath which is perfect for guests.  Enjoy family movie night in your upstairs media room.  The second floor also provides a retreat & bonus space so there is so much space for your family to grow.  Children attend KISD schools.  David Weekley Homes guarantees heating & cooling usage for three years with our Environments for Living Program.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 30 Block 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8251' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.45' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664652986' WHERE `Matrix_Unique_ID` = '207888683' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:59:40.097' ,`MLSNumber` = '96206139' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.162147' ,`Longitude` = '-95.589803' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '6' ,`ListPrice` = '434990.00' ,`Status` = 'Active' ,`StreetName` = 'Flintlock' ,`StreetNumber` = '26979' ,`StreetSuffix` = 'Trail' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 96206139 - Built by Highland Homes - October completion! ~ Clean lines, neutral interior makes this one story home easy to personalize. Primary bath and bathroom #3 have extra large shower in lieu of a tub. All bathrooms have framed mirrors. Primary Bedroom bay window and Extended Outdoor living area sets the tone for many relaxing days to enjoy this open concept home with 11’ ceilings. Fully sod yard with front and back sprinklers and fully fenced backyard. This home is on the end of a cul-de-sac and backs to green space, no shared fence in the back! House is prewired/pre-plumb up to 24Kw for a generator. Energy saving features and Smart Home Technology makes this an efficient and comfortable home.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 8 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6639' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NorthGrove' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664652986' WHERE `Matrix_Unique_ID` = '207996873' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:53:33.673' ,`MLSNumber` = '10905802' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.148794' ,`Longitude` = '-95.681577' ,`PhotoCount` = '9' ,`PostalCode` = '77362' ,`RoomCount` = '10' ,`ListPrice` = '819456.00' ,`Status` = 'Active' ,`StreetName` = 'Plantinum Stone' ,`StreetNumber` = '734' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3663' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 10905802 - Built by Drees Custom Homes - November completion! ~ The Merrick is an expansive two-story home with plenty of space for a busy family. An elegant two-story foyer draws you in and leads to the open living triangle. The dining room flows seamlessly to the kitchen and voluminous family room. A quiet study with French doors creates the perfect home office. A luxurious owner\'s suite and private guest suite complete the first floor. Upstairs, your family can unwind in the versatile gameroom and cozy media room.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 / Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8699' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace' ,`TaxAmount` = '' ,`TaxRate` = '3.35' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664652987' WHERE `Matrix_Unique_ID` = '208695979' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:56:44.943' ,`MLSNumber` = '870199' ,`ListAgentFullName` = 'Shanisha Greer' ,`ListOfficeName` = 'Greer Real Estate Solution' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.374244' ,`Longitude` = '-94.989958' ,`PhotoCount` = '12' ,`PostalCode` = '77568' ,`RoomCount` = '5' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = '1/2 Virgina' ,`StreetNumber` = '3119' ,`StreetSuffix` = '' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1770' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful, spacious, large 3 bedroom, 2 full bath, 2 car garage home features custom kitchen cabinets that compliments the quartz countertops, and stainless steel microwave and dishwasher. Separate formal dining area, large living room with high ceilings. Built in bench area with a storage at the entrance from the garage and a utitilty room inside. Roomy covered patio with an oversized back yard that is perfect for entertaining or just sitting back and relaxing.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'MaxTek Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 2 E 1/2 OF LOT 37(37.1)' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'WESTLAWN ELEMENTARY SCHOOL (LA MARQUE)' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'La Marque Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652987' WHERE `Matrix_Unique_ID` = '209018994' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:59:15.840' ,`MLSNumber` = '87632803' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292049' ,`Longitude` = '-95.561998' ,`PhotoCount` = '17' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '685000.00' ,`Status` = 'Active' ,`StreetName` = 'Everest' ,`StreetNumber` = '127' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2828' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 87632803 - Built by Highland Homes - February completion! ~ Lovely 1 story home with 3 beds & 2.5 bath. 10\' sliders that open to an extended covered patio. Extended Primary suite with 6\' drop-in rectangular tub & enlarged shower. Classic X Kitchen upgrade with 36 inch apron front sink. Extended brick fireplace & 72 inch Noir ceiling fan. Additional features include study, media room, formal dining area, & 2.5 car garage' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '26-1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 55s' ,`TaxAmount` = '' ,`TaxRate` = '2.83' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664652987' WHERE `Matrix_Unique_ID` = '209028630' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T06:01:44.980' ,`MLSNumber` = '61731832' ,`ListAgentFullName` = 'Bruce Brittimes' ,`ListOfficeName` = 'Brittimes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.956700' ,`Longitude` = '-95.733515' ,`PhotoCount` = '42' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '679000.00' ,`Status` = 'Active' ,`StreetName` = 'Partners Voice' ,`StreetNumber` = '18615' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3705' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury at its finest 4/3.5/3 single story home. It’s time to treat yourself with this beautiful semi-custom home with awesome curb appear in Bridgeland Community. Come enjoying this beautiful craftmanship home from the high ceilings custom interior trimmings down to the freshly polished wood floors in the formal living area and the formal dining area. The bonus room/sunroom is connected to the living room. When its time to retreat come and enjoy your humongous prime bedroom with bonus room for lounging and private time. Too many upgrades to name: Custom Kitchen Cabinets, custom tiles, chandeliers in prime closets, 4 year old installed roof w/ 30 yrs warranty, newly in HVAC system and more.' ,`Acres` = '0.2089' ,`Area` = '25' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 4 SHORES SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '9100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1255' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POPE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '15826' ,`TaxRate` = '3.4329' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652987' WHERE `Matrix_Unique_ID` = '210846320' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:58:10.943' ,`MLSNumber` = '69424856' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209070' ,`Longitude` = '-95.329812' ,`PhotoCount` = '23' ,`PostalCode` = '77302' ,`RoomCount` = '8' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Trails' ,`StreetNumber` = '15931' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2786' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 69424856 - Built by Highland Homes - February completion! ~ Gorgeous Panamera floorplan with soaring ceilings and an abundance of windows for plenty of natural light. Majestic rotunda staircase, wood-look flooring throughout the main living areas, GE stainless steel appliances, white cabinets, and quartz countertops throughout! This home is also a smart home equipped with Eero wifi enhancers, Honeywell wifi thermostat, Rheem tankless water heater, wifi garage door opener, wifi Smartlock on front door, a Skybell doorbell camera, a full sprinkler system and much more!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 73, Blk 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5719' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Artavia 45\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664652987' WHERE `Matrix_Unique_ID` = '210875889' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T06:50:07.750' ,`MLSNumber` = '25039962' ,`ListAgentFullName` = 'Connie Reddington' ,`ListOfficeName` = 'King & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.893300' ,`Longitude` = '-95.711613' ,`PhotoCount` = '46' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Chatham Springs' ,`StreetNumber` = '7915' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in Cypress, 5-3-2 , formal living rooms and dining room , with a game room, Master bedroom upstairs with new carpet with huge walk in closet with study area off the master bedroom with ceiling fan complete remodeled bathroom new tile , tub, fixtures, etc, three more bedroom upstairs with a large game room, ceiling fans throughout , downstairs formal living room, formal dining room , breakfast area, large kitchen lots of cabinets lite and bright granite countertops with stainless-steel appliances, Hunter sprinkler system 7 zones, New carpet with 1/2 inch padding, laminate wood flooring in all downstairs , Rheem air conditioner and heating units still under warranty. Lots of updates throughout the home . Patio doors going into the large back yard home freshly painted throughout.' ,`Acres` = '0.132' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 3 CYPRESS SPRINGS SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cypress Spgs Sec 04' ,`TaxAmount` = '7204' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652987' WHERE `Matrix_Unique_ID` = '210981423' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T06:49:12.887' ,`MLSNumber` = '12233316' ,`ListAgentFullName` = 'Juan Badillo' ,`ListOfficeName` = 'Berkshire Hathaway Home Svs.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874418' ,`Longitude` = '-95.636735' ,`PhotoCount` = '35' ,`PostalCode` = '77084' ,`RoomCount` = '6' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Falmouth' ,`StreetNumber` = '15206' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two stories well maintained home is ready for a Family. House is ready to Move in and can obtain a fast-closing period. This house is very well located in the west side of Houston. Minutes from major shopping areas Home Depot and Lowes are down the street from the neighborhood. Great restaurants and shopping centers nearby. This home is located in the cy-fairs school district. This home is a gorgeous 3 bedroom 2 and half baths. Home has been newly updated with flooring, threw out the entire house and newly installed roof in 2021. Schedule you\'re showing today... You won\'t be disappointed! this home is ready to move in and enjoy.' ,`Acres` = '0.1249' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 4 MAPLE TRACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5442' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Maple Trace Sec 01' ,`TaxAmount` = '5556' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664652988' WHERE `Matrix_Unique_ID` = '211678006' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:54:21.843' ,`MLSNumber` = '96783352' ,`ListAgentFullName` = 'Michelle Garza- Beason' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151059' ,`Longitude` = '-95.382381' ,`PhotoCount` = '37' ,`PostalCode` = '77386' ,`RoomCount` = '9' ,`ListPrice` = '470000.00' ,`Status` = 'Active' ,`StreetName` = 'Serrano Bluff' ,`StreetNumber` = '31747' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3149' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully appointed 4 BDRM/ 3 Bath home in the highly sought-after Falls at Imperial Oaks! Home offers hard to find Primary AND Secondary bedroom downstairs! The sleek, sophisticated kitchen offers granite counters, ample cabinetry, an eat in space and an oversize island that is sure to be the sociable center of the house. The kitchen, breakfast and living area flow together in this open concept home and are highlighted with rich wood flooring. Walls of windows provide the rooms with natural light and connects the home with the backyard space Upstairs game room is an informal and friendly space to relax or play. The generous sized secondary bedrooms upstairs are a dream! Casual living spaces spill effortlessly outdoors onto your covered patio. New roof 2022. Neighborhood includes 2 resort style pools, club house with workout facility, miles of trails, YMCA and area lake. Close to schools, shopping, I-45 and 99. Come fall in love with all this home has to offer!' ,`Acres` = '0.1663' ,`Area` = '15' ,`BuilderName` = 'David Weekly' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S504212 - FALLS AT IMPERIAL OAKS 12, BLOCK 1, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7242' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BIRNHAM WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls At Imperial Oaks 12' ,`TaxAmount` = '11001' ,`TaxRate` = '3.0687' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652988' WHERE `Matrix_Unique_ID` = '211687414' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:29:54.103' ,`MLSNumber` = '69604386' ,`ListAgentFullName` = 'Wayne Cohen' ,`ListOfficeName` = 'Bernstein Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.815759' ,`Longitude` = '-95.453213' ,`PhotoCount` = '49' ,`PostalCode` = '77092' ,`RoomCount` = '12' ,`ListPrice` = '999000.00' ,`Status` = 'Active' ,`StreetName` = 'Havel' ,`StreetNumber` = '3003' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4841' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Terrific custom 5-bedroom home on a 12,000+ lot (per HCAD) on a quiet cul-de-sac. Sides to green belt and no through traffic.\r\nRecent updates include interior and exterior painting,new carpet upstairs (July 2022-per seller), and complete home power washing to the exterior. Additional detailed update/maintenance list attached to docs. An impressive marble floor entry leads to a huge family room with high ceilings, and tons of natural light. The kitchen boasts an abundance of cabinets and counter space. The massive upstairs game room offers many possibilities. The shed in the backyard could be a workstation as it has electricity and was built on-site. Oversized garage with additional space for storage. Close to many new restaurants, and coffee shops, with easy access to the energy corridor, downtown, and galleria.' ,`Acres` = '0.2804' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 800 BLK 42 SHEPHERD FOREST SEC 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12213' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shepherd Forest Sec 03' ,`TaxAmount` = '17152' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652988' WHERE `Matrix_Unique_ID` = '211770128' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T06:41:19.867' ,`MLSNumber` = '53935893' ,`ListAgentFullName` = 'Emily Perez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518837' ,`Longitude` = '-94.995652' ,`PhotoCount` = '17' ,`PostalCode` = '77518' ,`RoomCount` = '3' ,`ListPrice` = '205000.00' ,`Status` = 'Active' ,`StreetName` = 'Derrick' ,`StreetNumber` = '3203' ,`StreetSuffix` = 'Street' ,`City` = 'Bacliff' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '999' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 3203 Derrick St! This home has been partially remodeled and ready for its new owners! Situated a block or two from the water; this is a quiet and cozy neighborhood. New roof 2022, New fascia and soffit 2022, New PEX Plumbing, New hot water heater, New vinyl plank flooring, New paint (interior & exterior, AC has been serviced with the lines blown out so A/C blows great! So many updates, you have to come look for yourself! Come make this house a home today!' ,`Acres` = '0.118' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 153 J MILES SUR S PT OF LOTS 12 & 13 (13-2) J W DERRICK' ,`LotDesciption` = 'Corner' ,`LotSize` = '5140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Derrick J W' ,`TaxAmount` = '2576' ,`TaxRate` = '1.9548' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652988' WHERE `Matrix_Unique_ID` = '211817717' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:54:11.143' ,`MLSNumber` = '2618357' ,`ListAgentFullName` = 'Ryan Harvey' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.695262' ,`Longitude` = '-95.759363' ,`PhotoCount` = '24' ,`PostalCode` = '77407' ,`RoomCount` = '4' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Jacobs Well' ,`StreetNumber` = '7422' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2146' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL 4BR - 2 Bath, ONE STORY home in the friendly Lost Creek neighborhood! This home has it all, great floorplan, open kitchen with granite countertops, storm windows, BRAND NEW bathrooms, fencing and floors throughout (all installed 2022), water softener/filtration system, and even a unique/super convenient water shut off control inside the laundry room! NEVER FLOODED!\r\n\r\nWalk into a cute formal sitting area, with custom archways for extra charm! Continue into the open kitchen and eating area. Enjoy the cozy fireplace in the family room or sit on the covered back porch and enjoy your nice sized back yard! Spread out in the 3 secondary bedrooms with a JUST UPDATED bath. Finally, make your way to the master bedroom with another beautiful, JUST UPDATED bath that is sure to wow! Separate shower/tub, double sinks and a large walk in closet! Buyer will need to provide survey. \r\n\r\nMake an appointment to come see this one, it will not last long!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOST CREEK SEC 2, BLOCK 2, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6426' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '726' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ADOLPHUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lost Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652988' WHERE `Matrix_Unique_ID` = '211875830' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:06:28.120' ,`MLSNumber` = '81803723' ,`ListAgentFullName` = 'Chris Cameron' ,`ListOfficeName` = 'Legacy South Realty, LLC' ,`SellingAgentFullName` = 'Dea Provenzano' ,`SellingOfficeName` = 'Provenzano Properties' ,`Latitude` = '29.033822' ,`Longitude` = '-95.560471' ,`PhotoCount` = '23' ,`PostalCode` = '77422' ,`RoomCount` = '5' ,`ListPrice` = '199000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Avenue G' ,`StreetNumber` = '202' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1294' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remodeled 3 bedroom, one bath brick house. Looks like a new house inside. New floors ,new kitchen, new bathroom. Double pane windows. New light fixtures and ceiling fans. Large mature trees, flower beds are new. Home is ready to move into. Good for a starter home or downsizing. Did not flood in Harvey.' ,`Acres` = '0.1928' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GARDEN ACRES (BRAZORIA) BLK 7 LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8398' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Garden Acres Brazoria' ,`TaxAmount` = '2684' ,`TaxRate` = '2.3372' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652988' WHERE `Matrix_Unique_ID` = '211919918' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T06:19:32.070' ,`MLSNumber` = '80317230' ,`ListAgentFullName` = 'Frank York' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.787374' ,`Longitude` = '-95.443431' ,`PhotoCount` = '39' ,`PostalCode` = '77055' ,`RoomCount` = '7' ,`ListPrice` = '835000.00' ,`Status` = 'Active' ,`StreetName` = 'Somerset York' ,`StreetNumber` = '3710' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3085' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 3710 Somerset York, a 3-story single family home that provides the lock & leave lifestyle you deserve. The first floor boasts an open concept interior, well-appointed Kitchen with island & Dacor refrigerator, Dining & Family room providing exceptional space for large scale entertaining or quiet evenings at home. This home is one of a few offering a private turfed backyard with ambient Lutron lighting & gas grill. The second floor is home to the spacious Owners Retreat with sitting room, private covered balcony, spa inspired bath, full coffee/wet bar with two refrigerated drawers, massive walk-in closet & Laundry Room with front loading washer & dryer. The third floor is highlighted by two secondary bedrooms, one with en-suite. Also located on the third floor is an incredible game or media room with sound, additional bath & private covered balcony. Powered shades, Lutron lighting, gleaming wood floors, water booster, tankless water heater & much more! Welcome Home!' ,`Acres` = '0.0517' ,`Area` = '9' ,`BuilderName` = 'Toll Brothers' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 SOMERSET GREEN SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2254' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Somerset Green Sec 5' ,`TaxAmount` = '13174' ,`TaxRate` = '2.83' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652989' WHERE `Matrix_Unique_ID` = '212072276' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:26:11.807' ,`MLSNumber` = '55682513' ,`ListAgentFullName` = 'Angela Ojeda' ,`ListOfficeName` = 'DOSS Pros, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825052' ,`Longitude` = '-95.442635' ,`PhotoCount` = '22' ,`PostalCode` = '77018' ,`RoomCount` = '3' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Althea' ,`StreetNumber` = '1705' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1521' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to 1705 Althea Dr. located in the highly desired Oak Forest Subdivision. The pride of ownership shows in this one and no expense was spared. This beautiful one story home offers 3 bedrooms, 2 bathrooms, hardwood floors, crown moulding, and a modern gourmet kitchen perfect for the chef of the family! The grand island seperates the kitchen and family room and is the heart of the home and perfect for entertaining. Dont forget to step outside and and admire the large backyard with covered patio, detached oversize 2 car garage, and a long \r\ngated driveway for extra privacy. Easy access to shopping, restauraunts, 610 and 290! Make your appointment to see this one today!' ,`Acres` = '0.1667' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 36 BLK 51 OAK FOREST SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oak Forest Sec 06' ,`TaxAmount` = '11643' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652989' WHERE `Matrix_Unique_ID` = '212331159' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:13:25.807' ,`MLSNumber` = '60200891' ,`ListAgentFullName` = 'Bobbie Higginbotham' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.558938' ,`Longitude` = '-95.429398' ,`PhotoCount` = '25' ,`PostalCode` = '77584' ,`RoomCount` = '8' ,`ListPrice` = '362000.00' ,`Status` = 'Active' ,`StreetName` = 'Moonlit Lake' ,`StreetNumber` = '13420' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2329' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A lovely home nestled in the beautiful and highly desired neighborhood of Shadow Creek Ranch. Welcome your guest to your lovely 3 bedrooms, 2 full bathrooms, spacious office with walls of built-in shelving. You\'ll love the free-flowing floor plan between the dining roomm, kitchen, & living areas, wired for surround sounds w/plenty of flexibility for entertaining. The kitchen overlooks the living area & features granite countertops, a sizable pantry w/SS appliances. A wall of large windows to let in all the natural light to greet you each morning. Spacious Primary suite w/a garden tub, dbl sinks, glass enclosed shower, walk-in closets. Crown molding through the home. Backyard with a patio, room to play and is low maintenance, no backyard neighbors. Recent flooring in common areas June 2020, water heater, & AC system in the last 2 yrs. Easy walking distance to great amenities including walking trails, community pools, playgrounds + zoned to Alvin ISD schools! PER SELLER NEVER FLOODED' ,`Acres` = '0.142' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF41 (PEARLAND), BLOCK 1, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6186' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'YORK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MCNAIR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf1-Sf2-Sf3' ,`TaxAmount` = '9162' ,`TaxRate` = '3.5409' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652989' WHERE `Matrix_Unique_ID` = '212366331' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:29:56.617' ,`MLSNumber` = '46061002' ,`ListAgentFullName` = 'Lindsay Landin' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.179984' ,`Longitude` = '-95.514544' ,`PhotoCount` = '47' ,`PostalCode` = '77381' ,`RoomCount` = '9' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Copperknoll' ,`StreetNumber` = '179' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2430' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one story home that has been meticulously cared for in the established neighborhood of Retreat at Copperknoll in The Woodlands offers a gated courtyard patio w/ beautiful foliage & trees. Bright and open floor plan w/ beautiful tile & eng. wood floors, crown molding, plantation shutters, & large expansive windows offering natural light throughout. This home has a gas log fireplace, built-in shelves in freshly painted living area & a nice quiet atrium that is easily maintained. Bright separate kitchen w/ ample cabinet space, walk-in pantry, office nook & cozy breakfast area. Executive study w/ French doors, built-in shelving & overlooking atrium, could also be used as a flex room. Large primary w/ double glass doors to patio, dual vanity, soak-in tub, separate glass shower & two large walk-in closets in primary. A DREAMY oversized attic space!!! This home has been pet & children free since it was built in 1990. \r\nWasher, Dryer & new Refrigerator included in sale of property.' ,`Acres` = '0.2047' ,`Area` = '15' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S972227 - WDLNDS VIL COCHRANS CR 27, BLOCK 2, LOT 2' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '8917' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'DAVID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Cochrans Cr 27' ,`TaxAmount` = '7240' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652989' WHERE `Matrix_Unique_ID` = '212411665' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:00:34.410' ,`MLSNumber` = '49098050' ,`ListAgentFullName` = 'Tosha Hypolite' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = 'Carla Tran' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '29.503450' ,`Longitude` = '-95.392658' ,`PhotoCount` = '29' ,`PostalCode` = '77578' ,`RoomCount` = '8' ,`ListPrice` = '275000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Old Presidio Way' ,`StreetNumber` = '16' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This ONE STORY home located in Rodeo Palms Master Planned community is THE ONE! This charming home includes a large kitchen with lots of cabinet space, new stainless steel appliances and an adorable breakfast area with window seating. This beautiful home has a lovely formal dining room and family room that\'s perfect for entertaining. The large Office/Study has two entrances. The beautiful ensuite is spacious and large enough to accommodate over sized furniture. It is also equipped with double sinks, and a large soaking tub with a separate shower. The large backyard that\'s newly fenced, has a garden box with solar lighting and is the perfect backdrop for your backyard oasis. This home has a new hot water heater and AC unit. Rodeo Palms is a lovely community that has several sparkling lakes, pocket parks, and a pool area. Located not far from Pearland Town Center and Downtown Houston, this beautiful home is perfect. Schedule your showing today!' ,`Acres` = '0.1326' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RODEO PALMS PALM VILLAS SEC 1 (A0459 ACH&B)(MANVEL) BLK 3 LO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5776' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms, Palm Villas Sec 1' ,`TaxAmount` = '7721' ,`TaxRate` = '3.6694' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652989' WHERE `Matrix_Unique_ID` = '212432209' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:23:16.947' ,`MLSNumber` = '24918409' ,`ListAgentFullName` = 'Janice Poscovsky' ,`ListOfficeName` = 'Spouses Selling Houses' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.572536' ,`Longitude` = '-95.579315' ,`PhotoCount` = '37' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '373000.00' ,`Status` = 'Active' ,`StreetName` = 'Cotter Lake' ,`StreetNumber` = '4919' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2272' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Prime location in highly sought after First Colony, conveniently located to local groceries, retail shopping and wonderful restaurants. Zoned to highly rated schools. Recently refreshed with full interior paint and new upstairs carpet, this east facing home has primary bedroom down with ensuite bath. New 3 inch blinds on all windows. Spacious kitchen with granite counters and lots of cabinets plus an island workspace. Kitchen sink window looks out into the fenced back yard. Driveway door to kitchen makes grocery unloading a breeze. Walking distance to Aquatic center with Olympic lap pool and leisure pool that has lazy river, splash pad, vortex pool and tube slide.' ,`Acres` = '0.1799' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE COLONY SEC 2, BLOCK 1, LOT 31' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7836' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '812' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'AUSTIN PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Colony Sec 2' ,`TaxAmount` = '6468' ,`TaxRate` = '2.71' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652990' WHERE `Matrix_Unique_ID` = '212442981' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:04:24.370' ,`MLSNumber` = '39973028' ,`ListAgentFullName` = 'Chris Cameron' ,`ListOfficeName` = 'Legacy South Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.391304' ,`Longitude` = '-95.222563' ,`PhotoCount` = '19' ,`PostalCode` = '77511' ,`RoomCount` = '9' ,`ListPrice` = '357800.00' ,`Status` = 'Active' ,`StreetName` = 'Sherwood' ,`StreetNumber` = '111' ,`StreetSuffix` = 'Drive' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2407' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '6 CAR GARAGE in Hillcrest (Timberlane Manor). House is in an established neighborhood with a large lot and huge oak trees. Back yard is fenced with metal posts. Covered patio has evening shade. Large Den with vaulted ceilings with gas and gas log fireplace, also has built in cabinets across one wall. Large bedrooms with ceiling fans in all rooms. Doorways are large enough to accommodate a wheelchair. Neighborhood has wide streets. . Plumbing in entire house has been re done recently.' ,`Acres` = '0.4683' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TIMBERLANE MANOR (A0161 B B B & C), LOT 70-W/2 LOT 71' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '20399' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WALT DISNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timberlane Manor' ,`TaxAmount` = '6043' ,`TaxRate` = '2.5148' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652990' WHERE `Matrix_Unique_ID` = '212604910' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:24:18.880' ,`MLSNumber` = '78996230' ,`ListAgentFullName` = 'L Gregory Dorsey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.443806' ,`Longitude` = '-95.446540' ,`PhotoCount` = '25' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Sapphire Creek' ,`StreetNumber` = '9443' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous, well-maintained, one owner home will encourage you to plant your feet in the sought after, gated, master-planned community of Sterling Lakes. This beautiful LGI home boasts 5 spacious bedrooms (any of which could serve as a flex room, gym or office) and a large game room with views of the beautiful, calming lake. \r\n\r\nThis home sits at the end on a premium, cul-de-sac lot. Seller upgrades include freshly painted walls throughout, grey-toned laminate flooring, Honeywell thermostat, Smart Home security system, and Eufy Home doorbell and smart front door lock. Outside the home, enjoy an upgraded, custom designed landscape retaining wall. No need to worry about walking through wet grass as you head to the backyard with limestone pavers surrounded by Blackstar gravel! \r\n\r\nEnjoy time with the family at the community tennis courts, Splashpad Texas, junior Olympic sized swimming pool, basketball court, and clubhouse, or travel amongst the miles of paved walking trails.' ,`Acres` = '0.1532' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING LAKES AT IOWA COLONY SEC 12A (A0289 HT&B) BLK 2 LOT' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6673' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Lakes At Iowa Colony' ,`TaxAmount` = '10324' ,`TaxRate` = '3.4099' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652990' WHERE `Matrix_Unique_ID` = '212638754' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:36:50.353' ,`MLSNumber` = '47444434' ,`ListAgentFullName` = 'Morad Fiki' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = 'Beckie Martinez' ,`SellingOfficeName` = 'Keller Williams RealtyNortheast' ,`Latitude` = '29.680021' ,`Longitude` = '-95.174805' ,`PhotoCount` = '30' ,`PostalCode` = '77502' ,`RoomCount` = '3' ,`ListPrice` = '190000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Purdue' ,`StreetNumber` = '2206' ,`StreetSuffix` = 'Street' ,`City` = 'Pasadena' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1027' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gem with beautiful updates throughout! This single-story residence is located on a quiet street and features a beautiful fresh painted brick facade, a bright and open floor plan, and updated interior finishes. Inside the home, you’ll find stunning vinyl flooring, neutral fresh paint, and new doors throughout! The home features new blinds, new fans, new fixtures and so much more! The updated kitchen offers modern cabinetry, granite countertops, stunning tile backsplash, a pantry, and stainless steel appliances. All the bedrooms include luxurious flooring and a neutral color palette. The bathroom has a brand new vanity and is ready for relaxation! The garage is freshly painted and can easily be used for extra storage! The backyard features a covered patio and is ready for entertaining! Enjoy a great location near schools, shopping, restaurants, and easy access to major freeways!\r\nDon’t miss the opportunity to own this gorgeous home!' ,`Acres` = '0.1389' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 1 FIELDCREST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MAE SMYTHE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHMORE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fieldcrest' ,`TaxAmount` = '3110' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652990' WHERE `Matrix_Unique_ID` = '212757880' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T06:02:13.950' ,`MLSNumber` = '18247969' ,`ListAgentFullName` = 'Bruce Brittimes' ,`ListOfficeName` = 'Brittimes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.637938' ,`Longitude` = '-95.512749' ,`PhotoCount` = '10' ,`PostalCode` = '77071' ,`RoomCount` = '3' ,`ListPrice` = '272000.00' ,`Status` = 'Active' ,`StreetName` = 'La Rochelle' ,`StreetNumber` = '7806' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2508' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fonmeadow Community, introducing this beautiful 3 bedrooms, 3.5 bathrooms and 2 car garage home. Living Room and formal dining room are breathtaking. Gas wood burning fireplace in the living room. Granite tops in kitchen and bar area. Kitchen is connected to sun room. Large Primary bedroom on the 1st floor. 2nd floor have 2 bedrooms and very large gameroom. Walking distance to community park and pool.' ,`Acres` = '' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'lt 73 blk 1 Fonmeadow Sec 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GROSS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'fonmeadow' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652990' WHERE `Matrix_Unique_ID` = '212795186' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T06:40:19.730' ,`MLSNumber` = '13694041' ,`ListAgentFullName` = 'Joshua Haynie' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.946322' ,`Longitude` = '-95.368361' ,`PhotoCount` = '11' ,`PostalCode` = '75862' ,`RoomCount` = '2' ,`ListPrice` = '65000.00' ,`Status` = 'Active' ,`StreetName` = 'South' ,`StreetNumber` = '102' ,`StreetSuffix` = 'Street' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '804' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to own in growing Trinity with close proximity to lake Livingston. Property does need some TLC but would make a great rental for residual income. No HOA, low taxes, almost 1/2 acre (2 lots) and close to downtown.' ,`Acres` = '0.449' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Trinity Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'BELL P.A. ADDN, LOT 19,20' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '19560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bell P A Add' ,`TaxAmount` = '784' ,`TaxRate` = '2.5001' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652990' WHERE `Matrix_Unique_ID` = '212875094' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:08:05.653' ,`MLSNumber` = '34056729' ,`ListAgentFullName` = 'Veso Kossev' ,`ListOfficeName` = 'The Kossev Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.920668' ,`Longitude` = '-95.573198' ,`PhotoCount` = '34' ,`PostalCode` = '77064' ,`RoomCount` = '9' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Pony Express' ,`StreetNumber` = '10223' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2487' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous 2 story home, 3 bedroom 2.5 bath home zoned to Cy-Fair ISD and move in ready! This open concept floor plan, perfect for entertaining, offers an abundance of natural light and laminate floors. Open kitchen design w/granite counters, natural stone backsplash, stainless appliances and a breakfast bar/pass through to the living room. Completing the 1st floor are a formal living and dining room, and family room with vaulted ceiling and fireplace. The 1st floor primary is spacious with 2 walk-in closets and an en-suite bathroom with dual sinks and a separate walk-in shower and bathtub. The 2nd floor is complete with 2 secondary bedrooms, 1 bathroom and a game room that overlooks the family room. The easily maintained backyard is fully fenced. The Neighborhood Park and pool are a short walk away and the home is conveniently located close to 290, Beltway 8 and SH249. Make an appointment to see this home today! Roof replaced in 2020.' ,`Acres` = '0.1213' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Jersey Village' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 3 WILLOW POINTE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5285' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BANG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Pointe' ,`TaxAmount` = '6243' ,`TaxRate` = '2.641' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652991' WHERE `Matrix_Unique_ID` = '212889789' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:27:01.163' ,`MLSNumber` = '78889879' ,`ListAgentFullName` = 'Tiffany Bean' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.922971' ,`Longitude` = '-95.668652' ,`PhotoCount` = '31' ,`PostalCode` = '77095' ,`RoomCount` = '8' ,`ListPrice` = '440000.00' ,`Status` = 'Active' ,`StreetName` = 'Heron Meadows' ,`StreetNumber` = '10111' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GATE CODE FOR OPEN HOUSE SAT 10/1 1-4PM IS: 50216 Rare opportunity to live right on a golf course! This gorgeous 4BD, 3BTH home sits on the 7th fairway and offers sweeping 2-story panoramic views of the golf course and private access to the course. Located in the sought-after Stone Gate community, the area provides the perfect balance of modern amenities and convenience with access to 2,000 acres of lakes, golfing, parks, excellent schools, proximity to interstate 290 and 99, world-class shopping and dining at Towne Lakes Boardwalk and the Outlet Mall. The home features a 46’ x 16’ covered patio with brick columns, modern upgraded fixtures, beautiful macadamia porcelain tiles, custom molding, enlarged living room, study with charming french doors, floor-to-ceiling built-in shelving, updated Rheem AC, and best of all, a new 50-year roof and extensive privacy with mature Oak and Crepe Myrtle trees surrounding the home.' ,`Acres` = '0.2319' ,`Area` = '8' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 49 BLK 1 STONE GATE SEC 15' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '10101' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1140' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BIRKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Gate Sec 15' ,`TaxAmount` = '7454' ,`TaxRate` = '2.561' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652991' WHERE `Matrix_Unique_ID` = '212947915' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212968717','1664652991','212968717','2022-10-01T07:05:26.830','19140535','Joy Samuel','Prompt Realty & Mortgage, Inc','','','29.531733','-95.472538','0','77545','4','529000.00','Active','San Bernard','2727','Drive','Fresno','3','1','4','2889','Single-Family','Never lived ready to move in One of a kind unique spacious single story Ashton woods Hanover model. No more lots available to build this model. 40k upgrades. Incredible 4-bedroom 3.5 bath, tandem three car garage, 8\' doors everywhere, high ceiling, formal dining, wow !!!!huge kitchen island open to family room, 42\" cabinets, pull out double trash can under the countertop, remote controlled fireplace, large utility, Gameroom/media room, bedrooms and family rooms are with carpet, entry dining etc. with tiles, covered patio with gas line, hot/cold water line for outside kitchen, sprinkler system, garage door opener, 2\" fox wood blinds for all windows. see to believe .........!!!!! . Fort bend School district and utilities even though in Fresno.','','38','AW','','','','No Disclosures,Owner/Agent','','','','Missouri City Area','Central Gas','1','Lot 7, Block 2 Shipman\'s Cove sec-2','Patio Lot','7500','Appraisal District','','1000','1','Never Lived In','3','','0','','','','','Composition','19 - Fort Bend','GOODMAN ELEMENTARY SCHOOL (FORT BEND)','HIGHTOWER HIGH SCHOOL','LAKE OLYMPIA MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Builder','1','Traditional','Shipman\'s Cove','','3.29','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212971572','1664652991','212971572','2022-10-01T07:55:14.620','34225298','James Payne Jr','Keller Williams Realty - Clear Lake/ NASA','','','29.386014','-94.948006','17','77590','2','220000.00','Active','3rd','3435','Avenue','Texas City','2','0','2','1316','Single-Family','Beautiful home located in Texas City. Easy access to all major roads and shopping centers. All rooms are large in size, also has a large back yard with fence. Large Walkin closets. No Mud TAXES OR HOA. Don\'t miss out on this one.','0.2961','33','','','','','Sellers Disclosure','','','','Texas City','Central Gas','0','ABST 63 PAGE 5 LOTS 7 & 8 (7-1) BLK 140 KOHFELDT 2ND ADDN','Other','12900','Appraisal District','','','0','','1','','0','','','Gas Cooktop','','Composition','52 - Texas City','HAYLEY ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','1','Ranch','Kohfeldt 2nd','5607','2.5335','Public Sewer,Public Water','2015','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213026193','1664652991','213026193','2022-10-01T07:16:47.827','66912660','Keith Rodgers','Realty ONE Group Iconic','','','30.149534','-95.382300','45','77386','11','550000.00','Active','Postwood Oaks','31426','Court','Spring','3','1','3','3403','Single-Family','LIKE NEW! This Village Builders 1.5 Story \'\'Marseille\'\' Floor Plan features 3/3.5/2 Car Garage w/ Storage + Epoxy Floors. Complete w/ Home Office, Game Room & Media Room! Dream Kitchen w/Maple Cabinets, Stone Cooktop Surround Sound, Granite, SS Appliances. Open to Family Room with FP. Elegant 7\'\' Oak Harwood Floors! Luxury Master Bath w/Granite, Corner Tub & Huge Walk In Custom Closet. Screened in Extended Covered Back Patio, Gated Front Courtyard. LARGE Cul-de-sac lot! In addition to all of these amazing features the Falls at Imperial Oaks Community has many amenities, including the Lake Club with indoor exercise and weight room, picnic areas, lighted tennis courts, outdoor playgrounds. Nearby Lake Holcomb and YMCA Boasts Nature Trails, Benches, Fishing Dock and Picnic Area. Zoned to CISD Grand Oaks High. Quick access to IAH and within minutes of The Woodlands Waterway, Hughes Landing, Market Street, Valley Ranch with lots of great shopping and dining. Check out the 3D Virtual Tour','0.2594','15','Village Builders','','','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Spring Northeast','Central Gas,Zoned','1','S504212 - FALLS AT IMPERIAL OAKS 12, BLOCK 2, LOT 23','Corner,Cul-De-Sac,Subdivision Lot','11299','Appraisal District','','650','0','','2','','0','','','','','Composition','11 - Conroe','BIRNHAM WOODS ELEMENTARY SCHOOL','GRAND OAKS HIGH SCHOOL','YORK JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1.5','Traditional','Falls At Imperial Oaks 12','12192','3.0687','Public Sewer,Public Water,Water District','2015','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213030286','1664652991','213030286','2022-10-01T07:00:01.200','42664857','LaKitsha Lagunes','Home Alliance Group','','','29.834921','-95.223057','30','77044','7','325000.00','Active','Nodding Pines','7610','Lane','Houston','2','0','3','1905','Single-Family','Treat yourself to a little slice of country heaven! Come and take a look at this gem located in Ralston Acres sitting on just over 2 acres with no restrictions and no HOA! The home features 3 bedrooms, 2 bathrooms, 2 car detached garage, recent roof, large living area, laundry room, storage shed and much more. Come and join this family-oriented community with easy access to Sam Houston Tollway and Highway 90, as well as numerous restaurants and shopping centers. Your 2-acre, unrestricted country oasis awaits! Schedule a showing before it\'s too late!!','2.0182','2','','','','','Sellers Disclosure','','','1','North Channel','Central Gas','0','LTS 32 & 33 RALSTON ACRES','Subdivision Lot','87912','Appraisal District','','','0','','1','','0','','','','','Composition','46 - Sheldon','ROYALWOOD ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','C.E. KING MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Ranch,Traditional','Ralston Acres','4091','2.2893','Well','1970','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213081010','1664652991','213081010','2022-10-01T07:51:06.597','61278777','Betty Taylor','Coldwell Banker Realty','','','29.562685','-95.338090','18','77581','10','340000.00','Active','Stone Arbor','7614','Lane','Pearland','2','0','3','2020','Single-Family','Open & bright 3/2/2. Nice entry with art nooks, columns & arched door ways. Study with glass doors, split bedrooms, large kitchen w/stainless refrigerator, breakfast room open den w/fireplace, separate tub & shower in master, formal dining, covered patio and fenced yard. Available Oct. 1st,2022 NO PETS!','','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Pearland','Central Gas','0','AVALON TERRACE SEC 2 (A0505 H T & B) BLK 1 LOT 7','Subdivision Lot','6600','Appraisal District','','','0','','2','Electric Oven','0','','','Gas Range','','Composition','42 - Pearland','LAWHON ELEMENTARY SCHOOL','GLENDA DAWSON HIGH SCHOOL','PEARLAND JUNIOR HIGH WEST','Appointment Required,Lockbox Front,No Supra Keybox','Appraisal District','1','Traditional','AVALON TERRACE SEC 2 (A0505','','','Public Sewer,Public Water,Water District','2007','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:23:06.963' ,`MLSNumber` = '17772339' ,`ListAgentFullName` = 'Houston Posey' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.016529' ,`Longitude` = '-95.324475' ,`PhotoCount` = '45' ,`PostalCode` = '77338' ,`RoomCount` = '12' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Twain Mark' ,`StreetNumber` = '6522' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better than new! This immaculately cared for home has it all including a beautiful 42\'x25\' covered back patio with stamped/stained concrete and gorgeous 6\" beaded Aspen wood ceiling backing up to the neighbors 5-acre property providing added privacy. Master has an updated walk-in shower. Includes a formal living; extremely large family room; large secondary rooms with large closets. Upstairs game room is a must see with unique den attached. Wood blinds; and has a 7x10 shoe room just for shoes!' ,`Acres` = '0.1687' ,`Area` = '12' ,`BuilderName` = 'Long Lake LTD' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 1 CYPRESSWOOD POINT SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7348' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '310' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Pt Sec 03' ,`TaxAmount` = '8117' ,`TaxRate` = '2.7734' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652991' WHERE `Matrix_Unique_ID` = '213090720' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T06:36:57.243' ,`MLSNumber` = '37819644' ,`ListAgentFullName` = 'Jesica Anderson' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.731113' ,`Longitude` = '-95.515049' ,`PhotoCount` = '34' ,`PostalCode` = '77063' ,`RoomCount` = '8' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Roseland Terrace' ,`StreetNumber` = '3115' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 3-story home with 4 Bedrooms and 3.5 Bathrooms in Briarmont gated community.\r\nOn the first floor you will find a secondary Bedroom with a full Bathroom and a Game or TV Room. This is a perfect separate/private space for a teen, the in-laws or the dear friends that come to visit.\r\nOn the second level is where the heart of this home is. This ample open floor plan is a perfect space to entertain. Elegant wood flooring throughout the Living, Dining and Kitchen. The Kitchen displays SS appliances, beautiful Silestone countertops and a large island kitchen with breakfast bar.\r\nOn the third floor you will find the Primary Bedroom with an En-suite, 2 secondary Bedrooms, a full Bathroom and the Laundry Room. The serene Primary Bedroom displays a beautiful faux wood wall & the Bathroom has dual vanities, a tub and separate shower.\r\nConveniently located between Westpark Toll, Beltway 8 and 610. Close to the Galleria and all the amazing restaurants and stores in the area. Schedule a tour!' ,`Acres` = '0.0374' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Briarmeadow/Tanglewilde' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 BRIARMONT SEC 1' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1631' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2065' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PINEY POINT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarmont Sec 1' ,`TaxAmount` = '8914' ,`TaxRate` = '2.4216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652991' WHERE `Matrix_Unique_ID` = '213094506' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:58:54.060' ,`MLSNumber` = '39464081' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.201022' ,`Longitude` = '-95.337358' ,`PhotoCount` = '36' ,`PostalCode` = '77302' ,`RoomCount` = '6' ,`ListPrice` = '515990.00' ,`Status` = 'Active' ,`StreetName` = 'Berry Brook' ,`StreetNumber` = '15076' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2741' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 39464081 - Built by Highland Homes - December completion! ~ Fall in love with this great one story design with high ceilings and lots of natural light. Open kitchen/dining area and family room, expanded secondary bedrooms, study, and media room. Great island kitchen with wood cabinets, quartz countertops, and stainless steel appliances too! Nothing like a Highland Home with its tankless water heater, 8\' solid core doors, and whole home dehumidifier. Sprinkler system, full gutters, full sod, and 3 car tandem garage. Don\'t miss out on this one!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot: 13 Section: 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9367' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664652992' WHERE `Matrix_Unique_ID` = '213109848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:43:59.957' ,`MLSNumber` = '83864892' ,`ListAgentFullName` = 'Yvonne Pruneda' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.965858' ,`Longitude` = '-95.625910' ,`PhotoCount` = '22' ,`PostalCode` = '77429' ,`RoomCount` = '12' ,`ListPrice` = '687990.00' ,`Status` = 'Active' ,`StreetName` = 'Texas Army' ,`StreetNumber` = '12435' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1607' ,`Area` = '10' ,`BuilderName` = 'New Elite Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 8 SARACEN PARK SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9935' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Saracen Park Sec 3' ,`TaxAmount` = '360' ,`TaxRate` = '2.5737' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664652992' WHERE `Matrix_Unique_ID` = '213124973' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213125639','1664652992','213125639','2022-10-01T06:21:40.567','95811441','Maricela Benton','Lea Homes Realty INC','','','30.830596','-95.131839','32','77360','3','316950.00','Active','Cattle','273','Drive','Onalaska','2','0','3','1811','Single-Family','Lea Homes is offering this 3 bedroom, 2 bath signature series home that features a modern theme with trend conscious colors and 8 ft plank flooring throughout entire home (no carpet). The home sits on a large lot with a privacy fenced backyard. The home has 10-foot ceilings throughout and 11-foot ceilings in family room and extra-large primary bedroom. The kitchen features upgraded quartz countertops, 42-inch cabinets, brush nickel faucets, hardware and door levers, also a Samsung appliance package. Dining room has a modern chandelier and living room and primary bedroom have trendy ceiling fans. The primary bathroom includes an oversize fully tiled walk-in shower with a built-in seat and an added window for light. The antique porcelain tile floors and designer mirrors make it a real treat after a long day. An efficient Carrier HVAC system with digital thermostat will keep your electricity bills low. The subdivision has a private boat ramp for homeowners.','0.1964','44','LEA HOMES INC','','Electric Dryer Connections','','Sellers Disclosure','1','','','Lake Livingston Area','Central Electric','1','Texas Acres SEC 3 BLK 13 LOT 15','Cleared,Subdivision Lot','8625','Appraisal District','','26','1','Never Lived In','2','','0','','','Electric Range','','Composition','104 - Onalaska','ONALASKA ELEMENTARY SCHOOL','ONALASKA JR/SR HIGH SCHOOL','ONALASKA JR/SR HIGH SCHOOL','Accompany,Appointment Required','Builder','1','Contemporary/Modern','Texas Acres','44','2.0361','Public Sewer,Public Water','2021','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213127688','1664652992','213127688','2022-10-01T06:28:43.243','15539537','Juria Taylor','Taylor Signature Properties','','','30.024988','-95.385928','27','77073','4','238500.00','Active','Jamals','21418','Way','Houston','2','0','4','1650','Single-Family','Welcome Home!!! To this beautiful, spacious, well maintained 4 bedroom, 2 bath, 2 car garage, 1 story home. This charming home has a open layout and is situated on a cul de sac street. Includes access to an area pool in the community. Just 15 minutes away for The Woodlands Mall! Grocery is near by, Mercer Botanic Gardens and Mercer Playground & Post Oak Picnic Pavilion just 6 minutes away.','0.1085','12','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Aldine Area','Central Gas','1','LT 51 BLK 3 WERRINGTON PARK SEC 3','Subdivision Lot','4725','Appraisal District','','570','0','','2','Gas Oven','0','','','Gas Range','','Composition','1 - Aldine','OGDEN ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','TEAGUE MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Ranch','Werrington Park Sec 3','3736','2.9808','Water District','2013','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T07:12:08.463' ,`MLSNumber` = '23804421' ,`ListAgentFullName` = 'Jennifer Hill' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.033823' ,`Longitude` = '-95.512962' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '8' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Butteroak Dr' ,`StreetNumber` = '17027' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2906' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous home, located in highly desirable Spring Creek Oaks. The home has been updated with double-paned windows and new hvac systems with transferrable warranty. Laminate wood look flooring added downstairs and all new kitchen appliances to the updated kitchen featuring your very own coffee bar. The laundry room has been opened and expanded. Great layout with multiple entertaining rooms. You will not be disappointed in all this home has to offer. Call for your appointment today!' ,`Acres` = '' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lt 14 Blk 2 Spring Creek Oaks' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8049' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '991' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KUEHNLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Creek Oaks' ,`TaxAmount` = '' ,`TaxRate` = '2.5965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652992' WHERE `Matrix_Unique_ID` = '213129526' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T06:07:34.370' ,`MLSNumber` = '11833259' ,`ListAgentFullName` = 'Lisa Arthur' ,`ListOfficeName` = 'Arthur Realty Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.095680' ,`Longitude` = '-95.108784' ,`PhotoCount` = '40' ,`PostalCode` = '77554' ,`RoomCount` = '9' ,`ListPrice` = '799900.00' ,`Status` = 'Active' ,`StreetName` = 'Estuary' ,`StreetNumber` = '26934' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2233' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LUXURIOUS NEW BUILD at Pointe West. With 4 bedrooms, 3.5 baths and a gameroom, this will make a great second home or vacation rental. Forecasting tools show rental projections > $100K/year. Photos are of a finished home with a very similar floorplan. This one is scheduled for January 2023 completion, so you still have time to make some changes. Great location w unobstructed beach views, only a short walk to Pointe West\'s heated Lazy River Pool and a short golf cart ride to the beach and Beach Club with infinity pool, fitness center, grilling areas, cabanas game room, restaurant, & bar. Pointe West has by far the best beach on Galveston Island - it\'s a large, clean pedestrian only beach that\'s never crowded. Family friendly community w several playgrounds, sports court, miles of golf cart trails, security patrol and quiet hours that start at 10 pm. All new construction here must meet strict architectural & quality standards. Only approved builders are allowed to build here.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Stately Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'POINTE WEST SEC 4-B (2006), ABST 121, BLOCK 1, LOT 2, ACRES' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '4000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'POINTE WEST' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664652992' WHERE `Matrix_Unique_ID` = '213147685' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213164371','1664652992','213164371','2022-10-01T06:02:43.073','19628222','Paul Martinez','Coldwell Banker PropertiesUnlimited','','','29.720095','-96.156967','12','77474','10','279000.00','Active','Kayleen','1849','Lane','Sealy','2','0','4','2046','Single-Family','Just minutes from Katy is a home that you must see. Not only will you be thrilled by the new vinyl plank floor, you will also be delightfully impressed by the huge lot and portable storage building. Don\'t miss your chance!','0.937','57','','','','','Sellers Disclosure','','','','','Central Electric','0','MEADOW VIEW ESTATES BLOCK 1 LOT 30B REAL PROPERTY LABEL # NT','Subdivision Lot','40816','Appraisal District','','','0','','0','','0','','','','','Composition','109 - Sealy','SELMAN ELEMENTARY SCHOOL','SEALY HIGH SCHOOL','SEALY JUNIOR HIGH SCHOOL','Accompany,Leave Business Card,Lockbox Front','Appraisal District','1','Other Style','Meadow View Estates','2084','1.8832','Septic Tank,Well','2003','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-01T06:51:03.940' ,`MLSNumber` = '38431226' ,`ListAgentFullName` = 'Truong Bui' ,`ListOfficeName` = 'RE/MAX Alliance' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.857894' ,`Longitude` = '-95.813897' ,`PhotoCount` = '40' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '319999.00' ,`Status` = 'Active' ,`StreetName` = 'LONGHORN RUN' ,`StreetNumber` = '5822' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to Katy Crossing! Beautiful & clean-as-a-whistle 4-bedrooms/2-baths is in the heart of Katy. White cabinets kitchen with upgraded back flash and quartz counter-top. Open concept living area. Huge Primary Bedroom. Good size secondary bedrooms. Three-sided bricks with two-car attached garage. Enjoy outdoor living and relaxation in the backyard with covered patio and extended concrete deck. Close to Katy Mills shopping, H-town, and other entertainment and dining. Exemplary Katy School District. COME AND SEE!!!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'PULTE HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TR 1C ABST 453 H&TCRR SEC 67 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4740' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Crossings' ,`TaxAmount` = '41134' ,`TaxRate` = '3.4768' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664652992' WHERE `Matrix_Unique_ID` = '213178876' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213179308','1664652993','213179308','2022-10-01T07:37:40.633','39734202','Dalvin Glover','Geek Realty Group','','','30.163611','-95.320009','13','77365','3','224999.00','Active','Oak Knoll','16749','Drive','Porter','2','0','3','1288','Single-Family','Recently remodeled 3BD/2BA home located in Porter, Tx. Home sits on over half an acre and has been recently updated with a new roof, new HVAC and water heater, new electrical, and new plumbing with grease trap. New appliances, cabinets, granite countertops, and ceiling fans have been installed as well as fresh paint and new floors throughout. The open concept kitchen has a view to the dining room and living room with sliding doors that bring in lots of natural light. Master bedroom has double closets and an en suite bathroom with double vanity. No HOA fees!','0.5739','40','','','','','Sellers Disclosure','','','','Porter/New Caney West','Central Electric','0','LIVE OAKS EST 04, BLOCK 2, LOT 15','Subdivision Lot','25000','Appraisal District','','','0','','0','','0','','','','','Composition','11 - Conroe','SAN JACINTO ELEMENTARY SCHOOL (CONROE)','CANEY CREEK HIGH SCHOOL','MOORHEAD JUNIOR HIGH SCHOOL','Supra Keybox','Appraisal','1','Other Style','Live Oaks Estate 04','627','1.8488','Septic Tank','1994','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213193927','1664652993','213193927','2022-10-01T07:58:21.753','90773437','Beverly Smith','Coldwell Banker Realty','','','30.422861','-95.641082','41','77356','13','1399000.00','Active','W Shore','26','Drive','Montgomery','4','1','4','5366','Single-Family','This Beautiful Custom Home on the #5 hole of the Miller Golf Course immediately impresses you with a wall of windows for fabulous views of Lake Conroe in the gated community of Bentwater. Walking into the home through the front door captures the stunning views of the golf course and Lake Conroe. A focal point is a gourmet kitchen including bamboo floors, 6 burner gas cooktop, 2 ovens, warming drawer, 2 dishwashers and 2 stainless sinks with garbage disposals along with enough counter space for great preparatory work. The 2 primary bedrooms on two levels connected by an elevator between all three levels have private balconies, In addition to a guest bedroom on floor 3, there is a downstairs office, TV room or Bunk Bedroom possibility with full bath to accommodate many friends and family to spend the night. Additional extras include an exercise room, library/study, TV room, dry sauna, heated pool with lush landscaping and a 500 square foot primary bedroom closet.','0.377','39','','','Gas Dryer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','3','Lake Conroe Area','Central Electric','1','Bentwater 44, Block 1, Lot 9','In Golf Course Community,On Golf Course,Water View','16424','Appraisal District','','1146','0','','3','Double Oven,Electric Oven','1','Gunite','','Gas Range','','Tile','37 - Montgomery','LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Controlled Access,No Supra Keybox','Seller','3','Mediterranean,Spanish','Bentwater','14748','2.4383','Public Sewer,Public Water,Water District','2000','Seller'); --> New record created successfully